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
