Hi Baruwa Experts, We are running the the python script that is
/usr/lib/python2.4/site-packages/baruwa/messages/management/commands/* dbclean.py* while running below script we are getting error mentioned in trail mail. root# python dbclean.py Regards, Pinemail On Thu, Oct 4, 2012 at 3:30 PM, <[email protected]> wrote: > Send Baruwa mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.baruwa.org/mailman/listinfo/baruwa > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Baruwa digest..." > > > Today's Topics: > > 1. Cleaning mysql messages table (Mail Admin) > 2. Re: Cleaning mysql messages table (Andrew Colin Kissa) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 3 Oct 2012 19:46:53 +0530 > From: Mail Admin <[email protected]> > To: [email protected] > Subject: [Baruwa] Cleaning mysql messages table > Message-ID: > <CACGqap+zQKCrNZXAQ17YmSNWsDwtVvm503tZ9UsK12Q18bY= > [email protected]> > Content-Type: text/plain; charset="windows-1252" > > Baruwa Experts, > > > > I need your help in reducing mysql database size in ?messages? table. I > found one script ( dbclean.py) which is supposed to do the job but somehow > it is throwing following errors > > > > File "dbclean.py", line 22, in ? > > from django.db import connection > > File "/usr/lib/python2.4/site-packages/django/db/__init__.py", line 14, > in ? > > if not settings.DATABASES: > > File "/usr/lib/python2.4/site-packages/django/utils/functional.py", line > 276, in __getattr__ > > self._setup() > > File "/usr/lib/python2.4/site-packages/django/conf/__init__.py", line 40, > in _setup > > raise ImportError("Settings cannot be imported, because environment > variable %s is undefined." % ENVIRONMENT_VARIABLE) > > ImportError: Settings cannot be imported, because environment variable > DJANGO_SETTINGS_MODULE is undefined. > > > > > > *& script look like this from > /usr/lib/python2.4/site-packages/baruwa/messages/management/commands* > > > > from django.conf import settings > > from django.db import connection > > from django.core.management.base import NoArgsCommand > > from django.utils.translation import ugettext as _ > > > > class Command(NoArgsCommand): > > "Archive messages and delete from messages table" > > help = _("Deletes records older than QUARANTINE_DAYS_TO_KEEP" > > " days from the messages table") > > > > def handle_noargs(self, **options): > > #import datetime > > #from baruwa.messages.models import Message > > #interval = datetime.timedelta(days=60) > > #last_date = datetime.datetime.now() - interval > > #Message.objects.filter(timestamp__lt=last_date).delete() > > days = getattr(settings, 'QUARANTINE_DAYS_TO_KEEP', 10) > > > > conn = connection.cursor() > > conn.execute( > > """DELETE FROM messages WHERE id in > > (SELECT id FROM archive WHERE timestamp < > > DATE_SUB(CURDATE(), INTERVAL %s DAY)) > > """ % str(days) > > ) > > conn.execute( > > """INSERT LOW_PRIORITY INTO archive > > SELECT * FROM messages WHERE timestamp < > > DATE_SUB(CURDATE(), INTERVAL %s DAY) > > """ % str(days) > > ) > > conn.execute( > > """DELETE LOW_PRIORITY FROM messages > > WHERE timestamp < DATE_SUB(CURDATE(), > > INTERVAL %s DAY) > > """ % str(days) > > ) > > conn.execute('OPTIMIZE TABLE messages') > > conn.execute('OPTIMIZE TABLE archive') > > > > > > I changed only from ?60? to ?10? so that old entries can be removed from > database > > > > > Baruwa Version - 1.1.1 > Mailscanner Version - 4.84.3 > CentOS - 5.7 32 bit > > > Thanks in advance, > Pinemail. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.baruwa.org/pipermail/baruwa/attachments/20121003/3e783d21/attachment-0001.html > > > > ------------------------------ > > Message: 2 > Date: Wed, 3 Oct 2012 18:36:00 +0200 > From: Andrew Colin Kissa <[email protected]> > To: Baruwa users list <[email protected]> > Subject: Re: [Baruwa] Cleaning mysql messages table > Message-ID: <[email protected]> > Content-Type: text/plain; charset=windows-1252 > > > On 03 Oct 2012, at 4:16 PM, Mail Admin wrote: > > > I changed only from ?60? to ?10? so that old entries can be removed from > database > > > > > > > > Baruwa Version - 1.1.1 > > Mailscanner Version - 4.84.3 > > CentOS - 5.7 32 bit > > > > How are you running the command ? > > -- > www.baruwa.org > > > > > > > ------------------------------ > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > End of Baruwa Digest, Vol 27, Issue 1 > ************************************* >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
