[OpenSER-Users] Help with unixODBC + sqlite driver

kionez kionez at anche.no
Thu Nov 22 09:18:22 CET 2007


#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.




More information about the sr-users mailing list