[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




More information about the Users mailing list