Ad Widget

Collapse

New 1.6 install, MySQL connect issues

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Wayne
    Junior Member
    • Oct 2006
    • 27

    #1

    New 1.6 install, MySQL connect issues

    Hello,

    Was happy to see that 1.6 has been released, as I was beginning to move to Nagios for monitoring due to a few recurring issues.

    Today, I installed a fresh copy of 1.6 onto a sandbox server of ours. Everything went as expected, except I am unable to start the zabbix server. I have setup a db for zabbix, imported the initial data of course, assigned a user, and configured this user during setup of the frontend of zabbix.

    From zabbix log:
    Starting zabbix_server. ZABBIX 1.6.
    **** Enabled features ****
    SNMP monitoring: YES
    WEB monitoring: YES
    Jabber notifications: NO
    ODBC: NO
    IPv6 support: NO
    **************************
    Failed to connect to database: Error: Access denied for user 'root'@'localhost' (using password: NO) [1045]

    /conf/zabbix.conf.php does contain proper MySQL connection details to the db with a non-root user. Any idea why the zabbix server would be trying to connect as root@localhost?

    Thanks!

    Edit - Resolved. Was a MySQL configuration issue, entirely unrelated to zabbix.
    Last edited by Wayne; 29-10-2008, 20:20.
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Look at zabbix_server.conf, not zabbix.conf.php!
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • Wayne
      Junior Member
      • Oct 2006
      • 27

      #3
      Yes, sorry I edited the post shortly after making it. The issue was entirely unrelated to Zabbix.

      I also wanted to update the post with that exact information that you posted, in case anyone searched for it. It initially wasn't obvious to me that zabbix_server.conf contained the MySQL connection information for the zabbix_server process, though I figured it out after the fact.

      Also.... I'm amazingly happy with 1.6 and the changes that have been made. It's great so see such progress. I had started to leave zabbix for a Nagios / Cacti setup mainly due to performance, and though I haven't done any benchmarking yet.... I'm seeing much improved performance on the same set of hosts I was monitoring with an older build.

      Comment

      Working...