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
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org
pstn:213-799-1400