[OpenSER-Users] unixODBC and SQLite???

Douglas Garstang dougmig33 at yahoo.com
Fri Mar 21 21:23:10 CET 2008


/etc/odbc.ini:
[sqlite1]
Description     = SQLite
Driver          = SQLite
Database        = /root/test.db
Timeout         = 9000
Trace           = Yes
TraceFile       = /tmp/sqlite.log

/etc/odbcinst.ini:
[SQLite]
Description     = SQLite ODBC Driver
Driver      = /usr/local/lib/libsqlite3odbc.so
Setup       = /usr/local/lib/libsqlite3odbc.so

openser.cfg:
modparam("avpops", "db_url", "unixodbc://localhost/sqlite1")

What's the correct format for specifying the DSN when using SQLite with ODBC?
SQLite doesn't use a user/password or host.

I tried the above, "unixodbc://localhost/sqlite1" and openser barfs with:
ERROR:unixodbc:new_connection: failed to connect

I also tried:
modparam("avpops", "db_url", "unixodbc://sqlite1")

and openser barfed with:
new_db_id: Error while parsing database URL: unixodbc://sqlite1

What's the correct format? Is it even supported in Openser 1.2.0?

Thanks,
Doug





      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080321/dafa8b43/attachment.htm 


More information about the Users mailing list