[EHPweb] Fwd: Database Access

[Eric Martinez]

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.
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://geohazards.usgs.gov/pipermail/ehpweb/attachments/20081023/fbaf1a14/attachment.html