sqlmail postfix support

Craig Brennan craig at hanssencomputer.com.au
Thu Dec 11 23:33:53 PST 2003


So far I've managed to Install and integrate everything I've wanted into
my Freeside Server and I must say it does an excellent job. 

The only problem Im having is getting sqlmail export to work with my
Postfix server, could you tell me what fields it uses etc in the mysql
database. Ive looked at sqlmail.pm code but Im not very familiar with
DBI programming could use a few pointers. Here is my current postfix
mysql db layout.

Same as the Postfix+Courier-IMAP+MySQL multiple domain HOWTO:

http://kirb.insanegenius.net/postfix.html




mysql> show tables;
+------------------+
| Tables_in_maildb |
+------------------+
| transport        |
| users            |
| virtual          |
+------------------+
3 rows in set (0.00 sec)

mysql> describe transport;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| domain    | varchar(128) |      | PRI |         |       |
| transport | varchar(128) |      | MUL |         |       |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe virtual;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| address | varchar(255) |      | PRI |         |       |
| goto    | varchar(255) |      |     |         |       |
+---------+--------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> describe users;
+---------+----------------------+------+-----+---------+-------+
| Field   | Type                 | Null | Key | Default | Extra |
+---------+----------------------+------+-----+---------+-------+
| id      | varchar(128)         |      | PRI |         |       |
| address | varchar(128)         |      | UNI |         |       |
| crypt   | varchar(128)         |      |     |         |       |
| clear   | varchar(128)         |      |     |         |       |
| name    | varchar(128)         |      |     |         |       |
| uid     | smallint(5) unsigned |      |     | 0       |       |
| gid     | smallint(5) unsigned |      |     | 0       |       |
| home    | varchar(128)         |      |     | /       |       |
| domain  | varchar(128)         |      |     |         |       |
| maildir | varchar(255)         |      |     |         |       |
| popok   | tinyinit(3) unsigned |      |     | 1       |       |
+---------+----------------------+------+-----+---------+-------+
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://420.am/pipermail/freeside-users/attachments/20031212/6cbb7c82/attachment.html


More information about the freeside-users mailing list