FW: CLAS sofware at UR: MYSQL

["Stefanovski, Sasko" <sstefano@richmond.edu>]

Jerry,

Before installing anything on pscm1, I need some information.

Mike mentioned that Francisco has setup some time while ago a mysql server
on psc1.

Do you want to keep the same setup - mysql server on psc1 and have mysql
client only on pscm1?
Or both the server and the client to be installed on the new cluster?

Thanks,
Sasko


-----Original Message-----
From: Luminita Todor [mailto:luminita@jlab.org]
Sent: Thursday, November 21, 2002 7:27 PM
To: Stefanovski, Sasko
Cc: Mike Vineyard; Markus Geiger
Subject: RE: CLAS sofware at UR: MYSQL


Sasko,

I think we need MySQL on pscm1 installed if not too difficult.
CLAS software uses sets of detector&time related values
organized in a MySQL database with a master version at 
JLAB and a mirror at UR.

I expect to pick up the software build next Monday - it
would be great if it is installed at that time.
If the effort is too big I can just copy the relevant 
libraries from JLAB.

Please also let me know where you put the CERN libraries (path&version).
Are you going to move old-home to new directories or should
 I do it - as root of course? The directories with different 
releases of CLAS software is named... clas
Thank you,

Luminita Todor
postdoctoral research associate
Carnegie Mellon University, Pittsburgh, PA
research site - Thomas Jefferson National Facility / Hall B
tel. 757-269-5538

On Thu, 21 Nov 2002, Stefanovski, Sasko wrote:

> Luminita,
> 
> /home/old-home directory is just there temporary. That's why 'old-home'
> Everything below is supposed to be moved to /home.
> User need to move their home directory too.
> 
> BTW, mysql is not installed on pscm1. If you need it, it can be installed.
> It is not a part of the default RedHat 7.2 installation and that's why
it's
> missing.
> 
> Sasko
> 
> -----Original Message-----
> From: Luminita Todor [mailto:luminita@jlab.org]
> Sent: Thursday, November 21, 2002 2:29 PM
> To: gilfoyle
> Cc: Mike Vineyard; Sasko Stafanovski; Markus Geiger
> Subject: CLAS sofware at UR: MYSQL?
> 
> 
> 
> Today I started to install release-4-4 of CLAS sofware on
> pscm1. I checked out the software in my account and copy
> the sources in
> /usr/old-home/clas/builds/release-4-4
> (to be side-by-side with the previous releases)
> 
> I tried to build and I run into some errors in caldb
> related to absence of some mysql header. 
> ....
> calib_connect.c:10:19: mysql.h: No such file or directory
> ....
> At JLAB I have included in the PATH
> MYSQL_INCLUDE_PATH=/group/clas/mysql/LinuxRH7/include
> MYSQL_LIB_PATH=/group/clas/mysql/LinuxRH6/lib
> MYSQL_INCLUDE=/apps/mysql/include/mysql
> MYSQL_LIBS=/apps/mysql/lib/mysql
> 
> Here comes the question:
> Is NOW mysql installed in UR cluster? Where? How/which related variables
> were set? It might as well be that you avoid the MySQL
> 
> There are some other minor problems - I think Mark Ito will help me clear
> them soon. So I'm working on it.
> 
> Luminita Todor
> postdoctoral research associate
> Carnegie Mellon University, Pittsburgh, PA
> research site - Thomas Jefferson National Facility / Hall B
> tel. 757-269-5538
> 
> 
>