Automating/Queuing Port Builds documentation

[Robert Gogolok]

Hi,
I'm using tinderbox 2.3.4.

The section about 'automating/queuing port builds' suggests to run 'addHost' 
and afterwards the 'addBuildPortsQueueEntry' command.

When running the following addBuildPortsQueueEntry' command:
./tc addBuildPortsQueueEntry -b 6.1-FreeBSD -d www/lighttpd
I get no error on the console but the PostgreSQL log shows an error:

LOG:  connection received: host=::1 port=60051
LOG:  connection authorized: user=gogo database=tinderbox
LOG:  duration: 2.678 ms
LOG:  duration: 0.090 ms
LOG:  execute dbdpg_1: SELECT * FROM hosts WHERE (Host_Name=$1)
DETAIL:  parameters: $1 = 'desktop.gogolok.de'
LOG:  duration: 0.110 ms
LOG:  statement: DEALLOCATE dbdpg_1
LOG:  duration: 0.088 ms
LOG:  duration: 1.760 ms
LOG:  duration: 0.071 ms
LOG:  execute dbdpg_2: SELECT * FROM builds WHERE (Build_Name=$1)
DETAIL:  parameters: $1 = '6.1-FreeBSD'
LOG:  duration: 0.160 ms
LOG:  statement: DEALLOCATE dbdpg_2
LOG:  duration: 0.106 ms
LOG:  duration: 0.815 ms
LOG:  duration: 0.061 ms
LOG:  execute dbdpg_3: SELECT * FROM builds WHERE (Build_Name=$1)
DETAIL:  parameters: $1 = '6.1-FreeBSD'
LOG:  duration: 0.079 ms
LOG:  statement: DEALLOCATE dbdpg_3
LOG:  duration: 0.097 ms
LOG:  duration: 0.334 ms
LOG:  duration: 0.047 ms
LOG:  execute dbdpg_4: SELECT * FROM hosts WHERE (Host_Name=$1)
DETAIL:  parameters: $1 = 'desktop.gogolok.de'
LOG:  duration: 0.070 ms
LOG:  statement: DEALLOCATE dbdpg_4
LOG:  duration: 0.108 ms
LOG:  duration: 1.871 ms
LOG:  duration: 0.122 ms
LOG:  execute dbdpg_5: SELECT users.* FROM users,user_permissions WHERE 
users.User_Id=user_permissions.User_Id AND 
user_permissions.User_Permission_Object_Type='users' AND 
user_permissions.User_Permission_Object_Id=users.User_Id AND 
user_permissions.User_Permission=$1
DETAIL:  parameters: $1 = '1'
LOG:  duration: 0.052 ms
LOG:  statement: DEALLOCATE dbdpg_5
LOG:  duration: 0.061 ms
LOG:  duration: 0.348 ms
LOG:  duration: 0.158 ms
LOG:  execute dbdpg_6: INSERT INTO build_ports_queue
                            ( Build_Id, User_Id, Port_Directory, Priority, 
Host_Id, Email_On_Completion )
                         VALUES
                             ( $1, $2, $3, $4, $5, '0' )
DETAIL:  parameters: $1 = '1', $2 = '0', $3 = 'www/lighttpd', $4 = '10', $5 
= '1'
ERROR:  insert or update on table "build_ports_queue" violates foreign key 
constraint "build_ports_queue_user_id_fkey"
DETAIL:  Key (user_id)=(0) is not present in table "users".
STATEMENT:  INSERT INTO build_ports_queue
                            ( Build_Id, User_Id, Port_Directory, Priority, 
Host_Id, Email_On_Completion )
                         VALUES
                             ( $1, $2, $3, $4, $5, '0' )
LOG:  statement: DEALLOCATE dbdpg_6
LOG:  duration: 0.108 ms
LOG:  disconnection: session time: 0:00:00.032 user=gogo database=tinderbox 
host=::1 port=60051

The INSERT command fails to add the port to the queue because there is no user 
associated with user id 0 (foreign key constraint is violated)/no user in the 
database when following the documentation? 

Robert