cmd=[]
qstr=[tdf=%22conf/didyouknow.txt%22]
qtok=[tdf=%22conf/didyouknow.txt%22]
fixqtok=[tdf="conf/didyouknow.txt"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
command line params:
current dir - pwd:
/u/catcom/wb/ex4_tst/comdat/common

current user - id:
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

standard input stream: stdinput=[]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
procsql()
procsql() sqloutf=[/tmp/sqlout6082_1] sqlerrf=[/tmp/sqlerr6082_1] sqlprocf=[/tmp/sqlproc6082_1]
sqlid=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:]
sqltype=[SELECT]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc6082_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6082_1
rm -f /tmp/sqlerr6082_1
rm -f /tmp/sqlproc6082_1
---------------------------------
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[conf/didyouknow.txt] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/conf/didyouknow.txt] -rw-rw-rw- 1 daemon daemon 49 Nov 3 15:41 topdat/conf/didyouknow.txt Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[conf] # dfp_part2=[didyouknow.txt] # dfp_part3=[] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all allowaccess="1" ] dowbttopcsv=[n/a] outfile=[topdat/conf/didyouknow.txt] allowaccess=[1] get: topdat/conf/didyouknow.txt qstr=[tdf=doc/disclaimer.html]
qtok=[tdf=doc/disclaimer.html]
fixqtok=[tdf="doc/disclaimer.html"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
cmd=[]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
cmd=[]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_WB_loginoff="0"]
qstr=[tdf=%22Sep_2011/data/wbttop.csv%22]
cookietok=[WB_extgrid=;]
qstr=[tdf=%22Aug_2011/data/wbttop.csv%22]
qtok=[tdf=%22Aug_2011/data/wbttop.csv%22]
qtok=[tdf=%22Sep_2011/data/wbttop.csv%22]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
fixqtok=[tdf="Aug_2011/data/wbttop.csv"]
fixqtok=[tdf="Sep_2011/data/wbttop.csv"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[remuser=bilmax21;]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[remuser=bilmax21;]
cookietok=[WB_userid=bilmax21;]
command line params:
current dir - pwd:
fixcookietok=[conf_WB_userid="bilmax21"]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
/u/catcom/wb/ex4_tst/comdat/common
N"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]

current user - id: fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]

cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]

standard input stream: fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
stdinput=[]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
wbt_stdcgiheader: validate user logged in here
fixcookietok=[conf_WB_ACCCODE=""]
wbt_stdcgiheader: username=[]
cookietok=[WB_ADMINDISABLED=]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
fixcookietok=[conf_WB_ADMINDISABLED=""]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
command line params:
current dir - pwd: fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]

/u/catcom/wb/ex4_tst/comdat/common

current user - id:
fixcookietok=[conf_entered_username="bilmax21"]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
procf=[/tmp/sqlproc6277_1] cookietok=[WB_recordno=168701;]

sqlid=[1]
standard input stream:
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] stdinput=[]

procfunc=[:] fixcookietok=[conf_WB_recordno="168701"]

cookietok=[WB_loginoff=0;]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
sqltype=[SELECT]
use SQL
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
procsql()
procsql() sqloutf=[/tmp/sqlout6319_1] sqlerrf=[/tmp/sqlerr6319_1] sqlprocf=[/tmp/sqlproc6319_1]
sqlid=[1] fixcookietok=[conf_WB_ACCCODE=""]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] cookietok=[WB_ADMINDISABLED=]

procfunc=[:]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) sqltype=[SELECT]
-------- nrows = 1 --------

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------

command line params: found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc6277_1 --------

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6277_1
rm -f /tmp/sqlerr6277_1
rm -f /tmp/sqlproc6277_1
---------------------------------
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
/u/catcom/wb/ex4_tst/comdat/common
ERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc6319_1 --------
cmd=[]
cmd=[]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6319_1
rm -f /tmp/sqlerr6319_1
rm -f /tmp/sqlproc6319_1

---------------------------------

current user - id:
qstr=[tdf=%22Mar_2010/data/wbttop.csv%22]
qstr=[tdf=%22Apr_2010/data/wbttop.csv%22]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
bttop.csv%22]

auser = [bilmax21]
fixqtok=[tdf="Apr_2010/data/wbttop.csv"]
standard input stream: fixqtok=[tdf="Mar_2010/data/wbttop.csv"]
stdinput=[] arecordno = [168701]
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
apasswdsalt = [0x]
cookietok=[remuser=bilmax21;]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
cookietok=[remuser=bilmax21;]
apassword=[0x101e1ff4262e2147]
wbt_stdcgiheader: validate user logged in here
userpwdes=[0x101e1ff4262e2147]
fixcookietok=[conf_remuser="bilmax21"]
wbt_stdcgiheader: test Cookie hack
wbt_stdcgiheader: username=[]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
get_useraccess() auser=[bilmax21] appmode=[]
userpwdes=[0x101e1ff4262e2147]
--- userpwdes OK ---
fixcookietok=[conf_remuser="bilmax21"]
wbt_stdcgiheader: username=[bilmax21]
use SQL
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
wbt_stdcgiheader: appmode=[ADMIN]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] cookietok=[WB_userid=bilmax21;]
datfile=[Aug_2011/data/wbttop.csv] --- userpwdes OK ---
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Aug_2011/data/wbttop.csv] wbt_stdcgiheader: username=[bilmax21]
-rw-rw-rw- 1 bilmax21 catcom 27447 Oct 4 18:43 topdat/Aug_2011/data/wbttop.csv wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
fixcookietok=[conf_WB_userid="bilmax21"]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
Login user is username=[bilmax21] cookietok=[remuserappmode=ADMIN;]
procsql() wbt_stdcgiheader: appmode=[ADMIN]
appmode=[ADMIN]
cookietok=[WB_userid=bilmax21;]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] testdistid=[ # dfp_part1=[Aug_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Aug_2011/data/wbttop.csv" allowaccess="1" ] fixcookietok=[conf_remuserappmode="ADMIN"]
procsql() sqloutf=[/tmp/sqlout6313_1] sqlerrf=[/tmp/sqlerr6313_1] sqlprocf=[/tmp/sqlproc6313_1] cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
datfile=[doc/disclaimer.html] dowbttopcsv=[topdat/Aug_2011/data/wbttop.csv]
sqlid=[1] outfile=[topdat/Aug_2011/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/doc/disclaimer.html] fixcookietok=[conf_WB_userid="bilmax21"]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] allowaccess=[1] get: topdat/Aug_2011/data/wbttop.csv cookietok=[remuserappmode=ADMIN;]
lrwxrwxrwx 1 bilmax21 catcom 25 Apr 19 2011 topdat/doc/disclaimer.html -> ../../img/disclaimer.html
procfunc=[:] cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
Login user is username=[bilmax21]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
appmode=[ADMIN]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_remuserappmode="ADMIN"]
sqltype=[SELECT] cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_recordno="168701"]
testdistid=[ # dfp_part1=[doc] # dfp_part2=[disclaimer.html] # dfp_part3=[] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all allowaccess="1" ] cookietok=[WB_loginoff=0;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_WB_loginoff="0"]
dowbttopcsv=[n/a] cookietok=[WB_extgrid=;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
outfile=[topdat/doc/disclaimer.html] fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
allowaccess=[1] fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
command line params:
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
current dir - pwd: get: topdat/doc/disclaimer.html
/u/catcom/wb/ex4_tst/comdat/common
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]

current user - id:
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------

standard input stream: recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- stdinput=[]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc6313_1 -------- fixcookietok=[conf_entered_username="bilmax21"]

cookietok=[WB_recordno=168701;]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6313_1
rm -f /tmp/sqlerr6313_1
rm -f /tmp/sqlproc6313_1
---------------------------------
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
cmd=[]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
fixcookietok=[conf_WB_loginoff="0"]
cmd=[]
cookietok=[WB_extgrid=;]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
qstr=[tdf=%22Apr_2011/data/wbttop.csv%22]
auser = [bilmax21]
procsql() fixcookietok=[conf_WB_extgrid=""]
arecordno = [168701]
qtok=[tdf=%22Apr_2011/data/wbttop.csv%22]
qstr=[tdf=%22Mar_2011/data/wbttop.csv%22]
cookietok=[WB_ACCCODE=;]
apassword = [0x101e1ff4262e2147]
procsql() sqloutf=[/tmp/sqlout6657_1] sqlerrf=[/tmp/sqlerr6657_1] sqlprocf=[/tmp/sqlproc6657_1] qtok=[tdf=%22Mar_2011/data/wbttop.csv%22]
apasswdsalt = [0x]
fixqtok=[tdf="Apr_2011/data/wbttop.csv"]

sqlid=[1] appmode = [ADMIN]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]

procfunc=[:]
fixqtok=[tdf="Mar_2011/data/wbttop.csv"]
wbt_stdcgiheader: username=[bilmax21]
fixcookietok=[conf_WB_ACCCODE=""]
apassword=[0x101e1ff4262e2147]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
userpwdes=[0x101e1ff4262e2147]
sqltype=[SELECT] wbt_stdcgiheader: test Cookie hack
fixcookietok=[conf_remuser="bilmax21"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_WB_ADMINDISABLED=""]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
--- userpwdes OK ---
command line params: cookietok=[WB_userid=bilmax21;]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
fixcookietok=[conf_WB_userid="bilmax21"]
wbt_stdcgiheader: appmode=[ADMIN]
current dir - pwd: fixcookietok=[conf_remuser="bilmax21"]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
datfile=[Sep_2011/data/wbttop.csv] /u/catcom/wb/ex4_tst/comdat/common
wd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Sep_2011/data/wbttop.csv]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
UX:ls: ERROR: Cannot access topdat/Sep_2011/data/wbttop.csv: No such file or directory sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) cookietok=[WB_userid=bilmax21;]
current user - id: fixcookietok=[conf_remuserappmode="ADMIN"]
Login user is username=[bilmax21] cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]

-------- nrows = 1 --------
appmode=[ADMIN]

uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
MIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]

cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WB_userid="bilmax21"]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc6657_1 --------

