Is postfix insisting to use nobody/nobody instead the virtual uid/gid when creating mail.. sigh.. I've checked every setting 1000 times by now and all seems correct including the entry in the db. Time to go outside before I tear all my hair out.
-rw------- 1 nobody nobody 476 Mar 16 08:35 1047832514.V303I27c00b.cygnus -rw------- 1 nobody nobody 480 Mar 16 08:47 1047833231.V303I27c00c.cygnus
mysql> select * from users where address='test'; +--------------------+---------+---------------+---------+------+------+------------------+--------+-------------------+ | id | address | crypt | name | uid | gid | home | domain | maildir | +--------------------+---------+---------------+---------+------+------+------------------+--------+-------------------+ | test@unix-girl.com | test | nbzzN9gUKKwYw | testing | 3001 | 3000 | /data/vmbox/test | | /data/vmbox/test/ | +--------------------+---------+---------------+---------+------+------+------------------+--------+-------------------+ 1 row in set (0.00 sec)
main.cf: virtual_uid_maps = mysql:/etc/postfix/vuids.cf virtual_gid_maps = mysql:/etc/postfix/vgids.cf
vuids.cf: user = postfix password = whatever dbname = maildb table = users select_field = uid where_field = address
vgids.cf: user = postfix password = whatever dbname = maildb table = users select_field = gid where_field = address
Maybe it will come to me later.
TrackBack URL for this entry: http://www.unix-girl.com/mt/mt-tb.cgi/635
Try hardcoding the gid/uids to see if the virtual delivery daemon is actually able to write with a different UID.
virtual_uid_maps = static:3001
virtual_gid_maps = static:3000
If that works enable debugging and watch the actual SQL query being sent to MySQL (I'm pretty sure that's possible with a sufficient high debuglevel)
#Also check the logfile to make sure that Postfix is actually using the virtual delivery agent to deliver the mail
#Thanks to Jan I figured it out!
#Cygnus? Several times have I tried getting cygnus running on my Debian box, to no avail. Is the best way to get it running, building from source?
#Cygnus is the name of the server :)
#So what was the problem? <grin>
#Silly me, I knew that :) Now I think I'll just go stand in the corner...
#