Reset vtiger default admin password

January 11, 2010 by  
Filed under Tools and Utilities

Comments Off

UPDATE vtiger_users SET user_hash = ‘21232f297a57a5a743894a0e4a801fc3′,
user_password = ‘adpexzg3FUZAk’,
confirm_password = ‘adoY/6Mlw8kqg’ WHERE user_name = ‘admin’

This will set the admin password to ‘admin’ again.

Install MySql on CentOS 5.x

January 6, 2010 by  
Filed under Linux Tutorials, MySQL

Comments Off

How to install MySql in CentOS 5.3 from shell or webmin

 

Login the server SSH using root

Inorder to check if mysql is already installed or not run this command
which mysql
If found it will show some directory name otherwise not found

In order to remove old mysql
yum remove mysql-server
yum remove mysql

Now to install mysql run this command from the shell or a command line access point
yum install mysql-server
yum install mysql
yum install mysql-devel

Inorder to use with php
yum install php-mysql

service mysqld restart

By default mysql has the no passward. To change the password in command shell write the following commands
mysql
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD(‘new-password’) WHERE user=’root’;
mysql> FLUSH PRIVILEGES;

Install imagemagick on cpanel

January 6, 2010 by  
Filed under cPanel-WHM

Comments Off

For installing imagemagick on a cpanel server,
you need to undergo below steps :

1. Log into your server as root
2. Create a new directory as below :
mkdir /home/cpimins
3. cd /home/cpimins
4. wget http://layer1.cpanel.net/magick.tar.gz
5. tar zxvf magick.tar.gz
6. cd magick
7. /scripts/installrpm ImageMagick
8. /scripts/installrpm ImageMagick-devel
9. sh ./install