API tools faq
paste
cyberzeus

log for sophos ios network agent auto-disconnect

cyberzeus
Nov 19th, 2017
126
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 154.98 KB | None | 0 0
raw download clone embed print report
  1. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  2. INFO Nov 19 13:39:26 [4144125760]: (listen_callback): New connection from [ IPHONE-IP_MASKED ]
  3. INFO Nov 19 13:39:26 [4144125760]: (CA_add_conn): Successfully added IP [ IPHONE-IP_MASKED ]
  4. DEBUG Nov 19 13:39:26 [4144125760]: (CA_add_conn): Created new conn 0x830d958 generation 14
  5. DEBUG Nov 19 13:39:26 [4144125760]: (listen_callback): conn 0x830d958 generation 14, ssl 0x830dfb8 created
  6. INFO Nov 19 13:39:26 [4144125760]: (register_epoll): Successfully registered epoll for fd 26, ep_data 0x8320708
  7. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  8. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  9. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  10. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  11. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  12. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  13. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  14. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  15. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  16. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  17. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  18. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  19. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  20. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  21. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  22. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  23. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  24. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  25. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  26. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  27. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Read 6 bytes on fd 26
  28. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): SSL read: xxx4xx
  29. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Processing command: xxx4xx
  30. INFO Nov 19 13:39:26 [4144125760]: (process_command): Number of received TLVs: 1
  31. MESSAGE Nov 19 13:39:26 [4144125760]: (process_command): Client type is IOS
  32. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): No AA_MESS_DEVICE_ID TLV found in chain
  33. DEBUG Nov 19 13:39:26 [4144125760]: (send_data): SSL write: xxxxx
  34. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  35. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  36. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  37. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  38. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Read 1 bytes on fd 26
  39. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): SSL read: x
  40. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Buffered: x
  41. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  42. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  43. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  44. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  45. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Read 20 bytes on fd 26
  46. INFO Nov 19 13:39:26 [4144125760]: (process_command): Number of received TLVs: 2
  47. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Allocated user 0x8320490 username [ IPHONE-USERNAME_MASKED ]
  48. DEBUG Nov 19 13:39:26 [4144125760]: (lc_utf8_bytes): lowercase = '[ IPHONE-USERNAME_MASKED ]'
  49. DEBUG Nov 19 13:39:26 [4144125760]: (CA_authenticate_user): Request data prepared for user [ IPHONE-USERNAME_MASKED ]
  50. INFO Nov 19 13:39:26 [4144125760]: (print_req_data): username:[ IPHONE-USERNAME_MASKED ]
  51. INFO Nov 19 13:39:26 [4144125760]: (print_req_data): password:xx...x
  52. INFO Nov 19 13:39:26 [4144125760]: (print_req_data): macaddress:
  53. INFO Nov 19 13:39:26 [4144125760]: (print_req_data): ipaddress:[ IPHONE-IP_MASKED ]
  54. INFO Nov 19 13:39:26 [4144125760]: (print_req_data): domainname:
  55. INFO Nov 19 13:39:26 [4144125760]: (print_req_data): clienttype:19
  56. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=3 req_handler=0x80a1949 res_handler=0x807850b handler_data=0x8320230
  57. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  58. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  59. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  60. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  61. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  62. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=3
  63. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  64. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  65. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  66. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  67. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  68. DEBUG Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  69. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  70. DEBUG Nov 19 13:39:26 [4140821312]: handle_server_events: EVENT_READ
  71. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  72. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  73. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  74. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  75. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=3 handler_data=0x8320230 res_handler=0x807850b
  76. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x8133e14
  77. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_BYIP
  78. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_BYIP, [ IPHONE-IP_MASKED ]) succeeded
  79. INFO Nov 19 13:39:26 [4140821312]: (_sqlite_db_handle_liveuser_byip): GET_LIVEUSER_BYIP found no entries (sqrs 101)
  80. DEBUG Nov 19 13:39:26 [4140821312]: (_sqlite_db_handle_liveuser_byip): returning 0
  81. DEBUG Nov 19 13:39:26 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  82.  
  83. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  84. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  85. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  86. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  87. INFO Nov 19 13:39:26 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  88. DEBUG Nov 19 13:39:26 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  89. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  90. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  91. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  92. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  93. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  94. INFO Nov 19 13:39:26 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  95. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  96. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  97. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  98. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read blocked
  99. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  100. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  101. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x807850b
  102. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  103. DEBUG Nov 19 13:39:26 [4144125760]: authenticate: SQLITE_REQ_GETLIVEUSER_BYIP Successful
  104. INFO Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  105. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=POSTGRES_DB req_type=34 req_handler=0x8095f19 res_handler=0x80782ab handler_data=0x8320230
  106. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  107. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
  108. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  109. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
  110. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  111. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=34
  112. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  113. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x826d1b8
  114. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
  115. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
  116. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
  117. DEBUG Nov 19 13:39:26 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
  118. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  119. DEBUG Nov 19 13:39:26 [4141873984]: handle_server_events: EVENT_READ
  120. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  121. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: READING... fd=9
  122. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  123. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
  124. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  125. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=34 handler_data=0x8320230 res_handler=0x80782ab
  126. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  127. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_handle_request): AUTHENTICATE_GUEST_USER triggers alloc_query_vals()
  128. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  129. DEBUG Nov 19 13:39:26 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
  130. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  131. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): executing command 'AUTHENTICATE_GUEST_USER'
  132. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
  133. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[0]: '[ IPHONE-USERNAME_MASKED ]'
  134. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'AUTHENTICATE_GUEST_USER'
  135. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
  136. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_authenticate_guest_user: row count: 1
  137. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_authenticate_guest_user: column:'usertype', value:'5'
  138. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_authenticate_guest_user: Not a Guest user
  139. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
  140. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
  141. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
  142. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
  143. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
  144. INFO Nov 19 13:39:26 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  145. DEBUG Nov 19 13:39:26 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
  146. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  147. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): released lock 0x826d1dc
  148. DEBUG Nov 19 13:39:26 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
  149. DEBUG Nov 19 13:39:26 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
  150. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  151. INFO Nov 19 13:39:26 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
  152. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  153. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: READING... fd=9
  154. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=8
  155. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: read blocked
  156. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
  157. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  158. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x80782ab
  159. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): released lock 0x826d1dc
  160. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=OTP_AUTH req_type=0 req_handler=0x80caa45 res_handler=0x8077939 handler_data=0x8320230
  161. INFO Nov 19 13:39:26 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
  162. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  163. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x82e91c8
  164. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  165. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x82e91c8
  166. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  167. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): OTP_AUTH: request submitted, req_type=0
  168. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x82e91c8
  169. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x82e91c8
  170. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x82e91c8
  171. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x82e91c8
  172. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=15 wq=0x82efb68 buf=0x82efb70 offset=0
  173. DEBUG Nov 19 13:39:26 [4134529856]: subsys_thread_main: OTP_AUTH: event received on fd: 16
  174. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=8
  175. DEBUG Nov 19 13:39:26 [4134529856]: handle_server_events: EVENT_READ
  176. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  177. INFO Nov 19 13:39:26 [4134529856]: (do_handle_read): server: READING... fd=16
  178. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  179. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x826d1b8
  180. INFO Nov 19 13:39:26 [4134529856]: (do_handle_read): server: read 16 bytes, fd=16
  181. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  182. DEBUG Nov 19 13:39:26 [4134529856]: (do_handle_read): server tlv=0x82e8d50 req_handler=0x80caa45 type=0 handler_data=0x8320230 res_handler=0x8077939
  183. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  184. DEBUG Nov 19 13:39:26 [4134529856]: (otp_handle_prepare_authentication_request): OTP prepare authentication for user [ IPHONE-USERNAME_MASKED ]
  185. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  186. DEBUG Nov 19 13:39:26 [4134529856]: (append_subsysqueue): : SERVER, datasize: 16
  187. DEBUG Nov 19 13:39:26 [4134529856]: (append_subsysqueue): acquiring lock 0x82e91ec
  188. DEBUG Nov 19 13:39:26 [4134529856]: (append_subsysqueue): : SERVER, remlen: 160
  189. DEBUG Nov 19 13:39:26 [4134529856]: (append_subsysqueue): released lock 0x82e91ec
  190. INFO Nov 19 13:39:26 [4134529856]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  191. DEBUG Nov 19 13:39:26 [4134529856]: subsys_submit_response: OTP_AUTH: response submitted, res_type=0
  192. DEBUG Nov 19 13:39:26 [4134529856]: (do_handle_write): acquiring lock 0x82e91ec
  193. DEBUG Nov 19 13:39:26 [4134529856]: (do_handle_write): released lock 0x82e91ec
  194. DEBUG Nov 19 13:39:26 [4134529856]: (write_subsysqueue): acquiring lock 0x82e91ec
  195. DEBUG Nov 19 13:39:26 [4134529856]: (write_subsysqueue): released lock 0x82e91ec
  196. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  197. INFO Nov 19 13:39:26 [4134529856]: (write_subsysqueue): SERVER: written 16 bytes, fd=16 wq=0x82e8df8 buf=0x82e8e00 offset=0
  198. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  199. INFO Nov 19 13:39:26 [4134529856]: (do_handle_read): server: READING... fd=16
  200. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=15
  201. INFO Nov 19 13:39:26 [4134529856]: (do_handle_read): server: read blocked
  202. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=15
  203. DEBUG Nov 19 13:39:26 [4134529856]: (do_handle_write): acquiring lock 0x82e91ec
  204. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x82e8eb0 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x8077939
  205. DEBUG Nov 19 13:39:26 [4134529856]: (do_handle_write): released lock 0x82e91ec
  206. DEBUG Nov 19 13:39:26 [4144125760]: (authenticate_user): current server:0, auth_client:0
  207. INFO Nov 19 13:39:26 [4134529856]: subsys_thread_main: OTP_AUTH: waiting for events...
  208. INFO Nov 19 13:39:26 [4144125760]: authenticate_user: Server:0, Local Authentication
  209. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=POSTGRES_DB req_type=35 req_handler=0x8095f19 res_handler=0x8077939 handler_data=0x8320230
  210. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  211. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
  212. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  213. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
  214. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  215. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=35
  216. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  217. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x826d1b8
  218. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
  219. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
  220. DEBUG Nov 19 13:39:26 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
  221. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
  222. DEBUG Nov 19 13:39:26 [4141873984]: handle_server_events: EVENT_READ
  223. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=15
  224. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: READING... fd=9
  225. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  226. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
  227. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x82e91c8
  228. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=35 handler_data=0x8320230 res_handler=0x8077939
  229. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x82e91c8
  230. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_handle_request): AUTHENTICATE_USER triggers alloc_query_vals()
  231. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  232. DEBUG Nov 19 13:39:26 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
  233. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  234. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): executing command 'AUTHENTICATE_USER'
  235. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  236. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
  237. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[0] length=4: 1
  238. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[1] length=4: 5
  239. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[2] length=4: 2
  240. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[3] length=4: 1
  241. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[4]: '[ IPHONE-USERNAME_MASKED ]'
  242. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'AUTHENTICATE_USER'
  243. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
  244. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_handle_authenticate_user): row count: 1
  245. DEBUG Nov 19 13:39:26 [4141873984]: (de_obfuscate): 24f85f2a07025959aec57b6d417a5920f7caa9907a79 decoded, password not empty
  246. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
  247. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
  248. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
  249. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
  250. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
  251. INFO Nov 19 13:39:26 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  252. DEBUG Nov 19 13:39:26 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
  253. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  254. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): released lock 0x826d1dc
  255. DEBUG Nov 19 13:39:26 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
  256. DEBUG Nov 19 13:39:26 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
  257. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  258. INFO Nov 19 13:39:26 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
  259. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  260. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: READING... fd=9
  261. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=8
  262. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: read blocked
  263. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
  264. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  265. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x8077939
  266. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): released lock 0x826d1dc
  267. DEBUG Nov 19 13:39:26 [4144125760]: (authenticate_user): current server:1, auth_client:0
  268. INFO Nov 19 13:39:26 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
  269. DEBUG Nov 19 13:39:26 [4144125760]: authenticate_user: SUCCESS || current_server >= MAX_LIMIT
  270. DEBUG Nov 19 13:39:26 [4144125760]: (is_local_auth): current_server = 0, auth_client = 0, authserver_id = 1, local_authserver_id = 1
  271. DEBUG Nov 19 13:39:26 [4144125760]: (check_auth_result): ==> local user
  272. DEBUG Nov 19 13:39:26 [4144125760]: check_auth_result: Authentication Successful, clienttype=19 auth_client=0
  273. DEBUG Nov 19 13:39:26 [4144125760]: (delete_admin_access_entry): invoked
  274. DEBUG Nov 19 13:39:26 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff430c8 for query 0x8133e28
  275. DEBUG Nov 19 13:39:26 [4144125760]: (bind_parameters_to_statement): Query name IS_ADMIN_IP_EXIST
  276. DEBUG Nov 19 13:39:26 [4144125760]: (check_sqlite_bind_text_result): sqlite3_bind_text(IS_ADMIN_IP_EXIST, [ IPHONE-IP_MASKED ]) succeeded
  277. DEBUG Nov 19 13:39:26 [4144125760]: (handle_count_star_query): IS_ADMIN_IP_EXIST retrieved: count = 0
  278. DEBUG Nov 19 13:39:26 [4144125760]: (handle_count_star_query): returning 0
  279. DEBUG Nov 19 13:39:26 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  280.  
  281. DEBUG Nov 19 13:39:26 [4144125760]: (CA_add_conn_to_user): Allocated user 0x831f008 username 0x8320490 ([ IPHONE-USERNAME_MASKED ])
  282. INFO Nov 19 13:39:26 [4144125760]: (CA_add_conn_to_user): Created new user [ IPHONE-USERNAME_MASKED ]
  283. MESSAGE Nov 19 13:39:26 [4144125760]: (CA_authentication_result): User [ IPHONE-USERNAME_MASKED ] authenticated (CA)
  284. DEBUG Nov 19 13:39:26 [4144125760]: (send_data): SSL write: xxxxx
  285. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=POSTGRES_DB req_type=0 req_handler=0x8095f19 res_handler=0x8072b72 handler_data=0x8320230
  286. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  287. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
  288. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  289. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
  290. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  291. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=0
  292. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  293. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x826d1b8
  294. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
  295. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
  296. DEBUG Nov 19 13:39:26 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
  297. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
  298. DEBUG Nov 19 13:39:26 [4141873984]: handle_server_events: EVENT_READ
  299. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=8
  300. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: READING... fd=9
  301. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  302. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
  303. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  304. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=0 handler_data=0x8320230 res_handler=0x8072b72
  305. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x826d1b8
  306. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_handle_request): GET_USERINFO triggers alloc_query_vals()
  307. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  308. DEBUG Nov 19 13:39:26 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
  309. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  310. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): executing command 'GET_USERINFO'
  311. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  312. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
  313. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[0]: '[ IPHONE-USERNAME_MASKED ]'
  314. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[1] length=4: 1
  315. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[2] length=4: 2
  316. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[3] length=4: 5
  317. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_process_prepq_async): param_value[4] length=4: 8
  318. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'GET_USERINFO'
  319. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
  320. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: row count: 1
  321. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_handle_get_userinfo): pg_server 0x8261160
  322. DEBUG Nov 19 13:39:26 [4141873984]: (pg_db_handle_get_userinfo): building userinfo: integration=0 req_data.groupname='NULL'
  323. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'userid', value:'11'
  324. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'groupid', value:'8'
  325. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'username', value:'[ IPHONE-USERNAME_MASKED ]'
  326. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'name', value:'[ IPHONE-USERNAME_MASKED ]'
  327. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'emailid', value:'[ EMAIL_MASKED ]'
  328. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'name', value:'kids'
  329. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'active', value:'Y'
  330. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'usertype', value:'5'
  331. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'webfilterid', value:'1'
  332. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'appfilterid', value:'1'
  333. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'accesspolicyid', value:'1'
  334. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'bwpolicyid', value:''
  335. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'surfingquotapolicyid', value:'1'
  336. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'datatransferpolicyid', value:''
  337. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'ipallocation', value:'4'
  338. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'allotedminutes', value:'-11'
  339. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'usedminutes', value:'41'
  340. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'cycleusedminutes', value:'41'
  341. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'uploaddata', value:'3137584'
  342. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'downloaddata', value:'91273366'
  343. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'lastusedtime', value:'2017-11-19 12:24:23'
  344. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'cycleupload', value:'3137584'
  345. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'cycledownload', value:'91273366'
  346. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'maxloginallowed', value:'-1'
  347. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'renewdate', value:'2017-11-18'
  348. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'macbinding', value:'1'
  349. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_handle_get_userinfo: column:'ipallocation', value:'1'
  350. DEBUG Nov 19 13:39:26 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
  351. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
  352. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
  353. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
  354. DEBUG Nov 19 13:39:26 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
  355. INFO Nov 19 13:39:26 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  356. DEBUG Nov 19 13:39:26 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
  357. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  358. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): released lock 0x826d1dc
  359. DEBUG Nov 19 13:39:26 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
  360. DEBUG Nov 19 13:39:26 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
  361. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  362. INFO Nov 19 13:39:26 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
  363. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  364. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: READING... fd=9
  365. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=8
  366. INFO Nov 19 13:39:26 [4141873984]: (do_handle_read): server: read blocked
  367. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
  368. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  369. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x8072b72
  370. DEBUG Nov 19 13:39:26 [4141873984]: (do_handle_write): released lock 0x826d1dc
  371. DEBUG Nov 19 13:39:26 [4144125760]: do_authorization: Got User Info Successfully
  372. INFO Nov 19 13:39:26 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
  373. DEBUG Nov 19 13:39:26 [4144125760]: is_currently_allowed: accesspolicy:1
  374. DEBUG Nov 19 13:39:26 [4144125760]: is_currently_allowed: currday:1, hour:13, min:39, currtime:819
  375. INFO Nov 19 13:39:26 [4144125760]: is_currently_allowed: POLICY MATCH. Strategy:'Y'
  376. DEBUG Nov 19 13:39:26 [4144125760]: has_surfing_time: effective_alloted_min:-11, effective_used_min:41
  377. DEBUG Nov 19 13:39:26 [4144125760]: has_surfing_time: YES
  378. INFO Nov 19 13:39:26 [4144125760]: match_surfing_quota: SQuota policy id:1, cycle:80
  379. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=2 req_handler=0x80a1949 res_handler=0x80708bd handler_data=0x8320230
  380. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  381. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  382. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  383. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  384. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  385. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=2
  386. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  387. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  388. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  389. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  390. DEBUG Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  391. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  392. DEBUG Nov 19 13:39:26 [4140821312]: handle_server_events: EVENT_READ
  393. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=8
  394. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  395. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  396. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  397. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  398. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=2 handler_data=0x8320230 res_handler=0x80708bd
  399. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x826d1b8
  400. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x8133e00
  401. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  402. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_BYNAME
  403. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  404. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_BYNAME, [ IPHONE-USERNAME_MASKED ]) succeeded
  405. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  406. DEBUG Nov 19 13:39:26 [4140821312]: (_sqlite_db_handle_liveuser_byname): GET_LIVEUSER_BYNAME retrieved: login_count=0
  407. DEBUG Nov 19 13:39:26 [4140821312]: (_sqlite_db_handle_liveuser_byname): returning 0
  408. DEBUG Nov 19 13:39:26 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  409.  
  410. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  411. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  412. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  413. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  414. INFO Nov 19 13:39:26 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  415. DEBUG Nov 19 13:39:26 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  416. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  417. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  418. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  419. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  420. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  421. INFO Nov 19 13:39:26 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  422. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  423. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  424. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  425. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read blocked
  426. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  427. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  428. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x80708bd
  429. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  430. INFO Nov 19 13:39:26 [4144125760]: do_authorization_phase2: UNL and FREE_IP
  431. INFO Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  432. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: LAST-UID: 3 BYTE-ID: 0
  433. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: BYTE-ID: 0
  434. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: BYTE[0]: 0x3
  435. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: free bits found at BYTE-ID: 0
  436. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: BIT[0] is not free
  437. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: BIT[1] is not free
  438. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: BIT[2] is free
  439. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: Before SET_BIT[2] BYTE[0]: 0x3
  440. DEBUG Nov 19 13:39:26 [4144125760]: uid_allocate: After SET_BIT[2] BYTE[0]: 0x7
  441. INFO Nov 19 13:39:26 [4144125760]: uid_allocate: allocated UID: 2
  442. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=8 req_handler=0x80a1949 res_handler=0x8072f25 handler_data=0x8320230
  443. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  444. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  445. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  446. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  447. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  448. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=8
  449. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  450. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  451. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  452. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  453. DEBUG Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  454. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  455. DEBUG Nov 19 13:39:26 [4140821312]: handle_server_events: EVENT_READ
  456. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  457. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  458. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  459. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  460. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  461. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=8 handler_data=0x8320230 res_handler=0x8072f25
  462. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  463. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Binding 23 parameters 0xf6cfd888 for query 0x8134120
  464. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  465. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Query name INSERT_LIVEUSER
  466. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  467. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 2) succeeded
  468. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  469. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 11) succeeded
  470. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ IPHONE-USERNAME_MASKED ]) succeeded
  471. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ IPHONE-USERNAME_MASKED ]) succeeded
  472. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ IPHONE-USERNAME_MASKED ]) succeeded
  473. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ IPHONE-IP_MASKED ]) succeeded
  474. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 8) succeeded
  475. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 245555) succeeded
  476. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 245555) succeeded
  477. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  478. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  479. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  480. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
  481. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  482. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  483. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
  484. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, 2017-11-18) succeeded
  485. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
  486. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 19) succeeded
  487. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 2) succeeded
  488. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
  489. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
  490. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
  491. DEBUG Nov 19 13:39:26 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  492.  
  493. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  494. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  495. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  496. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  497. INFO Nov 19 13:39:26 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  498. DEBUG Nov 19 13:39:26 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  499. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  500. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  501. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  502. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  503. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  504. INFO Nov 19 13:39:26 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  505. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  506. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  507. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  508. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read blocked
  509. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  510. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  511. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x8072f25
  512. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  513. INFO Nov 19 13:39:26 [4144125760]: handle_liveuser_insert: LIVE USER '[ IPHONE-USERNAME_MASKED ]' INSERTED
  514. INFO Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  515. DEBUG Nov 19 13:39:26 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff43118 for query 0x8133e3c
  516. DEBUG Nov 19 13:39:26 [4144125760]: (bind_parameters_to_statement): Query name ISUSEREXISTS_LIVEUSER_ACC
  517. DEBUG Nov 19 13:39:26 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(ISUSEREXISTS_LIVEUSER_ACC, 11) succeeded
  518. DEBUG Nov 19 13:39:26 [4144125760]: (handle_count_star_query): ISUSEREXISTS_LIVEUSER_ACC retrieved: count = 0
  519. DEBUG Nov 19 13:39:26 [4144125760]: (handle_count_star_query): returning 0
  520. DEBUG Nov 19 13:39:26 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  521.  
  522. DEBUG Nov 19 13:39:26 [4144125760]: (handle_liveuser_insert): INSERTING in LIVEUSER_ACC
  523. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=9 req_handler=0x80a1949 res_handler=0x8072e78 handler_data=0x8320230
  524. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  525. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  526. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  527. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  528. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  529. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=9
  530. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  531. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  532. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  533. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  534. DEBUG Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  535. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  536. DEBUG Nov 19 13:39:26 [4140821312]: handle_server_events: EVENT_READ
  537. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  538. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  539. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  540. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  541. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  542. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=9 handler_data=0x8320230 res_handler=0x8072e78
  543. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  544. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Binding 8 parameters 0xf6cfd888 for query 0x81341d4
  545. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  546. DEBUG Nov 19 13:39:26 [4140821312]: (bind_parameters_to_statement): Query name INSERT_LIVEUSER_ACC
  547. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  548. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 11) succeeded
  549. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  550. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1511127566) succeeded
  551. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 41) succeeded
  552. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 41) succeeded
  553. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 3137584) succeeded
  554. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 91273366) succeeded
  555. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 3137584) succeeded
  556. DEBUG Nov 19 13:39:26 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 91273366) succeeded
  557. DEBUG Nov 19 13:39:26 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  558.  
  559. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  560. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  561. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  562. DEBUG Nov 19 13:39:26 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  563. INFO Nov 19 13:39:26 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  564. DEBUG Nov 19 13:39:26 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  565. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  566. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  567. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  568. DEBUG Nov 19 13:39:26 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  569. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  570. INFO Nov 19 13:39:26 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  571. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  572. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: READING... fd=11
  573. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  574. INFO Nov 19 13:39:26 [4140821312]: (do_handle_read): server: read blocked
  575. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  576. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  577. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x8072e78
  578. DEBUG Nov 19 13:39:26 [4140821312]: (do_handle_write): released lock 0x828fe24
  579. INFO Nov 19 13:39:26 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  580. DEBUG Nov 19 13:39:26 [4144125760]: (login_user): no accounting_server configured
  581. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): subsys_name=OPCODE req_type=0 req_handler=0x80b89ad res_handler=0x8078e4e handler_data=0x8320230
  582. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  583. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): acquiring lock 0x82effb8
  584. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  585. DEBUG Nov 19 13:39:26 [4144125760]: (append_subsysqueue): released lock 0x82effb8
  586. INFO Nov 19 13:39:26 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  587. DEBUG Nov 19 13:39:26 [4144125760]: (subsys_submit_request): OPCODE: request submitted, req_type=0
  588. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x82effb8
  589. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x82effb8
  590. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): acquiring lock 0x82effb8
  591. DEBUG Nov 19 13:39:26 [4133477184]: subsys_thread_main: OPCODE: event received on fd: 18
  592. DEBUG Nov 19 13:39:26 [4133477184]: handle_server_events: EVENT_READ
  593. INFO Nov 19 13:39:26 [4133477184]: (do_handle_read): server: READING... fd=18
  594. INFO Nov 19 13:39:26 [4133477184]: (do_handle_read): server: read 16 bytes, fd=18
  595. DEBUG Nov 19 13:39:26 [4133477184]: (do_handle_read): server tlv=0x82f0038 req_handler=0x80b89ad type=0 handler_data=0x8320230 res_handler=0x8078e4e
  596. ERROR Nov 19 13:39:26 [4133477184]: config_resolve_bwid: BW Policy 0 not found
  597. DEBUG Nov 19 13:39:26 [4133477184]: opcode_handle_login: OPCODE: JSON:'{ "groupid":"kids","userid":"[ IPHONE-USERNAME_MASKED ]","liveuserid":"2","ipaddress":"[ IPHONE-IP_MASKED ]","bwpolicyid":"","webfilterid":"Allow All","appfilterid":"Allow All","starttime":"245555","clienttype":"19","setname":"lusers","addr_family":"2","ismicroapp":"1","authservername":"","macaddress":"","logintime":"2017-11-19 13:39:26" }'
  598. DEBUG Nov 19 13:39:26 [4144125760]: (write_subsysqueue): released lock 0x82effb8
  599. INFO Nov 19 13:39:26 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=17 wq=0x82f4428 buf=0x82f4430 offset=0
  600. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=10
  601. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  602. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  603. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x828fe00
  604. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  605. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  606. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  607. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  608. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Read 1 bytes on fd 26
  609. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): SSL read: x
  610. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Buffered: x
  611. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  612. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  613. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  614. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  615. DEBUG Nov 19 13:39:26 [4144125760]: (process_command): Read 16 bytes on fd 26
  616. INFO Nov 19 13:39:26 [4144125760]: (process_command): Number of received TLVs: 1
  617. MESSAGE Nov 19 13:39:26 [4144125760]: (process_command): Received IP for user [ IPHONE-USERNAME_MASKED ]: [ IPHONE-IP_MASKED ]
  618. INFO Nov 19 13:39:26 [4144125760]: (process_command): IP already present
  619. DEBUG Nov 19 13:39:26 [4144125760]: (send_data): SSL write: xxxxx
  620. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  621. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  622. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  623. INFO Nov 19 13:39:26 [4133477184]: (opcode_handle_login): OPCODE: OPCODE executed successfully
  624. DEBUG Nov 19 13:39:26 [4133477184]: (bind_parameters_to_statement): Binding 3 parameters 0xf65fc88c for query 0x8134314
  625. DEBUG Nov 19 13:39:26 [4133477184]: (bind_parameters_to_statement): Query name GET_LIVEUSERCNT_BYIP_UID_ID
  626. DEBUG Nov 19 13:39:26 [4133477184]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSERCNT_BYIP_UID_ID, 2) succeeded
  627. DEBUG Nov 19 13:39:26 [4133477184]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSERCNT_BYIP_UID_ID, 11) succeeded
  628. DEBUG Nov 19 13:39:26 [4133477184]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSERCNT_BYIP_UID_ID, [ IPHONE-IP_MASKED ]) succeeded
  629. DEBUG Nov 19 13:39:26 [4133477184]: (handle_count_star_query): GET_LIVEUSERCNT_BYIP_UID_ID retrieved: count = 1
  630. DEBUG Nov 19 13:39:26 [4133477184]: (handle_count_star_query): returning 1
  631. DEBUG Nov 19 13:39:26 [4133477184]: (sqlite_db_submit_response): Request processed res=1
  632.  
  633. DEBUG Nov 19 13:39:26 [4133477184]: (exists_live_user): 1 live user {luid 2, uid 11, ip [ IPHONE-IP_MASKED ]}
  634. DEBUG Nov 19 13:39:26 [4133477184]: (append_subsysqueue): : SERVER, datasize: 16
  635. DEBUG Nov 19 13:39:26 [4133477184]: (append_subsysqueue): acquiring lock 0x82effdc
  636. DEBUG Nov 19 13:39:26 [4133477184]: (append_subsysqueue): : SERVER, remlen: 160
  637. DEBUG Nov 19 13:39:26 [4133477184]: (append_subsysqueue): released lock 0x82effdc
  638. INFO Nov 19 13:39:26 [4133477184]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  639. DEBUG Nov 19 13:39:26 [4133477184]: subsys_submit_response: OPCODE: response submitted, res_type=0
  640. DEBUG Nov 19 13:39:26 [4133477184]: (do_handle_write): acquiring lock 0x82effdc
  641. DEBUG Nov 19 13:39:26 [4133477184]: (do_handle_write): released lock 0x82effdc
  642. DEBUG Nov 19 13:39:26 [4133477184]: (write_subsysqueue): acquiring lock 0x82effdc
  643. DEBUG Nov 19 13:39:26 [4133477184]: (write_subsysqueue): released lock 0x82effdc
  644. INFO Nov 19 13:39:26 [4133477184]: (write_subsysqueue): SERVER: written 16 bytes, fd=18 wq=0x82f00e0 buf=0x82f00e8 offset=0
  645. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): returning 1
  646. INFO Nov 19 13:39:26 [4133477184]: (do_handle_read): server: READING... fd=18
  647. DEBUG Nov 19 13:39:26 [4144125760]: handle_client_events: EVENT_READ
  648. INFO Nov 19 13:39:26 [4133477184]: (do_handle_read): server: read blocked
  649. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=17
  650. DEBUG Nov 19 13:39:26 [4133477184]: (do_handle_write): acquiring lock 0x82effdc
  651. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read 16 bytes, fd=17
  652. DEBUG Nov 19 13:39:26 [4133477184]: (do_handle_write): released lock 0x82effdc
  653. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_read): client tlv=0x82f4380 req_handler=(nil) type=0 handler_data=0x8320230 res_handler=0x8078e4e
  654. INFO Nov 19 13:39:26 [4133477184]: subsys_thread_main: OPCODE: waiting for events...
  655. INFO Nov 19 13:39:26 [4144125760]: create_response: AUTHENTICATION SUCCESSFULL
  656. DEBUG Nov 19 13:39:26 [4144125760]: is_incr: 1
  657. DEBUG Nov 19 13:39:26 [4144125760]: get_effective_time: 41
  658. DEBUG Nov 19 13:39:26 [4144125760]: (send_response): Error sending data: Invalid argument
  659. INFO Nov 19 13:39:26 [4144125760]: create_response: RESULT String: inc:41:You have successfully logged in:no
  660. DEBUG Nov 19 13:39:26 [4144125760]: free_session_data: session_data=0x8320230
  661. DEBUG Nov 19 13:39:26 [4144125760]: (reset_user_info): resetting user_info 0xf68021d0
  662. DEBUG Nov 19 13:39:26 [4144125760]: (free_session_data): freeing user_info 0xf68021d0
  663. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: READING... fd=17
  664. INFO Nov 19 13:39:26 [4144125760]: (do_handle_read): client: read blocked
  665. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): acquiring lock 0x82effb8
  666. DEBUG Nov 19 13:39:26 [4144125760]: (do_handle_write): released lock 0x82effb8
  667. DEBUG Nov 19 13:39:26 [4144125760]: (CA_keep_alive): called too soon, seconds = 42, returning
  668. DEBUG Nov 19 13:39:26 [4144125760]: (do_epoll): Waiting for events
  669. DEBUG Nov 19 13:39:26 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=3000
  670. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): returning 0
  671. DEBUG Nov 19 13:39:29 [4144125760]: (CA_keep_alive): Checking connections status
  672. MESSAGE Nov 19 13:39:29 [4144125760]: (CA_keep_alive): Sending PING to [ IPHONE-USERNAME_MASKED ]
  673. DEBUG Nov 19 13:39:29 [4144125760]: (do_epoll): Waiting for events
  674. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  675. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): returning 1
  676. DEBUG Nov 19 13:39:29 [4144125760]: (process_command): Read 1 bytes on fd 26
  677. DEBUG Nov 19 13:39:29 [4144125760]: (process_command): SSL read: x
  678. DEBUG Nov 19 13:39:29 [4144125760]: (process_command): Buffered: x
  679. DEBUG Nov 19 13:39:29 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  680. DEBUG Nov 19 13:39:29 [4144125760]: (do_epoll): Waiting for events
  681. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  682. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): returning 1
  683. DEBUG Nov 19 13:39:29 [4144125760]: (process_command): Read 4 bytes on fd 26
  684. DEBUG Nov 19 13:39:29 [4144125760]: (process_command): SSL read: xxxx
  685. DEBUG Nov 19 13:39:29 [4144125760]: (process_command): Complete command received: xxxxx
  686. DEBUG Nov 19 13:39:29 [4144125760]: (process_command): Processing command: xxxxx
  687. INFO Nov 19 13:39:29 [4144125760]: (process_command): Number of received TLVs: 1
  688. MESSAGE Nov 19 13:39:29 [4144125760]: (process_command): PONG 1 from [ IPHONE-USERNAME_MASKED ]
  689. DEBUG Nov 19 13:39:29 [4144125760]: (lc_utf8_bytes): lowercase = '[ IPHONE-USERNAME_MASKED ]'
  690. DEBUG Nov 19 13:39:29 [4144125760]: (new_livereq_data): _livereq_data=0x831c678
  691. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=4 req_handler=0x80a1949 res_handler=0x80c3bff handler_data=0x831c678
  692. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  693. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  694. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  695. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  696. INFO Nov 19 13:39:29 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  697. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=4
  698. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  699. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  700. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  701. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  702. DEBUG Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  703. INFO Nov 19 13:39:29 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  704. DEBUG Nov 19 13:39:29 [4140821312]: handle_server_events: EVENT_READ
  705. DEBUG Nov 19 13:39:29 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  706. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  707. DEBUG Nov 19 13:39:29 [4144125760]: (do_epoll): Waiting for events
  708. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  709. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  710. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=4 handler_data=0x831c678 res_handler=0x80c3bff
  711. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Binding 2 parameters 0xf6cfd888 for query 0x81340d0
  712. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_INFO
  713. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_INFO, [ IPHONE-IP_MASKED ]) succeeded
  714. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_INFO, 5) succeeded
  715. DEBUG Nov 19 13:39:29 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): Live username len 5
  716. ERROR Nov 19 13:39:29 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): Missing message!
  717. DEBUG Nov 19 13:39:29 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): Live password len 5
  718. DEBUG Nov 19 13:39:29 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): GET_LIVEUSER_INFO retrieved: liveuserid=2 userid=11 groupid=8 liveuser_name_by_ip='[ IPHONE-USERNAME_MASKED ]' attr.starttime=245555 attr.lastlivetime=245555 isactive=1 groupid=8 policyid=1 accesspolicyid=1 bwpolicyid=0 datatransferpolicyid=0 lastusedtime=1511127566 used_minutes=41 cycleused_minutes=41 renewdate='2017-11-18' upload=3137584 download=91273366 cycleupload=3137584 cycledownload=91273366 message='NULL' macaddress='' clienttype=19 password='[ IPHONE-USERNAME_MASKED ]' addr_family=2 authserver_id=0
  719. DEBUG Nov 19 13:39:29 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): returning 0
  720. DEBUG Nov 19 13:39:29 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  721.  
  722. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  723. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  724. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  725. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  726. INFO Nov 19 13:39:29 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  727. DEBUG Nov 19 13:39:29 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  728. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  729. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  730. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  731. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  732. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): returning 1
  733. INFO Nov 19 13:39:29 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  734. DEBUG Nov 19 13:39:29 [4144125760]: handle_client_events: EVENT_READ
  735. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  736. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  737. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read blocked
  738. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  739. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  740. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831c678 res_handler=0x80c3bff
  741. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  742. DEBUG Nov 19 13:39:29 [4144125760]: (CA_handle_get_liveuser): invoking handle_get_liveuser
  743. INFO Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  744. DEBUG Nov 19 13:39:29 [4144125760]: handle_get_liveuser: SQLITE_REQ_GETLIVEUSERINFO Successful
  745. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=7 req_handler=0x80a1949 res_handler=0x807a564 handler_data=0x831c678
  746. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  747. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  748. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  749. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  750. INFO Nov 19 13:39:29 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  751. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=7
  752. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  753. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  754. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  755. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  756. DEBUG Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  757. INFO Nov 19 13:39:29 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  758. DEBUG Nov 19 13:39:29 [4140821312]: handle_server_events: EVENT_READ
  759. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  760. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  761. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read blocked
  762. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  763. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  764. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=7 handler_data=0x831c678 res_handler=0x807a564
  765. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  766. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x813410c
  767. DEBUG Nov 19 13:39:29 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  768. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Query name GET_USERTYPE
  769. DEBUG Nov 19 13:39:29 [4144125760]: (do_epoll): Waiting for events
  770. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_USERTYPE, [ IPHONE-USERNAME_MASKED ]) succeeded
  771. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  772. DEBUG Nov 19 13:39:29 [4140821312]: (_sqlite_db_handle_getusertype): GET_USERTYPE retrieved: usertype=1
  773. DEBUG Nov 19 13:39:29 [4140821312]: (_sqlite_db_handle_getusertype): returning 0
  774. DEBUG Nov 19 13:39:29 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  775.  
  776. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  777. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  778. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  779. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  780. INFO Nov 19 13:39:29 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  781. DEBUG Nov 19 13:39:29 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  782. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  783. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  784. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  785. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  786. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): returning 1
  787. INFO Nov 19 13:39:29 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  788. DEBUG Nov 19 13:39:29 [4144125760]: handle_client_events: EVENT_READ
  789. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  790. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  791. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read blocked
  792. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  793. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  794. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831c678 res_handler=0x807a564
  795. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  796. DEBUG Nov 19 13:39:29 [4144125760]: authorize_live_request: SQLITE_REQ_GETUSERTYPE Successful
  797. INFO Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  798. DEBUG Nov 19 13:39:29 [4144125760]: authorize_live_request: UL & ASU_IP req_data->username:'[ IPHONE-USERNAME_MASKED ]', livuser->username:'[ IPHONE-USERNAME_MASKED ]'
  799. DEBUG Nov 19 13:39:29 [4144125760]: (update_lastlivetime): update_lastlivetime: now:245559, used_min:41, cycleused_min:41, lastlivetime:245555, diffmin:0.066667
  800. DEBUG Nov 19 13:39:29 [4144125760]: (update_lastlivetime): diffmin : 0.566667
  801. DEBUG Nov 19 13:39:29 [4144125760]: (update_lastlivetime): livereq used_minutes : 41
  802. DEBUG Nov 19 13:39:29 [4144125760]: (get_liveuser_allowed_status): config session_timeout=4294967295 livereq starttime=245555
  803. DEBUG Nov 19 13:39:29 [4144125760]: is_currently_allowed: accesspolicy:1
  804. DEBUG Nov 19 13:39:29 [4144125760]: is_currently_allowed: currday:1, hour:13, min:39, currtime:819
  805. INFO Nov 19 13:39:29 [4144125760]: is_currently_allowed: POLICY MATCH. Strategy:'Y'
  806. DEBUG Nov 19 13:39:29 [4144125760]: (get_liveuser_allowed_status): policies->policyid=1, user_acc={used_minutes=41}
  807. DEBUG Nov 19 13:39:29 [4144125760]: has_surfing_time: effective_alloted_min:-11, effective_used_min:41
  808. DEBUG Nov 19 13:39:29 [4144125760]: has_surfing_time: YES
  809. INFO Nov 19 13:39:29 [4144125760]: match_surfing_quota: SQuota policy id:1, cycle:80
  810. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=11 req_handler=0x80a1949 res_handler=0x8070cf4 handler_data=0x831c678
  811. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  812. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  813. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  814. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  815. INFO Nov 19 13:39:29 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  816. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=11
  817. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  818. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  819. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  820. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  821. DEBUG Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  822. INFO Nov 19 13:39:29 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  823. DEBUG Nov 19 13:39:29 [4140821312]: handle_server_events: EVENT_READ
  824. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  825. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  826. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read blocked
  827. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  828. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  829. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=11 handler_data=0x831c678 res_handler=0x8070cf4
  830. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  831. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Binding 8 parameters 0xf6cfd888 for query 0x8134134
  832. DEBUG Nov 19 13:39:29 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  833. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Query name UPDATE_LIVEUSER_ACC
  834. DEBUG Nov 19 13:39:29 [4144125760]: (do_epoll): Waiting for events
  835. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 1511127569) succeeded
  836. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  837. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 41) succeeded
  838. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 41) succeeded
  839. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 3137584) succeeded
  840. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 91273366) succeeded
  841. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 3137584) succeeded
  842. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 91273366) succeeded
  843. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 11) succeeded
  844. DEBUG Nov 19 13:39:29 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  845.  
  846. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  847. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  848. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  849. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  850. INFO Nov 19 13:39:29 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  851. DEBUG Nov 19 13:39:29 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  852. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  853. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  854. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  855. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  856. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): returning 1
  857. INFO Nov 19 13:39:29 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  858. DEBUG Nov 19 13:39:29 [4144125760]: handle_client_events: EVENT_READ
  859. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  860. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  861. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read blocked
  862. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  863. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  864. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831c678 res_handler=0x8070cf4
  865. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  866. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=10 req_handler=0x80a1949 res_handler=0x8070c3f handler_data=0x831c678
  867. INFO Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  868. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  869. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  870. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  871. DEBUG Nov 19 13:39:29 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  872. INFO Nov 19 13:39:29 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  873. DEBUG Nov 19 13:39:29 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=10
  874. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  875. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  876. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  877. DEBUG Nov 19 13:39:29 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  878. DEBUG Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  879. INFO Nov 19 13:39:29 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  880. DEBUG Nov 19 13:39:29 [4140821312]: handle_server_events: EVENT_READ
  881. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  882. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  883. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read blocked
  884. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  885. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  886. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=10 handler_data=0x831c678 res_handler=0x8070c3f
  887. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  888. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Binding 2 parameters 0xf6cfd888 for query 0x81341e8
  889. DEBUG Nov 19 13:39:29 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  890. DEBUG Nov 19 13:39:29 [4140821312]: (bind_parameters_to_statement): Query name UPDATE_LIVEUSER
  891. DEBUG Nov 19 13:39:29 [4144125760]: (do_epoll): Waiting for events
  892. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER, 245559) succeeded
  893. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  894. DEBUG Nov 19 13:39:29 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(UPDATE_LIVEUSER, [ IPHONE-IP_MASKED ]) succeeded
  895. DEBUG Nov 19 13:39:29 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  896.  
  897. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  898. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  899. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  900. DEBUG Nov 19 13:39:29 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  901. INFO Nov 19 13:39:29 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  902. DEBUG Nov 19 13:39:29 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  903. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  904. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  905. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  906. DEBUG Nov 19 13:39:29 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  907. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): returning 1
  908. INFO Nov 19 13:39:29 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  909. DEBUG Nov 19 13:39:29 [4144125760]: handle_client_events: EVENT_READ
  910. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: READING... fd=11
  911. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  912. INFO Nov 19 13:39:29 [4140821312]: (do_handle_read): server: read blocked
  913. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  914. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  915. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831c678 res_handler=0x8070c3f
  916. DEBUG Nov 19 13:39:29 [4140821312]: (do_handle_write): released lock 0x828fe24
  917. DEBUG Nov 19 13:39:29 [4144125760]: handle_liveuser_update: LIVE REQUEST Successful
  918. INFO Nov 19 13:39:29 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  919. DEBUG Nov 19 13:39:29 [4144125760]: (send_response): Error sending data: Invalid argument
  920. DEBUG Nov 19 13:39:29 [4144125760]: (free_livereq_data): _livereq_data=0x831c678
  921. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: READING... fd=10
  922. INFO Nov 19 13:39:29 [4144125760]: (do_handle_read): client: read blocked
  923. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  924. DEBUG Nov 19 13:39:29 [4144125760]: (do_handle_write): released lock 0x828fe00
  925. DEBUG Nov 19 13:39:29 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  926. DEBUG Nov 19 13:39:29 [4144125760]: (do_epoll): Waiting for events
  927. DEBUG Nov 19 13:39:29 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  928. DEBUG Nov 19 13:40:00 [4144125760]: (CA_epoll_wait): returning 1
  929. DEBUG Nov 19 13:40:00 [4144125760]: tlvserver_handle_request: tlv request received
  930. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: ---------------------------------
  931. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV ID: 140
  932. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV Type: 0
  933. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV Length: 0
  934. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  935. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: ---------------------------------
  936. DEBUG Nov 19 13:40:00 [4144125760]: tlvserver_process_request: GOT ALERT.EXECUTE_HEARTBEAT
  937. DEBUG Nov 19 13:40:00 [4144125760]: (CA_keep_alive): called too soon, seconds = 31, returning
  938. DEBUG Nov 19 13:40:00 [4144125760]: (do_epoll): Waiting for events
  939. DEBUG Nov 19 13:40:00 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=14000
  940. DEBUG Nov 19 13:40:00 [4144125760]: (CA_epoll_wait): returning 1
  941. DEBUG Nov 19 13:40:00 [4144125760]: tlvserver_handle_request: tlv request received
  942. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: ---------------------------------
  943. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV ID: 148
  944. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV Type: 0
  945. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV Length: 0
  946. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  947. INFO Nov 19 13:40:00 [4144125760]: tlvserver_print_request: ---------------------------------
  948. DEBUG Nov 19 13:40:00 [4144125760]: tlvserver_process_request: GOT ALERT.EDIR_SYNC
  949. DEBUG Nov 19 13:40:00 [4144125760]: (subsys_submit_request): subsys_name=EDIR_SYNC req_type=0 req_handler=0x80b5b92 res_handler=(nil) handler_data=(nil)
  950. DEBUG Nov 19 13:40:00 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  951. DEBUG Nov 19 13:40:00 [4144125760]: (append_subsysqueue): acquiring lock 0x83055b8
  952. DEBUG Nov 19 13:40:00 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  953. DEBUG Nov 19 13:40:00 [4144125760]: (append_subsysqueue): released lock 0x83055b8
  954. INFO Nov 19 13:40:00 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  955. DEBUG Nov 19 13:40:00 [4144125760]: (subsys_submit_request): EDIR_SYNC: request submitted, req_type=0
  956. DEBUG Nov 19 13:40:00 [4144125760]: (do_handle_write): acquiring lock 0x83055b8
  957. DEBUG Nov 19 13:40:00 [4144125760]: (do_handle_write): released lock 0x83055b8
  958. DEBUG Nov 19 13:40:00 [4144125760]: (write_subsysqueue): acquiring lock 0x83055b8
  959. DEBUG Nov 19 13:40:00 [4144125760]: (write_subsysqueue): released lock 0x83055b8
  960. INFO Nov 19 13:40:00 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=23 wq=0x8307a80 buf=0x8307a88 offset=0
  961. DEBUG Nov 19 13:40:00 [4144125760]: (CA_keep_alive): called too soon, seconds = 31, returning
  962. DEBUG Nov 19 13:40:00 [4144125760]: (do_epoll): Waiting for events
  963. DEBUG Nov 19 13:40:00 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=14000
  964. DEBUG Nov 19 13:40:00 [4132424512]: subsys_thread_main: EDIR_SYNC: event received on fd: 24
  965. DEBUG Nov 19 13:40:00 [4132424512]: handle_server_events: EVENT_READ
  966. INFO Nov 19 13:40:00 [4132424512]: (do_handle_read): server: READING... fd=24
  967. INFO Nov 19 13:40:00 [4132424512]: (do_handle_read): server: read 16 bytes, fd=24
  968. DEBUG Nov 19 13:40:00 [4132424512]: (do_handle_read): server tlv=0x8305628 req_handler=0x80b5b92 type=0 handler_data=(nil) res_handler=(nil)
  969. INFO Nov 19 13:40:00 [4132424512]: (do_handle_read): server: READING... fd=24
  970. INFO Nov 19 13:40:00 [4132424512]: (do_handle_read): server: read blocked
  971. DEBUG Nov 19 13:40:00 [4132424512]: (do_handle_write): acquiring lock 0x83055dc
  972. DEBUG Nov 19 13:40:00 [4132424512]: (do_handle_write): released lock 0x83055dc
  973. INFO Nov 19 13:40:00 [4132424512]: subsys_thread_main: EDIR_SYNC: waiting for events...
  974. DEBUG Nov 19 13:40:14 [4144125760]: (CA_epoll_wait): returning 0
  975. DEBUG Nov 19 13:40:14 [4144125760]: (CA_keep_alive): Checking connections status
  976. MESSAGE Nov 19 13:40:14 [4144125760]: (CA_keep_alive): Sending PING to [ IPHONE-USERNAME_MASKED ]
  977. DEBUG Nov 19 13:40:14 [4144125760]: (do_epoll): Waiting for events
  978. DEBUG Nov 19 13:40:14 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  979. DEBUG Nov 19 13:40:52 [4144125760]: (CA_epoll_wait): returning 1
  980. ERROR Nov 19 13:40:52 [4144125760]: (process_command): Failed to read from SSL socket: len 0 5
  981. MESSAGE Nov 19 13:40:52 [4144125760]: (CA_disconnect_user): Will disconnect user [ IPHONE-USERNAME_MASKED ]
  982. DEBUG Nov 19 13:40:52 [4144125760]: (new_livereq_data): _livereq_data=0x831c678
  983. DEBUG Nov 19 13:40:52 [4144125760]: (bind_parameters_to_statement): Binding 2 parameters 0xfff42948 for query 0x81340f8
  984. DEBUG Nov 19 13:40:52 [4144125760]: (bind_parameters_to_statement): Query name GET_LIVEUSER_INFO_TO_LOGOUT
  985. DEBUG Nov 19 13:40:52 [4144125760]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_INFO_TO_LOGOUT, [ IPHONE-IP_MASKED ]) succeeded
  986. DEBUG Nov 19 13:40:52 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_INFO_TO_LOGOUT, 5) succeeded
  987. DEBUG Nov 19 13:40:52 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Live username len 5
  988. DEBUG Nov 19 13:40:52 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Live name len 5
  989. ERROR Nov 19 13:40:52 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Missing message!
  990. DEBUG Nov 19 13:40:52 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): GET_LIVEUSER_INFO_TO_LOGOUT retrieved: liveuserid=2 userid=11 groupid=8 liveuser_name_by_ip='[ IPHONE-USERNAME_MASKED ]' name='[ IPHONE-USERNAME_MASKED ]' attr.starttime=245555 attr.lastlivetime=245559 isactive=1 groupid=8 policyid=1 accesspolicyid=1 bwpolicyid=0 datatransferpolicyid=0 lastusedtime=1511127569 used_minutes=41 cycleused_minutes=41 renewdate='2017-11-18' upload=3137584 download=91273366 cycleupload=3137584 cycledownload=91273366 message='NULL' macaddress='' clienttype=19 addr_family=2 authserver_id=0
  991. DEBUG Nov 19 13:40:52 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): returning 0
  992. DEBUG Nov 19 13:40:52 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  993.  
  994. DEBUG Nov 19 13:40:52 [4144125760]: (send_response): Error sending data: Invalid argument
  995. DEBUG Nov 19 13:40:52 [4144125760]: (handle_external_logout_req_finish_free): SQLITE_REQ_GETLIVEUSERINFO successful
  996. DEBUG Nov 19 13:40:52 [4144125760]: (update_lastlivetime): update_lastlivetime: now:245642, used_min:41, cycleused_min:41, lastlivetime:245559, diffmin:1.383333
  997. DEBUG Nov 19 13:40:52 [4144125760]: (update_lastlivetime): diffmin : 1.883333
  998. DEBUG Nov 19 13:40:52 [4144125760]: (update_lastlivetime): livereq used_minutes : 42
  999. DEBUG Nov 19 13:40:52 [4144125760]: update_lastlivetime: Executing command '/sbin/ipsetelite -L users liveuserid=2 -c'
  1000. DEBUG Nov 19 13:40:52 [4144125760]: update_lastlivetime: Command Output: '2,235811,3566096
  1001. '
  1002. DEBUG Nov 19 13:40:52 [4144125760]: update_lastlivetime: new_upload:235811, new_download:3566096, pre_upload:3137584, pre_download:91273366, pre_cycleupload:3137584, pre_cycledownload:3137584
  1003. DEBUG Nov 19 13:40:52 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff42718 for query 0x8134030
  1004. DEBUG Nov 19 13:40:52 [4144125760]: (bind_parameters_to_statement): Query name GET_LIVEUSER_SESSION_DATA
  1005. DEBUG Nov 19 13:40:52 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_SESSION_DATA, 2) succeeded
  1006. DEBUG Nov 19 13:40:52 [4144125760]: (_sqlite_db_handle_live_session_data): GET_LIVEUSER_SESSION_DATA retrieved: upload=0 download=0
  1007. DEBUG Nov 19 13:40:52 [4144125760]: (_sqlite_db_handle_live_session_data): returning 0
  1008. DEBUG Nov 19 13:40:52 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  1009.  
  1010. DEBUG Nov 19 13:40:52 [4144125760]: new_cycleupload:3373395, new_cycledownload:94839462
  1011. DEBUG Nov 19 13:40:52 [4144125760]: fill_logout_garner_data: UPLOAD:235811,DOWNLOAD:3566096,starttime:1511127564, Groupid:8, MAC:'', NAME:'[ IPHONE-USERNAME_MASKED ]'
  1012. DEBUG Nov 19 13:40:52 [4144125760]: execute_update_tbluseraccounting: OPCODE: JSON:'{ "userids":["[ IPHONE-USERNAME_MASKED ]"],"uploaddata":["3373395"],"downloaddata":["94839462"],"cycleupload":["3373395"],"cycledownload":["94839462"],"usedminutes":[42],"cycleusedminutes":[42],"lastusedtime":["2017-11-19 13:39:29"] }'
  1013. INFO Nov 19 13:40:52 [4144125760]: execute_update_tbluseraccounting: OPCODE: OPCODE executed successfully
  1014. DEBUG Nov 19 13:40:53 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff42908 for query 0x813415c
  1015. DEBUG Nov 19 13:40:53 [4144125760]: (bind_parameters_to_statement): Query name REMOVE_LIVEUSER
  1016. DEBUG Nov 19 13:40:53 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(REMOVE_LIVEUSER, 2) succeeded
  1017. DEBUG Nov 19 13:40:53 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  1018.  
  1019. ERROR Nov 19 13:40:53 [4144125760]: config_resolve_bwid: BW Policy 0 not found
  1020. DEBUG Nov 19 13:40:53 [4144125760]: (opcode_handle_logout): clienttype 19, JASON: { "userid":"[ IPHONE-USERNAME_MASKED ]","liveuserid":"2","bwpolicyid":"","ipaddress":"[ IPHONE-IP_MASKED ]","setname":"lusers", }
  1021. INFO Nov 19 13:40:53 [4144125760]: opcode_handle_logout: OPCODE: OPCODE executed successfully
  1022. DEBUG Nov 19 13:40:53 [4144125760]: uid_release: BYTE-ID: 0
  1023. DEBUG Nov 19 13:40:53 [4144125760]: uid_release: BIT-ID: 2
  1024. DEBUG Nov 19 13:40:53 [4144125760]: uid_release: Before CLEAR_BIT[2] BYTE[0]: 0x7
  1025. DEBUG Nov 19 13:40:53 [4144125760]: uid_release: Before CLEAR_BIT[2] BYTE[0]: 0x3
  1026. INFO Nov 19 13:40:53 [4144125760]: uid_release: UID 2 released
  1027. DEBUG Nov 19 13:40:53 [4144125760]: (free_livereq_data): _livereq_data=0x831c678
  1028. DEBUG Nov 19 13:40:53 [4144125760]: (CA_remove_conn): Will remove connection 0x830d958 with fd 26 for user [ IPHONE-USERNAME_MASKED ]
  1029. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): ===============================================================
  1030. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): fd: 26, authenticated: 1, secured: 1, alive: 1
  1031. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): username: [ IPHONE-USERNAME_MASKED ]
  1032. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): ip_address_string: [ IPHONE-IP_MASKED ]
  1033. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): type: 4
  1034. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): APNDeviceID: (null)
  1035. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): login_time: 1511127566
  1036. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): ssl: 0x830dfb8
  1037. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): cmd_buffer: (null), cmd_buffer_size: 0
  1038. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): ip_list: 0x831e940, num_ip: 1
  1039. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): ip6_list: (nil), num_ip6: 0
  1040. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): mac_list: (nil), num_mac: 0
  1041. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): next: (nil)
  1042. DEBUG Nov 19 13:40:53 [4144125760]: (CA_dump_conn): ===============================================================
  1043. INFO Nov 19 13:40:53 [4144125760]: (CA_remove_conn_for_user): User [ IPHONE-USERNAME_MASKED ] has no connections left, removing the user
  1044. DEBUG Nov 19 13:40:53 [4144125760]: (CA_remove_conn_for_user): Releasing user 0x831f008 username 0x8320490
  1045. DEBUG Nov 19 13:40:53 [4144125760]: (deregister_conn_epoll): releasing ep_data 0x8320708
  1046. DEBUG Nov 19 13:40:53 [4144125760]: (CA_close_connection): conn 0x830d958 generation 14, freeing ssl 0x830dfb8
  1047. DEBUG Nov 19 13:40:53 [4144125760]: (CA_remove_conn): Releasing conn 0x830d958 generation 14
  1048. DEBUG Nov 19 13:40:53 [4144125760]: (CA_keep_alive): called too soon, seconds = 39, returning
  1049. DEBUG Nov 19 13:40:53 [4144125760]: (do_epoll): Waiting for events
  1050. DEBUG Nov 19 13:40:53 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=7000
  1051. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): returning 1
  1052. DEBUG Nov 19 13:40:59 [4144125760]: handle_client: IP:4261849280, PORT:57282
  1053. INFO Nov 19 13:40:59 [4144125760]: process_request: Request Code:93
  1054. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: -----------------AUTH_TLV--------
  1055. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: TLV Type: 1
  1056. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: TLV Length: 2
  1057. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: ---------------------------------
  1058. DEBUG Nov 19 13:40:59 [4144125760]: http_client_request_data: Cookie FD:'131283'
  1059. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: -----------------AUTH_TLV--------
  1060. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: TLV Type: 2
  1061. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: TLV Length: 13
  1062. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: ---------------------------------
  1063. DEBUG Nov 19 13:40:59 [4144125760]: http_client_request_data: IP:'[ MAC-IP_MASKED ]'
  1064. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: -----------------AUTH_TLV--------
  1065. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: TLV Type: 3
  1066. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: TLV Length: 10
  1067. INFO Nov 19 13:40:59 [4144125760]: print_auth_tlv: ---------------------------------
  1068. DEBUG Nov 19 13:40:59 [4144125760]: (lc_utf8_bytes): lowercase = '[ MAC-USERNAME_MASKED ]'
  1069. DEBUG Nov 19 13:40:59 [4144125760]: (http_client_request_data): Username:'[ MAC-USERNAME_MASKED ]'
  1070. DEBUG Nov 19 13:40:59 [4144125760]: (new_livereq_data): _livereq_data=0x831f188
  1071. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=4 req_handler=0x80a1949 res_handler=0x807afb5 handler_data=0x831f188
  1072. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1073. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  1074. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1075. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  1076. INFO Nov 19 13:40:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1077. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=4
  1078. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1079. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1080. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  1081. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  1082. INFO Nov 19 13:40:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  1083. DEBUG Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  1084. DEBUG Nov 19 13:40:59 [4144125760]: (CA_keep_alive): Checking connections status
  1085. DEBUG Nov 19 13:40:59 [4140821312]: handle_server_events: EVENT_READ
  1086. DEBUG Nov 19 13:40:59 [4144125760]: (do_epoll): Waiting for events
  1087. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1088. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=1000
  1089. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  1090. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=4 handler_data=0x831f188 res_handler=0x807afb5
  1091. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Binding 2 parameters 0xf6cfd888 for query 0x81340d0
  1092. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_INFO
  1093. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_INFO, [ MAC-IP_MASKED ]) succeeded
  1094. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_INFO, 5) succeeded
  1095. DEBUG Nov 19 13:40:59 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): Live username len 9
  1096. ERROR Nov 19 13:40:59 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): Missing message!
  1097. DEBUG Nov 19 13:40:59 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): Live password len 9
  1098. DEBUG Nov 19 13:40:59 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): GET_LIVEUSER_INFO retrieved: liveuserid=1 userid=10 groupid=9 liveuser_name_by_ip='[ MAC-USERNAME_MASKED ]' attr.starttime=240762 attr.lastlivetime=245468 isactive=1 groupid=9 policyid=1 accesspolicyid=1 bwpolicyid=0 datatransferpolicyid=0 lastusedtime=1511127478 used_minutes=1087 cycleused_minutes=1087 renewdate='2017-11-18' upload=61573448 download=1654680838 cycleupload=61573448 cycledownload=1654680838 message='NULL' macaddress='' clienttype=2 password='[ MAC-USERNAME_MASKED ]' addr_family=2 authserver_id=0
  1099. DEBUG Nov 19 13:40:59 [4140821312]: (_sqlite_db_handle_get_liveuserinfo): returning 0
  1100. DEBUG Nov 19 13:40:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1101.  
  1102. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  1103. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  1104. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  1105. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  1106. INFO Nov 19 13:40:59 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  1107. DEBUG Nov 19 13:40:59 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  1108. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1109. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1110. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  1111. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  1112. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): returning 1
  1113. INFO Nov 19 13:40:59 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  1114. DEBUG Nov 19 13:40:59 [4144125760]: handle_client_events: EVENT_READ
  1115. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1116. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1117. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read blocked
  1118. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  1119. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1120. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831f188 res_handler=0x807afb5
  1121. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1122. DEBUG Nov 19 13:40:59 [4144125760]: handle_get_liveuser: SQLITE_REQ_GETLIVEUSERINFO Successful
  1123. INFO Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  1124. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=7 req_handler=0x80a1949 res_handler=0x807a564 handler_data=0x831f188
  1125. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1126. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  1127. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1128. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  1129. INFO Nov 19 13:40:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1130. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=7
  1131. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1132. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1133. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  1134. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  1135. DEBUG Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  1136. INFO Nov 19 13:40:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  1137. DEBUG Nov 19 13:40:59 [4140821312]: handle_server_events: EVENT_READ
  1138. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1139. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1140. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read blocked
  1141. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  1142. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1143. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=7 handler_data=0x831f188 res_handler=0x807a564
  1144. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1145. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x813410c
  1146. DEBUG Nov 19 13:40:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  1147. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Query name GET_USERTYPE
  1148. DEBUG Nov 19 13:40:59 [4144125760]: (do_epoll): Waiting for events
  1149. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_USERTYPE, [ MAC-USERNAME_MASKED ]) succeeded
  1150. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=1000
  1151. DEBUG Nov 19 13:40:59 [4140821312]: (_sqlite_db_handle_getusertype): GET_USERTYPE retrieved: usertype=1
  1152. DEBUG Nov 19 13:40:59 [4140821312]: (_sqlite_db_handle_getusertype): returning 0
  1153. DEBUG Nov 19 13:40:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1154.  
  1155. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  1156. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  1157. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  1158. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  1159. INFO Nov 19 13:40:59 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  1160. DEBUG Nov 19 13:40:59 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  1161. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1162. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1163. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  1164. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  1165. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): returning 1
  1166. INFO Nov 19 13:40:59 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  1167. DEBUG Nov 19 13:40:59 [4144125760]: handle_client_events: EVENT_READ
  1168. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1169. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1170. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read blocked
  1171. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  1172. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1173. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831f188 res_handler=0x807a564
  1174. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1175. DEBUG Nov 19 13:40:59 [4144125760]: authorize_live_request: SQLITE_REQ_GETUSERTYPE Successful
  1176. INFO Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  1177. DEBUG Nov 19 13:40:59 [4144125760]: authorize_live_request: UL & ASU_IP req_data->username:'[ MAC-USERNAME_MASKED ]', livuser->username:'[ MAC-USERNAME_MASKED ]'
  1178. DEBUG Nov 19 13:40:59 [4144125760]: (update_lastlivetime): update_lastlivetime: now:245649, used_min:1087, cycleused_min:1087, lastlivetime:245468, diffmin:3.016667
  1179. DEBUG Nov 19 13:40:59 [4144125760]: (update_lastlivetime): diffmin : 3.516667
  1180. DEBUG Nov 19 13:40:59 [4144125760]: (update_lastlivetime): livereq used_minutes : 1090
  1181. DEBUG Nov 19 13:40:59 [4144125760]: (get_liveuser_allowed_status): config session_timeout=4294967295 livereq starttime=240762
  1182. DEBUG Nov 19 13:40:59 [4144125760]: is_currently_allowed: accesspolicy:1
  1183. DEBUG Nov 19 13:40:59 [4144125760]: is_currently_allowed: currday:1, hour:13, min:40, currtime:820
  1184. INFO Nov 19 13:40:59 [4144125760]: is_currently_allowed: POLICY MATCH. Strategy:'Y'
  1185. DEBUG Nov 19 13:40:59 [4144125760]: (get_liveuser_allowed_status): policies->policyid=1, user_acc={used_minutes=1090}
  1186. DEBUG Nov 19 13:40:59 [4144125760]: has_surfing_time: effective_alloted_min:-11, effective_used_min:1090
  1187. DEBUG Nov 19 13:40:59 [4144125760]: has_surfing_time: YES
  1188. INFO Nov 19 13:40:59 [4144125760]: match_surfing_quota: SQuota policy id:1, cycle:80
  1189. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=11 req_handler=0x80a1949 res_handler=0x8070cf4 handler_data=0x831f188
  1190. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1191. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  1192. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1193. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  1194. INFO Nov 19 13:40:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1195. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=11
  1196. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1197. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1198. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  1199. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  1200. DEBUG Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  1201. INFO Nov 19 13:40:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  1202. DEBUG Nov 19 13:40:59 [4140821312]: handle_server_events: EVENT_READ
  1203. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1204. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1205. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read blocked
  1206. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  1207. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1208. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=11 handler_data=0x831f188 res_handler=0x8070cf4
  1209. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1210. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Binding 8 parameters 0xf6cfd888 for query 0x8134134
  1211. DEBUG Nov 19 13:40:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  1212. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Query name UPDATE_LIVEUSER_ACC
  1213. DEBUG Nov 19 13:40:59 [4144125760]: (do_epoll): Waiting for events
  1214. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 1511127659) succeeded
  1215. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=1000
  1216. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 1090) succeeded
  1217. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 1090) succeeded
  1218. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 61573448) succeeded
  1219. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 1654680838) succeeded
  1220. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 61573448) succeeded
  1221. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 1654680838) succeeded
  1222. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_ACC, 10) succeeded
  1223. DEBUG Nov 19 13:40:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1224.  
  1225. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  1226. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  1227. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  1228. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  1229. INFO Nov 19 13:40:59 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  1230. DEBUG Nov 19 13:40:59 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  1231. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1232. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1233. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  1234. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  1235. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): returning 1
  1236. INFO Nov 19 13:40:59 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  1237. DEBUG Nov 19 13:40:59 [4144125760]: handle_client_events: EVENT_READ
  1238. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1239. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1240. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read blocked
  1241. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  1242. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1243. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831f188 res_handler=0x8070cf4
  1244. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1245. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=10 req_handler=0x80a1949 res_handler=0x8070c3f handler_data=0x831f188
  1246. INFO Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  1247. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1248. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  1249. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1250. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  1251. INFO Nov 19 13:40:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1252. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=10
  1253. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1254. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1255. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  1256. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  1257. DEBUG Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  1258. INFO Nov 19 13:40:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  1259. DEBUG Nov 19 13:40:59 [4140821312]: handle_server_events: EVENT_READ
  1260. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1261. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1262. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read blocked
  1263. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  1264. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1265. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=10 handler_data=0x831f188 res_handler=0x8070c3f
  1266. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1267. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Binding 2 parameters 0xf6cfd888 for query 0x81341e8
  1268. DEBUG Nov 19 13:40:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  1269. DEBUG Nov 19 13:40:59 [4140821312]: (bind_parameters_to_statement): Query name UPDATE_LIVEUSER
  1270. DEBUG Nov 19 13:40:59 [4144125760]: (do_epoll): Waiting for events
  1271. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER, 245649) succeeded
  1272. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=1000
  1273. DEBUG Nov 19 13:40:59 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(UPDATE_LIVEUSER, [ MAC-IP_MASKED ]) succeeded
  1274. DEBUG Nov 19 13:40:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1275.  
  1276. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  1277. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  1278. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  1279. DEBUG Nov 19 13:40:59 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  1280. INFO Nov 19 13:40:59 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  1281. DEBUG Nov 19 13:40:59 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  1282. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1283. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1284. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  1285. DEBUG Nov 19 13:40:59 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  1286. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): returning 1
  1287. INFO Nov 19 13:40:59 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  1288. DEBUG Nov 19 13:40:59 [4144125760]: handle_client_events: EVENT_READ
  1289. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1290. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1291. INFO Nov 19 13:40:59 [4140821312]: (do_handle_read): server: read blocked
  1292. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  1293. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1294. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831f188 res_handler=0x8070c3f
  1295. DEBUG Nov 19 13:40:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1296. DEBUG Nov 19 13:40:59 [4144125760]: handle_liveuser_update: LIVE REQUEST Successful
  1297. INFO Nov 19 13:40:59 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  1298. DEBUG Nov 19 13:40:59 [4144125760]: send_http_client_response: Cookie FD:'131283'
  1299. DEBUG Nov 19 13:40:59 [4144125760]: send_http_client_response: LEN:'13'
  1300. DEBUG Nov 19 13:40:59 [4144125760]: send_response_authtlv: Packetlen:17
  1301. DEBUG Nov 19 13:40:59 [4144125760]: send_response_authtlv: Bytes sent:17, Buf len:17
  1302. DEBUG Nov 19 13:40:59 [4144125760]: (free_livereq_data): _livereq_data=0x831f188
  1303. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1304. INFO Nov 19 13:40:59 [4144125760]: (do_handle_read): client: read blocked
  1305. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1306. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1307. DEBUG Nov 19 13:40:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  1308. DEBUG Nov 19 13:40:59 [4144125760]: (do_epoll): Waiting for events
  1309. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=1000
  1310. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): returning 1
  1311. DEBUG Nov 19 13:40:59 [4144125760]: tlvserver_handle_request: tlv request received
  1312. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1313. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV ID: 140
  1314. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV Type: 0
  1315. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV Length: 0
  1316. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  1317. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1318. DEBUG Nov 19 13:40:59 [4144125760]: tlvserver_process_request: GOT ALERT.EXECUTE_HEARTBEAT
  1319. DEBUG Nov 19 13:40:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  1320. DEBUG Nov 19 13:40:59 [4144125760]: (do_epoll): Waiting for events
  1321. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=1000
  1322. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): returning 1
  1323. DEBUG Nov 19 13:40:59 [4144125760]: tlvserver_handle_request: tlv request received
  1324. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1325. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV ID: 148
  1326. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV Type: 0
  1327. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV Length: 0
  1328. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  1329. INFO Nov 19 13:40:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1330. DEBUG Nov 19 13:40:59 [4144125760]: tlvserver_process_request: GOT ALERT.EDIR_SYNC
  1331. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): subsys_name=EDIR_SYNC req_type=0 req_handler=0x80b5b92 res_handler=(nil) handler_data=(nil)
  1332. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1333. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): acquiring lock 0x83055b8
  1334. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1335. DEBUG Nov 19 13:40:59 [4144125760]: (append_subsysqueue): released lock 0x83055b8
  1336. INFO Nov 19 13:40:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1337. DEBUG Nov 19 13:40:59 [4144125760]: (subsys_submit_request): EDIR_SYNC: request submitted, req_type=0
  1338. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): acquiring lock 0x83055b8
  1339. DEBUG Nov 19 13:40:59 [4144125760]: (do_handle_write): released lock 0x83055b8
  1340. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): acquiring lock 0x83055b8
  1341. DEBUG Nov 19 13:40:59 [4144125760]: (write_subsysqueue): released lock 0x83055b8
  1342. INFO Nov 19 13:40:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=23 wq=0x8307a80 buf=0x8307a88 offset=0
  1343. DEBUG Nov 19 13:40:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 0, returning
  1344. DEBUG Nov 19 13:40:59 [4144125760]: (do_epoll): Waiting for events
  1345. DEBUG Nov 19 13:40:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=1000
  1346. DEBUG Nov 19 13:40:59 [4132424512]: subsys_thread_main: EDIR_SYNC: event received on fd: 24
  1347. DEBUG Nov 19 13:40:59 [4132424512]: handle_server_events: EVENT_READ
  1348. INFO Nov 19 13:40:59 [4132424512]: (do_handle_read): server: READING... fd=24
  1349. INFO Nov 19 13:40:59 [4132424512]: (do_handle_read): server: read 16 bytes, fd=24
  1350. DEBUG Nov 19 13:40:59 [4132424512]: (do_handle_read): server tlv=0x8305628 req_handler=0x80b5b92 type=0 handler_data=(nil) res_handler=(nil)
  1351. INFO Nov 19 13:40:59 [4132424512]: (do_handle_read): server: READING... fd=24
  1352. INFO Nov 19 13:40:59 [4132424512]: (do_handle_read): server: read blocked
  1353. DEBUG Nov 19 13:40:59 [4132424512]: (do_handle_write): acquiring lock 0x83055dc
  1354. DEBUG Nov 19 13:40:59 [4132424512]: (do_handle_write): released lock 0x83055dc
  1355. INFO Nov 19 13:40:59 [4132424512]: subsys_thread_main: EDIR_SYNC: waiting for events...
  1356. DEBUG Nov 19 13:41:00 [4144125760]: (CA_epoll_wait): returning 0
  1357. DEBUG Nov 19 13:41:00 [4144125760]: (CA_keep_alive): called too soon, seconds = 1, returning
  1358. DEBUG Nov 19 13:41:00 [4144125760]: (do_epoll): Waiting for events
  1359. DEBUG Nov 19 13:41:00 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  1360. DEBUG Nov 19 13:41:45 [4144125760]: (CA_epoll_wait): returning 0
  1361. DEBUG Nov 19 13:41:45 [4144125760]: (CA_keep_alive): Checking connections status
  1362. DEBUG Nov 19 13:41:45 [4144125760]: (do_epoll): Waiting for events
  1363. DEBUG Nov 19 13:41:45 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  1364. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): returning 1
  1365. DEBUG Nov 19 13:41:59 [4144125760]: tlvserver_handle_request: tlv request received
  1366. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1367. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV ID: 148
  1368. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Type: 0
  1369. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Length: 0
  1370. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  1371. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1372. DEBUG Nov 19 13:41:59 [4144125760]: tlvserver_process_request: GOT ALERT.EDIR_SYNC
  1373. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): subsys_name=EDIR_SYNC req_type=0 req_handler=0x80b5b92 res_handler=(nil) handler_data=(nil)
  1374. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1375. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): acquiring lock 0x83055b8
  1376. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1377. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): released lock 0x83055b8
  1378. INFO Nov 19 13:41:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1379. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): EDIR_SYNC: request submitted, req_type=0
  1380. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): acquiring lock 0x83055b8
  1381. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): released lock 0x83055b8
  1382. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): acquiring lock 0x83055b8
  1383. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): released lock 0x83055b8
  1384. INFO Nov 19 13:41:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=23 wq=0x8307a80 buf=0x8307a88 offset=0
  1385. DEBUG Nov 19 13:41:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 14, returning
  1386. DEBUG Nov 19 13:41:59 [4144125760]: (do_epoll): Waiting for events
  1387. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=31000
  1388. DEBUG Nov 19 13:41:59 [4132424512]: subsys_thread_main: EDIR_SYNC: event received on fd: 24
  1389. DEBUG Nov 19 13:41:59 [4132424512]: handle_server_events: EVENT_READ
  1390. INFO Nov 19 13:41:59 [4132424512]: (do_handle_read): server: READING... fd=24
  1391. INFO Nov 19 13:41:59 [4132424512]: (do_handle_read): server: read 16 bytes, fd=24
  1392. DEBUG Nov 19 13:41:59 [4132424512]: (do_handle_read): server tlv=0x8305628 req_handler=0x80b5b92 type=0 handler_data=(nil) res_handler=(nil)
  1393. INFO Nov 19 13:41:59 [4132424512]: (do_handle_read): server: READING... fd=24
  1394. INFO Nov 19 13:41:59 [4132424512]: (do_handle_read): server: read blocked
  1395. DEBUG Nov 19 13:41:59 [4132424512]: (do_handle_write): acquiring lock 0x83055dc
  1396. DEBUG Nov 19 13:41:59 [4132424512]: (do_handle_write): released lock 0x83055dc
  1397. INFO Nov 19 13:41:59 [4132424512]: subsys_thread_main: EDIR_SYNC: waiting for events...
  1398. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): returning 1
  1399. DEBUG Nov 19 13:41:59 [4144125760]: tlvserver_handle_request: tlv request received
  1400. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1401. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV ID: 112
  1402. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Type: 0
  1403. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Length: 0
  1404. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  1405. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1406. DEBUG Nov 19 13:41:59 [4144125760]: tlvserver_process_request: GOT TIMER ALERT.DO_ACCOUNTING
  1407. DEBUG Nov 19 13:41:59 [4144125760]: (bind_parameters_to_statement): Binding 3 parameters 0xfff42e08 for query 0x81341ac
  1408. DEBUG Nov 19 13:41:59 [4144125760]: (bind_parameters_to_statement): Query name GET_DISCONNECTED_USERS
  1409. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_DISCONNECTED_USERS, 1) succeeded
  1410. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_DISCONNECTED_USERS, 2) succeeded
  1411. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_DISCONNECTED_USERS, 4) succeeded
  1412. INFO Nov 19 13:41:59 [4144125760]: (_sqlite_db_get_disconnected_users): GET_DISCONNECTED_USERS found no entries (sqrs 101)
  1413. DEBUG Nov 19 13:41:59 [4144125760]: (_sqlite_db_get_disconnected_users): returning 0
  1414. DEBUG Nov 19 13:41:59 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  1415.  
  1416. DEBUG Nov 19 13:41:59 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff426f4 for query 0x8134300
  1417. DEBUG Nov 19 13:41:59 [4144125760]: (bind_parameters_to_statement): Query name UPDATE_CLIENTLESS_USERS_USEDMIN
  1418. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_CLIENTLESS_USERS_USEDMIN, 5) succeeded
  1419. DEBUG Nov 19 13:41:59 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  1420.  
  1421. DEBUG Nov 19 13:41:59 [4144125760]: Executing command '/sbin/ipsetelite -L users -c -m >> /tmp/authd_datafile'
  1422. DEBUG Nov 19 13:41:59 [4144125760]: dump_data_in_file: IPSET Command '/sbin/ipsetelite -L users -c -m >> /tmp/authd_datafile', Return Status:0
  1423. DEBUG Nov 19 13:41:59 [4144125760]: (bind_parameters_to_statement): Binding 4 parameters 0xfff426c0 for query 0x81342b0
  1424. DEBUG Nov 19 13:41:59 [4144125760]: (bind_parameters_to_statement): Query name UPDATE_LIVEUSER_DATATRANSFER
  1425. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_DATATRANSFER, 15491087) succeeded
  1426. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_DATATRANSFER, 692640271) succeeded
  1427. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(UPDATE_LIVEUSER_DATATRANSFER, 708131358) succeeded
  1428. DEBUG Nov 19 13:41:59 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_LIVEUSER_DATATRANSFER, 1) succeeded
  1429. DEBUG Nov 19 13:41:59 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  1430.  
  1431. DEBUG Nov 19 13:41:59 [4144125760]: (logout_timeout_users): invoked
  1432. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=17 req_handler=0x80a1949 res_handler=0x807b437 handler_data=(nil)
  1433. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1434. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  1435. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1436. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  1437. INFO Nov 19 13:41:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1438. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=17
  1439. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1440. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1441. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  1442. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  1443. INFO Nov 19 13:41:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  1444. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=18 req_handler=0x80a1949 res_handler=0x807b437 handler_data=(nil)
  1445. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1446. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  1447. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1448. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  1449. INFO Nov 19 13:41:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1450. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=18
  1451. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1452. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1453. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  1454. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  1455. INFO Nov 19 13:41:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  1456. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): subsys_name=GENERIC req_type=1 req_handler=0x80b6070 res_handler=0x807b437 handler_data=(nil)
  1457. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1458. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): acquiring lock 0x8261098
  1459. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1460. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): released lock 0x8261098
  1461. INFO Nov 19 13:41:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1462. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): GENERIC: request submitted, req_type=1
  1463. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): acquiring lock 0x8261098
  1464. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): released lock 0x8261098
  1465. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): acquiring lock 0x8261098
  1466. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): released lock 0x8261098
  1467. INFO Nov 19 13:41:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=4 wq=0x82617a8 buf=0x82617b0 offset=0
  1468. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=55 req_handler=0x80a1949 res_handler=0x807c033 handler_data=(nil)
  1469. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  1470. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  1471. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  1472. DEBUG Nov 19 13:41:59 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  1473. INFO Nov 19 13:41:59 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  1474. DEBUG Nov 19 13:41:59 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=55
  1475. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1476. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1477. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  1478. DEBUG Nov 19 13:41:59 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  1479. INFO Nov 19 13:41:59 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  1480. DEBUG Nov 19 13:41:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 14, returning
  1481. DEBUG Nov 19 13:41:59 [4144125760]: (do_epoll): Waiting for events
  1482. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=31000
  1483. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): returning 1
  1484. DEBUG Nov 19 13:41:59 [4144125760]: tlvserver_handle_request: tlv request received
  1485. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1486. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV ID: 140
  1487. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Type: 0
  1488. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Length: 0
  1489. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  1490. INFO Nov 19 13:41:59 [4144125760]: tlvserver_print_request: ---------------------------------
  1491. DEBUG Nov 19 13:41:59 [4144125760]: tlvserver_process_request: GOT ALERT.EXECUTE_HEARTBEAT
  1492. DEBUG Nov 19 13:41:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 14, returning
  1493. DEBUG Nov 19 13:41:59 [4144125760]: (do_epoll): Waiting for events
  1494. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=31000
  1495. DEBUG Nov 19 13:41:59 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  1496. DEBUG Nov 19 13:41:59 [4140821312]: handle_server_events: EVENT_READ
  1497. INFO Nov 19 13:41:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1498. INFO Nov 19 13:41:59 [4140821312]: (do_handle_read): server: read 48 bytes, fd=11
  1499. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=17 handler_data=(nil) res_handler=0x807b437
  1500. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Binding 2 parameters 0xf6cfd7a8 for query 0x81342c4
  1501. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Query name UPDATE_INACTIVITY_TIMEOUT_COUNTER
  1502. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_INACTIVITY_TIMEOUT_COUNTER, 1024) succeeded
  1503. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_INACTIVITY_TIMEOUT_COUNTER, 16) succeeded
  1504. DEBUG Nov 19 13:41:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1505.  
  1506. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Binding 6 parameters 0xf6cfd778 for query 0x81342ec
  1507. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Query name UPDATE_MULTIPLE_INACTIVITY_TIMEOUT_6_COUNTER
  1508. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_MULTIPLE_INACTIVITY_TIMEOUT_6_COUNTER, 1024) succeeded
  1509. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_MULTIPLE_INACTIVITY_TIMEOUT_6_COUNTER, 24) succeeded
  1510. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_MULTIPLE_INACTIVITY_TIMEOUT_6_COUNTER, 20) succeeded
  1511. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_MULTIPLE_INACTIVITY_TIMEOUT_6_COUNTER, 22) succeeded
  1512. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_MULTIPLE_INACTIVITY_TIMEOUT_6_COUNTER, 27) succeeded
  1513. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(UPDATE_MULTIPLE_INACTIVITY_TIMEOUT_6_COUNTER, 26) succeeded
  1514. DEBUG Nov 19 13:41:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1515.  
  1516. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Binding 14 parameters 0xf6cfd888 for query 0x8133f90
  1517. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Query name GET_TIMEOUT_INACTIVENTLM_LIVEUSERS
  1518. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_long_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 1510882008) succeeded
  1519. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 1) succeeded
  1520. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 4) succeeded
  1521. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 2) succeeded
  1522. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 18) succeeded
  1523. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 19) succeeded
  1524. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 245709) succeeded
  1525. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 540) succeeded
  1526. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 16) succeeded
  1527. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 2) succeeded
  1528. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 20) succeeded
  1529. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 22) succeeded
  1530. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 24) succeeded
  1531. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_TIMEOUT_INACTIVENTLM_LIVEUSERS, 2) succeeded
  1532. INFO Nov 19 13:41:59 [4140821312]: (_sqlite_db_handle_get_logout_users): GET_TIMEOUT_INACTIVENTLM_LIVEUSERS found no entries (sqrs 101)
  1533. DEBUG Nov 19 13:41:59 [4140821312]: (_sqlite_db_handle_get_logout_users): returning 0
  1534. DEBUG Nov 19 13:41:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1535.  
  1536. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  1537. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  1538. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  1539. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  1540. INFO Nov 19 13:41:59 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  1541. DEBUG Nov 19 13:41:59 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  1542. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1543. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1544. DEBUG Nov 19 13:41:59 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  1545. DEBUG Nov 19 13:41:59 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  1546. INFO Nov 19 13:41:59 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  1547. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_read): server tlv=0x828fe80 req_handler=0x80a1949 type=18 handler_data=(nil) res_handler=0x807b437
  1548. DEBUG Nov 19 13:41:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1549.  
  1550. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  1551. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  1552. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  1553. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  1554. INFO Nov 19 13:41:59 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  1555. DEBUG Nov 19 13:41:59 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  1556. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1557. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1558. DEBUG Nov 19 13:41:59 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  1559. DEBUG Nov 19 13:41:59 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  1560. INFO Nov 19 13:41:59 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  1561. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_read): server tlv=0x828fe90 req_handler=0x80a1949 type=55 handler_data=(nil) res_handler=0x807c033
  1562. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Binding 4 parameters 0xf6cfd888 for query 0x813406c
  1563. DEBUG Nov 19 13:41:59 [4140821312]: (bind_parameters_to_statement): Query name GET_IOS_ABT_TO_LOGOUT_USER
  1564. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_IOS_ABT_TO_LOGOUT_USER, 1) succeeded
  1565. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_IOS_ABT_TO_LOGOUT_USER, 19) succeeded
  1566. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_IOS_ABT_TO_LOGOUT_USER, 128) succeeded
  1567. DEBUG Nov 19 13:41:59 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_IOS_ABT_TO_LOGOUT_USER, 0) succeeded
  1568. INFO Nov 19 13:41:59 [4140821312]: (_sqlite_db_get_ios_user_info): GET_IOS_ABT_TO_LOGOUT_USER found no entries (sqrs 101)
  1569. INFO Nov 19 13:41:59 [4140821312]: (_sqlite_db_get_ios_user_info): row count: 0
  1570. DEBUG Nov 19 13:41:59 [4140821312]: (_sqlite_db_get_ios_user_info): returning 0
  1571. DEBUG Nov 19 13:41:59 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  1572.  
  1573. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  1574. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  1575. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  1576. DEBUG Nov 19 13:41:59 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  1577. INFO Nov 19 13:41:59 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  1578. DEBUG Nov 19 13:41:59 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  1579. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1580. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1581. DEBUG Nov 19 13:41:59 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  1582. DEBUG Nov 19 13:41:59 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  1583. INFO Nov 19 13:41:59 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  1584. INFO Nov 19 13:41:59 [4140821312]: (do_handle_read): server: READING... fd=11
  1585. INFO Nov 19 13:41:59 [4140821312]: (do_handle_read): server: read blocked
  1586. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  1587. DEBUG Nov 19 13:41:59 [4140821312]: (do_handle_write): released lock 0x828fe24
  1588. INFO Nov 19 13:41:59 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  1589. DEBUG Nov 19 13:41:59 [4144118592]: subsys_thread_main: GENERIC: event received on fd: 5
  1590. DEBUG Nov 19 13:41:59 [4144118592]: handle_server_events: EVENT_READ
  1591. INFO Nov 19 13:41:59 [4144118592]: (do_handle_read): server: READING... fd=5
  1592. INFO Nov 19 13:41:59 [4144118592]: (do_handle_read): server: read 16 bytes, fd=5
  1593. DEBUG Nov 19 13:41:59 [4144118592]: (do_handle_read): server tlv=0x82615a0 req_handler=0x80b6070 type=1 handler_data=(nil) res_handler=0x807b437
  1594. DEBUG Nov 19 13:41:59 [4144118592]: generic_handle_request: DO PERIODIC AUTHORIZATION
  1595. DEBUG Nov 19 13:41:59 [4144118592]: (auth_do_periodic_authorization): Periodic Authorization Starts
  1596. DEBUG Nov 19 13:41:59 [4144118592]: (auth_do_periodic_authorization): ludata.count = 0
  1597. DEBUG Nov 19 13:41:59 [4144118592]: (bind_parameters_to_statement): Binding 5 parameters 0xf7021bb8 for query 0x81340a8
  1598. DEBUG Nov 19 13:41:59 [4144118592]: (bind_parameters_to_statement): Query name GET_BULK_LIVEUSERINFO_5
  1599. DEBUG Nov 19 13:41:59 [4144118592]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_BULK_LIVEUSERINFO_5, 4) succeeded
  1600. DEBUG Nov 19 13:41:59 [4144118592]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_BULK_LIVEUSERINFO_5, 5) succeeded
  1601. DEBUG Nov 19 13:41:59 [4144118592]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_BULK_LIVEUSERINFO_5, 2) succeeded
  1602. DEBUG Nov 19 13:41:59 [4144118592]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_BULK_LIVEUSERINFO_5, 100) succeeded
  1603. DEBUG Nov 19 13:41:59 [4144118592]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_BULK_LIVEUSERINFO_5, 0) succeeded
  1604. INFO Nov 19 13:41:59 [4144118592]: (_sqlite_db_handle_get_bulk_liveuserinfo): GET_BULK_LIVEUSERINFO_5 found no entries (sqrs 101)
  1605. INFO Nov 19 13:41:59 [4144118592]: (_sqlite_db_handle_get_bulk_liveuserinfo): row count: 0
  1606. DEBUG Nov 19 13:41:59 [4144118592]: (_sqlite_db_handle_get_bulk_liveuserinfo): returning 0
  1607. DEBUG Nov 19 13:41:59 [4144118592]: (sqlite_db_submit_response): Request processed res=0
  1608.  
  1609. DEBUG Nov 19 13:41:59 [4144118592]: (auth_do_periodic_authorization): ludata.count = 0
  1610. DEBUG Nov 19 13:41:59 [4144118592]: (auth_do_periodic_authorization): found=0
  1611. DEBUG Nov 19 13:41:59 [4144118592]: (auth_do_periodic_authorization): Periodic Authorization Over, logout_data=(nil)
  1612. INFO Nov 19 13:41:59 [4144118592]: (do_handle_read): server: READING... fd=5
  1613. INFO Nov 19 13:41:59 [4144118592]: (do_handle_read): server: read blocked
  1614. DEBUG Nov 19 13:41:59 [4144118592]: (do_handle_write): acquiring lock 0x82610bc
  1615. DEBUG Nov 19 13:41:59 [4144118592]: (do_handle_write): released lock 0x82610bc
  1616. INFO Nov 19 13:41:59 [4144118592]: subsys_thread_main: GENERIC: waiting for events...
  1617. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): returning 1
  1618. DEBUG Nov 19 13:41:59 [4144125760]: handle_client_events: EVENT_READ
  1619. INFO Nov 19 13:41:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1620. INFO Nov 19 13:41:59 [4144125760]: (do_handle_read): client: read 48 bytes, fd=10
  1621. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=(nil) res_handler=0x807b437
  1622. DEBUG Nov 19 13:41:59 [4144125760]: handle_logout_users: handler_data NULL. No Users to Logout
  1623. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_read): client tlv=0x82d16a0 req_handler=(nil) type=0 handler_data=(nil) res_handler=0x807b437
  1624. DEBUG Nov 19 13:41:59 [4144125760]: handle_logout_users: handler_data NULL. No Users to Logout
  1625. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_read): client tlv=0x82d16b0 req_handler=(nil) type=0 handler_data=(nil) res_handler=0x807c033
  1626. DEBUG Nov 19 13:41:59 [4144125760]: handle_ios_users_info: no user to send logout info
  1627. INFO Nov 19 13:41:59 [4144125760]: (do_handle_read): client: READING... fd=10
  1628. INFO Nov 19 13:41:59 [4144125760]: (do_handle_read): client: read blocked
  1629. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  1630. DEBUG Nov 19 13:41:59 [4144125760]: (do_handle_write): released lock 0x828fe00
  1631. DEBUG Nov 19 13:41:59 [4144125760]: (CA_keep_alive): called too soon, seconds = 14, returning
  1632. DEBUG Nov 19 13:41:59 [4144125760]: (do_epoll): Waiting for events
  1633. DEBUG Nov 19 13:41:59 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=31000
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!