Find the answer to your Linux question:
Page 1 of 4 1 2 3 4 LastLast
Results 1 to 10 of 32
Hi people, I've followed the manual with http: flurdy.com/docs/postfix/#config-simple-firewall How to set up a mail server on a GNU / Linux system[/url] but then I could create mailbox with phpmyadmin ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36

    Smile Email problems postfix+roundcube+sasl


    Hi people,

    I've followed the manual with http: flurdy.com/docs/postfix/#config-simple-firewall How to set up a mail server on a GNU / Linux system[/url]

    but then I could create mailbox with phpmyadmin using mysql commands and in maildb database althouth every user I create on DB if I try with squirrel or even with roundcube none of them work.

    I can see it in /var/spool/mail/virtual/<username> is not created for new users.

    Is there any admin software (like webmin) to create user accounts and mailbox ?

    I think I missed a step creating user accounts but I couldn't find what is missing.

    Just to referre that I have a user created and this user works but hte new ones dosen't work and for the first user the folder for user was created automatically.

    Thanks in advanced for the help .
    LMSSML is offline Reply With Quote

  2. #2
    Linux Enthusiast scathefire's Avatar
    Join Date
    Jan 2010
    Location
    Western Kentucky
    Posts
    626
    linux user # 503963

  3. #3
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36

    Smile Error messages installing postfixadmin

    Hi there ,


    I found a tutorial
    http: postfixmail.com/blog/index.php/postfixadmin-on-ubuntu-9-10/
    that sent me create a ddatabase postfix and the create a user but there were the problem



    /postfixadmin/setup.php

    Postfix Admin Setup Checker

    Running software:

    * PHP version 5.2.10-2ubuntu6.4
    * Apache/2.2.12 (Ubuntu)

    Checking for dependencies:

    * Warning: Magic Quotes: ON (internal workaround used)
    * Depends on: presence config.inc.php - OK
    * Checking $CONF['configured'] - OK
    * Depends on: MySQL 3.23, 4.0 - OK
    * Depends on: MySQL 4.1 - OK
    * Error: Can't connect to database
    Please edit the $CONF['database_*'] parameters in config.inc.php.

    DEBUG INFORMATION:
    MySQLi Select Database: Access denied for user
    'postfixadm'@'localhost'
    to database 'postfix'
    * Depends on: session - OK
    * Depends on: pcre - OK
    * Depends on: multibyte string - OK
    * Depends on: IMAP functions - OK

    Please fix the errors listed above.


    Why postfixadm ? User ? The tutorial says to create postfix user .

    mysql> CREATE USER 'postfix'@'localhost' IDENTIFIED BY 'password changed to rela password';

    I've got the following error :

    ERROR 1396 (HY000): Operation CREATE USER failed for 'postfix'@'localhost'

    Any help ?

    Thanks in advanced.

  4. #4
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36

    Solved Problem and gained new one

    Hi there,

    I've solved last problem changing the postfix user with root user in config.inc.php of postfixadmin configuration file.

    So now i'm trying to integrate postfixadmin with squirrelmail.

    Because everytime I create a new mailbox the same isn't created for squirrelmail anyone ?

    I have a problem that always have mailbox with squirrelmail could not receive
    http: flurdy.com/docs/postfix/#config-extra-webmail
    but I can see emails using postqueue -p

    Any help ?

  5. #5
    Linux Enthusiast scathefire's Avatar
    Join Date
    Jan 2010
    Location
    Western Kentucky
    Posts
    626
    So you went through all the conf.pl stuff? Are there any errors in your apache log? Or perhaps mysql errors? What are your permissions on your data-dir and attachments dir? can you fetch the email using thunderbird or outlook?

    it is highly likely the reason you had problems using the postfix user in mysql is probably because you didn't

    a) create a user in the mysql environment named postfix
    or more likely
    b) assign appropriate login permissions and/or access to the database

    gimme more info, you are close to having this licked i know it.
    linux user # 503963

  6. #6
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36
    So you went through all the conf.pl stuff? Are there any errors in your apache log? Or perhaps mysql errors? What are your permissions on your data-dir and attachments dir? can you fetch the email using thunderbird or outlook?
    No errors on apache log

    /var/spool/mail/virtual
    drwxr-sr-x 9 virtual virtual 4.0K 2010-02-20 00:43 user1
    drwx--S--- 10 virtual virtual 4.0K 2010-02-18 12:50 user2

    /var/spool/squirrelmail
    drwx-wx--- 2 root www-data 4.0K 2009-12-12 14:02 attach


    Trying with outlook express

    The server responded with an error. Account: 'mail.example.pt', Server: 'mail.example.pt', Protocol: POP3, Server Response: '-ERR AVG POP3 Proxy Server: Cannot connect to the mail server!', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC90

    a) create a user in the mysql environment named postfix
    or more likely
    assign appropriate login permissions and/or access to the database

    Using phpmyadmin in mysql

    Edita Apagar localhost postfix N N N N N N

    Thanks in advanced.

  7. #7
    Linux Enthusiast scathefire's Avatar
    Join Date
    Jan 2010
    Location
    Western Kentucky
    Posts
    626
    if you try not using an SSL connection does the outlook connection work?
    linux user # 503963

  8. #8
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36
    Whithout ssl it present the following error.

    It appears a warning to wait for server or to stop after a shortime on clicking wait it goes to this error.

    The server responded with an error. Account: 'mail.example.pt', Server: 'mail.example.pt', Protocol: POP3, Server Response: '-ERR AVG POP3 Proxy Server: Cannot connect to the mail server!', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC90
    Any help?

    Thanks ins advanced

  9. #9
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36

    Smile Two pending subjects (Already see email on inbox)

    Hello

    Once again

    I think there were two steps that could be critical to my subject

    I can SEE MAILS ON SQUIRREL ON MY INBOX

    Althout I sent to an external account and it's working.


    But I have two subjects that are pending.

    First subject I create a new mailbox through postfixadmin and squirrelmail dosen't recognize this same mail box.

    Ok then I will use another methos explained with the following site:

    http: flurdy.com/docs/postfix/#config-extra-webmail
    INSERT INTO users (id,name,maildir,clear) VALUES ('email@address','short description','foldername/',encrypt('password'));


    INSERT INTO aliases (mail,destination) VALUES ('email@address','email@address');
    Surprise when trying to do authentication on squirrelmail it gives the error that username and password.

    ERROR
    Unknown user or password incorrect.
    Go to the login page
    in mail.log It gaves me this.

    Feb 23 23:28:57 mail imapd-ssl: Connection, ip=[::ffff:127.0.0.1]
    Feb 23 23:28:57 mail authdaemond: received auth request, service=imap, authtype=login
    Feb 23 23:28:57 mail authdaemond: authmysql: trying this module
    Feb 23 23:28:57 mail authdaemond: authmysqllib: connected. Versions: header 50075, client 50083, server 50137
    Feb 23 23:28:57 mail authdaemond: SQL query: SELECT id, crypt, "", uid, gid, home, maildir, quota, name, "" FROM users WHERE id = 'user3@example.pt' AND (enabled=1)
    Feb 23 23:28:57 mail authdaemond: supplied password 'password' does not match encrypted password 'sdtrusfX0Jj66'
    Feb 23 23:28:57 mail authdaemond: authmysql: REJECT - try next module
    Feb 23 23:28:57 mail authdaemond: FAIL, all modules rejected
    Feb 23 23:28:57 mail imapd-ssl: LOGIN FAILED, user=user3@example.pt, ip=[::ffff:127.0.0.1]
    Feb 23 23:29:02 mail imapd-ssl: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=66, sent=334

    The second subject goes to Outlook express:

    When using ssl ports it says that will generate a certificate but then it goes to authentication using user 1 and user 2 the same that works with sqquirrelmail it always ask for the authentication.


    Any help ?

    Thanks in advanced.



    Any help ?

  10. #10
    Linux Enthusiast scathefire's Avatar
    Join Date
    Jan 2010
    Location
    Western Kentucky
    Posts
    626
    Feb 23 23:28:57 mail authdaemond: SQL query: SELECT id, crypt, "", uid, gid, home, maildir, quota, name, "" FROM users WHERE id = 'user3@example.pt' AND (enabled=1)
    Feb 23 23:28:57 mail authdaemond: supplied password 'password' does not match encrypted password 'sdtrusfX0Jj66'

    Squirrelmail is sending your password in cleartext it looks like, and you are storing it in encrypted. I've dealt with this before, but they have moved the file that contains the PHP functions that defines how squirrelmail behaves as far as doing its SQL queries.

    The alternative would be to change the manner in which postfixadmin writes the passwords to the database.
    Code:
    $CONF['encrypt'] = 'md5';
    you could change that to cleartext, but I don't recommend it. So we need to find where squirrelmail is storing this function it looks like.
    Last edited by scathefire; 02-24-2010 at 02:29 PM.
    linux user # 503963

Page 1 of 4 1 2 3 4 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •