Installing in FreeBSD with Postgresql?

[francisco07]

Anyone has gotten Zabbix to work in FreeBSD with Postgresql?

Installed Zabbix from ports and selected Postgresql
(the port has option for mysql or postgresql).

Made zabbix DB and populated with the schema from the "postgresql"
directory in the Zabbix tree.

Edited /usr/local/etc/zabbix/zabbix_server.conf to point
to the proper DB, however don't see a way to tell it that
it will be connecting to a Postgresql database. I see a note
on the bottom about msyql socket.. so I am wondering if it
is trying to connect to a mysql DB.

I configure a virtual host in apache for the web interface.
Changed zabbix/php/include/db.inc.php to indicate I am using
postgresql.

When I try to login with "Admin" it shows:
[ERROR:Login name or password is incorrect]

Looked at the apache logs for any errors, and there were none.

Am I missing any steps besides editing zabbix/php/include/db.inc.php and /usr/local/etc/zabbix/zabbix_server.conf?

Any help would be greatly appreciated.

[James Wells]

Greetings,

Made zabbix DB and populated with the schema from the "postgresql" directory in the Zabbix tree.

Once, you create the schema, you need to go up one directory and load the initial data/data.sql. This file provides the Admin and guest users as well as basic sample templates and items. Additionally, it adds the integrated help data.

Edited /usr/local/etc/zabbix/zabbix_server.conf to point
to the proper DB, however don't see a way to tell it that
it will be connecting to a Postgresql database. I see a note
on the bottom about msyql socket.. so I am wondering if it
is trying to connect to a mysql DB.

The entry at the bottom is legacy and can be ignored. Anyway, the basic DB configuration is in the configuration file, but you define the DB type at compile time only.

Looked at the apache logs for any errors, and there were none.

By default, you will get no errors posted to the Apache log unless you configure your Apache PHP module to post errors. Additionally, from what you have described so far, there would be no error generated as the user simply was not in the DB.

[francisco07]

Got the web interface to work.
Thanks!

Does the default Unix_t template is enough to get started with FreeBSD or is that mostly a Linux setup?

Althoug I am still just going over the docs, so far don't see like the machine is getting monitored properly. In "Monitoring-> Latest Data" the last time monitored was last night at midnight.

Will continue reading.. perhaps I am missing something.

[tronite]

Got the web interface to work.
Thanks!

Does the default Unix_t template is enough to get started with FreeBSD or is that mostly a Linux setup?

Althoug I am still just going over the docs, so far don't see like the machine is getting monitored properly. In "Monitoring-> Latest Data" the last time monitored was last night at midnight.

Will continue reading.. perhaps I am missing something.

I suppose after this long you must have an update?