RedHat 64 bit install

server administration XI Server Discussion
1

I have been pulling my hair out on a RedHat 64 bit install. Yes installed MySQl and all the 32 bit drivers, tried commercial and the GA versions but nothing works for CRS2008. 32 bit unixODBC and isql etc are all fine though so it is not a connectivity issue.

I have also duplicated the install to RedHat 32 bit but it doesn’t seem to make any difference.

The .bash_profile is:

.bash_profile

Get the aliases and functions

if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

#CRS2008V1 install
export LANG_ALL=en_US.utf8
export LANG=en_US.utf8
export LC_ALL=en_US.utf8

export MYSQL_HOME=/etc/my.cnf

BOBJEDIR=/creport/bobje
export BOBJEDIR
ODBC_HOME=$BOBJEDIR/enterprise120/linux_x86/odbc
export ODBC_HOME
ODBCINI=$BOBJEDIR/odbc.ini
export ODBCINI
LD_LIBRARY_PATH=$BOBJEDIR/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer:/usr/lib:$ODBC_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

The 32 bit MySQL 3.51 ODBC drivers are referenced in odbcinst.ini

/usr/lib/libmyodbc3.so

MySQL Client is the 32 version:

[[root@creport ~]# rpm -qa --queryformat="%{name}-%{arch}\n" | grep MySQL
MySQL-devel-advanced-i386
MySQL-shared-compat-advanced-i386
MySQL-embedded-advanced-i386
MySQL-server-advanced-x86_64 - this is the database.
MySQL-shared-advanced-i386
MySQL-client-advanced-i386
[root@creport ~]#

I am getting seriously doubtful this can be installed as when I press for reference sites where this is installed I get nothing.

Is anyone able to get CSR2008 running on RedHat Linux to MySQL database on the same host using ODBC?

Dom

dombaines (BOB member since 2011-06-20)

2

[Moderator Note: Moved from General Discussion to XI Server Discussion]

And welcome to B:bob:B!

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks for the welcome but does anyone have this working as an install?

Dom

dombaines (BOB member since 2011-06-20)

4

This will be BOXI 12.3.0.601 --> XI 3.1 SP3

Also called Crystal Reports 2008 V1 SP3.

Also to confirm it isn’t the reports (were also created with a client with the same version number), I have the same reports deployed to a Windows 2008 R2 server running the same BOXI version and the reports run fine both to local and remote MySQL databases using ODBC… Again 64 bit host OS but 32 bit ODBC drivers.

Would be grateful for any advise.

Dom

dombaines (BOB member since 2011-06-20)

5

The SAP install docs were wrong for unixODBC their examples were completely wrong… extremely simple when worked it out.

e.g. (one DSN from the odbc.ini file from the bobje directory)

[MySQL-test]
Description=MySQL database test
Driver=/creport/bobje/MySQL_ODBC/mysql-connector-odbc-3.51.12-linux-i686/lib/libmyodbc3.so
Server=192.168.29.109
Database=test
Port=3306
Socket=
Option=
Stmt=

Note that there must be NO WHITE SPACE between any DSN variable name = and the value and no # comments either!

The SAP ODBC install configuration document even has an example that does have them and it did not work.

The unixODBC standard for the /etc/odbcinst.ini having the driver details in and the odbc.ini referencing the ODBC driver alias also doesn’t work you have to specify the actual driver file in the link file or the odbcinst.ini alias.

Hope this helps some others.

Dom

dombaines (BOB member since 2011-06-20)