Files
The latest snapshot was recommended: SQL-MA
[ytl@net-desk1:/opt/perfSONAR]$ ls -lah
total 56K
drwxr-xr-x 3 ytl ytl 4.0K Aug 30 10:25 .
drwxr-xr-x 9 ytl ytl 4.0K Aug 29 12:18 ..
lrwxrwxrwx 1 ytl ytl 14 Aug 9 16:30 current -> perfSONAR-1.0/
lrwxrwxrwx 1 ytl ytl 38 Aug 24 10:26 current-SQL_MA -> \
perfSONAR-SQL_MA-src-snapshot-20060828
-rw-rw-r-- 1 ytl ytl 2.4K Aug 29 11:54 mysql-sqlma-dbsetup.sql
drwxrwxr-x 10 ytl ytl 4.0K Aug 9 16:51 perfSONAR-1.0
lrwxrwxrwx 1 ytl ytl 94 Aug 24 09:58 perfSONAR-SQL_MA-src-snapshot-20060811 -> \
/u/sf/ytl/Work/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811
lrwxrwxrwx 1 ytl ytl 94 Aug 30 10:25 perfSONAR-SQL_MA-src-snapshot-20060828 -> \
/u/sf/ytl/Work/perfSONAR/SQLtypeMAService/java/20060828/perfSONAR-SQL_MA-src-snapshot-20060828
Note that the snapshot files are actually located on AFS space.
Exist Installation
Exist is already installed on net-desk1:8680.
Server started with:
[ytl@net-desk1:/opt/exist/current/bin]$ ./startup.sh Configuring eXist from /opt/exist/eXist-20060316/conf.xml Found 1 catalog entries. Loading catalog: /opt/exist/eXist-20060316/webapp/WEB-INF/catalog.xml IN CONFIGURE cluster.journal.maxStore 65000 cluster.journal.shift 100 30 Aug 2006 10:31:36,020 [main] INFO \ (FileResource.java [<clinit>]:60) - Checking Resource aliases 30 Aug 2006 10:31:36,231 [main] INFO \ (HttpServer.java [setStatsOn]:1068) - Statistics on = false for org.mortbay.jetty.Server@97eded 30 Aug 2006 10:31:36,240 [main] INFO \ (HttpServer.java [start]:654) - Starting Jetty/5.0.0 30 Aug 2006 10:31:36,320 [main] INFO \ (HttpServer.java [start]:669) - Started org.mortbay.http.NCSARequestLog@1a897a9 30 Aug 2006 10:31:36,786 [main] INFO \ (HttpContext.java [start]:1604) - Started WebApplicationContext[eXist Server,eXist Server] Logging already initialized. Skipping... 30 Aug 2006 10:31:38,173 [main] WARN \ (JavaUtils.java [isAttachmentSupported]:1305) \ - Unable to find required classes (javax.activation.DataHandler and javax.mail.internet.MimeMultipart). \ Attachment support is disabled. 30 Aug 2006 10:31:38,686 [main] INFO \ (SocketListener.java [start]:204) - Started SocketListener on 0.0.0.0:8680 30 Aug 2006 10:31:38,687 [main] INFO \ (HttpServer.java [start]:690) - Started org.mortbay.jetty.Server@97eded
Just to make sure the eXist DB is running, run the X11 client:
[ytl@net-desk1:/opt/exist/current/bin]$ ./client.sh eXist version 1.0, Copyright (C) 2001-2006 Wolfgang Meier eXist comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions; for details read the license file. GNU Readline found. IMPORTANT: Don't use GNU Readline to work with other character encodings than ISO-8859-1.
The sqlmaservice user was already added from a previous configuration.
Seems like everything is set up!
Conflicting MA Service
Noticed that the perfSONAR service runs the RRD MA Service also (as per my installation instructions):
Therefore undeployed the MA Service by:
[ytl@net-desk1:/opt/perfSONAR/current/scripts]$ ./MAAxisUndeploy.sh Processing file /opt/perfSONAR/perfSONAR-1.0/wsdd/ma-service-undeploy.wsdd <Admin>Done processing</Admin>
MySQL Database Setup
Downloaded a standalone version of MySQL:
[ytl@net-desk1:/opt/mysql]$ ls -lah total 42M drwxrwxr-x 3 ytl ytl 4.0K Aug 29 11:41 . drwxr-xr-x 9 ytl ytl 4.0K Aug 29 12:18 .. lrwxrwxrwx 1 ytl ytl 40 Aug 24 10:39 current -> mysql-standard-5.0.24-linux-i686-glibc23 -rw-rw-r-- 1 ytl ytl 13M Aug 1 06:25 MySQL-server-standard-5.0.24-0.rhel4.i386.rpm drwxr-xr-x 14 ytl ytl 4.0K Jul 27 20:55 mysql-standard-5.0.24-linux-i686-glibc23 -rw-r--r-- 1 ytl ytl 29M Aug 24 10:41 mysql-standard-5.0.24-linux-i686-glibc23.tar.gz
Added a MySQL user:
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo /usr/sbin/luseradd mysql
Tried to start the server and got:
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo ./mysqld_safe The file /usr/local/mysql/bin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more information
Edited /opt/mysql/current/bin/mysqld_safe to move all links to /opt/mysql/current/ rather than /usr/local/mysql.