Public bug reported: The current tango-db 9.5.0 works only with mariadb i.e. it does not work with original mysql
https://gitlab.com/tango-controls/TangoDatabase/-/issues/70 Contrary to debian (with default mariadb https://packages.debian.org/bookworm/default-mysql-server) ubuntu 24.04 install mysql-server (https://packages.ubuntu.com/noble/default-mysql-server). Therefore, ubuntu tango-db package (taken originally from debian) does not work fully on ubuntu. If I try default installation with mysql I get an error: ``` populating database via sql... error encountered populating database: mysql said: ERROR 1064 (42000) at line 255 in file: '/usr/share/tango-db/create_db_tables.sql': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_DATE, object varchar(255) NOT NULL default '', name varchar(255) NOT' at line 3 dbconfig-common: tango-db configure: noninteractive fail. dbconfig-common: tango-db configure: ignoring errors from here forwards done. ``` One can install the tango-db on ubuntu with mariadb but then the tango-db package does not create `tango` databases, i.e. one needs to create the database manually e.g. https://github.com/nexdatas/nxsconfigserver/blob/8d84e4bfcb0e6e476a83ff09c7f80821da245204/.ci/install.sh#L19 It would be nice the ubuntu 24.04 tango-db package would create `tango` DB by default as it was possible in previous releases. ** Affects: tango (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2060910 Title: tango-db does not install mysql/mariadb database on 24.04 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/tango/+bug/2060910/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs