VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
xtpl.gayatri at gmail.com
Guest
|
 Posted: Mon Oct 13, 2008 3:08 am Post subject: [Freeswitch-users] ODBC through JS (To all interested:) |
 |
|
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 (xtpl.gayatri@gmail.com)> wrote:
| Quote: | 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
|
|
|
| Back to top |
|
 |
freeswitch-users at li...
Guest
|
| Posted: Mon Oct 13, 2008 9:01 am Post subject: [Freeswitch-users] ODBC through JS (To all interested:) |
|
|
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:
| Quote: | 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>> 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
------------------------------------------------------------------------
_______________________________________________
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
|
_______________________________________________
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 |
|
| Back to top |
|
|
xtpl.gayatri at gmail.com
Guest
|
| Posted: Thu Oct 16, 2008 12:30 am Post subject: [Freeswitch-users] ODBC through JS (To all interested:) |
|
|
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?
--
Regards,
Gayatri Kulkarni
On Mon, Oct 13, 2008 at 7:22 PM, Rupa Schomaker <freeswitch-users@lists.rupa.com (freeswitch-users@lists.rupa.com)> wrote:
| Quote: | 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:
| Quote: | 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
|
| Quote: | <xtpl.gayatri@gmail.com (xtpl.gayatri@gmail.com) <mailto:xtpl.gayatri@gmail.com (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
|
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (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
|
|
|
| Back to top |
|
|
freeswitch-users at li...
Guest
|
| Posted: Thu Oct 16, 2008 1:31 am Post subject: [Freeswitch-users] ODBC through JS (To all interested:) |
|
|
On 10/16/2008 12:23 AM, Gayatri Kulkarni wrote:
| Quote: | 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
| Quote: |
--
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:
| Quote: | To all those who are interested:
Freeswitch uses *.odbc.ini* file to connect to the database and
|
not the
| Quote: | {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
| Quote: | with the isql command, you wont be able to use it through your FS
|
app.
| Quote: |
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:
| Quote: |
Like we have to add odbc-dsn as a parm name in the
|
voicemail.xml for
| Quote: | 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
|
|
_______________________________________________
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 |
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
