Hi Martin,
Thanks for replying. I am using ser-0.9.6. How do I check the period of silence? I have also noticed that alias cannot be recorded/updated into mysql too. Looks like the problem is as you were referring. Which version has the fix? Where is the culprit?
Ling
----- Original Message ---- From: Martin Hoffmann hn@nvnc.de To: lin9k@yahoo.com Cc: serusers@lists.iptel.org Sent: Tuesday, July 1, 2008 11:33:58 PM Subject: Re: [Serusers] usrloc won't work after a couple days?
lin9k@yahoo.com wrote:
I have setup ser to run with mysql. At beginning, it worked fine that the mysql/ser/location table got the correct update. However, after 3 days the table won't get updated. When I enable the mysql log I cannot see any updating or inserting into that table. User registration is still working fine but just not get updated into the location table. Also, server_monitoring tables are working fine.
Do you have a longer period of silence in between? I seem to remember that there was a problem with the connection between SER and MySQL getting shut down and SER not reconnecting. Dunno if this was in the SER version you are using, though.
Regards, Martin
Ling, maybe the fix mentioned here solves your issue..
http://www.iptel.org/faq/why_does_my_mysql_5_0_x_connection_time_out_when_us...
I have mysql 5.0.54 and ser 0.9.7 and SER-Mysql connection is lost.., but I must to apply this patch (no tested yet)
Claudio
On Wed, Jul 2, 2008 at 3:50 AM, lin9k@yahoo.com wrote:
Hi Martin,
Thanks for replying. I am using ser-0.9.6. How do I check the period of silence? I have also noticed that alias cannot be recorded/updated into mysql too. Looks like the problem is as you were referring. Which version has the fix? Where is the culprit?
Ling
----- Original Message ---- From: Martin Hoffmann hn@nvnc.de To: lin9k@yahoo.com Cc: serusers@lists.iptel.org Sent: Tuesday, July 1, 2008 11:33:58 PM Subject: Re: [Serusers] usrloc won't work after a couple days?
lin9k@yahoo.com wrote:
I have setup ser to run with mysql. At beginning, it worked fine that the mysql/ser/location table got the correct update. However, after 3 days the table won't get updated. When I enable the mysql log I cannot see any updating or inserting into that table. User registration is still working fine but just not get updated into the location table. Also, server_monitoring tables are working fine.
Do you have a longer period of silence in between? I seem to remember that there was a problem with the connection between SER and MySQL getting shut down and SER not reconnecting. Dunno if this was in the SER version you are using, though.
Regards, Martin
Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
lin9k@yahoo.com wrote:
I am using ser-0.9.6. How do I check the period of silence? I have also noticed that alias cannot be recorded/updated into mysql too. Looks like the problem is as you were referring. Which version has the fix? Where is the culprit?
I think you want to change the wait_timeout variable of the MySQL server:
http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html#option_m...
For further details, please refer to the MySQL manual. Not my field of knowledge ;)
Regards, Martin
-
caio -
lin9k＠yahoo.com -
Martin Hoffmann