Hi all,<br><br>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.<br><br>I'm using following code provided in IMC module documentation:<br>
<br>modparam("imc", "db_url", DBURL)<br><br>## route block ###<br> if(is_method("MESSAGE") && (uri=~ "sip:chat-[0-9]+@") || (uri=~ "sip:chat-manager@")) {<br>
xlog("L_INFO", "going to imc: F [$fu] T [$tu] B [$rb]\n");<br><br> if(imc_manager())<br> sl_send_reply("200", "ok - imc_manager()");<br>
else<br> sl_send_reply("500", "command error");<br> exit;<br> }<br><br>I am creating chat room with following message sent to <a href="mailto:chat-manager@abc.hr">chat-manager@abc.hr</a>: "#create chat-111"<br>
<br>DEBUG log returns following:<br>May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: INFO: <script>: going to imc: F [<a href="mailto:sip%3Aoz@abc.hr">sip:oz@abc.hr</a>] T [<a href="mailto:sip%3Achat-manager@abc.hr">sip:chat-manager@abc.hr</a>] B [#create chat-111]<br>
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: DEBUG: imc [imc.c:525]: found command<br>May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: DEBUG: imc [imc_cmd.c:146]: command: [create]<br>
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: DEBUG: imc [imc_cmd.c:151]: parameter 0=[chat-111]<br>May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: DEBUG: imc [imc_cmd.c:171]: new room [chat-111]<br>
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: DEBUG: imc [imc_cmd.c:186]: added room uri= <a href="mailto:sip%3Achat-111@abc.hr">sip:chat-111@abc.hr</a><br>May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: DEBUG: imc [imc_mng.c:322]: [uri]= <a href="mailto:sip%3Aoz@abc.hr">sip:oz@abc.hr</a><br>
May 30 18:01:23 ser-test /usr/local/kamailio-ozren/sbin/kamailio[13225]: DEBUG: imc [imc_mng.c:326]: [user]= oz<br>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 [<a href="mailto:sip%3Aoz@abc.hr">sip:oz@abc.hr</a>]<br>
<br>"./kamctl fifo imc_list_rooms" returns following:<br>ROOM:: URI=<a href="mailto:sip%3Achat-111@abc.hr">sip:chat-111@abc.hr</a> MEMBERS=0 OWNER=<a href="mailto:sip%3Aoz@abc.hr">sip:oz@abc.hr</a><br><br>"./kamctl fifo imc_list_members <a href="mailto:sip%3Achat-111@abc.hr">sip:chat-111@abc.hr</a>" returns following:<br>
ROOM:: <a href="mailto:sip%3Achat-111@abc.hr">sip:chat-111@abc.hr</a> NR_OF_MEMBERS=1<br> MEMBER:: <a href="mailto:sip%3Aoz@abc.hr">sip:oz@abc.hr</a><br><br>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?<br>
<br>Any help is greatly appreciated.<br><br>Best regards,<br>Ozren Lapcevic<br><br>PS<br>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. <br><br>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. <br><br>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.<br>