Forums

Resolved
0 votes
...... and therefore messed up the System Database which will no longer start ("systemctl status system-mariadb/systemctl restart system-mariadb")?

If you have, can you try editing /usr/lib/systemd/system/syswatch.service and change:
ExecStart=/usr/clearos/sandbox/usr/bin/mysqld_safe --basedir=x/usr
to:
ExecStart=/usr/clearos/sandbox/usr/bin/mysqld_safe --basedir=/usr/clearos/sandbox/usr
Then reload systemd and start system-mariadb:
systemctl daemon-reload
systemctl start system-mariadb
Does this fix it?
Thursday, February 18 2021, 09:23 PM
Share this post:
Responses (4)
  • Accepted Answer

    Wednesday, August 25 2021, 03:27 PM - #Permalink
    Resolved
    0 votes
    I am wondering what is the best way to upgrade MariaDB to corresponding MySql 5.6? Joomla 4 (and many more) requires at least mysql 5.6 and my ClearOS has 5.5.68-MariaDB to which I can't find an update in the standard repos. I don't want to mess up the existing system :-)

    Cheers
    Sven
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 25 2021, 05:40 PM - #Permalink
    Resolved
    0 votes
    There is no update in ClearOS7 or Centos7. If you want anything later you have to go a bit off-grid and you have options. You could remove mariadb and install one the rh-maraidb10? packages. I don't think you even have to remove mariadb, but they won't both run together as they both try to bind to socket 3306. More info on rh-mariadb at https://www.softwarecollections.org/en/scls/rhscl/rh-mariadb103/. Instructions apply to all versions of rh-mariadb10?

    Alternatively, I think MariaDB publish their own repos. Or there are plenty of other instructions on the internet on how to upgrade.

    I believe with what I did earlier this year, messing around with mariadb will not mess up the system-database.
    Like
    1
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, November 02 2021, 12:57 AM - #Permalink
    Resolved
    0 votes
    Has anyone tried this?

    https://www.softwarecollections.org/en/scls/rhscl/rh-mariadb103/

    Does it break anything does it upgrade the existing version will it work with php admin?

    I need some of the functions that 10 brings to the table.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, November 02 2021, 08:21 AM - #Permalink
    Resolved
    0 votes
    The SCL packages should work, but I don't think they will run at the same time as the stock mariadb as they both want to bind to port 3306. Note from their examples they are running from an scl enabled bash shell. You can execute any command outside a bash shell with "scl enable rh-mariadb103 {some_command}" and that command could be a script. I am wondering if the "scl enable rh-mariadb103 " will execute outside the bash shell, form a normal shell. I have a feeling it will work, which is good. I'd test which version you get when running mysql outside an scl enabled shell. For phpmyadmin, I have no idea, but if it just binds to port 3306 it may well be OK, unless it also requires a higher version of PHP to run.

    Note the latest scl rh-mariadb package is rh-mariadb105. As they say, in for a penny, in for a pound!
    The reply is currently minimized Show
Your Reply