Win10 installation error - Jive, connection to database failed
avatar par défaut
kyakovlev
Hello, everyone!

I bumped into a problem trying to install Tango on my PC. I was following this guide (text document, not Youtube video) step by step and after setting up "Tango Host" role, launching Jive shows the following error (see attached pics). I don't understand what I'm doing wrong. Could anyone help, please?

When I launched "create_db.bat" script I also got a bunch of CLI errors which I solved one by one, fixing a bit "create_db.sql", "create_db_tables.sql" and "stored_proc.sql" files, namely:
  • "Specified key was too long" - Removed "ENGINE=MyISAM" lines making tables' engine to be InnoDB (by default)
  • "Incorrect datetime value: '0' " - set datetime to be "1970-01-03 00:00:00.000000" instead of "0" and "NULL"
However, I believe the changes mentioned above aren't responsible for the error with Jive.

Also, when I call "%TANGO_ROOT%\bin\start-db.bat" in the console it writes "main(): arrived", and 5 seconds later it lets me enter console commands again (I'm not sure if this is how it's supposed to work, or not).

My OC is Windows 10 corporate LTSC (x64).

I used
  • JRE Version 8 Update 451
  • MySQL 9.3.0 x64
  • Tango 9.2.2 x64
  • nssm 2.24
Attachments:
gdi_franco avatar
Hiro
Hello,

The error in Jive is typical of a non-running tango database.
The result of the "start-db.bat" shall be an opened and hanging terminal showing the following message:

main(): arrived
main(): export DataBase as named servant (name=database)
Ready to accept request


What you say seems to indicate that the tango device DatabaseDs is not running, perhaps due to an issue with its connection to the MySQL database.
Assuming that you are running everything on the same computer, I would suggest to :
  • Ensure that your environnement variables MYSQL_PASSWORD and MYSQL_USER are defined with the right values you setup while installing MySQL (if you do not w
  • Ensure that your environnement variable TANGO_HOST is set to the right value (COMPUTER_IP:20000 or COMPUTER_HOSTNAME:20000 depending on your network configuration)
  • Check that your firewall is not preventing the DatabaseDs.exe to access the network
  • Check your MySQL database, looking for a Database called "tango" and its content (several tables)

I would suggest to Drop tango database & Re-do the create-db procedure + start-db
Guillaume DI FRANCO
Thales - Software Engineer Manager
akessler avatar
AlexK
Hello Konstantin,

I was in the same situation a few years ago and also did not manage to install Tango under Windows according to the instructions.

What worked smooth for me was the installation using Conda packages. As far as I know, the lowest version available is 9.3.5. If you are not pinned to Tango 9.2.2, maybe this approach is an alternative for you.

I use mamba as a manager. After creating an enviroment and:

mamba install cpptango jive tango-database

I could start Tango-DB and jive from my enviroment.

But there were various other stumbling blocks, such as:
https://www.tango-controls.org/community/forum/c/platforms/windows/long-response-time-in-windows-when-accessing-databank-ds/

In the end, I set up a small Ubuntu VM for Tango Host.

Best wishes,
Alex
rbourtembourg avatar
Reynald
Hi,

We are currently in the process of preparing a new version of the documentation.
You can already get an updated version here: https://tango-controls.readthedocs.io/en/doc-restructure-template/How-To/installation/tango-on-windows.html

This documentation should guide you to install more recent versions of Tango and its main components like the Database DS.
The errors you encountered with the Database should be fixed in the latest versions of the Database DS.

Using the conda packages as suggested above can be an alternative.

As noticed by Guillaume, when looking at the errors you got when starting jive, it looks like your Database DS is not running as expected on localhost:10000, so I would look at the environment as he suggested. Please note that you can use the port you like when starting the Database DS (not necessarily 20000 as he was suggesting. it looks like the doc you were following was using 10000). The port used when starting the TangoDatabase DS (-ORBEndPoint option when starting the database server), should be the one used in your TANGO_HOST environment variable.

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.
avatar par défaut
kyakovlev
Hello, everyone, again.
I'm writing to let you know that I finally managed to make my Tango work.

I'm afraid none of Hiro's advice helped solving my problem, though I haven't tried yet the suggestion proposed by AlexK with Conda, mamba and/or Virtual Machine. What helped me though was changing MySQL (mentioned in the older installation instruction) to MariaDB (mentioned in the newer documentation). I didn't even have to change three .sql files this time. Everything went smoothly and seems to be working fine now.

Thanks everyone for your help!

In case someone might need it, this time I used:
  • Tango 10.0.2_v143 (x64)
  • MariaDB 11.7.2 (x64)
Edited 12 hours ago
 
Register or login to create to post a reply.