How to install Mysql5.7 on Oracle linux 7

 By default Mariadb comes with Oracle linux 7. I need to have mysql on my box.

yum remove mariadb-server -y

wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

yum install mysql-server -y

systemctl start mysqld

systemctl enable mysqld

sudo grep 'temporary password' /var/log/mysqld.log

mysql_secure_installation

How to install jenkins on amazon linux

How to install jenkins on amazon linux

 Following this steps to install jenkins on amazon linux

Login to the server

sudo wget -O /etc/yum.repos.d/jenkins.repo https://pkg.jenkins.io/redhat-stable/jenkins.repo

sudo rpm --import https://pkg.jenkins.io/redhat-stable/jenkins.io.key

yum install jenkins

sudo service jenkins start

sudo chkconfig jenkins on

Open a browser, and access http://publicip:8080

Qmail error while installing and configuraing

Qmail error while installing and configuraing

After installing Qmail, i tried to start qmail i got this error

[root@localhost qmail-smtpd]# qmailctl start
Starting qmail...

qmail-send supervise not running
qmail-smtpd supervise not running
qmail-pop3d supervise not running

I checked all the possible issues,

[root@localhost qmail-smtpd]# ls -l /service
total 0
lrwxrwxrwx 1 root root 32 2010-08-16 21:38 qmail-pop3d -> /var/qmail/supervise/qmail-pop3d
lrwxrwxrwx 1 root root 31 2010-08-16 21:38 qmail-send -> /var/qmail/supervise/qmail-send
lrwxrwxrwx 1 root root 32 2010-08-16 21:38 qmail-smtpd -> /var/qmail/supervise/qmail-smtpd

[root@localhost qmail-smtpd]# ps ax |grep supervise
10190 pts/1 T 0:00 supervise log
10332 pts/1 S+ 0:00 grep supervise

etc...........

Solution

'svscanboot' was not running

[root@localhost qmail-smtpd]# svscanboot &
[2] 10336
[root@localhost qmail-smtpd]# qmailctl start
Starting qmail...

Starting qmail-send
Starting qmail-smtpd
Starting qmail-pop3d

It works !!!! Seems like we have to reboot the server after installing daemontools.

How to untar a file in Sun Solaris10

Normally i am doing is like this " tar -xzvf file.tar.gz "
But here in Solaris10 its not working,

this will helps.

gunzip -c somefile.tar.gz |tar xvf -

How to upgrade php 5.1.6 to php5.3

My box is Centos 32bit

Following steps i have done, used yum remi repository

wget http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm

yum --enablerepo=remi update php

Check php -v
rpm -qa | grep php

I forgot the admin user/password of moodle, but i have mysql access. How can i restore the admin password?

Login to the mysql prompt.
use table_name
update mdl_user set password='0192023a7bbd73250516f069df18b500' where  username='admin';
quit

I know moodle is using MD5 encryption.
The above mentioned is MD5 encryption of admin123

Login to the admin panel with password admin123 It works!!!

mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'':

Issue happens when I take a mysqldump after I upgrade Mysql 5.5 to Mysql 5.7

Error:

[root@ip-10-26-91-168 mnt]# mysqldump -u userone -p db1 > db1.sql
Enter password:
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Native table 'performance_schema'.'session_variables' has the wrong structure (1682)
[root@ip-10-26-91-168 mnt]#

Solution:

Login to the server as root

# mysql_upgrade -u root -p --force
# systemctl restart mysqld

This helped to fix my issue :)