testdistid=[ # dfp_part1=[Sep_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Sep_2011/data/wbttop.csv" allowaccess="1" ] recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6657_1
rm -f /tmp/sqlerr6657_1
rm -f /tmp/sqlproc6657_1
--------------------------------- fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
stdinput=[]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
dowbttopcsv=[topdat/Sep_2011/data/wbttop.csv]
outfile=[topdat/Sep_2011/data/wbttop.csv] fixcookietok=[conf_remuserappmode="ADMIN"]
allowaccess=[1] fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
cookietok=[entered_username=bilmax21;]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_entered_username="bilmax21"]
auser = [bilmax21]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
arecordno = [168701]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
cookietok=[WB_recordno=168701;]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WB_recordno="168701"]
procsql() --- userpwdes OK ---
cookietok=[WB_loginoff=0;]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
datfile=[Apr_2010/data/wbttop.csv]
procsql() sqloutf=[/tmp/sqlout6653_1] sqlerrf=[/tmp/sqlerr6653_1] sqlprocf=[/tmp/sqlproc6653_1] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Apr_2010/data/wbttop.csv] cookietok=[entered_username=bilmax21;]
UX:ls: ERROR: Cannot access topdat/Apr_2010/data/wbttop.csv: No such file or directory ddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:] fixcookietok=[conf_WB_loginoff="0"]

cookietok=[WB_extgrid=;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
Login user is username=[bilmax21] appmode=[ADMIN]
sqltype=[SELECT]
fixcookietok=[conf_WB_extgrid=""]
cmd=[]
cmd=[]
cookietok=[WB_ACCCODE=;]
testdistid=[ # dfp_part1=[Apr_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Apr_2010/data/wbttop.csv" allowaccess="1" ] fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
dowbttopcsv=[topdat/Apr_2010/data/wbttop.csv]
outfile=[topdat/Apr_2010/data/wbttop.csv] fixcookietok=[conf_WB_ACCCODE=""]
allowaccess=[1] cookietok=[WB_ADMINDISABLED=]
qstr=[tdf=%22Oct_2010/data/wbttop.csv%22]
fixcookietok=[conf_WB_loginoff="0"]
qtok=[tdf=%22Oct_2010/data/wbttop.csv%22]
qstr=[tdf=%22Sep_2010/data/wbttop.csv%22]
cookietok=[WB_extgrid=;]
fixqtok=[tdf="Oct_2010/data/wbttop.csv"]
qtok=[tdf=%22Sep_2010/data/wbttop.csv%22]
fixqtok=[tdf="Sep_2010/data/wbttop.csv"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
cookietok=[remuser=bilmax21;]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_WB_extgrid=""]

-------- nrows = 1 -------- cookietok=[remuser=bilmax21;]
cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_remuser="bilmax21"]
command line params:
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
---------------------------------------- current dir - pwd: cookietok=[WB_userid=bilmax21;]


fixcookietok=[conf_WB_ACCCODE=""]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
-------- /tmp/sqlproc6653_1 -------- cookietok=[WB_userid=bilmax21;]
/u/catcom/wb/ex4_tst/comdat/common
]
cookietok=[WB_ADMINDISABLED=]
cookietok=[remuserappmode=ADMIN;]

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6653_1
rm -f /tmp/sqlerr6653_1
rm -f /tmp/sqlproc6653_1
--------------------------------- cookietok=[remuserappmode=ADMIN;]

fixcookietok=[conf_remuserappmode="ADMIN"]
current user - id: cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]

fixcookietok=[conf_WB_ADMINDISABLED=""]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
params: fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]

cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
standard input stream: current dir - pwd: fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
stdinput=[] cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]

fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
/u/catcom/wb/ex4_tst/comdat/common
Y="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_entered_username="bilmax21"]
auser = [bilmax21]
cookietok=[WB_recordno=168701;]

arecordno = [168701]
fixcookietok=[conf_entered_username="bilmax21"]
current user - id: cookietok=[WB_recordno=168701;]
apassword = [0x101e1ff4262e2147]
wbt_stdcgiheader: validate user logged in here
fixcookietok=[conf_WB_recordno="168701"]

apasswdsalt = [0x]
cookietok=[WB_loginoff=0;]
wbt_stdcgiheader: username=[]
fixcookietok=[conf_WB_recordno="168701"]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
r=[bilmax21] appmode=[]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
use SQL
fixcookietok=[conf_WB_loginoff="0"]

cookietok=[WB_extgrid=;]
wbt_stdcgiheader: username=[bilmax21]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
standard input stream: apassword=[0x101e1ff4262e2147]
stdinput=[] fixcookietok=[conf_WB_ACCCODE=""]
fixcookietok=[conf_WB_extgrid=""]
procsql() cookietok=[WB_ADMINDISABLED=]
userpwdes=[0x101e1ff4262e2147]
cookietok=[WB_ACCCODE=;]
wbt_stdcgiheader: test Cookie hack
fixcookietok=[conf_WB_ADMINDISABLED=""]
command line params: fixcookietok=[conf_WB_ACCCODE=""]
procsql() sqloutf=[/tmp/sqlout6969_1] sqlerrf=[/tmp/sqlerr6969_1] sqlprocf=[/tmp/sqlproc6969_1] cookietok=[WB_ADMINDISABLED=]
wbt_stdcgiheader: validate user logged in here

sqlid=[1]
--- userpwdes OK ---
wbt_stdcgiheader: username=[]
current dir - pwd:
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] fixcookietok=[conf_WB_ADMINDISABLED=""]
wbt_stdcgiheader: username=[bilmax21]

get_useraccess() auser=[bilmax21] appmode=[]

procfunc=[:] wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
command line params: use SQL
/u/catcom/wb/ex4_tst/comdat/common
wbt_stdcgiheader: appmode=[ADMIN]
current dir - pwd:

current user - id: ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]

uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

procsql()
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Mar_2010/data/wbttop.csv] current user - id: standard input stream:
stdinput=[] UX:lsuid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
rectory
procsql() sqloutf=[/tmp/sqlout6979_1] sqlerrf=[/tmp/sqlerr6979_1] sqlprocf=[/tmp/sqlproc6979_1] Login user is username=[bilmax21]
sqlid=[1]
appmode=[ADMIN]
standard input stream:
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] stdinput=[]
procfunc=[:]
wbt_stdcgiheader: validate user logged in here

wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
testdistid=[ # dfp_part1=[Mar_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Mar_2010/data/wbttop.csv" allowaccess="1" ] procsql() sqltype=[SELECT] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
dowbttopcsv=[topdat/Mar_2010/data/wbttop.csv]
-------- nrows = 1 -------- procsql()
procsql() sqloutf=[/tmp/sqlout7292_1] sqlerrf=[/tmp/sqlerr7292_1] sqlprocf=[/tmp/sqlproc7292_1] outfile=[topdat/Mar_2010/data/wbttop.csv]

sqlid=[1] allowaccess=[1] recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
> sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] ----------------------------------------
procfunc=[:]
procfunc=[:]

found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc6969_1 --------

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6969_1
rm -f /tmp/sqlerr6969_1
rm -f /tmp/sqlproc6969_1
--------------------------------- sqltype=[SELECT] sqltype=[SELECT]

sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc6979_1 -------- sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------

found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc7297_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout6979_1
rm -f /tmp/sqlerr6979_1
rm -f /tmp/sqlproc6979_1
---------------------------------
auser = [bilmax21]
--------------------------------- arecordno = [168701]

cmd=[]
apassword = [0x101e1ff4262e2147]
auser = [bilmax21]
arecordno = [168701]
cmd=[]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
apasswdsalt = [0x]
appmode = [ADMIN]
appmode = [ADMIN]
qstr=[tdf=%22Jun_2010/data/wbttop.csv%22]
wbt_stdcgiheader: username=[bilmax21]
qstr=[tdf=%22May_2010/data/wbttop.csv%22]
qtok=[tdf=%22Jun_2010/data/wbttop.csv%22]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
fixqtok=[tdf="Jun_2010/data/wbttop.csv"]
qtok=[tdf=%22May_2010/data/wbttop.csv%22]
userpwdes=[0x101e1ff4262e2147]
--- userpwdes OK ---
wbt_stdcgiheader: test Cookie hack
auser = [bilmax21]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
fixqtok=[tdf="May_2010/data/wbttop.csv"]
wbt_stdcgiheader: appmode=[ADMIN]
arecordno = [168701]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
apassword = [0x101e1ff4262e2147]
datfile=[Sep_2010/data/wbttop.csv] apasswdsalt = [0x]
cookietok=[remuser=bilmax21;]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Sep_2010/data/wbttop.csv] appmode = [ADMIN]
--- userpwdes OK ---
UX:ls: ERROR: Cannot access topdat/Sep_2010/data/wbttop.csv: No such file or directory cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_remuser="bilmax21"]
Login user is username=[bilmax21] appmode=[ADMIN]
cookietok=[remuser=bilmax21;]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: appmode=[ADMIN]
apassword=[0x101e1ff4262e2147]
testdistid=[ # dfp_part1=[Sep_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Sep_2010/data/wbttop.csv" allowaccess="1" ] ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] userpwdes=[0x101e1ff4262e2147]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
fixcookietok=[conf_remuser="bilmax21"]
dowbttopcsv=[topdat/Sep_2010/data/wbttop.csv] wbt_stdcgiheader: test Cookie hack
cookietok=[WB_userid=bilmax21;]
datfile=[Apr_2011/data/wbttop.csv] outfile=[topdat/Sep_2010/data/wbttop.csv] allowaccess=[1] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Apr_2011/data/wbttop.csv] fixcookietok=[conf_WB_userid="bilmax21"]
--- userpwdes OK ---
cookietok=[remuserappmode=ADMIN;]
-rw-rw-rw- 1 bilmax21 catcom 99700 Oct 4 18:43 topdat/Apr_2011/data/wbttop.csv wbt_stdcgiheader: username=[bilmax21]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
Login user is username=[bilmax21] wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
appmode=[ADMIN]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
wbt_stdcgiheader: appmode=[ADMIN]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
testdistid=[ # dfp_part1=[Apr_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Apr_2011/data/wbttop.csv" allowaccess="1" ] datfile=[Mar_2011/data/wbttop.csv] fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
dowbttopcsv=[topdat/Apr_2011/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Mar_2011/data/wbttop.csv] fixcookietok=[conf_WB_userid="bilmax21"]
outfile=[topdat/Apr_2011/data/wbttop.csv] cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WB_recordno="168701"]
allowaccess=[1] -rw-rw-rw- 1 bilmax21 catcom 99697 Oct 4 18:43 topdat/Mar_2011/data/wbttop.csv Login user is username=[bilmax21] fixcookietok=[conf_WB_loginoff="0"]
get: topdat/Apr_2011/data/wbttop.csv cookietok=[WB_extgrid=;]
appmode=[ADMIN]
fixcookietok=[conf_remuserappmode="ADMIN"]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
testdistid=[ # dfp_part1=[Mar_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Mar_2011/data/wbttop.csv" allowaccess="1" ] fixcookietok=[conf_WB_ADMINDISABLED=""]
dowbttopcsv=[topdat/Mar_2011/data/wbttop.csv]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
outfile=[topdat/Mar_2011/data/wbttop.csv] command line params: cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
allowaccess=[1]
current dir - pwd: get: topdat/Mar_2011/data/wbttop.csv
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
/u/catcom/wb/ex4_tst/comdat/common
%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]

