Email problems postfix+roundcube+sasl

[LMSSML]

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

[scathefire]

Postfix Admin | Get Postfix Admin at SourceForge.net

[LMSSML]

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.

[LMSSML]

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 ?

[scathefire]

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.

[LMSSML]

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.

[scathefire]

if you try not using an SSL connection does the outlook connection work?

[LMSSML]

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

[LMSSML]

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 ?

[scathefire]

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.

$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.