Hi,
Does BO sets his own env. vars during setup/startup?
I'm running BOXI 3.1 on RHEL 5 with a MySQL datastore. I tried for ages to setup unixODBC but entered a cul de sac. I then used DataDirect (DD) and their support has been great.
DD support there said i need to ensure that the env. vars for my DD driver are still being set (LD_LIBRARY_PATH, ODBCINI, PATH and ODBCINST). Haven't changed, see below.
I have a screenshot of my error in BO when trying to do a data refresh.
[ http://docs.google.com/Doc?id=dfr8cvrq_181fkgw79fj]
Quote:
Since Driver Manager UnixODBC is being used, I assume BO also set the LD_LIBRARY_PATH. See the Error Attached when I try to do a refresh of a report in the CMC.
You can only use 1 DM at the same time, the one that is first on the line of the LD_LIBRARY_PATH env. var is being used.
Therefore, you must make sure that u201C/opt/odbc32v53/libu201D is at the beginning of the LD_LIBRARY_PATH path.
If the path of the UnixODBC DM comes before the DataDirect DM, UnixODBC DM is being used which is not allowed with our drivers.
Is BO still referring to the odbc.ini in the bobje folder?
my env
[root@moran lib]# env
SSH_AGENT_PID=3652
HOSTNAME=moran.anam.com
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
ODBCINST=/opt/odbc32v53/odbcinst.ini
GTK_RC_FILES=/etc/gtk/gtkrc:/home/eberwick/.gtkrc-1.2-gnome2
WINDOWID=50570380
OLDPWD=/opt/odbc32v53
LC_ALL=en_US.utf8
USER=eberwick
LD_LIBRARY_PATH=/opt/odbc32v53/lib
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:.cmd=00;32:.exe=00;32:.com=00;32:.btm=00;32:.bat=00;32:.sh=00;32:.csh=00;32:.tar=00;31:.tgz=00;31:.arj=00;31:.taz=00;31:.lzh=00;31:.zip=00;31:.z=00;31:.Z=00;31:.gz=00;31:.bz2=00;31:.bz=00;31:.tz=00;31:.rpm=00;31:.cpio=00;31:.jpg=00;35:.gif=00;35:.bmp=00;35:.xbm=00;35:.xpm=00;35:.png=00;35:.tif=00;35:
SSH_AUTH_SOCK=/tmp/ssh-YZKCNF3616/agent.3616
GNOME_KEYRING_SOCKET=/tmp/keyring-78Gh0M/socket
USERNAME=eberwick
SESSION_MANAGER=local/moran.anam.com:/tmp/.ICE-unix/3616
DESKTOP_SESSION=default
PATH=/opt/odbc32v53/tools:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/eberwick/Desktop/jdk/bin:/home/eberwick/bin:/home/eberwick/Desktop/jdk/bin
MAIL=/var/spool/mail/eberwick
GDM_XSERVER_LOCATION=local
PWD=/opt/odbc32v53/lib
INPUTRC=/etc/inputrc
XMODIFIERS=@im=none
JAVA_HOME=/home/eberwick/Desktop/jdk/bin
LANG=en_US.UTF-8
GDMSESSION=default
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/root
SHLVL=3
ODBCINI=/opt/odbc32v53/odbc.ini
GNOME_DESKTOP_SESSION_ID=Default
LOGNAME=eberwick
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-L3KjIa0g0t,guid=c4ab76a555397f41daf10600498c4e78
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
XAUTHORITY=/root/.xauthn5fyU8
COLORTERM=gnome-terminal
_=/usr/bin/env<a href=""></a>