75 articles Uncategorized

Mysql Stat reporting with mysqlreports

 Mysqlreport A free tool to see what your mysql server is doing  is mysqlreport. It gives current usage and statistics. Install it with the following commands: cd ~ (you can install it to any directory, ie /user/local/sbin I use home for simplicity). wget hackmysql.com/scripts/mysqlreport chmod 755 mysqlreport Now you simply run the command. ./mysqlreport –host…

WordPress FS_Method getting ftp Auth Request

This is information on what to do if you are trying to upgrade, or install a wordpress plugin and you get a FTP Authentication request. INFORMATION: Here is some information about setting up  FS_Method. FS_METHOD forces the filesystem method. It should only be “direct”, “ssh2”, “ftpext”, or “ftpsockets”. Generally, you should only change this if…

Rackspace phpmyadmin install method ran with Apache

 Rackspace phpmyadmin install method ran with Apache Centos Install Instructions: First lets see if it’s installed: Centos/Redhat: yum list installed |grep -i phpmyadmin   Check to see if phpmyadmin is in the current Repo’s you have: yum list |grep -i phpmyadmin Note:CENTOS/REDHAT ONLY!  If it is not in the Repo you will have to install…

Postfix unable to recieve email from some senders.

 Postfix unable to recieve email from some senders. You may run into a problem with Postfix when you are not getting a message from a few senders, but receiving messages from everyone else.  It is likely that you have SPF checker enabled in Postfix’s main.cf config file and the senders have malformed, or incomplete SPF…

How Do I Whitelist Hosts/IP Addresses In Postfix?

How Do I Whitelist Hosts/IP Addresses In Postfix? If you are not recieving emails from a sender to Postfix, this could be due to issues with the senders SPF record being incomplete, or malformed. If you really need to get emails from the sender one way would be to whitelist the ip or host address…

xmlrpc fail2ban block

First, I needed to create a filter, telling fail2ban what kinds of requests I wanted to block. On my system I created a file at /etc/fail2ban/filter.d/apache-xmlrpc.conf. The file is fairly simple:  [Definition]failregex = ^<HOST> .*POST .*xmlrpc.php.*ignoreregex = This tells fail2ban how to parse the log files to find requests for xmlrpc.php, and where to find the IP address. You might…

Ansible copy files to multiple servers.

There are many ways to copy a file over to many servers, but I think using Ansible with a adhoc command is a simple way to get it done with my method.  For official documentation see here: http://docs.ansible.com/ansible/intro_adhoc.html#file-transfer Step 1. Install Ansible I like to install ansible in a virtualenv with pip. Create a VirtualEnv…

Ansible Reload Apache on multiple servers

Sometimes you’d like to reload Apache after a config change on several servers. ansible adhoc commands makes this pretty simple. Step 1. Install Ansible I like to install ansible in a virtualenv with pip. Create a VirtualEnv Install pre-reqs Ubuntu: apt-get update && apt-get install python-apt python-pip build-essential python-dev git python-virtualenv -y RHEL/CentOS: yum install…