#include <Henning Westerholt.h> // created 21/11/2007 19:06
try to increate the debug level in the openser config (debug=9), to get more hints about the error. You could post some relevant parts of this output to the list. Also look into the unixodbc log, if there is one. What version of openser ("openser -V") do you use?
version of softwares: openser: 1.2.2-notls (from debian and from source) sqlite: 3.4.2 (from debian) or 3.5.2 (from source) unixodbc: 2.2.11 (from debian) or 2.2.12 (from source) sqliteodbc: 0.76 (from source)
and here the relevant parts of configs:
- /etc/openser/openser.cfg
debug=9 log_stderror=yes fork=no
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")
- /etc/odbcinst.ini
[ODBC] Trace = yes TraceFile = /tmp/unixodbc.log
[SQLite] Description = SQLite ODBC Driver Driver = /usr/local/lib/libsqlite3odbc.so Setup = /usr/local/lib/libsqlite3odbc.so
- /etc/odbc.ini
[mysqlitedb] Description = SQLite Driver = SQLite Database = /tmp/mytest.db Timeout = 20000
and now, the relevant part of output: # openser
0(0) db_init: Connection 'unixodbc://SQLite/mysqlitedb' not found in pool 0(0) DEBUG:unixodbc:build_conn_str: connection string is <DSN=mysqlitedb;PWD=;> 0(0) ERROR:unixodbc:new_connection: failed to connect 0(0) register_udomain(): Can not open database connection 0(0) domain_fixup(): Error while registering domain 0(0) ERROR: fix_actions: fixing failed (code=-1) at cfg line 144 ERROR: error -1 while trying to fix configuration
k.