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/
Squirrelmail show this error when I tried to login to webmail: To fix the problem, check email folder and make sure it has the subfolder: cur, new, tmp with appropriate permission.
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,…
The purpose of this installation is to filter spam email and virus on Postfix mail agent. Here I already installed Postfix in the server, because it is included in EHCP installation. 1. Install the packages 2. Install the optional packages for better spam detection libmail-spf-query-perl package is not available in Debian, therefore I change to…
Ubuntu 11.10 comes with PostgreSQL 8.4. I did this downgrade because my web application, Hospital Management System, was developed using PostgreSQL 8.2 database and it will throw SQL query error if running on version 8.4. This is step by step guide how to install PostgreSQL 8.2 on Ubuntu 11.10 1.Download source code from http://www.postgresql.org/ftp/source/ and…