Archive for March, 2007

Apt-get: WARNING: The following packages cannot be authenticated!

Sunday, March 25th, 2007

When upgraded form Sarge to Etch I started to notice a warning when using apt-get install from command line. The warning said:

WARNING: The following packages cannot be authenticated!

Googling with the warning text as a keyword turned out (Debian style!) simple solution:

apt-get install debian-archive-keyring
apt-get update

Nice to know that this is becouse Debian offers another level of safety in installing packages.

Little bit more about this topic is avilable at the origin of the above solution:
How to solve “The following packages cannot be authenticated” – The Changelog

Posted in administration, apt, repositories | No Comments »

How-to change existing record in MySQL database

Sunday, March 25th, 2007

Sometimes I forget some password for accessing CMS system and mail is not working and …

So far it never happened that  I forgot some more important password, such as MySQL access password in which case I can change password directly in the database and thus enable myself to access the CMS backend

The “magic” line is

UPDATE table_name SET column_to_change WHERE record_to_update;

To be less general and less abstract: in case of password change the line should look like this:

UPDATE table_name SET password_column = MD5(‘new_password’) WHERE ID = user_id_to_change;

Posted in database, mysql, password | No Comments »