Различия

Здесь показаны различия между двумя версиями данной страницы.

--- freebsd:seafile [2020/01/04 15:51]
alex
+++ freebsd:seafile [2020/11/23 21:01] (текущий)
alex [Перенос SeaFile на новый сервер]
@@ Строка 70: / Строка 70: @@
   create user 'seafile'@'10.215.130.22' identified by 'Kl0T1k#$ea';
-  Query OK, 0 rows affected (0.02 sec)
   GRANT ALL PRIVILEGES ON `ccnet-db`.* to `seafile`@10.215.130.22;
-  Query OK, 0 rows affected (0.03 sec)
   GRANT ALL PRIVILEGES ON `seafile-db`.* to `seafile`@10.215.130.22;
-  Query OK, 0 rows affected (0.02 sec)
   GRANT ALL PRIVILEGES ON `seahub-db`.* to `seafile`@10.215.130.22;
-  Query OK, 0 rows affected (0.02 sec)
   CREATE USER 'root'@'10.215.130.22' IDENTIFIED BY 'Ce,,0nf#';
-  Query OK, 0 rows affected (0.02 sec)
   GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.215.130.22';
-  Query OK, 0 rows affected (0.02 sec)
   FLUSH PRIVILEGES;
-  Query OK, 0 rows affected (0.01 sec)
   select user,host from mysql.user;
@@ Строка 536: / Строка 523: @@
-=== Запуск сервера ===
+==== Запуск сервера ====
 В /etc/rc.conf добавляю строки
   sysrc seafile_enable=YES
@@ Строка 576: / Строка 563: @@
 Сервер доступен по адресу **10.215.130.22:8000**
-=== Перенос SeaFile на новый сервер ===
+==== Перенос SeaFile на новый сервер ====
 После всего проделанного останавливаю SeaFile сервер.
   service seafile stop
-  service seahub start
+  service seahub stop
 На старых серверах делаю дампы баз данных SeaFile
+ # mysqldump -u seafile -p ccnet-db > ccnet-db.sql
+Enter password:
+mysqldump: Got error: 1045: Access denied for user 'seafile'@'localhost' (using password: YES) when trying to connect
+root@jail_1:/ #
+root@jail_1:/ # mysql -uroot -p
+Enter password:
+Welcome to the MySQL monitor.  Commands end with ; or \g.
+Your MySQL connection id is 8
+Server version: 5.7.29-log Source distribution
+Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
+Oracle is a registered trademark of Oracle Corporation and/or its
+affiliates. Other names may be trademarks of their respective
+owners.
+Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
+root@localhost [(none)]> select user,host from mysql.user;
++---------------+-------------+
+| user          | host        |
++---------------+-------------+
+| root          | 192.168.0.3 |
+| seafile       | 192.168.0.3 |
+| mysql.session | localhost   |
+| mysql.sys     | localhost   |
+| root          | localhost   |
++---------------+-------------+
+rows in set (0.19 sec)
+root@localhost [(none)]> create user 'seafile'@'localhost' identified by 'Kl0T1k#$ea';
+Query OK, 0 rows affected (0.28 sec)
+root@localhost [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'seafile'@'localhost';
+Query OK, 0 rows affected (0.03 sec)
+root@localhost [(none)]> FLUSH PRIVILEGES;
+Query OK, 0 rows affected (0.09 sec)
+root@localhost [(none)]> select user,host from mysql.user;
++---------------+-------------+
+| user          | host        |
++---------------+-------------+
+| root          | 192.168.0.3 |
+| seafile       | 192.168.0.3 |
+| mysql.session | localhost   |
+| mysql.sys     | localhost   |
+| root          | localhost   |
+| seafile       | localhost   |
++---------------+-------------+
+rows in set (0.00 sec)
+root@localhost [(none)]> quit
   mysqldump -u seafile -p ccnet-db > ccnet-db.sql
   mysqldump -u seafile -p seafile-db > seafile-db.sql
@@ Строка 625: / Строка 667: @@
   USE seafile-db
   SHOW TABLES;
+После восстановления данных из дампа даю права пользователю seafile на базы данных
+  GRANT ALL PRIVILEGES ON `ccnet-db`.* to `seafile`@10.215.130.22;
+  GRANT ALL PRIVILEGES ON `seafile-db`.* to `seafile`@10.215.130.22;
+  GRANT ALL PRIVILEGES ON `seahub-db`.* to `seafile`@10.215.130.22;
+  FLUSH PRIVILEGES;
 В файле /usr/local/www/haiwen/ccnet/**seafile.ini** указываю путь до данных со старого сервера
+Запускаю SeaFile
+  service seafile start
+  service seahub start
 ==== Seahub с Nginx ====
@@ Строка 883: / Строка 934: @@
   }
+Для получения файла **dhparam.pem** выполняю
+  openssl dhparam -out /usr/local/etc/nginx/dhparam.pem 2048
 Перезапускаю сервер
@@ Строка 998: / Строка 1052: @@
 https://www.8host.com/blog/sinxronizaciya-i-sovmestnoe-ispolzovanie-fajlov-s-pomoshhyu-seafile-v-debian-9\\
 https://zaraev.blogspot.com/2015/12/seafile-debian-dropbox.html\\
-https://forum.seafile.com/t/tutorial-for-server-migration-importing-mysql-mariadb-databases-and-seafile-data/132
+https://forum.seafile.com/t/tutorial-for-server-migration-importing-mysql-mariadb-databases-and-seafile-data/132\\
+https://gist.github.com/plentz/6737338\\
+https://myhosti.pro/faq/adminos/web/nginx/pri-vkliuchenii-u-www-domena-oshibka-dhparampem

klotik.ru

Инструменты пользователя

Инструменты сайта

Различия

Инструменты страницы