zabbix_server won't start

[tx4real]

Greetings:

I'm attempting to start 'zabbix_server', but I keep getting the
following error in '/tmp/zabbix_server.log'.

Failed to connect to database: Error : Access denied for
user 'root'@'localhost' ( using password: NO).

I was under the assumption ... that I would be logging into the database
as 'zabbix' not 'root'.

Any help will be greatly appreciated.


Thanks,



JZB

[cameronsto]

Sounds like you haven't defined your database settings properly in the zabbix_server.conf file.

-cameron

[tx4real]

Re:

Oops !
Thanks for the correction on the zabbix_server.conf file.

OK, so I updated the correct DBuser=zabbix and I
entered the correct DBuser password.

When I attempt to start zabbix now, I get the error:

Access denied for user 'zabbix'@'frodo.tx.us' ( using password: YES)

Any suggestions to solve the problem will be appreciated.

[cameronsto]

Have you setup your 'zabbix' database user properly? Follow the guidelines here to make sure it has the proper access to your zabbix database.

-cameron

[tx4real]

Re:

I can login just fine from the command line to mysql as the
'zabbix' user.

[elkor]

you need to edit the zabbixwebroot/include/db.inc.php file to specify the zabbix user and password for database connectivity. the default user is zabbix but there is no default password.

just guessing but this may be the cause of your problem

edit:

oh, sorry didn't see you were talking about the zabbix_server binary and not the frontend.
mysql has support for a user@hostname login, could you possibly be connecting from @localhost on the command line but @hostname when the zabbix_server tries to connect?