24 Mar
2023
24 Mar
'23
7:29 a.m.
Hi,
I need to use a database that may sometimes timeout and I'd like to give a
conditional sip response based on whether there was a timeout or not. I'm
using sqlops with mysql modules. Does anyone know if that's possible ?
Thanks,
Leon
24 Mar
24 Mar
3:39 p.m.
Hello,
try to evaluate the return value of the sqlops command. You should get a “-1” when the
query execution fails.
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com<https://gilawa.com/>
From: Leon de Rooij <leon(a)exquisip.nl>
Sent: Freitag, 24. März 2023 07:29
To: sr-users(a)lists.kamailio.org
Subject: [SR-Users] different sip response on database (mysql) timeout
Hi,
I need to use a database that may sometimes timeout and I'd like to give a conditional
sip response based on whether there was a timeout or not. I'm using sqlops with mysql
modules. Does anyone know if that's possible ?
Thanks,
Leon
4:16 p.m.
Hello,
there is no propagation of specific connector errors to the upper layer,
sqlops can be used with many connectors, some using directly the hard
drive like sqlops. Maybe something can be added to db_mysql to get last
error, but it would require C developement.
So far the scope was to be able to detect it failed and eventually to
respond with 500 server error.
Cheers,
Daniel
On 24.03.23 07:29, Leon de Rooij wrote:
Hi,
I need to use a database that may sometimes timeout and I'd like to
give a conditional sip response based on whether there was a timeout
or not. I'm using sqlops with mysql modules. Does anyone know if
that's possible ?
Thanks,
Leon
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - June 5-7, 2023 - www.kamailioworld.com
Kamailio Advanced Training - Online - March 27-30, 2023 - www.asipto.com
4:20 p.m.
Hi Daniel, Henning,
Thanks for the info - I will experiment a bit further, maybe just detecting
the failure is good enough, otherwise I'll see if it's worth digging a bit
in the code :)
regards,
Leon
On Fri, Mar 24, 2023 at 4:16 PM Daniel-Constantin Mierla <miconda(a)gmail.com>
wrote:
Hello,
there is no propagation of specific connector errors to the upper layer,
sqlops can be used with many connectors, some using directly the hard
drive like sqlops. Maybe something can be added to db_mysql to get last
error, but it would require C developement.
So far the scope was to be able to detect it failed and eventually to
respond with 500 server error.
Cheers,
Daniel
On 24.03.23 07:29, Leon de Rooij wrote:
Hi,
I need to use a database that may sometimes timeout and I'd like to
give a conditional sip response based on whether there was a timeout
or not. I'm using sqlops with mysql modules. Does anyone know if
that's possible ?
Thanks,
Leon
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - June 5-7, 2023 - www.kamailioworld.com
Kamailio Advanced Training - Online - March 27-30, 2023 - www.asipto.com
396
days inactive
396
days old
3 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Henning Westerholt -
Leon de Rooij