tango-db does not install mysql/mariadb database on 24.04

Bug #2060910 reported by Jan Kotanski
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
tango (Ubuntu)
New
Undecided
Unassigned

Bug Description

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.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.