From: Dani Crisan (danicrisan82yahoo.com)
Date: Fri Jul 18 2008 - 03:30:19 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Yes, I know it has nothing to do with postfix when authenticating via IMAP Authentication is not enabled for SMTP. However
However I thought I can find some answers here since I will have to access account via Courier in order to send emails via Postfix.

Thank you.

Dani Crisan wrote:
> Hello,
>
> I've just installed Postfix, Courier with Mysql authentication on Ubuntu server using this howto:http://flurdy.com/docs/postfix/#data
>
> However I cannot login into any accounts except for rootlocalhost.

what do you mean by login? if it is to read mail, then this has nothing
to do with postfix (when you read mail, postfix is not involved).

if it is to send mail, then show 'postconf -n' and postfix logs.

>
> Jul 18 11:07:36 mail authdaemond: received auth request, service=imap, authtype=login
> Jul 18 11:07:36 mail authdaemond: authmysql: trying this module
> Jul 18 11:07:36 mail authdaemond: SQL query: SELECT id, crypt, "", uid, gid, home, concat(home,'/',maildir), "", name, "" FROM users WHERE id = "gigifqdn.ro" AND (enabled=1)
> Jul 18 11:07:36 mail authdaemond: password matches successfully
> Jul 18 11:07:36 mail authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=gigifqdn.ro, fullname=gigi, maildir=/var/spool/mail/virtual/gigi/, quota=<null>, options=<null>
> Jul 18 11:07:36 mail authdaemond: authmysql: clearpasswd=<null>, passwd=6IOUkl4Ng1.DI
> Jul 18 11:07:36 mail authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=gigifqdn.ro, fullname=gigi, maildir=/var/spool/mail/virtual/gigi/, quota=<null>, options=<null>
> Jul 18 11:07:36 mail authdaemond: Authenticated: clearpasswd=XXX, passwd=6IOUkl4Ng1.DI
>

(This is a public mailing list, do not send passwords, even encrypted.
change the password)

>
> Any ideea why? It seems that it tries to authenticate via Mysql.

and it seems to succeed. what is the problem?

> Here is how I added this user:
>
> INSERT INTO users (id,name,maildir,crypt) VALUES ('gigifqdn.ro','gigi','gigi/', encrypt('XXX') );
>
> select * from users;
> gigifqdn.ro | gigi | 5000 | 5000 | /var/spool/mail/virtual | gigi/ | 1 | 1 | ChangeMe | 6IOUkl4Ng1.DI
>
> Thank you in advance..
>
>
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]