Univention Bugzilla – Bug 45876
MySQL / MariaDB in UCS 4.3
Last modified: 2018-03-14 14:37:55 CET
Debian stretch does not ship with mysql. Instead, mariadb is used. This bug is used to implement the transition to mariadb.
UCS uses a similar approach as debian. The univention-mysql package will be reduced to depend on the new package univention-mariadb, which handles the specific UCS handling of the service. By keeping u-mysql, the amount of code and dependency changes is kept to a minimum, e.g. for the app center. [4.3-0 b64bbd7] Bug #45876: Add univention-mariadb 1.0.0-1A~4.3.0.201712151436 * Adapts the mysql.secret creation, which was previously a patch in the mysql-server source package * Provides UCR interface to configure server settings Currently, some settings are still using the name mysql. The rationale is that in debian the mariadb-server is still referenced as mysql in many ways, so we keep using the name, too. E.g. the binary is still called mysqld, config files are in /etc/mysql, ...
5c402b75 Adapt univention-mysql, only depend on univention-mariadb univention-mysql 5.0.1-1A~4.3.0.201712151608
package is currently unmaintained, waiting for the next dvd build to move it to maintained. QA Notes: * Upgrade from 4.2 with installed u-mysql should work and install u-mariadb in the process. Mysql login after the update should work * new installation of u-mysql in 4.3 should work and install u-mariadb. A mysql.secret should be created, no passwordless login to mysql should be possible as root.
(In reply to Erik Damrose from comment #3) > package is currently unmaintained, waiting for the next dvd build to move it > to maintained. After a dvd build yesterday the packages are now maintained
Please add a changelog entry
ddd448d2 changelog
univention-app install wordpress does not really work. The mysql/mariadb integration works: * univention-mysql -> univention-mariadb is installed * database "wordpress" is created * user "wordpress" is created But the App quits: MySQL Connection Error: (2002) Connection refused Warning: mysqli::mysqli(): (HY000/2002): Connection refused in - on line 22 The reason is (presumably, I did not check further) that mariadb uses sockets for communication. The App Center needs TCP connections for all users. Currently, this works: mysql -p$(cat /etc/mysql.secret) --port 1
I thought i had checked that the configfile configured by our UCR template is read, but apparently not... mariadb configfiles have to end with the suffix .cnf Now mysqld listens on 0.0.0.0:3306 (previously on 127.0.0.1), wordpress installation works c9551881 Modify configfile to correct filename suffix '.cnf' univention-mariadb 1.0.1-1A~4.3.0.201801161042
f5480e1 Bug #45876 doc: spelling +MariaDB
The description for the "mariadb/autostart" ucr key still has Mysql in it.
Additionally, we have to make the UCRv work again. We had a patch against mysql-5.5 which enforced the autostart setting
(In reply to Erik Damrose from comment #11) > Additionally, we have to make the UCRv work again. We had a patch against > mysql-5.5 which enforced the autostart setting I just tested that and it already works :)
Fixed in c6dbe561 Package: univention-mariadb Version: 1.0.1-2A~4.3.0.201802071615
(In reply to Erik Damrose from comment #13) > Fixed in c6dbe561 > Package: univention-mariadb > Version: 1.0.1-2A~4.3.0.201802071615 What I tested: Install univention-mariadb on 4.3 -> OK Install univention-mysql on 4.2 with multiple apps -> upgrade to 4.3 -> OK mariadb/autostart=no -> service is masked -> no autostart -> OK changelog -> separate bug 45915 Ok -> Verified
UCS 4.3 has been released: https://docs.software-univention.de/release-notes-4.3-0-en.html https://docs.software-univention.de/release-notes-4.3-0-de.html If this error occurs again, please use "Clone This Bug".