Re: [Dspam-user] dspam relay with postfix

[Tom H. <to...@wh...>]

On 02-09-13 08:16, Hugh Badini wrote:
> Hello,
> 
<snip>
> 
> 21184: [09/02/2013 14:11:41] adding user to merged group groupuser
> 
<snip>
> 
> 21184: [09/02/2013 14:11:41] _mysql_drv_setpwnam: unable to run query:
> INSERT INTO dspam_virtual_uids (uid,username) VALUES (NULL,'groupuser')
> 
> 21184: [09/02/2013 14:11:41] _mysql_drv_get_spamtotals: unable to
> _mysql_drv_getpwnam(groupuser)
> 

<snip>

> 
> sql.errors:
> 
>  
> 
> [09/02/2013 14:11:41] 21184: Column 'uid' cannot be null: INSERT INTO
> dspam_virtual_uids (uid,username) VALUES (NULL,'groupuser')
> 
> [09/02/2013 14:11:41] 21184: Column 'uid' cannot be null: INSERT INTO
> dspam_virtual_uids (uid,username) VALUES (NULL,'groupuser')
> 

You created a group config using a user named 'groupuser', but this
username does not exist in the dspam_virtual_uids table. You need to
create it yourself (or make the uid column an autoincrement).

Tom