I think that my .bashrc is already correctly set:
export STARSQL=/usr/share/starsql
export ODBC=$STARSQL/odbc
export PATH=$PATH:/usr/local/pgsql/bin:$STARSQL/bin:$STARSQL/odbc/bin
export MANPATH=$MANPATH:$STARSQL/man
export
LD_LIBRARY_PATH=$STARSQL/lib:$ODBC/lib:$LD_LIBRARY_PATH:/usr/local/pgsql/lib
I checked nsodbc.so with ldd and found a dependency on
/usr/lib/libodbc.so instead of /usr/share/starsql/odbc/lib/libodbc.so.
Unfortunately, due to a 'lapsus mani' I corrupted the
/usr/share/starsql/odbc/lib while making a symlink and so I have to
reinstall Starsql.
I'll retry next monday and let you know the result.
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.
