Re: [Pmwh-users] problems with bad uid.

[<in...@cs...>]

mutombo wrote:
> 
> cat mysql-virtual-uid.cf
> user = provider
> password = *******
> dbname = provider
> table = users
> select_field = maildir
> where_field = email
> additional_conditions = and postfix = 'y'
> hosts = *myip*
> 
> it seems for me that the uid is right.

You are right, but

   select_field = maildir

is wrong.

> perhaps you can tell me whats wrong here.

The files
   mysql-virtual-maps.cf
   mysql-virtual-uid.cf
   mysql-virtual-gid.cf
are wrong. I filled it with the wrong values.

Correct them or get 
http://phpmywebhosting.sourceforge.net/docs/postfix-mysql.tar.gz
and run ./fill.pl and cp the mysql-* files to your postfix installation.

After that, restart postfix and it should work.

Your error message:

 > Dec 12 01:58:23 217-20-116-86 imaplogin: Connection,
 > ip=[::ffff:217.238.88.91]
 > Dec 12 01:58:23 217-20-116-86 imaplogin: LOGIN, user=te...@mo...,
 > ip=[::ffff:217.238.88.91]
 > Dec 12 01:58:23 217-20-116-86 imaplogin: Failed to create cache file:
 > ./tmp/1071190703.12184_imapuid_0.217-20-116-86.internetserviceteam.com
 > Dec 12 01:58:23 217-20-116-86 imaplogin: Error: No such file or
 > directory

Take a look at /home/vmail/Maildir/te...@mo.../
Are there three directories cur, new and tmp?

If not, send a mail to te...@mo... after changing postfix files.

Regards Udo