31 Mar
2006
31 Mar
'06
4:01 p.m.
please help.....
If i restart MySQL(version 5.0.19), SER shows next error message.
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): MySQL server has
gone away
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): Error while
submitting query
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: get_ha1(): Error while querying
database
Mar 31 22:37:22 localhost /usr/local/sbin/ser[32703]: Binding
'1234@192.9.2.1','sip:1234@192.9.2.11:5060' has expired
As appear in upside message, SER does not auto-reconnect to mysql.
If MySQL restarted, SER must be able to do Auto-Reconnect.
Is no there way that SER can do Auto-Reconnect to MySQL?
11 Apr
11 Apr
3:34 a.m.
John,
I just saw that message today as well. I had to restart SER. I didn't know
what it was, but I would be like to know if you find a solution. This seems
to have something to do with the newest version of MySQL I think. I am
running v5.0.18 for the first time. This does not happen on MySQL v4.1.16.
Leo P.
________________________________________
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of "???"
Sent: Friday, March 31, 2006 9:01 AM
To: serusers(a)lists.iptel.org
Subject: [Serusers] ERROR message : MySQL server has gone away
please help.....
If i restart MySQL(version 5.0.19), SER shows next error message.
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): MySQL
server has gone away
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): Error
while submitting query
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: get_ha1(): Error while
querying database
Mar 31 22:37:22 localhost /usr/local/sbin/ser[32703]: Binding
'1234@192.9.2.1','sip:1234@192.9.2.11:5060' has expired
As appear in upside message, SER does not auto-reconnect to mysql.
If MySQL restarted, SER must be able to do Auto-Reconnect.
Is no there way that SER can do Auto-Reconnect to MySQL?
4:02 p.m.
Yes, there was a change in the mysql client library in 5.x. Try to use
the latest stable SER version (0.9.6), the re-connect problem should be
fixed there.
Jan.
Leo Papadopoulos wrote:
John,
I just saw that message today as well. I had to restart SER. I didn't know
what it was, but I would be like to know if you find a solution. This seems
to have something to do with the newest version of MySQL I think. I am
running v5.0.18 for the first time. This does not happen on MySQL v4.1.16.
Leo P.
________________________________________
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of "???"
Sent: Friday, March 31, 2006 9:01 AM
To: serusers(a)lists.iptel.org
Subject: [Serusers] ERROR message : MySQL server has gone away
please help.....
If i restart MySQL(version 5.0.19), SER shows next error message.
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): MySQL
server has gone away
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): Error
while submitting query
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: get_ha1(): Error while
querying database
Mar 31 22:37:22 localhost /usr/local/sbin/ser[32703]: Binding
'1234@192.9.2.1','sip:1234@192.9.2.11:5060' has expired
As appear in upside message, SER does not auto-reconnect to mysql.
If MySQL restarted, SER must be able to do Auto-Reconnect.
Is no there way that SER can do Auto-Reconnect to MySQL?
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
13 Apr
13 Apr
1:39 p.m.
Greetings to the list.
We have a setup with ser-0.9.6 and mysql-5.0.19.
We have compiled everything from sources and we used mysql-5.0.19 sources from
MySQL. Our x86 servers run Debian Sarge.
We have installed everything under /opt and we linked ser with the
mysql client libs under /opt/mysql/lib. There is no other installation
of MySQL (clients or development files).
In ser.cfg, we have the following mysql URIs:
fifo_db_url="mysql://ser:XXXXX@<IP_of_MySQL>/ser"
modparam("usrloc", "db_url",
"mysql://ser:XXXXX@<IP_of_MySQL>/ser")
The PROBLEM:
We start ser via serctl (LD_LIBRARY_PATH needed) and we restart mysql.
If a new REGISTER comes to SER and then SER tries to write to MySQL,
we get the following error mesgs :
Apr 13 14:30:23 ./ser[26040]: submit_query(): MySQL server has gone away
Apr 13 14:30:23 ./ser[26040]: db_insert: Error while submitting query
Apr 13 14:30:23 ./ser[26040]: db_insert_ucontact(): Error while inserting contact
Apr 13 14:30:23 ./ser[26040]: insert_ucontact(): Error while inserting in database
Seems like SER's MySQL module does not auto-reconnect to MySQL server.
Please let us know what you need to further trace the issue.
thanks in advance for your help,
Jan Janak wrote:
Yes, there was a change in the mysql client library in
5.x. Try to use
the latest stable SER version (0.9.6), the re-connect problem should be
fixed there.
Jan.
Leo Papadopoulos wrote:
--
Kostas Marneris
e-mail: K.Marneris(a)otenet.gr
Tel : +30-210-6151886
John,
I just saw that message today as well. I had to restart SER. I didn't know
what it was, but I would be like to know if you find a solution. This seems
to have something to do with the newest version of MySQL I think. I am
running v5.0.18 for the first time. This does not happen on MySQL v4.1.16.
Leo P.
________________________________________
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of "???"
Sent: Friday, March 31, 2006 9:01 AM
To: serusers(a)lists.iptel.org
Subject: [Serusers] ERROR message : MySQL server has gone away
please help.....
If i restart MySQL(version 5.0.19), SER shows next error message.
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): MySQL
server has gone away
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): Error
while submitting query
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: get_ha1(): Error while
querying database
Mar 31 22:37:22 localhost /usr/local/sbin/ser[32703]: Binding
'1234@192.9.2.1','sip:1234@192.9.2.11:5060' has expired
As appear in upside message, SER does not auto-reconnect to mysql.
If MySQL restarted, SER must be able to do Auto-Reconnect.
Is no there way that SER can do Auto-Reconnect to MySQL?
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
3:01 p.m.
Kostas,
Kali Mera!!!
I am running FC5. I actually have configured SER to automatically start in
my init.d (let me know if you want to know how to do this) directory. After
the server boots up, I restart SER. Then it all works. I know this is not a
solution, but it can get you working. I think the key is to restart SER
AFTER the MySQL service starts.
Leo P.
-----Original Message-----
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of Kostas Marneris
Sent: Thursday, April 13, 2006 7:40 AM
To: Jan Janak; serusers(a)lists.iptel.org
Cc: kzorba(a)otenet.gr; Leo Papadopoulos; john.han(a)tuwise.com
Subject: Re: [Serusers] ERROR message : MySQL server has gone away
Greetings to the list.
We have a setup with ser-0.9.6 and mysql-5.0.19.
We have compiled everything from sources and we used mysql-5.0.19 sources
from
MySQL. Our x86 servers run Debian Sarge.
We have installed everything under /opt and we linked ser with the
mysql client libs under /opt/mysql/lib. There is no other installation
of MySQL (clients or development files).
In ser.cfg, we have the following mysql URIs:
fifo_db_url="mysql://ser:XXXXX@<IP_of_MySQL>/ser"
modparam("usrloc", "db_url",
"mysql://ser:XXXXX@<IP_of_MySQL>/ser")
The PROBLEM:
We start ser via serctl (LD_LIBRARY_PATH needed) and we restart mysql.
If a new REGISTER comes to SER and then SER tries to write to MySQL,
we get the following error mesgs :
Apr 13 14:30:23 ./ser[26040]: submit_query(): MySQL server has gone away
Apr 13 14:30:23 ./ser[26040]: db_insert: Error while submitting query
Apr 13 14:30:23 ./ser[26040]: db_insert_ucontact(): Error while inserting
contact
Apr 13 14:30:23 ./ser[26040]: insert_ucontact(): Error while inserting in
database
Seems like SER's MySQL module does not auto-reconnect to MySQL server.
Please let us know what you need to further trace the issue.
thanks in advance for your help,
Jan Janak wrote:
--
Kostas Marneris
e-mail: K.Marneris(a)otenet.gr
Tel : +30-210-6151886
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
Yes, there was a change in the mysql client library in
5.x. Try to use
the latest stable SER version (0.9.6), the re-connect problem should be
fixed there.
Jan.
Leo Papadopoulos wrote:
>John,
>
>I just saw that message today as well. I had to restart SER. I didn't know
>what it was, but I would be like to know if you find a solution. This
seems
>to have something to do with the newest version of
MySQL I think. I am
>running v5.0.18 for the first time. This does not happen on MySQL v4.1.16.
>
>Leo P.
>
>________________________________________
>From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
>Behalf Of "???"
>Sent: Friday, March 31, 2006 9:01 AM
>To: serusers(a)lists.iptel.org
>Subject: [Serusers] ERROR message : MySQL server has gone away
>
>please help.....
>
>
>If i restart MySQL(version 5.0.19), SER shows next error message.
>
>
>
>Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query():
MySQL
>server has gone away
>Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query():
Error
>while submitting query
>Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: get_ha1(): Error
while
querying
database
Mar 31 22:37:22 localhost /usr/local/sbin/ser[32703]: Binding
'1234@192.9.2.1','sip:1234@192.9.2.11:5060' has expired
As appear in upside message, SER does not auto-reconnect to mysql.
If MySQL restarted, SER must be able to do Auto-Reconnect.
Is no there way that SER can do Auto-Reconnect to MySQL?
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
6585
days inactive
6598
days old
4 comments
4 participants
participants (4)
-
"한승전" -
Jan Janak -
Kostas Marneris -
Leo Papadopoulos