sebbix_server cant reconnet to mysql ...

[tnt]

hi,
i have zabbix on one pc and mysql on another pc.
when i restart mysql, zabbix_server exiting with messages in log:

Connection to database 'XXXX' failed: [2003] Can't connect to MySQL server on 'IP_ADDRESS' (111)
20458:20090305:104708 One child process died. Exiting ...

after restart mysql i can connect to mysql from zabbis_server PC with:

 mysql -hIP -uUSER -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

zabbix 1.6.2 from source

can anyone help me please ?
thanks.

[Calimero]

What DB* parameters do you use in zabbix_server.conf ?

[tnt]

hi,

What DB* parameters do you use in zabbix_server.conf ?

cat zabbix_server.conf  | grep DB

DBHost=IP_address
# SQLite3 note: path to database file must be provided. DBUser and DBPassword are ignored.
DBName=db_name
DBUser=db_user
DBPassword=db_password
#DBSocket=/tmp/mysql.sock

hmm why zabbix_server dont reconnect?
i read about this problem in forum, but this was in version about 1.1

[Calimero]

Sorry I missed the fact that you restarted mysql in your first post.

As far as I know, zabbix doesn't reconnect on database failure. There's a topic regarding zabbix_server' behaviour when "panicking"/crashing:

http://www.zabbix.com/forum/showthread.php?t=11399

[nelsonab]

Reconnect on DB failure/restore should be expected behavior. Is there a bug for this?

[Calimero]

Reconnect on DB failure/restore should be expected behavior. Is there a bug for this?

I don't know. See support.zabbix.com.

As far as I know, the rationale behind this is that you should use an external system (shell script, heartbeat, ...) to check whether zabbix_server is running and respawning it if it's not.