ATDB How to use ATDB     Preferences     Subscribe     Tips & Q&A 
You're not logged on
Username:
Password:

35.172.224.102
Visitor - restrictions applyAeroFinder ] [ QueryBuilder ] [ QueryEvents ] [ QueryNews ] [ Help ]

Session limits exceeded for this week
Please subscribe for immediate access


TRACES:


timeline.php
get: operatorID value: 104940
any_sql: set names 'utf8'
->


Entering cookie2php for ATDB5logon: no cookie exists
ATDB5logon cookie values:
env[]=

Entering racf_check memory=1532480
racf 1: ATDB5logon cookie not found
getIP found IP=35.172.224.102
racf 2: Current IP is 35.172.224.102
racf 2.1: currentIP=35.172.224.102, currentIPmask=35.172.224., previousIP=unknown
racf 3: No logon cookie could be used for this session: First visit, cookie erased or previous logon failed
any_sql: select ifnull(max(logon),'') from atdb5_sessions where ip_address='35.172.224.102' and (to_days(current_date) - to_days(logon) < 7) union all select ifnull(max(logon),'') from atdb5_sessions where ip_address like '35.172.224.%' and (date_add(logon, interval 1 hour) > '2022-12-05 19:18:11') order by 1 desc limit 1
-> 2022-12-03 02:51:38

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)int(10)string(765)
1 PRIMARY atdb5_sessions ref atdb5_sessions_ip_address atdb5_sessions_ip_address 137 const 2 Using index condition; Using where
2 UNION atdb5_sessions range atdb5_sessions_ip_address atdb5_sessions_ip_address 137   2 Using index condition; Using where
  UNION RESULT ALL           Using filesort


racf 3.3: A record was found in session_table for IP=35.172.224.102 within last 7 days or last hour
any_sql: select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address='35.172.224.102' and logon='2022-12-03 02:51:38' union all select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address like '35.172.224.%' and logon='2022-12-03 02:51:38' order by 1 desc limit 1
-> 1670263766172035&V00000000

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)int(10)string(765)
1 PRIMARY atdb5_sessions ref atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_logon 8 const 1 Using where
2 UNION atdb5_sessions ref atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_logon 8 const 1 Using where
  UNION RESULT ALL           Using filesort


writeLogonInfo entered - fcode=c,currentIP=35.172.224.102,customerID=none
writeLogonInfo - Generated keys: IP=35.172.224.102 -> New SessionID=1670264291172035
writeLogonInfo - now=1670264291 , now2=2022-12-05 19:18:11 , cookieExpiry=1670523491
writeLogonInfo - writing cookie:
sid=1670264291172035&custID=none&logon=1670264291&profile=V00000000&ip1=035&ip2=172&userIP=35.172.224.102&racf=4108050209
ccdomain=.aerotransport.org
racf 3.3.1: Wrote new cookie, new SID=1670264291172035 profile=V00000000
any_sql: update atdb5_sessions /* s12 */ set session_id='1670264291172035' where session_id='1670263766172035'
-> 1

racf 3.3.2: Session table updated old SID=1670263766172035 -> new SID=1670264291172035 for IP 35.172.224.102
racf 3 completed
checkCPU entered: IP=35.172.224.102,SID=1670264291172035,userid=,profile=V00000000
any_sql: select concat(sum(queries),'&',sum(requests),'&',sum(sql_cpu),'&',sum(sql_rows),'&',min(substring(profile,1,1))) from atdb5_sessions where ip_address='35.172.224.102' /* and customer_id='none' */ and (to_days(current_date) - to_days(logon) < 7) limit 1
-> 10&20&0.11&96&V

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)int(10)string(765)
1 SIMPLE atdb5_sessions ref atdb5_sessions_ip_address atdb5_sessions_ip_address 137 const 2 Using index condition; Using where


checkCPU for this visitor: used_queries=10, used_requests=20, used_cpu=0.11, used_rows=96, profile=V


Entering htmlHeader, HTML length=90
getIP found IP=35.172.224.102
htmlTopBanner: ID=, username=, profile=V00000000

Entering racf_account - SID=1670264291172035, query=
Used for this page: Query=1 Requests=0, Rows=0, CPU=0
No request issued, no resources used
racf_account completed

END TRACES

