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.
