Re: [SM-PLUGINS] Caurier Vacation and Postfixadmin/Users

[Paul L. <pa...@sq...>]

Rocco Scappatura wrote:
> Hello Paul,
> 
> I dont think that this fit my needs nor Gabriele needs...
> 
> Infact Postfixadmin use the MySQL DB with the following schema:
> 
> +-------------------+
> | Tables_in_postfix |
> +-------------------+
> | admin             |
> | alias             |
> | domain            |
> | domain_admins     |
> | log               |
> | mailbox           |
> | vacation          |
> +-------------------+
> 
> The information about vacation are put into the 'vacation' table:
> 
> +---------+--------------+------+-----+---------------------+-------+
> | Field   | Type         | Null | Key | Default             | Extra |
> +---------+--------------+------+-----+---------------------+-------+
> | email   | varchar(255) |      | PRI |                     |       |
> | subject | varchar(255) |      |     |                     |       |
> | body    | text         |      |     |                     |       |
> | cache   | text         |      |     |                     |       |
> | domain  | varchar(255) |      |     |                     |       |
> | created | datetime     |      |     | 0000-00-00 00:00:00 |       |
> | active  | tinyint(4)   |      |     | 1                   |       |
> +---------+--------------+------+-----+---------------------+-------+
> 
> while the user information are contained into the 'mailbox' table:
> 
> +----------+--------------+------+-----+---------------------+-------+
> | Field    | Type         | Null | Key | Default             | Extra |
> +----------+--------------+------+-----+---------------------+-------+
> | username | varchar(255) |      | PRI |                     |       |
> | password | varchar(255) |      |     |                     |       |
> | name     | varchar(255) |      | UNI |                     |       |
> | maildir  | varchar(255) |      |     |                     |       |
> | quota    | int(10)      |      |     | -1                  |       |
> | domain   | varchar(255) |      |     |                     |       |
> | created  | datetime     |      |     | 0000-00-00 00:00:00 |       |
> | modified | datetime     |      |     | 0000-00-00 00:00:00 |       |
> | active   | tinyint(4)   |      |     | 1                   |       |
> +----------+--------------+------+-----+---------------------+-------+
> 
> If I well understood, your plug in store information about user vacations on
> filesystem and take on DB only the informations about user..

As I have said more than once now, you need to carefully read the README
file and the configuration file.

I am not here to hold your hand for free.