mysql-bin files - filling up the space.

2012-05-03 Thread Prabhpal S. Mavi
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.

2012-05-03 Thread Sergey V. Dyatko
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

2012-05-03 Thread Prabhpal S. Mavi

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

2012-05-03 Thread Glen Barber
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

2012-05-03 Thread Prabhpal S. Mavi

> 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

2012-05-03 Thread Efraín Déctor
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

2012-05-03 Thread Efraín Déctor
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

2012-05-03 Thread Mark Andrews

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

2012-05-03 Thread Jason Hellenthal


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

2012-05-03 Thread Jason Hellenthal

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"