I have ODBC going to mysql on the same box as FS and I keep having issues where it is dropping and then coming back. Any ideas where this might be occurring or how to fix it? FYI, the connection is broken long before I get the error messages below. I actually get those when the connection comes back up. Again, all of this is on the same box, so it isn't a lan/wan issue or anything like that. I suspect I will get a "update to the latest", but I wanted to check if there are any known issues before I do that. freeswitch@freebert> version FreeSWITCH Version 1.0.trunk (9577) freeswitch@freebert> 2008-10-08 08:05:25 [CRIT] switch_odbc.c:248 db_is_up() The sql server is not responding for DSN freeswitch [STATE: 24000 CODE 0 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-log]Invalid cursor state ] 2008-10-08 08:05:25 [INFO] switch_odbc.c:253 db_is_up() The connection has been re-established
no you don't have to update? It's not always our fault when something won't work =D If the server connection breaks and the ODBC tells us so, those error messages are what we always do. You must have some conditions where the mysql driver is malfunctioning because I leave mine connected in a similar way and mine stays up. Are you connecting to mysql over the local unix domain socket? I have never had much luck with that. It works much better to just use an IP addr. Do you have the right version of the mysql plugin for ODBC?, there are a few bad ones out there. This error is just passed up to us from the mysql plugin "Invalid cursor state" maybe google for that and see what causes it. 2008-10-08 08:05:25 [CRIT] switch_odbc.c:248 db_is_up() The sql server is not responding for DSN freeswitch [STATE: 24000 CODE 0 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-log]
Invalid cursor state
On Wed, Oct 8, 2008 at 8:11 AM, peder@networkoblivion.com < peder@networkoblivion.com> wrote:
I have ODBC going to mysql on the same box as FS and I keep having issues where it is dropping and then coming back. Any ideas where this might be occurring or how to fix it? FYI, the connection is broken long before I get the error messages below. I actually get those when the connection comes back up. Again, all of this is on the same box, so it isn't a lan/wan issue or anything like that. I suspect I will get a "update to the latest", but I wanted to check if there are any known issues before I do that.
freeswitch@freebert> version FreeSWITCH Version 1.0.trunk (9577)
freeswitch@freebert> 2008-10-08 08:05:25 [CRIT] switch_odbc.c:248 db_is_up() The sql server is not responding for DSN freeswitch [STATE: 24000 CODE 0 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-log]Invalid cursor state ]
2008-10-08 08:05:25 [INFO] switch_odbc.c:253 db_is_up() The connection has been re-established
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
I was experiencing the same exact issue and I tracked it down to the MySQL interactive_timeout and wait_timeout variables. I had both of the variables set to 900 seconds, which was too low compared to the interval the phones are set to register with the server. Basically I discovered you need to set those two MySQL variables greater than the register interval of your phones. I just set mine to 2 hours (7200) since my phones register every hour and all is well. Cheers, Gabe peder@networkoblivion.com wrote:
I have ODBC going to mysql on the same box as FS and I keep having issues where it is dropping and then coming back. Any ideas where this might be occurring or how to fix it? FYI, the connection is broken long before I get the error messages below. I actually get those when the connection comes back up. Again, all of this is on the same box, so it isn't a lan/wan issue or anything like that. I suspect I will get a "update to the latest", but I wanted to check if there are any known issues before I do that.
freeswitch@freebert> version FreeSWITCH Version 1.0.trunk (9577)
freeswitch@freebert> 2008-10-08 08:05:25 [CRIT] switch_odbc.c:248 db_is_up() The sql server is not responding for DSN freeswitch [STATE: 24000 CODE 0 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-log]Invalid cursor state ]
2008-10-08 08:05:25 [INFO] switch_odbc.c:253 db_is_up() The connection has been re-established
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (3)
-
Anthony Minessale
-
Gabriel Kuri
-
peder＠networkoblivion.com