Connect PHP in Debian Jessie to Ms Sql Server using FreeTDS

In this post we will connect Php code in Linux env (Debian 8 Jessie) to M$ Sql Server, using FreeTDS (latest vers.).

We start from a fresh installation of Debian 8 Jessie.

# apt-get update && sudo apt-get upgrade
# apt-get install apache2
# apt-get install php5
# /etc/init.d/apache2 restart
# apt-get install dpkg-dev
# apt-get install devscripts

To check that php5 works fine

# php -v
PHP 5.6.13-0+deb8u1 (cli) (built: Sep  7 2015 13:38:37)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies

Now if all works fine you can continue. Click here to continue reading Php code in Linux to Ms Sql Server using Freetds

Setting Fail2ban to track attacks in IspConfig setup

karatekidWe have an ISPConfig setup for some of our web hosting, and I noticed a lot of brute force attempts in analyzing /var/log/apache/error.log.

[Sat Jul 11 09:55:03 2015] [error] [client XX.XX.XX.XX] script '/var/www/setup.php' not found or unable to stat
.....
[Sat Jul 11 09:55:03 2015] [error] [client XX.XX.XX.XX] script '/var/www/xmlrpc.php' not found or unable to stat
.....

To solve this brute force attempts we added the following rules in fail2ban. Continue reading