Ad Widget

Collapse

Problems to change the database server of zabbix

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • huri.filho
    Junior Member
    • Jul 2007
    • 2

    #1

    Problems to change the database server of zabbix

    I have the zabbix monitoring tool, running in a server, from six months ago, with the mysql database in the same server. But now I need to change the database to our exclusive database server. I tried to do the same steps of a database recovery, but when I start the zabbix service, I only can see history, but no new data can be stored, and the words "no data" appear in the place of "Last data".
    The most important thing, was the change of the database server from a localhost server to a remote server.
    Something like this occured to someone?
    My steps:
    1 - Recovery of the database backup in the new server
    2 - Put the privileges on the database to zabbix@ipofzabbixserver
    3 - Changed the config file of zabbix database(zabbix.conf.php), to the new data(ip, user,port,..)
    4 - Started the zabbix service.

    What can be wrong?
    Is there any other place to change the ip of the database server?
    Last edited by huri.filho; 16-10-2007, 21:25.
  • Calimero
    Senior Member
    • Nov 2006
    • 481

    #2
    What if you run zabbix_server with debug level logging ?
    Any errors ?

    What if you connect to the remote MySQL server (using the 'mysql' client or with a simple php script) and you try to update/insert new records ?

    Comment

    Working...