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

Justin Stevens jrsteven at mit.edu
Wed Feb 25 14:19:24 EST 2015 

I can also login to the wiki from offsite.
-Justin

On Feb 25, 2015, at 2:14 PM, Sean Dobbs wrote:

> 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	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 at
>>>>>>> 
>>>>>>> https://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 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.
>>>>>>> 
>>>>>>> 
>>>>>>> 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 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
>>>> 
>>> 
>> 
>> _______________________________________________
>> 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
> _______________________________________________
> Halld mailing list
> Halld at jlab.org
> https://mailman.jlab.org/mailman/listinfo/halld

More information about the Halld mailing list