Piotr
lcg-archiver is definitely running. I've attached lcg-archiver.log.
How do I check which LCG registry I'm using? It is possible R-GMA is
broken as I've only just installed the MON with yaim, but
lcg-archiver.log doesn't specifically complain.
cheers
Steve
> -----Original Message-----
> From: LHC Computer Grid - Rollout
> [mailto:[log in to unmask]] On Behalf Of Piotr Nyczyk
> Sent: 21 October 2005 16:24
> To: [log in to unmask]
> Subject: Re: [LCG-ROLLOUT] Problems with SFT Server installation
>
> Hi,
>
> In fact to create those tables you have to check two things:
> 1. If the tables are declared in R-GMA schema server that you
> are using (if you are using central LCG registry it should be
> always the
> case)
> 2. If you correctly configured and started lcg-archiver on
> your SFT server machine. You can check it by looking at the
> following log file:
> /opt/lcg/var/log/lcg-archiver.log
>
> The tables are created in MySQL database by lcg-archiver when
> you start it for the first time. It can fail for several reasons:
> - tables are not defined in R-GMA schema
> - lcg-archiver cannot connect to MySQL - check
> /opt/lcg/etc/lcg- archiver.conf and if the user you created
> for the archiver in MySQL matches the one that you have in
> the archiver's config file
> - your R-GMA server is broken in any other way -
> lcg-archiver.log should then complain about it
>
> Cheers,
> Piotr
>
> On Oct 21, 2005, at 5:14 PM, Steve Thorn wrote:
>
> > I'm trying to setup an SFT Server following instructions at
> > http://goc.grid.sinica.edu.tw/gocwiki/SFT_Server_installation.
> >
> > Somewhere the tables are not being created, which causes
> errors when
> > submitting a test:
> >
> > $ ./sftests submit ce.epcc.ed.ac.uk
> > Starting Grid Environment Tests:
> > Getting list of monitored sites from GOC DB via R-GMA
> > Found sites: 175
> >
> > Results:
> > Found good central SE: lxn1183.cern.ch Found good RB: gdrb02.cern.ch
> >
> > Finished Grid Environment Tests.
> >
> > Publishing environmet:
> > DONE
> >
> > Publishing tests definitions:
> > sft-apel: FAILED: Error while inserting a tuple to MySQL DB
> > sft-brokerinfo: FAILED: Error while inserting a tuple to MySQL DB
> > sft-caver: FAILED: Error while inserting a tuple to MySQL
> DB <etc...>
> >
> > The log file confirms tables are missing and I can see that
> > latestProducer contains no tables.
> > /opt/lcg/var/log/lcg-sft-publish.log:
> > ...
> > 2005-10-21 15:46:20,384: [ERROR] Error while inserting a tuple to
> > MySQL DB Traceback (most recent call last):
> > File "/opt/lcg/sft/web/PublishTuple.py", line 70, in publishTuple
> > db_cur.execute(query_latest)
> > File
> "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 61,
> > in execute
> > r = self._query(query)
> > File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line
> > 168, in _query
> > rowcount = self._BaseCursor__do_query(q)
> > File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line
> > 112, in __do_query
> > db.query(q)
> > ProgrammingError: (1146, "Table
> 'latestProducer.TestData_v0_2' doesn't
> > exist")
> > ...
> >
> > I tried running /opt/lcg/sft/web/tablesV0_4.sh but it adds
> no tables.
> >
> > Any ideas would be greatly appreciated?
> >
> > cheers
> > Steve
> > _________________________
> > Dr Steve Thorn
> >
> > Systems Administrator
> > National e-Science Centre
> > 15 South College Street
> > Edinburgh EH8 9AA
> > United Kingdom
> >
> > Tel: +44 (0)131 650 9815
> >
>
>
|