Forums

Sampe
Sampe
Offline
Resolved
0 votes
Hi :)

I wonder if anyone here knows a good way to upgrade mysql server to v5.5 in ClearOS 6.5?

ClearOS repo doesn't seem to have any newer version of the MySQL server than 5.1.

I need 5.5 for phpmyadmin 4.2.5 and for more stuff.

Thanks :)
Monday, June 30 2014, 10:14 PM
Share this post:
Responses (3)
  • Accepted Answer

    Bernd
    Bernd
    Offline
    Saturday, June 20 2015, 12:26 PM - #Permalink
    Resolved
    0 votes
    Resource Report seems to stop working and phpmyadmin does not work from the mysql menu in ClearOS web interface. You need to update system-mysql and some more stuff to make ClearOS web interface work properly.


    Where do I start doing it?
    The reply is currently minimized Show
  • Accepted Answer

    Bernd
    Bernd
    Offline
    Monday, May 18 2015, 10:46 AM - #Permalink
    Resolved
    0 votes
    Thank you for sharing!

    I would like to install Drupal8 on Clearos6.6. The specs say that I need mysql server >= 5.5.3
    Is the REMI repo the way to do that?

    I have php5.4 from the timb repo installed for quite a while and it works good for me. Is it recommended to use the remi repo for this too?

    Are there some more recommendations on the forum?

    Bernd
    The reply is currently minimized Show
  • Accepted Answer

    Sampe
    Sampe
    Offline
    Thursday, July 17 2014, 01:25 PM - #Permalink
    Resolved
    0 votes
    I find a way that works, but it is from a repository that is for Fedora OS, so you lose the ClearOS versions of mysql-server. Though it works good anyways but i dont recommend to use this on a clearos server. ClearOS web interface is going to have some problems. Resource Report seems to stop working and phpmyadmin does not work from the mysql menu in ClearOS web interface. You need to update system-mysql and some more stuff to make ClearOS web interface work properly.

    You can upgrade mysql server to 5.5.38 and php to 5.4.30
    This should work for both 32 and 64 bit systems.
    I have only tested on 64 bit of ClearOS 6.5 and Clearos 6.5 professional, and it worked.

    Before doing the upgrade, it is best if you make backups of all configure files that can be changed, also under "/usr/clearos/sandbox/etc" or just make a buckup of the entire system.

    I found this on this link:
    http://www.tecmint.com/install-mysql-on-rhel-centos-6-5-fedora-17-12/

    Fist you have to add Remi Repository
    ## Install Remi Repository on RHEL/CentOS 6.8-6.0 ##
    rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
    rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm


    You can see the differences of clearos mysql and the one that is on remi repository by typing:

    yum --enablerepo=remi list mysql mysql-server


    Run this to upgrade mysql-server:
    yum --enablerepo=remi install mysql mysql-server


    Updating:
    mysql x86_64 5.5.38-1.el6.remi remi 5.8 M
    mysql-server x86_64 5.5.38-1.el6.remi remi 10 M
    Installing for dependencies:
    libaio x86_64 0.3.107-10.el6 clearos-core 20 k
    Updating for dependencies:
    mysql-libs x86_64 5.5.38-1.el6.remi remi 776 k


    and restart mysql-server
    service mysqld restart


    Run this to upgrade php5:
    yum --enablerepo=remi install php php-mysql


    Updating:
    php-mysql x86_64 5.4.30-1.el6.remi remi 137 k
    php x86_64 5.4.30-1.el6.remi remi 2.7 M
    php-cli x86_64 5.4.30-1.el6.remi remi 2.6 M
    php-common x86_64 5.4.30-1.el6.remi remi 932 k
    php-gd x86_64 5.4.30-1.el6.remi remi 144 k
    php-imap x86_64 5.4.30-1.el6.remi remi 80 k
    php-mbstring x86_64 5.4.30-1.el6.remi remi 945 k
    php-mcrypt x86_64 5.4.30-1.el6.remi remi 51 k
    php-pdo x86_64 5.4.30-1.el6.remi remi 121 k
    php-xml x86_64 5.4.30-1.el6.remi remi 172 k


    And restart apache
    service httpd restart


    if you want to downgrade you can use
    yum downgrade


    I hope it will work for you too :cheer:

    PS. Run this on your own risk.
    Like
    1
    The reply is currently minimized Show
Your Reply