[Users] Openser with unixODBC + sqlite driver

Sylvain Boily sboily at proformatique.com
Sat Apr 21 13:39:56 CEST 2007


Hi,

I would like to connect openser 1.2 to sqlite db with unixodbc. I have installed unixodbc et sqlite driver and i configure openser.cfg but it doesn't working.
I seems the configuration wants user:password at ip but for sqlite there no need this.
I have testing lot off configuration but it doesn't work.

My configuration and log :

File /etc/odbc.ini 

[mysqlitedb]
Description     = SQLite
Driver          = SQLite
Database        = /tmp/mytest.db
Timeout         = 100000
StepAPI         = No
NoWCHAR         = No
LongNames       = No

File /etc/odbcinst.ini

[SQLite]
Description     = SQLite ODBC Driver
Driver          = /usr/lib/odbc/libsqliteodbc.so
Setup           = /usr/lib/odbc/libsqliteodbc.so
UsageCount      = 1

File /etc/openser/openser.cfg

loadmodule "unixodbc.so"
loadmodule "auth.so"
loadmodule "auth_db.so"
modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")
modparam("usrloc", "db_mode", 2)
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
modparam("rr", "enable_full_lr", 1)
modparam("usrloc|auth_db", "db_url","unixodbc://SQLite/mysqlitedb")

My log :

Apr 21 13:33:25 sylvain-desktop /usr/sbin/openser[24539]: AUTH module - initializing 
Apr 21 13:33:25 sylvain-desktop /usr/sbin/openser[24539]: AUTH_DB module - initializing 
Apr 21 13:33:25 sylvain-desktop /usr/sbin/openser[24539]: ERROR:unixodbc:new_connection: failed to connect 
Apr 21 13:33:25 sylvain-desktop /usr/sbin/openser[24539]: register_udomain(): Can not open database connection 
Apr 21 13:33:25 sylvain-desktop /usr/sbin/openser[24539]: domain_fixup(): Error while registering domain 
Apr 21 13:33:25 sylvain-desktop /usr/sbin/openser[24539]: ERROR: fix_actions: fixing failed (code=-1) at cfg line 148 
Apr 21 13:33:25 sylvain-desktop /usr/sbin/openser[24539]: INFO:mi_fifo:mi_destroy: process hasn't been created -> nothing to kill

Thank for your help.
Sylvain






More information about the Users mailing list