On Sun, 1 Aug 2010 23:51:17 +0200 (CEST) "Imposit.com - webmaster" <webmas...@imposit.com> wrote:
> > | Okay. Then let me ask you a bunch of questions: > | - do you run a virtual user setup? > | - if you don't run a virtual user setup, then what kind of setup do > | you have? > | - what version of mysql? > > No Virtual user, the only entry there is dspam. All Mailaccounts are regular > (ok they are ldap but get an real id on the system (yea i know i know its all > about to change) > so no virtual users.... > No virtual users but you have added a constrain to the virtual table? Why? > at this point i think i get it... was doing all this at 4am .. i dont think > the constrains will work without virtual users.. > so ok then a tiny update in the manual dont use it with relay AND systemusers > ... > > > Dspam is on the 5.1.47 Box, > What is a "5.1.47" box? > but i can change it if nessesary > > > > | Might I ask why you insist in adding those constrains? > > Noone is insisting. Its there so i try to use it. I got an error so i report > back as the usual good dog iam :-) > I do not really need them but why not .. gives a bit comfort at removing users > but first line im jsut testing - and hey wherse a better realwolrd test than > in a production syste, at 5am sunday morning... > > > > | Can you run the following commands and post the result: > | select count(uid) from dspam_virtual_uids; > | select count(distinct uid) from dspam_virtual_uids; > > | Actually I don't need the number. All I would like to know is if the > | two numbers match or not? > Result 2 billion :-) no really no virtual users so its 1 - dspam vuser (what > is he doing here anyway hmm) :-) > The constrains are pointless for your setup. What are you trying to accomplish with those constrains? They are only made so that deleting a DSPAM user would automatically remove the stats, tokens and other DSPAM relevant data. But since you only have one user then having those constrains is no need for you. > > | > | > | Have you ever run the purge script? If not, could you try to run it? > | It has actually nothing to do with your problem but if you never have > | run the purge script then the purging of old data will shrink the data > | in MySQL and this is beneficial for you. > > purge is running all night of course. > > btw how big is your mysql table ? > Big in what sense? Size or amount of rows? You will probably be surprised how small my data is. I mean: it is relative small compared to the amount of total users/domains on that system. I accomplish this by using a merged group that I constantly train. This helps me to keep the individual user data very, very, very small. I don't just train like normal admins do. I use my own training script. > ah yes one more thing. i think i switch it to osb > but since ife to retrain might it be a good idea to take all quaratines and > train them globaly ? > I don't understand that. Could you rephraze that question? -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
