[asterisk-users] ODBC Voicemail storage
tlesher at digium.com
Wed Aug 25 09:20:11 CDT 2010
On Wednesday 25 August 2010 07:27:58 Andraž wrote:
> I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage
> (FreeTDS -> Mssql 2008 database). Everything it's working fine, but
> sometimes I receive this error and Asterisk crashes.
> [Aug 25 13:25:13] WARNING app_voicemail.c: SQL Prepare
> failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk
> [Aug 25 13:25:13] WARNING res_odbc.c: SQL Prepare failed.
> Attempting a reconnect...
> [Aug 25 13:25:13] NOTICE res_odbc.c: Connecting sqlserver
> [Aug 25 13:25:13] NOTICE res_odbc.c: res_odbc: Connected to
> sqlserver [kupalaodbc]
> Regards Andraž
Did you enable pooling in res_odbc.conf? It is mandatory when connecting to
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org
More information about the asterisk-users