Scientific Linux 6.2
2012/2/28 Jeremy McSpadden <[email protected]> > What flavor of Linux? Version? > > > -- > Jeremy McSpadden > > On Feb 28, 2012, at 4:14 PM, "Kleber Rocha" <[email protected]> wrote: > > 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 > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
