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?
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!
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
Hi. I tried to create a new account to my server and I noticed same error: Invalid settings in userdb... And in mail section of server config some field are empty. I've got access to dbispconfig through phpmyadmin but I don't know where [mail] section is. I've a 3.1.15 version of ISP (yes, I know it's an old version but it's in production and I don't like to make any changes but now I've found this problem and I'm forced). In other hand I don't know if editing the database and introducing this data solves the problem or however crashes the server. Please, help!
The section is located in the database table "server" the field is called "config". Check the data if there is something missing and consider posting it here before you make any changes.
OMG! I've checked that and there's no [mail] section into config filed. I've seen that this section must be below [server] (I see that at other server that is working ok) but it's missed. I don't know what would happen if I copy the code from the good server and paste it at the wrong server. Thanks.
Do you have any backups which include the dbispconfig database? There might be older backups in /var/backup/ Btw. Not updating a production system does not make it run more reliably, it causes the opposite, as bugs and security issues on your system are not fixed.
This is a virtual machine. I've some backups of all entire machine. And I make daily backups. Then, It's possible copy and paste that section? Or It's recommended update the ispconfig version before? Considering the working server has 3.2.8 version. Thanks
so you have multiple servers.. all standalone or multi-server? if multi-server, they should ALL be running the same version... differences in dbispconfig table settings / fields between different servers can lead to all sorts of problems. if you can find a backup of that servers dbispconfig database with the full config field, just cut and paste that back into the live db (accounting for any other changes that may have happened since the backup)
Hi! Yes, I've multiple servers but all standalone. Different virtual machines. I don't know when this problem starts to happen (this is a server I don't usually use) then I can't restore a backup without affecting mail clients.
copy the whole config field from a working vps and paste it into a text editor. compare that to what you have for the field in the broken vps. paste in any missing bits, adjusting as required, eg amavis/rspamd, dkim strength etc...
