Re: [SR-Users] Kamailio 5.1.2 and Module PDB: pdb_query returns always 0

Thanks for your reply. The debug at kamailio startup looks like this (multiple times, I think for each IP interface), this is only a part of it:

<--- snip ---> May 29 06:21:41 siphost01 /usr/sbin/kamailio[26692]: DEBUG: <core> [core/sr_module.c:984]: init_mod(): pdb May 29 06:21:41 siphost01 /usr/sbin/kamailio[26692]: DEBUG: pdb [pdb.c:525]: add_server(): adding server 'siphost01.mydom.com:5574' May 29 06:21:41 siphost01 /usr/sbin/kamailio[26692]: DEBUG: pdb [pdb.c:525]: add_server(): adding server 'siphost02.mydom.com:5574' May 29 06:21:41 siphost01 /usr/sbin/kamailio[26692]: DEBUG: pdb [pdb.c:525]: add_server(): adding server 'siphost03.mydom.com:5574' May 29 06:21:42 siphost01 /usr/sbin/kamailio[26692]: DEBUG: <core> [core/route.c:872]: fix_actions(): fixing pdb_query() May 29 06:21:42 siphost01 /usr/sbin/kamailio[26692]: DEBUG: <core> [core/sr_module.c:937]: init_mod_child(): idx 0 rank -127: pdb [main] May 29 06:21:42 siphost01 /usr/sbin/kamailio[26696]: DEBUG: <core> [core/sr_module.c:937]: init_mod_child(): idx 2 rank 2: pdb [udp receiver child=1 sock=127.0.0.1:5060] May 29 06:21:42 siphost01 /usr/sbin/kamailio[26696]: DEBUG: pdb [pdb.c:651]: init_server_socket(): initializing socket for 'siphost03.mydom.com:5574' May 29 06:21:42 siphost01 /usr/sbin/kamailio[26696]: DEBUG: pdb [pdb.c:651]: init_server_socket(): initializing socket for 'siphost02.mydom.com:5574' May 29 06:21:42 siphost01 /usr/sbin/kamailio[26696]: DEBUG: pdb [pdb.c:651]: init_server_socket(): initializing socket for 'siphost01.mydom.com:5574' May 29 06:21:42 siphost01 /usr/sbin/kamailio[26696]: DEBUG: pdb [pdb.c:675]: init_server_socket(): got 3 server in list <--- snap ---> So it finds all configured PDB servers. The debug for a non working query: <--- snip ---> May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: exec: *** cfgtrace:request_route=[PSTN] c=[/etc/kamailio//kamailio.cfg] l=1542 a=26 n=pdb_query May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:239]: pdb_query(): querying '0123334455'... May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:264]: pdb_query(): flushed 0 packets for 'siphost03.mydom.com:5574' May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:264]: pdb_query(): flushed 0 packets for 'siphost02.mydom.com:5574' May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:264]: pdb_query(): flushed 0 packets for 'siphost01.mydom.com:5574' May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:157]: pdb_msg_dbg(): Kamailio pdb client sends:#012version = 1#012type = 0#012code = 0#012id = 256#012len = 17#012payload = 30 31 32 33 33 33 34 34 35 35 00 May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:288]: pdb_query(): sending request to 'siphost03.mydom.com:5574' May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:288]: pdb_query(): sending request to 'siphost02.mydom.com:5574' May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:288]: pdb_query(): sending request to 'siphost01.mydom.com:5574' May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: DEBUG: pdb [pdb.c:157]: pdb_msg_dbg(): Kamailio pdb client receives:#012version = 0#012type = 0#012code = 0#012id = 256#012len = 17#012payload = 30 31 32 33 33 33 34 34 35 35 00 May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: NOTICE: pdb [pdb.c:359]: pdb_query(): Invalid code 0 received May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: INFO: pdb [pdb.c:386]: pdb_query(): got an answer in 0.706000 ms May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: exec: *** cfgtrace:request_route=[PSTN] c=[/etc/kamailio//kamailio.cfg] l=1543 a=26 n=xlog May 29 06:23:05 siphost01 /usr/sbin/kamailio[26706]: INFO: <script>: INFOSTD: PSTN pdb result for 0123334455: 0 <--- snap ---> Very strange for me too. Regards Stefan Am 28.05.18 um 21:00 schrieb Henning Westerholt: > Am Montag, 28. Mai 2018, 15:10:16 CEST schrieb Stefan Rüetschli: > > I have here Kamailio 5.1.2 with PDB Module. > > > > I use the documented function from PDB-Module as follows: > > > > > > > > pdb_query("$rU", "$avp(i:82)"); > > > > xlog("L_INFO","PDB result $rU: $avp(i:82)\n"); > > > > > > > > The problem is, that $avp(i:82) is always 0. > > > > > > > > If I test the PDB-Server, with "pdbt -r localhost:5574 query > > > > <phonenumber>" I get a valid response. > > > > > >