Tried to solve Squirrelmail - Could not copy/move file. File not attached - Now no login

(Debian Jessie) ISPConfig 3.0.5.4p9

I tried to run the following commands to fix the initial issue via the following thread:

Code:

https://www.howtoforge.com/community/threads/squirrelmail-could-not-move-copy-file-file-not-attached-when-trying-to-attach-a-fi.55043/

Now the user can't login. I get the following error:

Code:

ERROR: ERROR: Connection dropped by IMAP server.

All other email users can login fine. Very strange. Something just got corrupted for this one user. So I really have 2 problems. Firstly I just need to get this user back online asap to just get mail and then I need to figure out why the heck I can't attach files. In my php.ini I have:

Code:

file_uploads = On
upload_max_filesize = 200M

My squirrelmail folder defaults are:

Code:

SquirrelMail Configuration : Read: config.php (1.4.0)
---------------------------------------------------------
Folder Defaults
1.  Default Folder Prefix  :
2.  Show Folder Prefix Option  : false
3.  Trash Folder  : Trash
4.  Sent Folder  : Sent
5.  Drafts Folder  : Drafts
6.  By default, move to trash  : true
7.  By default, save sent messages : true
8.  By default, save as draft  : true
9.  List Special Folders First  : true
10. Show Special Folders Color  : true
11. Auto Expunge  : true
12. Default Sub. of INBOX  : false
13. Show 'Contain Sub.' Option  : false
14. Default Unseen Notify  : 2
15. Default Unseen Type  : 1
16. Auto Create Special Folders  : true
17. Folder Delete Bypasses Trash  : false
18. Enable /NoSelect folder fix  : false

and General defaults are:

Code:

SquirrelMail Configuration : Read: config.php (1.4.0)
---------------------------------------------------------
General Options
1.  Data Directory  : /var/lib/squirrelmail/data/
2.  Attachment Directory  : /var/spool/squirrelmail/attach/
3.  Directory Hash Level  : 0
4.  Default Left Size  : 150
5.  Usernames in Lowercase  : true
6.  Allow use of priority  : true
7.  Hide SM attributions  : false
8.  Allow use of receipts  : true
9.  Allow editing of identity  : true
  Allow editing of name  : true
  Remove username from header  : false
10. Allow server thread sort  : false
11. Allow server-side sorting  : false
12. Allow server charset search  : true
13. Enable UID support  : true
14. PHP session name  : SQMSESSID
15. Location base  :
16. Only secure cookies if poss. : true
17. Disable secure forms  : false
18. Page referal requirement  :
19. Browser rendering mode  : quirks

when I run

Code:

http://www.mydomain.com/squirrelmail/src/configtest.php

I get a 403 error.

I'm getting the following error in /var/log/mail.err

Code:

 Invalid settings in userdb: userdb returned 0 as uid
Refer to server log for more information.

Not sure what to do. I just went through war with my old ISPCONFIG on Centos with mail issues and setup this new DEBIAN system thinking I was out of the woods but looks like I have a ways to go to get back to square one where I use to be.

Thanks in advance for your reply!

Art

 

I tried copying users mail in Maildir to user-bak, then deleting the user and re-creating. Also, tried changing just the password and same result - no luck.

Here is what I get in mail.log. It appears to be a database error or something stuck in the database for that user. Not sure where to find this in phpmyadmin or elsewhere. I replaced actual [email protected] with "[email protected]".

Code:

Sep 12 08:13:59 ns1 dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=20396, secured, session=<MiFKbk48LAAAAAAAAAAAAAAAAAAAAAAB>
Sep 12 08:13:59 ns1 dovecot: imap: Error: user [email protected]: Invalid settings in userdb: userdb returned 0 as uid
Sep 12 08:13:59 ns1 dovecot: imap: Error: Invalid user settings. Refer to server log for more information.
Sep 12 08:14:14 ns1 dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=20408, secured, session=<LGwxb048LQAAAAAAAAAAAAAAAAAAAAAB>
Sep 12 08:14:14 ns1 dovecot: imap: Error: user [email protected]: Invalid settings in userdb: userdb returned 0 as uid
Sep 12 08:14:14 ns1 dovecot: imap: Error: Invalid user settings. Refer to server log for more information.

 

I was curious and confirmed that also no new users can't be created without the same error (cannot login to squirrelmail) but that all other existing users still appear to work fine (without being able to attach files that is). Very strange. I think something definitely got screwed up in the squirrelmail configuration. Is there anyway I can just reinstall squirrelmail without screwing up ispconfig?

 

Sorry, I missed that before. Okay, I changed both fields to "vmail" and am now getting the following errors:

Code:

