Hej all
I have been testing the Data Base software starting from the TestDB
programs in brat/test. I can not use the MySql server on pii3 so I use my
own localhost server where I have the MySql root privileges.
It is all in my own brat copy and not checked in. So this is for your
information in case you also start working on data bases.
TestDBSetup.cxx: I extracted the part that creates tables and placed it
in a shell script TestDBCreate.sh together with commands that grants
privileges to a user "brahms" and another part, TsetDBFill.cxx, which with
fewer privileges creates tables and fills in demo data.
TestDBCreate.sh: User "brahms" gets select and insert privileges from any
host and additionally update, delete and create to the Brahms Data bases
when running on my localhost. I also give a password to user "brahms" -
the same from all hosts. We have to decide what privileges should be used
to access what data bases for what purposes.
BTW: I changed the brat/db to change all occurrences of the textstring
"localhost" to the name of my local host (hilux03.nbi.dk) using a proper
library routine. This causes TCP/IP to be used rather than Unix sockets
for communication with the server and thus no need to find that stupid
socket file which disappears all the time.
TestDBFill.cxx: This is a slightly stripped down version of the former
TestDBSetup.cxx using the localhost and running as user brahms.
TestDBClean.sh: Prepares for a re-run of TestDBCreate.sh and TestDBFill.
It is a script running as MySql root and used to remove the brahms data
bases and all info about user "brahms from my local MySql server.
TestDBRead.cxx and TestDBWrite: Are adjusted to use a local server and
work as intended by Christian (I think).
--------
I go on vacation now thursday 22-june and resume work 10-july.
Just in case: My local stuff is on /nfs/hehi/hehi7/hehi/aholm/brat/
once you are at nbi.dk
Anders
=========================================================
Anders Holm email: aholm@nbi.dk
Niels Bohr institute phone: (45) 35 32 52 13
University of Copenhagen fax: (45) 35 32 50 16
Blegdamsvej 17
DK-2100 Copenhagen
Denmark
========================================================
This archive was generated by hypermail 2b29 : Wed Jun 21 2000 - 10:32:02 EDT