Using your own SQL database with Zabbix

[maplesyrupghost]

Hey!

So basically, we are setting up a new Zabbix 2.0.2 installation, our test installation has been a raging success, and now we going to implement it pointed at our own database server.

We created a VM, installed Zabbix using the Preloaded ISO file, everything installs correctly and it is functional.

We dumped the existing database and imported it to the new database exactly as it is, and changed the "/etc/zabbix_server.conf" to have DBHost, DBName, DBUser, and DBPassword to have the correct values for the server.

Restarting the box, it doesn't work. The web interface errors with "mysql_connect(): [2002] No such file or directory (trying to connect via unix:///var/run/mysql/mysql.sock) [include/db.inc.php:77]"

Although I can open the database tables from that server, it has the permissions to access it.

[dougbee]

You also need to modify the zabbix_conf.php, which should be under zabbix/www/conf ..

[maplesyrupghost]

You also need to modify the zabbix_conf.php, which should be under zabbix/www/conf ..

Thanks for the quick reply! I.. can't find that file (I used find /* | grep "zabbix_conf.php" and nothing shows up. Searching for "www" I see..

/srv/www
/srv/www/cgi-bin
/srv/www/htdocs
/usr/share/groff/1.21/tmac/www.tmac
/usr/share/man/man7/groff_www.7.gz
/var/lib/wwwrun

But there are no files in those directories?


edit: oh but searching for ".php" I found a boat load of files. I see "/usr/share/zabbix/conf/zabbix.conf.php" , that sounds pretty tasty! I shall investigate.

[dougbee]

Oops, it's zabbix.conf.php .. which I see you've found!

[maplesyrupghost]

Oops, it's zabbix.conf.php .. which I see you've found!

Dude thank you so much! You saved the day, I owe you a coke!

Everything works, yay!!