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
DRF / IRAMIS / NIMBE
Building 546 - Room 30
CEA Paris-Saclay – RD306 – 91191 Gif sur Yvette Cedex FRANCE
+33 (0)6 43 36 05 37
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.
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.