[Halld] Log entry notification: HALLD Web and DB Server Status

Wed Feb 25 14:14:42 EST 2015

For what it's worth, I've been able to log into and edit the wiki offsite
and see the front page image.

---Sean

On Wed, Feb 25, 2015 at 1:10 PM, David Lawrence <davidl at jlab.org> wrote:

>
>  I was able to log into the wiki today with my CUE username/password. I
> wonder if this is an
> offsite authentication issue...
>
>
>  On Feb 25, 2015, at 1:54 PM, Paul Mattione <pmatt at jlab.org> wrote:
>
>  Weird.  My CUE login works.  But I also don’t see the picture.
>
>   - Paul
>
>  On Feb 25, 2015, at 1:53 PM, Curtis A. Meyer <cmeyer at cmu.edu> wrote:
>
>  No -   there was also a different password for the wiki, neither of
> these appear to work at the moment.
>
>  I also don’t see the correct front page when I go to the new wiki, the
> picture is missing …. but I assumed
> that once I was able to login that this might be fixed.
>
>   ---------
> Curtis A. Meyer MCS Associate Dean for Faculty and Graduate Affairs
> Wean:    (412) 268-2745 Professor of Physics
> Doherty: (412) 268-3090 Carnegie Mellon University
> Fax:         (412) 681-0648 Pittsburgh, PA 15213
> curtis.meyer at cmu.edu http://www.curtismeyer.com/
>
>
>
>  On Feb 25, 2015, at 1:50 PM, Paul Mattione <pmatt at jlab.org> wrote:
>
>  Your JLAB CUE username / password doesn’t work for domain JLAB?
>
>   - Paul
>
>  On Feb 25, 2015, at 1:42 PM, Curtis A. Meyer <cmeyer at cmu.edu> wrote:
>
>  Ok-
>   I can’t login to the new GlueX Wiki with the username (cmeyer) and
> password that I had before. Has something changed?
> This is not good….
>
>    Curtis
>  ---------
> Curtis A. Meyer MCS Associate Dean for Faculty and Graduate Affairs
> Wean:    (412) 268-2745 Professor of Physics
> Doherty: (412) 268-3090 Carnegie Mellon University
> Fax:         (412) 681-0648 Pittsburgh, PA 15213
> curtis.meyer at cmu.edu http://www.curtismeyer.com/
>
>
>
>  On Feb 25, 2015, at 8:44 AM, Mark Ito <marki at jlab.org> wrote:
>
>  Folks,
>
> The new server is halldweb.jlab.org, not halldweb1.jlab.org. The old name
> is supposed to auto-switch you to the new one. I thought that worked this
> morning but does not seem to be working as I write this. The new wiki link
> is thus:
>
>  https://halldweb.jlab.org/wiki/index.php/Main_Page
>
> On the wiki, you now log in with your JLab CUE username and password.
> Really should have told you guys that before now. Our wiki is now standard
> in that regard.
>
>   -- Mark
>
>
> On 02/25/2015 07:36 AM, Mark Ito wrote:
>
> We should be up now...let us know if you find anomalies.
>
> -------- Original Message --------
> Subject: Log entry notification: HALLD Web and DB Server Status
> From: wise at jlab.org
> To: unixadm at jlab.org,hovanes at jlab.org,marki at jlab.org,davidl at jlab.org
> CC:
>
>
>
>    *1022640
> <http://cclog.jlab.org//elog.php?quicksearch=1022640&logbook=ALL&entry_type=ALL#bracketed>* *HALLD
> Web and DB Server Status*  *25-Feb-15 06:52* *M_Wise* *SYSTEMLOG |
> MAINTLOG*
>
>
>   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 (https://halldweb.jlab.org/wiki), the HDOPS wiki (now athttps://halldweb.jlab.org/hdops/wiki), and MantisBT
> (https://halldweb.jlab.org/mantisbt). 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 tohalldweb1-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 forhalldweb.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.
>
>
>   *References to other log entries:*
>   *1022636* *HALLD Web and DB Server Status*  *24-Feb-15 21:39* *M_Wise* *SYSTEMLOG
> | SCI-COMPLOG | MAINTLOG*
>
>
>   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.
>
>
>
>   *Other log entries that reference this one:*  1022640 - HALLD Web and
> DB Server Status
>
>
> Database query + PHP page generation time = 0 seconds
>
>
> _______________________________________________
> Halld mailing listHalld at jlab.orghttps://mailman.jlab.org/mailman/listinfo/halld
>
>
>  _______________________________________________
> Halld mailing list
> Halld at jlab.org
> https://mailman.jlab.org/mailman/listinfo/halld
>
>
>  _______________________________________________
> Halld mailing list
> Halld at jlab.org
> https://mailman.jlab.org/mailman/listinfo/halld
>
>
>
>
>  _______________________________________________
> Halld mailing list
> Halld at jlab.org
> https://mailman.jlab.org/mailman/listinfo/halld
>
>
>

-- 
Sean Dobbs
Department of Physics & Astronomy
Northwestern University
phone: 847-467-2826
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman.jlab.org/pipermail/halld/attachments/20150225/55c42972/attachment.html 