|
Guys, Im trying to use unixodbc.so to connect to a Sybase database
using Sybase native ODBC drivers. This is the entry that I have on: /etc/odbc.ini: [SYBASE] Description
= Sybase ODBC Data Source UserID
= username Password
= passwd Driver
= ASE Server
= xx.xx.xx.xx Port
= 5000 Database
= database UseCursor
= 1 /etc/odbcinst.ini ============ [ASE] Description
= Sybase ODBC Driver Driver
= /opt/sybase/ODBC-12_5/lib/libsybdrvodb.so FileUsage
= -1 UsageCount
= 1 The database is on a remote host. I can connect from the
openser server using unixodbc’s isql tool, as such: [EMAIL PROTECTED] openser]# isql SYBASE username passwd +---------------------------------------+ |
Connected!
| |
| |
sql-statement
| | help
[tablename]
| |
quit
| |
| +---------------------------------------+ SQL> This proves that unixodbc is installed correctly and that
the Sybase odbc driver is installed and functioning properly. However when I try to run openser (debug=4) I get the
following: 0(0) fixing /usr/local/lib/openser/modules/auth_db.so
www_authorize 0(0) db_init: Connection
'unixodbc://manager:[EMAIL PROTECTED]/SYBASE' not found in pool Failed to connect The driver reported the following diagnostics whilst running
SQLDriverConnect 0(0) auth_db:str_fixup: Unable to open database
connection 0(0) ERROR: fix_expr : fix_actions error ERROR: error -1 while trying to fix configuration 0(0) XLOG: destroy module ... 0(0) DEBUG: tm_shutdown : start 0(0) DEBUG: unlink_timer_lists : emptying DELETE list 0(0) DEBUG: tm_shutdown : emptying hash table 0(0) DEBUG: tm_shutdown : releasing timers 0(0) DEBUG: tm_shutdown : removing semaphores 0(0) DEBUG: tm_shutdown : destroying tmcb lists 0(0) DEBUG: tm_shutdown : done 0(22871) shm_mem_destroy 0(22871) destroying the shared memory lock [EMAIL PROTECTED] openser]# This is a snippet of my openser.cfg ------------------------------START-------------------------------- debug=4 fork=no log_stderror=yes listen=yy.yy.yy.yy port=5060 children=4 server_signature=no dns=no rev_dns=no check_via=no syn_branch=yes memlog=1000 sip_warning=no fifo_mode=0666 fifo="/tmp/openser_fifo" fifo_db_url="unixodbc://username:[EMAIL PROTECTED]/SYBASE" reply_to_via=no loadmodule
"/usr/local/lib/openser/modules/mysql.so" loadmodule
"/usr/local/lib/openser/modules/postgres.so" loadmodule
"/usr/local/lib/openser/modules/unixodbc.so" loadmodule "/usr/local/lib/openser/modules/sl.so" loadmodule "/usr/local/lib/openser/modules/tm.so" loadmodule "/usr/local/lib/openser/modules/rr.so" loadmodule
"/usr/local/lib/openser/modules/maxfwd.so" loadmodule
"/usr/local/lib/openser/modules/usrloc.so" loadmodule "/usr/local/lib/openser/modules/registrar.so" loadmodule "/usr/local/lib/openser/modules/acc.so" loadmodule
"/usr/local/lib/openser/modules/auth.so" loadmodule
"/usr/local/lib/openser/modules/auth_db.so" loadmodule
"/usr/local/lib/openser/modules/auth_radius.so" loadmodule "/usr/local/lib/openser/modules/uri.so" loadmodule
"/usr/local/lib/openser/modules/uri_radius.so" loadmodule
"/usr/local/lib/openser/modules/mediaproxy.so" loadmodule
"/usr/local/lib/openser/modules/nathelper.so" loadmodule
"/usr/local/lib/openser/modules/textops.so" loadmodule "/usr/local/lib/openser/modules/domain.so" loadmodule
"/usr/local/lib/openser/modules/avpops.so" loadmodule
"/usr/local/lib/openser/modules/avp_radius.so" loadmodule
"/usr/local/lib/openser/modules/permissions.so" loadmodule
"/usr/local/lib/openser/modules/xlog.so" loadmodule
"/usr/local/lib/openser/modules/options.so" #loadmodule
"/usr/local/lib/openser/modules/group.so" loadmodule
"/usr/local/lib/openser/modules/speeddial.so" loadmodule
"/usr/local/lib/openser/modules/group_radius.so" modparam("usrloc", "db_mode", 0) modparam("usrloc", "timer_interval", 60) modparam("usrloc", "desc_time_order", 1) modparam("permissions", "db_mode", 1) modparam("permissions", "trusted_table",
"trusted") modparam("permissions",
"default_allow_file", "/etc/ser/permissions.allow") modparam("permissions",
"default_deny_file", "/etc/ser/permissions.deny") modparam("usrloc|auth_db", "db_url",
"unixodbc://username:[EMAIL PROTECTED]/SYBASE") ---------------------------------END----------------------------------------- Any suggestions? Lenir |
_______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
