Difference between revisions of "Mariadb105"
Unnilennium (talk | contribs) |
Unnilennium (talk | contribs) (→Usage) |
||
| Line 90: | Line 90: | ||
define( 'DB_HOST', '127.0.0.1:/var/lib/mysql/mariadb105.sock' ); | define( 'DB_HOST', '127.0.0.1:/var/lib/mysql/mariadb105.sock' ); | ||
| + | |||
| + | some other php app migh need something like | ||
| + | localhost;unix_socket=/var/lib/mysql/mariadb105.sock | ||
=== Uninstall === | === Uninstall === | ||
Revision as of 00:11, 13 March 2022
 | |
| mariadb105 logo | |
| Maintainer | unnilennium |
|---|---|
| Url | https://mariadb.com |
| Category | |
| Tags | mariadb, mysql, db, database |
Maintainer
Version
Description
Koozali SME Server configuration package for mariadb105 RH SCLo This RPM will allow you to have 2 or more (if also using another contrib for another sclo version) versions of MySQL running side by side. You will have to select the one to use in the setup of the specific application - please see "usage" below. Please note that applications and contribs like phpmyadmin etc. will as standard use the original Mysql DBM for your OS unless you change the database connection.
Most of configuration options are explained for mysql/mariadb here : MySQL are also available for mariadb105 ( except innoDB options). Only difference is to prefix mariadb and mysql.init db entry by "mariadb105-". ie: mariadb105-mariadb and mariadb105-mysql.init
Note that on SME all mariadb service will share the same /etc/my.cnf configuration file. Generik part are read by all servers (eg: [mysqld] or [mariadb]), while specific version will only be read by the same version server (eg: [mariadb-10.1] for mariadb101). Also multiple for occurrence of one option where a server is able to read , the last one is used.
Note that default behaviour will be socket only, and if you enable networking, it will listen on default port on localhost. You then will need to open port to access remotely on LAN (private) or on web (public). Be careful that you need to manually configure yourself TLS encryption for mariadb before doing this kind of access as this is not part of base configuraiton and will leave your mysql traffic visible non encrypted.
Also if you want another port you need to define port to whatever you want. Also remember that default 3306 mysql port is reserved to original mariadb server
Installation
yum install smeserver-extrarepositories-centos-sclo yum --enablerepo=smecontribs install smeserver-mariadb105
Configuration
you can list the available configuration with the following command :
config show mariadb105-mariadb config show mariadb105-mysql.init
Some of the properties are not shown, but are defaulted in a template or a script. Here a more comprehensive list with default and expected values :
| property | default | values | |
|---|---|---|---|
| DbName | nextcloud | string | for mysql db |
| DbPassword | GENERATED | string | for mysql db |
| DbUser | nextcloud | string | for mysql db |
| access | private | private, public | |
| status | enabled | enabled,disabled |
Usage
For Wordpress adjust the DB_HOST value in the wp-config.php file accordingly.
define( 'DB_HOST', 'localhost:/var/lib/mysql/mariadb105.sock' );
or
define( 'DB_HOST', '127.0.0.1:/var/lib/mysql/mariadb105.sock' );
some other php app migh need something like
localhost;unix_socket=/var/lib/mysql/mariadb105.sock
Uninstall
yum remove smeserver-mariadb105 mariadb105
Bugs
Please raise bugs under the SME-Contribs section in bugzilla
and select the smeserver-mariadb105 component or use this link
Below is an overview of the current issues for this contrib:
Changelog
Only released version in smecontrib are listed here.
2023/11/23 Jean-Philippe Pialasse 2.7.0-18.sme
- fix OpenFilesLimit too low preventing backup [SME: 12417]
- fix mariadb overriding skip-networking for other versions [SME: 12262]
- use dedicated log file for *mysql.init [SME: 11953]
- Fix init for MariaDB 104+ [SME: 11991]
- /usr/libexec/mysql-wait-stop not used after mariadb101 [SME: 11936]
