Sylvain Boily wrote:
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@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
Hi Sylvain!
It's may be a bug/feature when ODBC return SQL_SUCCESS_WITH_INFO which
treat as error in current releases. It will be fixed in future releases
I hope (see
http://openser.org/pipermail/devel/2007-April/007070.html)
Now you can try comment "goto err" line 147 (for 1.2.0 release) in
odbc/my_con.c and reinstall module
--
CU,
Victor Gamov