[Freeswitch-users] Mod_easyroute w/postgresql-odbc Cannot Find Data Source Name and Default Driver

[Nyamul Hassan]

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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100808/b83b98ca/attachment.html