ejabberd - Comments for " mod_offline_odbc for MSSQL"

Unable to get offline status of user as the user logs out

rafay — Fri, 27 May 2011 11:26:29 +0000

Hi,
I successfully ran the provided SQL Script on my MSSQL Server 2008 and prepared a one to one chat module.
As the user logs in i am getting RosterUser data properly and online status also properly if anyone is logged in.
But when someone logs out I am unable to get the "unavailable" status fired so that i can make the appropriate user in my roster inactive.

The version of ejabbered i have installed is 2.1.6.

Thanks
Rafay.

Check the section about

sander — Thu, 11 Jan 2007 16:22:23 +0000

Check the section about Microsoft SQL Server in the guide.

--
sander

Integarted MSSQL with ejabberd

praj — Tue, 09 Jan 2007 09:08:09 +0000

Hello
i got success in integrating SQL Server and ejabberd and jwchat. And chat is working properly
But i m not getting the offline messege

Also the Group Chat is not working. When i invite people to join it gives Error Popup This pop Up also comes when i type something in the groupchat window and sent it

Can anybody help me out
Waiting for the reply

Thanks ,
Praj

SQL Server integration with ejabbered 1.1.2

praj — Mon, 08 Jan 2007 12:29:27 +0000

I want to integrate the ejabbered 1.1.2 with SQL Server 2005
Can you give me guides for this
waiting for your reply .

Thanks In advance
Praj

tiaan wrote:

Thank you.

I've managed to get all the ODBC modules to work with MSSQL. We are currently testing. Please shout if anyone want the MSSQL version.

I've noticed that most of the sql in these modules first delete and then insert. Is there a reason for this, why not a update statement ?

Tiaan

Re

praj — Mon, 08 Jan 2007 07:51:38 +0000

i want to integrate ejabbered with MSSQL .
For this i read link "http://www.ejabberd.im/mssql" In this one script file is not available "http://www.ejabberd.im/files/contributions/mssql.sql" .
I want to use this for jwchat for making chat application with ejabbered and MSSQL Server
Also can i do this with my user table instead of creating new one

Thanks in Advanced
Praj

sander wrote:

Do you know about the contributed MSSQL patch?

--
sander

Do you know about the

sander — Wed, 29 Mar 2006 16:28:39 +0000

Do you know about the contributed MSSQL patch?

--
sander

I also stuck with MSSQL

adarsh — Wed, 29 Mar 2006 15:06:21 +0000

I have installed ejabberd on windows 2000 box. I wanted to get it to work with MSSQL. But no luck ... I tried compiling it from sources and followed all the instruction on but all i get are errors... can somebody help me setup ejabberd with MSSQL.
Thanks and regards,
Adarsh

Would appreciate MSSQL info

mcannon — Thu, 26 Jan 2006 19:21:55 +0000

I have ejabberd running on Windows 2003 server but would like to change the authentication method to MSSQL. Maybe down the road look to store data in MSSQL as well.

Can anyone provide steps to accomplish this or point me in the right direction? I have been trying unsuccessfully to get it to work.

Thanks for any help...

Mike

Bug fixed

tiaan — Fri, 14 Oct 2005 20:42:49 +0000

There was an bug in this module, the fixed version is on SVN.

Same for Postgres database

tiaan@ejabberd.jabber.ru — Tue, 11 Oct 2005 18:11:19 +0000

It seems like the same situation occurs with a Postgres database. I've posted a question in the configuration section.

Talked to early

tiaan — Fri, 07 Oct 2005 15:08:02 +0000

I talked to early, it's not working correctly.

The presence does not automatically get send when a user logs on, but if I do a "send presence" in the client, the presence packet does get sent, and the client show the user as online.

I've started debugging, but I'm stuck at the moment. The following functions get called, when a user logs on. But the "in_subscription" "out_subscription" never gets called, am I correct in thinking they must get called ? From where do they get called ?

- New Online -
get_subscription_lists
fill_subscription_lists
process_iq
process_local_iq
process_iq_get
raw_to_record
item_to_xml

Any help would be appreciated.

Thanks
Tiaan

ODBC Modules for MSSQL

tiaan — Thu, 29 Sep 2005 20:07:15 +0000

Thank you.

I've managed to get all the ODBC modules to work with MSSQL. We are currently testing. Please shout if anyone want the MSSQL version.

I've noticed that most of the sql in these modules first delete and then insert. Is there a reason for this, why not a update statement ?

Tiaan

It is the "anonymous or

sander — Wed, 28 Sep 2005 18:29:49 +0000

It is the "anonymous or don't care variable". From page 25 at the bottom of Concurrent Programming in Erlang, Part I.

--
sander

MSSQL driver returns number of records affected

tiaan — Wed, 28 Sep 2005 15:32:07 +0000

No, I did however found the issue, I think.

The code works because the Postgres driver does not return the count of records deleted. Therefore "{updated, undefined}" returns true, but the MSSQL driver does return the number of records deleted. The return value of MSSQL is {updated, } ,

See changes I made to the case statement below, is this correct ?
What does the "_" in "{updated, _}" do / mean ?

-- Current Code --

case ejabberd_odbc:sql_query(
    LServer,
    ["begin;"
     "select * from spool where username='", EUser, "';"
     "delete from spool where username='", EUser, "';"
     "commit"]) of
 [{updated, undefined},
  {selected, ["username","xml"], Rs},
  {updated, _},
  {updated, undefined}] ->

-- Changed Code --

[{selected, ["username","xml"], Rs},
 {updated, _}] ->

Thanks
Tiaan

Does any error appear on the log?

mfoss — Wed, 28 Sep 2005 14:31:07 +0000

Does any error, or warning, or any strange message appear on the ejabberd logfile when a user with offline messages logins?