SQL database problem when installing Tango on linux

I have a problem with installing a fresh linux tango machine with database

I installed mysql-server and mysql client.
When installing tango
sudo apt-get install mysql-server mysql-client
sudo apt-get install tango-db tango-test

there is this error : "specified key was too long…"
I read somewhere this is an error on create-db script.

Olivier TACHÉ SWAXSLab Paris-Saclay
Nanometric Organisation Laboratory (L.I.O.N.S.)
UMR 3685 NIMBE CEA – CNRS / Paris-Saclay University
Building 546 - Room 30
CEA Paris-Saclay – RD306 – 91191 Gif sur Yvette Cedex FRANCE
+33 (0)6 43 36 05 37
Hi Olivier,

Please refer to https://github.com/tango-controls/TangoDatabase/issues/16 to get a work around to solve this issue.
In particular, you can refer to this comment in TangoDatabaseDS README (https://github.com/tango-controls/TangoDatabase/blob/master/README):

Note: It is recommended to setup the database to use latin1 character set.
Especially, any other character set with characters longer than 3 bytes
will not work. Character set can be specified in my.cnf configuration file:


Hoping this helps,
Rosenberg's Law: Software is easy to make, except when you want it to do something new.
Corollary: The only software that's worth making is software that does something new.
after a lot of try with mysql, I didn't succeed. The solution is good but for installing a working mysql database it becomes complicated.
To avoid this I tried to install mariadb as described here https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-ubuntu-20-04

And it works. I reached to install tango-db.
Register or login to create to post a reply.