From ozren.lapcevic@gmail.com Mon May 30 18:28:09 2011
From: Ozren Lapcevic <ozren.lapcevic@gmail.com>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] IMC module doesn't save data to mysql database
Date: Mon, 30 May 2011 18:28:03 +0200
Message-ID: <BANLkTikURVZ5_v4UT7q8P9NVfbxnfsC0Fg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0075016500=="

--===============0075016500==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

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=3D~ "sip:chat-[0-9]+@") || (uri=3D~
"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(a)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(a)abc.hr] T [sip:chat-manager(a)abc.h=
r]
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=3D[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=3D sip:chat-111(a)abc.hr
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_mng.c:322]: [uri]=3D sip:oz(a)abc.hr
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]:
DEBUG: imc [imc_mng.c:326]: [user]=3D 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(a)abc.hr]

"./kamctl fifo imc_list_rooms" returns following:
ROOM::  URI=3Dsip:chat-111(a)abc.hr MEMBERS=3D0 OWNER=3Dsip:oz(a)abc.hr

"./kamctl fifo imc_list_members sip:chat-111(a)abc.hr" returns following:
ROOM:: sip:chat-111(a)abc.hr NR_OF_MEMBERS=3D1
        MEMBER:: sip:oz(a)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.



--===============0075016500==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

