[Need Help] zabbix 1.4.5 ubuntu new installation

[chris_ok]

Hi guys,
I've just installed zabbix 1.4.5 on my ubuntu server.
Now I'm having problem the zabbix server cannot start, here's capture from zabbix_server.log :
/usr/sbin/zabbix_server [6112]: Warning: ZABBIX semaphores already exist, trying to recreate.
6112:20080619:184723 Starting zabbix_server. ZABBIX 1.4.5.
6112:20080619:184723 **** Enabled features ****
6112:20080619:184723 SNMP monitoring: YES
6112:20080619:184723 WEB monitoring: YES
6112:20080619:184723 Jabber notifications: NO
6112:20080619:184723 IPv6 support: NO
6112:20080619:184723 **************************
6112:20080619:184723 Failed to connect to database: Error: Access denied for user 'zabbix'@'localhost' (using password: NO) [1045]


please help.....
thanks

[Niels]

Hmm... did you install the database properly? Can you manually log on the database as the DBuser zabbix is using?

[chris_ok]

Hmm... did you install the database properly? Can you manually log on the database as the DBuser zabbix is using?

hi Niels,
thanks 4 reply.
Actually I still new in linux environment I just followed the instruction from http://www.zabbix.com/wiki/doku.php?...:ubuntuinstall.
It's really confusing for me cause sometimes when I check to server status is running and then not again.
so I must to manually start zabbix server and then the server goes up again.
But now even the server is up I still can't get data from host that I've created.

[chris_ok]

I've just find out that my root account is expired.
Is it connected to my zabbix server??

[Niels]

Can you log in to the database as zabbix_user? Can you see the zabbix database?

The root account shouldn't expire, that's probably a Ubuntu-specific "feature".

[chris_ok]

Can you log in to the database as zabbix_user? Can you see the zabbix database?

The root account shouldn't expire, that's probably a Ubuntu-specific "feature".

Yes I'm be able to login to zabbix database using zabbix as user.
I'm gonna try to reinstall my ubuntu server again, cause before I install ubuntu server LAMP that's maybe a problem.

thanks

[xs-]

You probably have a wrong user setup.
log in to your database as root, do the following and copy/paste the output

------------8<---------------------
USE mysql;
SELECT * FROM user WHERE user='zabbix';
SELECT * FROM db WHERE db='zabbix';
------------8<---------------------

Furthermore:
- You are running zabbix and the database on the same server?
- Did you correctly configure the zabbix_server.conf, are you sure?

6112:20080619:184723 Failed to connect to database: Error: Access denied for user 'zabbix'@'localhost' (using password: NO)

Using password: NO <-- hint