I believe that fixed it,Thanks. I had [EMAIL PROTECTED] and [EMAIL PROTECTED]
but not just globaluser in dspam_virtual_uids.
---- Sean Wilkerson <[EMAIL PROTECTED]> wrote:
>
> Tejas,
> This is consistent with an error you see when the user doesn't exist in
> mysql. I know you said the user exists on your system, but not knowing
> your setup, I don't know if that means the user also exists in mysql.
>
> - Connect to mysql and run this query
> select * from dspam_virtual_uids where username='globaluser';
> - Does it return a value? You should see something like this
> mysql> select * from dspam_virtual_uids where username='globaluser';
> +------------+-----+
> | username | uid |
> +------------+-----+
> | globaluser | 12 |
> +------------+-----+
> 1 row in set (0.02 sec)
>
> - Whether that returns or not, the next thing I would try is to watch
> your mysql.log to check for errors with mysql.
> - Add a line similar to this to your my.cnf if it isn't there already
> log = /var/log/mysql/mysql.log
> - Next, tail that log file mentioned above and watch for the query to
> globaluser
> - Now, retry your test with the globaluser, and see what mysql returns.
> - In the query I just made above with the select, this is what dspam is
> querying mysql for
> - Finally you can check your sql.errors file to see what mysql complains
> about. On my system I can find this here /var/log/dspam/sql.errors
>
> hth,
> Sean
>
> Tejas Jin wrote:
> > When I set up globalusers in my group configuration file I start getting
> > this error message whenever one of my users gets mail?
> >
> > 28922: [06/05/2007 13:36:28] checking result for user globaluser
> > 28922: [06/05/2007 13:36:28] _mysql_drv_get_spamtotals: unable to
> > _mysql_drv_getpwnam(globaluser)
> > 28922: [06/05/2007 13:36:28] unable to load totals. using zero
> > values.
> > 28922: [06/05/2007 13:36:28] _ds_getall_spamrecords: unable to
> > _mysql_drv_getpwnam(globaluser)
> > 28922: [06/05/2007 13:36:28] _ds_getall_spamrecords() failed
> > 28922: [06/05/2007 13:36:28] bailing on error -2
> >
> > I have a globaluser on the system. I am not sure what it is trying to do
> > because whenever I don't have globalusers setup, it get to about this point
> > and says
> > checking result for user testuser
> > and goes on. I didn't do any special configuration for a user in mysql.
> >
>
>
