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