ENV:
Array
(
    [debug] => 1
    [trace] => 
    [maxDebugMinutes] => 45
    [V] => 6
    [charset] => UTF-8
    [serverURL] => Array
        (
            [0] => aerotransport.org
            [1] => atdb.aero
            [2] => aerotran.o2switch.net
            [3] => aavrane.free.fr
        )

    [root] => https://www.aerotransport.org/
    [home] => https://www.aerotransport.org
    [base] => https://www.aerotransport.org/php/go.php
    [spooled] => ../spooled/
    [DBAemail] => webmaster@aerotransport.org
    [DBAdomain] => *.net1.nerim.net
    [emergencyMirror] => www2.aerotransport.org
    [allowVisitors] => 1
    [DBAonly] => 0
    [server_archive] => 1
    [archiveURL] => http://aavrane.free.fr/aerotransport/V5/
    [maxMemory] => 400000000
    [price_U12] => 75
    [price_E12] => 120
    [price_P1] => 130
    [price_P12] => 1300
    [price_R12] => 1800
    [blackFriday] => 
    [price_U12_regular] => 75
    [price_E12_regular] => 120
    [price_P1_regular] => 130
    [price_P12_regular] => 1300
    [price_R12_regular] => 1800
    [u] => 
    [p] => 
    [profile] => V00000000
    [userid] => 
    [username] => 
    [sid] => 1670264291172035
    [userIP] => unknown
    [lang] => EN
    [client_os] => 
    [client_cpu] => 
    [client_browser] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [maxHTMLrows] => 35
    [maxXLSrows] => 10000
    [maxpictures] => 50
    [partners] => *AJPEHFCSDNMBRX
    [maxSessionHours] => 72
    [maxSessionQueries] => 400
    [maxSessionRequests] => 900
    [maxSessionRows] => 9000
    [thisQueryRequests] => 0
    [thisQueryRows] => 0
    [thisQueryCPU] => 0
    [maxSavedQueries] => 40
    [thisUserQueries] => 0
    [maxTrialQueries] => 3500
    [maxTrialRequests] => 6000
    [maxTrialRows] => 30000
    [maxTrialThreshold] => 0.7
    [maxQuotaU] => 25000
    [maxQuotaE] => 40000
    [maxWeeklyQueries] => 9
    [maxWeeklyRequests] => 50
    [maxWeeklyRows] => 300
    [old2news] => 150
    [warningExpiry] => 12
    [graceDays] => 1
    [logonRetryCount] => 0
    [logonRetryMax] => 5
    [logonRetrySleep] => 20
    [logonRetryLast] => 0
    [maxDomainsWarning] => 3
    [maxDomainsReset] => 5
    [allowHotlinks] => 1
    [allowForeignFrames] => 0
    [automaticPasswordReset] => 1
    [automaticRevoke] => 1
    [enableLogs] => 1
    [enableEncryption] => 1
    [savedQueries] => 300
    [savedVisitorsQueries] => 30
    [blacklist] => erased
    [blackdomains] => Array
        (
            [0] => flightglobal.com
            [1] => rbi.co.uk
            [2] => rbinet.co.uk
            [3] => airclaims
            [4] => impots.gouv.fr
            [5] => cirium.com
            [6] => hwclouds-dns.com
            [7] => petalsearch.com
            [8] => mts-internet.net
        )

    [sampleSpreadsheet] => extant MD-11 in Europe
    [dd_maxFleetSize] => 30
    [] => 
    [pref_bgcolor] => #ffffff
    [pref_fsize] => x-small
    [pref_dateformat] => d/m/y
    [pref_xpl_built] => 0
    [pref_target] => target=_self
    [pref_maxrecords] => 35
    [pref_partners] => 1
    [pref_no2pict] => 0
    [pref_no2regs] => 0
    [pref_no2safe] => 0
    [pref_unit] => kg
    [ru00_mode] => 21
    [ru10_x_forwarded_for] => 
    [ru20_remote_addr] => 35.172.224.102
    [ru30_http_client_ip] => 
    [ru40_x_forwarded_for] => 
    [ru50_remote_addr] => 
    [ru60_http_client_ip] => 35.172.224.102
    [default_fsize] => x-small
    [phone] => 0
)

memory at end: 1549504

V6 © 1997-2022 AeroTransport Data Bank