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