Jive Messenger 1.1 Problem on Mac OS X/MySQL

Openfire Openfire Support
1

Hi…

Has anyone been successful in running Jive Messenger 1.1 with MySQL on the same Mac OS X Server? We are trying to install Jive Messenger 1.1 on a Mac OS X Server 10.3.5 with MySQL 4.0.20 and Connector-J 3.0.15. The Connector’'s jar file was copied to /Library/Java/Extensions.

We know that the MySQL Jive setup is correct because another server is using the MySQL database running Jive Messenger 1.0.8 without any problem.

When trying to setup the new Jive Messenger 1.1 on the same box as the MySQL Data, we encounter the following during the Datasouce Setting phase - an error occurs

A connection to the database could not be made. View the error message by opening the “[jiveHome]/logs/error.log” log file, then go back to fix the problem.

The error.log shows the following -

org.mortbay.http.HttpContext.handle(HttpContext.java:1757)

at org.mortbay.http.HttpServer.service(HttpServer.java:879)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:197)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)

2004.10.07 15:22 com.jivesoftware.cache.DefaultConnectionProvider.getConnection(DefaultConnection Provider.java:69) Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.

2004.10.07 15:22 com.jivesoftware.cache.DbConnectionManager.getConnection(DbConnectionManager.jav a:92) WARNING: ConnectionManager.getConnection() failed to obtain a connection.

We uses the same connection parameter as the 1.0.8 box, i.e.

com.mysql.jdbc.Driver and

jdbc:mysql://mysql.mydomin.com:3306/jivexmpp

Any help is GREATLY APPRECIATED

Message was edited by: lcsim

Message was edited by: lcsim

2

Hi,

Here are two things to check:

  • Is the jar for your JDBC driver in your classpath?

  • Is there a typo in your JDBC url?

Regards,

Greg

3

Hi…

Under OS X, I think the equivalent of CLASSPATH is by putting the JDBC jar “mysql-connector-java-3.0.15-ga-bin.jar” under /Library/Java/Extensions.

Double checked the URL, it is a direct cut and paste from a the working Jive Messenger 1.0.8.

Please advise…

Thanks!

4

DOH!!! Found the problem, the MySQL is set to denied login from local machine due to some deep wisdom It has been solved. Thanks for your help!