<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
The new location of the hdops wiki is:<br>
<br>
<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/hdops/wiki">https://halldweb.jlab.org/hdops/wiki</a><br>
<br>
There will be a re-direct page in the old location. It is just not
there yet.<br>
<br>
<br>
<div class="moz-cite-prefix">On 02/25/2015 07:36 AM, Mark Ito wrote:<br>
</div>
<blockquote
cite="mid:y8fog3kvd1n9srjivp7odadt.1424867653113@email.android.com"
type="cite">
<div>We should be up now...let us know if you find anomalies.<br>
<br>
-------- Original Message --------<br>
Subject: Log entry notification: HALLD Web and DB Server Status<br>
From: <a class="moz-txt-link-abbreviated" href="mailto:wise@jlab.org">wise@jlab.org</a><br>
To:
<a class="moz-txt-link-abbreviated" href="mailto:unixadm@jlab.org,hovanes@jlab.org,marki@jlab.org,davidl@jlab.org">unixadm@jlab.org,hovanes@jlab.org,marki@jlab.org,davidl@jlab.org</a><br>
CC: <br>
<br>
<br>
</div>
<br>
<div>
<div class="box">
<table border="0" width="90%" align="center">
<tbody>
<tr>
<td colspan="1"><b><a moz-do-not-send="true"
href="http://cclog.jlab.org//elog.php?quicksearch=1022640&logbook=ALL&entry_type=ALL#bracketed">1022640</a></b></td>
<td colspan="2"><font color="black"><b>HALLD Web and DB
Server Status</b></font></td>
</tr>
<tr>
<td width="150"> <b>25-Feb-15 06:52</b></td>
<td width="300"><b>M_Wise</b></td>
<td align="left"><b>SYSTEMLOG | MAINTLOG</b></td>
</tr>
</tbody>
</table>
</div>
<table border="0" width="90%" align="center">
</table>
<br>
<br>
<table border="0" width="90%" align="center">
<tbody>
<tr>
<td>
<pre wrap="">The deployment of the new web and DB servers for Hall D is nearly
complete with the following exceptions --
* The midas electronic logbook is not configured on halldweb yet
* GLUONWEB still remain to be set up. Apache is installed, working on the
MariaDB installation now.
* Replication of the CCDB database to GLUONDB1 is not operational yet
Otherwise, the new servers are up and running. This includes HALLDWEB,
HALLDDB and the externally-visible replication slave HALLDDB-EXT (note:
off-site, this is called HALLDDB). The new systems are all running new
versions of everything and have improvements in available resources (more
CPU, RAM, etc. appropriate to each) and improvements in the backup
systems, replication configuration, etc.
The main CC-maintained applications are all up and working, including the
Gluex Wiki (<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/wiki">https://halldweb.jlab.org/wiki</a>), the HDOPS wiki (now at
<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/hdops/wiki">https://halldweb.jlab.org/hdops/wiki</a>), and MantisBT
(<a class="moz-txt-link-freetext" href="https://halldweb.jlab.org/mantisbt">https://halldweb.jlab.org/mantisbt</a>). All are running the newest
versions. I've gone through several of the other applications
(JInventory, SP_Jinventory, etc) and updated their DB connection
parameters so they are now working as well.
The hallddb-ext and halldweb systems are both visible from off-site and
have had all the necessary DNS entries updated.
The original systems (halldweb1, hdops and hallddb1) have all been
preserved, but access to them from user VLANs has been blocked using
their local firewalls. Also, halldweb1's DNS entry was changed to
halldweb1-old.jlab.org. This was done so that the original name could be
aliased to the new system. So halldweb1.jlab.org is an alias for
halldweb.jlab.org.
*** NOTES:
1. DBs all originally were on halldweb1. I split them up between halldweb
and hallddb. The intention is that only DBs that are used exclusively by
applications running on halldweb will be maintained on the local DB
server on halldweb. Other DBs should move to hallddb for general access.
It may be that I guessed incorrectly about some of these, so we may need
to shuffle a few around yet.
2. DB user accounts were migrated from the old system. A few, obviously
obsolete accounts were removed. Also, many needed to be updated to
reflect the new client system names. This is a tedious, manual process.
Access should be reviewed and any problems reported so I can correct them.
3. DB accounts with no passwords, or granted to all hosts (e.g.
someuser@% should be carefully reviewed. Since the hallddb system is
replicated to the slave entirely, grants to all hosts now apply to
internet clients. The server is set to read-only in its config, but,
nevertheless, such accounts should be removed or changed to a limited
scope (like %.jlab.org) unless specifically required to support off-site
access.
4. All DB accounts from halldweb1 were copied to both halldweb and
hallddb. Many can be removed form the system where they are not used.
I will get gluonweb configured, then replication to gluondb1 and finally
the midas elog. I will email as these additional components are brought
online.
Let me know of any problems seen. Things seem to be working well
fundamentally, but I'm sure there are small details that will need
correction and/or adjustment.</pre>
</td>
</tr>
</tbody>
</table>
<table border="0" width="90%" align="center">
</table>
<br>
<table border="0" width="90%" align="center">
<tbody>
<tr>
<td colspan="2"><b>References to other log entries:</b></td>
</tr>
<tr>
<td>
<div class="box">
<table border="0" width="90%" align="center">
<tbody>
<tr>
<td colspan="1"><b><a moz-do-not-send="true"
href="elog.php?quicksearch=1022636&logbook=ALL&entry_type=ALL#bracketed">1022636</a></b></td>
<td colspan="2"><font color="black"><b>HALLD Web
and DB Server Status</b></font></td>
</tr>
<tr>
<td width="150"> <b>24-Feb-15 21:39</b></td>
<td width="300"><b>M_Wise</b></td>
<td align="left"><b>SYSTEMLOG | SCI-COMPLOG |
MAINTLOG</b></td>
</tr>
</tbody>
</table>
</div>
<table border="0" width="90%" align="center">
</table>
<br>
<br>
<table border="0" width="90%" align="center">
<tbody>
<tr>
<td>
<pre wrap="">HALLDWEB, HALLDDB and HALLDDB-EXT are all online. All still need some
checkout and finishing up, but the 2 DB servers are operational and
replicating to the ext server. FW is opened and DNS updated, but can't
connect yet... still getting old IP on my home system.
The Web Server is up and running, and the two wikis -- Gluon wiki and
the HDOPS wiki are both working to first order, though I need to do some
more checkout.
Other apps need edits to their configs to reflect the new system name
(halldweb). I will work through the remainder of them in the morning.
Replication of the wiki DB to gluonweb is in progress. I have the apache
server installed and preliminary configuration done on gluon24 but need
to install the DB server.
When I get the remaining items finished up, I'll send an email with the
new URLs. I will also install redirects or announcement pages on the old
URLs.
</pre>
</td>
</tr>
</tbody>
</table>
<table border="0" width="90%" align="center">
</table>
<br>
<table border="0" width="90%" align="center">
<tbody>
<tr>
<td colspan="2"><b>Other log entries that
reference this one:</b></td>
</tr>
<tr>
<td><a moz-do-not-send="true"
href="elog_item.php?elog_id=1022640">1022640 -
HALLD Web and DB Server Status</a></td>
</tr>
</tbody>
</table>
<br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
Database query + PHP page generation time = 0 seconds <br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Halld mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Halld@jlab.org">Halld@jlab.org</a>
<a class="moz-txt-link-freetext" href="https://mailman.jlab.org/mailman/listinfo/halld">https://mailman.jlab.org/mailman/listinfo/halld</a>
</pre>
</blockquote>
<br>
</body>
</html>