Under mitzkia.github.com/syslog-ng-ose-configurator you can find a configurator for syslog-ng. It still lacks a few syslog-ng features but otherwise this is a very round thing. I’m not quite sure if it’s worth an app for such a complex config. But for simple installations already very useful.
I´ve already pointed out here, that you can easily restart a replication. But you have to know that the replication isn´t working. Instead of continuously typing “CHECK SLAVE STATUS\G” in mysql i´ve decided to use nagios for that. If something is wrong, i get a mail and a notification in […]
If the mysql-replication is broken, there are two ways to fix the problem: skip the error rebuild the replication In some cases you could easily skip error. If you for example execute the same INSERT on both server. Skip the error Login into mysql as root: STOP SLAVE; SET GLOBAL […]
I use postscreen postscreen to prevent spam mails. Potential spam messages are rejected directly before they reach the server and the content must be scanned. You shouldn´t use postscreen if a Mail-User-Agents (MUAs) should be able to connect. Usually the TCP-Port 25 is only used for Mail-Transfer-Agents (MTAa) since MUAs […]
I wrote a small plugin for nagios to check the current clamav-version. Setup nagios: define command{ command_name check_clamdv command_line $USER1$/check_clamdv $ARG1$ } define service{ use local-service host_name obelix.schaal-24.de service_description CLAMD Version check_command check_clamdv # if clamd is not located in /usr/local/sbin/clamd, use #check_command check_clamdv!/path/to/your/clamd check_interval 15 } check_clamd Download #!/bin/bash […]
In contrast to a master-slave replication in a master-master replication changes made on one server are immediately available on both. The setup of a master-master-replication is similar to a master-slave-replication. I show here only the differences (for the basics see mysql master-slave-replication). In the following to old master remains as […]
In a master-slave replication on the slave are the databases of the master 1:1 available. Changes performerd on the master are immediately available on the slave (as long as you don´t user master_delay). Thus, it is not a true backup solution. Master setup: Change the section [mysqld] in /etc/my.cnf. Make […]
When decrypt a gpp-file (gpg-d file.gpg> file) i got the error-message “gpg: decryption failed: No secret key”. It’s funny, the key is certainly there. A simple chmod o + rw $ (tty) has helped. Apparently gpg has inside the su environment a few problems. Sure, you can also set the […]