powered by Jive Software

Admin Login Problem


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]


Digvijay Singh


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?


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


Thanks for acknowledging.

Please also suggest something about DDL[/b].


Digvijay Singh


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