powered by Jive Software

Asterisk IM and asteriskwin32

I enabled the asterisk-IM of openfire and I connected it to asteriskwin32. After I created, I didn’t see the server in the table ( in asterisk-im page )

Why ?

This is the message from openfire

Sep 20, 2008 1:16:36 AM org.asteriskjava.manager.internal.ManagerConnectionImpl connect
INFO: Connecting to 192.168.1.101:5038
Sep 20, 2008 1:16:37 AM org.asteriskjava.manager.internal.ManagerConnectionImpl setProtocolIdentifier
INFO: Connected via Asterisk Call Manager/1.0
Sep 20, 2008 1:16:37 AM org.asteriskjava.manager.internal.ManagerConnectionImpl doLogin
INFO: Successfully logged in
Sep 20, 2008 1:16:37 AM org.asteriskjava.manager.internal.ManagerConnectionImpl doLogin
INFO: Determined Asterisk version: Asterisk 1.2
Sep 20, 2008 1:16:37 AM org.asteriskjava.live.internal.AsteriskServerImpl initializeIfNeeded
INFO: Initializing done

Hi,

Even I am using the same setup and same error is been popuped up in my openfire error logs, did you get any solution for this if so please forward the solution to me also… either u can post it here so in future others can get benifited, else u can also send me the private message also.

Thank you in advance.

If you are using the embedded (HSQL) database then the tables are not created correctly.

Modify /plugins/asterisk-im/database/asterisk-im_hsqldb.sql to read as below, restart openfire and try to add a server again - hopefully it will work for you.

create table phoneServer (

serverID bigint not null,

serverName varchar(255) not null,

hostname varchar(255) not null,

port integer not null,

username varchar(255) not null,

password varchar(255) not null,

constraint phoneServer_pk primary key(serverID)

);

create table phoneDevice (

deviceID bigint not null,

device varchar(255) not null,

extension varchar(255) not null,

callerID varchar(255),

isPrimary integer not null,

userID integer,

serverID bigint not null,

constraint phoneDevice_pk primary key (deviceID)

);

create table phoneUser (

userID bigint not null,

username varchar(255) not null,

constraint phoneUser_pk primary key (userID)

);

create unique index phoneUser_username_idx on phoneUser(username);

INSERT INTO jiveVersion (name, version) VALUES (‘asterisk-im’, 2);