On Wed, 2005-05-11 at 17:49, Steve Traylen wrote:
> On Wed, May 11, 2005 at 01:33:20PM +0100 or thereabouts, Fraser Speirs wrote:
> > Following this morning's call, I started poking around in my YAIM-
> > installed APEL setup. Istarted by upgrading to edg-rgma-apel-3.4.45-1.
> >
> > In my site-info.def, I have a MySQL password set, however my
> > accounting database in MySQL has different passwords for the users
> > 'accounting' and 'producer':
>
> Hi Fraser,
>
> The accounting and producer passwords are hardwired in the rgma code. Producers
> and Consumers tables are what all R-GMA servlet boxes have.
accounting name is used by Apel. producer name is used by R-GMA.
There is a script which sets up the databases in R-GMA here
/opt/edg/share/rgma/scripts/rgma-server-setup.py
values can be passed for the username and passwords default one are used
if non are supplied. It also creates a configuration file with the
username and password and stores it here
/opt/edg/etc/rgma-server/rgma-server.conf
This is read by R-GMA when it starts.
There is a setup guide for apel here( I don't know how this relates to a
YAIM install)
http://hepunx.rl.ac.uk/egee/jra1-uk/LCG/doc/apel-guide.pdf
essentially when apel is installed a configuration script needs to be
run which creates the databases with supplied usernames and passwords
much the same as R-GMA. A configuration file needs to be created which
has the username and password in it which is used by apel.
I haven't setup Apel myself but if after reading the guide you are still
having problems let me know and I'll have a further dig for info.
Alastair
>
> I've not checked recently but it used to only be accessable at the local
> host. Hence the security concerns of mixing MON boxs and CEs/SEs to which
> people have access.
>
> I sympathise though, it has always struck me as annoying that all
> database applications unusually have to have some plain password
> somewhere.
>
> Steve
> >
> > mysql> select user, password from user;
> > +------------+------------------+
> > | user | password |
> > +------------+------------------+
> > | root | 4bd96e375a58ebc5 |
> > | root | |
> > | | |
> > | | |
> > | producer | 5da82855614d7756 |
> > | producer | 5da82855614d7756 |
> > | producer | 5da82855614d7756 |
> > | producer | 5da82855614d7756 |
> > | accounting | 406e89046c7a3347 |
> > | accounting | 406e89046c7a3347 |
> > | accounting | 406e89046c7a3347 |
> > | accounting | 406e89046c7a3347 |
> > +------------+------------------+
> > 12 rows in set (0.00 sec)
> >
> > mysql> select PASSWORD("MY_MYSQL_PASSWORD");
> > +------------------------+
> > | PASSWORD("MY_MYSQL_PASSWORD") |
> > +------------------------+
> > | 4bd96e375a58ebc5 |
> > +------------------------+
> > 1 row in set (0.00 sec)
> >
> > I'm not sure where this has come from, but it seems to be the most
> > immediate and obvious reason that the edg-rgma-apel-test script is
> > failing.
> >
> > Where did this arise and what's the best way to fix it? Just change
> > the passwords in MySQL?
> >
> > Thanks,
> > Fraser
> > --
> > Technical Coordinator - ScotGrid
> > a: Room 481, Kelvin Building, University of Glasgow
> > w: http://ppewww.ph.gla.ac.uk/~fspeirs/ t: 0141 330 6439
>
> --
> Steve Traylen
> [log in to unmask]
> http://www.gridpp.ac.uk/
|