Search for email forwardings to migrate

[lferran]

Search where email forwardings are configured in the old server, to migrate them too!

[lferran]

In the old server, there is a mysql database named mailsql that stores many important information about the mail system.

The database has the following tables:

mysql> show tables;
+-------------------+
| Tables_in_mailsql |
+-------------------+
| alias             |
| orxonox_alias     |
| relocated         |
| transport         |
| users             |
| virtual           |
| virtual_orxonox   |
+-------------------+

A dump of the most useful tables follows.

mysql> select * from alias;
+----+------------+----------------------+
| id | alias      | destination          |
+----+------------+----------------------+
|  1 | root       | scheusso@orxonox.net |
|  2 | postmaster | scheusso@orxonox.net |
|  4 | admin      | scheusso@orxonox.net |
+----+------------+----------------------+

mysql> select * from orxonox_alias;
+----+----------+--------------------------+
| id | alias    | destination              |
+----+----------+--------------------------+
|  4 | patrick  | boenzlip@orxonox.net     |
|  7 | wenners  | nowic@orxonox.ethz.ch    |
|  6 | beni     | bknecht@orxonox.ethz.ch  |
|  8 | stefalie | lieni@orxonox.ethz.ch    |
|  9 | silvan   | silvan@orxonox.ethz.ch   |
| 10 | x3n      | landauf@orxonox.ethz.ch  |
| 11 | nico     | nicolasc@orxonox.ethz.ch |
| 13 | felix    | felischu@orxonox.ethz.ch |
| 14 | reto     | rgrieder@orxonox.ethz.ch |
| 15 | oli      | scheusso@orxonox.ethz.ch |
+----+----------+--------------------------+

mysql> select * from users;
+----+----------------------+----------+-----------------+------+------+----------------+--------------------------+-------+---------+
| id | email                | clear    | name            | uid  | gid  | homedir        | maildir                  | quota | postfix |
+----+----------------------+----------+-----------------+------+------+----------------+--------------------------+-------+---------+
|  1 | boenzlip@orxonox.net | password | Patrick Boenzli | 1000 |  100 | /home/boenzlip | /home/boenzlip/.maildir/ |       | y       |
|  2 | bensch@orxonox.net   | password | Benjamin Grauer | 1101 | 1101 | /home/bensch   | /home/bensch/.maildir    |       | y       |
|  3 | hofzge@orxonox.net   | password | Simon Hofmann   | 1006 |  100 | /home/hofzge   | /home/hofzge/.maildir    |       | y       |
|  4 | bknecht@orxonox.net  | password | Benjamin Knecht | 1007 |  100 | /home/bknecht  | /home/bknecht/.maildir   |       | y       |
|  5 | nowic@orxonox.net    | password | Simon Wenner    | 1008 | 1008 | /home/nowic    | /home/nowic/.maildir     |       | y       |
+----+----------------------+----------+-----------------+------+------+----------------+--------------------------+-------+---------+

The remaining tables are either empty or contain useless information.