Hi again,<br>OK, the permissions have been altered. If you were on the list of IPs below, please make sure you see 90 databases in the output of the command:<br> mysql -u clasuser -h <a href="http://clasdb.jlab.org/">clasdb.jlab.org</a> -e 'show databases;'<br>
If not, please email me. Thanks,<br>--Johann.<br><br>P.S. On a related note, the database connection problem with the shift pages are currently being addressed.<br><br><div class="gmail_quote">---------- Forwarded message ----------<br>
From: <b class="gmail_sendername">Johann Goetz</b> <<a href="mailto:jgoetz@ucla.edu">jgoetz@ucla.edu</a>><br>Date: Thu, Aug 18, 2011 at 9:55 AM<br>Subject: cleaning up clasdb permissions tables.<br>
To: Dennis Weygand <<a href="mailto:weygand@jlab.org">weygand@jlab.org</a>>, Kari Heffner <<a href="mailto:heffner@jlab.org">heffner@jlab.org</a>>, CLAS Offline <<a href="mailto:clas_offline@jlab.org">clas_offline@jlab.org</a>><br>
<br><br>Hello offliners,<br><br>There a eight off-site IP addresses or subnets that have their own entry in the MySQL <a href="http://clasdb.jlab.org">clasdb.jlab.org</a> permissions tables (see below). We have already run into problems because these entries are often more restrictive than the defaults for the user 'clasuser'. Therefore, we plan on removing these entries from the permissions table. This will take place tomorrow morning on Friday August 19, 2011.<br>
<br><b>There should be no interruption in access to the database from these IP addresses during the switch, but since the permissions tables are quite messy, we can not guarantee this.</b> I will monitor my email very closely after the change, and if its an emergency, please call me at my office or my cell phone (see my signature below). If you recognize your IP in the list, I would appreciate it if you would test accessing the database from there --- either by running user_ana/a1c or gsim or simply the following mysql command which should show 90 databases:<br>
<br> mysql -u clasuser -h <a href="http://clasdb.jlab.org">clasdb.jlab.org</a> -e 'show databases;'<br><br>Here is a list of the IP address that will be removed. The permissions will go back to the default for clasuser logging in from off-site. Again, we do not expect anyone on this list to experience connection problems, but I wanted to give you guys the "heads up" in case things break.<br>
<br>
141.166.223.41<br>
%.<a href="http://uva.edu/">uva.edu</a><br>
%.<a href="http://virginia.edu/">virginia.edu</a><br>
192.160.243.114<br>
%.<a href="http://cnu.edu/">cnu.edu</a><br>
128.82.117.%<br>
128.82.117.50<br>
155.135.55.% <br clear="all"><font color="#888888"><br>-- <br>Johann T. Goetz, PhD.<br><a href="mailto:jgoetz@ucla.edu">jgoetz@ucla.edu</a><br>Nefkens Group, UCLA Dept. of Physics & Astronomy<br>Hall-B, Jefferson Lab, Newport News, VA<br>
Office: <a href="tel:757-269-5465">757-269-5465</a> (CEBAF Center F-335)<br>Mobile: <a href="tel:757-768-9999">757-768-9999</a><br>
</font></div><br><br clear="all"><br>-- <br>Johann T. Goetz, PhD.<br><a href="mailto:jgoetz@ucla.edu">jgoetz@ucla.edu</a><br>Nefkens Group, UCLA Dept. of Physics & Astronomy<br>Hall-B, Jefferson Lab, Newport News, VA<br>
Office: 757-269-5465 (CEBAF Center F-335)<br>Mobile: 757-768-9999<br><br>