[Freeswitch-users] ODBC Dropping

[Gabriel Kuri]

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 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
>