5,576
edits
Changes
Jump to navigation
Jump to search
Created page with "{{Warning box| this howto need to tested before to be used in an environment of work....test inside...high risk :) }} ==Upgrade PHP and MYSQL== ===Introduction=== the purpose..."
{{Warning box| this howto need to tested before to be used in an environment of work....test inside...high risk :) }}
==Upgrade PHP and MYSQL==
===Introduction===
the purpose of this howto is to upgrade php/mysql with different comfortable way. You can add here your method, please be aware to detail a maximum how to do that.
===For SME8===
===For SME9===
====From remi repository====
{{WIP box|stephdl}}
Remi collet provides a huge number of rpm for centos and fedora, the purpose is to use his work
* we need to enable [[remi]] and [[epel]] repositories
Past all these repositories in your root terminal
/sbin/e-smith/db yum_repositories set remi repository \
Name 'Remi - EL6' \
BaseURL 'http://rpms.famillecollet.com/enterprise/6/remi/$basearch/' \
EnableGroups no \
GPGCheck yes \
GPGKey http://rpms.famillecollet.com/RPM-GPG-KEY-remi \
Visible yes \
Exclude php-horde-horde \
status disabled
/sbin/e-smith/db yum_repositories set remi-php55 repository \
Name 'Remi-php55 - EL6' \
BaseURL 'http://rpms.famillecollet.com/enterprise/6/php55/$basearch/' \
EnableGroups no \
GPGCheck yes \
GPGKey http://rpms.famillecollet.com/RPM-GPG-KEY-remi \
Visible yes \
Exclude php-horde-horde \
status disabled
/sbin/e-smith/db yum_repositories set epel repository \
Name 'Epel - EL6' \
BaseUrl 'http://download.fedoraproject.org/pub/epel/6/$basearch' \
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch' \
EnableGroups no \
GPGCheck yes \
GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \
Visible no \
status disabled
db yum_repositories set stephdl repository \
BaseURL http://mirror.de-labrusse.fr/smeserver/\$releasever \
EnableGroups no GPGCheck yes \
Name "Mirror de Labrusse" \
GPGKey http://mirror.de-labrusse.fr/RPM-GPG-KEY \
Visible yes status disabled
signal-event yum-modify
* Then we need to upgrade php
yum --enablerepo=remi-php55,remi,epel update php\* mysql-server
* we need to activate innodb
Now with mysql 5.5 innodb is activate by default, and of course not in smeserver
db configuration setprop mysqld InnoDB enabled
expand-template /etc/my.cnf
sv t /service/mysqld
* Running the mysql_upgrade command is mandatory
It checks all tables in all databases for incompatibilities with the current version of MySQL Server. If a table is found to have a possible incompatibility, it is checked. If any problems are found, the table is repaired
mysql_upgrade
* allow_call_time_pass_reference is deprecated
there is a warning in log, concerning [http://php.net/manual/fr/ini.core.php#ini.allow-call-time-pass-reference allow_call_time_pass_reference] which is deprecated in php55.
sed -i s|allow_call_time_pass_reference|//allow_call_time_pass_reference/g /etc/e-smith/templates/etc/php.ini/10LanguageOptions
expand-template /etc/php.ini
/etc/init.d/httpd-e-smith restart
* restart the server
signal-event post-upgrade; signal-event reboot
* check the upgrade
after the reboot verify that the mysqld server is started
service mysqld status
and see which version of php you have
php -v
{{note box|msg=Now each time you will need a dependancies, you will have to use remi,remi-php55 and also probably epel. For example :
yum install --enablerepo=epel,remi,remi-php55,stephdl smeserver-phpMyAdmin_remi}}
[[category:howto]]
==Upgrade PHP and MYSQL==
===Introduction===
the purpose of this howto is to upgrade php/mysql with different comfortable way. You can add here your method, please be aware to detail a maximum how to do that.
===For SME8===
===For SME9===
====From remi repository====
{{WIP box|stephdl}}
Remi collet provides a huge number of rpm for centos and fedora, the purpose is to use his work
* we need to enable [[remi]] and [[epel]] repositories
Past all these repositories in your root terminal
/sbin/e-smith/db yum_repositories set remi repository \
Name 'Remi - EL6' \
BaseURL 'http://rpms.famillecollet.com/enterprise/6/remi/$basearch/' \
EnableGroups no \
GPGCheck yes \
GPGKey http://rpms.famillecollet.com/RPM-GPG-KEY-remi \
Visible yes \
Exclude php-horde-horde \
status disabled
/sbin/e-smith/db yum_repositories set remi-php55 repository \
Name 'Remi-php55 - EL6' \
BaseURL 'http://rpms.famillecollet.com/enterprise/6/php55/$basearch/' \
EnableGroups no \
GPGCheck yes \
GPGKey http://rpms.famillecollet.com/RPM-GPG-KEY-remi \
Visible yes \
Exclude php-horde-horde \
status disabled
/sbin/e-smith/db yum_repositories set epel repository \
Name 'Epel - EL6' \
BaseUrl 'http://download.fedoraproject.org/pub/epel/6/$basearch' \
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch' \
EnableGroups no \
GPGCheck yes \
GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \
Visible no \
status disabled
db yum_repositories set stephdl repository \
BaseURL http://mirror.de-labrusse.fr/smeserver/\$releasever \
EnableGroups no GPGCheck yes \
Name "Mirror de Labrusse" \
GPGKey http://mirror.de-labrusse.fr/RPM-GPG-KEY \
Visible yes status disabled
signal-event yum-modify
* Then we need to upgrade php
yum --enablerepo=remi-php55,remi,epel update php\* mysql-server
* we need to activate innodb
Now with mysql 5.5 innodb is activate by default, and of course not in smeserver
db configuration setprop mysqld InnoDB enabled
expand-template /etc/my.cnf
sv t /service/mysqld
* Running the mysql_upgrade command is mandatory
It checks all tables in all databases for incompatibilities with the current version of MySQL Server. If a table is found to have a possible incompatibility, it is checked. If any problems are found, the table is repaired
mysql_upgrade
* allow_call_time_pass_reference is deprecated
there is a warning in log, concerning [http://php.net/manual/fr/ini.core.php#ini.allow-call-time-pass-reference allow_call_time_pass_reference] which is deprecated in php55.
sed -i s|allow_call_time_pass_reference|//allow_call_time_pass_reference/g /etc/e-smith/templates/etc/php.ini/10LanguageOptions
expand-template /etc/php.ini
/etc/init.d/httpd-e-smith restart
* restart the server
signal-event post-upgrade; signal-event reboot
* check the upgrade
after the reboot verify that the mysqld server is started
service mysqld status
and see which version of php you have
php -v
{{note box|msg=Now each time you will need a dependancies, you will have to use remi,remi-php55 and also probably epel. For example :
yum install --enablerepo=epel,remi,remi-php55,stephdl smeserver-phpMyAdmin_remi}}
[[category:howto]]