SQL database problem when installing Tango on linux

# 3 years ago
otache	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

# 3 years ago

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

# 3 years ago
Reynald	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: [mysqld] character_set_server=latin1 collation_server=latin1_swedish_ci Hoping this helps, Reynald 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.

# 3 years ago

Reynald

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:

[mysqld]
character_set_server=latin1
collation_server=latin1_swedish_ci

Hoping this helps,
Reynald

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.

# 3 years ago
otache	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 https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-ubuntu-20-04 And it works. I reached to install tango-db. Olivier