Topic: Software collections and mysql 5.7

[Jean-Philippe Pialasse]

ran as above

subtility; not mysql57 but rh-mysql57 .... love it when naming convention evolves ! this is one of the worst thing with scl. You start working one way, and they present it differently for the next version

Code: [Select]

scl enable rh-mysql57  bash
also I have checked the rpm does not provides a /etc/profile.d/mysql55.sh but a /etc/profile.d/mysql57.sh

If you have the first you might have installed  also (or only) mysql55.

[jameswilson]

OK
so i have tried

service mysql57-mysqld stop
expand-template /root/.my.cnf
expand-template /var/service/mysql57-mysqld/set.password
/opt/rh/rh-mysql57/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql57.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql57-mysqld/set.password

at this point i get

# /opt/rh/rh-mysql57/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql57.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql57-mysqld/set.password
/opt/rh/rh-mysql57/root/usr/libexec/mysqld: error while loading shared libraries: liblz4.so.rh-mysql57-1: cannot open shared object file: No such file or directory

[ReetP]

Have you tried to find out what directories you have there?

Work your way down (or up) and see what you can see - what is there? What is missing?eg

Code: [Select]

cd /opt/rh/rh-mysql57/root/usr/

Code: [Select]

cd /opt/rh/rh-mysql57/root/

Code: [Select]

cd /opt/rh/rh-mysql57/

Code: [Select]

cd /opt/rh/
or

Code: [Select]

ll /opt/rh/rh-mysql57

Code: [Select]

ll /opt/rh/
or use mc to browse about....

Or say:

Code: [Select]

cd /opt/rh

Code: [Select]

find -iname mysqld
A little bit of thought and looking may give you some answers rather than blindly following what others paste.

(people make typos etc, so always worth having a look around)

[Jean-Philippe Pialasse]

While the exercise is interesting....

Trying to get back to the initial problem ie migrating db from mysql51 to mysql57

Signal-event pre-backup

Install smeserver-mysql57, just the yum step

cp /home/e-smith/db/mysql/*.dump /home/e-smith/db/mysql57

Then finish the install of mysql57 by doing the extra steps on wiki. It will do as you were restoring backups on a fresh sme

[jameswilson]

Have you tried to find out what directories you have there?

Work your way down (or up) and see what you can see - what is there? What is missing?eg

Code: [Select]

cd /opt/rh/rh-mysql57/root/usr/

Code: [Select]

cd /opt/rh/rh-mysql57/root/

Code: [Select]

cd /opt/rh/rh-mysql57/

Code: [Select]

cd /opt/rh/
or

Code: [Select]

ll /opt/rh/rh-mysql57

Code: [Select]

ll /opt/rh/
or use mc to browse about....

Or say:

Code: [Select]

cd /opt/rh

Code: [Select]

find -iname mysqld
A little bit of thought and looking may give you some answers rather than blindly following what others paste.

(people make typos etc, so always worth having a look around)

Thanks I have done that and found a typo but as abive the error relating to file not found etc is called by another

Code: [Select]

liblz4.so.rh-mysql57-1 so i cant edit the command as such

[jameswilson]

While the exercise is interesting....

Trying to get back to the initial problem ie migrating db from mysql51 to mysql57

Signal-event pre-backup

Install smeserver-mysql57, just the yum step

cp /home/e-smith/db/mysql/*.dump /home/e-smith/db/mysql57

Then finish the install of mysql57 by doing the extra steps on wiki. It will do as you were restoring backups on a fresh sme

That looks brilliant but until i fix the root password issue i assume i shoulndt try it?

[Jean-Philippe Pialasse]

That looks brilliant but until i fix the root password issue i assume i shoulndt try it?

the root password issue should fix by itself with the template expanding, and might have occurred by trying to play with it in the first place.

just tested:

https://wiki.contribs.org/Software_Collections:MySQL57

Code: [Select]

yum install --enablerepo=smecontribs smeserver-mysql57
signal-event post-upgrade ;  signal-event reboot
then

https://wiki.contribs.org/Software_Collections:MySQL57#Resetting_the_MySQL_root_password

Code: [Select]


service mysql57-mysqld stop
expand-template /root/.my.cnf
expand-template /var/service/mysql57-mysqld/set.password
scl enable rh-mysql57 bash
/opt/rh/rh-mysql57/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql57.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql57-mysqld/set.password
exit
service mysql57-mysqld start


[jameswilson]

Thats brilliant and worked a treat. Im unsure why it didnt before. But yes all reset and working correctly.