From Technical Knowledge to IT Service Management

Archive for April 2012

RedMine solution

If you are looking for a web solution to drive one or many projects: Redmine could be the good web application. I’ve tested it and like other apps running on Ruby on Rails framework, the result is good.

Just have a look: http://www.redmine.org or test the online demo: http://demo.redmine.org/

ITIL Foundation V3 – Training done

The purpose of the ITIL Foundation certificate in IT Service Management is to certify that I’ve gained knowledge of the ITIL terminology, structure and basic concepts and have comprehended the core principles of ITIL practices f or service management.

I’m working in an organization that has adopted and also adapted ITIL, i will be able to contribute to an ongoing service improvement on every project i will lead.

The different subjects were:

  • Service management as a practice
  • The ITIL service life cycle
  • Generic concepts and definitions
  • Key principles and models
  • Selected processes
  • Selected functions
  • Selected roles
  • Technology and architecture
  • Competence and training

I have to wait the exam result to get my certification.

Just lost your root password on MySQL ?

Loosing your root password on a MySQLserver could become tricky.

If you face this situation, you will have to stop your MySQL server

#/etc/init.d/mysql stop

One your database is stopped, you will start it again with 2 options to avoir authentication process but also avoid networtking connection to your unsecure database:

#/usr/libexec/mysqld --skip-grant-tables --skip-networking &

you will now be able to connect without password:

#mysql mysql -u root

One you are connected, you can reset your password and flush the privileges to apply changes on database:

MYSQL> UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';

MYSQL>FLUSH PRIVILEGES;

MYSQL>quit;

Then restart mysql:

#/etc/init.d/mysql restart

And start using KeePass software to store your password !

Non alphanumeric files

If you want to list all the non alphanumeric files:

ls -R | grep -iv ^[a-z0-9\._-]*$