VoIP Mailing List Archives

[peder at networkoblivi...]

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 at g...]

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]

[gkuri at ieee.org]

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: