API tools faq
paste
cyberzeus

log for sophos mac CAA auto-disconnect

cyberzeus
Nov 19th, 2017
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 78.17 KB | None | 0 0
raw download clone embed print report
  1. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  2. INFO Nov 19 12:18:23 [4144125760]: (listen_callback): New connection from [ IP_MASKED ]
  3. INFO Nov 19 12:18:23 [4144125760]: (CA_add_conn): Successfully added IP [ IP_MASKED ]
  4. DEBUG Nov 19 12:18:23 [4144125760]: (CA_add_conn): Created new conn 0x830d958 generation 13
  5. DEBUG Nov 19 12:18:23 [4144125760]: (listen_callback): conn 0x830d958 generation 13, ssl 0x830dfb8 created
  6. INFO Nov 19 12:18:23 [4144125760]: (register_epoll): Successfully registered epoll for fd 26, ep_data 0x82f56b8
  7. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  8. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  9. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  10. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  11. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  12. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  13. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  14. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  15. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  16. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  17. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  18. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  19. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  20. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  21. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  22. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  23. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Read 6 bytes on fd 26
  24. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): SSL read: xxx2xx
  25. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Processing command: xxx2xx
  26. INFO Nov 19 12:18:23 [4144125760]: (process_command): Number of received TLVs: 1
  27. MESSAGE Nov 19 12:18:23 [4144125760]: (process_command): Client type is OS X
  28. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): No AA_MESS_DEVICE_ID TLV found in chain
  29. DEBUG Nov 19 12:18:23 [4144125760]: (send_data): SSL write: xxxxx
  30. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  31. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  32. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  33. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  34. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Read 1 bytes on fd 26
  35. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): SSL read: x
  36. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Buffered: x
  37. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  38. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  39. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  40. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  41. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Read 24 bytes on fd 26
  42. INFO Nov 19 12:18:23 [4144125760]: (process_command): Number of received TLVs: 2
  43. DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Allocated user 0x830d010 username [ USERNAME_MASKED ]
  44. DEBUG Nov 19 12:18:23 [4144125760]: (lc_utf8_bytes): lowercase = '[ USERNAME_MASKED ]'
  45. DEBUG Nov 19 12:18:23 [4144125760]: (CA_authenticate_user): Request data prepared for user [ USERNAME_MASKED ]
  46. INFO Nov 19 12:18:23 [4144125760]: (print_req_data): username:[ USERNAME_MASKED ]
  47. INFO Nov 19 12:18:23 [4144125760]: (print_req_data): password:xx...x
  48. INFO Nov 19 12:18:23 [4144125760]: (print_req_data): macaddress:
  49. INFO Nov 19 12:18:23 [4144125760]: (print_req_data): ipaddress:[ IP_MASKED ]
  50. INFO Nov 19 12:18:23 [4144125760]: (print_req_data): domainname:
  51. INFO Nov 19 12:18:23 [4144125760]: (print_req_data): clienttype:1
  52. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=3 req_handler=0x80a1949 res_handler=0x807850b handler_data=0x831ffb8
  53. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  54. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  55. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  56. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  57. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  58. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=3
  59. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  60. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  61. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  62. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  63. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  64. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  65. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  66. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  67. DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  68. DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
  69. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  70. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  71. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=3 handler_data=0x831ffb8 res_handler=0x807850b
  72. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x8133e14
  73. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_BYIP
  74. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_BYIP, [ IP_MASKED ]) succeeded
  75. INFO Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byip): GET_LIVEUSER_BYIP found no entries (sqrs 101)
  76. DEBUG Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byip): returning 0
  77. DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  78.  
  79. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  80. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  81. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  82. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  83. INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  84. DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  85. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  86. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  87. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  88. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  89. INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  90. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  91. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
  92. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  93. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  94. INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  95. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  96. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  97. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  98. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  99. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x807850b
  100. DEBUG Nov 19 12:18:23 [4144125760]: authenticate: SQLITE_REQ_GETLIVEUSER_BYIP Successful
  101. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=POSTGRES_DB req_type=34 req_handler=0x8095f19 res_handler=0x80782ab handler_data=0x831ffb8
  102. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  103. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
  104. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  105. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
  106. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  107. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=34
  108. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  109. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  110. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
  111. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
  112. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
  113. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  114. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  115. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  116. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  117. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  118. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  119. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  120. DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
  121. DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
  122. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  123. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
  124. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=34 handler_data=0x831ffb8 res_handler=0x80782ab
  125. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): AUTHENTICATE_GUEST_USER triggers alloc_query_vals()
  126. DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
  127. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'AUTHENTICATE_GUEST_USER'
  128. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
  129. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0]: '[ USERNAME_MASKED ]'
  130. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'AUTHENTICATE_GUEST_USER'
  131. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
  132. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_authenticate_guest_user: row count: 1
  133. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_authenticate_guest_user: column:'usertype', value:'5'
  134. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_authenticate_guest_user: Not a Guest user
  135. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
  136. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
  137. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
  138. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
  139. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
  140. INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  141. DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
  142. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  143. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  144. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
  145. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
  146. INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
  147. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  148. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
  149. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  150. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  151. INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
  152. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  153. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  154. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  155. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
  156. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x80782ab
  157. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=OTP_AUTH req_type=0 req_handler=0x80caa45 res_handler=0x8077939 handler_data=0x831ffb8
  158. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  159. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x82e91c8
  160. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  161. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x82e91c8
  162. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  163. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): OTP_AUTH: request submitted, req_type=0
  164. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82e91c8
  165. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82e91c8
  166. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x82e91c8
  167. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x82e91c8
  168. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=15 wq=0x82efb68 buf=0x82efb70 offset=0
  169. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  170. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  171. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  172. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  173. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  174. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  175. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  176. DEBUG Nov 19 12:18:23 [4134529856]: subsys_thread_main: OTP_AUTH: event received on fd: 16
  177. DEBUG Nov 19 12:18:23 [4134529856]: handle_server_events: EVENT_READ
  178. INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: READING... fd=16
  179. INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: read 16 bytes, fd=16
  180. DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_read): server tlv=0x82e8d50 req_handler=0x80caa45 type=0 handler_data=0x831ffb8 res_handler=0x8077939
  181. DEBUG Nov 19 12:18:23 [4134529856]: (otp_handle_prepare_authentication_request): OTP prepare authentication for user [ USERNAME_MASKED ]
  182. DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): : SERVER, datasize: 16
  183. DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): acquiring lock 0x82e91ec
  184. DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): : SERVER, remlen: 160
  185. DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): released lock 0x82e91ec
  186. INFO Nov 19 12:18:23 [4134529856]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  187. DEBUG Nov 19 12:18:23 [4134529856]: subsys_submit_response: OTP_AUTH: response submitted, res_type=0
  188. DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): acquiring lock 0x82e91ec
  189. DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): released lock 0x82e91ec
  190. DEBUG Nov 19 12:18:23 [4134529856]: (write_subsysqueue): acquiring lock 0x82e91ec
  191. DEBUG Nov 19 12:18:23 [4134529856]: (write_subsysqueue): released lock 0x82e91ec
  192. INFO Nov 19 12:18:23 [4134529856]: (write_subsysqueue): SERVER: written 16 bytes, fd=16 wq=0x82e8df8 buf=0x82e8e00 offset=0
  193. INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: READING... fd=16
  194. INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: read blocked
  195. DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): acquiring lock 0x82e91ec
  196. DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): released lock 0x82e91ec
  197. INFO Nov 19 12:18:23 [4134529856]: subsys_thread_main: OTP_AUTH: waiting for events...
  198. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  199. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  200. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=15
  201. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=15
  202. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82e8eb0 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8077939
  203. DEBUG Nov 19 12:18:23 [4144125760]: (authenticate_user): current server:0, auth_client:0
  204. INFO Nov 19 12:18:23 [4144125760]: authenticate_user: Server:0, Local Authentication
  205. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=POSTGRES_DB req_type=35 req_handler=0x8095f19 res_handler=0x8077939 handler_data=0x831ffb8
  206. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  207. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
  208. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  209. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
  210. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  211. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=35
  212. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  213. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  214. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
  215. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
  216. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
  217. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=15
  218. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  219. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82e91c8
  220. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82e91c8
  221. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  222. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  223. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  224. DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
  225. DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
  226. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  227. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
  228. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=35 handler_data=0x831ffb8 res_handler=0x8077939
  229. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): AUTHENTICATE_USER triggers alloc_query_vals()
  230. DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
  231. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'AUTHENTICATE_USER'
  232. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
  233. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0] length=4: 1
  234. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[1] length=4: 5
  235. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[2] length=4: 2
  236. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[3] length=4: 1
  237. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[4]: '[ USERNAME_MASKED ]'
  238. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'AUTHENTICATE_USER'
  239. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
  240. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_authenticate_user): row count: 1
  241. DEBUG Nov 19 12:18:23 [4141873984]: (de_obfuscate): 1c2c236cb0b86122255da65c18deac714217 decoded, password not empty
  242. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
  243. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
  244. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
  245. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
  246. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
  247. INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  248. DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
  249. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  250. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  251. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
  252. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
  253. INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
  254. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  255. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
  256. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  257. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  258. INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
  259. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  260. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  261. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  262. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
  263. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8077939
  264. DEBUG Nov 19 12:18:23 [4144125760]: (authenticate_user): current server:1, auth_client:0
  265. DEBUG Nov 19 12:18:23 [4144125760]: authenticate_user: SUCCESS || current_server >= MAX_LIMIT
  266. DEBUG Nov 19 12:18:23 [4144125760]: (is_local_auth): current_server = 0, auth_client = 0, authserver_id = 1, local_authserver_id = 1
  267. DEBUG Nov 19 12:18:23 [4144125760]: (check_auth_result): ==> local user
  268. DEBUG Nov 19 12:18:23 [4144125760]: check_auth_result: Authentication Successful, clienttype=1 auth_client=0
  269. DEBUG Nov 19 12:18:23 [4144125760]: (delete_admin_access_entry): invoked
  270. DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff430c8 for query 0x8133e28
  271. DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Query name IS_ADMIN_IP_EXIST
  272. DEBUG Nov 19 12:18:23 [4144125760]: (check_sqlite_bind_text_result): sqlite3_bind_text(IS_ADMIN_IP_EXIST, [ IP_MASKED ]) succeeded
  273. DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): IS_ADMIN_IP_EXIST retrieved: count = 0
  274. DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): returning 0
  275. DEBUG Nov 19 12:18:23 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  276.  
  277. DEBUG Nov 19 12:18:23 [4144125760]: (CA_add_conn_to_user): Allocated user 0x831efb0 username 0x830d010 ([ USERNAME_MASKED ])
  278. INFO Nov 19 12:18:23 [4144125760]: (CA_add_conn_to_user): Created new user [ USERNAME_MASKED ]
  279. MESSAGE Nov 19 12:18:23 [4144125760]: (CA_authentication_result): User [ USERNAME_MASKED ] authenticated (CA)
  280. DEBUG Nov 19 12:18:23 [4144125760]: (send_data): SSL write: xxxxx
  281. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=POSTGRES_DB req_type=0 req_handler=0x8095f19 res_handler=0x8072b72 handler_data=0x831ffb8
  282. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  283. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
  284. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  285. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
  286. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  287. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=0
  288. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  289. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  290. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
  291. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
  292. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
  293. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  294. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  295. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  296. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  297. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  298. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  299. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  300. DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
  301. DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
  302. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  303. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
  304. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=0 handler_data=0x831ffb8 res_handler=0x8072b72
  305. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): GET_USERINFO triggers alloc_query_vals()
  306. DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
  307. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'GET_USERINFO'
  308. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
  309. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0]: '[ USERNAME_MASKED ]'
  310. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[1] length=4: 1
  311. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[2] length=4: 2
  312. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[3] length=4: 5
  313. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[4] length=4: 8
  314. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'GET_USERINFO'
  315. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
  316. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: row count: 1
  317. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_get_userinfo): pg_server 0x8261160
  318. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_get_userinfo): building userinfo: integration=0 req_data.groupname='NULL'
  319. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'userid', value:'10'
  320. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'groupid', value:'9'
  321. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'username', value:'[ USERNAME_MASKED ]'
  322. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'name', value:'[ USERNAME_MASKED ]'
  323. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'emailid', value:'[ EMAIL_MASKED ]'
  324. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'name', value:'adults'
  325. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'active', value:'Y'
  326. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'usertype', value:'5'
  327. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'webfilterid', value:'1'
  328. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'appfilterid', value:'1'
  329. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'accesspolicyid', value:'1'
  330. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'bwpolicyid', value:''
  331. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'surfingquotapolicyid', value:'1'
  332. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'datatransferpolicyid', value:''
  333. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'ipallocation', value:'4'
  334. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'allotedminutes', value:'-11'
  335. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'usedminutes', value:'1008'
  336. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'cycleusedminutes', value:'1008'
  337. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'uploaddata', value:'46881108'
  338. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'downloaddata', value:'1016019810'
  339. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'lastusedtime', value:'2017-11-19 12:16:28'
  340. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'cycleupload', value:'46881108'
  341. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'cycledownload', value:'1016019810'
  342. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'maxloginallowed', value:'-1'
  343. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'renewdate', value:'2017-11-18'
  344. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'macbinding', value:'1'
  345. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'ipallocation', value:'1'
  346. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
  347. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
  348. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
  349. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
  350. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
  351. INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  352. DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
  353. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  354. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  355. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
  356. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
  357. INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
  358. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  359. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
  360. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  361. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  362. INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
  363. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  364. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  365. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  366. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
  367. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8072b72
  368. DEBUG Nov 19 12:18:23 [4144125760]: do_authorization: Got User Info Successfully
  369. DEBUG Nov 19 12:18:23 [4144125760]: is_currently_allowed: accesspolicy:1
  370. DEBUG Nov 19 12:18:23 [4144125760]: is_currently_allowed: currday:1, hour:12, min:18, currtime:738
  371. INFO Nov 19 12:18:23 [4144125760]: is_currently_allowed: POLICY MATCH. Strategy:'Y'
  372. DEBUG Nov 19 12:18:23 [4144125760]: has_surfing_time: effective_alloted_min:-11, effective_used_min:1008
  373. DEBUG Nov 19 12:18:23 [4144125760]: has_surfing_time: YES
  374. INFO Nov 19 12:18:23 [4144125760]: match_surfing_quota: SQuota policy id:1, cycle:80
  375. DEBUG Nov 19 12:18:23 [4144125760]: check_mac_binding: Going to insert USERID-MAC values,10:''
  376. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=POSTGRES_DB req_type=2 req_handler=0x8095f19 res_handler=0x80709d6 handler_data=0x831ffb8
  377. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  378. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
  379. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  380. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
  381. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  382. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=2
  383. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  384. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  385. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
  386. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
  387. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
  388. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  389. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  390. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  391. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  392. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  393. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  394. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  395. DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
  396. DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
  397. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  398. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
  399. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=2 handler_data=0x831ffb8 res_handler=0x80709d6
  400. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): IS_MAC_BINDING_PRESENT triggers alloc_query_vals()
  401. DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
  402. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'IS_MAC_BINDING_PRESENT'
  403. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
  404. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0] length=4: 10
  405. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'IS_MAC_BINDING_PRESENT'
  406. DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
  407. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_check_mac_ip_binding: row count: 1
  408. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_check_mac_ip_binding: column:'count', value:'0'
  409. DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
  410. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
  411. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
  412. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
  413. DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
  414. INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  415. DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
  416. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  417. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  418. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
  419. DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
  420. INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
  421. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
  422. INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
  423. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
  424. DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
  425. INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
  426. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  427. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  428. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  429. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
  430. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x80709d6
  431. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=2 req_handler=0x80a1949 res_handler=0x80708bd handler_data=0x831ffb8
  432. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  433. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  434. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  435. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  436. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  437. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=2
  438. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  439. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  440. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  441. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  442. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  443. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
  444. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  445. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
  446. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
  447. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  448. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  449. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  450. DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  451. DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
  452. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  453. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  454. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=2 handler_data=0x831ffb8 res_handler=0x80708bd
  455. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x8133e00
  456. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_BYNAME
  457. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_BYNAME, [ USERNAME_MASKED ]) succeeded
  458. DEBUG Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byname): GET_LIVEUSER_BYNAME retrieved: login_count=0
  459. DEBUG Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byname): returning 0
  460. DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  461.  
  462. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  463. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  464. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  465. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  466. INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  467. DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  468. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  469. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  470. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  471. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  472. INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  473. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  474. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
  475. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  476. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  477. INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  478. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  479. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  480. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  481. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  482. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x80708bd
  483. INFO Nov 19 12:18:23 [4144125760]: do_authorization_phase2: UNL and FREE_IP
  484. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: LAST-UID: 2 BYTE-ID: 0
  485. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BYTE-ID: 0
  486. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BYTE[0]: 0x1
  487. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: free bits found at BYTE-ID: 0
  488. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BIT[0] is not free
  489. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BIT[1] is free
  490. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: Before SET_BIT[1] BYTE[0]: 0x1
  491. DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: After SET_BIT[1] BYTE[0]: 0x3
  492. INFO Nov 19 12:18:23 [4144125760]: uid_allocate: allocated UID: 1
  493. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=8 req_handler=0x80a1949 res_handler=0x8072f25 handler_data=0x831ffb8
  494. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  495. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  496. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  497. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  498. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  499. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=8
  500. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  501. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  502. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  503. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  504. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  505. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  506. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  507. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  508. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  509. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  510. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  511. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  512. DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  513. DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
  514. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  515. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  516. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=8 handler_data=0x831ffb8 res_handler=0x8072f25
  517. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 23 parameters 0xf6cfd888 for query 0x8134120
  518. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name INSERT_LIVEUSER
  519. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  520. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 10) succeeded
  521. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ USERNAME_MASKED ]) succeeded
  522. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ USERNAME_MASKED ]) succeeded
  523. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ USERNAME_MASKED ]) succeeded
  524. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ IP_MASKED ]) succeeded
  525. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 9) succeeded
  526. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 240693) succeeded
  527. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 240693) succeeded
  528. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  529. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  530. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  531. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
  532. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  533. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  534. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
  535. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, 2017-11-18) succeeded
  536. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
  537. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
  538. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 2) succeeded
  539. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
  540. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
  541. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
  542. DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  543.  
  544. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  545. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  546. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  547. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  548. INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  549. DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  550. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  551. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  552. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  553. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  554. INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  555. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  556. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
  557. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  558. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  559. INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  560. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  561. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  562. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  563. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  564. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8072f25
  565. INFO Nov 19 12:18:23 [4144125760]: handle_liveuser_insert: LIVE USER '[ USERNAME_MASKED ]' INSERTED
  566. DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff43118 for query 0x8133e3c
  567. DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Query name ISUSEREXISTS_LIVEUSER_ACC
  568. DEBUG Nov 19 12:18:23 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(ISUSEREXISTS_LIVEUSER_ACC, 10) succeeded
  569. DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): ISUSEREXISTS_LIVEUSER_ACC retrieved: count = 0
  570. DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): returning 0
  571. DEBUG Nov 19 12:18:23 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  572.  
  573. DEBUG Nov 19 12:18:23 [4144125760]: (handle_liveuser_insert): INSERTING in LIVEUSER_ACC
  574. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=SQLITE_DB req_type=9 req_handler=0x80a1949 res_handler=0x8072e78 handler_data=0x831ffb8
  575. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  576. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
  577. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  578. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
  579. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  580. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=9
  581. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  582. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  583. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
  584. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
  585. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
  586. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  587. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  588. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  589. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  590. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  591. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  592. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  593. DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
  594. DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
  595. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  596. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
  597. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=9 handler_data=0x831ffb8 res_handler=0x8072e78
  598. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 8 parameters 0xf6cfd888 for query 0x81341d4
  599. DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name INSERT_LIVEUSER_ACC
  600. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 10) succeeded
  601. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1511122703) succeeded
  602. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1008) succeeded
  603. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1008) succeeded
  604. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 46881108) succeeded
  605. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1016019810) succeeded
  606. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 46881108) succeeded
  607. DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1016019810) succeeded
  608. DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
  609.  
  610. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
  611. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
  612. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
  613. DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
  614. INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  615. DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
  616. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  617. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  618. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
  619. DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
  620. INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
  621. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
  622. INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
  623. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
  624. DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
  625. INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
  626. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  627. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  628. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  629. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
  630. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8072e78
  631. DEBUG Nov 19 12:18:23 [4144125760]: (login_user): no accounting_server configured
  632. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): subsys_name=OPCODE req_type=0 req_handler=0x80b89ad res_handler=0x8078e4e handler_data=0x831ffb8
  633. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  634. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x82effb8
  635. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  636. DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x82effb8
  637. INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  638. DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): OPCODE: request submitted, req_type=0
  639. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82effb8
  640. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82effb8
  641. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x82effb8
  642. DEBUG Nov 19 12:18:23 [4133477184]: subsys_thread_main: OPCODE: event received on fd: 18
  643. DEBUG Nov 19 12:18:23 [4133477184]: handle_server_events: EVENT_READ
  644. INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: READING... fd=18
  645. INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: read 16 bytes, fd=18
  646. DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_read): server tlv=0x82f0038 req_handler=0x80b89ad type=0 handler_data=0x831ffb8 res_handler=0x8078e4e
  647. ERROR Nov 19 12:18:23 [4133477184]: config_resolve_bwid: BW Policy 0 not found
  648. DEBUG Nov 19 12:18:23 [4133477184]: opcode_handle_login: OPCODE: JSON:'{ "groupid":"adults","userid":"[ USERNAME_MASKED ]","liveuserid":"1","ipaddress":"[ IP_MASKED ]","bwpolicyid":"","webfilterid":"Allow All","appfilterid":"Allow All","starttime":"240693","clienttype":"1","setname":"lusers","addr_family":"2","ismicroapp":"1","authservername":"","macaddress":"","logintime":"2017-11-19 12:18:23" }'
  649. DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x82effb8
  650. INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=17 wq=0x82f4428 buf=0x82f4430 offset=0
  651. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
  652. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  653. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
  654. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
  655. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  656. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  657. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  658. INFO Nov 19 12:18:23 [4133477184]: (opcode_handle_login): OPCODE: OPCODE executed successfully
  659. DEBUG Nov 19 12:18:23 [4133477184]: (bind_parameters_to_statement): Binding 3 parameters 0xf65fc88c for query 0x8134314
  660. DEBUG Nov 19 12:18:23 [4133477184]: (bind_parameters_to_statement): Query name GET_LIVEUSERCNT_BYIP_UID_ID
  661. DEBUG Nov 19 12:18:23 [4133477184]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSERCNT_BYIP_UID_ID, 1) succeeded
  662. DEBUG Nov 19 12:18:23 [4133477184]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSERCNT_BYIP_UID_ID, 10) succeeded
  663. DEBUG Nov 19 12:18:23 [4133477184]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSERCNT_BYIP_UID_ID, [ IP_MASKED ]) succeeded
  664. DEBUG Nov 19 12:18:23 [4133477184]: (handle_count_star_query): GET_LIVEUSERCNT_BYIP_UID_ID retrieved: count = 1
  665. DEBUG Nov 19 12:18:23 [4133477184]: (handle_count_star_query): returning 1
  666. DEBUG Nov 19 12:18:23 [4133477184]: (sqlite_db_submit_response): Request processed res=1
  667.  
  668. DEBUG Nov 19 12:18:23 [4133477184]: (exists_live_user): 1 live user {luid 1, uid 10, ip [ IP_MASKED ]}
  669. DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): : SERVER, datasize: 16
  670. DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): acquiring lock 0x82effdc
  671. DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): : SERVER, remlen: 160
  672. DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): released lock 0x82effdc
  673. INFO Nov 19 12:18:23 [4133477184]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
  674. DEBUG Nov 19 12:18:23 [4133477184]: subsys_submit_response: OPCODE: response submitted, res_type=0
  675. DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): acquiring lock 0x82effdc
  676. DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): released lock 0x82effdc
  677. DEBUG Nov 19 12:18:23 [4133477184]: (write_subsysqueue): acquiring lock 0x82effdc
  678. DEBUG Nov 19 12:18:23 [4133477184]: (write_subsysqueue): released lock 0x82effdc
  679. INFO Nov 19 12:18:23 [4133477184]: (write_subsysqueue): SERVER: written 16 bytes, fd=18 wq=0x82f00e0 buf=0x82f00e8 offset=0
  680. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
  681. INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: READING... fd=18
  682. DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
  683. INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: read blocked
  684. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=17
  685. DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): acquiring lock 0x82effdc
  686. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=17
  687. DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): released lock 0x82effdc
  688. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82f4380 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8078e4e
  689. INFO Nov 19 12:18:23 [4133477184]: subsys_thread_main: OPCODE: waiting for events...
  690. INFO Nov 19 12:18:23 [4144125760]: create_response: AUTHENTICATION SUCCESSFULL
  691. DEBUG Nov 19 12:18:23 [4144125760]: is_incr: 1
  692. DEBUG Nov 19 12:18:23 [4144125760]: get_effective_time: 1008
  693. DEBUG Nov 19 12:18:23 [4144125760]: (send_response): Error sending data: Invalid argument
  694. INFO Nov 19 12:18:23 [4144125760]: create_response: RESULT String: inc:1008:You have successfully logged in:no
  695. DEBUG Nov 19 12:18:23 [4144125760]: free_session_data: session_data=0x831ffb8
  696. DEBUG Nov 19 12:18:23 [4144125760]: (reset_user_info): resetting user_info 0xf68021d0
  697. DEBUG Nov 19 12:18:23 [4144125760]: (free_session_data): freeing user_info 0xf68021d0
  698. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=17
  699. INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
  700. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82effb8
  701. DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82effb8
  702. DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
  703. DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
  704. DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
  705. DEBUG Nov 19 12:18:25 [4144125760]: (CA_epoll_wait): returning 0
  706. DEBUG Nov 19 12:18:25 [4144125760]: (CA_keep_alive): Checking connections status
  707. MESSAGE Nov 19 12:18:25 [4144125760]: (CA_keep_alive): Sending PING to [ USERNAME_MASKED ]
  708. DEBUG Nov 19 12:18:25 [4144125760]: (do_epoll): Waiting for events
  709. DEBUG Nov 19 12:18:25 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
  710. DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): returning 1
  711. DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_handle_request: tlv request received
  712. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
  713. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV ID: 140
  714. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Type: 0
  715. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Length: 0
  716. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  717. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
  718. DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_process_request: GOT ALERT.EXECUTE_HEARTBEAT
  719. DEBUG Nov 19 12:19:00 [4144125760]: (CA_keep_alive): called too soon, seconds = 35, returning
  720. DEBUG Nov 19 12:19:00 [4144125760]: (do_epoll): Waiting for events
  721. DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=10000
  722. DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): returning 1
  723. DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_handle_request: tlv request received
  724. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
  725. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV ID: 148
  726. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Type: 0
  727. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Length: 0
  728. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
  729. INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
  730. DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_process_request: GOT ALERT.EDIR_SYNC
  731. DEBUG Nov 19 12:19:00 [4144125760]: (subsys_submit_request): subsys_name=EDIR_SYNC req_type=0 req_handler=0x80b5b92 res_handler=(nil) handler_data=(nil)
  732. DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
  733. DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): acquiring lock 0x83055b8
  734. DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
  735. DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): released lock 0x83055b8
  736. INFO Nov 19 12:19:00 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
  737. DEBUG Nov 19 12:19:00 [4144125760]: (subsys_submit_request): EDIR_SYNC: request submitted, req_type=0
  738. DEBUG Nov 19 12:19:00 [4144125760]: (do_handle_write): acquiring lock 0x83055b8
  739. DEBUG Nov 19 12:19:00 [4144125760]: (do_handle_write): released lock 0x83055b8
  740. DEBUG Nov 19 12:19:00 [4144125760]: (write_subsysqueue): acquiring lock 0x83055b8
  741. DEBUG Nov 19 12:19:00 [4144125760]: (write_subsysqueue): released lock 0x83055b8
  742. INFO Nov 19 12:19:00 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=23 wq=0x8307a80 buf=0x8307a88 offset=0
  743. DEBUG Nov 19 12:19:00 [4144125760]: (CA_keep_alive): called too soon, seconds = 35, returning
  744. DEBUG Nov 19 12:19:00 [4144125760]: (do_epoll): Waiting for events
  745. DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=10000
  746. DEBUG Nov 19 12:19:00 [4132424512]: subsys_thread_main: EDIR_SYNC: event received on fd: 24
  747. DEBUG Nov 19 12:19:00 [4132424512]: handle_server_events: EVENT_READ
  748. INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: READING... fd=24
  749. INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: read 16 bytes, fd=24
  750. DEBUG Nov 19 12:19:00 [4132424512]: (do_handle_read): server tlv=0x8305628 req_handler=0x80b5b92 type=0 handler_data=(nil) res_handler=(nil)
  751. INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: READING... fd=24
  752. INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: read blocked
  753. DEBUG Nov 19 12:19:00 [4132424512]: (do_handle_write): acquiring lock 0x83055dc
  754. DEBUG Nov 19 12:19:00 [4132424512]: (do_handle_write): released lock 0x83055dc
  755. INFO Nov 19 12:19:00 [4132424512]: subsys_thread_main: EDIR_SYNC: waiting for events...
  756. DEBUG Nov 19 12:19:10 [4144125760]: (CA_epoll_wait): returning 0
  757. DEBUG Nov 19 12:19:10 [4144125760]: (CA_keep_alive): Checking connections status
  758. ERROR Nov 19 12:19:10 [4144125760]: (CA_keep_alive): Timeout for [ USERNAME_MASKED ], will drop connection
  759. MESSAGE Nov 19 12:19:10 [4144125760]: (CA_disconnect_user): Will disconnect user [ USERNAME_MASKED ]
  760. DEBUG Nov 19 12:19:10 [4144125760]: (new_livereq_data): _livereq_data=0x831c798
  761. DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Binding 2 parameters 0xfff42da8 for query 0x81340f8
  762. DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Query name GET_LIVEUSER_INFO_TO_LOGOUT
  763. DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_INFO_TO_LOGOUT, [ IP_MASKED ]) succeeded
  764. DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_INFO_TO_LOGOUT, 5) succeeded
  765. DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Live username len 9
  766. DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Live name len 9
  767. ERROR Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Missing message!
  768. DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): GET_LIVEUSER_INFO_TO_LOGOUT retrieved: liveuserid=1 userid=10 groupid=9 liveuser_name_by_ip='[ USERNAME_MASKED ]' name='[ USERNAME_MASKED ]' attr.starttime=240693 attr.lastlivetime=240693 isactive=1 groupid=9 policyid=1 accesspolicyid=1 bwpolicyid=0 datatransferpolicyid=0 lastusedtime=1511122703 used_minutes=1008 cycleused_minutes=1008 renewdate='2017-11-18' upload=46881108 download=1016019810 cycleupload=46881108 cycledownload=1016019810 message='NULL' macaddress='' clienttype=1 addr_family=2 authserver_id=0
  769. DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): returning 0
  770. DEBUG Nov 19 12:19:10 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  771.  
  772. DEBUG Nov 19 12:19:10 [4144125760]: (send_response): Error sending data: Invalid argument
  773. DEBUG Nov 19 12:19:10 [4144125760]: (handle_external_logout_req_finish_free): SQLITE_REQ_GETLIVEUSERINFO successful
  774. DEBUG Nov 19 12:19:10 [4144125760]: (update_lastlivetime): update_lastlivetime: now:240739, used_min:1008, cycleused_min:1008, lastlivetime:240693, diffmin:0.766667
  775. DEBUG Nov 19 12:19:10 [4144125760]: (update_lastlivetime): diffmin : 1.266667
  776. DEBUG Nov 19 12:19:10 [4144125760]: (update_lastlivetime): livereq used_minutes : 1009
  777. DEBUG Nov 19 12:19:10 [4144125760]: update_lastlivetime: Executing command '/sbin/ipsetelite -L users liveuserid=1 -c'
  778. DEBUG Nov 19 12:19:10 [4144125760]: update_lastlivetime: Command Output: '1,221186,4680716
  779. '
  780. DEBUG Nov 19 12:19:10 [4144125760]: update_lastlivetime: new_upload:221186, new_download:4680716, pre_upload:46881108, pre_download:1016019810, pre_cycleupload:46881108, pre_cycledownload:46881108
  781. DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff42b78 for query 0x8134030
  782. DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Query name GET_LIVEUSER_SESSION_DATA
  783. DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_SESSION_DATA, 1) succeeded
  784. DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_live_session_data): GET_LIVEUSER_SESSION_DATA retrieved: upload=0 download=0
  785. DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_live_session_data): returning 0
  786. DEBUG Nov 19 12:19:10 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  787.  
  788. DEBUG Nov 19 12:19:10 [4144125760]: new_cycleupload:47102294, new_cycledownload:1020700526
  789. DEBUG Nov 19 12:19:10 [4144125760]: fill_logout_garner_data: UPLOAD:221186,DOWNLOAD:4680716,starttime:1511122703, Groupid:9, MAC:'', NAME:'[ USERNAME_MASKED ]'
  790. DEBUG Nov 19 12:19:10 [4144125760]: execute_update_tbluseraccounting: OPCODE: JSON:'{ "userids":["[ USERNAME_MASKED ]"],"uploaddata":["47102294"],"downloaddata":["1020700526"],"cycleupload":["47102294"],"cycledownload":["1020700526"],"usedminutes":[1009],"cycleusedminutes":[1009],"lastusedtime":["2017-11-19 12:18:23"] }'
  791. INFO Nov 19 12:19:10 [4144125760]: execute_update_tbluseraccounting: OPCODE: OPCODE executed successfully
  792. DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff42d68 for query 0x813415c
  793. DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Query name REMOVE_LIVEUSER
  794. DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(REMOVE_LIVEUSER, 1) succeeded
  795. DEBUG Nov 19 12:19:10 [4144125760]: (sqlite_db_submit_response): Request processed res=0
  796.  
  797. ERROR Nov 19 12:19:10 [4144125760]: config_resolve_bwid: BW Policy 0 not found
  798. DEBUG Nov 19 12:19:10 [4144125760]: (opcode_handle_logout): clienttype 1, JASON: { "userid":"[ USERNAME_MASKED ]","liveuserid":"1","bwpolicyid":"","ipaddress":"[ IP_MASKED ]","setname":"lusers", }
  799. INFO Nov 19 12:19:10 [4144125760]: opcode_handle_logout: OPCODE: OPCODE executed successfully
  800. DEBUG Nov 19 12:19:10 [4144125760]: uid_release: BYTE-ID: 0
  801. DEBUG Nov 19 12:19:10 [4144125760]: uid_release: BIT-ID: 1
  802. DEBUG Nov 19 12:19:10 [4144125760]: uid_release: Before CLEAR_BIT[1] BYTE[0]: 0x3
  803. DEBUG Nov 19 12:19:10 [4144125760]: uid_release: Before CLEAR_BIT[1] BYTE[0]: 0x1
  804. INFO Nov 19 12:19:10 [4144125760]: uid_release: UID 1 released
  805. DEBUG Nov 19 12:19:10 [4144125760]: (free_livereq_data): _livereq_data=0x831c798
  806. DEBUG Nov 19 12:19:10 [4144125760]: (CA_remove_conn): Will remove connection 0x830d958 with fd 26 for user [ USERNAME_MASKED ]
  807. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ===============================================================
  808. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): fd: 26, authenticated: 1, secured: 1, alive: 0
  809. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): username: [ USERNAME_MASKED ]
  810. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ip_address_string: [ IP_MASKED ]
  811. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): type: 2
  812. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): APNDeviceID: (null)
  813. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): login_time: 1511122703
  814. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ssl: 0x830dfb8
  815. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): cmd_buffer: (null), cmd_buffer_size: 0
  816. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ip_list: 0x831e940, num_ip: 1
  817. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ip6_list: (nil), num_ip6: 0
  818. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): mac_list: (nil), num_mac: 0
  819. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): next: (nil)
  820. DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ===============================================================
  821. INFO Nov 19 12:19:10 [4144125760]: (CA_remove_conn_for_user): User [ USERNAME_MASKED ] has no connections left, removing the user
  822. DEBUG Nov 19 12:19:10 [4144125760]: (CA_remove_conn_for_user): Releasing user 0x831efb0 username 0x830d010
  823. DEBUG Nov 19 12:19:10 [4144125760]: (deregister_conn_epoll): releasing ep_data 0x82f56b8
  824. DEBUG Nov 19 12:19:10 [4144125760]: (CA_close_connection): conn 0x830d958 generation 13, freeing ssl 0x830dfb8
  825. DEBUG Nov 19 12:19:10 [4144125760]: (CA_remove_conn): Releasing conn 0x830d958 generation 13
  826. DEBUG Nov 19 12:19:10 [4144125760]: (do_epoll): Waiting for events
  827. DEBUG Nov 19 12:19:10 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
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!