HomeServer14B の履歴(No.2)

履歴一覧
差分を表示
現在との差分を表示
ソースを表示
HomeServer14B へ行く。
- 1 (2017-08-26 (土) 02:33:35)
- 2 (2017-08-26 (土) 04:32:42)
- 3 (2017-08-29 (火) 04:54:31)
- 4 (2017-08-30 (水) 05:14:19)
- 5 (2017-08-31 (木) 04:37:00)
- 6 (2017-09-02 (土) 09:05:51)
- 7 (2017-09-03 (日) 02:57:11)
- 8 (2018-11-24 (土) 11:32:31)

メールサーバーを AWS 環境に移行†

hostname = mail.hmuna.com ←　ローカルのサーバー名と同じ名前を設定
- Ubuntu Linux が実行されているプライベート Amazon EC2 インスタンスに静的ホスト名を割り当てる方法
MYSQL admin pass = mysqladmin (現在のサーバーと同じにした）

旧サーバーから vmailbox のアカウント名と保管場所を記録したデータベースを AWS サーバーに移行する

旧サーバーの登録情報（ /var/www/html/postfixadmin/config.inc.php )

$CONF['database_type'] = 'mysql';
$CONF['database_host'] = 'localhost';
$CONF['database_user'] = 'mail-admin';
$CONF['database_password'] = 'admin7785';
$CONF['database_name'] = 'mail';

旧サーバーのデータベースダンプ　------- &ref(): File not found: "maildb_backup_20170825.sql" at page "HomeServer14B";
```
mail-admin@mail:~$ mysqldump -u root -p mail > maildb_backup_20170825.sql
Enter password:   <---- mysqladmin
```

mail データベースの中の mailbox テーブルの中味を表示

mysql> use mail;

mysql> show tables;
+-----------------------+
| Tables_in_mail        |
+-----------------------+
| admin                 |
| alias                 |
| alias_domain          |
| config                |
| domain                |
| domain_admins         |
| fetchmail             |
| log                   |
| mailbox               |
| quota                 |
| quota2                |
| vacation              |
| vacation_notification |
+-----------------------+

mysql> describe mailbox;
+------------+--------------+------+-----+---------------------+-------+
| Field      | Type         | Null | Key | Default             | Extra |
+------------+--------------+------+-----+---------------------+-------+
| username   | varchar(255) | NO   | PRI | NULL                |       |
| password   | varchar(255) | NO   |     | NULL                |       |
| name       | varchar(255) | NO   |     | NULL                |       |
| maildir    | varchar(255) | NO   |     | NULL                |       |
| quota      | bigint(20)   | NO   |     | 0                   |       |
| local_part | varchar(255) | NO   |     | NULL                |       |
| domain     | varchar(255) | NO   | MUL | NULL                |       |
| created    | datetime     | NO   |     | 0000-00-00 00:00:00 |       |
| modified   | datetime     | NO   |     | 0000-00-00 00:00:00 |       |
| active     | tinyint(1)   | NO   |     | 1                   |       |
+------------+--------------+------+-----+---------------------+-------+

mysql> select * from mailbox;
+------------------------+------------------------------------+----------------+-------------------------+-------+--------------+-----------+---------------------+---------------------+--------+
| username               | password                           | name           | maildir                 | quota | local_part   | domain    | created             | modified            | active |
+------------------------+------------------------------------+----------------+-------------------------+-------+--------------+-----------+---------------------+---------------------+--------+
| munakata@hmuna.com     | $1$9975d93d$7uKDdKNnb6DAYdugiIWeN0 | hisao munakata | munakata@hmuna.com/     |     0 | munakata     | hmuna.com | 2014-07-04 00:50:46 | 2014-07-04 00:50:46 |      1 |
| mail-admin@hmuna.com   | $1$773730f1$tE55MxG5mxTZPrYETPJcK0 | mail admin     | mail-admin@hmuna.com/   |     0 | mail-admin   | hmuna.com | 2014-07-04 00:50:04 | 2014-07-04 00:50:04 |      1 |
| public_mail@hmuna.com  | $1$045a718c$7weHeSb7EN0EtnV14e1xF. | hisao munakata | public_mail@hmuna.com/  |     0 | public_mail  | hmuna.com | 2014-07-04 00:51:24 | 2014-07-04 00:51:24 |      1 |
| server-admin@hmuna.com | $1$7f1c42b7$UzPUtxsgMAwwHpB3G40Ay0 | server admin   | server-admin@hmuna.com/ |     0 | server-admin | hmuna.com | 2014-07-04 00:51:48 | 2014-07-04 00:51:48 |      1 |
| yuko@hmuna.com         | $1$4b287f90$7Zott.IlT053.SxHveM.M0 | yuko           | yuko@hmuna.com/         |     0 | yuko         | hmuna.com | 2014-07-04 00:52:50 | 2014-07-04 00:52:50 |      1 |
| purple@hmuna.com       | $1$2c52aa21$9a0F8dRCzBWrebrJriY5r/ | yuko           | purple@hmuna.com/       |     0 | purple       | hmuna.com | 2014-07-04 00:53:17 | 2014-07-04 00:53:17 |      1 |
+------------------------+------------------------------------+----------------+-------------------------+-------+--------------+-----------+---------------------+---------------------+--------+

mail データーベースを新サーバーに移植

[AWS] ubuntu:~$ mysql -umail-admin -padmin7785 mail < maildb_backup_20170825.sql

postfixadmin を AWS 上で起動

postfixadmin setup password = admin7785

$CONF['setup_password'] = '6b0bca4049a0ebc2f3fe491483f197c9:501c0be9dcd5a3a2f903742281b9506fc2a1675f';

Create Admin Account for Postfix.admin
- ID = munakata@hmuna.com
- pass = frex7785