March 16, 2003
why, why, why

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.

Posted March 16, 2003 12:08 PM in Geek Stuff
TrackBack URL for this entry: http://www.unix-girl.com/mt/mt-tb.cgi/635
Comments
On March 16, 2003 01:54 PM Jan Chrillesen added:

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)

#
On March 16, 2003 02:00 PM Jan Chrillesen added:

Also check the logfile to make sure that Postfix is actually using the virtual delivery agent to deliver the mail

#
On March 16, 2003 11:03 PM kasia added:

Thanks to Jan I figured it out!

#
On March 17, 2003 09:34 AM Tzicha added:

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?

#
On March 17, 2003 10:13 AM kasia added:

Cygnus is the name of the server :)

#
On March 17, 2003 04:15 PM Harald added:

So what was the problem? <grin>

#
On March 18, 2003 08:37 AM Tzicha added:

Silly me, I knew that :) Now I think I'll just go stand in the corner...

#
Trackbacks