How to Install TACTIC and use MySQL as Database


Instructions for Fedora/Linux
-Applies to TACTIC version 3.9.0.v05+
-MySQL works in 3.9 but it has not been thoroughly tested yet (full support for MSQL will be available in TACTIC 4.0)
1) Check if you have mysql or mysql server installed.
    rpm -q mysql
   Use this command to install mysql and mysql server in fedora
    yum install mysql mysql-server mysql-devel python-devel MySQL-python gcc python-setuptools
    More details here if you need it:
2) Start the MySQL service
    service mysqld start
3) Set up MySQL
    note: for this tutorial we have set the password to: south123paw
    note: if you get the following error, it may be because you have not started the MySQL service (in step #2) yet:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
4) Test logging into MySQL
    mysql -h localhost -u root -p
    eg, -show stuff in database
    show databases;
    use <database_name>;
    show tables;
    describe <database_table_name>;
5) Download TACTIC 3.9 and extract to a temp folder
6) Follow the setup instructions here with one exception:
        for the step, running the following to install TACTIC *without* the database:
    python src/install/ --install_db False
7) Edit the following lines in the TACTIC config file:
8) Run the TACTIC script.
    (It will convert the generic SQL TACTIC database setup script to MySQL specifically)
    cd <TACTIC_INSTALL_DIR>/src/pyasm/search/upgrade/mysql
    And run the boot strap script to create the sthpw database in the MySQL database:
9) Run the upgrade script for the database:
    python <TACTIC_INSTALL_DIR>/src/bin/ -f
10) Start TACTIC
    python <TACTIC_INSTALL_DIR>/src/bin/




Submitted by focusgfx on

Hi, I've downloaded Tacic 3.9 V5 and installed it fine..however when trying to run the file "" after running the "" file
the database gives me an error
1071, 'Specified key was too long; max key length is 767 bytes'
and I know that this error is caused by trying to set the key value length more than 767 which is the maximum that mysql can handle in key length.
this made me think that the current mysql character encoding "utf8" is the problem and the database should be encodd in ansi, so I switched the database character set to "latin" and the script "" worked fine, but when trying to create a new project, the error showed up again!
that means Tactic is trying to set the key length more that 767 again!!
now, why is this happening ? should'nt the database been converted to mysql with the file "" ? or is something is wrong with the conversion ?
please guid me of what I'm doing wrong,
thanks in advance.

vfxpandit's picture
Submitted by vfxpandit on

i am stuck here ..
[root@mango mysql]# python

Importing bootstrap ...
/pipeline/apps/tactic45/tactic/src/pyasm/search/ Warning: Can't create database 'sthpw'; database exists
Error with query (Error):  sthpw --

-- These are the miminum set of tables required for the plugin installer
-- to function.  The tables are:

-- search_object
-- project
-- login
-- trigger
-- schema
-- notification

CREATE TABLE search_object (
    id serial PRIMARY KEY,
    code character varying(256),
    search_type character varying(100) NOT NULL,
    namespace character varying(200) NOT NULL,
    description text,
    "database" character varying(100) NOT NULL,
    table_name character varying(100) NOT NULL,
    class_name character varying(100) NOT NULL,
    title character varying(100),
    "schema" character varying(100),
    color character varying(256),
    "id_column" character varying(256),
    "default_layout" character varying(32),
    CONSTRAINT "search_object_code_idx" UNIQUE (code),
    CONSTRAINT "search_object_search_type_idx" UNIQUE (search_type)
Traceback (most recent call last):
  File "", line 111, in <module>
  File "", line 68, in import_bootstrap
  File "/pipeline/apps/tactic45/tactic/src/pyasm/search/", line 828, in do_update
    raise SqlException(e.__str__()) (1071, 'Specified key was too long; max key length is 767 bytes')

Rajiv Sharma
FX Pipeline Developer