Hi Vistor,
the SQL_SUCCESS_WITH_INFO issue was fixed on devel version ~ one week
ago. Also I just backported the fix to 1.2.0 and 1.1.x
Thanks and regards,
bogdan
Victor Gamov wrote:
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:[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
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
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
