After downloading the required software, we recommend installing
in this order: MySQL, Java, then Winston. If you already have Java
and/or MySQL running, please ensure that the versions are
sufficiently current. Winston requires at least MySQL version 4.0,
and Java 1.4. Better performance will be achieved with MySQL 4.1 vs
If you already have a MySQL installation running that you're
happy with (provided it's at least version 4.0) then just skip to
1. Extract the .zip file to
C:\ or on
Linux/Unix, untar the binary distribution to a directory of your
2. Install the MySQL server as a Windows service: open a
command prompt and
C:\mysql-4.1.11-win32\bin and type:
--install. (This step is not required for Linux/Unix).
3. On Windows, Start the service by typing:
start MySQL, or via Control Panel\Administrative
Tools\Services. Once the service is started it will automatically
restart at boot time. For Linux/Unix start the server by executing:
Probably you'll want to put this process in the background. Also,
you'll probably want to make the server start at boot.
4. Test that the server is running properly by executing
the mysql client program. While in the mysql binaries directory
(for Windows this is
mysql -u root. If you get something that looks like
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.11
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
then things are working properly.
5. OPTIONAL. You may want to add the mysql binaries
directory to your path for convenience.
6. You'll probably want to add a password to your root
mysql user. At a command prompt, assuming you're in the mysql
binaries directory, or that this directory is in your path, type:
mysqladmin -u root password newpass, where
newpass denotes the password you choose.
7. Create a Winston mysql user. Start the mysql client as
in 5 above (if you created a root password, you'll need to
-p option, which will cause the client to prompt
you for a password before starting). At the
prompt, type the following three commands:
grant all on `W\_%`.* to wwsuser@'localhost' identified by
Note that those are back ticks surrounding
W_%, not single quotes. You might want to just cut and paste this whole line. You can call the Winston user whatever you want (we called it
wwsuser here); the password can also be whatever you like. These
grant commands permit the Winston user to have full control over
any database that begins with
W_. No other database
will be touched under any circumstances, so you need not worry that
Winston will clobber pre-existing data.
Warning: In the section on configuration files, we describe how
W connect to the database via a JDBC url. Note that if the
localhost in the url resolves to something other than literal
localhost such as your machine name, then you'll need to change the above
grant appropriately. For example, on the AVO machine
avo-valve.wr.usgs.gov the command
ping localhost returns this:
PING avo-valve (127.0.0.1) 56(84) bytes of data.
64 bytes from avo-valve (127.0.0.1): icmp_seq=0 ttl=64 time=0.000 ms
64 bytes from avo-valve (127.0.0.1): icmp_seq=1 ttl=64 time=0.000 ms
--- avo-valve ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1000ms
rtt min/avg/max/mdev = 0.000/0.000/0.000/0.000 ms, pipe 2
localhost is getting resolved to
avo-valve. So, the
grant command should be as follows:
grant all on `W\_%`.* to wwsuser@'avo-valve' identified by 'wwspass';
A shortcut that avoids all these resolution issues is to simply grant access to
wwsuser from all hosts via:
grant all on `W\_%`.* to wwsuser@'%' identified by 'wwspass';
though under some circumstances this is less secure.
Warning: Your installation of MySQL must allow TCP/IP connections. This is the default setting, so no action needs to be taken unless you have specfically denied TCP/IP connections.
1. For Windows, simply run the executable,
self-extracting Java installer program. For Linux/Unix, untar the
Java distribution into a directory of your choosing.
2. Add the Java binary directories to you path. (This is
done automatically by the Windows installer)
3. Test the installation by typing:
-version at a command line. If you get something back like
then you're in business. Remember, Java 1.4 or higher is
java version "1.5.0_02"
Java(TM) 2 Runtime Environment, Standard Edition (build
Java HotSpot(TM) Client VM (build 1.5.0_02-b09, mixed mode,
1. For Windows, unzip the Winston binary distribution
C:\. For Linux/Unix, untar the Winston
distribution into a directory of your choosing.
2. Test the Winston software. At the command line type,
WinstonVersion.bat (Windows) or
WinstonVersion.sh (Linux/Unix). If you see something like
then everything is working fine. If the test script did not
execute properly, then make sure that the
Built: 2005-04-27 08:22:33
is still in your path.