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

Discussion in 'ISPConfig 3 Priority Support' started by vestport, Sep 12, 2016.

  1. vestport

    vestport Member HowtoForge Supporter

    (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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The change of the squirrelmail permissions is not the cause for the mail user login problem if other users are still abel to login. Check the mail.log file for the error message and try to set a new password for the mail user.
     
  3. vestport

    vestport Member HowtoForge Supporter

    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.
    
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Login to ispconfig, go to System > Server config, select the server and there go to the mail tab. There you can find the user and group of the mail system, both fields mist contain "vmail".
     
  5. vestport

    vestport Member HowtoForge Supporter

    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?
     
    Last edited: Sep 12, 2016
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    That's what I guessed already that you can not create any new mailboxes anymore and that's not related to the installation of squirrelmail, squirrelmail ist just an imap client, please see my post #4 and check what I wrote there.
     
  7. vestport

    vestport Member HowtoForge Supporter

     
  8. vestport

    vestport Member HowtoForge Supporter

    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!
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Please see screenshot for the correct values for all these fields.
     

    Attached Files:

  10. vestport

    vestport Member HowtoForge Supporter

    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
    
     
    Last edited: Sep 13, 2016
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post the output of:

    ls -la /var/lib/squirrelmail/data

    and

    ls -la /var/spool/squirrelmail/attach

    and the apache squirrelmail.conf file.
     
  12. vestport

    vestport Member HowtoForge Supporter


    Okay, here it is:

    Code:
    [email protected]:~# 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]
    [email protected]:~# 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 ..
    [email protected]:~#
    
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    run:

    chown www-data:www-data /var/spool/squirrelmail/attach

    and try again in squirrelmail.
     
  14. vestport

    vestport Member HowtoForge Supporter


    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.
     
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post the the apache squirrelmail.conf file.
     
  16. vestport

    vestport Member HowtoForge Supporter

    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>
    
    
     
  17. till

    till Super Moderator Staff Member ISPConfig Developer

    Cahnge the line:

    php_admin_value open_basedir /usr/share/squirrelmail:/etc/squirrelmail:/var/lib/squirrelmail:/etc/hostname:/etc/mailname

    to

    php_admin_value open_basedir /usr/share/squirrelmail:/etc/squirrelmail:/var/lib/squirrelmail:/etc/hostname:/etc/mailname:/var/spool/squirrelmail/attach

    and restart apache. If this wont help, try to comment out this line by adding a # in front and restart apache.
     
  18. vestport

    vestport Member HowtoForge Supporter

    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?
     
    Last edited: Sep 15, 2016
  19. till

    till Super Moderator Staff Member ISPConfig Developer

    I'll check the perfect server to see if something is missing there in the squirrel mail apache conf.
     
  20. vestport

    vestport Member HowtoForge Supporter

    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
     

Share This Page