Mysql Timing Out With Odbc

[bill-r]

Gentlemen:

 

I have a problem with MySQL Connection timing out.

 

I am running Voiceguide 6.0.3386 Enterprise VGDialer 4 line license with a Dialogic D/41JCT-LS running Drivers Release SR5.11 version DNA5 Build 80 ServicePack1, and MySQL ODBC Driver 5.1 to connect to a MySQL Server version: 5.0.67-0ubuntu6 Protocol Version 10. You can see below an error of “MySQL server has gone away:ODBC.Database” I have tried adjusting the wait_timeout variable in mysql. Default is 28800 and tried 86400 and 34000000. The problem corrects itself if I close and then restart Voiceguide, but I don’t know if I am missing calls while MySQL has timed out.

 

081823.24 1 state [update Call Log] DB Query

081823.24 1 db Jet mode used (To use ODBC mode specify ODBC Connect string)

081823.25 1 rv replace start: [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('$RV_CIDNUMBER','$RV_DNIS',$RV_LINEID,'$RV_CIDNAME',$RV[system Welcome])]

081823.25 1 rvns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[$RV_STARTTIME]{5/12/2009 8:18:19 AM}[$RV_DEVICEID]{1}[DlgcNetworkResource]{dxxxB1C1}[DlgcVoiceResource]{dxxxB1C1}

[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\TRET3\}[scriptPath]{C:\Program Files\VoiceGuide\Scripts\TRET3\}[$RV_CIDNUMBER]{3607351900}[system Welcome]{8000}[system Welcome_PathTaken]{success}

081823.25 1 rv replace end: [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('3607351900','',1,'',8000)]

081823.25 1 db About to execute a Modify type operation [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('3607351900','',1,'',8000)]

081823.36 1 ERROR 6.0.3386 DB Execute: 3155,ODBC--insert on a linked table 'tblCallLog' failed.

081823.36 1 rv add [update Call Log_RowCount]{0}

081823.41 1 db DBEngine.Error 2006:[MySQL][ODBC 5.1 Driver][mysqld-5.0.67-0ubuntu6]MySQL server has gone away:ODBC.Database

081823.41 1 db DBEngine.Error 3155:ODBC--insert on a linked table 'tblCallLog' failed.:DAO.Database

 

Any help would be appreciated.

 

[bill-r]

Gentlemen:

 

Additional Info: I have the same problem whether I use System or User DNS. I also have the “Enable Automatic Reconnect” box checked in the ODBC configuration under Details Flag 1.

 

I have a problem with MySQL Connection timing out.

 

I am running Voiceguide 6.0.3386 Enterprise VGDialer 4 line license with a Dialogic D/41JCT-LS running Drivers Release SR5.11 version DNA5 Build 80 ServicePack1, and MySQL ODBC Driver 5.1 to connect to a MySQL Server version: 5.0.67-0ubuntu6 Protocol Version 10. You can see below an error of “MySQL server has gone away:ODBC.Database” I have tried adjusting the wait_timeout variable in mysql. Default is 28800 and tried 86400 and 34000000. The problem corrects itself if I close and then restart Voiceguide, but I don’t know if I am missing calls while MySQL has timed out.

 

081823.24 1 state [update Call Log] DB Query

081823.24 1 db Jet mode used (To use ODBC mode specify ODBC Connect string)

081823.25 1 rv replace start: [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('$RV_CIDNUMBER','$RV_DNIS',$RV_LINEID,'$RV_CIDNAME',$RV[system Welcome])]

081823.25 1 rvns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[$RV_STARTTIME]{5/12/2009 8:18:19 AM}[$RV_DEVICEID]{1}[DlgcNetworkResource]{dxxxB1C1}[DlgcVoiceResource]{dxxxB1C1}

[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\TRET3\}[scriptPath]{C:\Program Files\VoiceGuide\Scripts\TRET3\}[$RV_CIDNUMBER]{3607351900}[system Welcome]{8000}[system Welcome_PathTaken]{success}

081823.25 1 rv replace end: [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('3607351900','',1,'',8000)]

081823.25 1 db About to execute a Modify type operation [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('3607351900','',1,'',8000)]

081823.36 1 ERROR 6.0.3386 DB Execute: 3155,ODBC--insert on a linked table 'tblCallLog' failed.

081823.36 1 rv add [update Call Log_RowCount]{0}

081823.41 1 db DBEngine.Error 2006:[MySQL][ODBC 5.1 Driver][mysqld-5.0.67-0ubuntu6]MySQL server has gone away:ODBC.Database

081823.41 1 db DBEngine.Error 3155:ODBC--insert on a linked table 'tblCallLog' failed.:DAO.Database

 

Any help would be appreciated.

 

[SupportTeam]

The ODBC driver reports that the "MySQL server has gone away", so this question should really be asked of the ODBC driver supplier. The ODBC driver should be ensuring that it can communicate with the database.

 

Looks like you are using a Database Query module form within the VoiceGuide script to access the database, and in v6 VoiceGuide would be trying to establish a new database connection from each new Database Query module within the script. So this is not an issue with a database connection timing out, but with a new database connection unable to be established. ODBC drivers tracing and maybe MySQL tracing should let you better see why ODBC driver was not able to setup a new DB connection.

 

Searching "MySQL server has gone away" on Google brings up a number of hits so maybe some of those would explain what is happening with the ODBC driver on your system.

 

Also if you are using a D/41JCT card then you may want to use VoiceGuide v7. Then you can use ADO.NET database connectivity instead of ODBC (although you can still use ODBC in v7).