Hi, Can anyone please tell me why I am getting this error inspite 'isql -v smepbx smepbx smeswitch' was working. [CRIT] switch_core_sqldb.c:433 Failure! ODBC NOT AVAILABLE! Can't connect to DSN smepbx Regards, Archana.V
ODBC NOT AVAILABLE
This means your FS was compiled without ODBC support. Check you have the unixodbc development package installed when building (usually unixodbc-dev or unixodbc-devel). It should be auto-detected if installed, but to be sure run configure with the --enable-core-odbc-support to force it to look for it, that'll should then give you an error if it can't find it. There has also been some changes to DSNs since v1.2.4 of which you should be aware. DSNs of format "datasourcename" are no longer supported. They should be changed to one of: "datasourcename::" "datasourcename:username:password" "odbc://datasourcename" "odbc://datasourcename::" "odbc://datasourcename:username:password" http://wiki.freeswitch.org/wiki/DSN I prefer using the odbc:// prefix - it seems less likely that it would change long-term -Steve On 16 December 2012 20:55, Archana Venugopan <a.venugopan@mundio.com> wrote:
Hi,****
Can anyone please tell me why I am getting this error inspite ‘isql –v smepbx smepbx smeswitch’ was working. ****
** **
** **
[CRIT] switch_core_sqldb.c:433 Failure! ODBC NOT AVAILABLE! Can't connect to DSN smepbx****
** **
Regards,****
Archana.V****
** **
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Thanks again. ODBC was the issue. Regards, Archana.V From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Steven Ayre Sent: 17 December 2012 11:42 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] ODBC error ODBC NOT AVAILABLE This means your FS was compiled without ODBC support. Check you have the unixodbc development package installed when building (usually unixodbc-dev or unixodbc-devel). It should be auto-detected if installed, but to be sure run configure with the --enable-core-odbc-support to force it to look for it, that'll should then give you an error if it can't find it. There has also been some changes to DSNs since v1.2.4 of which you should be aware. DSNs of format "datasourcename" are no longer supported. They should be changed to one of: "datasourcename::" "datasourcename:username:password" "odbc://datasourcename" "odbc://datasourcename::" "odbc://datasourcename:username:password" http://wiki.freeswitch.org/wiki/DSN I prefer using the odbc:// prefix - it seems less likely that it would change long-term -Steve On 16 December 2012 20:55, Archana Venugopan <a.venugopan@mundio.com<mailto:a.venugopan@mundio.com>> wrote: Hi, Can anyone please tell me why I am getting this error inspite 'isql -v smepbx smepbx smeswitch' was working. [CRIT] switch_core_sqldb.c:433 Failure! ODBC NOT AVAILABLE! Can't connect to DSN smepbx Regards, Archana.V _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Great :) Did that fix the problem? Just a thought for the core devs... Since ODBC is now so popular perhaps rather than auto-detecting unixodbc it'd be better to have it enabled by default and give an error if it's missing? For anyone still wanting to build without it (eg for embedded systems) add a --disable-core-odbc-support option. -Steve On 17 December 2012 12:32, Archana Venugopan <a.venugopan@mundio.com> wrote:
Thanks again. ODBC was the issue.****
** **
Regards,****
Archana.V****
** **
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Steven Ayre *Sent:* 17 December 2012 11:42 *To:* FreeSWITCH Users Help *Subject:* Re: [Freeswitch-users] ODBC error****
** **
ODBC NOT AVAILABLE****
** **
This means your FS was compiled without ODBC support.****
** **
Check you have the unixodbc development package installed when building (usually unixodbc-dev or unixodbc-devel).****
** **
It should be auto-detected if installed, but to be sure run configure with the --enable-core-odbc-support to force it to look for it, that'll should then give you an error if it can't find it.****
** **
** **
** **
There has also been some changes to DSNs since v1.2.4 of which you should be aware.****
** **
DSNs of format "datasourcename" are no longer supported. They should be changed to one of:****
"datasourcename::"****
"datasourcename:username:password"****
"odbc://datasourcename"****
"odbc://datasourcename::"****
"odbc://datasourcename:username:password"****
** **
http://wiki.freeswitch.org/wiki/DSN****
** **
I prefer using the odbc:// prefix - it seems less likely that it would change long-term ****
** **
-Steve****
** **
** **
On 16 December 2012 20:55, Archana Venugopan <a.venugopan@mundio.com> wrote:****
Hi,****
Can anyone please tell me why I am getting this error inspite ‘isql –v smepbx smepbx smeswitch’ was working. ****
****
****
[CRIT] switch_core_sqldb.c:433 Failure! ODBC NOT AVAILABLE! Can't connect to DSN smepbx****
****
Regards,****
Archana.V****
****
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org****
** **
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Ya it did fixed the problem. Just installed this unixodbc-devel. Regards, Archana.V From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Steven Ayre Sent: 17 December 2012 14:51 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] ODBC error Great :) Did that fix the problem? Just a thought for the core devs... Since ODBC is now so popular perhaps rather than auto-detecting unixodbc it'd be better to have it enabled by default and give an error if it's missing? For anyone still wanting to build without it (eg for embedded systems) add a --disable-core-odbc-support option. -Steve On 17 December 2012 12:32, Archana Venugopan <a.venugopan@mundio.com<mailto:a.venugopan@mundio.com>> wrote: Thanks again. ODBC was the issue. Regards, Archana.V From: freeswitch-users-bounces@lists.freeswitch.org<mailto:freeswitch-users-bounces@lists.freeswitch.org> [mailto:freeswitch-users-bounces@lists.freeswitch.org<mailto:freeswitch-users-bounces@lists.freeswitch.org>] On Behalf Of Steven Ayre Sent: 17 December 2012 11:42 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] ODBC error ODBC NOT AVAILABLE This means your FS was compiled without ODBC support. Check you have the unixodbc development package installed when building (usually unixodbc-dev or unixodbc-devel). It should be auto-detected if installed, but to be sure run configure with the --enable-core-odbc-support to force it to look for it, that'll should then give you an error if it can't find it. There has also been some changes to DSNs since v1.2.4 of which you should be aware. DSNs of format "datasourcename" are no longer supported. They should be changed to one of: "datasourcename::" "datasourcename:username:password" "odbc://datasourcename" "odbc://datasourcename::" "odbc://datasourcename:username:password" http://wiki.freeswitch.org/wiki/DSN I prefer using the odbc:// prefix - it seems less likely that it would change long-term -Steve On 16 December 2012 20:55, Archana Venugopan <a.venugopan@mundio.com<mailto:a.venugopan@mundio.com>> wrote: Hi, Can anyone please tell me why I am getting this error inspite 'isql -v smepbx smepbx smeswitch' was working. [CRIT] switch_core_sqldb.c:433 Failure! ODBC NOT AVAILABLE! Can't connect to DSN smepbx Regards, Archana.V _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (2)
-
Archana Venugopan
-
Steven Ayre