Yes, already added, the error happens anyway. 2012/2/28 Jeremy McSpadden <[email protected]>
> Add -U to your mailscanner # line. > > > -- > Jeremy McSpadden > > On Feb 28, 2012, at 4:11 PM, "Kleber Rocha" <[email protected]> wrote: > > Only these erros of perl. > > > In Debugging mode, not forking... > Trying to setlogsock(unix) > Building a message batch to scan... > Have a batch of 1 message. > Insecure dependency in open while running with -T switch at > /usr/lib64/perl5/IO/File.pm line 185. > Insecure dependency in open while running with -T switch at > /usr/lib64/perl5/IO/File.pm line 185. > Insecure dependency in open while running with -T switch at > /usr/lib64/perl5/IO/File.pm line 188. > Insecure dependency in open while running with -T switch at > /usr/lib64/perl5/IO/File.pm line 185. > Insecure dependency in open while running with -T switch at > /usr/lib64/perl5/IO/File.pm line 185. > Stopping now as you are debugging me. > > > 2012/2/28 Jeremy McSpadden <[email protected]> > >> Looks ok. Now check logs as to why. What does debug output? >> >> >> -- >> Jeremy McSpadden >> >> On Feb 28, 2012, at 4:05 PM, "Kleber Rocha" <[email protected]> wrote: >> >> [root@napmail01 tmp]# mysqlcheck -u root baruwa >> baruwa.archive OK >> baruwa.auth_group OK >> baruwa.auth_group_permissions OK >> baruwa.auth_hosts OK >> baruwa.auth_message OK >> baruwa.auth_permission OK >> baruwa.auth_user OK >> baruwa.auth_user_groups OK >> baruwa.auth_user_user_permissions OK >> baruwa.celery_taskmeta OK >> baruwa.celery_tasksetmeta OK >> baruwa.deliveryinfo OK >> baruwa.django_content_type OK >> baruwa.django_session OK >> baruwa.djcelery_crontabschedule OK >> baruwa.djcelery_intervalschedule OK >> baruwa.djcelery_periodictask OK >> baruwa.djcelery_periodictasks OK >> baruwa.djcelery_taskstate OK >> baruwa.djcelery_workerstate OK >> baruwa.domain_signatures OK >> baruwa.lists OK >> baruwa.mail_hosts OK >> baruwa.mailq OK >> baruwa.message_recipients OK >> baruwa.messages OK >> baruwa.profiles OK >> baruwa.quarantine_releases OK >> baruwa.report_filters OK >> baruwa.sa_rules OK >> baruwa.scanner_config OK >> baruwa.scanner_config_sections OK >> baruwa.scanners OK >> baruwa.signature_imgs OK >> baruwa.south_migrationhistory OK >> baruwa.user_addresses OK >> baruwa.user_signatures OK >> >> >> 2012/2/28 Jeremy McSpadden <[email protected]> >> >>> Looks like its not ok. Have you checked the db? >>> >>> >>> to server failed, using backup >>> >>> >>> -- >>> Jeremy McSpadden >>> >>> On Feb 28, 2012, at 4:01 PM, "Kleber Rocha" <[email protected]> wrote: >>> >>> Why this happens? >>> >>> Feb 28 07:14:17 napmail01 MailScanner[30376]: Baruwa: Sending message >>> 102DEAC33CA.A8F82 to server failed, using backup >>> Feb 28 07:14:17 napmail01 MailScanner[30376]: Baruwa: 102DEAC33CA.A8F82: >>> Logged using backup DB >>> >>> The MySQL server is ok and running. >>> >>> Thanks >>> >>> >>> >>> 2012/2/28 Mikael Syska <[email protected]> >>> >>>> http://baruwa.org/docs/batteries_included.html#database-maintenance >>>> >>>> mvh >>>> Mikael Syska >>>> >>>> On Tue, Feb 28, 2012 at 9:47 PM, Kleber Rocha <[email protected]> wrote: >>>> > I understanding the export, but how can I archive messages tables, to >>>> avoid >>>> > that table growing? >>>> > Rename table and create new table with the properties of old table? >>>> > >>>> > >>>> > Thanks >>>> > >>>> > 2012/2/28 Jeremy McSpadden <[email protected]> >>>> >> >>>> >> mysqldump –uUSER –pPASSWORD DBNAME > /tmp/backup.sql >>>> >> >>>> >> Login to mysql >>>> >> drop database DBNAME; >>>> >> create database DBNAME; >>>> >> Logout >>>> >> >>>> >> mysql –uUSER-pPASSWORD DBNAME < /tmp/backup.sql >>>> >> >>>> >> >>>> >> Problem you'll run out of memory real quick doing this import. 24gb >>>> db >>>> >> file .. good luck with that >>>> >> >>>> >> -- >>>> >> Jeremy McSpadden >>>> >> Flux Labs, Inc >>>> >> http://www.fluxlabs.net >>>> >> Endless Solutions >>>> >> Office : 850-588-4626 >>>> >> Cell : 850-890-2543 >>>> >> Fax : 850-254-2955 >>>> >> >>>> >> From: Kleber Rocha <[email protected]> >>>> >> Reply-To: Baruwa list <[email protected]> >>>> >> Date: Tue, 28 Feb 2012 17:37:44 -0300 >>>> >> To: Baruwa list <[email protected]> >>>> >> Subject: Re: [Baruwa] Duplicate Entry >>>> >> >>>> >> I don't understanding, I have to create dump? how can I export this >>>> table? >>>> >> >>>> >> Thanks >>>> >> >>>> >> 2012/2/28 Jeremy McSpadden <[email protected]> >>>> >>> >>>> >>> Export and start over :) >>>> >>> >>>> >>> >>>> >>> -- >>>> >>> Jeremy McSpadden >>>> >>> >>>> >>> On Feb 28, 2012, at 2:34 PM, "Kleber Rocha" <[email protected]> >>>> wrote: >>>> >>> >>>> >>> How can I archive this? >>>> >>> >>>> >>> Thanks >>>> >>> >>>> >>> 2012/2/28 Jeremy McSpadden <[email protected]> >>>> >>>> >>>> >>>> You can't. Unless you want to go ID by ID .. And manually delete >>>> them. >>>> >>>> I'm pretty sure you'll have more than a few. >>>> >>>> >>>> >>>> Why is your DB 24gb? Why don't you archive the database >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> >>>> Jeremy McSpadden >>>> >>>> >>>> >>>> On Feb 28, 2012, at 2:25 PM, "Kleber Rocha" <[email protected]> >>>> wrote: >>>> >>>> >>>> >>>> Jeremy, >>>> >>>> >>>> >>>> Thanks for the reply. >>>> >>>> >>>> >>>> But this table has 24GB, how can I avoid this issue? >>>> >>>> >>>> >>>> Thanks. >>>> >>>> >>>> >>>> >>>> >>>> 2012/2/28 Jeremy McSpadden <[email protected]> >>>> >>>>> >>>> >>>>> Export the table, then reimport. Will re-index on import. >>>> >>>>> >>>> >>>>> >>>> >>>>> -- >>>> >>>>> Jeremy McSpadden >>>> >>>>> >>>> >>>>> On Feb 28, 2012, at 2:02 PM, "Kleber Rocha" <[email protected]> >>>> wrote: >>>> >>>>> >>>> >>>>> > Hi, >>>> >>>>> > >>>> >>>>> > I have many errors like: >>>> >>>>> > >>>> >>>>> > Duplicate entry '7AF82AC3AF1.A5D3F' for key 'PRIMARY' error 1062 >>>> >>>>> > recorded: Duplicate entry '7AF82AC3AF1.A5D3F' for key 'PRIMARY' >>>> >>>>> > >>>> >>>>> > >>>> >>>>> > How can I fix this? >>>> >>>>> > >>>> >>>>> > Thanks >>>> >>>>> > _______________________________________________ >>>> >>>>> > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>>> >>>> >>>>> _______________________________________________ >>>> >>>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>> >>>> >>>> >>>> >>>> _______________________________________________ >>>> >>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>> >>>> >>>> >>>> >>>> _______________________________________________ >>>> >>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>> >>>> >>> >>>> >>> _______________________________________________ >>>> >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>> >>>> >>> >>>> >>> _______________________________________________ >>>> >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>> >>>> >> >>>> >> _______________________________________________ Keep Baruwa FREE - >>>> >> http://pledgie.com/campaigns/12056 >>>> >> >>>> >> _______________________________________________ >>>> >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >> >>>> > >>>> > >>>> > _______________________________________________ >>>> > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> > >>>> _______________________________________________ >>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>> >>> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
