Tactic 4.7.0.a07 on Centos7 installation issues

samaya · 10-09-2019, 08:36 PM

Hi Guys,

um trying to install Tactic 4.7 on centos 7 and im facing some issues with the database so I will appreciate your help.

Code:
Copying files to the install directory... It may take several minutes.

Creating a symlink at [/home/apache/tactic]...

Verifying Python modules are properly installed...

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

Creating TACTIC temp directories:  /home/apache/tactic_temp

Changing directory ownership of temp and data directories

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

Creating database 'sthpw' ...

('create: ', 'createdb -h localhost -U postgres -p 5432 -E UNICODE "sthpw"')

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

could not identify current directory: No such file or directory

Importing sql to database [sthpw]...

   using path [/home/apache/tactic/src/pyasm/search/upgrade/postgresql/bootstrap_schema.sql]

('Error with query (ProgrammingError): ', 'sthpw', 'CREATE TABLE "login" (\n    "id" serial PRIMARY KEY,\n    "code" character varying(512),\n    "login" character varying(100) NOT NULL,\n    "password" character varying(255),\n    "upn" character varying(100) NOT NULL,\n    "login_groups" text,\n    "first_name" character varying(100),\n    "last_name" character varying(100),\n    "display_name" character varying(256),\n    "email" character varying(200),\n    "phone_number" character varying(32),\n    "department" character varying(256),\n    "namespace" character varying(255),\n    "snapshot" text,\n    "s_status" character varying(30),\n    "project_code" text,\n    "license_type" character varying(256),\n    "hourly_wage" float,\n    "data" jsonb,\n    CONSTRAINT "login_code_idx" UNIQUE ("code"),\n    CONSTRAINT "login_upn_idx" UNIQUE ("upn")\n)')

type "jsonb" does not exist

LINE 20:     "data" jsonb,

                    ^

Traceback (most recent call last):

  File "/tmp/TACTIC-4.7-Python3/src/install/install.py", line 893, in <module>

    install.execute(install_db=install_db,install_defaults=install_defaults,database_type=database_type, port_num=port_num )

  File "/tmp/TACTIC-4.7-Python3/src/install/install.py", line 331, in execute

    database.import_schema(project_code, project_type)

  File "/home/apache/tactic/src/pyasm/search/database_impl.py", line 236, in import_schema

    self.import_sql_file(db_resource, schema_path)

  File "/home/apache/tactic/src/pyasm/search/database_impl.py", line 212, in import_sql_file

    sql.do_update(cmd)

  File "/home/apache/tactic/src/pyasm/search/sql.py", line 877, in do_update

    raise SqlException(str(e))

pyasm.search.sql.SqlException: type "jsonb" does not exist

LINE 20:     "data" jsonb,

                    ^

10-09-2019, 10:13 PM

Hi Samaya,

What database are you using? (ie. PostgreSQL, MySQL, etc.)

Thanks,

Celton

samaya · 10-09-2019, 10:37 PM

I'm using (PostgreSQL) 9.2.24

***remkonoteboom*** · 10-10-2019, 03:21 PM

The data type jsonb is only supported on Postgres 9.4 and newer. We are using the jsonb data type more and more and 4.7 is likely depenedent on it.

samaya · (This post was last modified: 10-11-2019, 01:54 PM by samaya.)

(10-10-2019, 03:21 PM)remkonoteboom Wrote: The data type jsonb is only supported on Postgres 9.4 and newer. We are using the jsonb data type more and more and 4.7 is likely depenedent on it.

thanks, upgrading the postgresql to 9.6 solved for the database but now im facing other issue when im trying to execute the service in dev mode, the page just stais in loading and qhen i check my console this is what i see.

Code:
[root@localhost TACTIC-4.7-Python3]# su apache -s /bin/bash -c "python /home/apache/tactic/src/bin/startup_dev.py"

Data Directory [/home/apache/tactic_data]

Asset Directory [/home/apache/assets]

Temp Directory [/home/apache/tactic_temp]

Config path [/home/apache/tactic_data/config/tactic-conf.xml]

Registering project ... admin

Registering project ... default

Initializing Workflow Engine

Starting Scheduler ....

Starting TACTIC v4.7.0.a07 ...

WARNING: Ticket [*********************************] is not valid

('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/web/viewer.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/build/pdf.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/build/pdf.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/web/viewer.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

I though that was a permission issue so I set the permissions on all the files to 777 just to test but no luck

***remkonoteboom*** · 10-11-2019, 07:20 PM

You should get a final line saying:

Starting TACTIC v4.7.0.a11 ...

For some reason, if your run startup.py, it gives more information:

[03/Oct/2019:21:53:14] ENGINE Bus STARTING
[03/Oct/2019:21:53:14] ENGINE Serving on http://127.0.0.1:8081
[03/Oct/2019:21:53:14] ENGINE Bus STARTED

What does it say when you run startup.py. My guess is that TACTIC is not able to secure whatever port you have it set to in your tactic config file ($TACTIC_DATA_DIR/config/tactic-conf.xml) and it is waiting for that port to free up.

samaya · (This post was last modified: 10-15-2019, 03:19 PM by samaya.)

(10-11-2019, 07:20 PM)remkonoteboom Wrote: You should get a final line saying:

Starting TACTIC v4.7.0.a11 ...

For some reason, if your run startup.py, it gives more information:

[03/Oct/2019:21:53:14] ENGINE Bus STARTING
[03/Oct/2019:21:53:14] ENGINE Serving on http://127.0.0.1:8081
[03/Oct/2019:21:53:14] ENGINE Bus STARTED

What does it say when you run startup.py. My guess is that TACTIC is not able to secure whatever port you have it set to in your tactic config file ($TACTIC_DATA_DIR/config/tactic-conf.xml) and it is waiting for that port to free up.

your guess was right, after using fuser to identify the rouge process using the port 8081 and kill it I'm able to start the app,

now im trying to fix some plugins that appear as 404 and broken icons that appear on the page.

Code:
('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/web/viewer.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/build/pdf.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/build/pdf.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

('WARNING: ', AttributeError("'Index' object has no attribute 'plugins'",))

WARNING:

('    status: ', '404 Not Found')

('    message: ', "The path '/tactic/plugins/pdfjs/web/viewer.js' was not found.")

('    site: ', '')

('    project_code: ', 'plugins')

***remkonoteboom*** · 10-15-2019, 03:30 PM

Don't worry about those. We were testing a PDF viewer and it seems this reference was left in the source code. We'll remove those references.

They are harmless and won't affect the operation of TACTIC.

samaya · 10-16-2019, 07:27 PM

(10-15-2019, 03:30 PM)remkonoteboom Wrote: Don't worry about those. We were testing a PDF viewer and it seems this reference was left in the source code. We'll remove those references.

They are harmless and won't affect the operation of TACTIC.

Thanks, now hopefully this is the last error to attack in this installation, every time I go to the admin site => global => system config this pop up appears:

ReferenceError: log is not defined

the strange is that the log path has already been set up on the tactic-config.xml file so my question is, do I need to set this up somewhere else?