3/31/2015 5:56:25 PM;phil;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\phil\workfiles;;;;;;;
3/31/2015 5:56:25 PM;phil;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\phil\Queries;;;;;;;
3/31/2015 5:56:25 PM;phil;appuser.GetQuery;phil;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;;;;;;
3/31/2015 5:56:25 PM;phil;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;;;;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;AllocStmt;15725312;;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;SetAsyncMode;0;;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;ExecDirect;rc=0;;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;GetNumRows;rc=0;numrows=0;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;GetColInfo; NumCols=1;;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;Fetch started;;;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;Fetch reached end after 0 rows;;;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;SQLDiagRec;FetchOne;0;SQLState=;;;
3/31/2015 5:56:25 PM;phil;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;rows=0;cols=1;elapsed=0.02;;;;
3/31/2015 5:56:25 PM;db=1=;stmt=9;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0312519 Prepare=0 ExecDirect=0.0156253 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 5:56:28 PM;phil;dbsignon - page load;;;;;;;;
3/31/2015 5:56:28 PM;phil;dbsignon > loadsignons;;;;;;;;
3/31/2015 5:56:28 PM;phil;appuser.GetQuery;phil;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;;;;;;
3/31/2015 5:56:28 PM;phil;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;;;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;AllocStmt;707324144;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;SetAsyncMode;0;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;ExecDirect;rc=0;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;GetNumRows;rc=0;numrows=1;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;GetColInfo; NumCols=10;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Description,type=12,bind=C,prec=100,buflen=101;colno=3,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=4,NeedsUserPass,type=1,bind=C,prec=1,buflen=2;colno=5,DatabaseType,type=1,bind=C,prec=1,buflen=2;colno=6,CfgFile,type=12,bind=C,prec=20,buflen=21;colno=7,ShowReports,type=1,bind=C,prec=1,buflen=2;colno=8,ShowDatabase,type=1,bind=C,prec=1,buflen=2;colno=9,ShowSQL,type=1,bind=C,prec=1,buflen=2;colno=10,ShowFiles,type=1,bind=C,prec=1,buflen=2;;Tot bytes alloc=227;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;Fetch started;;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;Fetch reached end after 1 rows;;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;SQLDiagRec;FetchOne;0;SQLState=;;;
3/31/2015 5:56:28 PM;phil;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;rows=1;cols=10;elapsed=0.03;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=10;CloseQuery;Query statistics: Fetches=1 GetData=0 Elapsed=0.0312501 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 5:56:28 PM;phil;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
3/31/2015 5:56:28 PM;phil;appuser.GetQuery;phil;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;;;;;;
3/31/2015 5:56:28 PM;phil;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;;;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;AllocStmt;707324144;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;SetAsyncMode;0;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;ExecDirect;rc=0;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;GetNumRows;rc=0;numrows=1;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;GetColInfo; NumCols=7;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Userid,type=12,bind=C,prec=50,buflen=51;colno=3,DBName,type=12,bind=C,prec=50,buflen=51;colno=4,OraclePriv,type=12,bind=C,prec=50,buflen=51;colno=5,Description,type=12,bind=C,prec=100,buflen=101;colno=6,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=7,EncryptedPwd,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=386;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;Fetch started;;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;Fetch reached end after 1 rows;;;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;SQLDiagRec;FetchOne;0;SQLState=;;;
3/31/2015 5:56:28 PM;phil;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;rows=1;cols=7;elapsed=0.03;;;;
3/31/2015 5:56:28 PM;db=1=;stmt=11;CloseQuery;Query statistics: Fetches=1 GetData=0 Elapsed=0.031251 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0.0156254 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 5:56:42 PM;phil;appuser.GetQuery;troy;Query querysignon: Select EncryptedPassword from Users where UserName='troy';;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;AllocStmt;15725312;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;SetAsyncMode;0;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;ExecDirect;unicode=False;Select EncryptedPassword from Users where UserName='troy';;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;ExecDirect;rc=0;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;GetNumRows;rc=0;numrows=1;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;GetColInfo; NumCols=1;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;Bindcols;colno=1,EncryptedPassword,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;Fetch started;;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;Fetch reached end after 1 rows;;;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;SQLDiagRec;FetchOne;0;SQLState=;;;
3/31/2015 5:56:42 PM;phil;GetDataColl;Select EncryptedPassword from Users where UserName='troy';rows=1;cols=1;elapsed=0.02;;;;
3/31/2015 5:56:42 PM;db=1=;stmt=12;CloseQuery;Query statistics: Fetches=1 GetData=0 Elapsed=0.0156229 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
3/31/2015 5:56:42 PM;phil;do_dec ;password= ;troy;;;;;;
4/14/2015 5:58:13 PM;aqtdb path=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;;;;;;;;
4/14/2015 5:58:13 PM;aqtdb version=C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\aqtweb\0e6c774c\e7062279\assembly\dl3\16733391\7b8e989b_fc2ccf01\aqtdbinterface.dll;1.0.4884.37408;32-bit mode;;;;;;;;
4/14/2015 5:58:13 PM;phil;-------------------- Session Starts --------------------;;;;;;;;
4/14/2015 5:58:13 PM;phil;Options;UseDSNConnections=y,ShowFavOnStart=y,ODBCMode=n,SupportAS400SysNamingConvention=n,NewTab=y,MenuStyle=Windows7,ToolbarStyle=Windows7,MultQueries=n,MultQueries2=n,MultQueriesBlankRow=y,AutoSaveQueries=n,Delimiter=;,RemoveComments=y,EnableUserParms=y,UserParmChar=$,MaxRows=1000,MaxColSize=1000,ShowGroupBy=y,ShowRowNumbers=y,RightTrim=y,NullFormat=(null),ShowVarcharLen=n,DateFormatV9=yyyy-MM-dd,TimeFormatV9=HH:mm:ss,DateFormatInformixV9=yyyy-MM-dd,TimeFormatInformixV9=HH:mm:ss,ShowZeroTime=n,ShowRowID=n,BinaryDisplay=2,ConvertEBCDIC=n,WriteBlobsToFiles=n,ShowBlobs=n,ShowClobs=n,ShowVarchar=n,ExcludeBLOBs=n,AsyncMode=2,QuoteNames=n,UncommittedRead=y,UseParms=N,AutoCommit=y,CommitAfterEachQuery=n,UseExecDirect=n,UnicodeMode=y,UnicodeCols=n,BindColsToStrings=n,UseGetDataAll=n,DeferredPrepare=n,ContinueOnFetchError=n,IDMSAccessCode=,IDMSAccessPlan=,ShowAllCons=n,ShowDNSCons=n,HistFile=aqt_history.txt,HistDiffName=n,HistIncScript=n,HistIncUpd=n,HistIncSearch=n,AuditEnabled=n,AuditDir=\audit,AuditFile=aqt_audit_yyyymmdd.txt,AuditSepFiles=n,AuditSelectStatements=n,AuditQueryResults=n,AuditRows=50,AuditRowLength=1000,DefDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\phil\workfiles,CfgDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\cfg,QueryDir=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\phil\Queries,HistDir=,DSNdirectory=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\DSNs,ReadOnlyMode=n,debug=y,debugDB=y,debugfile=E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\phil\aqtdebug2.txt,DisableSavePwd=n,ErrorLog=errorlog.txt,RunSQL=n,CharTstamps=n,EnforceSafeMode=n,SafeMode=n,SafeModeRem=n,SafeModeNumber=1,RowCount=n,ReplaceHex00=n,PromptTranMode=n,GridFormatForNumeric=y,ShowUserName=n,UseTOCHARWithOracleTstamps=y,PostgreSQLSetLimit=n,UseOracleServerName=n,OracleReplaceCRLF=y,QualifyUnqualifedTabNames=y,OnlyLookatUDRs=n,MultResult=n,NumHistEntries=20,EncryptPasswords=false;;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.SetupUser;Set work directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\phil\workfiles;;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.SetupUser;Set query directory: E:\HostingSpaces\cardett\webdbtool.com\wwwroot\UQT\userfiles\phil\Queries;;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.GetQuery;phil;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.GetQuery;Query queryautodb: Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;AllocStmt;714614440;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;SetAsyncMode;0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;ExecDirect;unicode=False;Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;ExecDirect;rc=0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;GetNumRows;rc=0;numrows=0;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;GetColInfo; NumCols=1;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;Fetch started;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;Fetch reached end after 0 rows;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:13 PM;phil;GetDataColl;Select `Database` from DatabaseAccess where UserName = 'phil' and AutoSignon=true;rows=0;cols=1;elapsed=0.03;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=19;CloseQuery;Query statistics: Fetches=0 GetData=0 Elapsed=0.0313023 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:13 PM;phil;dbsignon - page load;;;;;;;;
4/14/2015 5:58:13 PM;phil;dbsignon > loadsignons;;;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.GetQuery;phil;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.GetQuery;Query querydblist: Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;AllocStmt;714616696;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;SetAsyncMode;0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;ExecDirect;unicode=False;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;ExecDirect;rc=0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;GetNumRows;rc=0;numrows=1;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;GetColInfo; NumCols=10;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Description,type=12,bind=C,prec=100,buflen=101;colno=3,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=4,NeedsUserPass,type=1,bind=C,prec=1,buflen=2;colno=5,DatabaseType,type=1,bind=C,prec=1,buflen=2;colno=6,CfgFile,type=12,bind=C,prec=20,buflen=21;colno=7,ShowReports,type=1,bind=C,prec=1,buflen=2;colno=8,ShowDatabase,type=1,bind=C,prec=1,buflen=2;colno=9,ShowSQL,type=1,bind=C,prec=1,buflen=2;colno=10,ShowFiles,type=1,bind=C,prec=1,buflen=2;;Tot bytes alloc=227;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;Fetch started;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;Fetch reached end after 1 rows;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:13 PM;phil;GetDataColl;Select a.`Database`, b.Description, a.ReadOnly, b.NeedsUserPass, b.DatabaseType, b.CfgFile, a.ShowReports, a.ShowDatabase, a.ShowSQL, a.ShowFiles from DatabaseAccess a, `Database` b WHERE UserName in ('phil','dev') and a.`Database`=b.DatabaseName;rows=1;cols=10;elapsed=0.03;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=20;CloseQuery;Query statistics: Fetches=1 GetData=0 Elapsed=0.0312527 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:13 PM;phil;aqtdbsignon > SetUpDsnSignons: dbSignonColl collection = 0;;;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.GetQuery;phil;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;;;;;;
4/14/2015 5:58:13 PM;phil;appuser.GetQuery;Query queryselrecent: Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;AllocStmt;714616696;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;SetAsyncMode;0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;ExecDirect;unicode=False;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;ExecDirect;rc=0;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;GetNumRows;rc=0;numrows=1;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;GetColInfo; NumCols=7;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;Bindcols;colno=1,Database,type=12,bind=C,prec=50,buflen=51;colno=2,Userid,type=12,bind=C,prec=50,buflen=51;colno=3,DBName,type=12,bind=C,prec=50,buflen=51;colno=4,OraclePriv,type=12,bind=C,prec=50,buflen=51;colno=5,Description,type=12,bind=C,prec=100,buflen=101;colno=6,ReadOnly,type=1,bind=C,prec=1,buflen=2;colno=7,EncryptedPwd,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=386;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;Fetch started;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;Fetch reached end after 1 rows;;;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:13 PM;phil;GetDataColl;Select a.`Database`, a.Userid, a.DBName, a.OraclePriv, b.Description, c.ReadOnly, a.EncryptedPwd FROM RecentSignons a, `Database` b, DatabaseAccess c WHERE a.`Database` = b.DatabaseName AND a.UserName = c.UserName AND a.`Database` = c.`Database` AND a.UserName='phil' ORDER BY ConnectTime desc;rows=1;cols=7;elapsed=0.03;;;;
4/14/2015 5:58:13 PM;db=1=;stmt=21;CloseQuery;Query statistics: Fetches=1 GetData=0 Elapsed=0.0312476 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0.0156225 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:33 PM;phil;appuser.GetQuery;troy;Query querysignon: Select EncryptedPassword from Users where UserName='troy';;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;AllocStmt;714618752;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;SetAsyncMode;0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;ExecDirect;unicode=False;Select EncryptedPassword from Users where UserName='troy';;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;ExecDirect;rc=0;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;GetNumRows;rc=0;numrows=1;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;GetColInfo; NumCols=1;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;Bindcols;colno=1,EncryptedPassword,type=12,bind=C,prec=50,buflen=51;;Tot bytes alloc=55;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;Fetch started;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;Fetch reached end after 1 rows;;;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;SQLDiagRec;FetchOne;0;SQLState=;;;
4/14/2015 5:58:33 PM;phil;GetDataColl;Select EncryptedPassword from Users where UserName='troy';rows=1;cols=1;elapsed=0.03;;;;
4/14/2015 5:58:33 PM;db=1=;stmt=22;CloseQuery;Query statistics: Fetches=1 GetData=0 Elapsed=0.0312544 Prepare=0 ExecDirect=0 Execute=0 Fetch (total)=0 Fetch (getting data from dbs)=0 GetData (total)=0 GetData (getting data from dbs)=0 NextResults (checking for another result-set)=0;;;;;
4/14/2015 5:58:33 PM;phil;do_dec ;password= ;troy;;;;;;