Vertigo is the string processor and database holder.
An introduction to mysql databases (vertigo)
 Look into the link:http://icecube.wisc.edu/~krasberg/fat/how_to_start_a_fat/how_we_started_uw_fat_09.html

The information is repeated here, with local modifications for Uppsala (it is a bit out of date, the link above is therefore what you should use!).

First, generate a list of DOMs in DFL which includes old and new DOMs

the file monitor.dat will be used later. This file should be scanned for DOMs which have pressure leaks and for DOMs which have zero scaler rates...

Second, make a list of domids and mbids

This is the first line of newdoms.txt, since prod_id.sql creates a header line...
TP5P0581   347fd0110547
UP5P0582   ec54677bbb9e
TP5P0583   a3ae4b646a70

the file newdoms.txt will be used later (note, in this example, two of the fields were NULL because the production room typed in the domids incorrectly during testing and overwrote already existing DOMs - it is very common for people to remember domids incorrectly)

Third, initialize the doms and domtune tables with the new DOMs

this will print out a summary like this:

total number of unknown (monitor) doms = 42
total number of known (monitor) doms = 9
total number of found unknown (newdoms.txt) doms = 42
total number of found unknown T doms = 18
total number of found unknown U doms = 14
total number of found unknown A doms = 10

MAKE SURE THE SUMMARY ABOVE IS CORRECT ! THIS IS VERY IMPORTANT, OTHEWISE YOUR DFL MIGHT NOT BE LOADED RIGHT

Fourth, run domcal

Fifth, generate steering files and update domtune table one more time

The database has now been setup - you need to regenerate the steering files again since the first time they didn't have the correct lcmodes

To update the domprodtest database with info from the doms database, use the command "java icecube.daq.db.app.FAT2DPT" 

Enter all traveller information you can into the database on vertigo:

loginsql

use fat; example:

update doms set start_date='2005-04-12',pmtserial='TA1169',hvserial='000450',sphereserial=71097,mbserial='001252' where name='Akalla';

select * from doms where name='Akalla';

Example of what can be filled in (fill in more if you find the data!):

serial | domid | name | start_date | pmtserial | hvserial | sphereserial | mbserial | mbid | bfserial | seal_date | humidity | seal_pressure | pentorque

__________________________________________________________________________________________________________________________

4 | UP4H0026 | Bluetooth | 2004-08-04 | TA0176 | 000219 | 71129 | V5.0L000464 | d030f9de4010 | NULL | NULL | NULL | NULL | NULL |


Note: there is a special discriminator setting in domtune for the sync board

it is necessary to make a special spe threshold discrimator setting of
700 and mpe thres. disc. of 650 for the sync board at UPPSALA prior to generating FAT
steering files.

Lastly, update /usr/local/python/domnames.dat and rerun "monitor", and keep the info in monitor.dat - it is very useful to have these initial readings at the start of a FAT for later reference. Check that monitor.dat doesn't have any missing info in any of the fields (this would indicate database problems)