installing tb-3 with postgresql

Max Brazhnikov makc at issp.ac.ru
Thu Sep 4 07:03:19 EDT 2008


Hi guys,

I've failed to update my tinderbox, so I started with clean install.
I use tinderbox from ports with postgresql database and follow README step by 
step. At the third step I've got errors when loading schema into database.
Any help is appreciated, I can't live without tinderbox :)

Thanks,
Max

/tank/tinderbox/scripts# ./tc Setup
Welcome to the Tinderbox Setup script.  This script will guide you through
some of the automated Tinderbox setup steps.  Once this script completes ,
you should review the documentation in /tank/tinderbox/scripts/README or on
the web at http://tinderbox.marcuscom.com/ to complete your setup.

Hit <ENTER> to get started:
INFO: Checking prerequisites ...
DONE.

INFO: Creating default configuration files ...
DONE.

INFO: Beginning database configuration.
Enter database driver (mysql pgsql): pgsql
Does this host have access to connect to the Tinderbox database as a database 
administrator? (y/N)y
Enter database admin user [root]: tinder
Enter database host [localhost]:
Enter database name [tinderbox]:
Are these settings corrrect:
    Database Administrative User : tinder
    Database Host                : localhost
    Database Name                : tinderbox
(y/N)y
Do you want to cache tinder's password, and pass it to subsequent database 
command calls (note: this presents a security risk) (y/N) ?N
INFO: Checking for prerequisites for pgsql database driver ...
DONE.

INFO: Checking to see if database tinderbox already exists on localhost ...
The next prompt will be for tinder's password to the tinderbox database.
Password for user tinder:
INFO: Database tinderbox does not exist.  Creating tinderbox on localhost ...
The next prompt will be for tinder's password to the tinderbox database.
Password:
CREATE DATABASE
INFO: Loading Tinderbox schema into tinderbox ...
The next prompt will be for tinder's password to the tinderbox database.
Password for user tinder:
NOTICE:  CREATE TABLE will create implicit sequence "ports_port_id_seq" for 
serial column "ports.port_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ports_pkey" 
for table "ports"
NOTICE:  CREATE TABLE / UNIQUE will create implicit 
index "ports_port_directory_key" for table "ports"
CREATE TABLE
CREATE INDEX
NOTICE:  CREATE TABLE will create implicit sequence "jails_jail_id_seq" for 
serial column "jails.jail_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "jails_pkey" 
for table "jails"
NOTICE:  CREATE TABLE / UNIQUE will create implicit 
index "jails_jail_name_key" for table "jails"
CREATE TABLE
NOTICE:  CREATE TABLE will create implicit 
sequence "ports_trees_ports_tree_id_seq" for serial 
column "ports_trees.ports_tree_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "ports_trees_pkey" for table "ports_trees"
NOTICE:  CREATE TABLE / UNIQUE will create implicit 
index "ports_trees_ports_tree_name_key" for table "ports_trees"
CREATE TABLE
NOTICE:  CREATE TABLE will create implicit sequence "builds_build_id_seq" for 
serial column "builds.build_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "builds_pkey" 
for table "builds"
NOTICE:  CREATE TABLE / UNIQUE will create implicit 
index "builds_build_name_key" for table "builds"
CREATE TABLE
NOTICE:  CREATE TABLE will create implicit sequence "users_user_id_seq" for 
serial column "users.user_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" 
for table "users"
NOTICE:  CREATE TABLE / UNIQUE will create implicit 
index "users_user_name_key" for table "users"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "user_permissions_pkey" for table "user_permissions"
CREATE TABLE
NOTICE:  CREATE TABLE will create implicit 
sequence "build_users_build_user_id_seq" for serial 
column "build_users.build_user_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "build_users_pkey" for table "build_users"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "port_fail_reasons_pkey" for table "port_fail_reasons"
CREATE TABLE
NOTICE:  CREATE TABLE will create implicit 
sequence "build_ports_build_port_id_seq" for serial 
column "build_ports.build_port_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "build_ports_pkey" for table "build_ports"
CREATE TABLE
CREATE INDEX
CREATE INDEX
NOTICE:  CREATE TABLE will create implicit 
sequence "port_dependencies_port_dependency_id_seq" for serial 
column "port_dependencies.port_dependency_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "port_dependencies_pkey" for table "port_dependencies"
ERROR:  relation "build_port" does not exist
ERROR:  relation "port_dependencies" does not exist
ERROR:  relation "port_dependencies" does not exist
ERROR:  syntax error at or near ")"
LINE 4: );
        ^