current user - id:
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
=168701;]

standard input stream: fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
stdinput=[]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
wbt_stdcgiheader: validate user logged in here
fixcookietok=[conf_WB_extgrid=""]
wbt_stdcgiheader: username=[]
cookietok=[WB_ACCCODE=;]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
procsql() command line params:
procsql() sqloutf=[/tmp/sqlout7836_1] sqlerrf=[/tmp/sqlerr7836_1] sqlprocf=[/tmp/sqlproc7836_1]
current dir - pwd:
sqlid=[1]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] /u/catcom/wb/ex4_tst/comdat/common

current user - id:
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

standard input stream: stdinput=[]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
procsql()
procsql() sqloutf=[/tmp/sqlout7829_1] sqlerrf=[/tmp/sqlerr7829_1] sqlprocf=[/tmp/sqlproc7829_1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
sqlid=[1]
-------- nrows = 1 --------
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|

----------------------------------------

found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc7836_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout7836_1
rm -f /tmp/sqlerr7836_1
rm -f /tmp/sqlproc7836_1
---------------------------------
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]

wbt_stdcgiheader: appmode=[ADMIN]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc7829_1 -------- ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout7829_1
rm -f /tmp/sqlerr7829_1
rm -f /tmp/sqlproc7829_1
--------------------------------- pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jun_2010/data/wbttop.csv]
UX:ls: ERROR: Cannot access topdat/Jun_2010/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Jun_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jun_2010/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Jun_2010/data/wbttop.csv] auser = [bilmax21]
outfile=[topdat/Jun_2010/data/wbttop.csv] arecordno = [168701]
allowaccess=[1] apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[May_2010/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/May_2010/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/May_2010/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[May_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/May_2010/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/May_2010/data/wbttop.csv] outfile=[topdat/May_2010/data/wbttop.csv] allowaccess=[1] cmd=[]
cmd=[]
qstr=[tdf=%22Dec_2009/data/wbttop.csv%22]
qtok=[tdf=%22Dec_2009/data/wbttop.csv%22]
qstr=[tdf=%22Nov_2009/data/wbttop.csv%22]
fixqtok=[tdf="Dec_2009/data/wbttop.csv"]
qtok=[tdf=%22Nov_2009/data/wbttop.csv%22]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixqtok=[tdf="Nov_2009/data/wbttop.csv"]
cookietok=[remuser=bilmax21;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuserappmode="ADMIN"]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[entered_username=bilmax21;]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_entered_username="bilmax21"]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WB_recordno=168701;]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_WB_ADMINDISABLED=""]
fixcookietok=[conf_WB_ACCCODE=""]
command line params: cookietok=[WB_ADMINDISABLED=]
current dir - pwd:
/u/catcom/wb/ex4_tst/comdat/common
fixcookietok=[conf_WB_ADMINDISABLED=""]

command line params: current user - id:
cmd=[]
current dir - pwd:
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
qstr=[tdf=%22Aug_2009/data/wbttop.csv%22]
/u/catcom/wb/ex4_tst/comdat/common
standard input stream: qtok=[tdf=%22Aug_2009/data/wbttop.csv%22]

stdinput=[] qstr=[tdf=%22Jul_2009/data/wbttop.csv%22]
fixqtok=[tdf="Aug_2009/data/wbttop.csv"]
current user - id:
qtok=[tdf=%22Jul_2009/data/wbttop.csv%22]
wbt_stdcgiheader: validate user logged in here
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
get_useraccess() auser=[bilmax21] appmode=[]
use SQL

cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
standard input stream: cookietok=[remuser=bilmax21;]
stdinput=[] cmd=[]
fixqtok=[tdf="Jul_2009/data/wbttop.csv"]
procsql()
fixcookietok=[conf_remuser="bilmax21"]
procsql() sqloutf=[/tmp/sqlout8352_1] sqlerrf=[/tmp/sqlerr8352_1] sqlprocf=[/tmp/sqlproc8352_1] cookietok=[remuserpwdes=0x101e1ff4262e2147;]

sqlid=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] wbt_stdcgiheader: validate user logged in here

procfunc=[:] qstr=[tdf=%22May_2009/data/wbttop.csv%22]

wbt_stdcgiheader: username=[]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
get_useraccess() auser=[bilmax21] appmode=[]
cookietok=[WB_userid=bilmax21;]
qtok=[tdf=%22May_2009/data/wbttop.csv%22]
use SQL
sqltype=[SELECT] cookietok=[remuser=bilmax21;]
fixcookietok=[conf_WB_userid="bilmax21"]
fixqtok=[tdf="May_2009/data/wbttop.csv"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
procsql() cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[remuser=bilmax21;]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
procsql() sqloutf=[/tmp/sqlout8353_1] sqlerrf=[/tmp/sqlerr8353_1] sqlprocf=[/tmp/sqlproc8353_1]
sqlid=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) fixcookietok=[conf_WB_userid="bilmax21"]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserappmode=ADMIN;]

-------- nrows = 1 -------- cookietok=[remuserpwdes=0x101e1ff4262e2147;]

procfunc=[:]

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
cookietok=[WB_userid=bilmax21;]

cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WB_userid="bilmax21"]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc8352_1 -------- cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]

cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout8352_1
rm -f /tmp/sqlerr8352_1
rm -f /tmp/sqlproc8352_1
--------------------------------- sqltype=[SELECT]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[entered_username=bilmax21;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_entered_username="bilmax21"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_recordno="168701"]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WB_loginoff=0;]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_loginoff="0"]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
cookietok=[WB_extgrid=;]
auser = [bilmax21]
fixcookietok=[conf_entered_username="bilmax21"]
arecordno = [168701]
fixcookietok=[conf_WB_extgrid=""]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_recordno=168701;]
cookietok=[WB_ACCCODE=;]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) apassword = [0x101e1ff4262e2147]
cookietok=[WB_loginoff=0;]
apasswdsalt = [0x]

-------- nrows = 1 -------- fixcookietok=[conf_WB_ACCCODE=""]
appmode = [ADMIN]
cookietok=[WB_ADMINDISABLED=]

fixcookietok=[conf_WB_loginoff="0"]
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- wbt_stdcgiheader: username=[bilmax21]
fixcookietok=[conf_WB_ADMINDISABLED=""]

fixcookietok=[conf_WB_extgrid=""]
apassword=[0x101e1ff4262e2147]
cookietok=[WB_ACCCODE=;]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc8353_1 -------- command line params: userpwdes=[0x101e1ff4262e2147]
fixcookietok=[conf_WB_loginoff="0"]

wbt_stdcgiheader: test Cookie hack
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout8353_1
rm -f /tmp/sqlerr8353_1
rm -f /tmp/sqlproc8353_1
---------------------------------
--- userpwdes OK ---
fixcookietok=[conf_WB_ADMINDISABLED=""]
/u/catcom/wb/ex4_tst/comdat/common
21]
command line params: wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]

fixcookietok=[conf_WB_extgrid=""]
current user - id: wbt_stdcgiheader: appmode=[ADMIN]

---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] cookietok=[WB_ACCCODE=;]
current dir - pwd: uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
datfile=[Dec_2009/data/wbttop.csv]
/u/catcom/wb/ex4_tst/comdat/common
pdat/Dec_2009/data/wbttop.csv] standard input stream: stdinput=[]
fixcookietok=[conf_WB_ACCCODE=""]
UX:ls: ERROR: Cannot access topdat/Dec_2009/data/wbttop.csv: No such file or directory cookietok=[WB_ADMINDISABLED=]
Login user is username=[bilmax21] auser = [bilmax21]

appmode=[ADMIN]
arecordno = [168701]
wbt_stdcgiheader: validate user logged in here
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
get_useraccess() auser=[bilmax21] appmode=[]
apasswdsalt = [0x]

use SQL
appmode = [ADMIN]
standard input stream: fixcookietok=[conf_WB_ADMINDISABLED=""]
testdistid=[ # dfp_part1=[Dec_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Dec_2009/data/wbttop.csv" allowaccess="1" ]
stdinput=[] dowbttopcsv=[topdat/Dec_2009/data/wbttop.csv]
procsql() outfile=[topdat/Dec_2009/data/wbttop.csv] allowaccess=[1] wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
command line params:
procsql() sqloutf=[/tmp/sqlout8531_1] sqlerrf=[/tmp/sqlerr8531_1] sqlprocf=[/tmp/sqlproc8531_1] userpwdes=[0x101e1ff4262e2147]

sqlid=[1] wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: test Cookie hack

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] current dir - pwd: wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]

procfunc=[:]
use SQL

--- userpwdes OK ---
/u/catcom/wb/ex4_tst/comdat/common
wbt_stdcgiheader: username=[bilmax21]

wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
sqltype=[SELECT] current user - id: wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
procsql() uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Nov_2009/data/wbttop.csv]
UX:ls: ERROR: Cannot access topdat/Nov_2009/data/wbttop.csv: No such file or directory qlproc8574_1] standard input stream: Login user is username=[bilmax21] stdinput=[]
sqlid=[1] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Nov_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Nov_2009/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Nov_2009/data/wbttop.csv]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
outfile=[topdat/Nov_2009/data/wbttop.csv]
procfunc=[:] get_useraccess() auser=[bilmax21] appmode=[]
allowaccess=[1]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) use SQL

