Skip navigation
Up to Discussions in Asterisk-IM Support
13840 Views 6 Replies Latest reply: Sep 7, 2008 1:21 AM by jonie_e2000 RSS
Bronze
mimmo
9 posts since
Aug 27, 2007
Currently Being Moderated

Aug 29, 2007 4:34 AM

Asterisk-IM configuration

 

Hi to all... I've a problem with Asterisk-IM configuration.

 

 

On my LAN i've two PC: one with Asterisk 1.4.9 on Debian Etch (192.168.0.4); other of these with openfire 3.3.2 on WinXP (192.168.0.2; database embedded).

 

 

Now, i'd run integration through Astererisk-IM, but it doesn't work.

 

 

When openfire start, i've message in openfire console:

 

 

Missing database schema for asterisk-im. Attempting to install...

asterisk-im - Database update failed. Please manually upgrade your database.

 

 

What means??

 

 

And then, when i try to add server in asterisk-IM tab, it says "Server created successfully"... but it isn't true:

 

 

in the next screen message is always "No Servers Configured". WHY??? Help me!

 

 

and i've another message:

 

 

29-ago-2007 13.18.49 org.asteriskjava.util.internal.JavaLoggingLog info

INFO: Connecting to 192.168.0.4:5038

29-ago-2007 13.18.49 org.asteriskjava.util.internal.JavaLoggingLog info

INFO: Connected via Asterisk Call Manager/1.0

29-ago-2007 13.18.49 org.asteriskjava.util.internal.JavaLoggingLog info

INFO: Successfully logged in

29-ago-2007 13.18.49 org.asteriskjava.util.internal.JavaLoggingLog info

INFO: Determined Asterisk version: Asterisk 1.2

29-ago-2007 13.18.49 org.asteriskjava.util.internal.JavaLoggingLog info

INFO: Initializing done

 

 

My manager.conf is:

 

 

Asterisk-IM configuration

 

 

secret=admin

 

 

permit=192.168.0.2/255.255.255.0

 

 

read =.......all.......

 

 

write = .......all...........

 

 

Thank you!

 

 

 

 

 

Tags: asterisk-im, openfire, asterisk, voip
  • Bronze
    Chris Stone
    2 posts since
    Sep 1, 2007
    Currently Being Moderated
    Sep 1, 2007 12:03 PM (in response to mimmo)
    Re: Asterisk-IM configuration

     

    Hello,

     

     

    I'm very new to this but I found that 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.

     

     

    C.

     

     

     

     

     

    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);

     

     

     

     

More Like This

  • Retrieving data ...

Incoming Links

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points