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

44.197.230.180
Visitor - restrictions apply[ AeroFinder ] [ QueryBuilder ] [ QueryEvents ] [ QueryNews ] [ Help ]

Session limits exceeded for this week
Please subscribe for immediate access

TRACES:


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

Entering cookie2php for ATDB5logon: no cookie exists
ATDB5logon cookie values:
env[]=
Entering racf_check memory=1530872
racf 1: ATDB5logon cookie not found
getIP found IP=44.197.230.180
racf 2: Current IP is 44.197.230.180
racf 2.1: currentIP=44.197.230.180, currentIPmask=44.197.230., 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='44.197.230.180' and (to_days(current_date) - to_days(logon) < 7) union all select ifnull(max(logon),'') from atdb5_sessions where ip_address like '44.197.230.%' and (date_add(logon, interval 1 hour) > '2022-08-15 12:52:20') order by 1 desc limit 1
-> 2022-08-15 10:59:54

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 1 Using index condition; Using where
2 UNION atdb5_sessions range atdb5_sessions_ip_address atdb5_sessions_ip_address 137   1 Using index condition; Using where
  UNION RESULT ALL           Using filesort


racf 3.3: A record was found in session_table for IP=44.197.230.180 within last 7 days or last hour
any_sql: select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address='44.197.230.180' and logon='2022-08-15 10:59:54' union all select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address like '44.197.230.%' and logon='2022-08-15 10:59:54' order by 1 desc limit 1
-> 1660560324197044&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_ip_address 137 const 1 Using index condition; Using where
2 UNION atdb5_sessions range atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_ip_address 137   1 Using index condition; Using where
  UNION RESULT ALL           Using filesort


writeLogonInfo entered - fcode=c,currentIP=44.197.230.180,customerID=none
writeLogonInfo - Generated keys: IP=44.197.230.180 -> New SessionID=1660560740197044
writeLogonInfo - now=1660560740 , now2=2022-08-15 12:52:20 , cookieExpiry=1660819940
writeLogonInfo - writing cookie:
sid=1660560740197044&custID=none&logon=1660560740&profile=V00000000&ip1=044&ip2=197&userIP=44.197.230.180&racf=4108050209
ccdomain=.aerotransport.org
racf 3.3.1: Wrote new cookie, new SID=1660560740197044 profile=V00000000
any_sql: update atdb5_sessions /* s12 */ set session_id='1660560740197044' where session_id='1660560324197044'
-> 1

racf 3.3.2: Session table updated old SID=1660560324197044 -> new SID=1660560740197044 for IP 44.197.230.180
racf 3 completed
checkCPU entered: IP=44.197.230.180,SID=1660560740197044,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='44.197.230.180' /* and customer_id='none' */ and (to_days(current_date) - to_days(logon) < 7) limit 1
-> 10&34&0.06&183&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 1 Using index condition; Using where


checkCPU for this visitor: used_queries=10, used_requests=34, used_cpu=0.06, used_rows=183, profile=V

Entering htmlHeader, HTML length=90
getIP found IP=44.197.230.180
htmlTopBanner: ID=, username=, profile=V00000000
Entering racf_account - SID=1660560740197044, 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] => 60
    [price_E12_regular] => 110
    [price_P1_regular] => 120
    [price_P12_regular] => 1200
    [price_R12_regular] => 1700
    [u] => 
    [p] => 
    [profile] => V00000000
    [userid] => 
    [username] => 
    [sid] => 1660560740197044
    [userIP] => unknown
    [lang] => EN
    [client_os] => 
    [client_cpu] => 
    [client_browser] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [maxHTMLrows] => 35
    [maxXLSrows] => 10000
    [maxpictures] => 50
    [partners] => *AJPEHFCSDNMBGRX
    [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] => 44.197.230.180
    [ru30_http_client_ip] => 
    [ru40_x_forwarded_for] => 
    [ru50_remote_addr] => 
    [ru60_http_client_ip] => 44.197.230.180
    [default_fsize] => x-small
    [phone] => 0
)

memory at end: 1547968

V6 © 1997-2022 AeroTransport Data Bank