There is a mysql table creation script that takes auto-increment for uid. If your debug logs show that only the username and not the domain are taken into account, that is because you are calling dspam with the option"--user brian" and not "--user [EMAIL PROTECTED]". Take a look at the way you are calling dspam.
-- Sydney. > -----Message d'origine----- > De : [EMAIL PROTECTED] [mailto:owner-dspam- > [EMAIL PROTECTED] De la part de Brian austin > Envoyé : jeudi 6 décembre 2007 13:15 > À : [email protected] > Objet : Re: [dspam-users] endless frustration :-) > > so near.. so far... > > my virtual table looks like this... I have multiple domains, so want the > domain after the username, yes? > > CREATE TABLE `dspam_virtual_uids` ( > `uid` smallint(6) NOT NULL, > `username` varchar(128) NOT NULL, > UNIQUE KEY `id_virtual_uids_01` (`username`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > INSERT INTO `dspam_virtual_uids` VALUES (12345,'[EMAIL PROTECTED]'); > > that gave me errors - dspam was trying to insert a record with null uid > !!! > > > I added just (1234,'brian') and it works ok for that uid, > # dspam_stats > brian > TP: 0 TN: 1 FP: 0 FN: 0 SC: 0 NC: 0 > [EMAIL PROTECTED] > TP: 0 TN: 0 FP: 0 FN: 0 SC: 0 NC: 0 > > > how do I deal with multiple domains in the dspam_virtual_uids table? > > thanks > > Brian >