-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc8531_1 -------- sqltype=[SELECT]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout8531_1
rm -f /tmp/sqlerr8531_1
rm -f /tmp/sqlproc8531_1
---------------------------------
procsql() sqloutf=[/tmp/sqlout8529_1] sqlerrf=[/tmp/sqlerr8529_1] sqlprocf=[/tmp/sqlproc8529_1]
sqlid=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:] auser = [bilmax21]

arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) wbt_stdcgiheader: appmode=[ADMIN]
sqltype=[SELECT]
-------- nrows = 1 --------
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc8574_1 -------- datfile=[Jul_2009/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jul_2009/data/wbttop.csv]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout8574_1
rm -f /tmp/sqlerr8574_1
rm -f /tmp/sqlproc8574_1
--------------------------------- Login user is username=[bilmax21] cmd=[]

appmode=[ADMIN]
cmd=[]
testdistid=[ # dfp_part1=[Jul_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jul_2009/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Jul_2009/data/wbttop.csv] outfile=[topdat/Jul_2009/data/wbttop.csv] qstr=[tdf=%22Feb_2009/data/wbttop.csv%22]
qstr=[tdf=%22Mar_2009/data/wbttop.csv%22]
allowaccess=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) qtok=[tdf=%22Feb_2009/data/wbttop.csv%22]
qtok=[tdf=%22Mar_2009/data/wbttop.csv%22]

-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- fixqtok=[tdf="Feb_2009/data/wbttop.csv"]

fixqtok=[tdf="Mar_2009/data/wbttop.csv"]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc8529_1 --------
auser = [bilmax21]

arecordno = [168701]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout8529_1
rm -f /tmp/sqlerr8529_1
rm -f /tmp/sqlproc8529_1
pdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
--------------------------------- cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
apasswdsalt = [0x]
appmode = [ADMIN]
cookietok=[remuser=bilmax21;]

wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
auser = [bilmax21]
fixcookietok=[conf_remuser="bilmax21"]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
arecordno = [168701]
fixcookietok=[conf_remuser="bilmax21"]
wbt_stdcgiheader: appmode=[ADMIN]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
apassword = [0x101e1ff4262e2147]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) apasswdsalt = [0x]
appmode = [ADMIN]
datfile=[May_2009/data/wbttop.csv]
-------- nrows = 1 -------- fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/May_2009/data/wbttop.csv]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- userpwdes=[0x101e1ff4262e2147]
appmode=[ADMIN]
wbt_stdcgiheader: test Cookie hack

fixcookietok=[conf_WB_userid="bilmax21"]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc7292_1 -------- fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
testdistid=[ # dfp_part1=[May_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/May_2009/data/wbttop.csv" allowaccess="1" ] --- userpwdes OK ---
cookietok=[remuserappmode=ADMIN;]

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout7292_1
rm -f /tmp/sqlerr7292_1
rm -f /tmp/sqlproc7292_1
] --------------------------------- wbt_stdcgiheader: appmode=[ADMIN]
allowaccess=[1]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] fixcookietok=[conf_remuserappmode="ADMIN"]
fixcookietok=[conf_remuserappmode="ADMIN"]
datfile=[Aug_2009/data/wbttop.csv] cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Aug_2009/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/Aug_2009/data/wbttop.csv: No such file or directory cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Aug_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Aug_2009/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Aug_2009/data/wbttop.csv] fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
outfile=[topdat/Aug_2009/data/wbttop.csv] allowaccess=[1] fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
auser = [bilmax21]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
arecordno = [168701]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
cookietok=[entered_username=bilmax21;]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
appmode = [ADMIN]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
wbt_stdcgiheader: username=[bilmax21]
fixcookietok=[conf_WB_loginoff="0"]
apassword=[0x101e1ff4262e2147]
cookietok=[WB_extgrid=;]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
fixcookietok=[conf_entered_username="bilmax21"]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_ACCCODE=""]
--- userpwdes OK ---
cookietok=[WB_ADMINDISABLED=]
wbt_stdcgiheader: username=[bilmax21]
fixcookietok=[conf_WB_ADMINDISABLED=""]
command line params: wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
current dir - pwd: fixcookietok=[conf_WB_recordno="168701"]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
cookietok=[WB_loginoff=0;]
datfile=[Oct_2010/data/wbttop.csv] /u/catcom/wb/ex4_tst/comdat/common
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Oct_2010/data/wbttop.csv]
cmd=[]
current user - id: UX:ls: ERROR: Cannot access topdat/Oct_2010/data/wbttop.csv: No such file or directory
fixcookietok=[conf_WB_loginoff="0"]
Login user is username=[bilmax21] uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
]

standard input stream: qstr=[tdf=%22Oct_2011/data/wbttop.csv%22]
qstr=[tdf=%22Nov_2008/data/wbttop.csv%22]
stdinput=[] testdistid=[ # dfp_part1=[Oct_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Oct_2010/data/wbttop.csv" allowaccess="1" ]
qtok=[tdf=%22Oct_2011/data/wbttop.csv%22]
fixcookietok=[conf_WB_extgrid=""]
qtok=[tdf=%22Nov_2008/data/wbttop.csv%22]
dowbttopcsv=[topdat/Oct_2010/data/wbttop.csv] cookietok=[WB_ACCCODE=;]
outfile=[topdat/Oct_2010/data/wbttop.csv] wbt_stdcgiheader: validate user logged in here
fixqtok=[tdf="Oct_2011/data/wbttop.csv"]
allowaccess=[1]
wbt_stdcgiheader: username=[]
fixcookietok=[conf_WB_ACCCODE=""]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixqtok=[tdf="Nov_2008/data/wbttop.csv"]
get_useraccess() auser=[bilmax21] appmode=[]
cookietok=[WB_ADMINDISABLED=]
use SQL
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_WB_ADMINDISABLED=""]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
procsql() fixcookietok=[conf_remuser="bilmax21"]
command line params: cookietok=[remuser=bilmax21;]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
current dir - pwd: fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
procsql() sqloutf=[/tmp/sqlout9188_1] sqlerrf=[/tmp/sqlerr9188_1] sqlprocf=[/tmp/sqlproc9188_1]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuser="bilmax21"]

sqlid=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
/u/catcom/wb/ex4_tst/comdat/common
]
cookietok=[remuserappmode=ADMIN;]

current user - id:
cmd=[]
sqltype=[SELECT] fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
cmd=[]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
standard input stream: qstr=[tdf=%22May_2011/data/wbttop.csv%22]
fixcookietok=[conf_WB_userid="bilmax21"]
stdinput=[] qstr=[tdf=%22Feb_2011/data/wbttop.csv%22]
qtok=[tdf=%22May_2011/data/wbttop.csv%22]
cookietok=[remuserappmode=ADMIN;]
qtok=[tdf=%22Feb_2011/data/wbttop.csv%22]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixqtok=[tdf="May_2011/data/wbttop.csv"]
fixcookietok=[conf_remuserappmode="ADMIN"]
fixqtok=[tdf="Feb_2011/data/wbttop.csv"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
wbt_stdcgiheader: validate user logged in here
cookietok=[remuser=bilmax21;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
wbt_stdcgiheader: username=[]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[remuser=bilmax21;]
get_useraccess() auser=[bilmax21] appmode=[]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_remuser="bilmax21"]
use SQL
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]

-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
fixcookietok=[conf_remuser="bilmax21"]
procsql() cookietok=[remuserpwdes=0x101e1ff4262e2147;]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc9188_1 -------- fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
fixcookietok=[conf_WB_userid="bilmax21"]

fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[entered_username=bilmax21;]
cookietok=[remuserappmode=ADMIN;]
cookietok=[WB_recordno=168701;]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout9188_1
rm -f /tmp/sqlerr9188_1
rm -f /tmp/sqlproc9188_1
--------------------------------- fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]

sqlid=[1] fixcookietok=[conf_entered_username="bilmax21"]
fixcookietok=[conf_remuserappmode="ADMIN"]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]

procfunc=[:]
cookietok=[WB_loginoff=0;]

fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WB_loginoff="0"]
fixcookietok=[conf_WB_recordno="168701"]
sqltype=[SELECT] cookietok=[WB_loginoff=0;]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_remuserappmode="ADMIN"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WB_extgrid=""]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_ACCCODE=;]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
auser = [bilmax21]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
cookietok=[WB_recordno=168701;]
arecordno = [168701]
fixcookietok=[conf_WB_extgrid=""]
fixcookietok=[conf_WB_ADMINDISABLED=""]
apassword = [0x101e1ff4262e2147]
fixcookietok=[conf_WB_recordno="168701"]
command line params: sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
apasswdsalt = [0x]
cookietok=[WB_loginoff=0;]

-------- nrows = 1 -------- cookietok=[entered_username=bilmax21;]

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- current dir - pwd: fixcookietok=[conf_WB_ACCCODE=""]


fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_extgrid=;]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc9185_1 -------- cookietok=[WB_recordno=168701;]
/u/catcom/wb/ex4_tst/comdat/common

wbt_stdcgiheader: username=[bilmax21]

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout9185_1
rm -f /tmp/sqlerr9185_1
rm -f /tmp/sqlproc9185_1
--------------------------------- current user - id: fixcookietok=[conf_WB_ADMINDISABLED=""]
fixcookietok=[conf_WB_extgrid=""]
userpwdes=[0x101e1ff4262e2147]
fixcookietok=[conf_WB_recordno="168701"]


wbt_stdcgiheader: test Cookie hack
cookietok=[WB_ACCCODE=;]
cookietok=[WB_loginoff=0;]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
--- userpwdes OK ---

fixcookietok=[conf_WB_ACCCODE=""]
standard input stream: wbt_stdcgiheader: username=[bilmax21]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_loginoff="0"]
current dir - pwd: stdinput=[] wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
cookietok=[WB_extgrid=;]

wbt_stdcgiheader: appmode=[ADMIN]
/u/catcom/wb/ex4_tst/comdat/common

