URLs don't get logged

nottinghub · Joined: 31 Mar 2012 Posts: 15

Hi,

I am using FS 7.0.6 on Win 2008 64-bit and mySQL 6.0.9

I have enabled URL tracking for Standard Ports under "Access Control". When I click on show URL Log, the log is empty. There's no urldata_timestamp.csv file in the FirstSpot\log directory.

What am I missing??

Here's an extract of part of my config.ini:
;
; Description : FirstSpot setting ini file
;
; Filename : config.ini
;

; Note: use a backslash to separate directories and files, those lines starting with
; a semi-colon is considered as comment.
;
; Warning : please don't change this file without supervision of a PatronSoft Engineer
; It is highly recommended that you change the FirstSpot setting in the Web-based Configuration Manager

[version]
version=Premium
versionDesc=7.0.6
versionLang=English

[MNS]
; number of return paths
num_return_path=0
return_path0=

[DHCP]
leasetime=2880
num_ignored_addr=67
ignore_addr0=192.168.192.159
ignore_addr1=192.168.192.160
ignore_addr2=192.168.192.161
ignore_addr3=192.168.192.162
ignore_addr4=192.168.192.163
ignore_addr5=192.168.192.164
ignore_addr6=192.168.192.165
ignore_addr7=192.168.192.166
ignore_addr8=192.168.192.167
ignore_addr9=192.168.192.168
ignore_addr10=192.168.192.169
ignore_addr11=192.168.192.170
ignore_addr12=192.168.192.171
ignore_addr13=192.168.192.172
ignore_addr14=192.168.192.173
ignore_addr15=192.168.192.174
ignore_addr16=192.168.192.175
ignore_addr17=192.168.192.176
ignore_addr18=192.168.192.177
ignore_addr19=192.168.192.178
ignore_addr20=192.168.192.179
ignore_addr21=192.168.192.180
ignore_addr22=192.168.192.181
ignore_addr23=192.168.192.182
ignore_addr24=192.168.192.183
ignore_addr25=192.168.192.184
ignore_addr26=192.168.192.185
ignore_addr27=192.168.192.186
ignore_addr28=192.168.192.187
ignore_addr29=192.168.192.188
ignore_addr30=192.168.192.189
ignore_addr31=192.168.192.190
ignore_addr32=192.168.192.191
ignore_addr33=192.168.192.192
ignore_addr34=192.168.192.193
ignore_addr35=192.168.192.194
ignore_addr36=192.168.192.195
ignore_addr37=192.168.192.196
ignore_addr38=192.168.192.197
ignore_addr39=192.168.192.198
ignore_addr40=192.168.192.199
ignore_addr41=192.168.192.200
ignore_addr42=192.168.192.201
ignore_addr43=192.168.192.202
ignore_addr44=192.168.192.203
ignore_addr45=192.168.192.204
ignore_addr46=192.168.192.205
ignore_addr47=192.168.192.206
ignore_addr48=192.168.192.207
ignore_addr49=192.168.192.208
ignore_addr50=192.168.192.209
ignore_addr51=192.168.192.210
ignore_addr52=192.168.192.211
ignore_addr53=192.168.192.212
ignore_addr54=192.168.192.213
ignore_addr55=192.168.192.214
ignore_addr56=192.168.192.215
ignore_addr57=192.168.192.216
ignore_addr58=192.168.192.217
ignore_addr59=192.168.192.218
ignore_addr60=192.168.192.219
ignore_addr61=192.168.192.220
ignore_addr62=192.168.192.221
ignore_addr63=192.168.192.222
ignore_addr64=192.168.192.223
ignore_addr65=192.168.192.224
ignore_addr66=192.168.192.225

[Port Filter]
flt_num=0
flt_0=

[UserPortFilter]
user_pf_size=0
flt_num1=
flt_num1_name=
flt1_0=

[QOS]
dl=
ul=
qos_num=0
qos_0=

[Client Pass]
num_mac_addr=9
mac_0=00-1E-2A-52-83-11
num_ip_addr=0
ip_0=
mac_1=84-2B-2B-89-D0-95
mac_2=A4-BA-DB-D4-6C-93
mac_3=B4-07-F9-F3-A3-13
mac_4=00-24-E8-17-5D-5E
mac_5=14-FE-B5-9D-17-83
mac_6=00-21-70-2C-72-FB
mac_7=00-10-18-32-16-05
mac_8=00-C0-EE-8B-B0-D4

[proxyARP]
ip_num=0
ip_addr0=

;
; Redirect Login Page php file
;
[loginPhp]
Login_enable0=
Login_php_Num0=

;
; Gateway Settings
;
[gateway]
;Print Log Table
Datasource_Printlog=printlog

;Shared Secret Table Name
Datasource_Shared_Secret_Tablename=fssecret

;maximum timelimit per session in minutes (global), 0 = never
sessionlimit =

;URL tracking, default off
Trace_URL=1

;URL tracking interval, do not log the same url for particular user in x mins
Trace_URL_Interval=30

;URL tracking temp table
datasource_tmp_URL_tablename=tmpurl

;extra-information field table name
Datasource_extra_field_table =aexlog

;for scenario2 communicate
Datasource_msg_Tablename=fsmsg

;for In-browser message
Datasource_ibmsg_Tablename=ibmsg

;demo_mode=on, off (default)
;
;This demo_mode parameter is for FirstSpot channel partners demonstration purpose
;If demo_mode=on, FirstSpot DNS Server and Web Server will perform a catch-all on all
;requests. After the user login, the client will always see the "firstspotdemo" page.
demo_mode=off

;redirect user to cart.php when login fails
redirect_cart=1

;Client Isolation, NetBIOS over TCP/IP, Default is Disabled
netbios=0

;Scenario 2 (Distributed Network Topology)
scenario2=0

;FirstSpot Site ID
siteID=

; Post-Startup Batch File Path Name
batch_filePath =

; lan's subnet mask (please change this through Configuration Manager only)
;
subnet_mask =255.255.0.0

; domain name server IP address
;
DNS =0.0.0.0

; domain name server IP address
;
preferred_DNS =0.0.0.0

; domain name server IP address
;
alternate_DNS =0.0.0.0

; username
;
user =firstspot

; password
;
pass =f5c5b39651776e6cf2b09522ac666f42

;Number of maximum administrator account
max_admin_account = 30

;Administrator username
admin_username0 =eid101b
admin_username1 =admin
admin_username2 =
admin_username3 =
admin_username4 =
admin_username5 =
admin_username6 =
admin_username7 =
admin_username8 =
admin_username9 =
admin_username10 =
admin_username11 =
admin_username12 =
admin_username13 =
admin_username14 =
admin_username15 =
admin_username16 =
admin_username17 =
admin_username18 =
admin_username19 =
admin_username20 =
admin_username21 =
admin_username22 =
admin_username23 =
admin_username24 =
admin_username25 =
admin_username26 =
admin_username27 =
admin_username28 =
admin_username29 =

;Administrator password
admin_password0 =8689f761afbc77f763ada976c524a0ce
admin_password1 =f5c5b39651776e6cf2b09522ac666f42
admin_password2 =
admin_password3 =
admin_password4 =
admin_password5 =
admin_password6 =
admin_password7 =
admin_password8 =
admin_password9 =
admin_password10 =
admin_password11 =
admin_password12 =
admin_password13 =
admin_password14 =
admin_password15 =
admin_password16 =
admin_password17 =
admin_password18 =
admin_password19 =
admin_password20 =
admin_password21 =
admin_password22 =
admin_password23 =
admin_password24 =
admin_password25 =
admin_password26 =
admin_password27 =
admin_password28 =
admin_password29 =

;Administrator parameter
admin_parameter0 =admin,acl,an,a,bcreate,flt,m,cc,dhcp,d,er,e,fo,ibmsg,key,r,nat,p,report,s,cart,sstatus,lang,u,vhosts
admin_parameter1 =admin,acl,an,a,bcreate,flt,m,cc,dhcp,d,er,e,fo,ibmsg,key,r,nat,p,report,s,cart,sstatus,lang,u,vhosts
admin_parameter2 =
admin_parameter3 =
admin_parameter4 =
admin_parameter5 =
admin_parameter6 =
admin_parameter7 =
admin_parameter8 =
admin_parameter9 =
admin_parameter10 =
admin_parameter11 =
admin_parameter12 =
admin_parameter13 =
admin_parameter14 =
admin_parameter15 =
admin_parameter16 =
admin_parameter17 =
admin_parameter18 =
admin_parameter19 =
admin_parameter20 =
admin_parameter21 =
admin_parameter22 =
admin_parameter23 =
admin_parameter24 =
admin_parameter25 =
admin_parameter26 =
admin_parameter27 =
admin_parameter28 =
admin_parameter29 =

; network interface card connected to Internet (after modify this, need to restart FirstSpot)
;
publicNIC=NIC Upper WAN

; network interface card connected Hotspots or visitor-based networks (after modify this, need to bind the FirstHop driver
; to this new card and unbind the FirstHop driver from ALL other cards, then reboot Windows)
;
privateNIC=NIC Lower Visitor Network

; data source for user login
;
Datasource =E:\DATA\_FirstSpot\_FirstSpot Customization\MySQL Stuff\DSN\first_dsn.dsn

; datasource table for user login
;
Datasource_Tablename = fsusr

; datasource table for user login
Datasource_Plans_Tablename = fsplans

; enable session logging into the datasource log table
session_log =ON

; datasource table for user session logging
;
Datasource_Log_Tablename = fsusrlog

; datasource table for PayPal
;
Datasource_PayPal_Table=ppal

; port used by Gateway Service
;
port =5786

; port used by Authentication Server
;
auth_port =5788

; port used by ssl site
;
ssl_port =5789

; Greeting message displayed in login page
;
greeting_msg =Welcome to our Hotspot!

; Enable to show InfoBox
;
show_infobox =ON

; Logout automatically when Infobox is closed
;
check_infobox_closed =off

; port used by infobox
;
infobox_port =5795

; for client's browser not fully support popup infobox (detect by user agent)
;
not_support_popup_option =1

; login page filename which dispatcher will call
;
loginpage =login_select.php

; login form filename which login_select.php will call
;
loginform =login_form.php

; anonymous login form filename which login_select.php will call
;
a_loginform =alogin_form.php

; idle time (minutes) allowed for authenticated users
;
idle_timeout =60

; gateway IP address (please change this through Configuration Manager only)
;
gateway_IP =192.168.192.1

; allow access to config manager from private network?
;
access_from_private =ON

; allow access to config manager from public network?
;
access_from_public =ON

; license file path
;
licensepath =C:\Program Files (x86)\FirstSpot\

; session handling mode, 0 for MAC-based, 1 for IP-based
session_handling =0

; path for dhcp config
dhcppath =C:\Program Files (x86)\FirstSpot\dhcp\dhcpservice.ini

; dhcp mode, 0 = auto, 1 = static, 2 = disabled
dhcpmode =0

; for static dhcp only, path of the Ip MAC mapping list
static_dhcp_path =C:\Program Files (x86)\FirstSpot\StaticDHCP.txt

; anonymous login
anonymous_login =off

; secret enable
secret_enable=off

; secret code
secret_code=0aed120c6f7090a5b26a4c93df382b21

; anonymous login user table name
Datasource_Anonymous_Tablename =fsa

; anonymous login log table name
Datasource_Anonymous_Log_Tablename =fsalog

; password offloading mode
pwd_offload =off

; password encryption directory path
encrypt_path =C:\Program Files (x86)\FirstSpot\dispatcher\encrypt_pwd.exe

; initial air time in minutes for self signup users
self_sign_up_credit=0

; initial plan for self signup users
self_sign_up_plan=

; self signup option
self_sign_up_option=0
self_sign_up_redirect=http://www.google.com

; self signup filtering
self_signup_filter=1

; null=no filter, 0 = signup once, >0 after x mins
self_signup_period=

; 1=not show sign up form
self_signup_not_show_form=0

;CAPTCHA option
self_sign_up_captcha_check=on
login_captcha_check=off

;use 3 party ssl cert 0=yes 1=no
ssl_cert=1

;secure socket layer for authentication
;443 for enabled SSL, auth_port=ssl_auth_port for disabled ssl
ssl_auth_port=5788

;rewrite engine for http to https redirection
rewrite_engine=off

;maximum fail attempt allowed
max_attempt=

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Did you change the setting under Configuration Manager UI? Have you restarted FirstSpot?
_________________
~ Patronsoft Limited ~

nottinghub · Joined: 31 Mar 2012 Posts: 15

yes, I changed the setting under Configuration Manager UI. I restarted the server to be sure....still no log

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

This is not normal. Can you switch back to the default datasource temporary as a test?
_________________
~ Patronsoft Limited ~

nottinghub · Joined: 31 Mar 2012 Posts: 15

Same thing. I switched to the original C:\Program Files (x86)\FirstSpot\datasource\firstspot.dsn; then restarted FS. Still no log in the log folder, clicking on "Show URL" also shows empty log.

what else should I try?

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Can you post your log file firstspot_gw_srv_[timestamp].log file under FirstSpot\log directory?
_________________
~ Patronsoft Limited ~

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Also. please try :

1) shutdown FirstSpot
2) replace tmpurl.dbf under datasource directory with the "blank" file from the original setup zip file
3) start FirstSpot
_________________
~ Patronsoft Limited ~

nottinghub · Joined: 31 Mar 2012 Posts: 15

