Jive Messenger not starting up...mysql access error

Openfire Openfire Support
1

more error.log

2005.04.05 16:11:59 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:107)] Failed to create new connections on startup. Attempt 0 of 3

java.sql.SQLException: Access denied for user ‘‘root’’@’‘localhost.localdomain’’ (using password: YES)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:753)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3562)

2

This is a mysql permissions problem. You need to grant localhost access to connect to the database. Please consult the mysql documentation.

Regards,

Matt

3

I can login locally to the mysql server using the login id and password listed in…

/opt/jive/messenger/conf/jive-messenger.xml

here is how jive connects…

.com.mysql.jdbc

jdbc:mysql://localhost:3306/jive

it was working before,…but i think my mysql login permissions rules may have changed…

4

Mysql will accept connections on a unix socket (/tmp/mysql.sock or somesuch) and also on an tcp socket (localhost:3306) if you are trying to connect using the mysql command line interface then you are most lilkely connecting to the unix socket and not really testing the acls used by jive.

Try this one to force the command line interface to connect to the tcp socket.

mysql -h 127.0.0.1 -u $JIVE-USER -p

and see what that gets you.

You may need to adjust your GRANT statement to indicate the correct source host (’’$JIVE-USER’’@’‘localhost’’)

Message was edited by:

retheisen

adjusted line breaks