[EHPweb] Fwd: Fwd: Database Access
Eric Martinez
emartinez at usgs.gov
Thu Oct 23 20:07:59 GMT 2008
All,
I have completed locking down the database (with a few exceptions) as
I have explained below and in my previous messages. Please watch any
processes you have that access the database and make sure they are
still working as expected.
Stan Silverman, Scott Haefner, and Susan Garcia:
Please call me. 720.570.6303 I need to talk with you to complete
locking down the database. If I don't hear from you by 12:00 MST
(Noon) Monday then I will move forward locking down the database
without your input. This will likely cause you to lose access to the
database for specific purposes.
Thanks,
~Eric.
Begin forwarded message:
> From: Eric Martinez <emartinez at usgs.gov>
> Date: October 23, 2008 1:02:27 PM MDT
> To: EHPweb <ehpweb at geohazards.usgs.gov>
> Subject: [EHPweb] Fwd: Database Access
>
> All,
> After receiving no feedback since early this morning, I am going to
> start modifying the database. Please watch your processes to make
> sure nothing breaks. I expect to be completed with this by 14:00
> MST today and I will send another email when I complete.
>
> Thanks,
> ~Eric.
>
> Begin forwarded message:
>
>> From: Eric Martinez <emartinez at usgs.gov>
>> Date: October 23, 2008 11:31:57 AM MDT
>> To: EHPweb <ehpweb at geohazards.usgs.gov>
>> Subject: Fwd: Database Access
>>
>> All,
>> Attached is a spreadsheet identifying all the current user
>> accounts on our database on ehpmaster. I have combed through this
>> list and cross-referenced with what you all have told me thus far
>> with what I know in general and what I've seen in the access logs.
>> Please review the list of actions to be taken; pay close attention
>> to the accounts that will be deleted. It is much easier to delete
>> an account than to get it working again. I will start working down
>> this list starting at 13:00 MST today. Since time is a factor,
>> please call me with any changes you feel need to be made to this
>> list. 720.570.6303.
>>
>> Thanks,
>> ~Eric.
>>
>>
>> Begin forwarded message:
>>
>>> From: Eric Martinez <emartinez at usgs.gov>
>>> Date: October 23, 2008 9:54:03 AM MDT
>>> To: EHPweb <ehpweb at geohazards.usgs.gov>
>>> Subject: Fwd: Database Access
>>>
>>> All,
>>> Below is a short list of users that have accessed our database in
>>> the passed two days. Most of these accesses are acceptable,
>>> however I have marked four of these accounts for removal because
>>> no one seems to know what they are doing. If any of these
>>> accounts marked below for removal are doing something useful that
>>> you are aware of please let me know ASAP of they will be deleted.
>>> Please note this is a list only of accounts that are actively
>>> accessing our database. A full list of accounts to be deleted
>>> will be sent out later today.
>>>
>>> +----------+-----------------------------+-------------+
>>> | user | host | Action |
>>> +----------+-----------------------------+-------------+
>>> | ehprepl | ehp1.cr.usgs.gov | |
>>> | ehprepl | ehp3.gps.caltech.edu | |
>>> | ehprepl | ehp4.cr.usgs.gov | |
>>> | ehprepl | ehpbackup.cr.usgs.gov | |
>>> | ehprepl | ehpdevel.cr.usgs.gov | |
>>> | ehprepl | gldsvrbuild1.cr.usgs.gov | |
>>> | hmind | localhost | |
>>> | lisa | igskcicgltlwald.cr.usgs.gov | |
>>> | netops | gldqc.cr.usgs.gov | |
>>> | quake | localhost | |
>>> | root | localhost | |
>>> | shaefner | jayhawk.wr.usgs.gov | |
>>> | web | ehpmaster.wr.usgs.gov | |
>>> | web | ehzeast.er.usgs.gov | DELETE |
>>> | web | ehzmenlo.wr.usgs.gov | DELETE |
>>> | web | ehznorth.wr.usgs.gov | DELETE |
>>> | web | localhost | |
>>> | webwrite | ehp1.cr.usgs.gov | |
>>> | webwrite | ehp2.wr.usgs.gov | |
>>> | webwrite | ehp3.gps.caltech.edu | |
>>> | webwrite | ehp4.cr.usgs.gov | |
>>> | webwrite | ehpmaster.wr.usgs.gov | |
>>> | webwrite | nsmprt1.wr.usgs.gov | DELETE |
>>> +----------+-----------------------------+-------------+
>>>
>>> Remember I will be deleting accounts at 13:00 MST today, so please
>>> respond ASAP to avoid headaches.
>>>
>>> Thanks,
>>> ~Eric.
>>>
>>>
>>>
>>> Begin forwarded message:
>>>
>>>> From: Eric Martinez <emartinez at usgs.gov>
>>>> Date: October 22, 2008 10:50:44 AM MDT
>>>> To: EHPweb <ehpweb at geohazards.usgs.gov>
>>>> Subject: Database Access
>>>>
>>>> All -
>>>> Some accounts that we were fairly certain could be deleted have
>>>> been. If you are accessing the database on ehpmaster (or any
>>>> other web server) from ANY server using ANY username, please let
>>>> me know. You can reply by filling in the blanks below:
>>>>
>>>> I use the _________ user to access the database on the machine
>>>> ________ from the machine ________. It is used for the ________
>>>> process.
>>>>
>>>> Let me know about accounts even if you think it is a very common
>>>> account and safe from being deleting. Any account that I am not
>>>> explicitly told about will be deleted tomorrow at 13:00 MST. If
>>>> you think anybody who might need to know about this and is not on
>>>> this mailing list, please forward it ASAP. If you know of
>>>> anybody who might need to know about this and is on leave right
>>>> now, please reply to me so I can accommodate.
>>>>
>>>> Below is a list of accounts that have recently accessed our
>>>> database on ehpmaster. Please let me know if you think any of
>>>> these accounts are performing old actions that are no longer
>>>> needed and could be deleted.
>>>>
>>>> ehprepl at ehp1.cr.usgs.gov
>>>> ehprepl at ehp2.wr.usgs.gov
>>>> ehprepl at ehp3.gps.caltech.edu
>>>> ehprepl at ehp4.cr.usgs.gov
>>>> ehprepl at ehpbackup.cr.usgs.gov
>>>> ehprepl at ehpdevel.cr.usgs.gov
>>>> ehprepl at gldsvrbuild1.cr.usgs.gov
>>>> hmind at localhost
>>>> lisa at igskcicgltlwald.cr.usgs.gov
>>>> quake at localhost
>>>> root at localhost
>>>> shaefner at jayhawk.wr.usgs.gov
>>>> web at ehpmaster.wr.usgs.gov
>>>> web at ehzeast.er.usgs.gov
>>>> web at ehzmenlo.wr.usgs.gov
>>>> web at ehznorth.wr.usgs.gov
>>>> web at localhost
>>>> webwrite at ehp1.cr.usgs.gov
>>>> webwrite at ehp2.wr.usgs.gov
>>>> webwrite at ehp3.gps.caltech.edu
>>>> webwrite at ehp4.cr.usgs.gov
>>>> webwrite at ehpmaster.wr.usgs.gov
>>>> webwrite at nsmprt1.wr.usgs.gov
>>>>
>>>> Thanks,
>>>> ~Eric.
>>
>
> _______________________________________________
> EHPweb mailing list
> EHPweb at geohazards.usgs.gov
> https://geohazards.usgs.gov/mailman/listinfo/ehpweb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://geohazards.usgs.gov/pipermail/ehpweb/attachments/20081023/a72d9afc/attachment-0001.html
More information about the EHPweb
mailing list