Re: [OpenSIPS-Users] Public IP in REGISTER

2020-03-09 Thread Jehanzaib Younis
i do if(isflagset(8)) { setbflag(3); setbflag(NAT); setbflag(7); } save("location"); exit; I have modparam("usrloc", "nat_bflag", "NAT") & modparam

Re: [OpenSIPS-Users] opensips udp workers lock up with sched_yield

2020-03-09 Thread Bogdan-Andrei Iancu
Hi William, That it's interesting. Most of the processes are idle (waiting in the I/O reactor) and there are a bunch of them blocked in a lock (same pattern). Nevertheless, the weird thing is there is no active process (like doing something) that may hold the lock. All procs are either blocke

Re: [OpenSIPS-Users] WARNING:core:timer_ticker: timer task

2020-03-09 Thread Bogdan-Andrei Iancu
Hi Oleg, Well, for some reasons, it looks like it takes to your OpenSIPS more than 1.5 minutes to send all the pings. If you have no DNS resolving evolved here, the only penalty may come from the transport layer, but you mentioned most of them are over SCTP - to be honest I never used it, to

Re: [OpenSIPS-Users] Second Contact when sending 302 Redirect using async avp_db_query

2020-03-09 Thread Calvin Ellison
Thanks, Jon. Confirmed, updating $ru and not using append_to_reply solved the problem. After a moment of contemplation, I realized it makes sense that a 3xx response Contact would be based on the request URI Regards, *Calvin Ellison* Senior Voice Operations Engineer calvin.elli...@voxox.com +1

Re: [OpenSIPS-Users] MySQL Type: FIELD_TYPE_NEWDECIMAL (246) uses DB_INT result type but should use float

2020-03-09 Thread Calvin Ellison
The problem, as I see it, is that the MariaDB server is indicating this field is a floating-point (FIELD_TYPE_NEWDECIMAL), but OpenSIPS is casting that integer (DB_INT). I don't really need the delay field but I have no way to exclude it from the result and avp_db_query want every field mapped to

Re: [OpenSIPS-Users] MySQL Type: FIELD_TYPE_NEWDECIMAL (246) uses DB_INT result type but should use float

2020-03-09 Thread Brett Nemeroff
Can you just statically put a integer in there? Like say, 0? I actually think this is a bug. You are using 2.4.7? I don’t see this fixed in newer versions. The bug is on Line 81 of res.c. It incorrectly assumes that MYSQL_TYPE_NEWDECIMAL is an INT. This should be easy for you to attempt to fix an

Re: [OpenSIPS-Users] opensips udp workers lock up with sched_yield

2020-03-09 Thread William Simon
This is opensips 2.2.7 (I understand no longer supported) . We found last time this happened a very large TCP send-q from opensips to a remote SIP TCP endpoint when running netstat. It seems TCP gets blocked and does not recover. We do not need to reboot the server to restore the service, only r

Re: [OpenSIPS-Users] MySQL Type: FIELD_TYPE_NEWDECIMAL (246) uses DB_INT result type but should use float

2020-03-09 Thread Calvin Ellison
Updating the C code per Brett's suggestion resolved that specific error: DBG:db_mysql:db_mysql_str2val: converting DOUBLE [0.0018] Now there is a warning when trying to print that avp: WARNING:avpops:db_query_avp_print_results: Unknown type 2 I don't really care about this particular variable,

[OpenSIPS-Users] Presence 404 Not Here

2020-03-09 Thread Social Boh
Hello, maybe is a error on my configuration but when i send a SUBSCRIBE to OpenSIPs, the SIP flow is: Device                                        OpenSIPs SUBSCRIBE    -->                        <--        200OK NOTIFY          -->                    

Re: [OpenSIPS-Users] MySQL Type: FIELD_TYPE_NEWDECIMAL (246) uses DB_INT result type but should use float

2020-03-09 Thread Calvin Ellison
Copying Brett's reply back to the list. I deleted some of the previous conversation to avoid "message too large". I also noticed DB_DOUBLE is missing from /avpops/avpops_db.c but I don't know C well enough to do the needful. Do you know what should be done to make it a string? Here's my updated /

Re: [OpenSIPS-Users] MySQL Type: FIELD_TYPE_NEWDECIMAL (246) uses DB_INT result type but should use float

2020-03-09 Thread Brett Nemeroff
Calvin, If you look at the code blocks, I’d start by mirroring one of the string type conversion code blocks and see how you do. You should see it repeated a bunch of times (in avpops_db.c). I’m away from the code right now, so I can only be of limited help at the moment. -Brett On Mon, Mar 9, 2