Mouse-svn < CF

CF Web>Research>ResearchGroups>VisionLab>Mouse-svn (2021-03-11, MikeGore) (raw view)

---+ Title

Article text.

-- %USERSIG{MikeGore - 2020-09-24}%

---++ Comments

%COMMENT%

---++ mouse SVN running on cs-tech1-vm.cs.uwaterloo.ca for testing
   * All original accounts are running passwords restored
   * The svn data has been restore */var/svn/repo/name of repository goes here*     it will ask for user and password authentication


---++ Old mouse.cs
   * Interesting applicatons
      * mysql-server-5.0 mysql-client-5.0 php5-mysql php5-mysqli php5 phpmyadmin apache2 apache2-utils libapache2-mod-php5   libapache2-mod-svn subversion git-svn  git-svnmediawiki

   * mysql version 5.0
   * Databases
      * wikidb_vision
      * wikidb_digs
      * mysql
   * Users
      * wikiuser

---+++ Exporting MYSQL 5.0 databases
<verbatim>
PASS=DELETED
mysqldump -u root -p$PASS --add-drop-table --all-databases >/mouse-50_databases_all.sql
</verbatim>

---+++ Exporting MYSQL 5.0 users
<verbatim>
PASS=DELETED
mysql -u root -p$PASS --skip-column-names -A -e "SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') AS query FROM mysql.user WHERE user NOT IN  ('root','pma','phpmyadmin','debian-sys-maint')" | mysql -u root -p$PASS --skip-column-names -A | sed 's/$/;/g'  > /mouse-50_mysql_all_users_sql
</verbatim>

---+++ mediawiki
   * /var/lib/mediawiki/vision/LocalSettings.php
      * Settings and account and settings for wikidb_vision
   * /var/lib/mediawiki/digs/LocalSettings.php
      * Settings and account and settings for  wikidb_vision

---++ Updating via 18.04LTS VM


---+++ Software
   * apt-get install net-tools
   * apt-get install mysql-client-5.7 mysql-server-5.7 mediawiki apache2 subversion libapache2-mod-svn  git-svn phpmyadmin mediawiki
---+++ Importing Databases
#import all databases
<verbatim>
PASS=DELETED
mysql -u root -p$PASS --force < /mouse-50_databases_all.sql
</verbatim>
---+++ Importing Users
<verbatim>
# We delete the PASSWORD keyword since 5.7 does not use it
# See https://stackoverflow.com/questions/27256839/mysql-script-to-create-user-and-database-with-hashed-password
sed -i -e "/ PASSWORD//" /mouse-50_mysql_all_users_sql
</verbatim>
   * Added *SELECT User, Host FROM mysql.user;* as first line of */mouse-50_mysql_all_users_sql*
   * Added *flush privileges; before every line to  */mouse-50_mysql_all_users_sql*
---+++ Upgrading databases
<verbatim>
PASS=DELETED
mysql_upgrade -u root -p$PASS
# Run it again after fixing mysql root user passwword
</verbatim>
---+++ Exporting MYSQL Database from 18.04 VM
<verbatim>
PASS=DELETED
mysqldump -u root -p$PASS --all-databases --ignore-table=mysql.innodb_index_stats --ignore-table=mysql.innodb_table_stats  -
-add-drop-table >/mouse-vm_57_databases_all.sql
</verbatim>
---+++ Exporting MYSQL Users from 18.04
<verbatim>
mysql -u root -p$PASS --skip-column-names -A -e "SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') AS query FROM m
ysql.user WHERE user NOT IN ('root','pma','phpmyadmin','debian-sys-maint')" | mysql -u root -p$PASS --skip-column-names -A |
 sed 's/$/;/g' > /mouse-vm_57_mysql_all_users_sql
</verbatim>


---++ Mouse 20.04:TS
---+++ Software
   * apt-get install net-tools
   * apt-get install mysql-client-8.0 mysql-server-8.0 mediawiki apache2 subversion libapache2-mod-svn  git-svn phpmyadmin mediawiki
---+++ Importing Databases
#import all databases
<verbatim>
PASS=DELETED
mysql -u root -p$PASS --force < /mouse-vm_57_databases_all.sql
systemctl restart mysql
</verbatim>
---+++ Importing Users
<verbatim>
# We delete the PASSWORD keyword since 5.7 does not use it
# See https://stackoverflow.com/questions/27256839/mysql-script-to-create-user-and-database-with-hashed-password
sed -i -e "/ PASSWORD//" /mouse-vm_57_mysql_all_users_sql
</verbatim>
   * Added *SELECT User, Host FROM mysql.user;* as first line of */mouse-vm_57_mysql_all_users_sql*
   * Added *flush privileges; before every line to  */mouse-vm_57_mysql_all_users_sql*

Topic revision: r2 - 2021-03-11 - MikeGore

Information in this area is meant for use by CSCF staff and is not official documentation, but anybody who is interested is welcome to use it if they find it useful.

Other Webs

My links
- People
- CERAS
- WatForm
- Tetherless lab
- Ubuntu Main.HowTo
- eDocs
- RGG NE notes
- RGG
- CS infrastructure
- Grad images

Edit