Skip to main content

Jabber, Anyone?

Posted by dozment on Tue, 09/23/2008

Has anyone tried integrating a jabber server like Openfire with Thirdlane?


Submitted by dozment on Tue, 09/23/2008 Permalink

Ok, this is kind of cool. I've got OpenFire installed on my MTE server, and I'm using Spark IM on my desktop and BeejiveIM on my Blackberry. Both connect to OpenFire, and I can use them for private label instant messaging.

Also, from both clients I am able to see presence from Asterisk. I wonder if this could possibly be a poor man's operator panel.

Submitted by mattdarnell on Tue, 09/23/2008 Permalink

I would love this. If the phone presence could be shown in jabra that would be excellent. I have been waiting for Druid to make this happen....Ming always says they are almost there.

Have you started working on this? Is this something you would like to work on jointly?

I wonder what effect Cisco buying Jabber will have....

-Matt

Submitted by mattdarnell on Tue, 09/23/2008 Permalink

I want a demo!

How hard was it to set up....how does the OpenFire get the phone status?

-Matt

Submitted by eeman on Tue, 09/23/2008 Permalink

Ive used it. its a good proof of concept. Presence is disappointing due to only showing you a phone presence when the user is logged into jabber. So if you forgot to log into jabber, it wont show you if you are on the phone or not. The jabber server itself is being evaluated for other similar applications since it encrypts the data and gets around NAT. However, cisco just bought jabber. Who knows what anti-competitive crap they might pull.

Submitted by dozment on Tue, 09/23/2008 Permalink

I didn't actually use Jabber. I used OpenFire and it's AsteriskIM plugin for the server, Spark for my PC client and BeejiveIM for my Blackberry. They haven't been assimilated by the Borg as of yet. Eric, I think you are saying the viewer's client has to be logged in to view presence, and not that the client has to be logged in to report presence. Right?

In that case it's not that different from having FOP or iSymphony running. If they aren't running you won't see presence. It doesn't have all of the features of Flash Operator Panel or iSymphony (ie, no dragging and dropping calls). But, I have a client who is looking to have admin staff know when the people they support are on the phone. This may be perfect for them.

The install wasn't bad. There is an option to use a built in database or MySQL. I first choose the built in to make the install quicker. But, the AsteriskIM presence table isn't part of the built in database. So, I installed it using MySQL. There was one other issue with the MySQL database script that I had to correct. I added (1024) to thie jid index statement on this query.

CREATE TABLE ofRoster (

rosterID BIGINT NOT NULL,

username VARCHAR(64) NOT NULL,

jid VARCHAR(1024) NOT NULL,

sub TINYINT NOT NULL,

ask TINYINT NOT NULL,

recv TINYINT NOT NULL,

nick VARCHAR(255),

PRIMARY KEY (rosterID),

INDEX ofRoster_unameid_idx (username),

INDEX ofRoster_jid_idx (jid(1024))

);

Submitted by dozment on Wed, 09/24/2008 Permalink

Yeah, you're right. I realized that not long after my last post. Both sides have to be logged in for it to work. I think it's still worth a try, though. We just have to have them autostart Spark. I wonder how difficult it would be to create a "client" that would run on the server and keep multiple jabber users logged into the server (at least as far as the server is concerned).