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

[Stefan Rüetschli]

Hi Henning

Thanks for coming back to this.
I didn't solve it until now, I don't know where to search.
Does somebody also use PDB with 5.1.2 on Ubuntu 16.04.4?

Regards
Stefan

Am 17.06.18 um 21:06 schrieb Henning Westerholt:
>
> Am Dienstag, 29. Mai 2018, 08:47:00 CEST schrieb Stefan Rüetschli:
>
> > 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:
>
> Hello Stefan,
>
> sorry for the really late reply. Do you managed to solve the issue on 
> your own? Or does the problem persists?
>
> Best regards,
>
> Henning
>
> > <--- 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.
>
> > > >
>
> > > >
>
> > > >
>
> > > > I use this already with Kamailio 4.3.6 and there it is working.
>
> > > >
>
> > > >
>
> > > >
>
> > > > https://kamailio.org/docs/modules/5.1.x/modules/pdb.html
>
> > >
>
> > > Hello Stefan,
>
> > >
>
> > > strange. Can you post the debug logs (enable debug logging in cfg) of
>
> > > kamailio for one not working query here? Maybe we can find something
>
> > > there, before we dig into the module.
>
> > >
>
> > > Best regards,
>
> > >
>
> > > Henning
>
> -- 
>
> If you like my work in the Kamailio project, it would be great if you 
> could consider supporting me on Patreon: https://www.patreon.com/henningw
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180618/800ce664/attachment.html>