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@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of "???" Sent: Friday, March 31, 2006 9:01 AM To: serusers@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

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@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@lists.iptel.org Cc: kzorba@otenet.gr; Leo Papadopoulos; john.han@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:

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@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of "???" Sent: Friday, March 31, 2006 9:01 AM To: serusers@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers