Ubuntu: How to Fix “Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg)”

To resolve this issue, we have to export GPG key from deprecated keyring. Get list of existing keys Export the key Key BE1229CF is the last 8 digit taken from key list. The following message will appear: Now we can update our apt source file for the repository (e.g., /etc/apt/sources.list.d/microsoft.list), adding a signed-by tag: Update apt to make…

Read More

How to Fix MySQL Error “Stopping MySQL database server : mysqld failed!” on Debian Squeeze

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…

Read More

How to Save Apache Access Log into MySQL Database Using libapache2-mod-log-sql on Debian Squeeze

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:…

Read More