NOTICE:  CREATE TABLE will create implicit 
sequence "build_ports_queue_build_ports_queue_id_seq" for serial 
column "build_ports_queue.build_ports_queue_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "build_ports_queue_pkey" for table "build_ports_queue"
CREATE TABLE
CREATE INDEX
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "port_fail_patterns_pkey" for table "port_fail_patterns"
CREATE TABLE
CREATE INDEX
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "hooks_pkey" 
for table "hooks"
CREATE TABLE
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
ERROR:  relation "config" does not exist
WARNING:  nonstandard use of escape in a string literal
LINE 6: ...RT INTO hooks VALUES ('prePortsTreeUpdate', NULL, 'Hook to r...
                                                             ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: ...T INTO hooks VALUES ('postPortsTreeUpdate', NULL, 'Hook to r...
                                                             ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: ...NSERT INTO hooks VALUES ('preBuildExtract', NULL, 'Hook to r...
                                                             ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: ...SERT INTO hooks VALUES ('postBuildExtract', NULL, 'Hook to r...
                                                             ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: INSERT INTO hooks VALUES ('preJailUpdate', NULL, 'Hook to ru...
                                                         ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: INSERT INTO hooks VALUES ('postJailUpdate', NULL, 'Hook to r...
                                                          ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: INSERT INTO hooks VALUES ('preJailBuild', NULL, 'Hook to run...
                                                        ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: INSERT INTO hooks VALUES ('postJailBuild', NULL, 'Hook to ru...
                                                         ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: INSERT INTO hooks VALUES ('prePortBuild', NULL, 'Hook to run...
                                                        ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
WARNING:  nonstandard use of escape in a string literal
LINE 1: INSERT INTO hooks VALUES ('postPortBuild', NULL, 'Hook to ru...
                                                         ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(__parent__) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(mtree) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(arch) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(__parent__) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(arch) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(perl) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(configure_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(fetch) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(LIB_DEPENDS) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (900, '\\.(c|cc|cxx|cp...
                                                    ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(__parent__) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (1000, '(X11/.*|Xosdef...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(__parent__) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (1100, 'XFree86-.*\\.t...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(missing_header) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(USE_XLIB) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(missing_header) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (1400, '(parse error|t...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(compiler_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(new_compiler_error) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (1600, '(syntax error ...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(bad_C++_code) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(gcc4_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(linker_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(install_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(depend_object) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(coredump) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(arch) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (2300, 'autoconf([0-9\...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(autoconf) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(autoheader) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(automake) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(checksum) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(chown) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (2800, 'Shared object ...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(compat6x) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(depend_package) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(disk_full) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(DISPLAY) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(distinfo_update) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (3300, 'Member name co...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(fetch) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(fetch_timeout) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(f77) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(gcc_bug) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(install_error) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (3800, '(cc: .*libintl...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(linker_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(makefile) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (4000, 'make.*(cannot ...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(makefile) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(manpage) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(patch) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(perl) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(perl) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(process_failed) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(python) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(runaway_process) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(segfault) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(stdio) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(struct_changes) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(sysvipc) is not present in 
table "port_fail_reasons".
WARNING:  nonstandard use of \\ in a string literal
LINE 1: INSERT INTO port_fail_patterns VALUES (5200, '(/usr/bin/ld: ...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(threads) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(varargs) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(WRKDIR) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(compiler_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(PLIST) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(configure_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(linker_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(NFS) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(install_error) is not present in 
table "port_fail_reasons".
ERROR:  insert or update on table "port_fail_patterns" violates foreign key 
constraint "port_fail_patterns_port_fail_pattern_reason_fkey"
DETAIL:  Key (port_fail_pattern_reason)=(???) is not present in 
table "port_fail_reasons".
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
Enter the desired username for the Tinderbox database : tinder
Are these the settings you want:
    Database username      : tinder
(y/N) y
Make sure tinder owns the database tinderbox as well as all of its tables.
DONE.

INFO: Database configuration complete.

Congratulations!  The scripted portion of Tinderbox has completed 
successfully.
You should now verify the settings in /tank/tinderbox/scripts/tinderbox.ph
are correct for your environment, then run "/tank/tinderbox/scripts/tc init"
to complete the setup.  Be sure to checkout http://tinderbox.marcuscom.com/
for further instructions.


More information about the tinderbox-list mailing list