On 10/16/2008 12:23 AM, Gayatri Kulkarni wrote:
when i run odbcinst -j on my system, it shows me 3 files: /usr/local/etc/odbc.ini /usr/local/etc/odbcinst.ini /root/.odbc.ini
When all these files are identical, i can successfully esatcblish the connection through my JS script What does it show on your system?
$ sudo -u freeswitch odbcinst -j unixODBC 2.2.11 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini USER DATA SOURCES..: /opt/freeswitch/.odbc.ini /etc/odbcinst.ini: [PostgreSQL ANSI] Description = PostgreSQL ODBC driver (ANSI version) Driver = /usr/lib/odbc/psqlodbca.so Setup = /usr/lib/odbc/libodbcpsqlS.so Debug = 0 CommLog = 1 UsageCount = 1 [PostgreSQL Unicode] Description = PostgreSQL ODBC driver (Unicode version) Driver = /usr/lib/odbc/psqlodbcw.so Setup = /usr/lib/odbc/libodbcpsqlS.so Debug = 0 CommLog = 1 UsageCount = 1 /etc/odbc.ini: [phone] Description = PostgreSQL Driver = PostgreSQL ANSI Trace = Yes TraceFile = /tmp/psqlodbc.log Database = phone Servername = localhost UserName = Password = Port = ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = /opt/freeswitch/.odbc.ini is an empty file
-- Regards, Gayatri Kulkarni
On Mon, Oct 13, 2008 at 7:22 PM, Rupa Schomaker <freeswitch-users@lists.rupa.com <mailto:freeswitch-users@lists.rupa.com>> wrote:
This seems to be dependent on how your ODBC is setup. On my system, using the debian supplied odbc, freeswitch is working just fine with /etc/odbc.ini.
On 10/13/2008 2:58 AM, Gayatri Kulkarni wrote: > To all those who are interested: > > Freeswitch uses *.odbc.ini* file to connect to the database and not the > {prefix for unixODBC}/etc/odbc.ini > *so make sure that one is right before you use("ODBC")* in your > applications; otherwise even if you can successfully connect to your DB > with the isql command, you wont be able to use it through your FS app. > > It's good to find out things on my own :) (time consuming though!) > > > -- > Regards, > Gayatri Kulkarni > > On Mon, Oct 13, 2008 at 11:21 AM, Gayatri Kulkarni > <xtpl.gayatri@gmail.com <mailto:xtpl.gayatri@gmail.com> <mailto:xtpl.gayatri@gmail.com <mailto:xtpl.gayatri@gmail.com>>> wrote: > > Like we have to add odbc-dsn as a parm name in the voicemail.xml for > voice mail, > do we ave to do add it somewhere for running it in javascript too? > > like i said before, i can successfully connect with same username, > password, DSN through isql utility > why does fs not find the DSN name? > > > -- > Regards, > Gayatri Kulkarni