Tango 9 Windows demo installation problem
avatar par défaut
Giedrius
I am the completely new to the Tango Controls.
I am installing Tango 9 on Windows 10, MySQL 8.0.

I do follow the procedure as per https://tango-controls.readthedocs.io/en/latest/installation/tango-on-windows.html

When I try to install TangoTest device server using Astor tool, I get the following error:

"Failed to query TANGO database (error=Field 'date' doesn't have a default value)
.The query was: INSERT INTO property_device_hist SET device='tango/admin/test',id='3',name='StartDsPath',count='1',value='c:\\tango\\bin'"
avatar par défaut
pgoryl
Hi,

This is probably due to MySQL settings: STRICT_TRANS_TABLES SQL mode. I don't know where is my.ini (or my.cnf) for your installation, but you need to find it and remove STRICT_TRANS_TABLES from line starting with 
sql_mode=
You may refer to the following pages:
  • https://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values and
  • https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html

    • Best regards,
    Piotr
    avatar par défaut
    Giedrius
    		Thank you so much. That worked.
    avatar par défaut
    na
    		Hello,
    I try to install tango with the same procedure on windows 7, mysql 5.5 i have many problems like when
    I have defined the environment variables as well as the username and the password but I always have an error (attached) when I run "" start-db.bat"".

    So, I tried this other stuff.
    for 3.5 Start the test device server tangotest: When I type start-tangotest.bat 1 -v4, I have this :
    c:\tango-root\bin>start-tangotest.bat 1 -v4
    Can't build connection to TANGO database server, exiting

    before that for ""create_db.bat"" I encountered an error (attached).
    so I launched directly the script sql and I run it, i don't know if it's right.
    thank you,
    Attachments:
    avatar par défaut
    pgoryl
    		Hi, it looks like you forget to create a database user. Try to follow the text instrution:
    https://tango-controls.readthedocs.io/en/dev/installation/tango-on-windows.html#tango-host-role

    And look at this part:

    Invoke command: %TANGO_ROOT%\bin\dbconfig.exe.

    Note

    This lets you setup two environment variables MYSQL_USER and MYSQL_PASSWORD used to access the MySQL server. You may use root credentials provided upon MySQL installation if it is your development workstation. For production environment it is suggested to create an additional user with DB Admin privileges. On Windows you may use MySQL Installer from Start menu and select the option Reconfigure for MySQL Server. Please refer to: http://dev.mysql.com/doc/refman/5.7/en/adding-users.html

    Good luck!
    Piotr
    Edited 5 years ago
    avatar par défaut
    IvaKu
    		I'm trying to install tango 9.2.2 on Windows7.
    I installed MySQL server 8.0 community.
    When I runing create_db.bat, I get following error:
    ERROR 1071 (42000) at line 257 in file: 'create_db_tables.sql': Specified key was too long; max key length is 1000 bytes
    Edited 5 years ago
    rbourtembourg avatar
    Reynald
    		Hi,

    It looks like a workaround can be to edit %TANGO_ROOT%\share\tango\db\create_db.sql and to replace the following line

    CREATE DATABASE tango;

    with
    CREATE DATABASE tango DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;


    Workaround found on https://stackoverflow.com/questions/20014106/how-to-create-this-table-1071-specified-key-was-too-long-max-key-length-is/42497309

    An older version of MySQL would also probably work smile
    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.
    Edited 5 years ago
    avatar par défaut
    IvaKu
    		So, I installed mysql-5.1.73-winx64 but there was another error
    Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause


    And I edited create_db_tables.sql:
    changed CURRENT_TIMESTAMP on lines 11 and 25
    to '2000-01-01 00:00:00' (as in latest github source).

    It worked.smile
    Edited 5 years ago
    pwickramasinghe avatar
    PrasadW
    		Hi Team,

    I'm not sure whether this is the correct forum to post this, but i have tried Tango contact email address as well.

    We are a sustainable textile manufacturer from the USA and we are looking forward to automate our manufacturing plants and we are on the lookout for an effective MES system. I want to know more about Tango and its capabilities and how it will help us to automate our manufacturing plants.

    Thanks and regards,
    Prasad Wickramasinghe
    gdi_franco avatar
    Hiro
    		Hello PrasadW,

    I do not think that this is the best place to discuss that point but, here we are.

    Tango is quite a good way to get into MES if you already have some equipment like PLC or any kind of automaton, even if it is not designed to be connected to a network. Tango is used in several facilities and laboratories all around the world and for some of them, they are running 24/7. In Thales for example, we are monitoring and sending requests to PLC devices that control vacuum circuits in high power laser systems .

    Several devices already exists (and are available on the community) that let you connect to equipment that use well known protocol.

    I hope that will be helpfull.

    PrasadW
    Hi Team,

    I'm not sure whether this is the correct forum to post this, but i have tried Tango contact email address as well.

    We are a sustainable textile manufacturer from the USA and we are looking forward to automate our manufacturing plants and we are on the lookout for an effective MES system. I want to know more about Tango and its capabilities and how it will help us to automate our manufacturing plants.

    Thanks and regards,
    Prasad Wickramasinghe
    Guillaume DI FRANCO
    Thales - Software Engineer Manager
     
    Register or login to create to post a reply.