I was tasked with creating a new MySQL slave in a Brighton datacenter to replicate with the master in London. There was already a replication in place from London to Manchester. Here are the steps to copy the information from Manchester Slave (MySQL2) to the Brighton Slave (MySQL3) . This method allows the master MySQL to be completely untouched In Read More…
Category: FreeBSD
Nagios: DNS CRITICAL – ‘/usr/bin/nslookup -sil’ msg parsing exited with no address
Scenario: We changed from BIND to Unbound on a smarthost email server. As soon as this was changed Nagios started throwing up a "DNS CRITICAL – '/usr/bin/nslookup -sil' msg parsing exited with no address" . In the following example i've substituted myhost.domain.co.uk for the actual host. Troubleshooting steps: From the Nagios server i checked the config file: Read More…
Setting up vsFTPd to use SSL on FreeBSD
Notes: FreeBSD 9.1 / vsFTPD 3.0.2 / using a CA certificate 1) Ensure both private key and certificate are located in .pem. I named this vsftpd.pem 2) Edit the the vsftpd.conf file # vi /usr/local/etc/vsftpd.conf ### PASV FTP pasv_enable=YES pasv_min_port=49152 pasv_max_port=65535 port_enable=YES ssl_enable=YES ### SSL STUFF allow_anon_ssl=NO force_local_data_ssl=NO force_local_logins_ssl=NO ssl_tlsv1=YES ssl_sslv2=NO ssl_sslv3=NO rsa_cert_file=/usr/local/etc/vsftpd.pem 3) Read More…
Enable SNMP FreeBSD
1) Install Net-SNMP # cd /usr/ports/net-mgmt/net-snmp # make install clean 2) Create SNMP conf file # vi /usr/local/share/snmp/snmpd.conf syscontact [email protected] rocommunity public 10.0.0.1/24 syscontact Jordansphere syslocation London 3) Start SNMP service # /usr/local/etc/rc.d/snmpd start 4) Input line in rc.conf so it starts on a reboot # vi /etc/rc.conf snmpd_enable="YES"
Configuring MySQL Replication 5.5 in 6 steps
Scenario: You want to create a MySQL replication between an exisiting master and a brand new slave. Both machines running FreeBSD 8.x with MySQL 5.5. The master server currently has a mixture of InnoDB and MyISAM engines. A small amount of downtime is available. Master server: 10.1.1.1 Slave server: 10.1.1.2 (1) ON Read More…
Using Logrotate with MySQL Database Backups
Scenario: I wanted to backup all the databases individually from a MySQL server and keep for x days. I set about achieving this using a custom script combined with logrotate. The server is running FreeBSD 8.x. 1) Firstly, the script (backup-all-dbs.sh): #!/usr/local/bin/bash # backup-all-dbs.sh # backup each mysql db into a different file, rather Read More…
Add an IP alias to NIC on FreeBSD
Here are the steps for adding and removing an alias to a NIC on a FreeBSD 8.x machine. Find out the name of the NIC : # ifconfig As you’ll see from the above screenshot the NIC is called em0 Now to add the alias: # ifconfig em0 192.168.9.50 netmask 255.255.255.0 alias Read More…
MySQL Corruption: Error 1034 (HY000) : Incorrect key file for table ‘xyz’ ; try to repair it
Scenario: We upgraded from MySQL 5.1 to 5.5 (It was 4.1 in the past and possibly even 3.x before my time!). There seems to be some sort of corruption in a particular DB. The normal myisamchk and REPAIR TABLE functions didnt cut the mustard. Below are my steps to fix the issue. It appears that the Read More…
Installing and Enabling NRPE on Remote FreeBSD Server
Here are some instructions I had (from a couple of years ago may I add) to assist in setting up NRPE for remote monitoring from (eg) Nagios 1) Add nagios user. nologin 2) install nagios-plugins from ports (nagios-plugins-1.4.11,1 ) -> cd / /usr/ports/net-mgmt/nagios-plugins/ -> make -> make install 3) Set permissions -> chown Read More…
Login Incorrect when connecting from FreeBSD to SQL Server 2008 via FreeTDS
Scenario: I wanted to connect to an SQL server 2008 from a FreeBSD 8.2 machine using PHP5.3 and FreeTDS. We have a similar set up on another server running FreeBSD 7.2 with PHP 5.2 . This is still running in production and connecting to the same DB server successfully. The logical thing to do was Read More…