SQL database problem when installing Tango on linux

General Installation
1

Hi,
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.

Thanks
Olivier

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

2

Hi Olivier,

Please refer to MySQL 8 - ERROR 1071 (42000) in file: 'create_db_tables.sql': Specified key was too long; max key length is 1000 bytes · Issue #16 · tango-controls/TangoDatabase · GitHub to get a work around to solve this issue.
In particular, you can refer to this comment in TangoDatabaseDS README (TangoDatabase/README at main · tango-controls/TangoDatabase · GitHub):

[quote]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:

[mysqld]
character_set_server=latin1
collation_server=latin1_swedish_ci[/quote]

Hoping this helps,
Reynald

3

Thanks,
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 How To Install MariaDB on Ubuntu 20.04 | DigitalOcean

And it works. I reached to install tango-db.
Olivier