---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
auser = [bilmax21]
fixcookietok=[conf_WB_extgrid=""]

arecordno = [168701]
command line params: current user - id: datfile=[Feb_2009/data/wbttop.csv] wbt_stdcgiheader: validate user logged in here
cookietok=[WB_ACCCODE=;]

apassword = [0x101e1ff4262e2147]
wbt_stdcgiheader: username=[]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Feb_2009/data/wbttop.csv]
get_useraccess() auser=[bilmax21] appmode=[]
apasswdsalt = [0x]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
or directory use SQL
appmode = [ADMIN]

Login user is username=[bilmax21]
/u/catcom/wb/ex4_tst/comdat/common
ookietok=[conf_WB_ACCCODE=""]
standard input stream: cookietok=[WB_ADMINDISABLED=]

stdinput=[] procsql() wbt_stdcgiheader: username=[bilmax21]
current user - id:
testdistid=[ # dfp_part1=[Feb_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Feb_2009/data/wbttop.csv" allowaccess="1" ] apassword=[0x101e1ff4262e2147]

fixcookietok=[conf_WB_ADMINDISABLED=""]
userpwdes=[0x101e1ff4262e2147]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
st Cookie hack
outfile=[topdat/Feb_2009/data/wbttop.csv]
procsql() sqloutf=[/tmp/sqlout9508_1] sqlerrf=[/tmp/sqlerr9508_1] sqlprocf=[/tmp/sqlproc9508_1]

sqlid=[1] standard input stream: allowaccess=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] wbt_stdcgiheader: validate user logged in here
command line params: stdinput=[] --- userpwdes OK ---

procfunc=[:] wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]

wbt_stdcgiheader: username=[bilmax21]
use SQL
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
current dir - pwd: ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
/u/catcom/wb/ex4_tst/comdat/common
date user logged in here
datfile=[Mar_2009/data/wbttop.csv] procsql()
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Mar_2009/data/wbttop.csv] wbt_stdcgiheader: username=[]

get_useraccess() auser=[bilmax21] appmode=[]
UX:ls: ERROR: Cannot access topdat/Mar_2009/data/wbttop.csv: No such file or directory qlproc9518_1] current user - id: use SQL

sqlid=[1] Login user is username=[bilmax21]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] appmode=[ADMIN]

procfunc=[:] uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

testdistid=[ # dfp_part1=[Mar_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Mar_2009/data/wbttop.csv" allowaccess="1" ] standard input stream: sqltype=[SELECT] stdinput=[] dowbttopcsv=[topdat/Mar_2009/data/wbttop.csv]
outfile=[topdat/Mar_2009/data/wbttop.csv] allowaccess=[1]
procsql()
procsql() sqloutf=[/tmp/sqlout9646_1] sqlerrf=[/tmp/sqlerr9646_1] sqlprocf=[/tmp/sqlproc9646_1]
sqlid=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:]
-------- nrows = 1 --------
wbt_stdcgiheader: validate user logged in here

wbt_stdcgiheader: username=[]
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
get_useraccess() auser=[bilmax21] appmode=[]

use SQL
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc9508_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout9508_1
rm -f /tmp/sqlerr9508_1
rm -f /tmp/sqlproc9508_1
---------------------------------
procsql() cmd=[]
procsql() sqloutf=[/tmp/sqlout9648_1] sqlerrf=[/tmp/sqlerr9648_1] sqlprocf=[/tmp/sqlproc9648_1]
sqlid=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
-------- nrows = 1 -------- cmd=[]

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------


qtok=[tdf=%22Aug_2010/data/wbttop.csv%22]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc9646_1 -------- qstr=[tdf=%22Nov_2010/data/wbttop.csv%22]

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout9646_1
rm -f /tmp/sqlerr9646_1
rm -f /tmp/sqlproc9646_1
--------------------------------- sqltype=[SELECT] auser = [bilmax21]

arecordno = [168701]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
cookietok=[remuser=bilmax21;]
fixqtok=[tdf="Nov_2010/data/wbttop.csv"]
appmode = [ADMIN]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
wbt_stdcgiheader: username=[bilmax21]
auser = [bilmax21]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
apassword=[0x101e1ff4262e2147]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
apasswdsalt = [0x]
cookietok=[WB_userid=bilmax21;]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
fixcookietok=[conf_WB_userid="bilmax21"]
userpwdes=[0x101e1ff4262e2147]
apassword=[0x101e1ff4262e2147]
cookietok=[remuserappmode=ADMIN;]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
wbt_stdcgiheader: test Cookie hack
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuserappmode="ADMIN"]
--- userpwdes OK ---
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) wbt_stdcgiheader: username=[bilmax21]
--- userpwdes OK ---
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]

-------- nrows = 1 -------- fixcookietok=[conf_remuser="bilmax21"]
wbt_stdcgiheader: username=[bilmax21]

wbt_stdcgiheader: appmode=[ADMIN]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] -rw-rw-rw- 1 bilmax21 catcom 99566 Oct 4 18:43 topdat/May_2011/data/wbttop.csv Login user is username=[bilmax21]
appmode=[ADMIN]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc9648_1 -------- datfile=[Nov_2008/data/wbttop.csv] cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]

pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Nov_2008/data/wbttop.csv] recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout9648_1
rm -f /tmp/sqlerr9648_1
rm -f /tmp/sqlproc9648_1
/May_2011/data/wbttop.csv" allowaccess="1" ] --------------------------------- cookietok=[WB_userid=bilmax21;]
UX:ls: ERROR: Cannot access topdat/Nov_2008/data/wbttop.csv: No such file or directory fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]

outfile=[topdat/May_2011/data/wbttop.csv] cookietok=[entered_username=bilmax21;]
Login user is username=[bilmax21] allowaccess=[1] get: topdat/May_2011/data/wbttop.csv appmode=[ADMIN]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
testdistid=[ # dfp_part1=[Nov_2008] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Nov_2008/data/wbttop.csv" allowaccess="1" ] fixcookietok=[conf_WB_userid="bilmax21"]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
dowbttopcsv=[topdat/Nov_2008/data/wbttop.csv] fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
outfile=[topdat/Nov_2008/data/wbttop.csv] fixcookietok=[conf_remuserappmode="ADMIN"]
allowaccess=[1] cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WB_ADMINDISABLED=""]
command line params: fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
auser = [bilmax21]
current dir - pwd: cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]

arecordno = [168701]
/u/catcom/wb/ex4_tst/comdat/common
apassword = [0x101e1ff4262e2147]

current user - id:
apasswdsalt = [0x]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
appmode = [ADMIN]

standard input stream: stdinput=[]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
userpwdes=[0x101e1ff4262e2147]
cookietok=[entered_username=bilmax21;]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
wbt_stdcgiheader: test Cookie hack
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
fixcookietok=[conf_entered_username="bilmax21"]
procsql() --- userpwdes OK ---
cookietok=[WB_recordno=168701;]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
procsql() sqloutf=[/tmp/sqlout10295_1] sqlerrf=[/tmp/sqlerr10295_1] sqlprocf=[/tmp/sqlproc10295_1] wbt_stdcgiheader: appmode=[ADMIN]

sqlid=[1] ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:] datfile=[Feb_2011/data/wbttop.csv]
fixcookietok=[conf_WB_recordno="168701"]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Feb_2011/data/wbttop.csv] cookietok=[WB_loginoff=0;]
-rw-rw-rw- 1 bilmax21 catcom 98891 Oct 4 18:43 topdat/Feb_2011/data/wbttop.csv Login user is username=[bilmax21] appmode=[ADMIN]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
testdistid=[ # dfp_part1=[Feb_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Feb_2011/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Feb_2011/data/wbttop.csv] outfile=[topdat/Feb_2011/data/wbttop.csv] fixcookietok=[conf_WB_extgrid=""]
allowaccess=[1] get: topdat/Feb_2011/data/wbttop.csv cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 -------- fixcookietok=[conf_WB_ADMINDISABLED=""]

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- command line params:

current dir - pwd: found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc10295_1 --------

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout10295_1
rm -f /tmp/sqlerr10295_1
rm -f /tmp/sqlproc10295_1
---------------------------------

current user - id:
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

standard input stream: stdinput=[] auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: validate user logged in here
apassword=[0x101e1ff4262e2147]
wbt_stdcgiheader: username=[]
userpwdes=[0x101e1ff4262e2147]
get_useraccess() auser=[bilmax21] appmode=[]
wbt_stdcgiheader: test Cookie hack
use SQL
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
procsql() ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Aug_2010/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Aug_2010/data/wbttop.csv]
procsql() sqloutf=[/tmp/sqlout10304_1] sqlerrf=[/tmp/sqlerr10304_1] sqlprocf=[/tmp/sqlproc10304_1] UX:ls: ERROR: Cannot access topdat/Aug_2010/data/wbttop.csv: No such file or directory
sqlid=[1] Login user is username=[bilmax21]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] appmode=[ADMIN]

