tactic安装的时候出现的问题，注意
pydev debugger: starting
********************
Tactic Installation
********************
Verifying the database is installed. The default is no password if you have followed the instructions to not require a password. If you see it asking for 'Password for user postgres', you should close this window and make the database not require a password first (refer to our install documentation) and resume the installation.
Database type is: PostgresSQL
(if this is not the database type desired,
hit Ctrl+C to cancel and see the types available with 'python install.py -h' )
Please enter the base path of the Tactic installation:
(C:/Program Files/Southpaw) ->
Custom install directory [C:/Program Files/Southpaw/tactic] already exists. It will be removed and copied over. Continue? (y/n) -> y
Copying files to the install directory... It may take several minutes.
Verifying Python modules are properly installed...
Creating TACTIC temp directories: C:/ProgramData/Southpaw/tactic_temp
Installing win32 service.
Installing service TacticService
Changing service configuration
Service updated
Creating database 'sthpw' ...
no output, assumed success
Importing schema ...
psql -q -h localhost -U postgres -p 5432 sthpw < "C:/Program Files/Southpaw/tactic/src/pyasm/search/upgrade/schema/config_schema.sql"
Importing schema ...
psql -q -h localhost -U postgres -p 5432 sthpw < "C:/Program Files/Southpaw/tactic/src/pyasm/search/upgrade/schema/sthpw_schema.sql"
ERROR: language "plpgsql" already exists
ERROR: relation "prod_setting" already exists
ERROR: relation "prod_setting_id_seq" already exists
ERROR: relation "widget_config" already exists
ERROR: relation "widget_config_id_seq" already exists
ERROR: multiple primary keys for table "widget_config" are not allowed
ERROR: relation "widget_config_code_idx" already exists
ERROR: relation "snapshot_type_code_unique" already exists
ERROR: there is no unique constraint matching given keys for referenced table "trigger"
Importing data ...
psql -q -h localhost -U postgres -p 5432 sthpw < "C:/Program Files/Southpaw/tactic/src/pyasm/search/upgrade/schema/sthpw_data.sql"
setval
--------
128
(1 行记录)
setval
--------
10
(1 行记录)
setval
--------
42
(1 行记录)
setval
--------
5
(1 行记录)
setval
--------
12
(1 行记录)
setval
--------
14
(1 行记录)
setval
--------
2
(1 行记录)
Upgrading the database schema in quiet mode...
C:/Program Files/Southpaw/tactic/src\pyasm\search\upgrade\upgrade_db.py:34: SyntaxWarning: import * only allowed at module level
def execute(my):
C:/Program Files/Southpaw/tactic/src\pyasm\search\upgrade\upgrade_db.py:34: SyntaxWarning: import * only allowed at module level
def execute(my):
C:/Program Files/Southpaw/tactic/src\pyasm\search\upgrade\upgrade_db.py:34: SyntaxWarning: import * only allowed at module level
def execute(my):
C:/Program Files/Southpaw/tactic/src\pyasm\search\upgrade\upgrade_db.py:34: SyntaxWarning: import * only allowed at module level
def execute(my):
WARNING: Cannot find license file [C:/ProgramData/Southpaw/Tactic/config/tactic-license.xml]
Error with query (ProgrammingError): sthpw
ALTER TABLE pipeline DROP CONSTRAINT project_code_foreign;
constraint "project_code_foreign" of relation "pipeline" does not exist
Error: constraint "project_code_foreign" of relation "pipeline" does not exist
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(config/url) already exists.
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(config/prod_setting) already exists.
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(config/client_trigger) already exists.
Error: duplicate key value violates unique constraint "pref_list_key_idx"
DETAIL: Key (key)=(quick_text) already exists.
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(config/plugin) already exists.
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(config/trigger) already exists.
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(config/process) already exists.
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(sthpw/work_hour) already exists.
Error with query (ProgrammingError): sthpw
ALTER TABLE "wdg_settings" DROP constraint "wdg_settings_login_fkey";
constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist
Error: constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist
Error with query (ProgrammingError): sthpw
ALTER TABLE "wdg_settings" DROP constraint "wdg_settings_project_code_fkey";
constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist
Error: constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist
Error with query (ProgrammingError): sthpw
ALTER TABLE wdg_settings drop constraint wdg_settings_login_fkey CASCADE;
constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist
Error: constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist
Error with query (ProgrammingError): sthpw
ALTER TABLE wdg_settings drop constraint wdg_settings_project_code_fkey CASCADE;
constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist
Error: constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist
Error with query (ProgrammingError): sthpw
ALTER TABLE pref_setting drop constraint pref_setting_login_fkey CASCADE;
constraint "pref_setting_login_fkey" of relation "pref_setting" does not exist
Error: constraint "pref_setting_login_fkey" of relation "pref_setting" does not exist
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(sthpw/search_type) already exists.
Error with query (ProgrammingError): sthpw
alter table task drop constraint "pipeline_code_foreign";
constraint "pipeline_code_foreign" of relation "task" does not exist
Error: constraint "pipeline_code_foreign" of relation "task" does not exist
Error: duplicate key value violates unique constraint "search_object_idx"
DETAIL: Key (search_type)=(prod/session_contents) already exists.
Please refer to the upgrade_output.txt file for any upgrade messages.
*** Installation of TACTIC completed at [C:/Program Files/Southpaw] ***
Next, please install the Apache Web Server and then copy the Apache config extension [C:/ProgramData/Southpaw/Tactic/config/tactic_win32.conf] to the Apache web server config area. e.g. C:/Program Files/Apache Software Foundation/Apache2.2/conf/
Depending on the OS, you may need to add the following line to the main config file [httpd.conf] shipped with Apache as well:
Include conf/tactic_win32.conf