11/04/2012 16:08:22 ** Starting Print Log **
11/04/2012 16:08:22 ** FirstSpot Version (7.0.6) **
11/04/2012 16:08:22 ** Service: Read Session Log: Session Log[ON]
11/04/2012 16:08:22 ** Service: Read DataBase Info: Datasource[FILEDSN=E:\DATA\_FirstSpot\_FirstSpot Customization\MySQL Stuff\DSN\first_dsn.dsn;]
11/04/2012 16:08:22 ** Service: Read DataBase Info: Datasource driver[MySQL ODBC 3.51 Driver]
11/04/2012 16:08:22 ** Service: Read DataBase Info: Datasource type[1]
11/04/2012 16:08:22 ** Service: Read DataBase Info: Datasource Tablename[fsusr]
11/04/2012 16:08:22 ** Service: Read DataBase Info: Datasource Log Tablename[fsusrlog]
11/04/2012 16:08:22 ** Service: Read DataBase Info: Datasource Shared Secret Tablename[fssecret]
11/04/2012 16:08:22 ** Service: Read DataBase Info: Datasource IB Msg Tablename[ibmsg]
11/04/2012 16:08:22 ** Service: PrivateMAC[00195b706185]
11/04/2012 16:08:22 ** Service: Read BlockICMP_UDP: Block ICMP[ON]
11/04/2012 16:08:22 ** Service: Read BlockICMP_UDP: Block UDP[ON]
11/04/2012 16:08:22 ** Service: Read Driver Param: Session Time Limit[0]
11/04/2012 16:08:22 ** Service: Read Driver Param: Idle time out[60]
11/04/2012 16:08:22 ** Service: Read Driver Param: Driver Time Out[1]
11/04/2012 16:08:22 ** Service: Read Driver Param: listen port[5786]
11/04/2012 16:08:22 ** Service: Read Driver Param: Authentication port[5788]
11/04/2012 16:08:22 ** Service: Read Driver Param: Https port[5790]
11/04/2012 16:08:22 ** Service: Read Driver Param: Authentication IP[192.168.192.1]
11/04/2012 16:08:22 ** Service: Read Driver Param: Fail to read private gateway domain name, default [firstspot.org]
11/04/2012 16:08:22 ** Service: Read Driver Param: Logout automatically when Infobox is closed [OFF]
11/04/2012 16:08:22 ** Service: Read Driver Param: Default Instant Keywords port[5801]
11/04/2012 16:08:22 ** Service: Read Global BandWidth Throttle: Upload Throttle is disabled
11/04/2012 16:08:22 ** Service: Read Global BandWidth Throttle: Download Throttle is disabled
11/04/2012 16:08:22 ** Service: Dynamic / Flexible bandwidth throttling [OFF]
11/04/2012 16:08:22 ** Service: Read PW Offloading [OFF]
11/04/2012 16:08:22 ** Service: Read Session Handling: [MAC]
11/04/2012 16:08:22 ** Service: Read Anonymous Login: Anonymous [NO]
11/04/2012 16:08:22 ** Service: Read Anonymous Login: AnonymousSharedSecret [NO]
11/04/2012 16:08:22 ** Service: Read Lisence Path: licensePath[C:\Program Files (x86)\FirstSpot\license.key]
11/04/2012 16:08:22 ** Service: Read IP: gatewayIP[192.168.192.1]
11/04/2012 16:08:22 ** Service: Read IP: subnetMask[255.255.0.0]
11/04/2012 16:08:22 ** Service: Read IP: privateIP[192.168.0.0]
11/04/2012 16:08:22 ** Service: ReadMultipleNetworkSegment: Login Page Count[0]
11/04/2012 16:08:22 ** Service: Read Allow Disconnect: allow private disconnect[NO]
11/04/2012 16:08:22 ** Service: Read Allow Disconnect: allow public disconnect[NO]
11/04/2012 16:08:22 ** Service: Read NIC: system default locale [409], user default locale [409]
11/04/2012 16:08:22 ** Service: Read NIC: system default UI language [409], user default UI language [409]
11/04/2012 16:08:22 ** Service: Read NIC: Current equipment manufacturer (OEM) code page [437], Current Windows ANSI code page [1252]
11/04/2012 16:08:22 ** PrintEnumUILanguagesProc: lpUILanguageString = 0409
11/04/2012 16:08:22 ** Service: Read NIC: publicNIC[NIC Upper WAN]
11/04/2012 16:08:22 ** Service: Read NIC: privateNIC[NIC Lower Visitor Network]
11/04/2012 16:08:22 ** Service: Read Allowed Hosts: hosts key words file path[C:\Program Files (x86)\FirstSpot\AllowedHostsKeywords.txt]
11/04/2012 16:08:22 ** Service: Read Allowed Hosts: hosts ip file path[C:\Program Files (x86)\FirstSpot\AllowedHostsIps.txt]
11/04/2012 16:08:22 ** Service: Read Default Login Page: [login_select.php]
11/04/2012 16:08:22 ** Service: Read DHCP: mode[0]
11/04/2012 16:08:22 ** Service: Read DHCP: DHCP Path[C:\Program Files (x86)\FirstSpot\dhcp\dhcpservice.ini]
11/04/2012 16:08:22 ** Service: Read Skip Nic D/E[Allow]
11/04/2012 16:08:22 ** Service: Packet Drop Period [20]
11/04/2012 16:08:22 ** Service: SMTP Roaming OFF
11/04/2012 16:08:22 ** Service: Read AuthServ: No MAX Attempt
11/04/2012 16:08:22 ** Service: Read Global Data Transfer Download[Enabled]
11/04/2012 16:08:22 ** Service: Read Global Data Transfer Upload[Enabled]
11/04/2012 16:08:22 ** Service: Read Global Data Transfer Download Quota[0]
11/04/2012 16:08:22 ** Service: Read Global Data Transfer Upload Quota[0]
11/04/2012 16:08:22 ** Service: URL Tracking ON
11/04/2012 16:08:22 ** Service: NAT[Enabled]
11/04/2012 16:08:22 ** Service: NAT Module [FSNAT]
11/04/2012 16:08:22 ** Service: NAT TYPE[2]
11/04/2012 16:08:22 ** Service: Read Proxy ARP Count[0]
11/04/2012 16:08:22 ** Service: FSFO: Failover [0]
11/04/2012 16:08:22 ** Service: Scenario2 Technology [OFF]
11/04/2012 16:08:22 ** Service: Read Max Conc User: Maximum number of concurrent users is unlimited
11/04/2012 16:08:22 ** Service: In-browser: iscript file's path [C:\Program Files (x86)\FirstSpot\iscript.txt]
11/04/2012 16:08:22 ** Service: In-browser: Proxy port[5796]
11/04/2012 16:08:22 ** Service: In-browser: Script port[5802]
11/04/2012 16:08:22 ** Service: In-browser: In-browser Message [ON]
11/04/2012 16:08:22 ** Service: In-browser: Top banner mode [Disable]
11/04/2012 16:08:22 ** Service: In-browser: Infobox always on [Disable]
11/04/2012 16:08:22 ** Service: In-browser Message time reminder[ON ][5]
11/04/2012 16:08:22 ** Service: Internet Surfing Break [OFF]
11/04/2012 16:08:22 ** Service: Pool: min connection [3], max connection [10]
11/04/2012 16:08:22 ** Service: Read Scratch Login: Support both Username / Password and Scratch Code login [YES]
11/04/2012 16:08:22 ** Service: Read Scratch Login: Support v6 style Scratch Code [YES]
11/04/2012 16:08:22 ** Service: Read Payment Method: [ppal]
11/04/2012 16:08:22 ** Service: Read Preferred DNS server IP for the Visitor Network [0.0.0.0]
11/04/2012 16:08:22 ** Service: Read Alternate DNS server IP for the Visitor Network [0.0.0.0]
11/04/2012 16:08:22 ** Service: Read Client Blacklist Log [ON]
11/04/2012 16:08:22 ** Service: ForwordToProxy: Forword To Proxy[OFF]
11/04/2012 16:08:22 ** Service: ReadBlackoutPeriod: Blackout Period [OFF]
11/04/2012 16:08:22 ** System Info for Verification **
11/04/2012 16:08:22 ** System Info for Verification:Microsoft Windows Server 2008 R2
11/04/2012 16:08:22 ** System Info for Verification:Server type
11/04/2012 16:08:22 ** System Info for Verification:Enterprise
11/04/2012 16:08:22 ** System Info for Verification:{Service Pack 1} (Build 7601)
11/04/2012 16:08:22 ** SUCCESS **
11/04/2012 16:08:22 ** Virtual Platform Info for Verification **
11/04/2012 16:08:22 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:22 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:22 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 16:08:22 ** Hardware Info for Verification **
11/04/2012 16:08:22 ** getHardwareInfo: using GetNativeSystemInfo
11/04/2012 16:08:22 ** Hardware Info for Verification: Number of processors: {2}
11/04/2012 16:08:22 ** Hardware Info for Verification: Page size: {4096}
11/04/2012 16:08:22 ** Hardware Info for Verification: Processor type: {16.08.22.log]
11/04/2012 16:08:22 ** Hardware Info for Verification: wProcessorLevel: {Intel Pentium Pro, II, III or 4}
11/04/2012 16:08:22 ** Hardware Info for Verification: CPU Hz {3192}MHz
11/04/2012 16:08:22 ** Hardware Info for Verification: CPU Name {Pentium(R) Dual-Core CPU E5800 @ 3.20GHz}
11/04/2012 16:08:22 ** Hardware Info for Verification: CPU Model {Intel64 Family 6 Model 23 Stepping 10}
11/04/2012 16:08:22 ** Memory Status: Total Physical Memory 3995 MBytes
11/04/2012 16:08:22 ** Memory Status: Free Physical Memory 2975 MBytes
11/04/2012 16:08:22 ** Memory Status: Total Page File 4095 MBytes
11/04/2012 16:08:22 ** Memory Status: Available Page File 4095 MBytes
11/04/2012 16:08:22 ** Memory Status: Total Virtual Memory 2047 MBytes
11/04/2012 16:08:22 ** Memory Status: Available Virtual Memory 1972 MBytes
11/04/2012 16:08:22 ** Memory Status: Total Memory Loaded 25 Bytes
11/04/2012 16:08:22 ** ReadVirturalMemSetting: Query registry (PagingFiles) = ?:\pagefile.sys
11/04/2012 16:08:22 ** Memory Mapping: [C:\Program Files (x86)\FirstSpot\log\firstspot_gw_srv_2012.04.11_16.08.22.log]
11/04/2012 16:08:22 ** verifyPublicNicStatus=>
11/04/2012 16:08:22 ** firstspotconOperation2=>
11/04/2012 16:08:22 ** firstspotconOperation2: Connection Name[NIC Upper WAN]
11/04/2012 16:08:22 ** firstspotconOperation2: Hardware Name Obtained[Broadcom NetLink (TM) Gigabit Ethernet]
11/04/2012 16:08:22 ** firstspotconOperation2: Hardware ID Obtained[PCI\VEN_14E4&DEV_1692&SUBSYS_04001028&REV_01\4&2696CBC&0&00E0]
11/04/2012 16:08:22 ** firstspotconOperation2{STA_PUBLIC_NIC}: Getting Status
11/04/2012 16:08:22 ** firstspotconOperation2{STA_PUBLIC_NIC}: Internet NIC started
11/04/2012 16:08:22 ** <=firstspotconOperation2
11/04/2012 16:08:22 ** <=verifyPublicNicStatus
11/04/2012 16:08:22 ** probePublicIP=>
11/04/2012 16:08:22 ** probePublicIP: Connection Name[NIC Upper WAN]
11/04/2012 16:08:22 ** probePublicIP: Hardware Guid Obtained[{CA1FCF23-006D-4A92-86C8-AC199FAEADAB}]
11/04/2012 16:08:22 ** <=probePublicIP
11/04/2012 16:08:22 ** validate_SubnetAddr =>
11/04/2012 16:08:22 ** validate_SubnetAddr <=
11/04/2012 16:08:22 ** EnableDisableAssignIPs=>
11/04/2012 16:08:22 ** EnableDisableAssignIPs: Skip Disable Visitor NIC
11/04/2012 16:08:22 ** EnableDisableAssignIPs: Configuring Visitor NIC
11/04/2012 16:08:22 ** is64: 64-bit
11/04/2012 16:08:22 ** IsWow64: Support IsWow64Process()
11/04/2012 16:08:22 ** is64: The process is running under WOW64.
11/04/2012 16:08:23 ** EnableDisableAssignIPs: Finished Configuring Visitor NIC
11/04/2012 16:08:23 ** EnableDisableAssignIPs: Skip Enable Visitor NIC
11/04/2012 16:08:23 ** <=EnableDisableAssignIPs
11/04/2012 16:08:23 ** verifyPrivateNicStatus=>
11/04/2012 16:08:23 ** firstspotconOperation2=>
11/04/2012 16:08:23 ** firstspotconOperation2: Connection Name[NIC Lower Visitor Network]
11/04/2012 16:08:23 ** firstspotconOperation2: Hardware Name Obtained[D-Link DFE-530TX PCI Fast Ethernet Adapter (rev.C)]
11/04/2012 16:08:23 ** firstspotconOperation2: Hardware ID Obtained[PCI\VEN_1106&DEV_3106&SUBSYS_14031186&REV_86\4&1DF304F3&0&00F0]
11/04/2012 16:08:23 ** firstspotconOperation2{STA_PRIVATE_NIC}: Getting Status
11/04/2012 16:08:23 ** firstspotconOperation2{STA_PRIVATE_NIC}: Visitor NIC started
11/04/2012 16:08:23 ** <=firstspotconOperation2
11/04/2012 16:08:23 ** <=verifyPrivateNicStatus
11/04/2012 16:08:23 entering verify NIC
11/04/2012 16:08:23 verify NIC : Internet NIC{{CA1FCF23-006D-4A92-86C8-AC199FAEADAB}}
11/04/2012 16:08:23 verify NIC : Visitor NIC{{D3BE2DBB-D3ED-4863-9C9F-1D254D92B5E4}}
11/04/2012 16:08:23 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:23 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:23 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:23 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:23 Visitor network interface card Component
11/04/2012 16:08:23 ** showNICComponent ->
11/04/2012 16:08:23 ** showNICComponent: using IPv4
11/04/2012 16:08:23 ** showNICComponent: [UNBIND] Internet Protocol Version 6 (TCP/IPv6)
11/04/2012 16:08:23 ** showNICComponent: [BIND] Internet Protocol Version 4 (TCP/IPv4)
11/04/2012 16:08:23 ** showNICComponent: [UNBIND] Link-Layer Topology Discovery Mapper I/O Driver
11/04/2012 16:08:23 ** showNICComponent: [UNBIND] Link-Layer Topology Discovery Responder
11/04/2012 16:08:23 ** showNICComponent: [BIND] Net-Peeker Kernel Driver
11/04/2012 16:08:23 ** showNICComponent: [BIND] PatronSoft NAT Driver
11/04/2012 16:08:23 ** showNICComponent: [BIND] PatronSoft FirstHop Driver
11/04/2012 16:08:23 ** showNICComponent: [UNBIND] QoS Packet Scheduler
11/04/2012 16:08:23 ** showNICComponent: [BIND] File and Printer Sharing for Microsoft Networks
11/04/2012 16:08:23 ** showNICComponent: [BIND] Client for Microsoft Networks
11/04/2012 16:08:23 ** <- showNICComponent
11/04/2012 16:08:23 leaving verify NIC
11/04/2012 16:08:23 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:23 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:23 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 16:08:23 ** is64: 64-bit
11/04/2012 16:08:23 ** IsWow64: Support IsWow64Process()
11/04/2012 16:08:23 ** is64: The process is running under WOW64.
11/04/2012 16:08:23 license key valid, running Premium edition
11/04/2012 16:08:23 ** RestartApacheService=>
11/04/2012 16:08:23 ** RestartApacheService: restart gracefully
11/04/2012 16:08:28 ** <=RestartApacheService
11/04/2012 16:08:28 ** StopUnusedServices=>
11/04/2012 16:08:28 ** StopUnusedServices: SharedAccess
11/04/2012 16:08:28 ** Service: Skip disable Vista Firewall [0]
11/04/2012 16:08:28 ** StopUnusedServices: Turn the Vista firewall off for all profiles
11/04/2012 16:08:28 ** StopUnusedServices: DNS
11/04/2012 16:08:28 ** StopUnusedServices: DHCPServer
11/04/2012 16:08:28 ** <=StopUnusedServices
11/04/2012 16:08:28 ** modifyRRAS=>
11/04/2012 16:08:28 ** resetRRAS ->
11/04/2012 16:08:29 ** resetRRAS: remove visitor NIC
11/04/2012 16:08:29 ** resetRRAS: add visitor NIC
11/04/2012 16:08:29 ** <- resetRRAS
11/04/2012 16:08:29 ** modifyRRAS: Configuring
11/04/2012 16:08:29 ** modifyRRAS: parameter not found, Windows Server 2008 R2 will using default
11/04/2012 16:08:29 ** modifyRRAS: Skip set 1.1.1.1 route
11/04/2012 16:08:29 ** restartRRAS->
11/04/2012 16:08:29 ** restartRRAS: OpenService
11/04/2012 16:08:29 ** restartRRAS: Stopping
11/04/2012 16:08:29 ** restartRRAS: starting
11/04/2012 16:08:29 ** <-restartRRAS
11/04/2012 16:08:29 ** <=modifyRRAS
11/04/2012 16:08:29 ** modifyDNS ->
11/04/2012 16:08:29 Preferred DNS List: 65.55.206.200
11/04/2012 16:08:29 DNS List: 65.55.206.201
11/04/2012 16:08:29 using DNS List
65.55.206.200;
65.55.206.201;
11/04/2012 16:08:29 ** WriteBindCfg: dnsOrFilename[C:\Program Files (x86)\FirstSpot\dns\etc\..\..\DNS_override.txt]
11/04/2012 16:08:29 ** WriteBindCfg: DNS override [dnsoverridetest.com -> 127.0.0.1]
11/04/2012 16:08:29 ** WriteBindCfg: bindpath[C:\Program Files (x86)\FirstSpot\dns\etc\]
11/04/2012 16:08:29 ** <- modifyDNS
11/04/2012 16:08:30 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:30 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:30 ** GetMacAddress: (mac 00:19:5b:70:61:85) [current]
11/04/2012 16:08:30 Multiple Network Segment Count = (0)
11/04/2012 16:08:30 ** WriteROUTERCfg : Ignore Multiple Network Segment Proc for non-ADV MODE USER **
11/04/2012 16:08:30 Quit WriteROUTERCfg!
11/04/2012 16:08:31 ** StartFirstSpot: (INFO) Start PSNAT
11/04/2012 16:08:31 ** setdispatcher=>
11/04/2012 16:08:31 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:31 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:31 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 16:08:31 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:31 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:31 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 16:08:31 ** setdispatcher : Enforce MAC address session handling for non-ADV USER
11/04/2012 16:08:31 ** setdispatcher : SMTP Roaming OFF
11/04/2012 16:08:31 ** setdispatcher : Public Adapter IP[65.55.206.203]
11/04/2012 16:08:31 ** setdispatcher : Private IP(192.168.0.0)
11/04/2012 16:08:31 ** setdispatcher : idle timeout(60)
11/04/2012 16:08:31 ** setdispatcher : driver timeout(1)
11/04/2012 16:08:31 ** setdispatcher : Gateway IP(192.168.192.1)
11/04/2012 16:08:31 ** setdispatcher : Listen Port(5786)
11/04/2012 16:08:31 ** setdispatcher : Auth Port(5788)
11/04/2012 16:08:31 ** setdispatcher : Redirect Port(5790)
11/04/2012 16:08:31 ** setdispatcher : Authenicate IP(192.168.192.1)
11/04/2012 16:08:31 ** setdispatcher : Up Load Limit(0)
11/04/2012 16:08:31 ** setdispatcher : Down Load Limit(0)
11/04/2012 16:08:31 ** setdispatcher : Interval(1)
11/04/2012 16:08:31 ** setdispatcher : Drop Period(2)
11/04/2012 16:08:31 ** setdispatcher : PKTInterval(20)
11/04/2012 16:08:31 ** setdispatcher : Restricted Redirect ON
11/04/2012 16:08:31 ** setdispatcher : Logout automatically when Infobox is closed ( OFF)
11/04/2012 16:08:31 ** setdispatcher : Internet Surfing Break ( OFF)
11/04/2012 16:08:31 ** <=setdispatcher
11/04/2012 16:08:31 ** PortMapInit=>
11/04/2012 16:08:31 ** PortMapAdd: (INFO) Add public port [5901] protocol [TCP,UDP] private [192.168.192.207:5901]
11/04/2012 16:08:31 ** PortMapAdd: (INFO) Add public port [80] protocol [TCP] private [192.168.192.190:80]
11/04/2012 16:08:31 ** PortMapAdd: (INFO) Add public port [5801] protocol [TCP,UDP] private [192.168.192.207:5801]
11/04/2012 16:08:31 ** <=PortMapInit
11/04/2012 16:08:31 ** StartServiceThread: Create Connection Pool
11/04/2012 16:08:32 ** MonitorConnectionNumberThread: =>
11/04/2012 16:08:32 ** MonitorConnectionNumberThread: =>
11/04/2012 16:08:32 ** InitialCaptureThread:=>
11/04/2012 16:08:32 ** PipeListenThread=>
11/04/2012 16:08:32 ** <=InitialCaptureThread:
11/04/2012 16:08:32 ** DeviceNotifyDBLogin=>
11/04/2012 16:08:32 ** ObtainClientBlReportThread=>
11/04/2012 16:08:32 ** DeviceNotifyDB=>
11/04/2012 16:08:32 ** ObtainHttpReportThread=>
11/04/2012 16:08:32 ** ObtainBWReportThread=>
11/04/2012 16:08:32 ** Reset All Accounts
11/04/2012 16:08:32 ** InitFailOver=>
11/04/2012 16:08:32 ** InitFailOver: IOCTL_INIT_FAILOVER SUCCESS
11/04/2012 16:08:32 ** <=InitFailOver
11/04/2012 16:08:32 ** EnableDrvBlock: BLOCK_ICMP ENABLED
11/04/2012 16:08:32 ** EnableDrvBlock: IOCTL_CMD_ENABLE_BLOCK_ICMP SUCCESS
11/04/2012 16:08:32 ** EnableDrvBlock: BLOCK_UDP ENABLED
11/04/2012 16:08:32 ** EnableDrvBlock: IOCTL_CMD_ENABLE_BLOCK_UDP SUCCESS
11/04/2012 16:08:32 ** EnableDrvDP: IOCTL_CMD_ENABLE_DEBUG SUCCESS, debug_level=1
11/04/2012 16:08:32 ** EnableDrvDP: IOCTL_CMD_DEBUG_PATH_INIT SUCCESS
11/04/2012 16:08:32 ** InitAllowIPTable: IOCTL_CMD_ALLOWED_IP_INIT SUCCESS
11/04/2012 16:08:32 ** read_client_pass ->
11/04/2012 16:08:32 ** read_client_pass: file name=C:\Program Files (x86)\FirstSpot\config.ini, session=0
11/04/2012 16:08:32 ** read_client_pass: MAC={00-1E-2A-52-83-11}{19255716879872}{19255716879872}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={84-2B-2B-89-D0-95}{164722887043972}{164722887043972}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={A4-BA-DB-D4-6C-93}{162095636920996}{162095636920996}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={B4-07-F9-F3-A3-13}{21594893780916}{21594893780916}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={00-24-E8-17-5D-5E}{103753926059008}{103753926059008}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={14-FE-B5-9D-17-83}{144137453436436}{144137453436436}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={00-21-70-2C-72-FB}{276467790389504}{276467790389504}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={00-10-18-32-16-05}{5592887857152}{5592887857152}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** read_client_pass: MAC={00-C0-EE-8B-B0-D4}{233854727012352}{233854727012352}
11/04/2012 16:08:32 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 16:08:32 ** <- read_client_pass
11/04/2012 16:08:32 ** read_port_filter ->
11/04/2012 16:08:32 ** <- read_port_filter
11/04/2012 16:08:32 ** read_acl ->
11/04/2012 16:08:32 ** read_acl: ip [2982193344] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3149965504] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [2864752832] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [2915084480] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [2881530048] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3066079424] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3183519936] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3200297152] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3233851584] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3267406016] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3284183232] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3317737664] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3334514880] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [2797643968] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3435178176] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3451955392] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3468732608] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3485509824] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3502287040] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3519064256] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3569395904] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3619727552] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3636504768] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3703613632] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3703613632] mask [16777215]
11/04/2012 16:08:32 ** read_acl: ip [3720390848] mask [16777215]
11/04/2012 16:08:32 ** <- read_acl
11/04/2012 16:08:32 ** ProcURLTrackingRange=>
11/04/2012 16:08:32 ** ProcURLTrackingRange: (INFO) Type[1]
11/04/2012 16:08:32 ** <=ProcURLTrackingRange
11/04/2012 16:08:32 ** StartFirstSpot: QoS is not supported in non-adv edition
11/04/2012 16:08:32 ** indicate_subnetmask: IOCTL_CMD_GET_SUBNETMASK SUCCESS, sm.smask={255.255.0.0}
11/04/2012 16:08:32 ** Filter Initialized
11/04/2012 16:08:32 ** InitOtherSiteClientFlt Initialized
11/04/2012 16:08:32 ** init_uatoken=>
11/04/2012 16:08:32 ** init_uatoken: Ignore to Init
11/04/2012 16:08:32 ** <=init_uatoken
11/04/2012 16:08:32 Bandwidth Throttle (Overall Upload Limit:(0)KB/s Overall Download Limit:(0)KB/s)
11/04/2012 16:08:32 ** ClearTmpURL: SQLExecute[DELETE FROM tmpurl ;] fails
11/04/2012 16:08:32 ** ObtainHttpReportThread: ClearTmpURL Fail
11/04/2012 16:08:36 ** AddPassiveLoginMAC=>
11/04/2012 16:08:36 ** MonitorFSR=>
11/04/2012 16:08:36 ** QueryAllPassiveLogin: [eid207(00-24-E8-17-9C-AC)]
11/04/2012 16:08:36 ** PrintUserInfo(0): Add user mac(00-24-E8-17-9C-AC) ,timeleft(Unlimit) ,Upload Limit(Unlimit) ,Download Limit(Unlimit) ,Data transfer D/L Count On, Accumulated[1312KB], QUOTA OFF ,Data transfer U/L Count On, Accumulated[381KB], QUOTA OFF, Data transfer sharing OFF ,Expire Date [NEVER] ,Start Date [11-04-2012 14:54:51] ,ACL [OFF], User port filter OFF
11/04/2012 16:08:36 ** CreateBWUsageMemory: BWUsage[0]
11/04/2012 16:08:36 ** CreateBWUsageMemory_ul: BWUsage[0]
11/04/2012 16:08:36 ** CreateBWLL: Counting is enabled.
11/04/2012 16:08:36 ** HaveIBMsgExist: SQLFetch[SELECT iBMsg_glo, iBMsg_per FROM fsusr WHERE name = '00-24-E8-17-9C-AC';] Fail
11/04/2012 16:08:36 ** CheckIBMsg: haveIbMsg [0]
11/04/2012 16:08:36 ** AddPassiveLoginMAC: IOCTL_CMD_PL_MAC_RESET SUCCESS
11/04/2012 16:08:36 ** AddPassiveLoginMAC: IOCTL_CMD_ADD_MAC_USERNAME SUCCESS
11/04/2012 16:08:36 ** <=AddPassiveLoginMAC
11/04/2012 16:08:36 <------ batch_fP_RetValue stats : 0.
11/04/2012 16:08:36 IoctlNdisQueryGlobalStats ->
11/04/2012 16:08:36 ** StartFirstSpot: no Batch File or Failed the execution
11/04/2012 16:08:36 <- IoctlNdisQueryGlobalStats
11/04/2012 16:08:36 ** StartFirstSpot: MonitorPMem Thread Created
11/04/2012 16:08:36 ** Service: FirstSpot starts successfully.
11/04/2012 16:08:36 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 16:08:36 ** MonitorPMem=>
11/04/2012 16:08:37 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151512;] fails
11/04/2012 16:08:38 ** AddressThread: Status Code[0] site1
11/04/2012 16:08:38 ** AddressThread: Normal Mode ON
11/04/2012 16:08:38 ** AddressThread: Online validation check succeeds
11/04/2012 16:08:43 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151517;] fails
11/04/2012 16:08:48 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151524;] fails
11/04/2012 16:08:52 ** DeviceNotifyDBLogin: reseted DeviceNotifyDBLogin event
11/04/2012 16:08:52 ** DeviceNotifyDBLogin: total clients[1]
11/04/2012 16:08:52 ** DeviceNotifyDBLogin: mac address (00-24-E8-17-9C-AC) Login
11/04/2012 16:08:52 ** NotifyDBLoginODBC: user[00-24-E8-17-9C-AC] login successfully
11/04/2012 16:08:54 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151528;] fails
11/04/2012 16:08:59 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151533;] fails
11/04/2012 16:09:09 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151547;] fails
11/04/2012 16:09:15 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151549;] fails
11/04/2012 16:09:20 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151557;] fails
11/04/2012 16:09:25 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151563;] fails
11/04/2012 16:09:28 ** AuthLoginODBC: Authenticate[tth]
11/04/2012 16:09:28 ** RetVal[1]
11/04/2012 16:09:28 ** AuthLoginODBC:[tth] recur_option[0], week_sch[0], start time[-1], end time[-1]
11/04/2012 16:09:28 ** AuthLoginODBC: Current Time [Wed Apr 11 16:09:28 2012], EDate [N/A]
11/04/2012 16:09:28 ** AuthLoginODBC:[tth] browser Information (Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20100101 Firefox/11.0)
11/04/2012 16:09:28 ** AuthLoginODBC: haveIbMsg [0]
11/04/2012 16:09:28 ** PrintUserInfo(972): Add user mac(00-24-E8-17-9C-EF) ,timeleft(Unlimit) ,Upload Limit(Unlimit) ,Download Limit(Unlimit) ,Data transfer D/L Count On, Accumulated[55588KB], QUOTA OFF ,Data transfer U/L Count On, Accumulated[2807KB], QUOTA OFF, Data transfer sharing OFF ,Expire Date [NEVER] ,ACL [OFF], User port filter OFF
11/04/2012 16:09:28 ** CreateBWUsageMemory: BWUsage[0]
11/04/2012 16:09:28 ** CreateBWUsageMemory_ul: BWUsage[0]
11/04/2012 16:09:28 ** CreateBWLL: Counting is enabled.
11/04/2012 16:09:28 ** insert_entry=>
11/04/2012 16:09:28 ** <=insert_entry
11/04/2012 16:09:28 ** StartServiceThread: (check) OP_ADD [1]
11/04/2012 16:09:36 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151571;] fails
11/04/2012 16:09:36 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'autos.yahoo.com' and RESERVED1 > 1334151574 and DESTIP = '98.136.70.45' AND destport = 80] Fail
11/04/2012 16:09:36 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'l.yimg.com' and RESERVED1 > 1334151574 and DESTIP = '195.10.51.66' AND destport = 80] Fail
11/04/2012 16:09:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'yui.yahooapis.com' and RESERVED1 > 1334151574 and DESTIP = '195.10.51.43' AND destport = 80] Fail
11/04/2012 16:09:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'ad.doubleclick.net' and RESERVED1 > 1334151576 and DESTIP = '173.194.34.187' AND destport = 80] Fail
11/04/2012 16:09:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 's.yimg.com' and RESERVED1 > 1334151576 and DESTIP = '2.22.125.227' AND destport = 443] Fail
11/04/2012 16:09:42 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151576;] fails
11/04/2012 16:09:42 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 's.yimg.com' and RESERVED1 > 1334151576 and DESTIP = '2.22.125.227' AND destport = 443] Fail
11/04/2012 16:09:43 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'ads.bluelithium.com' and RESERVED1 > 1334151576 and DESTIP = '217.163.21.40' AND destport = 80] Fail
11/04/2012 16:09:43 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '128.248.255.255' and RESERVED1 > 1334151576 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:09:43 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 's0.2mdn.net' and RESERVED1 > 1334151576 and DESTIP = '173.194.34.188' AND destport = 80] Fail
11/04/2012 16:09:43 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'us.bc.yahoo.com' and RESERVED1 > 1334151576 and DESTIP = '217.146.179.205' AND destport = 80] Fail
11/04/2012 16:09:43 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'ocsp.digicert.com' and RESERVED1 > 1334151577 and DESTIP = '68.232.37.39' AND destport = 80] Fail
11/04/2012 16:09:43 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'a.analytics.yahoo.com' and RESERVED1 > 1334151577 and DESTIP = '98.139.0.24' AND destport = 80] Fail
11/04/2012 16:09:43 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'ad.yieldmanager.com' and RESERVED1 > 1334151577 and DESTIP = '217.163.21.41' AND destport = 80] Fail
11/04/2012 16:09:44 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'pn4.adserver.yahoo.com' and RESERVED1 > 1334151578 and DESTIP = '68.180.207.227' AND destport = 80] Fail
11/04/2012 16:09:44 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'pn1.bc.yahoo.com' and RESERVED1 > 1334151582 and DESTIP = '76.13.6.132' AND destport = 80] Fail
11/04/2012 16:09:49 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151583;] fails
11/04/2012 16:09:55 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151589;] fails
11/04/2012 16:10:00 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151595;] fails
11/04/2012 16:10:00 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'en-us.fxfeeds.mozilla.com' and RESERVED1 > 1334151599 and DESTIP = '68.232.35.119' AND destport = 80] Fail
11/04/2012 16:10:01 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'fxfeeds.mozilla.com' and RESERVED1 > 1334151600 and DESTIP = '68.232.35.119' AND destport = 80] Fail
11/04/2012 16:10:06 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151600;] fails
11/04/2012 16:10:06 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'newsrss.bbc.co.uk' and RESERVED1 > 1334151600 and DESTIP = '195.10.51.49' AND destport = 80] Fail
11/04/2012 16:10:06 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'feeds.bbci.co.uk' and RESERVED1 > 1334151600 and DESTIP = '195.10.51.17' AND destport = 80] Fail
11/04/2012 16:10:06 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151602 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:10:11 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151606;] fails
11/04/2012 16:10:11 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'download.windowsupdate.com' and RESERVED1 > 1334151606 and DESTIP = '62.41.18.50' AND destport = 80] Fail
11/04/2012 16:10:12 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'www.update.microsoft.com' and RESERVED1 > 1334151607 and DESTIP = '65.55.184.16' AND destport = 443] Fail
11/04/2012 16:10:17 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151611;] fails
11/04/2012 16:10:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'www.update.microsoft.com' and RESERVED1 > 1334151611 and DESTIP = '65.55.184.16' AND destport = 443] Fail
11/04/2012 16:10:18 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'download.windowsupdate.com' and RESERVED1 > 1334151614 and DESTIP = '62.41.18.50' AND destport = 80] Fail
11/04/2012 16:10:23 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151619;] fails
11/04/2012 16:10:29 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151624;] fails
11/04/2012 16:10:32 ** AuthLoginODBC: Authenticate[user01]
11/04/2012 16:10:32 ** RetVal[1]
11/04/2012 16:10:32 ** AuthLoginODBC:[user01] recur_option[0], week_sch[0], start time[-1], end time[-1]
11/04/2012 16:10:32 ** AuthLoginODBC: Current Time [Wed Apr 11 16:10:32 2012], EDate [N/A]
11/04/2012 16:10:32 ** AuthLoginODBC:[user01] browser Information (Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20100101 Firefox/11.0)
11/04/2012 16:10:32 ** AuthLoginODBC: haveIbMsg [0]
11/04/2012 16:10:32 ** PrintUserInfo(1820): Add user mac(E8-39-DF-32-AA-56) ,timeleft(Unlimit) ,Upload Limit(Unlimit) ,Download Limit(Unlimit) ,Data transfer D/L Count On, Accumulated[96916KB], QUOTA OFF ,Data transfer U/L Count On, Accumulated[21187KB], QUOTA OFF, Data transfer sharing OFF ,Expire Date [NEVER] ,ACL [OFF], User port filter OFF
11/04/2012 16:10:32 ** CreateBWUsageMemory: BWUsage[0]
11/04/2012 16:10:32 ** CreateBWUsageMemory_ul: BWUsage[0]
11/04/2012 16:10:32 ** CreateBWLL: Counting is enabled.
11/04/2012 16:10:32 ** insert_entry=>
11/04/2012 16:10:32 ** <=insert_entry
11/04/2012 16:10:32 ** StartServiceThread: (check) OP_ADD [1]
11/04/2012 16:10:34 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151629;] fails
11/04/2012 16:10:34 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151633 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:10:40 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151636;] fails
11/04/2012 16:10:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'rss.adnkronos.com' and RESERVED1 > 1334151637 and DESTIP = '213.92.47.107' AND destport = 80] Fail
11/04/2012 16:10:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.netvibes.com' and RESERVED1 > 1334151638 and DESTIP = '193.189.143.34' AND destport = 80] Fail
11/04/2012 16:10:45 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151640;] fails
11/04/2012 16:10:46 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'gfx1.hotmail.com' and RESERVED1 > 1334151644 and DESTIP = '65.54.81.33' AND destport = 80] Fail
11/04/2012 16:10:46 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151644 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:10:51 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151646;] fails
11/04/2012 16:10:51 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151646 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:10:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '111.221.77.148' and RESERVED1 > 1334151646 and DESTIP = '111.221.77.148' AND destport = 443] Fail
11/04/2012 16:10:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '157.55.130.157' and RESERVED1 > 1334151646 and DESTIP = '157.55.130.157' AND destport = 443] Fail
11/04/2012 16:10:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'apps.skype.com' and RESERVED1 > 1334151647 and DESTIP = '2.21.238.161' AND destport = 443] Fail
11/04/2012 16:10:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'rad.msn.com' and RESERVED1 > 1334151647 and DESTIP = '94.245.117.45' AND destport = 80] Fail
11/04/2012 16:10:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'a.rad.msn.com' and RESERVED1 > 1334151647 and DESTIP = '94.245.117.47' AND destport = 80] Fail
11/04/2012 16:10:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'connect.facebook.net' and RESERVED1 > 1334151648 and DESTIP = '2.22.79.139' AND destport = 443] Fail
11/04/2012 16:10:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '92.3.153.145' and RESERVED1 > 1334151650 and DESTIP = '92.3.153.145' AND destport = 443] Fail
11/04/2012 16:10:57 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151651;] fails
11/04/2012 16:10:58 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '92.3.153.145' and RESERVED1 > 1334151653 and DESTIP = '92.3.153.145' AND destport = 443] Fail
11/04/2012 16:10:58 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '66.87.83.34' and RESERVED1 > 1334151655 and DESTIP = '66.87.83.34' AND destport = 443] Fail
11/04/2012 16:10:58 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.facebook.com' and RESERVED1 > 1334151656 and DESTIP = '69.171.247.48' AND destport = 80] Fail
11/04/2012 16:10:58 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'profile.ak.fbcdn.net' and RESERVED1 > 1334151657 and DESTIP = '195.10.11.187' AND destport = 80] Fail
11/04/2012 16:11:04 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151658;] fails
11/04/2012 16:11:04 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'profile.ak.fbcdn.net' and RESERVED1 > 1334151658 and DESTIP = '195.10.11.187' AND destport = 80] Fail
11/04/2012 16:11:04 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.facebook.com' and RESERVED1 > 1334151658 and DESTIP = '69.171.247.48' AND destport = 80] Fail
11/04/2012 16:11:04 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'a8.sphotos.ak.fbcdn.net' and RESERVED1 > 1334151658 and DESTIP = '165.254.34.18' AND destport = 80] Fail
11/04/2012 16:11:04 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'external.ak.fbcdn.net' and RESERVED1 > 1334151658 and DESTIP = '195.10.51.74' AND destport = 80] Fail
11/04/2012 16:11:04 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '66.87.83.34' and RESERVED1 > 1334151658 and DESTIP = '66.87.83.34' AND destport = 443] Fail
11/04/2012 16:11:04 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'pixel.facebook.com' and RESERVED1 > 1334151658 and DESTIP = '66.220.153.76' AND destport = 80] Fail
11/04/2012 16:11:04 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151661 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:11:10 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151664;] fails
11/04/2012 16:11:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151664 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:11:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '78.100.194.156' and RESERVED1 > 1334151665 and DESTIP = '78.100.194.156' AND destport = 443] Fail
11/04/2012 16:11:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151666 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:11:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151668 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:11:11 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'profile.ak.fbcdn.net' and RESERVED1 > 1334151669 and DESTIP = '195.10.11.187' AND destport = 80] Fail
11/04/2012 16:11:16 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151670;] fails
11/04/2012 16:11:16 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151670 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:11:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'du108w.dub108.mail.live.com' and RESERVED1 > 1334151672 and DESTIP = '157.55.0.137' AND destport = 80] Fail
11/04/2012 16:11:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'gfx1.hotmail.com' and RESERVED1 > 1334151672 and DESTIP = '65.54.81.33' AND destport = 80] Fail
11/04/2012 16:11:22 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151677;] fails
11/04/2012 16:11:22 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '41.82.158.168' and RESERVED1 > 1334151678 and DESTIP = '41.82.158.168' AND destport = 443] Fail
11/04/2012 16:11:22 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151681 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:11:23 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '111.221.74.31' and RESERVED1 > 1334151682 and DESTIP = '111.221.74.31' AND destport = 443] Fail
11/04/2012 16:11:23 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '157.55.235.141' and RESERVED1 > 1334151682 and DESTIP = '157.55.235.141' AND destport = 443] Fail
11/04/2012 16:11:28 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151683;] fails
11/04/2012 16:11:33 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151690;] fails
11/04/2012 16:11:33 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '77.17.114.78' and RESERVED1 > 1334151691 and DESTIP = '77.17.114.78' AND destport = 443] Fail
11/04/2012 16:11:34 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 's.yimg.com' and RESERVED1 > 1334151693 and DESTIP = '2.22.125.227' AND destport = 443] Fail
11/04/2012 16:11:39 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151694;] fails
11/04/2012 16:11:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '77.17.114.78' and RESERVED1 > 1334151694 and DESTIP = '77.17.114.78' AND destport = 443] Fail
11/04/2012 16:11:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151694 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:11:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '177.76.88.171' and RESERVED1 > 1334151696 and DESTIP = '177.76.88.171' AND destport = 443] Fail
11/04/2012 16:11:45 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151699;] fails
11/04/2012 16:11:45 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '177.76.88.171' and RESERVED1 > 1334151699 and DESTIP = '177.76.88.171' AND destport = 443] Fail
11/04/2012 16:11:45 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'bay.gateway.messenger.live.com' and RESERVED1 > 1334151699 and DESTIP = '64.4.9.190' AND destport = 80] Fail
11/04/2012 16:11:45 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'by2msg3020513.gateway.messenger.live.com' and RESERVED1 > 1334151701 and DESTIP = '64.4.34.221' AND destport = 80] Fail
11/04/2012 16:11:51 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151709;] fails
11/04/2012 16:11:51 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'safebrowsing.clients.google.com' and RESERVED1 > 1334151709 and DESTIP = '173.194.34.163' AND destport = 80] Fail
11/04/2012 16:11:51 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'safebrowsing-cache.google.com' and RESERVED1 > 1334151709 and DESTIP = '74.125.230.133' AND destport = 80] Fail
11/04/2012 16:11:51 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151710 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:11:56 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151711;] fails
11/04/2012 16:11:57 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151711 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:11:57 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'connect.facebook.net' and RESERVED1 > 1334151714 and DESTIP = '2.22.79.139' AND destport = 443] Fail
11/04/2012 16:11:57 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'apps.skype.com' and RESERVED1 > 1334151714 and DESTIP = '2.21.238.161' AND destport = 443] Fail
11/04/2012 16:12:02 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151716;] fails
11/04/2012 16:12:08 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151722;] fails
11/04/2012 16:12:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151724 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:12:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151725 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:12:13 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151727;] fails
11/04/2012 16:12:18 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151736;] fails
11/04/2012 16:12:24 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151741;] fails
11/04/2012 16:12:29 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151744;] fails
11/04/2012 16:12:29 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151746 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:12:34 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151752;] fails
11/04/2012 16:12:40 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151754;] fails
11/04/2012 16:12:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151754 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:12:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.facebook.com' and RESERVED1 > 1334151758 and DESTIP = '69.171.247.48' AND destport = 80] Fail
11/04/2012 16:12:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151759 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:12:46 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151760;] fails
11/04/2012 16:12:46 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151761 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:12:46 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151762 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:12:56 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151771;] fails
11/04/2012 16:13:02 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151781;] fails
11/04/2012 16:13:07 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151782;] fails
11/04/2012 16:13:07 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151785 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:13:07 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.facebook.com' and RESERVED1 > 1334151785 and DESTIP = '69.171.247.48' AND destport = 80] Fail
11/04/2012 16:13:12 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151787;] fails
11/04/2012 16:13:13 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151788 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:13:13 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151788 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:13:23 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151799;] fails
11/04/2012 16:13:23 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151799 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:13:28 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151803;] fails
11/04/2012 16:13:34 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151810;] fails
11/04/2012 16:13:34 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151812 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:13:39 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151814;] fails
11/04/2012 16:13:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151815 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:13:45 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151819;] fails
11/04/2012 16:13:50 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151826;] fails
11/04/2012 16:13:50 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151826 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:13:51 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'weather.partners.msn.com' and RESERVED1 > 1334151827 and DESTIP = '65.55.17.39' AND destport = 80] Fail
11/04/2012 16:13:51 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151827 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:13:56 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151830;] fails
11/04/2012 16:13:56 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151830 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:14:02 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151836;] fails
11/04/2012 16:14:07 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151842;] fails
11/04/2012 16:14:07 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151845 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:14:12 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151847;] fails
11/04/2012 16:14:13 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151851 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:14:18 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151852;] fails
11/04/2012 16:14:18 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'mail.yahoo.com' and RESERVED1 > 1334151852 and DESTIP = '98.139.241.94' AND destport = 80] Fail
11/04/2012 16:14:18 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'uk.mg40.mail.yahoo.com' and RESERVED1 > 1334151853 and DESTIP = '66.196.66.156' AND destport = 80] Fail
11/04/2012 16:14:23 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151858;] fails
11/04/2012 16:14:24 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'uk.mg40.mail.yahoo.com' and RESERVED1 > 1334151858 and DESTIP = '66.196.66.156' AND destport = 80] Fail
11/04/2012 16:14:24 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151858 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:14:24 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'ad.yieldmanager.com' and RESERVED1 > 1334151859 and DESTIP = '217.163.21.38' AND destport = 80] Fail
11/04/2012 16:14:29 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151863;] fails
11/04/2012 16:14:29 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'ucs.query.yahoo.com' and RESERVED1 > 1334151868 and DESTIP = '217.12.4.46' AND destport = 80] Fail
11/04/2012 16:14:30 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151868 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:14:35 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151870;] fails
11/04/2012 16:14:40 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151876;] fails
11/04/2012 16:14:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151876 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:14:46 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151880;] fails
11/04/2012 16:14:51 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151888;] fails
11/04/2012 16:14:51 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151888 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:14:56 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151891;] fails
11/04/2012 16:14:57 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151891 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:15:02 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151899;] fails
11/04/2012 16:15:02 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151899 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:15:07 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151904;] fails
11/04/2012 16:15:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151906 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:15:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151907 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:15:13 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151907;] fails
11/04/2012 16:15:13 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151909 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:15:13 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151909 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:15:19 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151916;] fails
11/04/2012 16:15:19 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151916 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:15:24 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151923;] fails
11/04/2012 16:15:29 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151924;] fails
11/04/2012 16:15:34 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151931;] fails
11/04/2012 16:15:40 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151934;] fails
11/04/2012 16:15:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151936 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:15:40 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151936 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:15:46 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151940;] fails
11/04/2012 16:15:46 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151943 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:15:46 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151945 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:15:51 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151947;] fails
11/04/2012 16:15:52 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334151951 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:15:57 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151952;] fails
11/04/2012 16:16:02 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151961;] fails
11/04/2012 16:16:07 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151965;] fails
11/04/2012 16:16:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151966 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:16:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151967 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:16:13 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151967;] fails
11/04/2012 16:16:13 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151968 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:16:13 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151968 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:16:19 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151974;] fails
11/04/2012 16:16:19 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151977 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:16:24 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151979;] fails
11/04/2012 16:16:25 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334151981 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:16:30 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151984;] fails
11/04/2012 16:16:35 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151992;] fails
11/04/2012 16:16:41 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334151995;] fails
11/04/2012 16:16:41 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334151997 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:16:41 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334151998 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:16:46 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152004;] fails
11/04/2012 16:16:52 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152007;] fails
11/04/2012 16:16:57 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152012;] fails
11/04/2012 16:16:57 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334152013 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 16:17:03 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152022;] fails
11/04/2012 16:17:08 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152022;] fails
11/04/2012 16:17:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334152027 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:17:13 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152028;] fails
11/04/2012 16:17:19 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152033;] fails
11/04/2012 16:17:19 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.bangkokin360.com' and RESERVED1 > 1334152034 and DESTIP = '209.54.59.36' AND destport = 80] Fail
11/04/2012 16:17:19 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334152037 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:17:24 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152039;] fails
11/04/2012 16:17:25 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334152040 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 16:17:30 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152044;] fails
11/04/2012 16:17:35 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152052;] fails
11/04/2012 16:17:41 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152056;] fails
11/04/2012 16:17:41 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '64.74.103.144' and RESERVED1 > 1334152057 and DESTIP = '64.74.103.144' AND destport = 443] Fail
11/04/2012 16:17:46 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152060;] fails
11/04/2012 16:17:52 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334152070;] fails
11/04/201

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

