Arquivo de outubro, 2014

Atualizando o Endian Firewall

Publicado: outubro 28, 2014 em Endian

Atualizando o Endian Firewall

Olá a todos mais uma vez

Este tutorial mostra como atualizar o Endian Firewall para a versão mais recente sem a necessidade de reinstalar todo o sistema.

O primeiro passo para isso é se registrar na comunidade no site Endian, você pode fazer isso clicando aqui, nesse link você deve preencher nome sobrenome email válido onde você deverá ir até sua caixa postal para validar o recebimento.

O próximo passo é fazer um backup do seu endian firewall e caso não saiba como fazê-lo pode clicar aqui e ver nosso tutorial

Feito isso você deve se logar como root na console do endian ou via ssh e executar o seguinte comando:

efw-upgrade -s

vai exibir a seguinte tela

1) Production (stable releases)

2) Development (bleeding edge)

Selecione a opção 1

Vai aparecer esta tela

Please enter your username and hit [ENTER]:

Digite o email que registrou no site do Endian no primeiro passo e digite enter.

Feito isso o Endian vai fazer o download das versões mais novas e será necessário reinicar o endiar para concluir o processo.

Abraço a todos e qualquer coisa deixem um comentário.

 

Fonte: http://www.cooperati.com.br/2011/03/29/endian-firewall-serie-de-posts-6/

MySQL database server generates binary log files for every transaction to the databases, provided administrator does not disable or comment out the “log-bin” parameter in my.cny configuration file. The binary log files are written in binary format. Although the binary logs, or also known as logbin are mainly used for MySQL database replication purpose, sometimes you may need to examine or read the contents of binary logs in text format, where the mysqlbinlog utility will come in handy.

Binary log file, which normally has name with the format host_name-bin.xxxxxx and store in /var/lib/mysql directory, could not be opened and read straight away as it’s in unreadable binary format. To read the binary logs in text format, we can make use of mysqlbinlog command, which also able to readrelay log files written by a slave server in a replication setup. Relay logs have the same format as binary log files.

To use mysqlbinlog utility is simple, simply use the following command syntax to invoke mysqlbinlog after login in as root (else you have to specify user name and password) to shell via SSH:

mysqlbinlog [options] log_file ...

So to read and display the contents of the binary log file named binlog.000001, use this command:

mysqlbinlog binlog.000001

The binary log files and its data are likely to be very huge, thus making it almost impossible to read anything on screen. However, you can pipe the output of mysqlbinlog into a file which can be open up for later browsing in text editor, by using the following command:

mysqlbinlog binlog.000001 > filename.txt

To reduce the amount of data retrieved from binary logs, there are several options that can be used to limit the data that is been returned. Among the useful ones are listed below:

–start-datetime=datetime

Start reading the binary log at the first event having a timestamp equal to or later than the datetime argument. The datetime value is relative to the local time zone on the machine where you run mysqlbinlog. The value should be in a format accepted for the DATETIME or TIMESTAMP data types. For example:

mysqlbinlog --start-datetime="2005-12-25 11:25:56" binlog.000001

–stop-datetime=datetime

Stop reading the binary log at the first event having a timestamp equal or posterior to the datetime argument. This option is useful for point-in-time recovery. See the description of the –start-datetime option for information about the datetime value.

–start-position=N

Start reading the binary log at the first event having a position equal to the N argument. This option applies to the first log file named on the command line.

–stop-position=N

Stop reading the binary log at the first event having a position equal or greater than the N argument. This option applies to the last log file named on the command line.

 

Fonte: http://www.mydigitallife.info/how-to-read-mysql-binary-log-files-binlog-with-mysqlbinlog/