Openfire setup admin password error, database lock wait timeout

Openfire Openfire Support
1

I installed openfire 3.5.2 on FC 6. and trying to set it up using http://localhost:9090. Everything went well until the step of seting admin password. I uses “admin” for old password, and set new password to “welcome123”. The error message asked me to check log. I could not find the log.

After login into Mysql using InnoDB, i see all the tables have been created, but no users in jiveUser table. When I tried to insert the admin user row, lock wait timeout error.

I have tried many times (reinstall openfire ), no luck. Could someone help me?

Thanks very much.

Dave

2

For insert, mysql hangs(lock wait timeout) , so I delete and re-create the following tables. Manually a create admin account in the jiveUser table. But I could not login.

mysql> drop table jiveUser;

Query OK, 0 rows affected (0.01 sec)

mysql> drop table jiveID;

Query OK, 0 rows affected (0.01 sec)

mysql> drop table jiveVersion;

Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE jiveVersion (

-> name VARCHAR(50) NOT NULL,

-> version INTEGER NOT NULL,

-> PRIMARY KEY (name)

-> );

Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE jiveUser (

-> username VARCHAR(64) NOT NULL,

-> plainPassword VARCHAR(32),

-> encryptedPassword VARCHAR(255),

-> name VARCHAR(100),

-> email VARCHAR(100),

-> creationDate CHAR(15) NOT NULL,

-> modificationDate CHAR(15) NOT NULL,

-> PRIMARY KEY (username),

-> INDEX jiveUser_cDate_idx (creationDate)

-> );

Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO jiveUser (username, plainPassword, name, email, creationDate, modificationDate)

->     VALUES ('admin', 'admin', 'Administrator', 'admin@example.com', '0', '0');

Query OK, 1 row affected (0.00 sec)

mysql> CREATE TABLE jiveID (

-> idType INTEGER NOT NULL,

-> id BIGINT NOT NULL,

-> PRIMARY KEY (idType)

-> );

Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO jiveID (idType, id) VALUES (18, 1);

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO jiveID (idType, id) VALUES (19, 1);

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO jiveID (idType, id) VALUES (23, 1);

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> INSERT INTO jiveVersion (name, version) VALUES (‘openfire’, 16);

Query OK, 1 row affected (0.00 sec)

mysql>

mysql>

mysql>

mysql> select * from jiveUser;

*----

*–

+

+

+

+

+–

username

plainPassword

encryptedPassword

name

email

creationDate

modificationDate

*----

*–

+

+

+

+

+–

admin

admin

NULL

Administrator

admin@example.com

0

0

*----

*–

+

+

+

+

+–

1 row in set (0.00 sec)

mysql> commit;

Query OK, 0 rows affected (0.00 sec)

3

I found the following logs on server side:

2008.07.02 14:58:32 org.jivesoftware.openfire.container.AdminConsolePlugin.startup(AdminConsolePlugi n.java:138) 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 05)

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

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

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

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

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

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

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

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

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

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)

2008.07.02 07:04:57 org.jivesoftware.openfire.user.User.setPassword(User.java:187)

org.jivesoftware.openfire.user.UserNotFoundException

at org.jivesoftware.openfire.auth.DefaultAuthProvider.setPassword(DefaultAuthProvi der.java:207)

at org.jivesoftware.openfire.user.User.setPassword(User.java:175)

at org.jivesoftware.openfire.admin.setup.setup_002dadmin_002dsettings_jsp._jspServ ice(setup_002dadmin_002dsettings_jsp.java:131)

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

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

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1093)

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.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)

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

at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)

at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)

at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollect ion.java:206)

at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)

4

Address already in use may be due to “start twice”. After I reboot the machine, same issue.

If I setup openfire manually, what steps should I follow? I tried the following:

  1. edit the openfire.xml

  2. execute the database/openfire_mysql.sql,

But I could not login using admin/admin.

Any help appreciated. Thanks.

Dave