Openfire 3.4.5 + Embedded DB + Asterisk-IM 1.4.0 doesn't work

try to run with above combination, but the asterisk-im plugins seems like not working.

I enable Asterisk-IM, then input the server configuration, Then click Create server.

I got successful response, but the server is not added into the server list table on general settings.

But, from asterisk console, I can see the manager is logged in.

Just like to know if anybody have a success setup with these combination?



I am also having this problem, This looked like it was going to do what I need,

I am going to look at getting asterisk to send the information to openfire as I know asterisk supports sending information (i think)

If anyone has a fix for this, this would be great.

Many Thank



Fix can be found here:


Did that work well? If yes I’ll integrate it into 1.4.1.

Thanks, It is hsql table creation problem. I try to create the tables manually, and had to remove the ‘unique’ from one of the table. But, then have a little problem when trying to run the hsql toosl/viewer.

now, I switch to postgresql, so far, it installed fine.


It would be cool if someone using the embedded db could test the script attached to the bug report and either confirm it is working or provide an fix that actually works.

Then I could provide a working version later on.



I think if you remove ‘unique’ from following line

serverName varchar(255) not null unique,

It should allow the plugins to at least create the tables and allow us to insert the server info,

Seems like hsqldb doesn’t recognize that’unique’ keyword. I also see, this ‘unique’ keyword are being remove from the other 2 tables. Where the specs for other db, all three table have a unique constraint.

I don’t know if I have the exact same problem as the OP, but I have the same configuration (openfire 3.4.5, embedded-db, asterisk-im 1.4) and I am unable to add a server to the Asterisk-IM plugin page.

On the Asterisk-IM tab, I click the Add Server link, fill in the correct data, press the Create Server button, and then nothing happens.

In the Info log I see this:

2008.04.23 14:55:52 Found old database version 0 for asterisk-im. Upgrading to version 2…

2008.04.23 14:55:52 Initializing phone plugin

2008.04.23 14:55:52 Initializing Asterisk Manager connection

2008.04.23 14:55:52 Started server (unencrypted) socket on port: 5269

2008.04.23 14:55:52 Started plain (unencrypted) socket on port: 5222

2008.04.23 14:55:52 Started SSL (encrypted) socket on port: 5223

2008.04.23 14:56:12 Connecting to

2008.04.23 14:56:13 Connected via Asterisk Call Manager/1.0

2008.04.23 14:56:13 Successfully logged in

In the Warn log I see this:

2008.04.23 14:55:18 EXCEPTION


In the Error log I see this:

2008.04.23 14:56:12

Table not found in statement [INSERT INTO phoneServer (serverID,

serverName, hostname, port, username, password) VALUES (?, ?, ?, ?, ?,



Table not found in statement [INSERT INTO phoneServer (serverID,

serverName, hostname, port, username, password) VALUES (?, ?, ?, ?, ?,


On on the Asterisk server console I see:

== Parsing ‘/etc/asterisk/manager.conf’: Found

== Manager ‘openfire’ logged on from

Can someone please help?

I’ve got the same problem as Sarkoon here. Same config except that I’m using MySQL insted of the embedded db.

When adding my Asterisk-server in the admin interface, nothing happens. And if I reload the main page of the plugin, the server isn’t online. But the asterisk-console tells me that the user openfire has logged in.

Very confusing and perhaps this should be lifted to another thread?



Edit: Realised that I’ve installed 3.5.1 and well, just ignore this post, I’ll post another one.

I’m using OpenFire 3.5.1. The fix mentioned does not work, or at least I can’t get it to “stick”.

I modify the file in question (in my case, /opt/openfire/plugins/asterisk-im/database/asterisk-im_hsqldb.sql) but when i restart the plugin somehow the whole “database” directory is erased, and new files are pulled in from somewhere (svn?) which over-writes my changes.

This pretty much means that the Asterisk-IM plugin is dead in the water for most people experimenting with the system, since I would expect most people will try with the embedded database first before bothering to set up a DB server for their XMPP implementation. I’d love to see this working again - anyone have any hints on this thread?