<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">All,<div><span class="Apple-tab-span" style="white-space:pre"> </span>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.</div><div><br></div><div>Stan Silverman, Scott Haefner, and Susan Garcia:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Please call me. <b>720.570.6303</b> 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.</div><div><br></div><div>Thanks,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>~Eric.<br><div><br><div>Begin forwarded message:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>From: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Eric Martinez <<a href="mailto:emartinez@usgs.gov">emartinez@usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Date: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">October 23, 2008 1:02:27 PM MDT</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>To: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">EHPweb <<a href="mailto:ehpweb@geohazards.usgs.gov">ehpweb@geohazards.usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Subject: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><b>[EHPweb] Fwd: Database Access</b></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div> </div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">All,<div><span class="Apple-tab-span" style="white-space:pre"> </span>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.</div><div><br></div><div>Thanks,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>~Eric.<br><div><br><div>Begin forwarded message:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>From: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Eric Martinez <<a href="mailto:emartinez@usgs.gov">emartinez@usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Date: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">October 23, 2008 11:31:57 AM MDT</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>To: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">EHPweb <<a href="mailto:ehpweb@geohazards.usgs.gov">ehpweb@geohazards.usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Subject: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><b>Fwd: Database Access</b></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div> </div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">All,<div><span class="Apple-tab-span" style="white-space:pre"> </span>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.</div><div><br></div><div>Thanks,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>~Eric.</div><div><br></div></div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div></div><div><br><div>Begin forwarded message:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>From: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Eric Martinez <<a href="mailto:emartinez@usgs.gov">emartinez@usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Date: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">October 23, 2008 9:54:03 AM MDT</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>To: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">EHPweb <<a href="mailto:ehpweb@geohazards.usgs.gov">ehpweb@geohazards.usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Subject: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><b>Fwd: Database Access</b></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div> </div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">All,<div><span class="Apple-tab-span" style="white-space:pre"> </span>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.<br></div><div><br></div><div><font class="Apple-style-span" face="Courier">+----------+-----------------------------+-------------+</font></div><div><font class="Apple-style-span" face="Courier">| user | host | Action |</font></div><div><font class="Apple-style-span" face="Courier">+----------+-----------------------------+-------------+</font></div><div><font class="Apple-style-span" face="Courier"><div>| ehprepl | ehp1.cr.usgs.gov | |</div><div>| ehprepl | ehp3.gps.caltech.edu | |</div><div>| ehprepl | ehp4.cr.usgs.gov | |</div><div>| ehprepl | ehpbackup.cr.usgs.gov | |</div><div>| ehprepl | ehpdevel.cr.usgs.gov | |</div><div>| ehprepl | gldsvrbuild1.cr.usgs.gov | |</div><div>| hmind | localhost | |</div><div>| lisa | igskcicgltlwald.cr.usgs.gov | |</div><div>| netops | gldqc.cr.usgs.gov | |</div><div>| quake | localhost | |</div><div>| root | localhost | |</div><div>| shaefner | jayhawk.wr.usgs.gov | |</div><div>| web | ehpmaster.wr.usgs.gov | |</div><div>| web | ehzeast.er.usgs.gov | DELETE |</div><div>| web | ehzmenlo.wr.usgs.gov | DELETE |</div><div>| web | ehznorth.wr.usgs.gov | DELETE |</div><div>| web | localhost | |</div><div>| webwrite | ehp1.cr.usgs.gov | |</div><div>| webwrite | ehp2.wr.usgs.gov | |</div><div>| webwrite | ehp3.gps.caltech.edu | |</div><div>| webwrite | ehp4.cr.usgs.gov | |</div><div>| webwrite | ehpmaster.wr.usgs.gov | |</div><div>| webwrite | nsmprt1.wr.usgs.gov | DELETE |</div><div>+----------+-----------------------------+-------------+</div></font></div><div><br></div><div>Remember I will be deleting accounts at 13:00 MST today, so please respond ASAP to avoid headaches.</div><div><br></div><div>Thanks,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>~Eric.<br></div><div><br></div><div><br><div><br><div>Begin forwarded message:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>From: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Eric Martinez <<a href="mailto:emartinez@usgs.gov">emartinez@usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Date: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">October 22, 2008 10:50:44 AM MDT</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>To: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica">EHPweb <<a href="mailto:ehpweb@geohazards.usgs.gov">ehpweb@geohazards.usgs.gov</a>></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" color="#000000" style="font: 12.0px Helvetica; color: #000000"><b>Subject: </b></font><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><b>Database Access</b></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div> </div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">All -<div><span class="Apple-tab-span" style="white-space:pre"> </span>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:<br></div><div><br></div><div><b>I use the _________ user to access the database on the machine ________ from the machine ________. It is used for the ________ process.</b></div><div><br></div><div>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 <b>tomorrow at </b><b>13:00 MST</b>. 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.</div><div><br></div><div>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.</div><div><br></div><div><div><a href="mailto:ehprepl@ehp1.cr.usgs.gov">ehprepl@ehp1.cr.usgs.gov</a></div><div><a href="mailto:ehprepl@ehp2.wr.usgs.gov">ehprepl@ehp2.wr.usgs.gov</a></div><div><a href="mailto:ehprepl@ehp3.gps.caltech.edu">ehprepl@ehp3.gps.caltech.edu</a></div><div><a href="mailto:ehprepl@ehp4.cr.usgs.gov">ehprepl@ehp4.cr.usgs.gov</a></div><div><a href="mailto:ehprepl@ehpbackup.cr.usgs.gov">ehprepl@ehpbackup.cr.usgs.gov</a></div><div><a href="mailto:ehprepl@ehpdevel.cr.usgs.gov">ehprepl@ehpdevel.cr.usgs.gov</a></div><div><a href="mailto:ehprepl@gldsvrbuild1.cr.usgs.gov">ehprepl@gldsvrbuild1.cr.usgs.gov</a></div><div>hmind@localhost</div><div><a href="mailto:lisa@igskcicgltlwald.cr.usgs.gov">lisa@igskcicgltlwald.cr.usgs.gov</a></div><div>quake@localhost</div><div>root@localhost</div><div><a href="mailto:shaefner@jayhawk.wr.usgs.gov">shaefner@jayhawk.wr.usgs.gov</a></div><div><a href="mailto:web@ehpmaster.wr.usgs.gov">web@ehpmaster.wr.usgs.gov</a></div><div><a href="mailto:web@ehzeast.er.usgs.gov">web@ehzeast.er.usgs.gov</a></div><div><a href="mailto:web@ehzmenlo.wr.usgs.gov">web@ehzmenlo.wr.usgs.gov</a></div><div><a href="mailto:web@ehznorth.wr.usgs.gov">web@ehznorth.wr.usgs.gov</a></div><div>web@localhost</div><div><a href="mailto:webwrite@ehp1.cr.usgs.gov">webwrite@ehp1.cr.usgs.gov</a></div><div><a href="mailto:webwrite@ehp2.wr.usgs.gov">webwrite@ehp2.wr.usgs.gov</a></div><div><a href="mailto:webwrite@ehp3.gps.caltech.edu">webwrite@ehp3.gps.caltech.edu</a></div><div><a href="mailto:webwrite@ehp4.cr.usgs.gov">webwrite@ehp4.cr.usgs.gov</a></div><div><a href="mailto:webwrite@ehpmaster.wr.usgs.gov">webwrite@ehpmaster.wr.usgs.gov</a></div><div><a href="mailto:webwrite@nsmprt1.wr.usgs.gov">webwrite@nsmprt1.wr.usgs.gov</a></div><div><br></div><div>Thanks,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>~Eric.</div></div></div></blockquote></div></div></div></blockquote></div><br></div></div></blockquote></div><br></div></div>_______________________________________________<br>EHPweb mailing list<br><a href="mailto:EHPweb@geohazards.usgs.gov">EHPweb@geohazards.usgs.gov</a><br>https://geohazards.usgs.gov/mailman/listinfo/ehpweb<br></blockquote></div><br></div></body></html>