powered by Jive Software

Postgresql problem

After restarting openfire the server appears to have lost its settings and is giving me the following error in the logs, can somebody tell me how to manually update my database ? (I’m assuming this is a schema issue and I couldnt find any info for postgresql.)

2008.02.12 17:29:40 org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:251)
org.postgresql.util.PSQLException: ERROR: syntax error at or near "TYPE"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl .java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: 1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java :452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2State ment.java:337)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java :329)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Wrapper$$EnhancerByProxool$$95d3a5f4.execute(<generated>)
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:348 )
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:248)
at org.jivesoftware.database.SchemaManager.checkPluginSchema(SchemaManager.java:11 1)
at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java :416)
at org.jivesoftware.openfire.container.PluginManager.access$300(PluginManager.java :46)
at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:1013)
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.02.12 17:29:40 org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java: 418) gateway - Database update failed. Please manually upgrade your database.

Hi Risar,

Did you get this after some Openfire upgrade between versions or a new install?

daryl

I inherited the box, and I’m working on gssapi. I just happened to have run into the error in the course of my testing, it seems to have been non-impacting as the Error is still there even after I figured out the DB issue. (ie postgresql is working now as is openfire but this error is still present)

I have not tested gateway functionality yet but I’m guessing that based on this error it might not be working. I have seen notes regarding how to update oracle but nothing for postgres.