...... 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:
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/usrExecStart=/usr/clearos/sandbox/usr/bin/mysqld_safe --basedir=/usr/clearos/sandbox/usrsystemctl daemon-reload
systemctl start system-mariadb
In MySQL Server
Share this post:
Responses (4)
-
Accepted Answer
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! -
Accepted Answer
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. -
Accepted Answer
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. -
Accepted Answer
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »