Differences between revisions 1 and 2
Revision 1 as of 2010-03-08 13:08:03
Size: 1472
Comment:
Revision 2 as of 2010-04-22 11:58:11
Size: 1467
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
Line 12: Line 11:
 > more conf/start_external_database.sh  . > more conf/start_external_database.sh
It should give a line like:
Line 14: Line 14:
It should give a line like:
 
''java -cp $INSTALLDIR/lib/db/derby.jar:$INSTALLDIR/lib/db/derbynet.jar org.apache.derby.drda.NetworkServerControl -p '''8139''' start ...''
 . ''java -cp $INSTALLDIR/lib/db/derby.jar:$INSTALLDIR/lib/db/derbynet.jar org.apache.derby.drda.NetworkServerControl -p '''8139''' start ...''
Line 22: Line 19:
 > java -cp lib/db/derbyclient-10.4.2.0.jar:lib/db/derbytools-10.4.2.0.jar org.apache.derby.tools.ij
 . > java -cp lib/db/derbyclient-10.5.3.0.jar:lib/db/derbytools-10.5.3.0.jar org.apache.derby.tools.ij
Line 25: Line 21:
Line 28: Line 23:
 > SELECT * FROM file;
 . > SELECT * FROM file;
Line 34: Line 28:
 > SELECT * FROM replicafileinfo;
 . > SELECT * FROM replicafileinfo;
Line 40: Line 33:
 > SELECT * FROM replica;
 . > SELECT * FROM replica;
Line 46: Line 38:

> exit;
 . > exit;

Verify that the database is empty

Use ssh to go the admin machine and into your installation directory (netarkivet.dk -> kb-test-adm-001, and /home/test/TESTX)

Check that no admin.data file exists.

Check that a database directory, adminDB, exists.

Check the port number for the database by running the command:

  • > more conf/start_external_database.sh

It should give a line like:

  • java -cp $INSTALLDIR/lib/db/derby.jar:$INSTALLDIR/lib/db/derbynet.jar org.apache.derby.drda.NetworkServerControl -p 8139 start ...

The port in this case is 8139.

Log into the database and check the status (it is an external database, so the applications does not need to be shutdown before accessing the database).

  • > java -cp lib/db/derbyclient-10.5.3.0.jar:lib/db/derbytools-10.5.3.0.jar org.apache.derby.tools.ij > connect 'jdbc:derby://localhost:$PORT/adminDB'

Check the content of the different tables. The file table and the replicafileinfo table should be empty, whereas the replica table should contain the replicas:

  • > SELECT * FROM file;

...

It should now contain the amount of harvested files (at least 4, two for each harvest, and at least 1-metadata-1.arc and 2-metadata-1.arc).

  • > SELECT * FROM replicafileinfo;

...

If should now contain the 3 times the amount of harvested files, one for each replica (thus at least 12).

  • > SELECT * FROM replica;

...

3 rows selected

  • > exit;

It42VerifyNotEmptyDatabase (last edited 2010-08-16 10:24:52 by localhost)