[Freeswitch-users] ODBC Dropping

[Anthony Minessale]

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 at networkoblivion.com <
peder at 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 at freebert> version
> FreeSWITCH Version 1.0.trunk (9577)
>
> freeswitch at 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 at 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 at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:213-799-1400
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20081008/8e0b7b6c/attachment-0002.html