This problem happens when you modify user table in mysql database. In Debian system, there is a user named debian-sys-maint. We can’t restart mysql daemon if the password is not correct. We have to update the password for that user. First, we check the password: Login to mysql shell as root Now use the following…
The purpose of saving Apache access log into MySQL database is to make it easier to parse website’s visitor information. First of all, we do repository update: Install libapache2-mod-log-sql Create apachelogs and scoreboard table: Modify /etc/apache2/sites-available/default: If you have other virtual hosts, you can put LogSQLTransferLogTable directive into each virtual host tag. Create mod_log_sql-preserve file:…
PHP is a popular web scripting language. This article will show you how to install PHP on Ubuntu / Debian server. 1. First of all, we update repository. 2. Install PHP and Apache web server 3. It’s done. You can put your .php source code at /var/www and access http://your_ip from browser. Now we will…
PhpMyAdmin is a web-based tool written in PHP to handle administration of MySQL database. To install PhpMyAdmin on Ubuntu / Debian, execute this command: After that, you can access it on http://your_ip/phpmyadmin/
Sudo is a program that allows users to run programs with the security privileges of another user (normally the superuser, or root). The /etc/sudoers file controls who can run what commands as what users on what machines and can also control special things such as whether you need a password for particular commands. To add…
Fail2ban is an important software for system administrator. It scans log files (e.g. /var/log/auth.log) and bans IPs that show malicious signs, something like too many password failures and looking for exploits. To install fail2ban, execute this command: Open the configuration file to activate some rules: Find following line to set email destination for notification: Find…
Download version 0.30.6 from this link. # cd /root # wget http://sourceforge.net/projects/ehcp/files/ehcp_yeni.tgz/download Extract the file Backup current EHCP # copy -R /var/www/new/ehcp /root/backup_ehcp Copy new EHCP # copy -R /root/ehcp /var/www/new/ Copy config.php from backup # cp /root/backup_ehcp/config.php /var/www/new/ehcp Open browser and go to http://your_ip and login to EHCP. If you have logged in already,…
EHCP is a free and open source web hosting control panel. This guide will show you how to install it on Ubuntu server. Check /etc/apt/sources.list. It should have the following line (replace oneiric with your version). deb http://archive.ubuntu.com/ubuntu/ oneiric main restricted deb-src http://archive.ubuntu.com/ubuntu/ oneiric main restricted deb http://archive.ubuntu.com/ubuntu/ oneiric-updates main…
There are two approaches to change Grub boot order: command line and GUI. For command line method: Run this command to edit /etc/default/grub: $ sudo nano /etc/default/grub Change the number in GRUB_DEFAULT line. First boot menu is numbered 0. If it is 6th boot menu, type in GRUB_DEFAULT=5. Press CTRL-X, press Y, press Enter (save…
Make sure kernel source is installed. If it is not installed, use ‘sysinstall’ command. Copy kernel GENERIC configuration: # cd /usr/src/sys/i386/conf/ # cp GENERIC KERNELNEW Edit KERNELNEW configuration as your needed: # ee KERNELNEW And then, build the kernel: # cd /usr/src # make buildkernel KERNCONF=KERNELNEW # make installkernel KERNCONF=KERNELNEW Finish. Reboot PC. To build…
