powered by Jive Software

Error creating sip acount with postgresql + openfire 3.4.1 + sip pluguin 1.0.0


I get this error when try to create an acount in sip mappings:

2007.11.09 20:55:20

org.jivesoftware.openfire.plugin.sip.create_002dsipark_002dmapping_jsp._jspServi ce(create_002dsipark_002dmapping_jsp.java:171)

java.sql.SQLException: ERROR: column “enabled” is of type integer but expression is of type boolean

at org.jivesoftware.openfire.sip.sipaccount.SipAccountDAO.insert(SipAccountDAO.jav a:133)


org.jivesoftware.openfire.plugin.sip.create_002dsipark_002dmappin g_jsp._jspService(create_002dsipark_002dmapping_jsp.java:163)

I thik is a problem with de database schema for sip.


Hey Josep,

I made a fix to the SIP plugin for this issue. Could you try with the attached version? If that works fine (it should) I will upload a new version of the SIP plugin.


– Gato

Ok, it works.



New version is out. From the plugins page you can update to the new version.

– Gato