ERROR
Maildir Path is empty.
Invalid maildir path.
Homedir Path is empty.
Invalid homedir path.
Mailuser UID is empty.
Mailuser uid must be >= 2000
Mailuser GID is empty.
Mailuser gid must be >= 2000

I changed the maildir path to "/var/vmail" and UID to "2000" but am unsure what I should set home path to. I am now getting the following errors:

Code:

Homedir Path is empty.
Invalid homedir path.

I know I'm close but unfortunately not yet.

Let me know if I was okay with the maildir path I used (/var/vmail/) and UID/GID set to "2000".

I still need the correct homedir path and not sure what to use. /var/vmail/$HOME? I just don't want to screw working mail up.

I am certain that once I get the right path I will be back up and running but will still need to solve the issue of not being able to attach files.

Thanks again!

 

Yes, setup as described above and with user and group id of 5000. Back online with email. Thanks so much! Not sure how that setting got screwed up and missing all the variables in the first place. Must have been when I ran the config file.

I am still getting error messages when trying to send attachments:

Code:

Could not move/copy file. File not attached

 

Okay, here it is:

Code:

root@ns1:~# ls -la /var/lib/squirrelmail/data
total 32
drwx-wx--- 2 root  www-data 4096 Sep 12 22:41 .
drwxr-xr-x 4 root  root  4096 Sep  3 15:27 ..
-rw------- 1 www-data www-data  0 Sep  8 21:10 [email protected]
-rw------- 1 www-data www-data  120 Sep 12 22:41 [email protected]
-rw------- 1 www-data www-data  108 Sep 12 22:32 [email protected]
-rw------- 1 www-data www-data  36 Sep 11 23:07 .pref
-rw------- 1 www-data www-data  176 Sep 11 15:50 [email protected]
-rw------- 1 www-data www-data  120 Sep 12 18:05 [email protected]
-rw------- 1 www-data www-data  108 Sep 11 22:36 [email protected]
root@ns1:~# ls -la /var/spool/squirrelmail/attach
total 8
drwx-wx-wx 2 root root 4096 Sep 11 22:59 .
drwxr-xr-x 3 root root 4096 Sep 11 22:59 ..
root@ns1:~#

 

I tried changing user/group as described and get the same error

Code:

Could not move/copy file. File not attached

I verified that the user/group did change to "www-data" and also my ADD: is (max. 128 M) so plenty of room there. The /var/spool/squirrelmail directory itself is owned by root:root. Not sure if that is a problem? /var/spool/squirrelmail/attach is owned by www-data:www-data. Still no work.

 

Code:

Alias /squirrelmail /usr/share/squirrelmail
Alias /webmail /usr/share/squirrelmail
<Directory /usr/share/squirrelmail>
  Options FollowSymLinks
  <IfModule mod_php5.c>
AddType application/x-httpd-php .php
  php_flag magic_quotes_gpc Off
  php_flag track_vars On
  php_admin_flag allow_url_fopen Off
  php_value include_path .
  php_admin_value upload_tmp_dir /var/lib/squirrelmail/tmp
  php_admin_value open_basedir /usr/share/squirrelmail:/etc/squirrelmail:/var/lib/squirrelmail:/etc/hostname:/etc/mailname
  php_flag register_globals off
  </IfModule>
  <IfModule mod_dir.c>
  DirectoryIndex index.php
  </IfModule>

  # access to configtest is limited by default to prevent information leak
  <Files configtest.php>
  order deny,allow
  deny from all
  allow from 127.0.0.1
  </Files>
</Directory>

# users will prefer a simple URL like http://webmail.example.com
#<VirtualHost 1.2.3.4>
#  DocumentRoot /usr/share/squirrelmail
#  ServerName webmail.example.com
#</VirtualHost>

<VirtualHost *:80>
  DocumentRoot /usr/share/squirrelmail
  ServerName webmail.mydomain.com

</VirtualHost>

# redirect to https when available (thanks [email protected])
#
#  Note: There are multiple ways to do this, and which one is suitable for
#  your site's configuration depends. Consult the apache documentation if
#  you're unsure, as this example might not work everywhere.
#
#<IfModule mod_rewrite.c>
#  <IfModule mod_ssl.c>
#  <Location /squirrelmail>
#  RewriteEngine on
#  RewriteCond %{HTTPS} !^on$ [NC]
#  RewriteRule . https://%{HTTP_HOST}%{REQUEST_URI}  [L]
#  </Location>
#  </IfModule>
#</IfModule>

 

Changing to the new line you suggested worked. Oh man, thanks so much for your support on this! This was a real battle to correct. How did this get all screwed up from the perfect install? Did I miss something?

 

I'm thinking that some things may have got overwritten when I ran the squirrelmail configuration script from the command line however attachments were never working and that's why I ran it in the first place.

Thanks again for getting me going!


Art