It seems there is problem with table tmpurl. Can you perform the above steps to recreate the tmpurl table?
_________________
~ Patronsoft Limited ~

nottinghub · Joined: 31 Mar 2012 Posts: 15

as I am using mysql, how would like me to recreate tmpurl ?

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Just drop the table and recreate.
_________________
~ Patronsoft Limited ~

nottinghub · Joined: 31 Mar 2012 Posts: 15

I dropped the table, then recreated with the following statement:
create table tmpurl
(
name varchar(80),
url varchar(254),
reserved1 integer,
destip varchar(15),
destport integer
);

I then restarted FirstSpot.

Issue seems to still be there:

Here's the log:

11/04/2012 17:14:20 ** Starting Print Log **
11/04/2012 17:14:20 ** FirstSpot Version (7.0.6) **
11/04/2012 17:14:20 ** Service: Read Session Log: Session Log[ON]
11/04/2012 17:14:20 ** Service: Read DataBase Info: Datasource[FILEDSN=E:\DATA\_FirstSpot\_FirstSpot Customization\MySQL Stuff\DSN\first_dsn.dsn;]
11/04/2012 17:14:20 ** Service: Read DataBase Info: Datasource driver[MySQL ODBC 3.51 Driver]
11/04/2012 17:14:20 ** Service: Read DataBase Info: Datasource type[1]
11/04/2012 17:14:20 ** Service: Read DataBase Info: Datasource Tablename[fsusr]
11/04/2012 17:14:20 ** Service: Read DataBase Info: Datasource Log Tablename[fsusrlog]
11/04/2012 17:14:20 ** Service: Read DataBase Info: Datasource Shared Secret Tablename[fssecret]
11/04/2012 17:14:20 ** Service: Read DataBase Info: Datasource IB Msg Tablename[ibmsg]
11/04/2012 17:14:20 ** Service: PrivateMAC[00195b706185]
11/04/2012 17:14:20 ** Service: Read BlockICMP_UDP: Block ICMP[ON]
11/04/2012 17:14:20 ** Service: Read BlockICMP_UDP: Block UDP[ON]
11/04/2012 17:14:20 ** Service: Read Driver Param: Session Time Limit[0]
11/04/2012 17:14:20 ** Service: Read Driver Param: Idle time out[60]
11/04/2012 17:14:20 ** Service: Read Driver Param: Driver Time Out[1]
11/04/2012 17:14:20 ** Service: Read Driver Param: listen port[5786]
11/04/2012 17:14:20 ** Service: Read Driver Param: Authentication port[5788]
11/04/2012 17:14:20 ** Service: Read Driver Param: Https port[5790]
11/04/2012 17:14:20 ** Service: Read Driver Param: Authentication IP[192.168.192.1]
11/04/2012 17:14:20 ** Service: Read Driver Param: Fail to read private gateway domain name, default [firstspot.org]
11/04/2012 17:14:20 ** Service: Read Driver Param: Logout automatically when Infobox is closed [OFF]
11/04/2012 17:14:20 ** Service: Read Driver Param: Default Instant Keywords port[5801]
11/04/2012 17:14:20 ** Service: Read Global BandWidth Throttle: Upload Throttle is disabled
11/04/2012 17:14:20 ** Service: Read Global BandWidth Throttle: Download Throttle is disabled
11/04/2012 17:14:20 ** Service: Dynamic / Flexible bandwidth throttling [OFF]
11/04/2012 17:14:20 ** Service: Read PW Offloading [OFF]
11/04/2012 17:14:20 ** Service: Read Session Handling: [MAC]
11/04/2012 17:14:20 ** Service: Read Anonymous Login: Anonymous [NO]
11/04/2012 17:14:20 ** Service: Read Anonymous Login: AnonymousSharedSecret [NO]
11/04/2012 17:14:20 ** Service: Read Lisence Path: licensePath[C:\Program Files (x86)\FirstSpot\license.key]
11/04/2012 17:14:20 ** Service: Read IP: gatewayIP[192.168.192.1]
11/04/2012 17:14:20 ** Service: Read IP: subnetMask[255.255.0.0]
11/04/2012 17:14:20 ** Service: Read IP: privateIP[192.168.0.0]
11/04/2012 17:14:20 ** Service: ReadMultipleNetworkSegment: Login Page Count[0]
11/04/2012 17:14:20 ** Service: Read Allow Disconnect: allow private disconnect[NO]
11/04/2012 17:14:20 ** Service: Read Allow Disconnect: allow public disconnect[NO]
11/04/2012 17:14:20 ** Service: Read NIC: system default locale [409], user default locale [409]
11/04/2012 17:14:20 ** Service: Read NIC: system default UI language [409], user default UI language [409]
11/04/2012 17:14:20 ** Service: Read NIC: Current equipment manufacturer (OEM) code page [437], Current Windows ANSI code page [1252]
11/04/2012 17:14:20 ** PrintEnumUILanguagesProc: lpUILanguageString = 0409
11/04/2012 17:14:20 ** Service: Read NIC: publicNIC[NIC Upper WAN]
11/04/2012 17:14:20 ** Service: Read NIC: privateNIC[NIC Lower Visitor Network]
11/04/2012 17:14:20 ** Service: Read Allowed Hosts: hosts key words file path[C:\Program Files (x86)\FirstSpot\AllowedHostsKeywords.txt]
11/04/2012 17:14:20 ** Service: Read Allowed Hosts: hosts ip file path[C:\Program Files (x86)\FirstSpot\AllowedHostsIps.txt]
11/04/2012 17:14:20 ** Service: Read Default Login Page: [login_select.php]
11/04/2012 17:14:20 ** Service: Read DHCP: mode[0]
11/04/2012 17:14:20 ** Service: Read DHCP: DHCP Path[C:\Program Files (x86)\FirstSpot\dhcp\dhcpservice.ini]
11/04/2012 17:14:20 ** Service: Read Skip Nic D/E[Allow]
11/04/2012 17:14:20 ** Service: Packet Drop Period [20]
11/04/2012 17:14:20 ** Service: SMTP Roaming OFF
11/04/2012 17:14:20 ** Service: Read AuthServ: No MAX Attempt
11/04/2012 17:14:20 ** Service: Read Global Data Transfer Download[Enabled]
11/04/2012 17:14:20 ** Service: Read Global Data Transfer Upload[Enabled]
11/04/2012 17:14:20 ** Service: Read Global Data Transfer Download Quota[0]
11/04/2012 17:14:20 ** Service: Read Global Data Transfer Upload Quota[0]
11/04/2012 17:14:20 ** Service: URL Tracking ON
11/04/2012 17:14:20 ** Service: NAT[Enabled]
11/04/2012 17:14:20 ** Service: NAT Module [FSNAT]
11/04/2012 17:14:20 ** Service: NAT TYPE[2]
11/04/2012 17:14:20 ** Service: Read Proxy ARP Count[0]
11/04/2012 17:14:20 ** Service: FSFO: Failover [0]
11/04/2012 17:14:20 ** Service: Scenario2 Technology [OFF]
11/04/2012 17:14:20 ** Service: Read Max Conc User: Maximum number of concurrent users is unlimited
11/04/2012 17:14:20 ** Service: In-browser: iscript file's path [C:\Program Files (x86)\FirstSpot\iscript.txt]
11/04/2012 17:14:20 ** Service: In-browser: Proxy port[5796]
11/04/2012 17:14:20 ** Service: In-browser: Script port[5802]
11/04/2012 17:14:20 ** Service: In-browser: In-browser Message [ON]
11/04/2012 17:14:20 ** Service: In-browser: Top banner mode [Disable]
11/04/2012 17:14:20 ** Service: In-browser: Infobox always on [Disable]
11/04/2012 17:14:20 ** Service: In-browser Message time reminder[ON ][5]
11/04/2012 17:14:20 ** Service: Internet Surfing Break [OFF]
11/04/2012 17:14:20 ** Service: Pool: min connection [3], max connection [10]
11/04/2012 17:14:20 ** Service: Read Scratch Login: Support both Username / Password and Scratch Code login [YES]
11/04/2012 17:14:20 ** Service: Read Scratch Login: Support v6 style Scratch Code [YES]
11/04/2012 17:14:20 ** Service: Read Payment Method: [ppal]
11/04/2012 17:14:20 ** Service: Read Preferred DNS server IP for the Visitor Network [0.0.0.0]
11/04/2012 17:14:20 ** Service: Read Alternate DNS server IP for the Visitor Network [0.0.0.0]
11/04/2012 17:14:20 ** Service: Read Client Blacklist Log [ON]
11/04/2012 17:14:20 ** Service: ForwordToProxy: Forword To Proxy[OFF]
11/04/2012 17:14:20 ** Service: ReadBlackoutPeriod: Blackout Period [OFF]
11/04/2012 17:14:20 ** System Info for Verification **
11/04/2012 17:14:20 ** System Info for Verification:Microsoft Windows Server 2008 R2
11/04/2012 17:14:20 ** System Info for Verification:Server type
11/04/2012 17:14:20 ** System Info for Verification:Enterprise
11/04/2012 17:14:20 ** System Info for Verification:{Service Pack 1} (Build 7601)
11/04/2012 17:14:20 ** SUCCESS **
11/04/2012 17:14:20 ** Virtual Platform Info for Verification **
11/04/2012 17:14:20 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:20 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:20 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 17:14:20 ** Hardware Info for Verification **
11/04/2012 17:14:20 ** getHardwareInfo: using GetNativeSystemInfo
11/04/2012 17:14:20 ** Hardware Info for Verification: Number of processors: {2}
11/04/2012 17:14:20 ** Hardware Info for Verification: Page size: {4096}
11/04/2012 17:14:20 ** Hardware Info for Verification: Processor type: {17.14.20.log]
11/04/2012 17:14:20 ** Hardware Info for Verification: wProcessorLevel: {Intel Pentium Pro, II, III or 4}
11/04/2012 17:14:20 ** Hardware Info for Verification: CPU Hz {3192}MHz
11/04/2012 17:14:20 ** Hardware Info for Verification: CPU Name {Pentium(R) Dual-Core CPU E5800 @ 3.20GHz}
11/04/2012 17:14:20 ** Hardware Info for Verification: CPU Model {Intel64 Family 6 Model 23 Stepping 10}
11/04/2012 17:14:20 ** Memory Status: Total Physical Memory 3995 MBytes
11/04/2012 17:14:20 ** Memory Status: Free Physical Memory 2715 MBytes
11/04/2012 17:14:20 ** Memory Status: Total Page File 4095 MBytes
11/04/2012 17:14:20 ** Memory Status: Available Page File 4095 MBytes
11/04/2012 17:14:20 ** Memory Status: Total Virtual Memory 2047 MBytes
11/04/2012 17:14:20 ** Memory Status: Available Virtual Memory 1972 MBytes
11/04/2012 17:14:20 ** Memory Status: Total Memory Loaded 32 Bytes
11/04/2012 17:14:20 ** ReadVirturalMemSetting: Query registry (PagingFiles) = ?:\pagefile.sys
11/04/2012 17:14:20 ** Memory Mapping: [C:\Program Files (x86)\FirstSpot\log\firstspot_gw_srv_2012.04.11_17.14.20.log]
11/04/2012 17:14:20 ** verifyPublicNicStatus=>
11/04/2012 17:14:20 ** firstspotconOperation2=>
11/04/2012 17:14:20 ** firstspotconOperation2: Connection Name[NIC Upper WAN]
11/04/2012 17:14:20 ** firstspotconOperation2: Hardware Name Obtained[Broadcom NetLink (TM) Gigabit Ethernet]
11/04/2012 17:14:20 ** firstspotconOperation2: Hardware ID Obtained[PCI\VEN_14E4&DEV_1692&SUBSYS_04001028&REV_01\4&2696CBC&0&00E0]
11/04/2012 17:14:20 ** firstspotconOperation2{STA_PUBLIC_NIC}: Getting Status
11/04/2012 17:14:20 ** firstspotconOperation2{STA_PUBLIC_NIC}: Internet NIC started
11/04/2012 17:14:20 ** <=firstspotconOperation2
11/04/2012 17:14:20 ** <=verifyPublicNicStatus
11/04/2012 17:14:20 ** probePublicIP=>
11/04/2012 17:14:20 ** probePublicIP: Connection Name[NIC Upper WAN]
11/04/2012 17:14:20 ** probePublicIP: Hardware Guid Obtained[{CA1FCF23-006D-4A92-86C8-AC199FAEADAB}]
11/04/2012 17:14:20 ** <=probePublicIP
11/04/2012 17:14:20 ** validate_SubnetAddr =>
11/04/2012 17:14:20 ** validate_SubnetAddr <=
11/04/2012 17:14:20 ** EnableDisableAssignIPs=>
11/04/2012 17:14:20 ** EnableDisableAssignIPs: Skip Disable Visitor NIC
11/04/2012 17:14:20 ** EnableDisableAssignIPs: Configuring Visitor NIC
11/04/2012 17:14:20 ** is64: 64-bit
11/04/2012 17:14:20 ** IsWow64: Support IsWow64Process()
11/04/2012 17:14:20 ** is64: The process is running under WOW64.
11/04/2012 17:14:21 ** EnableDisableAssignIPs: Finished Configuring Visitor NIC
11/04/2012 17:14:21 ** EnableDisableAssignIPs: Skip Enable Visitor NIC
11/04/2012 17:14:21 ** <=EnableDisableAssignIPs
11/04/2012 17:14:21 ** verifyPrivateNicStatus=>
11/04/2012 17:14:21 ** firstspotconOperation2=>
11/04/2012 17:14:21 ** firstspotconOperation2: Connection Name[NIC Lower Visitor Network]
11/04/2012 17:14:21 ** firstspotconOperation2: Hardware Name Obtained[D-Link DFE-530TX PCI Fast Ethernet Adapter (rev.C)]
11/04/2012 17:14:21 ** firstspotconOperation2: Hardware ID Obtained[PCI\VEN_1106&DEV_3106&SUBSYS_14031186&REV_86\4&1DF304F3&0&00F0]
11/04/2012 17:14:21 ** firstspotconOperation2{STA_PRIVATE_NIC}: Getting Status
11/04/2012 17:14:21 ** firstspotconOperation2{STA_PRIVATE_NIC}: Visitor NIC started
11/04/2012 17:14:21 ** <=firstspotconOperation2
11/04/2012 17:14:21 ** <=verifyPrivateNicStatus
11/04/2012 17:14:21 entering verify NIC
11/04/2012 17:14:21 verify NIC : Internet NIC{{CA1FCF23-006D-4A92-86C8-AC199FAEADAB}}
11/04/2012 17:14:21 verify NIC : Visitor NIC{{D3BE2DBB-D3ED-4863-9C9F-1D254D92B5E4}}
11/04/2012 17:14:21 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:21 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:21 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:21 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:21 Visitor network interface card Component
11/04/2012 17:14:21 ** showNICComponent ->
11/04/2012 17:14:21 ** showNICComponent: using IPv4
11/04/2012 17:14:21 ** showNICComponent: [UNBIND] Internet Protocol Version 6 (TCP/IPv6)
11/04/2012 17:14:21 ** showNICComponent: [BIND] Internet Protocol Version 4 (TCP/IPv4)
11/04/2012 17:14:21 ** showNICComponent: [UNBIND] Link-Layer Topology Discovery Mapper I/O Driver
11/04/2012 17:14:21 ** showNICComponent: [UNBIND] Link-Layer Topology Discovery Responder
11/04/2012 17:14:21 ** showNICComponent: [BIND] Net-Peeker Kernel Driver
11/04/2012 17:14:21 ** showNICComponent: [BIND] PatronSoft NAT Driver
11/04/2012 17:14:21 ** showNICComponent: [BIND] PatronSoft FirstHop Driver
11/04/2012 17:14:21 ** showNICComponent: [UNBIND] QoS Packet Scheduler
11/04/2012 17:14:21 ** showNICComponent: [BIND] File and Printer Sharing for Microsoft Networks
11/04/2012 17:14:21 ** showNICComponent: [BIND] Client for Microsoft Networks
11/04/2012 17:14:21 ** <- showNICComponent
11/04/2012 17:14:21 leaving verify NIC
11/04/2012 17:14:21 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:21 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:21 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 17:14:21 ** is64: 64-bit
11/04/2012 17:14:21 ** IsWow64: Support IsWow64Process()
11/04/2012 17:14:21 ** is64: The process is running under WOW64.
11/04/2012 17:14:21 license key valid, running Premium edition
11/04/2012 17:14:21 ** RestartApacheService=>
11/04/2012 17:14:21 ** RestartApacheService: restart gracefully
11/04/2012 17:14:26 ** <=RestartApacheService
11/04/2012 17:14:26 ** StopUnusedServices=>
11/04/2012 17:14:26 ** StopUnusedServices: SharedAccess
11/04/2012 17:14:26 ** Service: Skip disable Vista Firewall [0]
11/04/2012 17:14:26 ** StopUnusedServices: Turn the Vista firewall off for all profiles
11/04/2012 17:14:26 ** StopUnusedServices: DNS
11/04/2012 17:14:26 ** StopUnusedServices: DHCPServer
11/04/2012 17:14:26 ** <=StopUnusedServices
11/04/2012 17:14:26 ** modifyRRAS=>
11/04/2012 17:14:26 ** resetRRAS ->
11/04/2012 17:14:27 ** resetRRAS: remove visitor NIC
11/04/2012 17:14:27 ** resetRRAS: add visitor NIC
11/04/2012 17:14:27 ** <- resetRRAS
11/04/2012 17:14:27 ** modifyRRAS: Configuring
11/04/2012 17:14:27 ** modifyRRAS: parameter not found, Windows Server 2008 R2 will using default
11/04/2012 17:14:27 ** modifyRRAS: Skip set 1.1.1.1 route
11/04/2012 17:14:27 ** restartRRAS->
11/04/2012 17:14:27 ** restartRRAS: OpenService
11/04/2012 17:14:27 ** restartRRAS: Stopping
11/04/2012 17:14:27 ** restartRRAS: starting
11/04/2012 17:14:27 ** <-restartRRAS
11/04/2012 17:14:27 ** <=modifyRRAS
11/04/2012 17:14:27 ** modifyDNS ->
11/04/2012 17:14:28 Preferred DNS List: 65.55.206.200
11/04/2012 17:14:28 DNS List: 65.55.206.201
11/04/2012 17:14:28 using DNS List
65.55.206.200;
65.55.206.201;
11/04/2012 17:14:28 ** WriteBindCfg: dnsOrFilename[C:\Program Files (x86)\FirstSpot\dns\etc\..\..\DNS_override.txt]
11/04/2012 17:14:28 ** WriteBindCfg: DNS override [dnsoverridetest.com -> 127.0.0.1]
11/04/2012 17:14:28 ** WriteBindCfg: bindpath[C:\Program Files (x86)\FirstSpot\dns\etc\]
11/04/2012 17:14:28 ** <- modifyDNS
11/04/2012 17:14:29 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:29 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:29 ** GetMacAddress: (mac 00:19:5b:70:61:85) [current]
11/04/2012 17:14:29 Multiple Network Segment Count = (0)
11/04/2012 17:14:29 ** WriteROUTERCfg : Ignore Multiple Network Segment Proc for non-ADV MODE USER **
11/04/2012 17:14:29 Quit WriteROUTERCfg!
11/04/2012 17:14:30 ** StartFirstSpot: (INFO) Start PSNAT
11/04/2012 17:14:30 ** setdispatcher=>
11/04/2012 17:14:30 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:30 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:30 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 17:14:30 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:30 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:30 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 17:14:30 ** setdispatcher : Enforce MAC address session handling for non-ADV USER
11/04/2012 17:14:30 ** setdispatcher : SMTP Roaming OFF
11/04/2012 17:14:30 ** setdispatcher : Public Adapter IP[65.55.206.200]
11/04/2012 17:14:30 ** setdispatcher : Private IP(192.168.0.0)
11/04/2012 17:14:30 ** setdispatcher : idle timeout(60)
11/04/2012 17:14:30 ** setdispatcher : driver timeout(1)
11/04/2012 17:14:30 ** setdispatcher : Gateway IP(192.168.192.1)
11/04/2012 17:14:30 ** setdispatcher : Listen Port(5786)
11/04/2012 17:14:30 ** setdispatcher : Auth Port(5788)
11/04/2012 17:14:30 ** setdispatcher : Redirect Port(5790)
11/04/2012 17:14:30 ** setdispatcher : Authenicate IP(192.168.192.1)
11/04/2012 17:14:30 ** setdispatcher : Up Load Limit(0)
11/04/2012 17:14:30 ** setdispatcher : Down Load Limit(0)
11/04/2012 17:14:30 ** setdispatcher : Interval(1)
11/04/2012 17:14:30 ** setdispatcher : Drop Period(2)
11/04/2012 17:14:30 ** setdispatcher : PKTInterval(20)
11/04/2012 17:14:30 ** setdispatcher : Restricted Redirect ON
11/04/2012 17:14:30 ** setdispatcher : Logout automatically when Infobox is closed ( OFF)
11/04/2012 17:14:30 ** setdispatcher : Internet Surfing Break ( OFF)
11/04/2012 17:14:30 ** <=setdispatcher
11/04/2012 17:14:30 ** PortMapInit=>
11/04/2012 17:14:30 ** PortMapAdd: (INFO) Add public port [5901] protocol [TCP,UDP] private [192.168.192.207:5901]
11/04/2012 17:14:30 ** PortMapAdd: (INFO) Add public port [80] protocol [TCP] private [192.168.192.190:80]
11/04/2012 17:14:30 ** PortMapAdd: (INFO) Add public port [5801] protocol [TCP,UDP] private [192.168.192.207:5801]
11/04/2012 17:14:30 ** <=PortMapInit
11/04/2012 17:14:30 ** StartServiceThread: Create Connection Pool
11/04/2012 17:14:30 ** MonitorConnectionNumberThread: =>
11/04/2012 17:14:30 ** InitialCaptureThread:=>
11/04/2012 17:14:30 ** <=InitialCaptureThread:
11/04/2012 17:14:30 ** PipeListenThread=>
11/04/2012 17:14:30 ** DeviceNotifyDBLogin=>
11/04/2012 17:14:30 ** ObtainClientBlReportThread=>
11/04/2012 17:14:30 ** MonitorConnectionNumberThread: =>
11/04/2012 17:14:30 ** ObtainHttpReportThread=>
11/04/2012 17:14:30 ** ObtainBWReportThread=>
11/04/2012 17:14:30 ** DeviceNotifyDB=>
11/04/2012 17:14:30 ** Reset All Accounts
11/04/2012 17:14:30 ** InitFailOver=>
11/04/2012 17:14:30 ** InitFailOver: IOCTL_INIT_FAILOVER SUCCESS
11/04/2012 17:14:30 ** <=InitFailOver
11/04/2012 17:14:30 ** EnableDrvBlock: BLOCK_ICMP ENABLED
11/04/2012 17:14:30 ** EnableDrvBlock: IOCTL_CMD_ENABLE_BLOCK_ICMP SUCCESS
11/04/2012 17:14:30 ** EnableDrvBlock: BLOCK_UDP ENABLED
11/04/2012 17:14:30 ** EnableDrvBlock: IOCTL_CMD_ENABLE_BLOCK_UDP SUCCESS
11/04/2012 17:14:30 ** EnableDrvDP: IOCTL_CMD_ENABLE_DEBUG SUCCESS, debug_level=1
11/04/2012 17:14:30 ** EnableDrvDP: IOCTL_CMD_DEBUG_PATH_INIT SUCCESS
11/04/2012 17:14:30 ** InitAllowIPTable: IOCTL_CMD_ALLOWED_IP_INIT SUCCESS
11/04/2012 17:14:30 ** read_client_pass ->
11/04/2012 17:14:30 ** read_client_pass: file name=C:\Program Files (x86)\FirstSpot\config.ini, session=0
11/04/2012 17:14:30 ** read_client_pass: MAC={00-1E-2A-52-83-11}{19255716879872}{19255716879872}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={84-2B-2B-89-D0-95}{164722887043972}{164722887043972}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={A4-BA-DB-D4-6C-93}{162095636920996}{162095636920996}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={B4-07-F9-F3-A3-13}{21594893780916}{21594893780916}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={00-24-E8-17-5D-5E}{103753926059008}{103753926059008}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={14-FE-B5-9D-17-83}{144137453436436}{144137453436436}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={00-21-70-2C-72-FB}{276467790389504}{276467790389504}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={00-10-18-32-16-05}{5592887857152}{5592887857152}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** read_client_pass: MAC={00-C0-EE-8B-B0-D4}{233854727012352}{233854727012352}
11/04/2012 17:14:30 ** read_client_pass: IOCTL_CMD_ADD_CLIENT_PASS SUCCESS
11/04/2012 17:14:30 ** <- read_client_pass
11/04/2012 17:14:30 ** read_port_filter ->
11/04/2012 17:14:30 ** <- read_port_filter
11/04/2012 17:14:30 ** read_acl ->
11/04/2012 17:14:30 ** read_acl: ip [2982193344] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3149965504] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [2864752832] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [2915084480] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [2881530048] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3066079424] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3183519936] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3200297152] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3233851584] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3267406016] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3284183232] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3317737664] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3334514880] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [2797643968] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3435178176] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3451955392] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3468732608] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3485509824] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3502287040] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3519064256] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3569395904] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3619727552] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3636504768] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3703613632] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3703613632] mask [16777215]
11/04/2012 17:14:30 ** read_acl: ip [3720390848] mask [16777215]
11/04/2012 17:14:30 ** <- read_acl
11/04/2012 17:14:30 ** ProcURLTrackingRange=>
11/04/2012 17:14:30 ** ProcURLTrackingRange: (INFO) Type[1]
11/04/2012 17:14:30 ** <=ProcURLTrackingRange
11/04/2012 17:14:30 ** StartFirstSpot: QoS is not supported in non-adv edition
11/04/2012 17:14:30 ** indicate_subnetmask: IOCTL_CMD_GET_SUBNETMASK SUCCESS, sm.smask={255.255.0.0}
11/04/2012 17:14:30 ** Filter Initialized
11/04/2012 17:14:30 ** InitOtherSiteClientFlt Initialized
11/04/2012 17:14:30 ** init_uatoken=>
11/04/2012 17:14:30 ** init_uatoken: Ignore to Init
11/04/2012 17:14:30 ** <=init_uatoken
11/04/2012 17:14:30 Bandwidth Throttle (Overall Upload Limit:(0)KB/s Overall Download Limit:(0)KB/s)
11/04/2012 17:14:30 ** ClearTmpURL: SQLExecute[DELETE FROM tmpurl ;] fails
11/04/2012 17:14:30 ** ObtainHttpReportThread: ClearTmpURL Fail
11/04/2012 17:14:35 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155475;] fails
11/04/2012 17:14:38 ** AddPassiveLoginMAC=>
11/04/2012 17:14:38 ** MonitorFSR=>
11/04/2012 17:14:38 ** QueryAllPassiveLogin: [eid207(00-24-E8-17-9C-AC)]
11/04/2012 17:14:38 ** PrintUserInfo(0): Add user mac(00-24-E8-17-9C-AC) ,timeleft(Unlimit) ,Upload Limit(Unlimit) ,Download Limit(Unlimit) ,Data transfer D/L Count On, Accumulated[1312KB], QUOTA OFF ,Data transfer U/L Count On, Accumulated[381KB], QUOTA OFF, Data transfer sharing OFF ,Expire Date [NEVER] ,Start Date [11-04-2012 14:54:51] ,ACL [OFF], User port filter OFF
11/04/2012 17:14:38 ** CreateBWUsageMemory: BWUsage[0]
11/04/2012 17:14:38 ** CreateBWUsageMemory_ul: BWUsage[0]
11/04/2012 17:14:38 ** CreateBWLL: Counting is enabled.
11/04/2012 17:14:38 ** HaveIBMsgExist: SQLFetch[SELECT iBMsg_glo, iBMsg_per FROM fsusr WHERE name = '00-24-E8-17-9C-AC';] Fail
11/04/2012 17:14:38 ** CheckIBMsg: haveIbMsg [0]
11/04/2012 17:14:38 ** AddPassiveLoginMAC: IOCTL_CMD_PL_MAC_RESET SUCCESS
11/04/2012 17:14:38 ** AddPassiveLoginMAC: IOCTL_CMD_ADD_MAC_USERNAME SUCCESS
11/04/2012 17:14:38 ** <=AddPassiveLoginMAC
11/04/2012 17:14:38 <------ batch_fP_RetValue stats : 0.
11/04/2012 17:14:38 IoctlNdisQueryGlobalStats ->
11/04/2012 17:14:38 ** StartFirstSpot: no Batch File or Failed the execution
11/04/2012 17:14:38 <- IoctlNdisQueryGlobalStats
11/04/2012 17:14:38 ** StartFirstSpot: MonitorPMem Thread Created
11/04/2012 17:14:38 ** GetMacAddress: (mac 00:19:5b:70:61:85) [permanent]
11/04/2012 17:14:38 ** MonitorPMem=>
11/04/2012 17:14:38 ** Service: FirstSpot starts successfully.
11/04/2012 17:14:41 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155479;] fails
11/04/2012 17:14:46 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155481;] fails
11/04/2012 17:14:48 ** AddressThread: Status Code[0] site2
11/04/2012 17:14:48 ** AddressThread: Normal Mode ON
11/04/2012 17:14:48 ** AddressThread: Online validation check succeeds
11/04/2012 17:14:55 ** DeviceNotifyDBLogin: reseted DeviceNotifyDBLogin event
11/04/2012 17:14:55 ** DeviceNotifyDBLogin: total clients[1]
11/04/2012 17:14:55 ** DeviceNotifyDBLogin: mac address (00-24-E8-17-9C-AC) Login
11/04/2012 17:14:55 ** NotifyDBLoginODBC: user[00-24-E8-17-9C-AC] login successfully
11/04/2012 17:14:56 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155494;] fails
11/04/2012 17:15:02 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155496;] fails
11/04/2012 17:15:07 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155503;] fails
11/04/2012 17:15:13 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155508;] fails
11/04/2012 17:15:19 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155513;] fails
11/04/2012 17:15:24 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155523;] fails
11/04/2012 17:15:29 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155526;] fails
11/04/2012 17:15:40 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155538;] fails
11/04/2012 17:15:45 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155540;] fails
11/04/2012 17:15:52 ** AuthLoginODBC: Authenticate[tth]
11/04/2012 17:15:52 ** RetVal[1]
11/04/2012 17:15:52 ** AuthLoginODBC:[tth] recur_option[0], week_sch[0], start time[-1], end time[-1]
11/04/2012 17:15:52 ** AuthLoginODBC: Current Time [Wed Apr 11 17:15:52 2012], EDate [N/A]
11/04/2012 17:15:52 ** AuthLoginODBC:[tth] browser Information (Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20100101 Firefox/11.0)
11/04/2012 17:15:52 ** AuthLoginODBC: haveIbMsg [0]
11/04/2012 17:15:52 ** PrintUserInfo(1360): Add user mac(00-24-E8-17-9C-EF) ,timeleft(Unlimit) ,Upload Limit(Unlimit) ,Download Limit(Unlimit) ,Data transfer D/L Count On, Accumulated[56954KB], QUOTA OFF ,Data transfer U/L Count On, Accumulated[3119KB], QUOTA OFF, Data transfer sharing OFF ,Expire Date [NEVER] ,ACL [OFF], User port filter OFF
11/04/2012 17:15:52 ** CreateBWUsageMemory: BWUsage[0]
11/04/2012 17:15:52 ** CreateBWUsageMemory_ul: BWUsage[0]
11/04/2012 17:15:52 ** CreateBWLL: Counting is enabled.
11/04/2012 17:15:52 ** insert_entry=>
11/04/2012 17:15:52 ** <=insert_entry
11/04/2012 17:15:52 ** StartServiceThread: (check) OP_ADD [1]
11/04/2012 17:15:56 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155550;] fails
11/04/2012 17:16:01 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155556;] fails
11/04/2012 17:16:02 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'autos.yahoo.com' and RESERVED1 > 1334155557 and DESTIP = '98.136.70.45' AND destport = 80] Fail
11/04/2012 17:16:02 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'l.yimg.com' and RESERVED1 > 1334155558 and DESTIP = '81.52.205.168' AND destport = 80] Fail
11/04/2012 17:16:02 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'ad.doubleclick.net' and RESERVED1 > 1334155558 and DESTIP = '173.194.34.187' AND destport = 80] Fail
11/04/2012 17:16:02 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'ads.bluelithium.com' and RESERVED1 > 1334155559 and DESTIP = '217.163.21.36' AND destport = 80] Fail
11/04/2012 17:16:02 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'ad.yieldmanager.com' and RESERVED1 > 1334155559 and DESTIP = '217.163.21.37' AND destport = 80] Fail
11/04/2012 17:16:03 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = '128.248.255.255' and RESERVED1 > 1334155559 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 17:16:07 ** AuthLoginODBC: Authenticate[user01]
11/04/2012 17:16:07 ** RetVal[1]
11/04/2012 17:16:07 ** AuthLoginODBC:[user01] recur_option[0], week_sch[0], start time[-1], end time[-1]
11/04/2012 17:16:07 ** AuthLoginODBC: Current Time [Wed Apr 11 17:16:07 2012], EDate [N/A]
11/04/2012 17:16:07 ** AuthLoginODBC:[user01] browser Information (Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20100101 Firefox/11.0)
11/04/2012 17:16:07 ** AuthLoginODBC: haveIbMsg [0]
11/04/2012 17:16:07 ** PrintUserInfo(1288): Add user mac(E8-39-DF-32-AA-56) ,timeleft(Unlimit) ,Upload Limit(Unlimit) ,Download Limit(Unlimit) ,Data transfer D/L Count On, Accumulated[126926KB], QUOTA OFF ,Data transfer U/L Count On, Accumulated[30884KB], QUOTA OFF, Data transfer sharing OFF ,Expire Date [NEVER] ,ACL [OFF], User port filter OFF
11/04/2012 17:16:07 ** CreateBWUsageMemory: BWUsage[0]
11/04/2012 17:16:07 ** CreateBWUsageMemory_ul: BWUsage[0]
11/04/2012 17:16:07 ** CreateBWLL: Counting is enabled.
11/04/2012 17:16:07 ** insert_entry=>
11/04/2012 17:16:07 ** <=insert_entry
11/04/2012 17:16:07 ** StartServiceThread: (check) OP_ADD [1]
11/04/2012 17:16:08 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155561;] fails
11/04/2012 17:16:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'l.yimg.com' and RESERVED1 > 1334155561 and DESTIP = '81.52.205.168' AND destport = 80] Fail
11/04/2012 17:16:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 's0.2mdn.net' and RESERVED1 > 1334155563 and DESTIP = '173.194.34.188' AND destport = 80] Fail
11/04/2012 17:16:08 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'us.bc.yahoo.com' and RESERVED1 > 1334155564 and DESTIP = '87.248.121.190' AND destport = 80] Fail
11/04/2012 17:16:09 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'csc.beap.bc.yahoo.com' and RESERVED1 > 1334155564 and DESTIP = '76.13.234.74' AND destport = 80] Fail
11/04/2012 17:16:09 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '193.120.199.12' and RESERVED1 > 1334155567 and DESTIP = '193.120.199.12' AND destport = 443] Fail
11/04/2012 17:16:09 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '193.120.199.14' and RESERVED1 > 1334155567 and DESTIP = '193.120.199.14' AND destport = 443] Fail
11/04/2012 17:16:09 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '213.146.189.206' and RESERVED1 > 1334155567 and DESTIP = '213.146.189.206' AND destport = 443] Fail
11/04/2012 17:16:09 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '213.146.189.203' and RESERVED1 > 1334155567 and DESTIP = '213.146.189.203' AND destport = 443] Fail
11/04/2012 17:16:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '193.120.199.15' and RESERVED1 > 1334155567 and DESTIP = '193.120.199.15' AND destport = 443] Fail
11/04/2012 17:16:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '193.120.199.16' and RESERVED1 > 1334155567 and DESTIP = '193.120.199.16' AND destport = 443] Fail
11/04/2012 17:16:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '213.146.189.205' and RESERVED1 > 1334155567 and DESTIP = '213.146.189.205' AND destport = 443] Fail
11/04/2012 17:16:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '213.146.189.204' and RESERVED1 > 1334155567 and DESTIP = '213.146.189.204' AND destport = 443] Fail
11/04/2012 17:16:10 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '193.120.199.13' and RESERVED1 > 1334155567 and DESTIP = '193.120.199.13' AND destport = 443] Fail
11/04/2012 17:16:11 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '213.146.189.201' and RESERVED1 > 1334155567 and DESTIP = '213.146.189.201' AND destport = 443] Fail
11/04/2012 17:16:11 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '213.146.189.202' and RESERVED1 > 1334155567 and DESTIP = '213.146.189.202' AND destport = 443] Fail
11/04/2012 17:16:16 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155568;] fails
11/04/2012 17:16:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'apps.skype.com' and RESERVED1 > 1334155571 and DESTIP = '2.21.238.161' AND destport = 443] Fail
11/04/2012 17:16:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.centarahotelsresorts.com' and RESERVED1 > 1334155572 and DESTIP = '202.183.167.71' AND destport = 80] Fail
11/04/2012 17:16:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'connect.facebook.net' and RESERVED1 > 1334155572 and DESTIP = '2.22.79.139' AND destport = 443] Fail
11/04/2012 17:16:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334155573 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 17:16:17 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.facebook.com' and RESERVED1 > 1334155573 and DESTIP = '69.171.242.74' AND destport = 80] Fail
11/04/2012 17:16:18 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'secure.fastbooking.com' and RESERVED1 > 1334155575 and DESTIP = '198.64.158.41' AND destport = 80] Fail
11/04/2012 17:16:18 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'tracking.fastbooking.net' and RESERVED1 > 1334155575 and DESTIP = '198.104.151.66' AND destport = 80] Fail
11/04/2012 17:16:23 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155576;] fails
11/04/2012 17:16:23 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.centarahotelsresorts.com' and RESERVED1 > 1334155576 and DESTIP = '202.183.167.71' AND destport = 80] Fail
11/04/2012 17:16:23 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'bergamo.corriere.it' and RESERVED1 > 1334155577 and DESTIP = '194.20.158.241' AND destport = 80] Fail
11/04/2012 17:16:24 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'lvs.truehits.in.th' and RESERVED1 > 1334155577 and DESTIP = '203.151.21.62' AND destport = 80] Fail
11/04/2012 17:16:24 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.google-analytics.com' and RESERVED1 > 1334155577 and DESTIP = '74.125.230.128' AND destport = 80] Fail
11/04/2012 17:16:24 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'bt.rcs.it' and RESERVED1 > 1334155580 and DESTIP = '194.20.158.109' AND destport = 80] Fail
11/04/2012 17:16:24 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'video.corriere.it' and RESERVED1 > 1334155580 and DESTIP = '194.20.158.101' AND destport = 80] Fail
11/04/2012 17:16:25 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'images.bergamo.corriereobjects.it' and RESERVED1 > 1334155580 and DESTIP = '194.20.158.243' AND destport = 80] Fail
11/04/2012 17:16:25 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'images.corriere.it' and RESERVED1 > 1334155581 and DESTIP = '194.20.158.103' AND destport = 80] Fail
11/04/2012 17:16:25 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'oas.rcsadv.it' and RESERVED1 > 1334155581 and DESTIP = '208.81.234.97' AND destport = 80] Fail
11/04/2012 17:16:30 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155583;] fails
11/04/2012 17:16:31 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'bergamo.corriere.it' and RESERVED1 > 1334155583 and DESTIP = '194.20.158.241' AND destport = 80] Fail
11/04/2012 17:16:31 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'images.bergamo.corriereobjects.it' and RESERVED1 > 1334155583 and DESTIP = '194.20.158.243' AND destport = 80] Fail
11/04/2012 17:16:31 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'oas.rcsadv.it' and RESERVED1 > 1334155590 and DESTIP = '208.81.234.97' AND destport = 80] Fail
11/04/2012 17:16:36 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155590;] fails
11/04/2012 17:16:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'ad.doubleclick.net' and RESERVED1 > 1334155590 and DESTIP = '173.194.34.188' AND destport = 80] Fail
11/04/2012 17:16:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'bergamo.corriere.it' and RESERVED1 > 1334155590 and DESTIP = '194.20.158.241' AND destport = 80] Fail
11/04/2012 17:16:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'css2.corriereobjects.it' and RESERVED1 > 1334155590 and DESTIP = '213.254.248.10' AND destport = 80] Fail
11/04/2012 17:16:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334155591 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 17:16:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'images2.corriereobjects.it' and RESERVED1 > 1334155591 and DESTIP = '46.33.74.25' AND destport = 80] Fail
11/04/2012 17:16:37 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'annunci.corriere.it' and RESERVED1 > 1334155591 and DESTIP = '194.20.158.101' AND destport = 80] Fail
11/04/2012 17:16:38 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.facebook.com' and RESERVED1 > 1334155591 and DESTIP = '69.171.242.74' AND destport = 80] Fail
11/04/2012 17:16:38 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.google-analytics.com' and RESERVED1 > 1334155591 and DESTIP = '74.125.230.128' AND destport = 80] Fail
11/04/2012 17:16:38 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'secure-it.imrworldwide.com' and RESERVED1 > 1334155591 and DESTIP = '212.239.41.101' AND destport = 80] Fail
11/04/2012 17:16:38 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'metrics.rcsmetrics.it' and RESERVED1 > 1334155592 and DESTIP = '66.235.156.129' AND destport = 80] Fail
11/04/2012 17:16:38 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'external.ak.fbcdn.net' and RESERVED1 > 1334155592 and DESTIP = '81.52.205.151' AND destport = 80] Fail
11/04/2012 17:16:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'css.corriereobjects.it' and RESERVED1 > 1334155592 and DESTIP = '194.20.158.103' AND destport = 80] Fail
11/04/2012 17:16:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334155593 and DESTIP = '66.220.151.84' AND destport = 80] Fail
11/04/2012 17:16:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'download.windowsupdate.com' and RESERVED1 > 1334155593 and DESTIP = '46.33.74.131' AND destport = 80] Fail
11/04/2012 17:16:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'advloc.alice.it' and RESERVED1 > 1334155593 and DESTIP = '212.48.1.160' AND destport = 80] Fail
11/04/2012 17:16:39 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'adimg.alice.it' and RESERVED1 > 1334155594 and DESTIP = '212.48.1.174' AND destport = 80] Fail
11/04/2012 17:16:44 ** TruncTmpURL: SQLExecute[DELETE FROM tmpurl WHERE reserved1 <= 1334155596;] fails
11/04/2012 17:16:45 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'tth' and URL = 'www.update.microsoft.com.nsatc.net' and RESERVED1 > 1334155597 and DESTIP = '65.55.200.139' AND destport = 443] Fail
11/04/2012 17:16:45 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = 'www.facebook.com' and RESERVED1 > 1334155597 and DESTIP = '69.171.242.74' AND destport = 80] Fail
11/04/2012 17:16:45 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '128.248.255.255' and RESERVED1 > 1334155597 and DESTIP = '128.248.255.255' AND destport = 63616] Fail
11/04/2012 17:16:45 ** WriteToDBLogURL: SQLExecute[SELECT * FROM tmpurl WHERE NAME = 'user01' and URL = '0-174.channel.facebook.com' and RESERVED1 > 1334155599 and DESTIP = '66.220.151.84' AND destport = 80] Fail

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Please switch back to the default datasource, and copy the tmpurl.dbf using the above steps.
_________________
~ Patronsoft Limited ~

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Actually, it looks like FirstSpot is using the local tmpurl.dbf even if you change the datasource to MySQL. So please perform the above steps to reset the tmpurl table.
_________________
~ Patronsoft Limited ~

nottinghub · Joined: 31 Mar 2012 Posts: 15

The issue is now resolved.

As per your instructions, I did the following
1) shutdown FirstSpot
2) replace tmpurl.dbf under datasource directory with the "blank" file from the original setup zip file
3) start FirstSpot

it seems the tmpurl.dbf (14MB file) had become corrupted...am still not quite sure what caused it though...

thanks for your help