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:[EMAIL PROTECTED] 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
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
