Re: [Condor-devel] file tranfer type

[Erik Paulson <epaulson@xxxxxxxxxxx>]

On Tue, Jan 30, 2007 at 11:46:21AM -0600, Zachary Miller wrote:
> > 
> > Well, we had talked about it being used as either an indicator of a 
> > regular file transfer or an X509 delegation.
> 
> i see.  yes, you'll want that.  i wouldn't use a boolean flag since there may
> be more than one protocol for delegation (although there is currently only one)
> but an int should be fine.
> 
> 
> > Well, we wouldn't want to store the actual credential, but instead some
> > sort of fingerprint or credential id. 
> 
> probably, yeah.  i'm not sure how this table is being used, if it's queueing
> active transfers or simply recording historical info.  as i have very little
> knowledge of the quill++ design, i'll butt out now and leave it to the actual
> quill++ developers.  i just wanted to let you know all the extra stuff we had
> to add in condor along the way, in case it is relevant to what you are doing
> with that table.
> 
> 

I added a couple of columns (We had previously added the encryption field)

-- src and dest protocols - ie was it cedar on one end/http on the other
-- src and dest credentials - this is meant to be a foreign key to a future cred
ential table
-- src and dest acl_ids - again, a foreign key for a future ACL table, where 
unix file permissions/owner names/windows acls/some unknown method could live
-- an delegation_methods_id - per Zach: 0 might mean normal, 1 might mean 
   regular GSI authentication, 2 might be some crap through VOMS, etc
-- an intermediary_transfer_id - a foreign key for any proxies that might have 
   been involved. It might be something simple, ie just a proxy, or it could be
more advanced, like a table that points to the path through a diskrouter overlay
 network. 

I also shoved the acl_id into the files table. It may not be enough in the
long run, but since it's not being used right now it doesn't really matter :)

Here's the current transfers table:

CREATE TABLE  transfers (
globaljobid     varchar(4000),
src_name        varchar(4000),
src_host        varchar(4000),
src_port        integer,
src_path        varchar(4000),
src_daemon      varchar(30),
src_protocol    varchar(30),
src_credential_id integer,
src_acl_id        integer, -- we dont know what this is yet, so normalized id
dst_name        varchar(4000),
dst_host        varchar(4000),
dst_port        integer,
dst_path        varchar(4000),
dst_daemon      varchar(30),
dst_protocol    varchar(30),
dst_credential_id integer,
dst_acl_id        integer,
transfer_intermediary_id integer, -- a foreign key for potential proxies
transfer_size_bytes   numeric(38),
elapsed         numeric(38),
checksum        varchar(256),
transfer_time   timestamp(3) with time zone,
last_modified   timestamp(3) with time zone,
is_encrypted    varchar(5),
delegation_method_id integer,
completion_code integer
);