Problem connecting to Spidermonkey ODBC
Hi, I know there are a lot of answered questions about this already, but I think I read all of the answers and I'm still stuck. * I'm using FreeSWITCH Version 1.0.trunk (14961). * I installed UnixODBC * My odbc.ini and odbcinst.ini files are in /usr/local/etc/ * I have symlinks to /usr/local/etc from /usr/etc and from /usr/local/freeswitch/etc/ * Im running freeswitch as root, and I copied odbc.ini to /root/.odbc.ini * I have mod_spidermonkey_odbc uncommented in spidermonkey.conf.xml * When I run "isql dbname" from the command prompt it works fine. But when I try to run my script, I get: 2009-10-17 23:56:21.848930 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2009-10-17 23:56:21.848930 [ERR] mod_spidermonkey_odbc.c:245 Database is not connected! Please help! Thanks.
How are you using this from your javascript code? /b On Oct 17, 2009, at 7:13 PM, Adam Wilt wrote:
2009-10-17 23:56:21.848930 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2009-10-17 23:56:21.848930 [ERR] mod_spidermonkey_odbc.c:245 Database is not connected!
Brian, Here's how I'm using the ODBC in my .js file: use("ODBC"); var DSN="mydsn"; var DB_USER="myuser"; var DB_PASS="mypass"; . . . var db = new ODBC(DSN, DB_USER, DB_PASS); db.connect(); . . . Thanks. On Sat, Oct 17, 2009 at 8:56 PM, Brian West <brian@freeswitch.org> wrote:
How are you using this from your javascript code?
/b
On Oct 17, 2009, at 7:13 PM, Adam Wilt wrote:
2009-10-17 23:56:21.848930 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2009-10-17 23:56:21.848930 [ERR] mod_spidermonkey_odbc.c:245 Database is not connected!
_______________________________________________ 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
So, where is FreeSWITCH looking for the odbc.ini file? I keep reading conflicting information, including /usr/local/freeswitch/etc/, /usr/local/etc, /usr/etc, /home/username/ On Sat, Oct 17, 2009 at 9:11 PM, Adam Wilt <wiltingtree@gmail.com> wrote:
Brian,
Here's how I'm using the ODBC in my .js file:
use("ODBC");
var DSN="mydsn"; var DB_USER="myuser"; var DB_PASS="mypass"; . . . var db = new ODBC(DSN, DB_USER, DB_PASS); db.connect(); . . .
Thanks.
On Sat, Oct 17, 2009 at 8:56 PM, Brian West <brian@freeswitch.org> wrote:
How are you using this from your javascript code?
/b
On Oct 17, 2009, at 7:13 PM, Adam Wilt wrote:
2009-10-17 23:56:21.848930 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2009-10-17 23:56:21.848930 [ERR] mod_spidermonkey_odbc.c:245 Database is not connected!
_______________________________________________ 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
Its in /etc/ or where ever your default is.. is FS running as root? /b On Oct 17, 2009, at 10:16 PM, Adam Wilt wrote:
So, where is FreeSWITCH looking for the odbc.ini file? I keep reading conflicting information, including /usr/local/ freeswitch/etc/, /usr/local/etc, /usr/etc, /home/username/
Yes, I have FreeSWITCH running as root. So the odbc.ini file should be in /etc/ ? How do you set the default? On Sat, Oct 17, 2009 at 11:26 PM, Brian West <brian@freeswitch.org> wrote:
Its in /etc/ or where ever your default is.. is FS running as root?
/b
On Oct 17, 2009, at 10:16 PM, Adam Wilt wrote:
So, where is FreeSWITCH looking for the odbc.ini file? I keep reading conflicting information, including /usr/local/ freeswitch/etc/, /usr/local/etc, /usr/etc, /home/username/
_______________________________________________ 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
Brian, Putting the odbc.ini and odbcinst.ini in /etc/ fixed the problem. Thanks. Thanks, Marc On Sat, Oct 17, 2009 at 11:26 PM, Brian West <brian@freeswitch.org> wrote:
Its in /etc/ or where ever your default is.. is FS running as root?
/b
On Oct 17, 2009, at 10:16 PM, Adam Wilt wrote:
So, where is FreeSWITCH looking for the odbc.ini file? I keep reading conflicting information, including /usr/local/ freeswitch/etc/, /usr/local/etc, /usr/etc, /home/username/
_______________________________________________ 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
participants (2)
-
Adam Wilt
-
Brian West