[Fwd: database for UI of the LAS]

[Jonathan Callahan <Jonathan.S.Callahan@xxxxxxxx>]

All,

I thought this discussion might be a good for anyone else setting up
multiple LASs on a single machine.


-- Jon

--- Begin Message ---

• To: Tony Jolibois <Tony.Jolibois@xxxxxx>
• Subject: Re: database for UI of the LAS
• From: Jonathan Callahan <Jonathan.S.Callahan@xxxxxxxx>
• Date: Wed, 02 Jul 2003 10:52:26 -0700
• References: <5.1.0.14.2.20030702172316.00b138d8@pop.cls.fr>

Tony,

We have a dozen or more LAS installations on our operational computer.  If you look at the databases in MySQL you'll see that there is one database named 'las' and several others named 'las#'.  The 'las' database keeps track of which 'las#' database is associated with each URL as well ass the different sessions in progress.  The various 'las#' database contain the configuration information for each LAS installation.  An example session with MySQL is given below.

Because the LAS User Interface (UI) and LAS data server are completely separate you could have multiple LAS UIs that all request data from a single LAS data server.  However, it's easiest to have completely separate installations, one for each server.  The important thing is to choose a different path name during the configuration process.  When you reach this step in the configuration:

You must now specify the path name the Web client will use ...

you should respond with 'aviso_las' or 'mersea_las' or some such in order to distinguish them.

The default installation process will also result in multiple Tomcat servers being installed, one for each LAS UI.  We have found that running many Tomcat servers at once causes problems and have written a FAQ describing how to get by with one.  This may not be an issue for your three servers.

Let me know if you have any questions.
 

-- Jon
 

stout.pmel.noaa.gov webuser> mysql -u root -h localhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14346 to server version: 3.23.45

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| bugs     |
| las      |
| las0     |
| las1     |
| las10    |
| las11    |
...
| las9     |
| mysql    |
| obs      |
| test     |
+----------+
58 rows in set (0.26 sec)

Tony Jolibois wrote:

    Dear Jonathan,

I have installed my 3 las (AVISO, MERCATOR and MERSEA) on the same
computer. And I have seen that 2 LAS was connected to the same MySql
database (for the User Interface) ! It was not flagrant because a lot of
data in these 2 LAS are the same.
Where is specified the database used by the LAS ?

Tony

--- End Message ---