[Clas_offline] cleaning up clasdb permissions tables.

[Johann Goetz]

Hello offliners,

There a eight off-site IP addresses or subnets that have their own entry in
the MySQL clasdb.jlab.org 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.

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

    mysql -u clasuser -h clasdb.jlab.org -e 'show databases;'

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.

141.166.223.41
%.uva.edu
%.virginia.edu
192.160.243.114
%.cnu.edu
128.82.117.%
128.82.117.50
155.135.55.%

-- 
Johann T. Goetz, PhD.
jgoetz at ucla.edu
Nefkens Group, UCLA Dept. of Physics & Astronomy
Hall-B, Jefferson Lab, Newport News, VA
Office: 757-269-5465 (CEBAF Center F-335)
Mobile: 757-768-9999
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman.jlab.org/pipermail/clas_offline/attachments/20110818/3cc97bf0/attachment.html