procfunc=[:]
testdistid=[ # dfp_part1=[Aug_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Aug_2010/data/wbttop.csv" allowaccess="1" ] sqltype=[SELECT] dowbttopcsv=[topdat/Aug_2010/data/wbttop.csv]
outfile=[topdat/Aug_2010/data/wbttop.csv] allowaccess=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc10304_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout10304_1
rm -f /tmp/sqlerr10304_1
rm -f /tmp/sqlproc10304_1
---------------------------------
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
cmd=[]
wbt_stdcgiheader: appmode=[ADMIN]
cmd=[]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
datfile=[Nov_2010/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Nov_2010/data/wbttop.csv]
UX:ls: ERROR: Cannot access topdat/Nov_2010/data/wbttop.csv: No such file or directory qstr=[tdf=%22Oct_2009/data/wbttop.csv%22]
Login user is username=[bilmax21] appmode=[ADMIN]
qtok=[tdf=%22Oct_2009/data/wbttop.csv%22]
qstr=[tdf=%22Jan_2010/data/wbttop.csv%22]
testdistid=[ # dfp_part1=[Nov_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Nov_2010/data/wbttop.csv" allowaccess="1" ] qtok=[tdf=%22Jan_2010/data/wbttop.csv%22]
dowbttopcsv=[topdat/Nov_2010/data/wbttop.csv] fixqtok=[tdf="Oct_2009/data/wbttop.csv"]
outfile=[topdat/Nov_2010/data/wbttop.csv]
allowaccess=[1] fixqtok=[tdf="Jan_2010/data/wbttop.csv"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[WB_userid=bilmax21;]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WB_userid="bilmax21"]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[remuserappmode=ADMIN;]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
cmd=[]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
cmd=[]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WB_extgrid=""]
qstr=[tdf=%22Apr_2009/data/wbttop.csv%22]
cookietok=[WB_ACCCODE=;]
qtok=[tdf=%22Apr_2009/data/wbttop.csv%22]
qstr=[tdf=%22Jan_2009/data/wbttop.csv%22]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
qtok=[tdf=%22Jan_2009/data/wbttop.csv%22]
fixcookietok=[conf_WB_ACCCODE=""]
fixqtok=[tdf="Apr_2009/data/wbttop.csv"]
cookietok=[WB_ADMINDISABLED=]
fixqtok=[tdf="Jan_2009/data/wbttop.csv"]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
command line params: fixcookietok=[conf_WB_ADMINDISABLED=""]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
command line params: current dir - pwd: fixcookietok=[conf_remuser="bilmax21"]

cookietok=[remuserpwdes=0x101e1ff4262e2147;]
/u/catcom/wb/ex4_tst/comdat/common
fixcookietok=[conf_remuser="bilmax21"]
current dir - pwd:

cookietok=[remuserpwdes=0x101e1ff4262e2147;]
current user - id: fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
/u/catcom/wb/ex4_tst/comdat/common
> uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
user - id: fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[WB_userid=bilmax21;]


uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
ut=[]
fixcookietok=[conf_WB_userid="bilmax21"]

cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_remuserappmode="ADMIN"]
standard input stream: cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
stdinput=[]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
fixcookietok=[conf_remuserappmode="ADMIN"]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
get_useraccess() auser=[bilmax21] appmode=[]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
use SQL
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
get_useraccess() auser=[bilmax21] appmode=[]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
use SQL
procsql() cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
procsql() sqloutf=[/tmp/sqlout10842_1] sqlerrf=[/tmp/sqlerr10842_1] sqlprocf=[/tmp/sqlproc10842_1] fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]

sqlid=[1] fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
procsql()
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] cookietok=[entered_username=bilmax21;]

procfunc=[:]
procsql() sqloutf=[/tmp/sqlout10838_1] sqlerrf=[/tmp/sqlerr10838_1] sqlprocf=[/tmp/sqlproc10838_1] fixcookietok=[conf_entered_username="bilmax21"]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WB_recordno=168701;]
sqltype=[SELECT] cookietok=[entered_username=bilmax21;]

sqlid=[1]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:] fixcookietok=[conf_WB_recordno="168701"]

cookietok=[WB_loginoff=0;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
sqltype=[SELECT] fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_WB_recordno="168701"]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_loginoff=0;]
cookietok=[WB_ADMINDISABLED=]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 -------- fixcookietok=[conf_WB_ADMINDISABLED=""]

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- fixcookietok=[conf_WB_loginoff="0"]

current dir - pwd: cookietok=[WB_extgrid=;]

found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc10842_1 -------- /u/catcom/wb/ex4_tst/comdat/common


recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout10842_1
rm -f /tmp/sqlerr10842_1
rm -f /tmp/sqlproc10842_1
--------------------------------- uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

standard input stream: stdinput=[]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
auser = [bilmax21]
fixcookietok=[conf_WB_ADMINDISABLED=""]
arecordno = [168701]
procsql() apassword = [0x101e1ff4262e2147]
procsql() sqloutf=[/tmp/sqlout10990_1] sqlerrf=[/tmp/sqlerr10990_1] sqlprocf=[/tmp/sqlproc10990_1] command line params:
sqlid=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] apasswdsalt = [0x]

procfunc=[:] appmode = [ADMIN]

current dir - pwd:

sqltype=[SELECT]
wbt_stdcgiheader: username=[bilmax21]
/u/catcom/wb/ex4_tst/comdat/common
262e2147]
userpwdes=[0x101e1ff4262e2147]

wbt_stdcgiheader: test Cookie hack
current user - id:
--- userpwdes OK ---
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]

wbt_stdcgiheader: appmode=[ADMIN]
standard input stream: ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) stdinput=[]
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Oct_2009/data/wbttop.csv]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc10990_1 --------
UX:ls: ERROR: Cannot access topdat/Oct_2009/data/wbttop.csv: No such file or directory DMIN'
:
rm -f /tmp/sqlout10990_1
rm -f /tmp/sqlerr10990_1
rm -f /tmp/sqlproc10990_1
--------------------------------- wbt_stdcgiheader: validate user logged in here

Login user is username=[bilmax21] wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
appmode=[ADMIN]
use SQL
auser = [bilmax21]
testdistid=[ # dfp_part1=[Oct_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Oct_2009/data/wbttop.csv" allowaccess="1" ] arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
dowbttopcsv=[topdat/Oct_2009/data/wbttop.csv] outfile=[topdat/Oct_2009/data/wbttop.csv] allowaccess=[1] procsql() wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
procsql() sqloutf=[/tmp/sqlout10995_1] sqlerrf=[/tmp/sqlerr10995_1] sqlprocf=[/tmp/sqlproc10995_1]
sqlid=[1] --- userpwdes OK ---

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] wbt_stdcgiheader: username=[bilmax21]

procfunc=[:] wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
datfile=[Apr_2009/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Apr_2009/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/Apr_2009/data/wbttop.csv: No such file or directory sqltype=[SELECT] Login user is username=[bilmax21]
appmode=[ADMIN]
testdistid=[ # dfp_part1=[Apr_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Apr_2009/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Apr_2009/data/wbttop.csv] outfile=[topdat/Apr_2009/data/wbttop.csv] allowaccess=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc10995_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout10995_1
rm -f /tmp/sqlerr10995_1
rm -f /tmp/sqlproc10995_1
---------------------------------
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Jan_2009/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jan_2009/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/Jan_2009/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Jan_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jan_2009/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Jan_2009/data/wbttop.csv] outfile=[topdat/Jan_2009/data/wbttop.csv] allowaccess=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc9518_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout9518_1
rm -f /tmp/sqlerr9518_1
rm -f /tmp/sqlproc9518_1
---------------------------------
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Oct_2011/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Oct_2011/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/Oct_2011/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Oct_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Oct_2011/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Oct_2011/data/wbttop.csv] outfile=[topdat/Oct_2011/data/wbttop.csv] allowaccess=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc10838_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout10838_1
rm -f /tmp/sqlerr10838_1
rm -f /tmp/sqlproc10838_1
---------------------------------
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Jan_2010/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jan_2010/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/Jan_2010/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Jan_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jan_2010/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Jan_2010/data/wbttop.csv] outfile=[topdat/Jan_2010/data/wbttop.csv] allowaccess=[1] cmd=[]
cmd=[]
qstr=[tdf=%22Jun_2011/data/wbttop.csv%22]
qtok=[tdf=%22Jun_2011/data/wbttop.csv%22]
qstr=[tdf=%22Jan_2011/data/wbttop.csv%22]
qtok=[tdf=%22Jan_2011/data/wbttop.csv%22]
fixqtok=[tdf="Jun_2011/data/wbttop.csv"]
fixqtok=[tdf="Jan_2011/data/wbttop.csv"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
cmd=[]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_entered_username="bilmax21"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WB_recordno=168701;]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WB_recordno="168701"]
qstr=[tdf=%22Jul_2011/data/wbttop.csv%22]
cookietok=[WB_loginoff=0;]
qtok=[tdf=%22Jul_2011/data/wbttop.csv%22]
fixcookietok=[conf_WB_loginoff="0"]
cmd=[]
cmd=[]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
fixqtok=[tdf="Jul_2011/data/wbttop.csv"]
cookietok=[entered_username=bilmax21;]
qstr=[tdf=%22Feb_2010/data/wbttop.csv%22]
fixcookietok=[conf_WB_extgrid=""]
qtok=[tdf=%22Feb_2010/data/wbttop.csv%22]
cookietok=[WB_ACCCODE=;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_entered_username="bilmax21"]
fixqtok=[tdf="Feb_2010/data/wbttop.csv"]
cookietok=[WB_recordno=168701;]
qstr=[tdf=%22Sep_2009/data/wbttop.csv%22]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[remuser=bilmax21;]
cookietok=[WB_ADMINDISABLED=]
qtok=[tdf=%22Sep_2009/data/wbttop.csv%22]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_remuser="bilmax21"]
fixqtok=[tdf="Sep_2009/data/wbttop.csv"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixcookietok=[conf_WB_loginoff="0"]
fixcookietok=[conf_WB_ADMINDISABLED=""]
cookietok=[remuser=bilmax21;]
cookietok=[WB_extgrid=;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
command line params: fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
current dir - pwd: fixcookietok=[conf_WB_extgrid=""]

cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
/u/catcom/wb/ex4_tst/comdat/common
cookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WB_userid="bilmax21"]
fixcookietok=[conf_WB_ACCCODE=""]

fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[WB_ADMINDISABLED=]
cookietok=[remuserappmode=ADMIN;]
cookietok=[remuserappmode=ADMIN;]
current user - id:
fixcookietok=[conf_remuserappmode="ADMIN"]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WB_ADMINDISABLED=""]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
sk@victrack.com.au"]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
command line params: cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]

standard input stream: fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
stdinput=[] cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
current dir - pwd:
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[entered_username=bilmax21;]

cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
/u/catcom/wb/ex4_tst/comdat/common
lmax21"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
cookietok=[WB_recordno=168701;]

wbt_stdcgiheader: validate user logged in here
current user - id: fixcookietok=[conf_WB_recordno="168701"]
wbt_stdcgiheader: username=[]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
cookietok=[WB_loginoff=0;]

cookietok=[entered_username=bilmax21;]
get_useraccess() auser=[bilmax21] appmode=[]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
okietok=[conf_WB_loginoff="0"]
use SQL
cookietok=[WB_extgrid=;]

