3.2beta2 issues mail server

Discussion in 'Developers' Forum' started by NueX, Sep 23, 2020.

  1. NueX

    NueX Member

    Requested table definitions:
    Code:
    MariaDB [dbispconfig]> describe mail_domain;
    +----------------+------------------+------+-----+---------+----------------+
    | Field          | Type             | Null | Key | Default | Extra          |
    +----------------+------------------+------+-----+---------+----------------+
    | domain_id      | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
    | sys_userid     | int(11) unsigned | NO   |     | 0       |                |
    | sys_groupid    | int(11) unsigned | NO   |     | 0       |                |
    | sys_perm_user  | varchar(5)       | NO   |     |         |                |
    | sys_perm_group | varchar(5)       | NO   |     |         |                |
    | sys_perm_other | varchar(5)       | NO   |     |         |                |
    | server_id      | int(11) unsigned | NO   | MUL | 0       |                |
    | domain         | varchar(255)     | NO   | MUL |         |                |
    | dkim           | enum('n','y')    | NO   |     | n       |                |
    | dkim_selector  | varchar(63)      | NO   |     | default |                |
    | dkim_private   | mediumtext       | YES  |     | NULL    |                |
    | dkim_public    | mediumtext       | YES  |     | NULL    |                |
    | active         | enum('n','y')    | NO   |     | n       |                |
    +----------------+------------------+------+-----+---------+----------------+
    13 rows in set (0.001 sec)
    
    MariaDB [dbispconfig]> describe mail_user;
    +--------------------------+-------------------+------+-----+---------------------+----------------+
    | Field                    | Type              | Null | Key | Default             | Extra          |
    +--------------------------+-------------------+------+-----+---------------------+----------------+
    | mailuser_id              | int(11) unsigned  | NO   | PRI | NULL                | auto_increment |
    | sys_userid               | int(11) unsigned  | NO   |     | 0                   |                |
    | sys_groupid              | int(11) unsigned  | NO   |     | 0                   |                |
    | sys_perm_user            | varchar(5)        | NO   |     |                     |                |
    | sys_perm_group           | varchar(5)        | NO   |     |                     |                |
    | sys_perm_other           | varchar(5)        | NO   |     |                     |                |
    | server_id                | int(11) unsigned  | NO   | MUL | 0                   |                |
    | email                    | varchar(255)      | NO   | MUL |                     |                |
    | login                    | varchar(255)      | NO   |     |                     |                |
    | password                 | varchar(255)      | NO   |     |                     |                |
    | name                     | varchar(255)      | NO   |     |                     |                |
    | uid                      | int(11)           | NO   |     | 5000                |                |
    | gid                      | int(11)           | NO   |     | 5000                |                |
    | maildir                  | varchar(255)      | NO   |     |                     |                |
    | maildir_format           | varchar(255)      | NO   |     | maildir             |                |
    | quota                    | bigint(20)        | NO   |     | -1                  |                |
    | cc                       | text              | YES  |     | NULL                |                |
    | forward_in_lda           | enum('n','y')     | NO   |     | n                   |                |
    | sender_cc                | varchar(255)      | NO   |     |                     |                |
    | homedir                  | varchar(255)      | NO   |     |                     |                |
    | autoresponder            | enum('n','y')     | NO   |     | n                   |                |
    | autoresponder_start_date | datetime          | YES  |     | NULL                |                |
    | autoresponder_end_date   | datetime          | YES  |     | NULL                |                |
    | autoresponder_subject    | varchar(255)      | NO   |     | Out of office reply |                |
    | autoresponder_text       | mediumtext        | YES  |     | NULL                |                |
    | move_junk                | enum('y','a','n') | NO   |     | y                   |                |
    | purge_trash_days         | int(11)           | NO   |     | 0                   |                |
    | purge_junk_days          | int(11)           | NO   |     | 0                   |                |
    | custom_mailfilter        | mediumtext        | YES  |     | NULL                |                |
    | postfix                  | enum('n','y')     | NO   |     | y                   |                |
    | greylisting              | enum('n','y')     | NO   |     | n                   |                |
    | access                   | enum('n','y')     | NO   |     | y                   |                |
    | disableimap              | enum('n','y')     | NO   |     | n                   |                |
    | disablepop3              | enum('n','y')     | NO   |     | n                   |                |
    | disabledeliver           | enum('n','y')     | NO   |     | n                   |                |
    | disablesmtp              | enum('n','y')     | NO   |     | n                   |                |
    | disablesieve             | enum('n','y')     | NO   |     | n                   |                |
    | disablesieve-filter      | enum('n','y')     | NO   |     | n                   |                |
    | disablelda               | enum('n','y')     | NO   |     | n                   |                |
    | disablelmtp              | enum('n','y')     | NO   |     | n                   |                |
    | disabledoveadm           | enum('n','y')     | NO   |     | n                   |                |
    | disablequota-status      | enum('n','y')     | NO   |     | n                   |                |
    | disableindexer-worker    | enum('n','y')     | NO   |     | n                   |                |
    | last_quota_notification  | date              | YES  |     | NULL                |                |
    | backup_interval          | varchar(255)      | NO   |     | none                |                |
    | backup_copies            | int(11)           | NO   |     | 1                   |                |
    +--------------------------+-------------------+------+-----+---------------------+----------------+
    46 rows in set (0.002 sec)
    
    MariaDB [dbispconfig]> describe mail_forwarding;
    +----------------+--------------------------------------------------+------+-----+---------+----------------+
    | Field          | Type                                             | Null | Key | Default | Extra          |
    +----------------+--------------------------------------------------+------+-----+---------+----------------+
    | forwarding_id  | int(11) unsigned                                 | NO   | PRI | NULL    | auto_increment |
    | sys_userid     | int(11) unsigned                                 | NO   |     | 0       |                |
    | sys_groupid    | int(11) unsigned                                 | NO   |     | 0       |                |
    | sys_perm_user  | varchar(5)                                       | NO   |     |         |                |
    | sys_perm_group | varchar(5)                                       | NO   |     |         |                |
    | sys_perm_other | varchar(5)                                       | NO   |     |         |                |
    | server_id      | int(11) unsigned                                 | NO   | MUL | 0       |                |
    | source         | varchar(255)                                     | NO   |     |         |                |
    | destination    | text                                             | YES  |     | NULL    |                |
    | type           | enum('alias','aliasdomain','forward','catchall') | NO   | MUL | alias   |                |
    | active         | enum('n','y')                                    | NO   |     | n       |                |
    | allow_send_as  | enum('n','y')                                    | NO   |     | n       |                |
    | greylisting    | enum('n','y')                                    | NO   |     | n       |                |
    +----------------+--------------------------------------------------+------+-----+---------+----------------+
    13 rows in set (0.001 sec)
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Those look good.
     
  3. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Just making sure you saw this...
     
  4. NueX

    NueX Member

    /etc/postfix/mysql-virtual_mailboxes.cf
    Code:
    user = ispconfig
    password = xxxxxx
    dbname = dbispconfig
    hosts = 127.0.0.1
    query = select CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') from mail_user where login = '%s' and postfix = 'y' and disabledeliver = 'n' and server_id = 1
    Code:
    select CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') from mail_user where login = '[email protected]' and postfix = 'y' and disabledeliver = 'n' and server_id = 1;
    Empty set (0.000 sec)
    Code:
    select CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') from mail_user where login = 'mail' and postfix = 'y' and disabledeliver = 'n' and server_id = 1;
    +----------------------------------------------------------------------------+
    | CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') |
    +----------------------------------------------------------------------------+
    | mydomain.com/mail/                                                     |
    +----------------------------------------------------------------------------+
    
    
    Code:
    select CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') from mail_user where postfix = 'y' and disabledeliver = 'n' and server_id = 1;
    +----------------------------------------------------------------------------+
    | CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') |
    +----------------------------------------------------------------------------+
    | mydomain.com/mail/                                                         |
    +----------------------------------------------------------------------------+
    
     
  5. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Also what do you get from `select * from mail_user where login = '[email protected]'`?
     
  6. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Try changing your mysql-virtual_mailboxes.cf query to:
     
  7. NueX

    NueX Member

    The query above does only return something when the login='username' not login='[email protected]'.

    Code:
    select * from mail_user where login = '[email protected]';
    Empty set (0.000 sec)
    
    select * from mail_user where login = 'mail';
    +-------------+------------+-------------+---------------+----------------+----------------+-----------+-----------------------+-------+------------------------------------+--------------+------+------+----------------------------------+----------------+------------+------+----------------+-----------+------------+---------------+--------------------------+------------------------+-----------------------+--------------------+-----------+------------------+-----------------+-------------------+---------+-------------+--------+-------------+-------------+----------------+-------------+--------------+---------------------+------------+-------------+----------------+---------------------+-----------------------+-------------------------+-----------------+---------------+
    | mailuser_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_id | email                 | login | password                           | name         | uid  | gid  | maildir                          | maildir_format | quota      | cc   | forward_in_lda | sender_cc | homedir    | autoresponder | autoresponder_start_date | autoresponder_end_date | autoresponder_subject | autoresponder_text | move_junk | purge_trash_days | purge_junk_days | custom_mailfilter | postfix | greylisting | access | disableimap | disablepop3 | disabledeliver | disablesmtp | disablesieve | disablesieve-filter | disablelda | disablelmtp | disabledoveadm | disablequota-status | disableindexer-worker | last_quota_notification | backup_interval | backup_copies |
    +-------------+------------+-------------+---------------+----------------+----------------+-----------+-----------------------+-------+------------------------------------+--------------+------+------+----------------------------------+----------------+------------+------+----------------+-----------+------------+---------------+--------------------------+------------------------+-----------------------+--------------------+-----------+------------------+-----------------+-------------------+---------+-------------+--------+-------------+-------------+----------------+-------------+--------------+---------------------+------------+-------------+----------------+---------------------+-----------------------+-------------------------+-----------------+---------------+
    |           1 |          2 |           2 | riud          | riud           |                |         1 | [email protected]     | mail | xxxx                                | Name | 5000 | 5000 | /var/vmail/mydomain.com/mail | maildir        | 5242880000 |      | n              |           | /var/vmail | n             | NULL                     | NULL                   | Out of office reply   |                    | y         |                0 |               0 |                   | y       | y           | y      | n           | n           | n              | n           | n            | n                   | n          | n           | n              | n                   | n                     | NULL                    | none            |             1 |
    +-------------+------------+-------------+---------------+----------------+----------------+-----------+-----------------------+-------+------------------------------------+--------------+------+------+----------------------------------+----------------+------------+------+----------------+-----------+------------+---------------+--------------------------+------------------------+-----------------------+--------------------+-----------+------------------+-----------------+-------------------+---------+-------------+--------+-------------+-------------+----------------+-------------+--------------+---------------------+------------+-------------+----------------+---------------------+-----------------------+-------------------------+-----------------+---------------+
     
  8. NueX

    NueX Member

    That's the solution! With the query on "email", my main mailbox [email protected] is working again in- and externally.
     
  9. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Ok, that looks like a bug, thanks for reporting it, and please holler if you run into any other issues. We value you brave beta testers willing to work through a few of these issues. :)
     
  10. NueX

    NueX Member

    Jesse, thank you very much for your amazing support! Hope this helped fixing one little bug.
     
  11. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

  12. NueX

    NueX Member

    So this will be in tomorrows nightly?
     
  13. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

  14. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Last edited: Sep 24, 2020
  15. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    I doubt it as it has just been midnight in our timezone ;) I don't know at what time the nightly is generated, but I suspect it will be in 3.2dev20200925 or 3.2dev20200926.

    As soon as it's merged you can upgrade to git-develop aswell, instead of the nightly.
     
    ahrasis likes this.

Share This Page