| 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....
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, 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) :-) | | | 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 ? 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 ? ------------------------------------------------------------------------------ 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
