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