[OpenSIPS-Users] SQL Query Variables

Kingsley Tart kingsley at dns99.co.uk
Sat Aug 14 23:48:23 EST 2021


On Fri, 2021-08-13 at 20:27 +0500, HS wrote:
> Hi all.
> 
> In my quest to make the push server work on my Opensips 3.0
> installation. I have figured out that the following query isn't
> working correctly:
> 
> $avp(query) = "SELECT token, app, platform, sip_instance from
> push_tokens WHERE username='" + $(var(user){s.escape.common}) + "'
> AND domain='" + $(var(domain){s.escape.common}) + "'";
> 
> When I replace $(var(user...)/$var(domain...) with $(tU..) and
> $(td..), the query seems to work. I have tried multiple combinations,
> but the original query isn't working.
> 
> What do I need to change to make the original query work? I did find
> details of what tU is, but nothing about var(user).

Does your query contain what you think it does? Do you see what you
expect if you do

xlog("Query=$avp(query)\n");

?

-- 
Cheers,
Kingsley.




More information about the Users mailing list