Hi,
what can be the reason why usrloc module sometimes can read from database, sometimes
not?
Normal operation looks ok, the location table is kept up to date. The problem seems to be
related with RPC (kamcmd or jsonrpc). For example,
kamcmd ul.dump # ok
kamcmd ul.lookup location 6351*1 # ok
kamcmd ul.db_users location # error: 500 - Failed to use table
Error 500 correlates with syslog entry: ERROR: <core> [db.c:481]: db_use_table():
invalid connection parameter
Who connects where? In my understanding usrloc via core to mysql. I suppose RPC calls do
not fail if usrloc can operate on kamailio memory, does that make sense? If so, what
usrloc parameter can I tweak to fix error 500 ? I don't find any usrloc parameter
regarding db connection.
(Opening another mysql session as user kamailio is no problem, so we re not running out of
connections.)
Thanks in advance!
Volker
[cid:fb71bb9b-ad4f-4110-824b-d6805406bf6a]
Volker Denneberg
Development
Telefon: +49 241 980 986 41
Web:
www.m3connect.de<https://mx.scientific.de/owa/redir.aspx?C=RW1TSCipXQC6K…
E-Mail:
v.denneberg@m3connect.de<https://mx.scientific.de/owa/redir.aspx?C=BjBXIUrD2WCryLRZ2IrAAwEu0b0W0ciUY-5KeN2UcS_9nK32r5vVCA..&URL=mailto%3aj.siemons%40m3connect.de>
m3connect GmbH | Pascalstr.18 | 52076 Aachen | DE/Germany | Amtsgericht Aachen | HRB 8773
| USt.- ID: DE219 664 658 | Geschäftsführer/CEO: Emilio Dragas