[SR-Users] IMC module doesn't save data to mysql database

[Ozren Lapcevic]

Hi all,

I'm trying to configure IMC module and get it to work properly but I've run
into problems with saving IMC module data to mysql database.

I'm using following code provided in IMC module documentation:

modparam("imc", "db_url", DBURL)

## route block ###
        if(is_method("MESSAGE") && (uri=~ "sip:chat-[0-9]+@") || (uri=~
"sip:chat-manager@")) {
                xlog("L_INFO", "going to imc: F [$fu] T [$tu] B [$rb]\n");

                if(imc_manager())
                        sl_send_reply("200", "ok - imc_manager()");
                else
                        sl_send_reply("500", "command error");
        exit;
        }

I am creating chat room with following message sent to chat-manager at abc.hr:
"#create chat-111"

DEBUG log returns following:
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
INFO: <script>: going to imc: F [sip:oz at abc.hr] T [sip:chat-manager at abc.hr]
B [#create chat-111]
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc.c:525]: found command
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_cmd.c:146]: command: [create]
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_cmd.c:151]: parameter 0=[chat-111]
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_cmd.c:171]: new room [chat-111]
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_cmd.c:186]: added room uri= sip:chat-111 at abc.hr
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_mng.c:322]: [uri]= sip:oz at abc.hr
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_mng.c:326]: [user]= oz
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_cmd.c:196]: added the owner as the first member [
sip:oz at abc.hr]

"./kamctl fifo imc_list_rooms" returns following:
ROOM::  URI=sip:chat-111 at abc.hr MEMBERS=0 OWNER=sip:oz at abc.hr

"./kamctl fifo imc_list_members sip:chat-111 at abc.hr" returns following:
ROOM:: sip:chat-111 at abc.hr NR_OF_MEMBERS=1
        MEMBER:: sip:oz at abc.hr

However, that data is not persisted/saved in the imc_rooms and imc_members
tables in the database. Any clues what might be the problem here?

Any help is greatly appreciated.

Best regards,
Ozren Lapcevic

PS
I'm runing Kamailio 3.1.4 with default cfg file with enabled mysql,
multidomain, usrlocdb, auth and NAT. I can register clients, establish
calls, send IMs, etc. imc_rooms and imc_members tables were created when
kamailio was installed. I've also checked imc-create.sql script and tables
are correctly created.

The same DBURL used for imc is also used for auth_db, domain and usrloc
modules and I haven't experienced any problems with those modules and
database connection/persistence. domain, location, version and subscriber
tables are correctly populated.

I'm not getting any errors from imc_manager(), it returns 200 OK. I can't
trace any errors in DEBUG related to problems with mysql database.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110530/5518eaac/attachment.htm>