mysql-bin files - filling up the space.
Dear All Greetings, i am seeking help from guys with mysql knowledge. i can see lot of these files in mysql directory. And they are eventually filling up the space on the server. what these files are? some exists with very old time stamps. such as February 2012. can these be deleted? This Number Starts From ---mysql-bin.01 -rw-rw 1 mysql mysql 159M Apr 25 12:24 mysql-bin.000197 -rw-rw 1 mysql mysql 5M Apr 26 00:00 mysql-bin.000198 -rw-rw 1 mysql mysql 8.1M Apr 27 00:00 mysql-bin.000200 -rw-rw 1 mysql mysql 125B MAY 27 20:29 mysql-bin.000230 Prabh S. Mavi ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
Re: mysql-bin files - filling up the space.
On Thu, 3 May 2012 14:22:08 - "Prabhpal S. Mavi" wrote: > Dear All Greetings, > > i am seeking help from guys with mysql knowledge. i can see lot of > these files in mysql directory. And they are eventually filling up > the space on the server. what these files are? some exists with very > old time stamps. such as February 2012. can these be deleted? > > This Number Starts From ---mysql-bin.01 > > -rw-rw 1 mysql mysql 159M Apr 25 12:24 mysql-bin.000197 > -rw-rw 1 mysql mysql 5M Apr 26 00:00 mysql-bin.000198 > -rw-rw 1 mysql mysql 8.1M Apr 27 00:00 mysql-bin.000200 > > -rw-rw 1 mysql mysql 125B MAY 27 20:29 mysql-bin.000230 > > you should read official documentation, I think. http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html for example > > Prabh S. Mavi > > > > ___ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to > "freebsd-stable-unsubscr...@freebsd.org" -- wbr, tiger ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
Reject Action For SPF
Dear Friends, i have setup SPF alright, postfix is performing check as well (results below), but even if there is no SPF record exist for a domain, message is still accepted. how can i set the reject action, if no SPF available. May 3 16:11:14 titan postfix/policy-spf[5353]: : SPF none (No applicable sender policy available): Envelope-from: somedomain.com Prabh S. Mavi Prabh S. Mavi ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
Re: Reject Action For SPF
On Thu, May 03, 2012 at 04:30:53PM -, Prabhpal S. Mavi wrote: > > Dear Friends, > > i have setup SPF alright, postfix is performing check as well (results > below), but even if there is no SPF record exist for a domain, message is > still accepted. > > how can i set the reject action, if no SPF available. > Why would you want to reject mail from legitimite senders that do not have SPF records published? Glen ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
Re: Reject Action For SPF
> Why would you want to reject mail from legitimite senders that do not > have SPF records published? > > Glen Dear Glen. B Thanks for your response, We want to implement this no our backup MX server. i trust this explains the reason. i know SPF is not spam prevention mechanize. Can you tell me how to set reject action? Prabh S. Mavi ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
Re: /var getting full
Hello. I did not write the Java program. I've sent your recomendation to our programmers. Thank you. -Mensaje original- From: Peter Maloney Sent: Monday, April 30, 2012 3:11 AM To: freebsd-stable@freebsd.org Subject: Re: /var getting full Am 27.04.2012 17:26, schrieb Efraín Déctor: Thank you all. I found out that a Java process was using all this space. I restarted it and voilá problem solved. Did you write this Java program? If so, you probably need a finally block: File f = ... InputStream in = null; try { in = new FileInputStream(in); //whatever you do here, such as create a Reader, you keep a reference to the InputStream }finally{ //A finally is called regardless of what happens in the try. For example, if there is an Exception thrown, the finally is run anyway. Code at the end of the try is not called when an exception is thrown. if( in != null ) { //you must wrap this in a try{}catch(IOException){}, otherwise the rest of your finally is not run if it throws an Exception try{ in.close(); }catch(IOException e) { logger.log(Level.SEVERE, Failed to close InputStream", e); } } } Thanks. -Mensaje original- From: Tom Evans Sent: Friday, April 27, 2012 10:22 AM To: Damien Fleuriot Cc: freebsd-stable@freebsd.org Subject: Re: /var getting full On Fri, Apr 27, 2012 at 4:19 PM, Damien Fleuriot wrote: Type: sync Then: df -h Then: cd /var && du -hd 1 Post results. As well as this, any unlinked files that have file handles open by running processes will not be accounted for in du, but will be counted in df. You could try restarting services that write to /var. Cheers Tom ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org" ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org" ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org" ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
User root can't get email
Hello. I have a FreeBSD Server 8.2, the past few days I’ve noticed that the user root was not recieving email. I ran a test simply by using: mail root Then in /var/log/messsages I got this message: May 3 22:47:56 edh sendmail[74022]: q3RFM513074022: SYSERR(root): Cannot reopen ./dfq3RFM513074022: No such file or directory May 3 22:47:56 edh sendmail[74022]: q3RFM514074022: SYSERR(root): putbody: Cannot open ./dfq3RFM513074022 for MAILER-DAEMON from root: No such file or directory Im not using this server as a email server, but it is very important to me because I have some scripts running by cron that send the output by email to the user that is running them, in this case root. Thanks in advance. ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
Re: Reject Action For SPF
In message , "Prabhpal S. Mavi" writes: > > > Why would you want to reject mail from legitimite senders that do not > > have SPF records published? > > > > Glen > > Dear Glen. B > > Thanks for your response, We want to implement this no our backup MX > server. i trust this explains the reason. i know SPF is not spam > prevention mechanize. Can you tell me how to set reject action? Fix your backup server to have the data required to perform the filtering. Don't force the rest of the world to waste cycles and bandwidth attempting to send email to a backup MX that you have advertised. If you can't do it correctly, DO NOT DO IT. > Prabh S. Mavi > > ___ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org" -- Mark Andrews, ISC 1 Seymour St., Dundas Valley, NSW 2117, Australia PHONE: +61 2 9871 4742 INTERNET: ma...@isc.org ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"
Re: User root can't get email
On Thu, May 03, 2012 at 06:02:35PM -0500, Efraín Déctor wrote: > Hello. > > I have a FreeBSD Server 8.2, the past few days I’ve noticed that the user > root was not recieving email. I ran a test simply by using: > > mail root > > Then in /var/log/messsages I got this message: > > May 3 22:47:56 edh sendmail[74022]: q3RFM513074022: SYSERR(root): Cannot > reopen ./dfq3RFM513074022: No such file or directory > May 3 22:47:56 edh sendmail[74022]: q3RFM514074022: SYSERR(root): putbody: > Cannot open ./dfq3RFM513074022 for MAILER-DAEMON from root: No such file or > directory > > Im not using this server as a email server, but it is very important to me > because I have some scripts running by cron that send the output by email to > the user that is running them, in this case root. > If you have recently been working on upgrading your system in any way I would check the perms on all the directories in /var and possibly other systems as can be advised in a upgrade procedure within the handbook. You may also attempt the following which may fix it but it comes with a disclaimer and you should know how to fix it if it breaks. mtree -deU -f /etc/mtree/BSD.var.dist Before doing the above, I would seriously ask myself... What did I do in those last few days or week or so... and at least attempt to backtrack to a conclusive result. Good luck. -- - (2^(N-1)) pgpeiDnFgjzFc.pgp Description: PGP signature
Re: User root can't get email
And possibly /etc/mtree/BSD.sendmail.dist On Fri, May 04, 2012 at 01:05:05AM -0400, Jason Hellenthal wrote: > > > On Thu, May 03, 2012 at 06:02:35PM -0500, Efraín Déctor wrote: > > Hello. > > > > I have a FreeBSD Server 8.2, the past few days I’ve noticed that the user > > root was not recieving email. I ran a test simply by using: > > > > mail root > > > > Then in /var/log/messsages I got this message: > > > > May 3 22:47:56 edh sendmail[74022]: q3RFM513074022: SYSERR(root): Cannot > > reopen ./dfq3RFM513074022: No such file or directory > > May 3 22:47:56 edh sendmail[74022]: q3RFM514074022: SYSERR(root): putbody: > > Cannot open ./dfq3RFM513074022 for MAILER-DAEMON from root: No such file or > > directory > > > > Im not using this server as a email server, but it is very important to me > > because I have some scripts running by cron that send the output by email > > to the user that is running them, in this case root. > > > > If you have recently been working on upgrading your system in any way I > would check the perms on all the directories in /var and possibly other > systems as can be advised in a upgrade procedure within the handbook. > > You may also attempt the following which may fix it but it comes with a > disclaimer and you should know how to fix it if it breaks. > > mtree -deU -f /etc/mtree/BSD.var.dist > > > Before doing the above, I would seriously ask myself... What did I do in > those last few days or week or so... and at least attempt to backtrack > to a conclusive result. > > > Good luck. > > -- > > - (2^(N-1)) -- - (2^(N-1)) ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "freebsd-stable-unsubscr...@freebsd.org"