AWstats Reporting Problem after update latest Virtualmin (Fix)

  Virtualmin by updating "System Settings -> Features and Plugins -> Awstats -> Configure".

Full path to AWstats program to /var/www/awstats/awstats.pl
Full path to AWstats icons directory to /var/www/awstats/icon
Full path to AWstats lang directory to /var/www/awstats/lang
Full path to AWstats lib directory to /var/www/awstats/lib
Full path to AWstats plugins directory to /var/www/awstats/plugins

How to install your own VPN server in 5 mins (PPTP on CentOS, RedHat and Ubuntu)

Virtual Private Network (VPN) is the most effective way to bypass access control, the censorship, and network spying. It is also a safe way to connect to the internet to protect your privacy. It is usually better than using web proxy.
For example,  when you are on a business visit to Asia, very likely,  you are not able to access your Hulu Plus contents, or Amazon Prime unless you use a VPN connection to a server located in US. The reason is that Hulu or Amazon is only allowed to stream videos in US per license agreement with copyright holders.
Of course, there are many VPN providers. But if you want full control or want to  share the vpn with your buddies, you can get a server and install it by yourself.
Before you start, you need get a dedicated server with root access. VPS may not work well depending on the virtualization software used. You can get a cheap dedicated server with less than $50/month.
There are mainly 3 types of VPN servers: Point-to-Point Tunneling Protocol (PPTP), Layer 2 Tunneling Protocol (L2TP) and OpenVPN. In this tutorial, we use PPTP because it is supported natively on almost all devices, Windows, Linux, Android, IOS and Mac OS.
Step 1. Install PPTPD
If your OS is CentOS/RedHat 5:

yum install ppp
cd /usr/local/src
wget http://poptop.sourceforge.net/yum/stable/packages/pptpd-1.3.4-2.rhel5.x86_64.rpm
rpm -Uhv pptpd-1.3.4-2.rhel5.x86_64.rpm

If your OS is CentOS/RedHat 6:

yum install ppp
cd /usr/local/src
wget http://poptop.sourceforge.net/yum/stable/packages/pptpd-1.3.4-2.el6.x86_64.rpm
rpm -Uhv pptpd-1.3.4-2.el6.x86_64.rpm

If you are using Ubuntu:

apt-get install pptpd

Step 2. Edit IP setttings in /etc/pptpd.conf
vi /etc/pptpd.conf

localip 192.168.0.1
remoteip 192.168.0.101-200

Step 3. Add user account in/etc/ppp/chap-secrets (assign username and password)
vi /etc/ppp/chap-secrets

usernameForuser1 *  setpassword1here  *
usernameForuser2 *  setpassword2here  *

Step 4. Optional settings in /etc/ppp/options.pptpd
vi /etc/ppp/options.pptpd

ms-dns 8.8.8.8
ms-dns 4.4.4.4

Step 5. Enable network forwarding in /etc/sysctl.conf
vi /etc/sysctl.conf

net.ipv4.ip_forward = 1

use the following command to apply the change:
sysctl -p
Step 6. Configure firewall
iptables -A INPUT -i eth0 -p tcp --dport 1723 -j ACCEPT
iptables -A INPUT -i eth0 -p gre -j ACCEPT
iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE
iptables -A FORWARD -i ppp+ -o eth0 -j ACCEPT
iptables -A FORWARD -i eth0 -o ppp+ -j ACCEPT
service iptables save
service iptables restart
If you are using CSF firewall, you may refer to this post on firewall settings.
Step 7. Start PPTP VPN server
If your OS is CentOS or Redhat, using the following command:
service pptpd restart

To start PPTP Daemon automatically when rebooting next time, use command:

chkconfig pptpd on

If your OS is Ubuntu, you just reboot your machine.
Now you can test the VPN server from any client: Windows PCs, Linux PCs, Android phones/tablets, or iPhone and iPad.
The log of the VPN server, by default, is combined with system log located at /var/log/messages.

Source: ( http://freehostinganswers.com/blog/how-to-install-your-own-vpn-server-in-5-mins-pptp-on-centos-redhat-and-ubuntu/)

Connect PHP to MSSQL Server Setting

 

rpm -ivh http://dag.wieers.com/rpm/packages/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm



cd /etc/yum.repos.d/

wget http://rpms.famillecollet.com/enterprise/remi.repo



yum install freetds

yum install freetds-devel

yum install --enablerepo=remi php-mssql

How to install wireshark in CentOs 6.2

firstly type
# yum install wireshark -y

install for GUI version
# yum install wireshark-gnome

Useful Link for CentOS Configuration

http://www.server-world.info

ProFTPD and AuthUserFile for password file

ProFTPD and AuthUserFile for password file

By dooblem on Monday 11 October 2010, 00h45 - Permalink

• Debian
• ProFTPD

Default in Debian: ProFTPD only uses the /etc/passwd system user base.

To add "virtual" users :

In /etc/proftpd/proftpd.conf:

DefaultRoot ~
AuthUserFile /etc/proftpd/ftpd.passwd
RequireValidShell off

Then restart proftpd: /etc/init.d/proftpd restart

Create users file:

vi /etc/proftpd/ftpd.passwd
username:HASH:1011:1011:MyUserName:/home/ftp/directory:/bin/true

You can also generate the user lines with the ftpasswd command, but I think it's simpler to generate passwords with the command:

mkpasswd --hash=md5

Then paste the HASH in the passwd file.

Correct passwd file permissions:

chown proftpd /etc/proftpd/ftpd.passwd
chmod go-r /etc/proftpd/ftpd.passwd

And just test it to finish.

mod_python installation guide

To install mod_python, we need the EPEL repositories:

1	rpm --import https://fedoraproject.org/static/0608B895.txt

2	wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-7.noarch.rpm

3	rpm -ivh epel-release-6-7.noarch.rpm

4	yum install yum-priorities

Now edit the /etc/yum.repos.d/eped.repo file and add priority=10 to the [epel] section.
After that follow the steps below and you’ll have mod_python installed and active.

1	yum install mod_python

2	service httpd restart

Now you should configure your httpd.conf files so that apache nows where and when to interpret your Python scripts. If you have installed you system with our LAMP installer, then go to /etc/httpd/conf.d and edit you websites .conf file (starting with a z_)

1	vi /etc/httpd/conf.d/z_castmator.com

Make sure you add the following lines in the <Directory …> </Directory> statements.

1	AddHandler mod_python .py

2	PythonHandler mod_python.publisher

3	PythonDebug On

Don’t forget that PythonDebug is for debug mode. When you’re done developing it may be a good idea to turn it off.
Also don’t forget to add your DirectoryIndex handlers so that Apache knows you can also have Python Index files. You can add this right after the </Directory> statement.

1	DirectoryIndex index.html index.php index.py

Since we’ve altered with the configuration files of Apache, we should restart it again, then you are ready to go.

1	service httpd restart