Syntax error when setting up DB via tc Setup

[Joe Marcus Clarke]

On 10/11/11 11:09 AM, Sevan / Venture37 wrote:
> Hiya,
> On a fresh install of FreeBSD 9.0 Beta 3 with Postgresql 9.0, I'm seeing
> an error during the db setup stage of running tc Setup from Tinderbox
> 3.4.r1

Thanks.  This should be fixed in CVS.

Joe

> 
> Sevan
> 
> 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"
> CREATE TABLE
> CREATE INDEX
> CREATE INDEX
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "config_pkey" for table "config"
> CREATE TABLE
> 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
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "logfile_patterns_pkey" for table "logfile_patterns"
> CREATE TABLE
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "build_groups_pkey" for table "build_groups"
> CREATE TABLE
> 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
> invalid command \nIf
> invalid command \nThe
> invalid command \'.*
> invalid command \'/',
> invalid command \'/',
> invalid command \'|warning:
> invalid command \'.*
> invalid command \'
> invalid command \'
> invalid command \'
> invalid command \'
> invalid command \'|warning:
> invalid command \'
> invalid command \'
> ERROR:  syntax error at or near "s"
> LINE 1: ...ksum', NULL, 'Hook to run before checking a port\'s distfile...
>                                                              ^
> Make sure tinderbox 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
> /usr/local/tinderbox/scripts/tinderbox.ph
> are correct for your environment, then run "/usr/local/tinderbox/scripts/tc
> init" to complete the setup.  Be sure to checkout
> http://tinderbox.marcuscom.com/ for further instructions.
> _______________________________________________
> tinderbox-list at marcuscom.com mailing list
> http://marcuscom.com/mailman/listinfo/tinderbox-list
> To unsubscribe, send any mail to "tinderbox-list-unsubscribe at marcuscom.com"
> 


-- 
PGP Key : http://www.marcuscom.com/pgp.asc