Invalid settings in userdb: userdb returned 0 as uid

Discussion in 'General' started by spazio, Sep 6, 2017.

  1. spazio

    spazio Member

    The setup is ISPConfig 3.1.6
    lsb_release -a
    No LSB modules are available.
    Distributor ID: Debian
    Description: Debian GNU/Linux 8.9 (jessie)
    Release: 8.9
    Codename: jessie

    The server is in production mode for over one year and working great! some time ago I edited a mailbox and this problem happend. I corrected it and told myself bd problem. But it happend again this mornig and I did some test and it' salways there!

    After editing any mailbox in the system. The following parameter are empty in `mail_user`table
    uid = 0
    gid = 0
    maildir = empty filed ( nothing but not NULL)
    homedir = empty filed ( nothing but not NULL)

    And if the user tries to send and received from outlook it doesn't work!
    In the log here is the error message: Invalid settings in userdb: userdb returned 0 as uid

    Any idea?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely wrong or corrupted settings under System > server config > mail.
     
  3. spazio

    spazio Member

    That is it!
    There is problems with what is in the filds in the mail tab!

    I changed the values but I can't save the new values.
    I get this error:
    1- Uid-mapping cannot be changed if there are already mail users.

    I gess I need to change the values in the ispdb!
    The table for those values is dbispconfig.serveer.config
    And Voila! it fix the problem

    Thanks Till!
     
    Last edited: Sep 6, 2017
  4. corpus

    corpus Member

    Hello
    Thanks for the help. I had the same problem and fixed it with your help.
    For all those who don't have the values in the dbispconfig.serveer.config
    i paste mine

    [mail]
    module=postfix_mysql
    maildir_path=/var/vmail/[domain]/[localpart]
    homedir_path=/var/vmail
    maildir_format=maildir
    dkim_path=/var/lib/amavis/dkim
    dkim_strength=1024
    pop3_imap_daemon=dovecot
    mail_filter_syntax=sieve
    mailuser_uid=5000
    mailuser_gid=5000
    mailuser_name=vmail
    mailuser_group=vmail
    mailbox_virtual_uidgid_maps=n
    relayhost=
    relayhost_user=
    relayhost_password=
    mailbox_size_limit=0
    message_size_limit=0
    mailbox_quota_stats=y
    realtime_blackhole_list=zen.spamhaus.org
    overquota_notify_admin=y
    overquota_notify_client=y
    overquota_notify_freq=7
    overquota_notify_onok=n
    sendmail_path=/usr/sbin/sendmail
    reject_sender_login_mismatch=n
     

Share This Page