Cannot connect to Mysql

Openfire Openfire Support
1

I have been able to run the post-install script on FC3 (after removing the 3rd ‘‘s’’). I have created the mysql db and granted localhost.localdomain rights to it. When I run the admin setup I cannot connect to the database. I get the following in the error.log

2005.03.14 23:16:20 org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnect ionProvider.java:68) Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.

2005.03.14 23:16:20 org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:279)

java.lang.NullPointerException

at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.j ava:420)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:268)

at org.jivesoftware.messenger.admin.setup_002ddatasource_002dstandard_jsp._jspServ ice(setup_002ddatasource_002dstandard_jsp.java:268)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:816)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:45)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:807)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:807)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:76)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:807)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:488)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

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

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

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

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

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

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

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

Thanks!

2

Any clues?

3

This is a setup problem. Have you tried connecting to the database using the same user and password from the command line? What value are you using in the Database URL? Do you have another exception before the ones you posted?

Regards,

– Gato

4

I didnt receive any issues during install. Here’'s the db URL I entered:

jdbc:mysql://localhost.localdomain:3306/jabberdb

Not sure how to connect via command line (total Mysql noob)

Thanks!

5

jdbc:mysql://localhost.localdomain:3306/jabberdb

Is localhost.localdomain the host name of your PC? Or is it just localhost? Is jabberdb the name of your database?

Not sure how to connect via command line (total Mysql

noob)

If MySQL is in your path then you may try executing

mysql -u -p

then enter the same password that you are using in Messenger and then execute the following command

use

Have you checked if there is another error in the errro.log file before this hour 2005.03.14 23:16:20?

Thanks,

– Gato

6

Ok, I got it to work. This was a mysql issue. It appears that when you install mysql via certain distributions (I am installing on FC3), the mysql databases are not installed initially. Before you can start mysqld, this command needs to be run: mysql_install_db

Once I did that, started mysqld and granted privileges, I was able to get thru the main setup page and connect to the database.

Thanks to all for their help!