Re: [OpenSIPS-Users] SQL Query Variables

2021-08-15 Thread HS
Hi Kingsley. Thanks a lot for your comment. I realised that the following was missing before the query: $var(user) = $rU; $var(domain) = $rd; It seems to be working for usernames now. Probably been the toughest bit of self-learning. Next step, need to figure out how to make this work for

Re: [OpenSIPS-Users] SQL Query Variables

2021-08-14 Thread Kingsley Tart
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

[OpenSIPS-Users] SQL Query Variables

2021-08-13 Thread HS
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='" +

[OpenSIPS-Users] SQL query

2011-02-03 Thread Denis Putyato
Hello! Opensips 1.6.4-2, MySQL installed on the same server as opensips. Please can somebody explain why such message can appear in syslog? This happens when I make “opensipsctl fifo dp_reload” after long period of time nothing to do with opensips. During processing calls opensips make

Re: [OpenSIPS-Users] SQL query

2011-02-03 Thread Bogdan-Andrei Iancu
Hi Denis, As the messages say, they are just info, they are not indicating a problem. The Info is about a reconnect event to DB - as the FIFO process (doing the reload) is most of the time idle, the mysql server probably disconnects it, so it need to reconnects when a DB query must be done.