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.dehttps://mx.scientific.de/owa/redir.aspx?C=RW1TSCipXQC6K0Yw1m69CGqyTwJHXjiiN8oBDLLwr_79nK32r5vVCA..&URL=http%3a%2f%2fwww.m3connect.de%2f E-Mail: v.denneberg@m3connect.dehttps://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