powered by Jive Software

Help to setup openfire and Mysql

Hi everyone ,

I want to setup Openfire and MySQL on Mandriva 2007 follow this tutorial http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html#mysql, but I don’t do it successfully .

Here what i’ve done :

  • Created a database on MySQL , database name is openfire .

openfire_mysql.sql .

  • Imported ``

  • Open Firefox and go to 127.0.0.1:9090 to setup Openfire , and now I have trouble at step 3 : Database Settings

I filled

JDBC Driver Class : com.mysql.jdbc.Driver

DatabaseURL : jdbc:mysql://localhost:3306/openfire

Username and password : blank

Result : “A connection to the database could not be made” .

Here is my error.log

2007.11.28 19:04:17

org.jivesoftware.openfire.container.AdminConsolePlugin.startup(AdminConsolePlugi n.java:137)

Could not start admin conosle server

java.net.BindException: Address already in use

at sun.nio.ch.Net.bind(Native Method)

at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)

at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)

at org.mortbay.jetty.nio.SelectChannelConnector.open(SelectChannelConnector.java:2 11)

at org.mortbay.jetty.nio.SelectChannelConnector.doStart(SelectChannelConnector.jav a:309)

at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)

at org.mortbay.jetty.Server.doStart(Server.java:228)

at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)

at org.jivesoftware.openfire.container.AdminConsolePlugin.startup(AdminConsolePlug in.java:134)

at org.jivesoftware.openfire.container.AdminConsolePlugin.initializePlugin(AdminCo nsolePlugin.java:169)

at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java :436)

at org.jivesoftware.openfire.container.PluginManager.access$300(PluginManager.java :46)

at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:975)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Hi,

is it possible that port 9090 or 9091 are used by an other process?

You may want to create an user with a password to access MySQL, not sure if “” and “” are supported.

LG

hi it2000,

Thanks for your support . Now I can setup openfire, instead of blank username and password, i fill :

username : root

password : blank

And , everything is OK now .

Thanks again .