SGkgYWxsLDxicj48YnI+SSYjMzk7bSB0cnlpbmcgdG8gY29uZmlndXJlIElNQyBtb2R1bGUgYW5k
IGdldCBpdCB0byB3b3JrIHByb3Blcmx5IGJ1dCBJJiMzOTt2ZSBydW4gaW50byBwcm9ibGVtcyB3
aXRoIHNhdmluZyBJTUMgbW9kdWxlIGRhdGEgdG8gbXlzcWwgZGF0YWJhc2UuPGJyPjxicj5JJiMz
OTttIHVzaW5nIGZvbGxvd2luZyBjb2RlIHByb3ZpZGVkIGluIElNQyBtb2R1bGUgZG9jdW1lbnRh
dGlvbjo8YnI+CqA8YnI+bW9kcGFyYW0oJnF1b3Q7aW1jJnF1b3Q7LCAmcXVvdDtkYl91cmwmcXVv
dDssIERCVVJMKTxicj48YnI+IyMgcm91dGUgYmxvY2sgIyMjPGJyPqCgoKCgoKAgaWYoaXNfbWV0
aG9kKCZxdW90O01FU1NBR0UmcXVvdDspICZhbXA7JmFtcDsgKHVyaT1+ICZxdW90O3NpcDpjaGF0
LVswLTldK0AmcXVvdDspIHx8ICh1cmk9fiAmcXVvdDtzaXA6Y2hhdC1tYW5hZ2VyQCZxdW90Oykp
IHs8YnI+CqCgoKCgoKCgoKCgoKCgoCB4bG9nKCZxdW90O0xfSU5GTyZxdW90OywgJnF1b3Q7Z29p
bmcgdG8gaW1jOiBGIFskZnVdIFQgWyR0dV0gQiBbJHJiXVxuJnF1b3Q7KTs8YnI+PGJyPqCgoKCg
oKCgoKCgoKCgoCBpZihpbWNfbWFuYWdlcigpKTxicj6goKCgoKCgoKCgoKCgoKCgoKCgoKCgoCBz
bF9zZW5kX3JlcGx5KCZxdW90OzIwMCZxdW90OywgJnF1b3Q7b2sgLSBpbWNfbWFuYWdlcigpJnF1
b3Q7KTs8YnI+CqCgoKCgoKCgoKCgoKCgoCBlbHNlPGJyPqCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
IHNsX3NlbmRfcmVwbHkoJnF1b3Q7NTAwJnF1b3Q7LCAmcXVvdDtjb21tYW5kIGVycm9yJnF1b3Q7
KTs8YnI+oKCgoKCgoCBleGl0Ozxicj6goKCgoKCgIH08YnI+PGJyPkkgYW0gY3JlYXRpbmcgY2hh
dCByb29tIHdpdGggZm9sbG93aW5nIG1lc3NhZ2Ugc2VudCB0byA8YSBocmVmPSJtYWlsdG86Y2hh
dC1tYW5hZ2VyQGFiYy5ociI+Y2hhdC1tYW5hZ2VyQGFiYy5ocjwvYT46ICZxdW90OyNjcmVhdGUg
Y2hhdC0xMTEmcXVvdDs8YnI+Cjxicj5ERUJVRyBsb2cgcmV0dXJucyBmb2xsb3dpbmc6PGJyPk1h
eSAzMCAxODowMToyMyBzZXItdGVzdCAvdXNyL2xvY2FsL2thbWFpbGlvLW96cmVuL3NiaW4va2Ft
YWlsaW9bMTMyMjVdOiBJTkZPOiAmbHQ7c2NyaXB0Jmd0OzogZ29pbmcgdG8gaW1jOiBGIFs8YSBo
cmVmPSJtYWlsdG86c2lwJTNBb3pAYWJjLmhyIj5zaXA6b3pAYWJjLmhyPC9hPl0gVCBbPGEgaHJl
Zj0ibWFpbHRvOnNpcCUzQWNoYXQtbWFuYWdlckBhYmMuaHIiPnNpcDpjaGF0LW1hbmFnZXJAYWJj
LmhyPC9hPl0gQiBbI2NyZWF0ZSBjaGF0LTExMV08YnI+Ck1heSAzMCAxODowMToyMyBzZXItdGVz
dCAvdXNyL2xvY2FsL2thbWFpbGlvLW96cmVuL3NiaW4va2FtYWlsaW9bMTMyMjVdOiBERUJVRzog
aW1jIFtpbWMuYzo1MjVdOiBmb3VuZCBjb21tYW5kPGJyPk1heSAzMCAxODowMToyMyBzZXItdGVz
dCAvdXNyL2xvY2FsL2thbWFpbGlvLW96cmVuL3NiaW4va2FtYWlsaW9bMTMyMjVdOiBERUJVRzog
aW1jIFtpbWNfY21kLmM6MTQ2XTogY29tbWFuZDogW2NyZWF0ZV08YnI+Ck1heSAzMCAxODowMToy
MyBzZXItdGVzdCAvdXNyL2xvY2FsL2thbWFpbGlvLW96cmVuL3NiaW4va2FtYWlsaW9bMTMyMjVd
OiBERUJVRzogaW1jIFtpbWNfY21kLmM6MTUxXTogcGFyYW1ldGVyIDA9W2NoYXQtMTExXTxicj5N
YXkgMzAgMTg6MDE6MjMgc2VyLXRlc3QgL3Vzci9sb2NhbC9rYW1haWxpby1venJlbi9zYmluL2th
bWFpbGlvWzEzMjI1XTogREVCVUc6IGltYyBbaW1jX2NtZC5jOjE3MV06IG5ldyByb29tIFtjaGF0
LTExMV08YnI+Ck1heSAzMCAxODowMToyMyBzZXItdGVzdCAvdXNyL2xvY2FsL2thbWFpbGlvLW96
cmVuL3NiaW4va2FtYWlsaW9bMTMyMjVdOiBERUJVRzogaW1jIFtpbWNfY21kLmM6MTg2XTogYWRk
ZWQgcm9vbSB1cmk9IDxhIGhyZWY9Im1haWx0bzpzaXAlM0FjaGF0LTExMUBhYmMuaHIiPnNpcDpj
aGF0LTExMUBhYmMuaHI8L2E+PGJyPk1heSAzMCAxODowMToyMyBzZXItdGVzdCAvdXNyL2xvY2Fs
L2thbWFpbGlvLW96cmVuL3NiaW4va2FtYWlsaW9bMTMyMjVdOiBERUJVRzogaW1jIFtpbWNfbW5n
LmM6MzIyXTogW3VyaV09IDxhIGhyZWY9Im1haWx0bzpzaXAlM0FvekBhYmMuaHIiPnNpcDpvekBh
YmMuaHI8L2E+PGJyPgpNYXkgMzAgMTg6MDE6MjMgc2VyLXRlc3QgL3Vzci9sb2NhbC9rYW1haWxp
by1venJlbi9zYmluL2thbWFpbGlvWzEzMjI1XTogREVCVUc6IGltYyBbaW1jX21uZy5jOjMyNl06
IFt1c2VyXT0gb3o8YnI+TWF5IDMwIDE4OjAxOjIzIHNlci10ZXN0IC91c3IvbG9jYWwva2FtYWls
aW8tb3pyZW4vc2Jpbi9rYW1haWxpb1sxMzIyNV06IERFQlVHOiBpbWMgW2ltY19jbWQuYzoxOTZd
OiBhZGRlZCB0aGUgb3duZXIgYXMgdGhlIGZpcnN0IG1lbWJlciBbPGEgaHJlZj0ibWFpbHRvOnNp
cCUzQW96QGFiYy5ociI+c2lwOm96QGFiYy5ocjwvYT5dPGJyPgo8YnI+JnF1b3Q7Li9rYW1jdGwg
ZmlmbyBpbWNfbGlzdF9yb29tcyZxdW90OyByZXR1cm5zIGZvbGxvd2luZzo8YnI+Uk9PTTo6oCBV
Ukk9PGEgaHJlZj0ibWFpbHRvOnNpcCUzQWNoYXQtMTExQGFiYy5ociI+c2lwOmNoYXQtMTExQGFi
Yy5ocjwvYT4gTUVNQkVSUz0wIE9XTkVSPTxhIGhyZWY9Im1haWx0bzpzaXAlM0FvekBhYmMuaHIi
PnNpcDpvekBhYmMuaHI8L2E+PGJyPjxicj4mcXVvdDsuL2thbWN0bCBmaWZvIGltY19saXN0X21l
bWJlcnMgPGEgaHJlZj0ibWFpbHRvOnNpcCUzQWNoYXQtMTExQGFiYy5ociI+c2lwOmNoYXQtMTEx
QGFiYy5ocjwvYT4mcXVvdDsgcmV0dXJucyBmb2xsb3dpbmc6PGJyPgpST09NOjogPGEgaHJlZj0i
bWFpbHRvOnNpcCUzQWNoYXQtMTExQGFiYy5ociI+c2lwOmNoYXQtMTExQGFiYy5ocjwvYT4gTlJf
T0ZfTUVNQkVSUz0xPGJyPqCgoKCgoKAgTUVNQkVSOjogPGEgaHJlZj0ibWFpbHRvOnNpcCUzQW96
QGFiYy5ociI+c2lwOm96QGFiYy5ocjwvYT48YnI+PGJyPkhvd2V2ZXIsIHRoYXQgZGF0YSBpcyBu
b3QgcGVyc2lzdGVkL3NhdmVkIGluIHRoZSBpbWNfcm9vbXMgYW5kIGltY19tZW1iZXJzIHRhYmxl
cyBpbiB0aGUgZGF0YWJhc2UuIEFueSBjbHVlcyB3aGF0IG1pZ2h0IGJlIHRoZSBwcm9ibGVtIGhl
cmU/PGJyPgo8YnI+QW55IGhlbHAgaXMgZ3JlYXRseSBhcHByZWNpYXRlZC48YnI+PGJyPkJlc3Qg
cmVnYXJkcyw8YnI+T3pyZW4gTGFwY2V2aWM8YnI+PGJyPlBTPGJyPkkmIzM5O20gcnVuaW5nIEth
bWFpbGlvIDMuMS40IHdpdGggZGVmYXVsdCBjZmcgZmlsZSB3aXRoIGVuYWJsZWQgbXlzcWwsIApt
dWx0aWRvbWFpbiwgdXNybG9jZGIsIGF1dGggYW5kIE5BVC4gSSBjYW4gcmVnaXN0ZXIgY2xpZW50
cywgZXN0YWJsaXNoIApjYWxscywgc2VuZCBJTXMsIGV0Yy4gaW1jX3Jvb21zIGFuZCBpbWNfbWVt
YmVycyB0YWJsZXMgd2VyZSBjcmVhdGVkIHdoZW4ga2FtYWlsaW8gd2FzIGluc3RhbGxlZC4gSSYj
Mzk7dmUgYWxzbyBjaGVja2VkIGltYy1jcmVhdGUuc3FsIHNjcmlwdCBhbmQgdGFibGVzIGFyZSBj
b3JyZWN0bHkgY3JlYXRlZC4gPGJyPjxicj5UaGUgc2FtZSBEQlVSTCB1c2VkIGZvciBpbWMgaXMg
YWxzbyB1c2VkIGZvciBhdXRoX2RiLCBkb21haW4gYW5kIHVzcmxvYyAKbW9kdWxlcyBhbmQgSSBo
YXZlbiYjMzk7dCBleHBlcmllbmNlZCBhbnkgcHJvYmxlbXMgd2l0aCB0aG9zZSBtb2R1bGVzIGFu
ZCAKZGF0YWJhc2UgY29ubmVjdGlvbi9wZXJzaXN0ZW5jZS4gZG9tYWluLCBsb2NhdGlvbiwgdmVy
c2lvbiBhbmQgc3Vic2NyaWJlciB0YWJsZXMgYXJlIGNvcnJlY3RseSBwb3B1bGF0ZWQuIDxicj48
YnI+SSYjMzk7bSBub3QgZ2V0dGluZyBhbnkgZXJyb3JzIGZyb20gaW1jX21hbmFnZXIoKSwgaXQg
cmV0dXJucyAyMDAgT0suIEkgY2FuJiMzOTt0IHRyYWNlIGFueSBlcnJvcnMgaW4gREVCVUcgcmVs
YXRlZCB0byBwcm9ibGVtcyB3aXRoIG15c3FsIGRhdGFiYXNlLjxicj4K

--===============0075016500==--