Can''t login to Database Mysql 4.1.19 in Fedora Core4

Openfire Openfire Support
1

Hi guys,

I’‘ve installed wildfire 3 in my Fedora Core 4 box, I did the creation og database in mysql. But when it comes to me setting up my database setting, I can’'t seem to connect to my database.

Here is my database url - jdbc:mysql://localhost:3306/wildfire

any help would be much appreciated. Thanks! Mark

Here is the error log:

java.lang.NullPointerException

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

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

at org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:194)

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

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

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

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

at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

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

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

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

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

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

at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2006.07.06 11:23:00 org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager. java:92) WARNING: ConnectionManager.getConnection() failed to obtain a connection.

2

I don’'t really understand your errorlog but in general:

did you grant whatever user you’'re using access to the database? Something like:

grant all privileges on wildfire.* to the_admin@localhost identified by ''the_admin_password;

Make sure you don’'t use root or the root password…

After setting things up try to connect to the database with the mysql client. If you can’'t connect then reload the grant tables.

Do you run a firewall? If so allow all incoming and outgoing traffic to see if you can connect properly. This is acceptable for a short test to see if it will connect, but you shouldn’'t allow this situation for more then a few minutes.

3

Thanks for the reply sir.

Do you mean I must create a new user in my linux box? I logged in as root and used root as the username to connect to mysql.

I can connect to mysql using the “mysql -u root” command.

I’'ve checked the database mysql and table user and it has host=localhost, user=root and password=""

I’'ve managed to install it in my WinXP box but unsuccessful with my Linux one.

4

No, what you need to do is to create a new user for mysql. This user is not related to any linux user.

The easiest way to do this:

logon to mysql:

mysql -u root -p

use wildfire

grant all privileges on wildfire.* to the_admin@localhost identified by ''the_admin_password;

You need to replace the_admin with a self choosen username and the_admin_password with a self choosen password.

I hope you did set a password for root, otherwise you will need to do that. Explaining that would be beyond the scope of this forum, so I’'d like to suggest that you look at the manual at http://www.mysql.com for further details.