Globus Toolkit Error FAQ

For GRAM error codes, follow this link.

To Grid-enable MySQL is to allow client authentication using X509 certificates as used in the Globus Toolkit. Using the X509 certificates issued by the Globus Toolkit CA will alleviate the need for the client to authenticate separately after issuing the "grid-proxy-init" command. To do this in MySQL, one needs to connect over an SSL encrypted channel. This document will outline the steps needed to prepare MySQL for such connections, demonstrate a simple Perl DBI script which accomplishes the connection, and discuss future plans for testing and implementation.

Grid Security Infrastructure (GSI) is the mechanism used by the Globus Toolkit for enabling secure authentication and communication for a Grid over an open network. GSI provides a number of useful services for Grids, including mutual authentication and single sign-on. For detailed information regarding GSI you can read the GSI overview from Globus. Enabling MySQL to use GSI security and authentication will enable Grid users with grid proxy certificates to securely communicate with MySQL daemons on the grid without having to do further authentication. Processes that have been scheduled and initiated on the grid by an authenticated user will be able to communicate with MySQL daemons as well without further authentication.

---

GSI

GSI uses X.509 certificates and SSL providing:

• secure communication
• security across organizational boundaries
• single sign-on for users of the Grid

MySQL

As of version 4.0.0, MySQL is both SSL and X.509 enabled.

By default, MySQL is not SSL enabled, since using encrypted connections to access the database would slow down transactions and MySQL is, by default, optimized fo speed. Read the MySQL documentation on Using Secure Connections for details on how to set up MySQL for SSL, including how to create and set up the user certificates and grant the proper privleges for a user to authenticate.

Introduction

Ganglia is a resource information gathering tools and a monitoring system in general.

The STAR MySQL for GRID project is an effort to integrate MySQL database in the GRID infrastructure. This means providing tools to help management of networks of replicated database and providing GSI authentication for MySQL connection.

This page will be used for general information about our grid Infrastructure, news, upgrade stories, patches to the software stack, network configuration and studies etc ... Some documents containing local information are however protected.

So you brought a laptop to BNL… and the first thing you want to do is get online, right?
Ok, here's a quick (?) guide to getting what you want without breaking too many rules.

Wired Options:

Software Site Licenses:

Do we have a site license for software package XYZ?

The answer is (almost) always: No!
Neither STAR nor BNL have site licences for any Microsoft product, Hummingbird Exceed, WinZIP, ssh.com's software or much of anything intended to run on individual users' desktops. Furthermore, for most purposes BNL-owned computers do not qualify for academic software licenses, though exceptions do exist.

Utilities for Security and Performance

If your computer seems to be running slower than it used to, pop-up advertising is appearing at an alarming rat

Productivity software and viewers/utilities for various file types

• OpenOffice -- Free and available on multiple platforms.  Perhaps the single best reason to use it is that it natively creates PDF format.  In addition to its own formats, it can read (and write) MS Word, Excel and PowerPoint files (usually -- sometimes formatting details go haywire, but they are constantly updating it.)

To quote from the Cygwin website:  "Cygwin is a Linux-like environment for Windows."

Networking
Software

• PuTTY:
   This is the preferred SSH client for Windows.  It is free, easy to use
  and well maintained for both security and bug issues.
   (As with everything, it is only "maintained" if you regularly check
  for updated versions!)
   Please note that most other SSH clients for Windows are NOT free for
  use on government computers or in the pursuit of lab business, though
  they might function just fine without payment.

BNL-specific requirements and configuration for networked Windows computers:

This area is intended to provide information for STAR members to assist in configuring and using typical desktop/laptop PCs at BNL.

  Windows 2000/XP and Scientific Linux/Redhat Enterprise Linux are the preferred Operating Systems within STAR at BNL for desktop computing, though there is no formal requirement to use any particular OS.

1. Job Tracker database. New version of db structure proposed for
discussion. It allows flexible handling of job parameters and allows
to start GUI development. However, minimal list of parameters is still
not finalized (not  a show-stopper, imho). I'm open to discussion,
nothing is fixed yet.
1.1 I'll keep php-based XML-RPC server for a GUI development phase, we
do not have a working GT4 setup anyway.

2. Job Tracker API draft submitted for comments. It is made with
future WS compatibility in mind. I've studied GT4-WS docs on their

Time	Talk	Presenter
19:10	Job Tracker progress ( 00:10 ) 0 files	Dmitry Arkhipkin (JINR)