Something I've never run into before when I was using MySQL 4.x, but now crops
up on MySQL 5.0.27... I get these errors:
Feb 5 07:30:40 qabalah ser[26765]: submit_query(): MySQL server has gone away
Feb 5 07:30:40 qabalah ser[26765]: db_update: Error while submitting query
Feb 5 07:30:40 qabalah ser[26765]: db_upd_ucontact(): Error while updating
database
Feb 5 07:30:40 qabalah ser[26765]: wb_timer(): Error while updating contact
in db
I assume there's some sort of timeout of the SER connection to mysql? Is there
a standard way to rectify this? Is this something new in MySQL 5?
N.
We have over 4 proxies running openser-1.1.0-notls. Recently we started to
see the following error in the logs of one of the proxies:
Feb 4 06:46:21 proxy01 /usr/local/sbin/openser[4670]: ERROR: udp_send:
sendto(sock,0xb3c35898,594,0,0xb3c257f4,16): Invalid argument(22)
Feb 4 06:46:21 proxy01 /usr/local/sbin/openser[4670]: CRITICAL: invalid
sendtoparameters one possible reason is the server is bound to localhost and
attempts to send to the net
Feb 4 06:46:21 proxy01 /usr/local/sbin/openser[4670]: msg_send: ERROR:
udp_send failed
Feb 4 06:46:21 proxy01 /usr/local/sbin/openser[4670]:
ERROR:tm:t_forward_nonack: sending request failed
Now the errors suggests a binding to localhost, however our openser.cfg has
the following:
listen=eth0:5060
After a brief search we came across a couple of over people having a similar
problem. Once of the suggested fixes was to add a mhomed=1 line to the cfg.
Well we tried this (even though we are not multi homed) and the error
changed to:
Feb 5 02:54:09 proxy01 /usr/local/sbin/openser[2209]: ERROR:
get_out_socket: connect failed: Invalid argument
Feb 5 02:54:09 proxy01 /usr/local/sbin/openser[2209]: ERROR:
get_out_socket: no socket found
Feb 5 02:54:09 proxy01 /usr/local/sbin/openser[2209]: ERROR:tm:add_uac:
can't fwd to af 2, proto 1 (no corresponding listening socket)
Feb 5 02:54:09 proxy01 /usr/local/sbin/openser[2209]:
ERROR:tm:t_forward_nonack: failure to add branches
Does anyone have any suggestions or ideas as to what is causing this error.
Thanks
mburns
Hi,
Since dbtext is part of the standard, my suggestion would be to
ship/install the sc.dbtext script along with the openserctl script.
We can install it as openser_dbtext_ctl and in openserctl we can make
a reference to it if no DBENGINE is provided:
see the following patch for openserct (openser-v1.1.1):
diff -Naurp sip-server/scripts/openserctl openser/scripts/openserctl
--- sip-server/scripts/openserctl 2006-09-15 08:41:42.000000000 -0400
+++ openser/scripts/openserctl 2007-01-17 09:39:09.000000000 -0500
@@ -126,6 +126,8 @@ do
$f
done
echo
+ echo "Note: Use openser_dbtext_ctl for DBTEXT operations!"
+ echo
}
Regards,
Ovidiu Sas
Hello,
I've built openser 1.1.1 from source with radius support. I installed
radiusclient-ng. When I execute openser with to loadmodule
auth_radius.so in my configuration I get:
# openser
0(20268) ERROR: load_module: could not open module
</usr/local/lib/openser/modules/auth_radius.so
loadmodule >: /usr/local/lib/openser/modules/auth_radius.so
loadmodule : cannot open shared object file: No such file or directory
0(20268) parse error (60,13-14): failed to load module
0(20268) parse error (60,14-15): syntax error
0(20268) parse error (60,14-15):
ERROR: bad config file (3 errors)
But the module is there.
# ls -l /usr/local/lib/openser/modules/auth_radius.so
-rwxr-xr-x 1 root staff 61369 Feb 5
10:33 /usr/local/lib/openser/modules/auth_radius.so
This is really strange.
ciao
Luca
have you checked this on the x-lite machine?
regards,
bogdan
raviprakash sunkara wrote:
> it didn't see any Ack packet is sending to SIP server,
>
>
> On 2/5/07, *Bogdan-Andrei Iancu* <bogdan(a)voice-system.ro
> <mailto:bogdan@voice-system.ro>> wrote:
>
> I would say the X-lite does not obey the RR header - please try to get
> an trace from the X-lite machine to see where the ACK is sent.
>
> regards,
> bogdan
>
> raviprakash sunkara wrote:
>
> > Hi BogDan,
> >
> > Yes, I see Record-Route header in the 200 ok.......
> > Please can u check the ngrepped of the X-lite
> > with Hard phones iit is fine ...........
> > Below one is ngrep from X-lite users,
>
>
>
>
>
> --
> Thanks and Regards
> Ravi Prakash Sunkara
> ravi.sunkara(a)hyperion-tech.com <mailto:ravi.sunkara@hyperion-tech.com>
> M:+91 9985077535
> O:+91 40 23114549
> F:+91 40 40208727
> ravi.sunkara(a)hyperion-tech.com <mailto:ravi.sunkara@hyperion-tech.com>
> www.hyperion-tech.com <http://www.hyperion-tech.com>
Hi!
What is the default send socket? Is it the first listen=..... statement in
openser.cfg? Or can I manually set the default sendsocket?
regards
klaus
Hi all,
I'm having a problem with the mediaproxy rtp proxy.
I'm using to do accounting into a MySQL database.
After a period of inactivity, it loses it's connection to the MySQL server and
the update queries begin to fail. Openser stays connected, however.
The error in the logs is:
error: accounting failed. MySQL error: (2006, 'MySQL server has gone
away')
I'm running:
mediaproxy 1.8.0
openser-1.1.0 (using the RHEL3 rpm from the openser website)
openser-mysql-1.1.0 (again using the openser RHEL3 rpm)
Python-2.4.4
MySQL-python-1.2.1_p2
My Python skills aren't up to much. So far, I've tried added the
following line into /usr/local/mediaproxy/modules/mysql.py just before
the query call, to try and re-establish the connection:
def query(self, query):
self._query = query
for c in range(0, 3):
try:
self.conn.db.ping() <<<<<<---- added by me
return self.cursor.execute(query)
except MySQLdb.OperationalError, why:
if why[0] not in (CR.SERVER_GONE_ERROR, CR.SERVER_LOST):
raise
raise
... but it hasn't helped.
Has anyone seen this before?
Best regards,
James
--
James Holden AQ Limited
Senior Systems Architect 13-15 Hunslet Road
james.holden(a)uk.aql.com Leeds, LS10 1JQ
07989 702968 0800 389 5815
=====================================================
http://aql.com/documents/news/about_aql.pdf
"The service has been perfect."
BSI Inspectorate ltd
"really really really useful. easy to use and reduces manpower."
Fortnums
"without a shadow of a doubt...excellent"
Ruella James Plc
-----------------------------------------------------
(aq) Limited
13-15 Hunslet Road Leeds LS10 1JQ
194 Harrogate Road Leeds LS7 4NZ
http://www.aql.com
Sales: 08707 449227
Fax: 08707 449228
PGP public key http://aql.co.uk/A-Q.txt
Subject to our standard terms, found at
http://aql.com/site/termsofservice.php
-----------------------------------------------------
******************************
CONFIDENTIALITY
This e-mail is intended only for the use of the addressees named
above and may be confidential or legally privileged.
If you are not an addressee you must not read it and must not use
any information contained in nor copy it nor inform any person other
than (aq) limited or the addressees of its existence or contents.
If you have received this email and are not a named addressee, please
delete it and notify the (aq) limited customer service department via
admin(a)a-q.co.uk. Many thanks.
=========================================================
Hi,
I would like to use the dispatcher module. I have configured it on my
ser.cfg file for the PSTN calls and it works fine.
However when the select gateway is unavailable the module don't switch to
another gateway.
Can you help me to write the "failure_route" so I can use another gateway
when the first is unavailable?
'm using the "call forwarding ser.cfg" file of the SER Getting Started
<http://www.iptel.org/ser/doc/gettingstarted> pack (in attachment I'm
sending you my ser.cfg and dispatcher.list files)
Thanks in advance for your help.
Bye,
Giovanni Chirico
Just a typo correction
On 02/05/07 13:54, Brandon Armstead wrote:
> Daniel-Constantin Mierla wrote:
>> Stripping is now possible with the new introduced 'transformations':
>> http://openser.org/dokuwiki/doku.php/transformations:devel
>>
>> So if you want to strip last two characters of username in R-URI
>>
>> $var(x) = $(rU{s.len})-2;
>> $rU = $(ru{s.substr,0,$var(x)});
^^^ this is:
$rU = $(rU{s.substr,0,$var(x)});
Cheers,
Daniel
>>
>> Cheers,
>> Daniel
>>
>>
>> On 01/30/07 09:08, Juha Heinanen wrote:
>>> Brandon Armstead writes:
>>>
>>> > i.e. strip_tail(strlen($ru) - 2); ... or something like such.
>>>
>>> sorry, but my suggestion
>>>
>>> substr($ru, -2, 2)
>>>
>>> does not work, since it returns the last two chars of $ru not the
>>> remaining chars. strlen is indeed needed for the above. using php
>>> substr and strlen
>>>
>>> strip_tail(strlen($ru) - 2)
>>>
>>> becomes
>>>
>>> substr($ru, 0, strlen($ru) - 2)
>>>
>>> -- juha
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users(a)openser.org
>>> http://openser.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>>
> Hello Daniel,
>
> Glad to see this implemented, I think it will be a definite asset
> to the future and improvements of OpenSER. Keep up the good work!
>
> Regards,
> Brandon
>