Finally I succeeded connecting Aolsever to a DB2/400 via nsodbc and Starsql.
The problem was that I have to start the nsd process as root to bind the
port 80, but as root the environment variable STARSQL and
LD_LIBRARY_PATH was not set.
Tom Jackson ha scritto:
On Saturday 16 September 2006 07:35, Claudio Pasolini wrote:
During Aolserver startup i get this error and I don't know how to proceed.
[-main-] Notice: dbdrv: opening database 'odbc:DB2PROD'
[-main-] Notice: odbc[pool4]: attemping to open 'DB2PROD'
[-main-] Error: odbc[pool4]: odbc message: SQLSTATE = 01000, Native err =
0, msg = '[unixODBC][Driver Manager]Can't open lib
'/usr/share/starsql/lib/libSWODBC.so' : libSQLPARSER.so: cannot open shared
object file: No such file or directory'
[-main-] Error: dbdrv: failed to open database 'odbc:DB2PROD'
Apparently the driver manager is pointing to libSWODBC.so and
libSQLPARSER.so and both exist and are readable.
You probably have to set your LD_LIBRARY_PATH= /dir/where/libSQLPARSER.so/is
maybe = (/usr/share/starsql/lib)?
do this in your startup script for instance:
#!/bin/bash
sleep 4
export HOMEDIR=/web/nsd45
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export TNS_ADMIN=/home/tom/ADMIN
export ORACLE_SID=vs
export JAVA_HOME=/usr/java/current
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT=YYYY-MM-DD
# /u01/app/oracle/product/10.2.0/db_1/lib
export
PATH=/bin:/local/bin:/usr/bin:/usr/local/bin:$ORACLE_HOME/bin:$HOMEDIR/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/web/nsd45/lib:/web/m2/lib
exec 2>&1
exec $HOMEDIR/bin/nsd -ft /web/vs/trunk/aolserver-parameters/tom.tcl -u tom -B
"/web/vs/trunk/aolserver-parameters/bind-tom.txt"
\
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.