Nobody replied to this in the last 3 weeks, I hope you have found your answer. I was stumped on this issue too, and fixed it following the wiki.
The basic test that I ran before anything was:
isql <dsn name> <user> <pass>
It was failing at first, then I tracked the error to incorrect "Database" in my "dsn" section of the "odbc.ini".
The "isql" command helped in troubleshooting the basic operation of ODBC outside of Freeswitch.
Hope you have resolved it by now.
Regards
HASSAN
On Sat, Jul 17, 2010 at 00:04, Jerry Richards
<jerry.richards@teotech.com> wrote:
I'm having trouble getting mod_easyroute to work with odbc postgresql.
Please see the error I am getting below. Is there someone who has done this
and could tell me what I'm doing wrong?
Here is the error I'm getting:
[ERR] switch_odbc.c:313 STATE IM002 CODE 0 ERROR: [unixODBC][Driver
Manager]Data source name not found, and no default driver specified
[CRIT] mod_easyroute.c:147 Cannot Open ODBC Database!
Here is my conf/autoload_configs/easyroute_conf.xml content:
<param name="db-username" value="postgres"/>
<param name="db-password" value="password"/>
<param name="db-dsn" value="ez:postgres:password"/>
Here is my odbc.ini content:
[ez]
Description = PostgreSQL Unicode
Driver = PostgreSQL Unicode
Trace = No
TraceFile = /home/TeoUser/db/psqlodbc.log
Database = ez
Servername = 127.0.0.1
UserName = postgres
Password = password
Port = 5432
ReadOnly = Yes
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
Here is my odbcinst.ini file content:
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
Thanks And Best Regards,
Jerry
_______________________________________________
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