Thursday, September 10, 2015

How to install and configure MySQL on Cent OS

Here are the steps to install and configure MySQL on Cent OS :
  • Install MySql Server
    • yum install mysql-server mysql php-mysql
  • Set to Chkconfig to start on boot
    • chkconfig –level 235 mysqld on
  • Start the MySQL service
    • service mysqld start
  • Set the password for all domains
    • myql -u root
    • SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');
    • SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('new-password');
    • SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');
  • Exit and verify the MySQL version
    • exit
    • mysql --version
      • mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1




How to install GIT on CentOS

It is quite easy to install GIT using YUM command line manage utility on CENT OS 6.

Install :

# yum clean all
# yum install git

Verify Subversion : 

# git --version

Thanks..!!!

Monday, August 24, 2015

How to add MySQL component in the Tivoli Directory Intregator (TDI).

To support MySQL database in the TDI, You first need to add mysql driver into the TDI

Here are the steps :
  • Download and copy mysql (mysql-connector-java-5.1.23-bin.jar ) jar to the location "${IBM}\TDI\V7.1\jars\3rdparty\others" where IBM is your installation directory
  • Restart TDI if it's running.
  • Click on Add component under AssemblyLines and choose JDBC connector
  • In JDBC URL,  add “jdbc:mysql://<IP>:<PORT>/<DATABASE_NAME>”.
  • in JDBC Driver, add com.mysql.jdbc.Driver
  • Provider correct Username and Password of your database.
  • Select table Name from select button.
  • Click Finish to connect to the MySQL Database.



How TOPT Works: Generating OTPs Without Internet Connection

Introduction Have you ever wondered how authentication apps like RSA Authenticator generate One-Time Passwords (OTPs) without requiring an i...