[SR-Users] presence bug

Kelvin Chua kelchy at gmail.com
Mon Mar 24 17:33:44 CET 2014


I would like to report a bug on the presence module
kamailio 4.0.5
setting custom table names via

modparam("presence", "presentity_table", "kam_presentity")
modparam("presence", "active_watchers_table", "kam_active_watchers")
modparam("presence", "watchers_table", "kam_watchers")

does work, i can see entries on the table when logged in.
however these things show up from time to time, seems like it is not
looking for the custom table name.


/usr/local/sbin/kamailio[20406]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Table 'kam.presentity'
doesn't exist
/usr/local/sbin/kamailio[20406]: ERROR: <core> [db_query.c:132]:
db_do_query_internal(): error while submitting query
/usr/local/sbin/kamailio[20406]: ERROR: <core> [db_query.c:429]:
db_fetch_query_internal(): unable to query db for fetch
/usr/local/sbin/kamailio[20406]: ERROR: presence [publish.c:108]:
msg_presentity_clean(): failed to query database for expired messages
/usr/local/sbin/kamailio[20406]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Table 'kam.presentity'
doesn't exist
/usr/local/sbin/kamailio[20406]: ERROR: <core> [db_query.c:291]:
db_do_delete(): error while submitting query
/usr/local/sbin/kamailio[20406]: ERROR: presence [publish.c:227]:
msg_presentity_clean(): failed to delete expired records from DB
/usr/local/sbin/kamailio[20406]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Table 'kam.watchers'
doesn't exist
/usr/local/sbin/kamailio[20406]: ERROR: <core> [db_query.c:291]:
db_do_delete(): error while submitting query
/usr/local/sbin/kamailio[20406]: ERROR: presence [subscribe.c:745]:
msg_watchers_clean(): cleaning pending subscriptions
/usr/local/sbin/kamailio[20406]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Table 'kam.active_watchers'
doesn't exist
/usr/local/sbin/kamailio[20406]: ERROR: <core> [db_query.c:291]:
db_do_delete(): error while submitting query
/usr/local/sbin/kamailio[20406]: ERROR: presence [subscribe.c:2220]:
update_db_subs_timer(): deleting expired information from database


Kelvin Chua
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140324/dd504514/attachment-0001.html>


More information about the sr-users mailing list