Skip to Content
0
Former Member
Feb 13, 2009 at 04:18 PM

BO set env. vars during setup? Using Datadirect => MySQL

242 Views

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>