zabbix won't start after installing

[gregtompkins2]

Hi All,

I installed zabbix on my OpenSuSe 11.4 through Software Manager. I also ran the sql scripts manually since it looks like the Software Manager didn't do that step.

I am getting this error after trying to launch ./zabbix-server start as root from /etc/rc.d

If I go to the zabbix-server.log in /var/log/zabbix I see this:

33781:20110917:011017.653 Starting Zabbix Server. Zabbix 1.8.7 (revision 21394)
.
33781:20110917:011017.654 ****** Enabled features ******
33781:20110917:011017.654 SNMP monitoring: YES
33781:20110917:011017.654 IPMI monitoring: YES
33781:20110917:011017.654 WEB monitoring: YES
33781:20110917:011017.654 Jabber notifications: YES
33781:20110917:011017.654 Ez Texting notifications: YES
33781:20110917:011017.654 ODBC: NO
33781:20110917:011017.654 SSH2 support: YES
33781:20110917:011017.654 IPv6 support: NO
33781:20110917:011017.654 ******************************
33781:20110917:011017.662 [Z3001] connection to database 'zabbix' failed: [2002
] Can't connect to local MySQL server through socket '/var/lib/mysql' (13)
33781:20110917:011017.662 Cannot connect to the database. Exiting...
48896:20110919:012119.762 Starting Zabbix Server. Zabbix 1.8.7 (revision 21394)

I already made sure the user 'zabbix' password 'zabbix' exists in mysql so I am at a loss as to what I did wrong here.

Any ideas?

Thanks!

[Colttt]

can you connect manualy to the mysql-db with zabbix account??

mysql -u zabbix -p PASSWORD 
use zabbix

[gregtompkins2]

yes, i can connect manually using the root as well as the 'zabbix' user i created. i can also connect using the zabbix user in phpMyAdmin and it looks like the permissions are set up equivalent to root.

is there somewhere else i can go to get more detail about what is hanging it up?

thank you!

[Colttt]

yes you can set up the verbose-level..

line ~85

DebugLevel=4

[gregtompkins2]

i set the debug level to 4 but still the same thing in the log

more zabbix-server.log
46430:20110922:010840.492 Starting Zabbix Server. Zabbix 1.8.7 (revision 21394)
.
46430:20110922:010840.492 ****** Enabled features ******
46430:20110922:010840.492 SNMP monitoring: YES
46430:20110922:010840.492 IPMI monitoring: YES
46430:20110922:010840.492 WEB monitoring: YES
46430:20110922:010840.492 Jabber notifications: YES
46430:20110922:010840.492 Ez Texting notifications: YES
46430:20110922:010840.492 ODBC: NO
46430:20110922:010840.492 SSH2 support: YES
46430:20110922:010840.493 IPv6 support: NO
46430:20110922:010840.493 ******************************
46430:20110922:010840.493 In DBconnect() flag:1
46430:20110922:010840.497 [Z3001] connection to database 'zabbix' failed: [2002
] Can't connect to local MySQL server through socket '/var/lib/mysql' (13)
46430:20110922:010840.497 Cannot connect to the database. Exiting...

is there any way to check the mysql log to see why it cannot connect through that /var/log/mysql socket?

Thanks!

[Colttt]

ok..

can you please post you zabbix_server.conf? the last 30lines

[0siris]

ok..
can you please post you zabbix_server.conf? the last 30lines

Or please post the complete config, but just the lines that don't start with a '#':

grep -v ^\# zabbix_server.conf

[badener]

you could also check with
mysql_config --socket
whether your mysql installation actually uses /var/lib/mysql as socket.
If it doesn't change parameter DBSocket in zabbix_server.conf to the socket used.