Admin Login Problem

Openfire Openfire Dev
1

Hi

I am facing problem, after installing i get admin Window but after that I am not able to logging in and I am getting this partcular error.I tried a lot but couldnot overcome with solution.

org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:275) Database upgrade failed. Please manually upgrade your database.[/b]

java.sql.SQLException: Duplicate column name ‘‘lockedDate’’

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)

at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2248)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2196)

at com.mysql.jdbc.Statement.execute(Statement.java:906)

at org.jivesoftware.database.DbConnectionManager.upgradeDatabase(DbConnectionManag er.java:670)

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

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:89)

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:269)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)

at org.jivesoftware.util.JiveProperties.(XMPPServer.java:117)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Please help me I am in trouble. Looking forward for your ASAP reply.[/b]

Regards

Digvijay Singh

2

Hi,

which Wifi version are you using? 2.6.2 or 3.0a (nightly build)?

Did you run the DDL script which came with the Wifi version you are using?

What are the values of the JIVEVERSION table?

LG

3

I am Using Jive Messenger 2.1.3[/b]

These are the values of Jive VersionTable

INSERT INTO jiveVersion (majorVersion, minorVersion) VALUES (2, 1);

/* Entry for admin user */

INSERT INTO jiveUser (username, password, name, email, creationDate, modificationDate)

VALUES (''admin'', ''admin'', ''Administrator'', ''admin@example.com'', ''0'', ''0''); /b
4

Hi

Thanks for acknowledging.

Please also suggest something about DDL[/b].

Regards

Digvijay Singh

5

Hi

Please suggest possible solution. I am not able to login to admin[/b] by using . Above mentioned are the requirement which you asked.

Thanks in advance

Digvijay