[SR-Users] Error in db_mysql while using presence

[Henning Westerholt]

Am Dienstag, 8. Januar 2019, 14:57:21 CET schrieb Ravindrakumar Bhatt:
> I am using latest kamailio stable version. i have used it for presenece and
> BLF. i am facing issue in presence related method when i am setting
> sub_db_mode to any db related mode like 3.

Hello Ravindrakumar,

the presence module uses a database LOCK TABLE command and this fails. Can you 
check if the database user that is used from Kamailio has the appropriate 
permissions to issue this command on the database? You can try e.g. with mysql 
command line client.
 
> Version :
> version: kamailio 5.2.0 (x86_64/linux) 535e13
> flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS,
> DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC,
> Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX,
> FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR,
> USE_DST_BLACKLIST, HAVE_RESOLV_RES
> ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144 MAX_URI_SIZE 1024,
> BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
> poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
> id: 535e13
> compiled on 06:32:22 Jan  8 2019 with gcc 4.8.5
> 
> Kamailio.cfg setup:
> modparam("presence|presence_xml", "db_url", DBURL)
> modparam("presence", "server_address", "sip:XX.XX.XX.XX:5050")
> modparam("presence", "send_fast_notify", 0)
> modparam("presence", "db_update_period", 20)
> modparam("presence", "clean_period", 40)
> modparam("presence", "subs_db_mode", 0)
> modparam("presence", "fetch_rows", 1000)
> 
> # ----- presence_xml params -----
> #modparam("presence_xml", "db_url", DBURL)
> modparam("presence_xml", "force_active", 1)
> 
> # ----- pua params -----
> modparam("pua", "db_url", DBURL)
> modparam("pua", "db_mode", 2)
> modparam("pua", "update_period", 60)
> modparam("pua", "dlginfo_increase_version", 0)
> modparam("pua", "reginfo_increase_version", 0)
> modparam("pua", "check_remote_contact", 1)
> modparam("pua", "fetch_rows", 1000)
> 
> # ----- pua_dialoginfo params -----
> modparam("pua_dialoginfo", "include_callid", 1)
> modparam("pua_dialoginfo", "send_publish_flag", FLT_DLGINFO)
> modparam("pua_dialoginfo", "caller_confirmed", 0)
> modparam("pua_dialoginfo", "include_tags", 1)
> modparam("pua_dialoginfo", "override_lifetime", 124)
> 
> # ----- dialog params -----
> modparam("dialog", "db_url", DBURL)
> modparam("dialog", "enable_stats", 1)
> modparam("dialog", "db_mode", 1)
> modparam("dialog", "dlg_flag", FLT_DLG)
> modparam("presence_dialoginfo", "force_single_dialog", 0)
> Error:
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19523]: {1 1 PUBLISH
> MzQ4ZjNhOGRlYWZlY2QyMDQwMGZlZjg0N2JlZGE2YWM.} ERROR: db_mysql
> [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Table
> 'active_watchers' was not locked with LOCK TABLES (1100)
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19523]: {1 1 PUBLISH
> MzQ4ZjNhOGRlYWZlY2QyMDQwMGZlZjg0N2JlZGE2YWM.} ERROR: <core>
> [db_query.c:132]: db_do_query_internal(): error while submitting query
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19523]: {1 1 PUBLISH
> MzQ4ZjNhOGRlYWZlY2QyMDQwMGZlZjg0N2JlZGE2YWM.} ERROR: presence
> [notify.c:1369]: publ_notify_notifier(): Can't query db
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19523]: {1 1 PUBLISH
> MzQ4ZjNhOGRlYWZlY2QyMDQwMGZlZjg0N2JlZGE2YWM.} ERROR: presence
> [presentity.c:1152]: update_presentity(): updating watcher records
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19527]: {1 1 SUBSCRIBE
> MTlkYjI2NTBhYTFlMTBjYmYyMDgzNzQxYTM3OTE4OGE.} ERROR: db_mysql
> [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Table
> 'watchers' was not locked with LOCK TABLES (1100)
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19527]: {1 1 SUBSCRIBE
> MTlkYjI2NTBhYTFlMTBjYmYyMDgzNzQxYTM3OTE4OGE.} ERROR: <core>
> [db_query.c:132]: db_do_query_internal(): error while submitting query
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19527]: {1 1 SUBSCRIBE
> MTlkYjI2NTBhYTFlMTBjYmYyMDgzNzQxYTM3OTE4OGE.} ERROR: presence
> [subscribe.c:2827]: get_db_subs_auth(): while querying watchers table
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19527]: {1 1 SUBSCRIBE
> MTlkYjI2NTBhYTFlMTBjYmYyMDgzNzQxYTM3OTE4OGE.} ERROR: presence
> [subscribe.c:1217]: handle_subscribe(): getting subscription status from
> watchers table
> Jan  8 04:34:37 client1 /usr/local/sbin/kamailio[19523]: {1 1 PUBLISH
> MzQ4ZjNhOGRlYWZlY2QyMDQwMGZlZjg0N2JlZGE2YWM.} ERROR: presence
> [publish.c:499]: ki_handle_publish_uri(): when updating presentity
> 
> I am currently using presence with memory only db_mode but for persistence
> i would like to use db_only mode which is not possible due to this issue.
> Any idea or suggetions for this issue.

Best regards,

Henning


-- 
Henning Westerholt - https://skalatan.de/blog/
Kamailio services - https://skalatan.de/services
Kamailio security assessment - https://skalatan.de/de/assessment