standard input stream: fixcookietok=[conf_WB_extgrid=""]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_WB_extgrid=""]
stdinput=[] cookietok=[WB_recordno=168701;]
cookietok=[WB_ACCCODE=;]
fixcookietok=[conf_WB_ACCCODE=""]
cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ACCCODE=""]
procsql() cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
fixcookietok=[conf_WB_recordno="168701"]
command line params: cookietok=[WB_loginoff=0;]
fixcookietok=[conf_WB_ADMINDISABLED=""]
procsql() sqloutf=[/tmp/sqlout11708_1] sqlerrf=[/tmp/sqlerr11708_1] sqlprocf=[/tmp/sqlproc11708_1] wbt_stdcgiheader: validate user logged in here

sqlid=[1]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] command line params: wbt_stdcgiheader: username=[]
current dir - pwd:
get_useraccess() auser=[bilmax21] appmode=[]

procfunc=[:]
current dir - pwd: use SQL


/u/catcom/wb/ex4_tst/comdat/common

/u/catcom/wb/ex4_tst/comdat/common
current user - id:
current user - id:

sqltype=[SELECT]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
fixcookietok=[conf_WB_extgrid=""]
procsql() cookietok=[WB_ACCCODE=;]

standard input stream: standard input stream: stdinput=[] stdinput=[]
procsql() sqloutf=[/tmp/sqlout11709_1] sqlerrf=[/tmp/sqlerr11709_1] sqlprocf=[/tmp/sqlproc11709_1]

sqlid=[1] fixcookietok=[conf_WB_ACCCODE=""]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] cookietok=[WB_ADMINDISABLED=]

procfunc=[:] wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]
wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]
get_useraccess() auser=[bilmax21] appmode=[]
use SQL
use SQL

procsql() procsql() fixcookietok=[conf_WB_ADMINDISABLED=""]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 -------- command line params:
sqltype=[SELECT] recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
onf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]

sqlid=[1] current dir - pwd:
procfunc=[:] ----------------------------------------

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]


procfunc=[:]
/u/catcom/wb/ex4_tst/comdat/common
K~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc11708_1 --------


recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout11708_1
rm -f /tmp/sqlerr11708_1
rm -f /tmp/sqlproc11708_1
---------------------------------

uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )

-------- nrows = 1 -------- standard input stream:
stdinput=[] recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc11709_1 --------
auser = [bilmax21]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout11709_1
rm -f /tmp/sqlerr11709_1
rm -f /tmp/sqlproc11709_1
--------------------------------- wbt_stdcgiheader: username=[]
apassword = [0x101e1ff4262e2147]

get_useraccess() auser=[bilmax21] appmode=[]
apasswdsalt = [0x]
use SQL
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
procsql() userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
procsql() sqloutf=[/tmp/sqlout11794_1] sqlerrf=[/tmp/sqlerr11794_1] sqlprocf=[/tmp/sqlproc11794_1]
sqlid=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] auser = [bilmax21]

procfunc=[:] --- userpwdes OK ---

arecordno = [168701]
wbt_stdcgiheader: username=[bilmax21]
apassword = [0x101e1ff4262e2147]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
sqltype=[SELECT] apasswdsalt = [0x]
wbt_stdcgiheader: appmode=[ADMIN]
appmode = [ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Jun_2011/data/wbttop.csv] wbt_stdcgiheader: username=[bilmax21]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jun_2011/data/wbttop.csv] apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
-rw-rw-rw- 1 bilmax21 catcom 99581 Oct 4 18:43 topdat/Jun_2011/data/wbttop.csv Login user is username=[bilmax21] appmode=[ADMIN]
--- userpwdes OK ---
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 -------- wbt_stdcgiheader: username=[bilmax21]

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
testdistid=[ # dfp_part1=[Jun_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jun_2011/data/wbttop.csv" allowaccess="1" ] ---------------------------------------- wbt_stdcgiheader: appmode=[ADMIN]

found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc11794_1 -------- ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout11794_1
rm -f /tmp/sqlerr11794_1
rm -f /tmp/sqlproc11794_1
--------------------------------- outfile=[topdat/Jun_2011/data/wbttop.csv]
datfile=[Jan_2011/data/wbttop.csv] allowaccess=[1] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jan_2011/data/wbttop.csv] get: topdat/Jun_2011/data/wbttop.csv -rw-rw-rw- 1 bilmax21 catcom 106323 Oct 4 18:41 topdat/Jan_2011/data/wbttop.csv Login user is username=[bilmax21] appmode=[ADMIN]
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
testdistid=[ # dfp_part1=[Jan_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jan_2011/data/wbttop.csv" allowaccess="1" ] apasswdsalt = [0x]
appmode = [ADMIN]
dowbttopcsv=[topdat/Jan_2011/data/wbttop.csv] outfile=[topdat/Jan_2011/data/wbttop.csv] allowaccess=[1] wbt_stdcgiheader: username=[bilmax21]
get: topdat/Jan_2011/data/wbttop.csv apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Jul_2011/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jul_2011/data/wbttop.csv] -rw-rw-rw- 1 bilmax21 catcom 99846 Oct 4 18:43 topdat/Jul_2011/data/wbttop.csv Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Jul_2011] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jul_2011/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Jul_2011/data/wbttop.csv] outfile=[topdat/Jul_2011/data/wbttop.csv] allowaccess=[1] get: topdat/Jul_2011/data/wbttop.csv cmd=[]
qstr=[tdf=%22Dec_2010/data/wbttop.csv%22]
qtok=[tdf=%22Dec_2010/data/wbttop.csv%22]
cmd=[]
fixqtok=[tdf="Dec_2010/data/wbttop.csv"]
cmd=[]
qstr=[tdf=%22Jul_2010/data/wbttop.csv%22]
qtok=[tdf=%22Jul_2010/data/wbttop.csv%22]
qstr=[tdf=%22Dec_2008/data/wbttop.csv%22]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
fixqtok=[tdf="Jul_2010/data/wbttop.csv"]
qtok=[tdf=%22Dec_2008/data/wbttop.csv%22]
cookietok=[remuser=bilmax21;]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[remuser=bilmax21;]
fixqtok=[tdf="Dec_2008/data/wbttop.csv"]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuser="bilmax21"]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookie=[remuser=bilmax21; remuserpwdes=0x101e1ff4262e2147; WB_userid=bilmax21; remuserappmode=ADMIN; WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au; WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
cookietok=[WB_userid=bilmax21;]
cookietok=[remuser=bilmax21;]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_remuser="bilmax21"]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_WB_userid="bilmax21"]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
cookietok=[remuserpwdes=0x101e1ff4262e2147;]
cookietok=[remuserappmode=ADMIN;]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_remuserappmode="ADMIN"]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
cookietok=[entered_username=bilmax21;]
cookietok=[WB_userid=bilmax21;]
fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
fixcookietok=[conf_WB_userid="bilmax21"]
fixcookietok=[conf_WB_recordno="168701"]
cookietok=[remuserappmode=ADMIN;]
cookietok=[WB_loginoff=0;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WB_loginoff="0"]
cookietok=[WB_extgrid=;]
fixcookietok=[conf_remuserappmode="ADMIN"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
fixcookietok=[conf_WB_extgrid=""]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]
cookietok=[WB_ACCCODE=;]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
fixcookietok=[conf_WB_ACCCODE=""]
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
cookietok=[WB_ADMINDISABLED=]
cookietok=[entered_username=bilmax21;]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
fixcookietok=[conf_WB_ADMINDISABLED=""]
command line params: fixcookietok=[conf_entered_username="bilmax21"]
fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
cookietok=[WB_recordno=168701;]
current dir - pwd:
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
/u/catcom/wb/ex4_tst/comdat/common
fixcookietok=[conf_WB_recordno="168701"]

cookietok=[WB_loginoff=0;]
fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
current user - id: cookietok=[entered_username=bilmax21;]
fixcookietok=[conf_WB_loginoff="0"]

cookietok=[WB_extgrid=;]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

fixcookietok=[conf_entered_username="bilmax21"]
cookietok=[WB_recordno=168701;]
fixcookietok=[conf_WB_ACCCODE=""]
standard input stream: cookietok=[WB_ADMINDISABLED=]
stdinput=[] fixcookietok=[conf_WB_ADMINDISABLED=""]
fixcookietok=[conf_WB_recordno="168701"]
command line params: cookietok=[WB_loginoff=0;]
current dir - pwd:
wbt_stdcgiheader: validate user logged in here
/u/catcom/wb/ex4_tst/comdat/common
get_useraccess() auser=[bilmax21] appmode=[]

current user - id: use SQL

fixcookietok=[conf_WB_loginoff="0"]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)

standard input stream: stdinput=[]
procsql() fixcookietok=[conf_WB_extgrid=""]
cookietok=[WB_ACCCODE=;]
wbt_stdcgiheader: validate user logged in here
procsql() sqloutf=[/tmp/sqlout12570_1] sqlerrf=[/tmp/sqlerr12570_1] sqlprocf=[/tmp/sqlproc12570_1] wbt_stdcgiheader: username=[]
get_useraccess() auser=[bilmax21] appmode=[]

sqlid=[1] use SQL

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:] fixcookietok=[conf_WB_ACCCODE=""]

cookietok=[WB_ADMINDISABLED=]
procsql() sqltype=[SELECT]
procsql() sqloutf=[/tmp/sqlout12569_1] sqlerrf=[/tmp/sqlerr12569_1] sqlprocf=[/tmp/sqlproc12569_1] fixcookietok=[conf_WB_ADMINDISABLED=""]

sqlid=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ] command line params:
procfunc=[:]
cmd=[]
current dir - pwd:
sqltype=[SELECT]
qstr=[tdf=%22Jun_2009/data/wbttop.csv%22]
qtok=[tdf=%22Jun_2009/data/wbttop.csv%22]
/u/catcom/wb/ex4_tst/comdat/common
onid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------

current user - id: recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- fixqtok=[tdf="Jun_2009/data/wbttop.csv"]

uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
tinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc12570_1 --------

sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout12570_1
rm -f /tmp/sqlerr12570_1
rm -f /tmp/sqlproc12570_1
SUBJECT=Bilmax21%20Query; WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A; entered_username=bilmax21; WB_recordno=168701; WB_loginoff=0; WB_extgrid=; WB_ACCCODE=; WB_ADMINDISABLED=]
standard input stream:
-------- nrows = 1 -------- ---------------------------------
stdinput=[] cookietok=[remuser=bilmax21;]
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc12569_1 -------- fixcookietok=[conf_remuser="bilmax21"]

cookietok=[remuserpwdes=0x101e1ff4262e2147;]
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout12569_1
rm -f /tmp/sqlerr12569_1
rm -f /tmp/sqlproc12569_1
--------------------------------- wbt_stdcgiheader: validate user logged in here
wbt_stdcgiheader: username=[]

get_useraccess() auser=[bilmax21] appmode=[]
auser = [bilmax21]
fixcookietok=[conf_remuserpwdes="0x101e1ff4262e2147"]
use SQL
arecordno = [168701]
cookietok=[WB_userid=bilmax21;]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
procsql() fixcookietok=[conf_WB_userid="bilmax21"]
wbt_stdcgiheader: username=[bilmax21]
cookietok=[remuserappmode=ADMIN;]
auser = [bilmax21]
apassword=[0x101e1ff4262e2147]
arecordno = [168701]
userpwdes=[0x101e1ff4262e2147]
apassword = [0x101e1ff4262e2147]
procsql() sqloutf=[/tmp/sqlout12580_1] sqlerrf=[/tmp/sqlerr12580_1] sqlprocf=[/tmp/sqlproc12580_1] apasswdsalt = [0x]
wbt_stdcgiheader: test Cookie hack

sqlid=[1] fixcookietok=[conf_remuserappmode="ADMIN"]
appmode = [ADMIN]

sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:] wbt_stdcgiheader: username=[bilmax21]
cookietok=[WBLOGINADMINEMAIL=support@transmit.com.au%3B%20helpdesk@victrack.com.au;]

apassword=[0x101e1ff4262e2147]
--- userpwdes OK ---
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: test Cookie hack
fixcookietok=[conf_WBLOGINADMINEMAIL="support@transmit.com.au; helpdesk@victrack.com.au"]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
cookietok=[WBLOGINADMINEMAILSUBJECT=Bilmax21%20Query;]
sqltype=[SELECT] wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] --- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
datfile=[Jul_2010/data/wbttop.csv] fixcookietok=[conf_WBLOGINADMINEMAILSUBJECT="Bilmax21 Query"]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jul_2010/data/wbttop.csv] wbt_stdcgiheader: appmode=[ADMIN]
cookietok=[WBLOGINADMINEMAILBODY=Please%20include%20your%20name%2C%20phone%20number%2C%0Aand%20a%20short%20description%20of%20your%20query.%0A;]
UX:ls: ERROR: Cannot access topdat/Jul_2010/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] ---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] appmode=[ADMIN]
datfile=[Dec_2010/data/wbttop.csv] fixcookietok=[conf_WBLOGINADMINEMAILBODY="Please include your name, phone number, and a short description of your query. "]
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Dec_2010/data/wbttop.csv] cookietok=[entered_username=bilmax21;]
UX:ls: ERROR: Cannot access topdat/Dec_2010/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] fixcookietok=[conf_entered_username="bilmax21"]
appmode=[ADMIN]
cookietok=[WB_recordno=168701;]
testdistid=[ # dfp_part1=[Jul_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jul_2010/data/wbttop.csv" allowaccess="1" ] testdistid=[ # dfp_part1=[Dec_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Dec_2010/data/wbttop.csv" allowaccess="1" ] fixcookietok=[conf_WB_recordno="168701"]
cookietok=[WB_loginoff=0;]
dowbttopcsv=[topdat/Jul_2010/data/wbttop.csv] dowbttopcsv=[topdat/Dec_2010/data/wbttop.csv] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) outfile=[topdat/Jul_2010/data/wbttop.csv] fixcookietok=[conf_WB_loginoff="0"]
outfile=[topdat/Dec_2010/data/wbttop.csv] allowaccess=[1] allowaccess=[1]
-------- nrows = 1 -------- cookietok=[WB_extgrid=;]

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- fixcookietok=[conf_WB_extgrid=""]

cookietok=[WB_ACCCODE=;]
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc12580_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout12580_1
rm -f /tmp/sqlerr12580_1
rm -f /tmp/sqlproc12580_1
--------------------------------- fixcookietok=[conf_WB_ACCCODE=""]

cookietok=[WB_ADMINDISABLED=]
fixcookietok=[conf_WB_ADMINDISABLED=""]
command line params:
current dir - pwd: auser = [bilmax21]

arecordno = [168701]
/u/catcom/wb/ex4_tst/comdat/common
apasswdsalt = [0x]
appmode = [ADMIN]

current user - id: wbt_stdcgiheader: username=[bilmax21]

apassword=[0x101e1ff4262e2147]
uid=1(daemon) gid=12(daemon) groups=12(daemon),1(other),2(bin),4(adm)
t Cookie hack

standard input stream: --- userpwdes OK ---
stdinput=[] wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Dec_2008/data/wbttop.csv] wbt_stdcgiheader: validate user logged in here
pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Dec_2008/data/wbttop.csv] wbt_stdcgiheader: username=[]
UX:ls: ERROR: Cannot access topdat/Dec_2008/data/wbttop.csv: No such file or directory use SQL
Login user is username=[bilmax21] appmode=[ADMIN]
procsql() testdistid=[ # dfp_part1=[Dec_2008] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Dec_2008/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Dec_2008/data/wbttop.csv]
procsql() sqloutf=[/tmp/sqlout12903_1] sqlerrf=[/tmp/sqlerr12903_1] sqlprocf=[/tmp/sqlproc12903_1] outfile=[topdat/Dec_2008/data/wbttop.csv]
sqlid=[1] allowaccess=[1]
sqlinput=[select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) ]
procfunc=[:]
sqltype=[SELECT]
sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
----------------------------------------
found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc12903_1 --------
recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout12903_1
rm -f /tmp/sqlerr12903_1
rm -f /tmp/sqlproc12903_1
---------------------------------
auser = [bilmax21]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Jun_2009/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Jun_2009/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/Jun_2009/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] appmode=[ADMIN]
testdistid=[ # dfp_part1=[Jun_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Jun_2009/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Jun_2009/data/wbttop.csv] outfile=[topdat/Jun_2009/data/wbttop.csv] allowaccess=[1] sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) sqlstmnt = select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" )
-------- nrows = 1 --------
-------- nrows = 1 --------

recordno|userid|passwd|wbd_type|
168701|bilmax21|0x101e1ff4262e2147|ADMIN|
Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1|
---------------------------------------- ----------------------------------------

found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc11836_1 -------- found Status = Status:|SQLCODE~0~OK~SQLERRD~2~0~1~13~0~340~select distinct tPerson.personid recordno, tPerson.emailaddress userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf, tPerson where wbdconf.userid = "email" and (tPerson.emailaddress = "bilmax21" or tPerson.emailaddress = "BILMAX21" or tPerson.emailaddress = "bilmax21" ) and tPerson.personid = wbdconf.recordno UNION select distinct wbdconf.recordno, wbdconf.userid, wbdconf.passwd, wbdconf.wbd_type from wbdconf where wbdconf.userid != "email" and wbdconf.userid IS NOT NULL and wbdconf.userid != " " and (wbdconf.userid = "bilmax21" or wbdconf.userid = "BILMAX21" or wbdconf.userid = "bilmax21" ) |1| NROWS=1 -------- /tmp/sqlproc11839_1 --------

recordno='168701'
userid='bilmax21'
passwd='0x101e1ff4262e2147'
wbd_type='ADMIN'
:
rm -f /tmp/sqlout11839_1
rm -f /tmp/sqlerr11839_1
rm -f /tmp/sqlproc11839_1
--------------------------------- ---------------------------------

auser = [bilmax21]
auser = [bilmax21]
arecordno = [168701]
arecordno = [168701]
apassword = [0x101e1ff4262e2147]
apassword = [0x101e1ff4262e2147]
apasswdsalt = [0x]
apasswdsalt = [0x]
appmode = [ADMIN]
appmode = [ADMIN]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: username=[bilmax21]
apassword=[0x101e1ff4262e2147]
apassword=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: test Cookie hack
wbt_stdcgiheader: test Cookie hack
--- userpwdes OK ---
wbt_stdcgiheader: username=[bilmax21]
--- userpwdes OK ---
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
wbt_stdcgiheader: username=[bilmax21]
wbt_stdcgiheader: appmode=[ADMIN]
wbt_stdcgiheader: userpwdes=[0x101e1ff4262e2147]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] wbt_stdcgiheader: appmode=[ADMIN]
---------------wbt_stdcgiheader---------------------------- username=[bilmax21] appmode=[ADMIN] wbt_stdcgi_auth_cgi=[wbt_topdat.cgi] wbt_stdcgi_auth_allow=[1] datfile=[Sep_2009/data/wbttop.csv] pwd=[/u/catcom/wb/ex4_tst] outfile=[topdat/Sep_2009/data/wbttop.csv] datfile=[Feb_2010/data/wbttop.csv] UX:ls: ERROR: Cannot access topdat/Sep_2009/data/wbttop.csv: No such file or directory UX:ls: ERROR: Cannot access topdat/Feb_2010/data/wbttop.csv: No such file or directory Login user is username=[bilmax21] appmode=[ADMIN]
appmode=[ADMIN]
testdistid=[ # dfp_part1=[Sep_2009] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Sep_2009/data/wbttop.csv" allowaccess="1" ] testdistid=[ # dfp_part1=[Feb_2010] # dfp_part2=[data] # dfp_part3=[wbttop.csv] # dfp_part4=[] # dfp_part5=[] allowaccess="0" dowbttopcsv="n/a" # ADMIN USER - allow all dowbttopcsv="topdat/Feb_2010/data/wbttop.csv" allowaccess="1" ] dowbttopcsv=[topdat/Sep_2009/data/wbttop.csv] dowbttopcsv=[topdat/Feb_2010/data/wbttop.csv] outfile=[topdat/Sep_2009/data/wbttop.csv] outfile=[topdat/Feb_2010/data/wbttop.csv] allowaccess=[1] allowaccess=[1]