Project

General

Profile

Support #16787

remove unused Minos Mysql accounts

Added by Arthur Kreymer about 3 years ago. Updated about 3 years ago.

Status:
Work in progress
Priority:
Low
Start date:
06/08/2017
Due date:
06/15/2017
% Done:

50%

Estimated time:
3.00 h
Duration: 8

Description

Per a 2017/06/06 email from svetlana,
we should drop unused accounts and networks.

The Soudan lab was shut down in July 2016.
%.soudan.org entries can be removed.

The guest, nova, and reader_old accounts can be removed.
They have not been used since 2015
and should not be needed in the future.

I will open a Service Desk Request for this.

History

#1 Updated by Arthur Kreymer about 3 years ago


    COUNT LOG FILES

cd /minos/data/web/database/topdb/minos-db1

find 20* -type f -name \*.txt  | wc -l
40546

    SCAN FOR CANDIDATE USER USAGE

    GUEST

for YEAR in 2012 2013 2014 2015 2016 2017 ; do
   printf "${YEAR} " 
   find ${YEAR} -type f -name \*.txt  -exec grep ' guest ' {} \; | wc -l
done

2012 61038
2013 39744
2014 41878
2015 0
2016 0
2017 0

    NOVA

for YEAR in 2012 2013 2014 2015 2016 2017 ; do
   printf "${YEAR} " 
   find ${YEAR} -type f -name \*.txt  -exec grep ' nova ' {} \; | wc -l
done

2012 0
2013 146
2014 33
2015 0
2016 0
2017 0

    READER_OLD

for YEAR in 2012 2013 2014 2015 2016 2017 ; do
   printf "${YEAR} " 
   find ${YEAR} -type f -name \*.txt  -exec grep ' reader_old ' {} \; | wc -l
done

2012 20
2013 2954
2014 48
2015 3
2016 0
2017 0

#2 Updated by Arthur Kreymer about 3 years ago

I submitted
RITM0571072 06/08 Minos mysql database user updates

The requested users have been removed, thanks !

Donatella has prepared minos-daq24-nd for the switch for write_old to writer.
Waiting for a beam downtime to do the switch.

#3 Updated by Arthur Kreymer about 3 years ago

There is no scheduled beam downtime before the July 7 shutdown.

We will stand by, waiting for unscheduled downtime
to make the switch from writer_old to writer.

#4 Updated by Arthur Kreymer about 3 years ago

sorry, this entry was intended for https://cdcvs.fnal.gov/redmine/issues/16746

#5 Updated by Arthur Kreymer about 3 years ago

The connections from minos-daq24-nd are now being made with writer, see
http://minos.fnal.gov/database/topdb/minos-db1/2017/06/16/09.txt using writer_old
http://minos.fnal.gov/database/topdb/minos-db1/2017/06/16/10.txt using writer

This was done by Donatella during a beam downtime Friday 06/16.

RITM0571072 has been closed.

After we see no writer_old connection for a week
I will submit a separate request to remove the writer_old account.



Also available in: Atom PDF