Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- INFO Nov 19 12:18:23 [4144125760]: (listen_callback): New connection from [ IP_MASKED ]
- INFO Nov 19 12:18:23 [4144125760]: (CA_add_conn): Successfully added IP [ IP_MASKED ]
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_add_conn): Created new conn 0x830d958 generation 13
- DEBUG Nov 19 12:18:23 [4144125760]: (listen_callback): conn 0x830d958 generation 13, ssl 0x830dfb8 created
- INFO Nov 19 12:18:23 [4144125760]: (register_epoll): Successfully registered epoll for fd 26, ep_data 0x82f56b8
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Read 6 bytes on fd 26
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): SSL read: xxx2xx
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Processing command: xxx2xx
- INFO Nov 19 12:18:23 [4144125760]: (process_command): Number of received TLVs: 1
- MESSAGE Nov 19 12:18:23 [4144125760]: (process_command): Client type is OS X
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): No AA_MESS_DEVICE_ID TLV found in chain
- DEBUG Nov 19 12:18:23 [4144125760]: (send_data): SSL write: xxxxx
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Read 1 bytes on fd 26
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): SSL read: x
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Buffered: x
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Read 24 bytes on fd 26
- INFO Nov 19 12:18:23 [4144125760]: (process_command): Number of received TLVs: 2
- DEBUG Nov 19 12:18:23 [4144125760]: (process_command): Allocated user 0x830d010 username [ USERNAME_MASKED ]
- DEBUG Nov 19 12:18:23 [4144125760]: (lc_utf8_bytes): lowercase = '[ USERNAME_MASKED ]'
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_authenticate_user): Request data prepared for user [ USERNAME_MASKED ]
- INFO Nov 19 12:18:23 [4144125760]: (print_req_data): username:[ USERNAME_MASKED ]
- INFO Nov 19 12:18:23 [4144125760]: (print_req_data): password:xx...x
- INFO Nov 19 12:18:23 [4144125760]: (print_req_data): macaddress:
- INFO Nov 19 12:18:23 [4144125760]: (print_req_data): ipaddress:[ IP_MASKED ]
- INFO Nov 19 12:18:23 [4144125760]: (print_req_data): domainname:
- INFO Nov 19 12:18:23 [4144125760]: (print_req_data): clienttype:1
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=3
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
- DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=3 handler_data=0x831ffb8 res_handler=0x807850b
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x8133e14
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_BYIP
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_BYIP, [ IP_MASKED ]) succeeded
- INFO Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byip): GET_LIVEUSER_BYIP found no entries (sqrs 101)
- DEBUG Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byip): returning 0
- DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x807850b
- DEBUG Nov 19 12:18:23 [4144125760]: authenticate: SQLITE_REQ_GETLIVEUSER_BYIP Successful
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=34
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
- DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=34 handler_data=0x831ffb8 res_handler=0x80782ab
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): AUTHENTICATE_GUEST_USER triggers alloc_query_vals()
- DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'AUTHENTICATE_GUEST_USER'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0]: '[ USERNAME_MASKED ]'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'AUTHENTICATE_GUEST_USER'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_authenticate_guest_user: row count: 1
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_authenticate_guest_user: column:'usertype', value:'5'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_authenticate_guest_user: Not a Guest user
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x80782ab
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x82e91c8
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x82e91c8
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): OTP_AUTH: request submitted, req_type=0
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82e91c8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82e91c8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x82e91c8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x82e91c8
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=15 wq=0x82efb68 buf=0x82efb70 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4134529856]: subsys_thread_main: OTP_AUTH: event received on fd: 16
- DEBUG Nov 19 12:18:23 [4134529856]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: READING... fd=16
- INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: read 16 bytes, fd=16
- DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_read): server tlv=0x82e8d50 req_handler=0x80caa45 type=0 handler_data=0x831ffb8 res_handler=0x8077939
- DEBUG Nov 19 12:18:23 [4134529856]: (otp_handle_prepare_authentication_request): OTP prepare authentication for user [ USERNAME_MASKED ]
- DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): acquiring lock 0x82e91ec
- DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4134529856]: (append_subsysqueue): released lock 0x82e91ec
- INFO Nov 19 12:18:23 [4134529856]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4134529856]: subsys_submit_response: OTP_AUTH: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): acquiring lock 0x82e91ec
- DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): released lock 0x82e91ec
- DEBUG Nov 19 12:18:23 [4134529856]: (write_subsysqueue): acquiring lock 0x82e91ec
- DEBUG Nov 19 12:18:23 [4134529856]: (write_subsysqueue): released lock 0x82e91ec
- INFO Nov 19 12:18:23 [4134529856]: (write_subsysqueue): SERVER: written 16 bytes, fd=16 wq=0x82e8df8 buf=0x82e8e00 offset=0
- INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: READING... fd=16
- INFO Nov 19 12:18:23 [4134529856]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): acquiring lock 0x82e91ec
- DEBUG Nov 19 12:18:23 [4134529856]: (do_handle_write): released lock 0x82e91ec
- INFO Nov 19 12:18:23 [4134529856]: subsys_thread_main: OTP_AUTH: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=15
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=15
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82e8eb0 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8077939
- DEBUG Nov 19 12:18:23 [4144125760]: (authenticate_user): current server:0, auth_client:0
- INFO Nov 19 12:18:23 [4144125760]: authenticate_user: Server:0, Local Authentication
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=35
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=15
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82e91c8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82e91c8
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
- DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=35 handler_data=0x831ffb8 res_handler=0x8077939
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): AUTHENTICATE_USER triggers alloc_query_vals()
- DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'AUTHENTICATE_USER'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0] length=4: 1
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[1] length=4: 5
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[2] length=4: 2
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[3] length=4: 1
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[4]: '[ USERNAME_MASKED ]'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'AUTHENTICATE_USER'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_authenticate_user): row count: 1
- DEBUG Nov 19 12:18:23 [4141873984]: (de_obfuscate): 1c2c236cb0b86122255da65c18deac714217 decoded, password not empty
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8077939
- DEBUG Nov 19 12:18:23 [4144125760]: (authenticate_user): current server:1, auth_client:0
- DEBUG Nov 19 12:18:23 [4144125760]: authenticate_user: SUCCESS || current_server >= MAX_LIMIT
- DEBUG Nov 19 12:18:23 [4144125760]: (is_local_auth): current_server = 0, auth_client = 0, authserver_id = 1, local_authserver_id = 1
- DEBUG Nov 19 12:18:23 [4144125760]: (check_auth_result): ==> local user
- DEBUG Nov 19 12:18:23 [4144125760]: check_auth_result: Authentication Successful, clienttype=1 auth_client=0
- DEBUG Nov 19 12:18:23 [4144125760]: (delete_admin_access_entry): invoked
- DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff430c8 for query 0x8133e28
- DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Query name IS_ADMIN_IP_EXIST
- DEBUG Nov 19 12:18:23 [4144125760]: (check_sqlite_bind_text_result): sqlite3_bind_text(IS_ADMIN_IP_EXIST, [ IP_MASKED ]) succeeded
- DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): IS_ADMIN_IP_EXIST retrieved: count = 0
- DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): returning 0
- DEBUG Nov 19 12:18:23 [4144125760]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_add_conn_to_user): Allocated user 0x831efb0 username 0x830d010 ([ USERNAME_MASKED ])
- INFO Nov 19 12:18:23 [4144125760]: (CA_add_conn_to_user): Created new user [ USERNAME_MASKED ]
- MESSAGE Nov 19 12:18:23 [4144125760]: (CA_authentication_result): User [ USERNAME_MASKED ] authenticated (CA)
- DEBUG Nov 19 12:18:23 [4144125760]: (send_data): SSL write: xxxxx
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=0
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
- DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=0 handler_data=0x831ffb8 res_handler=0x8072b72
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): GET_USERINFO triggers alloc_query_vals()
- DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'GET_USERINFO'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0]: '[ USERNAME_MASKED ]'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[1] length=4: 1
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[2] length=4: 2
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[3] length=4: 5
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[4] length=4: 8
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'GET_USERINFO'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: row count: 1
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_get_userinfo): pg_server 0x8261160
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_get_userinfo): building userinfo: integration=0 req_data.groupname='NULL'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'userid', value:'10'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'groupid', value:'9'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'username', value:'[ USERNAME_MASKED ]'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'name', value:'[ USERNAME_MASKED ]'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'emailid', value:'[ EMAIL_MASKED ]'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'name', value:'adults'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'active', value:'Y'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'usertype', value:'5'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'webfilterid', value:'1'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'appfilterid', value:'1'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'accesspolicyid', value:'1'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'bwpolicyid', value:''
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'surfingquotapolicyid', value:'1'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'datatransferpolicyid', value:''
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'ipallocation', value:'4'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'allotedminutes', value:'-11'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'usedminutes', value:'1008'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'cycleusedminutes', value:'1008'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'uploaddata', value:'46881108'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'downloaddata', value:'1016019810'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'lastusedtime', value:'2017-11-19 12:16:28'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'cycleupload', value:'46881108'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'cycledownload', value:'1016019810'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'maxloginallowed', value:'-1'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'renewdate', value:'2017-11-18'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'macbinding', value:'1'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_get_userinfo: column:'ipallocation', value:'1'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8072b72
- DEBUG Nov 19 12:18:23 [4144125760]: do_authorization: Got User Info Successfully
- DEBUG Nov 19 12:18:23 [4144125760]: is_currently_allowed: accesspolicy:1
- DEBUG Nov 19 12:18:23 [4144125760]: is_currently_allowed: currday:1, hour:12, min:18, currtime:738
- INFO Nov 19 12:18:23 [4144125760]: is_currently_allowed: POLICY MATCH. Strategy:'Y'
- DEBUG Nov 19 12:18:23 [4144125760]: has_surfing_time: effective_alloted_min:-11, effective_used_min:1008
- DEBUG Nov 19 12:18:23 [4144125760]: has_surfing_time: YES
- INFO Nov 19 12:18:23 [4144125760]: match_surfing_quota: SQuota policy id:1, cycle:80
- DEBUG Nov 19 12:18:23 [4144125760]: check_mac_binding: Going to insert USERID-MAC values,10:''
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): POSTGRES_DB: request submitted, req_type=2
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x826d1b8
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=8 wq=0x827a5a0 buf=0x827a5a8 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: event received on fd: 9
- DEBUG Nov 19 12:18:23 [4141873984]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read 16 bytes, fd=9
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_read): server tlv=0x827a398 req_handler=0x8095f19 type=2 handler_data=0x831ffb8 res_handler=0x80709d6
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_handle_request): IS_MAC_BINDING_PRESENT triggers alloc_query_vals()
- DEBUG Nov 19 12:18:23 [4141873984]: (alloc_query_vals): using query_vals on stack 0xf6dfe8dc
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): executing command 'IS_MAC_BINDING_PRESENT'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): PG's socket (fd 6) is NON-blocking
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_process_prepq_async): param_value[0] length=4: 10
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): retrieving PGresult of 'IS_MAC_BINDING_PRESENT'
- DEBUG Nov 19 12:18:23 [4141873984]: (pg_db_get_async_prepq_result): returning PGresult 1 (0xf6800e68)
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_check_mac_ip_binding: row count: 1
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_handle_check_mac_ip_binding: column:'count', value:'0'
- DEBUG Nov 19 12:18:23 [4141873984]: pg_db_submit_response: Request Processed: res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4141873984]: (append_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4141873984]: subsys_submit_response: POSTGRES_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (write_subsysqueue): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: (write_subsysqueue): SERVER: written 16 bytes, fd=9 wq=0x827a440 buf=0x827a448 offset=0
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: READING... fd=9
- INFO Nov 19 12:18:23 [4141873984]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): acquiring lock 0x826d1dc
- DEBUG Nov 19 12:18:23 [4141873984]: (do_handle_write): released lock 0x826d1dc
- INFO Nov 19 12:18:23 [4141873984]: subsys_thread_main: POSTGRES_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x827a4f8 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x80709d6
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=2
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=8
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x826d1b8
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
- DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=2 handler_data=0x831ffb8 res_handler=0x80708bd
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 1 parameters 0xf6cfd888 for query 0x8133e00
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name GET_LIVEUSER_BYNAME
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_BYNAME, [ USERNAME_MASKED ]) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byname): GET_LIVEUSER_BYNAME retrieved: login_count=0
- DEBUG Nov 19 12:18:23 [4140821312]: (_sqlite_db_handle_liveuser_byname): returning 0
- DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x80708bd
- INFO Nov 19 12:18:23 [4144125760]: do_authorization_phase2: UNL and FREE_IP
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: LAST-UID: 2 BYTE-ID: 0
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BYTE-ID: 0
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BYTE[0]: 0x1
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: free bits found at BYTE-ID: 0
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BIT[0] is not free
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: BIT[1] is free
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: Before SET_BIT[1] BYTE[0]: 0x1
- DEBUG Nov 19 12:18:23 [4144125760]: uid_allocate: After SET_BIT[1] BYTE[0]: 0x3
- INFO Nov 19 12:18:23 [4144125760]: uid_allocate: allocated UID: 1
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
- DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=8 handler_data=0x831ffb8 res_handler=0x8072f25
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 23 parameters 0xf6cfd888 for query 0x8134120
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name INSERT_LIVEUSER
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 10) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ USERNAME_MASKED ]) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ USERNAME_MASKED ]) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ USERNAME_MASKED ]) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, [ IP_MASKED ]) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 9) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 240693) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 240693) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, 2017-11-18) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 2) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_text_result): sqlite3_bind_text(INSERT_LIVEUSER, ) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER, 0) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8072f25
- INFO Nov 19 12:18:23 [4144125760]: handle_liveuser_insert: LIVE USER '[ USERNAME_MASKED ]' INSERTED
- DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff43118 for query 0x8133e3c
- DEBUG Nov 19 12:18:23 [4144125760]: (bind_parameters_to_statement): Query name ISUSEREXISTS_LIVEUSER_ACC
- DEBUG Nov 19 12:18:23 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(ISUSEREXISTS_LIVEUSER_ACC, 10) succeeded
- DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): ISUSEREXISTS_LIVEUSER_ACC retrieved: count = 0
- DEBUG Nov 19 12:18:23 [4144125760]: (handle_count_star_query): returning 0
- DEBUG Nov 19 12:18:23 [4144125760]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:18:23 [4144125760]: (handle_liveuser_insert): INSERTING in LIVEUSER_ACC
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): SQLITE_DB: request submitted, req_type=9
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x828fe00
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=10 wq=0x82d1738 buf=0x82d1740 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: event received on fd: 11
- DEBUG Nov 19 12:18:23 [4140821312]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read 16 bytes, fd=11
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_read): server tlv=0x828fe70 req_handler=0x80a1949 type=9 handler_data=0x831ffb8 res_handler=0x8072e78
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Binding 8 parameters 0xf6cfd888 for query 0x81341d4
- DEBUG Nov 19 12:18:23 [4140821312]: (bind_parameters_to_statement): Query name INSERT_LIVEUSER_ACC
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 10) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1511122703) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1008) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_int_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1008) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 46881108) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1016019810) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 46881108) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (check_sqlite_bind_ulong_result): sqlite3_bind_int(INSERT_LIVEUSER_ACC, 1016019810) succeeded
- DEBUG Nov 19 12:18:23 [4140821312]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4140821312]: (append_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4140821312]: subsys_submit_response: SQLITE_DB: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (write_subsysqueue): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: (write_subsysqueue): SERVER: written 16 bytes, fd=11 wq=0x828ff18 buf=0x828ff20 offset=0
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: READING... fd=11
- INFO Nov 19 12:18:23 [4140821312]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): acquiring lock 0x828fe24
- DEBUG Nov 19 12:18:23 [4140821312]: (do_handle_write): released lock 0x828fe24
- INFO Nov 19 12:18:23 [4140821312]: subsys_thread_main: SQLITE_DB: waiting for events...
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=10
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82d1690 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8072e78
- DEBUG Nov 19 12:18:23 [4144125760]: (login_user): no accounting_server configured
- 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
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): acquiring lock 0x82effb8
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:18:23 [4144125760]: (append_subsysqueue): released lock 0x82effb8
- INFO Nov 19 12:18:23 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4144125760]: (subsys_submit_request): OPCODE: request submitted, req_type=0
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82effb8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82effb8
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): acquiring lock 0x82effb8
- DEBUG Nov 19 12:18:23 [4133477184]: subsys_thread_main: OPCODE: event received on fd: 18
- DEBUG Nov 19 12:18:23 [4133477184]: handle_server_events: EVENT_READ
- INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: READING... fd=18
- INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: read 16 bytes, fd=18
- DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_read): server tlv=0x82f0038 req_handler=0x80b89ad type=0 handler_data=0x831ffb8 res_handler=0x8078e4e
- ERROR Nov 19 12:18:23 [4133477184]: config_resolve_bwid: BW Policy 0 not found
- 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" }'
- DEBUG Nov 19 12:18:23 [4144125760]: (write_subsysqueue): released lock 0x82effb8
- INFO Nov 19 12:18:23 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=17 wq=0x82f4428 buf=0x82f4430 offset=0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=10
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x828fe00
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- INFO Nov 19 12:18:23 [4133477184]: (opcode_handle_login): OPCODE: OPCODE executed successfully
- DEBUG Nov 19 12:18:23 [4133477184]: (bind_parameters_to_statement): Binding 3 parameters 0xf65fc88c for query 0x8134314
- DEBUG Nov 19 12:18:23 [4133477184]: (bind_parameters_to_statement): Query name GET_LIVEUSERCNT_BYIP_UID_ID
- DEBUG Nov 19 12:18:23 [4133477184]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSERCNT_BYIP_UID_ID, 1) succeeded
- DEBUG Nov 19 12:18:23 [4133477184]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSERCNT_BYIP_UID_ID, 10) succeeded
- DEBUG Nov 19 12:18:23 [4133477184]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSERCNT_BYIP_UID_ID, [ IP_MASKED ]) succeeded
- DEBUG Nov 19 12:18:23 [4133477184]: (handle_count_star_query): GET_LIVEUSERCNT_BYIP_UID_ID retrieved: count = 1
- DEBUG Nov 19 12:18:23 [4133477184]: (handle_count_star_query): returning 1
- DEBUG Nov 19 12:18:23 [4133477184]: (sqlite_db_submit_response): Request processed res=1
- DEBUG Nov 19 12:18:23 [4133477184]: (exists_live_user): 1 live user {luid 1, uid 10, ip [ IP_MASKED ]}
- DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): : SERVER, datasize: 16
- DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): acquiring lock 0x82effdc
- DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): : SERVER, remlen: 160
- DEBUG Nov 19 12:18:23 [4133477184]: (append_subsysqueue): released lock 0x82effdc
- INFO Nov 19 12:18:23 [4133477184]: (append_subsysqueue): SERVER: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:18:23 [4133477184]: subsys_submit_response: OPCODE: response submitted, res_type=0
- DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): acquiring lock 0x82effdc
- DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): released lock 0x82effdc
- DEBUG Nov 19 12:18:23 [4133477184]: (write_subsysqueue): acquiring lock 0x82effdc
- DEBUG Nov 19 12:18:23 [4133477184]: (write_subsysqueue): released lock 0x82effdc
- INFO Nov 19 12:18:23 [4133477184]: (write_subsysqueue): SERVER: written 16 bytes, fd=18 wq=0x82f00e0 buf=0x82f00e8 offset=0
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): returning 1
- INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: READING... fd=18
- DEBUG Nov 19 12:18:23 [4144125760]: handle_client_events: EVENT_READ
- INFO Nov 19 12:18:23 [4133477184]: (do_handle_read): server: read blocked
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=17
- DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): acquiring lock 0x82effdc
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read 16 bytes, fd=17
- DEBUG Nov 19 12:18:23 [4133477184]: (do_handle_write): released lock 0x82effdc
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_read): client tlv=0x82f4380 req_handler=(nil) type=0 handler_data=0x831ffb8 res_handler=0x8078e4e
- INFO Nov 19 12:18:23 [4133477184]: subsys_thread_main: OPCODE: waiting for events...
- INFO Nov 19 12:18:23 [4144125760]: create_response: AUTHENTICATION SUCCESSFULL
- DEBUG Nov 19 12:18:23 [4144125760]: is_incr: 1
- DEBUG Nov 19 12:18:23 [4144125760]: get_effective_time: 1008
- DEBUG Nov 19 12:18:23 [4144125760]: (send_response): Error sending data: Invalid argument
- INFO Nov 19 12:18:23 [4144125760]: create_response: RESULT String: inc:1008:You have successfully logged in:no
- DEBUG Nov 19 12:18:23 [4144125760]: free_session_data: session_data=0x831ffb8
- DEBUG Nov 19 12:18:23 [4144125760]: (reset_user_info): resetting user_info 0xf68021d0
- DEBUG Nov 19 12:18:23 [4144125760]: (free_session_data): freeing user_info 0xf68021d0
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: READING... fd=17
- INFO Nov 19 12:18:23 [4144125760]: (do_handle_read): client: read blocked
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): acquiring lock 0x82effb8
- DEBUG Nov 19 12:18:23 [4144125760]: (do_handle_write): released lock 0x82effb8
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_keep_alive): called too soon, seconds = 44, returning
- DEBUG Nov 19 12:18:23 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:23 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=2000
- DEBUG Nov 19 12:18:25 [4144125760]: (CA_epoll_wait): returning 0
- DEBUG Nov 19 12:18:25 [4144125760]: (CA_keep_alive): Checking connections status
- MESSAGE Nov 19 12:18:25 [4144125760]: (CA_keep_alive): Sending PING to [ USERNAME_MASKED ]
- DEBUG Nov 19 12:18:25 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:18:25 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
- DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_handle_request: tlv request received
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV ID: 140
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Type: 0
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Length: 0
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
- DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_process_request: GOT ALERT.EXECUTE_HEARTBEAT
- DEBUG Nov 19 12:19:00 [4144125760]: (CA_keep_alive): called too soon, seconds = 35, returning
- DEBUG Nov 19 12:19:00 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=10000
- DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): returning 1
- DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_handle_request: tlv request received
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV ID: 148
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Type: 0
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Length: 0
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: TLV Cl Res: 0
- INFO Nov 19 12:19:00 [4144125760]: tlvserver_print_request: ---------------------------------
- DEBUG Nov 19 12:19:00 [4144125760]: tlvserver_process_request: GOT ALERT.EDIR_SYNC
- 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)
- DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): : CLIENT, datasize: 16
- DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): acquiring lock 0x83055b8
- DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): : CLIENT, remlen: 160
- DEBUG Nov 19 12:19:00 [4144125760]: (append_subsysqueue): released lock 0x83055b8
- INFO Nov 19 12:19:00 [4144125760]: (append_subsysqueue): CLIENT: '16' bytes appended to subsys queue
- DEBUG Nov 19 12:19:00 [4144125760]: (subsys_submit_request): EDIR_SYNC: request submitted, req_type=0
- DEBUG Nov 19 12:19:00 [4144125760]: (do_handle_write): acquiring lock 0x83055b8
- DEBUG Nov 19 12:19:00 [4144125760]: (do_handle_write): released lock 0x83055b8
- DEBUG Nov 19 12:19:00 [4144125760]: (write_subsysqueue): acquiring lock 0x83055b8
- DEBUG Nov 19 12:19:00 [4144125760]: (write_subsysqueue): released lock 0x83055b8
- INFO Nov 19 12:19:00 [4144125760]: (write_subsysqueue): CLIENT: written 16 bytes, fd=23 wq=0x8307a80 buf=0x8307a88 offset=0
- DEBUG Nov 19 12:19:00 [4144125760]: (CA_keep_alive): called too soon, seconds = 35, returning
- DEBUG Nov 19 12:19:00 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:19:00 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=10000
- DEBUG Nov 19 12:19:00 [4132424512]: subsys_thread_main: EDIR_SYNC: event received on fd: 24
- DEBUG Nov 19 12:19:00 [4132424512]: handle_server_events: EVENT_READ
- INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: READING... fd=24
- INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: read 16 bytes, fd=24
- DEBUG Nov 19 12:19:00 [4132424512]: (do_handle_read): server tlv=0x8305628 req_handler=0x80b5b92 type=0 handler_data=(nil) res_handler=(nil)
- INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: READING... fd=24
- INFO Nov 19 12:19:00 [4132424512]: (do_handle_read): server: read blocked
- DEBUG Nov 19 12:19:00 [4132424512]: (do_handle_write): acquiring lock 0x83055dc
- DEBUG Nov 19 12:19:00 [4132424512]: (do_handle_write): released lock 0x83055dc
- INFO Nov 19 12:19:00 [4132424512]: subsys_thread_main: EDIR_SYNC: waiting for events...
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_epoll_wait): returning 0
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_keep_alive): Checking connections status
- ERROR Nov 19 12:19:10 [4144125760]: (CA_keep_alive): Timeout for [ USERNAME_MASKED ], will drop connection
- MESSAGE Nov 19 12:19:10 [4144125760]: (CA_disconnect_user): Will disconnect user [ USERNAME_MASKED ]
- DEBUG Nov 19 12:19:10 [4144125760]: (new_livereq_data): _livereq_data=0x831c798
- DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Binding 2 parameters 0xfff42da8 for query 0x81340f8
- DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Query name GET_LIVEUSER_INFO_TO_LOGOUT
- DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_text_result): sqlite3_bind_text(GET_LIVEUSER_INFO_TO_LOGOUT, [ IP_MASKED ]) succeeded
- DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_INFO_TO_LOGOUT, 5) succeeded
- DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Live username len 9
- DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Live name len 9
- ERROR Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): Missing message!
- 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
- DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_get_liveuserinfo): returning 0
- DEBUG Nov 19 12:19:10 [4144125760]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:19:10 [4144125760]: (send_response): Error sending data: Invalid argument
- DEBUG Nov 19 12:19:10 [4144125760]: (handle_external_logout_req_finish_free): SQLITE_REQ_GETLIVEUSERINFO successful
- DEBUG Nov 19 12:19:10 [4144125760]: (update_lastlivetime): update_lastlivetime: now:240739, used_min:1008, cycleused_min:1008, lastlivetime:240693, diffmin:0.766667
- DEBUG Nov 19 12:19:10 [4144125760]: (update_lastlivetime): diffmin : 1.266667
- DEBUG Nov 19 12:19:10 [4144125760]: (update_lastlivetime): livereq used_minutes : 1009
- DEBUG Nov 19 12:19:10 [4144125760]: update_lastlivetime: Executing command '/sbin/ipsetelite -L users liveuserid=1 -c'
- DEBUG Nov 19 12:19:10 [4144125760]: update_lastlivetime: Command Output: '1,221186,4680716
- '
- 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
- DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff42b78 for query 0x8134030
- DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Query name GET_LIVEUSER_SESSION_DATA
- DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(GET_LIVEUSER_SESSION_DATA, 1) succeeded
- DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_live_session_data): GET_LIVEUSER_SESSION_DATA retrieved: upload=0 download=0
- DEBUG Nov 19 12:19:10 [4144125760]: (_sqlite_db_handle_live_session_data): returning 0
- DEBUG Nov 19 12:19:10 [4144125760]: (sqlite_db_submit_response): Request processed res=0
- DEBUG Nov 19 12:19:10 [4144125760]: new_cycleupload:47102294, new_cycledownload:1020700526
- DEBUG Nov 19 12:19:10 [4144125760]: fill_logout_garner_data: UPLOAD:221186,DOWNLOAD:4680716,starttime:1511122703, Groupid:9, MAC:'', NAME:'[ USERNAME_MASKED ]'
- 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"] }'
- INFO Nov 19 12:19:10 [4144125760]: execute_update_tbluseraccounting: OPCODE: OPCODE executed successfully
- DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Binding 1 parameters 0xfff42d68 for query 0x813415c
- DEBUG Nov 19 12:19:10 [4144125760]: (bind_parameters_to_statement): Query name REMOVE_LIVEUSER
- DEBUG Nov 19 12:19:10 [4144125760]: (check_sqlite_bind_int_result): sqlite3_bind_int(REMOVE_LIVEUSER, 1) succeeded
- DEBUG Nov 19 12:19:10 [4144125760]: (sqlite_db_submit_response): Request processed res=0
- ERROR Nov 19 12:19:10 [4144125760]: config_resolve_bwid: BW Policy 0 not found
- DEBUG Nov 19 12:19:10 [4144125760]: (opcode_handle_logout): clienttype 1, JASON: { "userid":"[ USERNAME_MASKED ]","liveuserid":"1","bwpolicyid":"","ipaddress":"[ IP_MASKED ]","setname":"lusers", }
- INFO Nov 19 12:19:10 [4144125760]: opcode_handle_logout: OPCODE: OPCODE executed successfully
- DEBUG Nov 19 12:19:10 [4144125760]: uid_release: BYTE-ID: 0
- DEBUG Nov 19 12:19:10 [4144125760]: uid_release: BIT-ID: 1
- DEBUG Nov 19 12:19:10 [4144125760]: uid_release: Before CLEAR_BIT[1] BYTE[0]: 0x3
- DEBUG Nov 19 12:19:10 [4144125760]: uid_release: Before CLEAR_BIT[1] BYTE[0]: 0x1
- INFO Nov 19 12:19:10 [4144125760]: uid_release: UID 1 released
- DEBUG Nov 19 12:19:10 [4144125760]: (free_livereq_data): _livereq_data=0x831c798
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_remove_conn): Will remove connection 0x830d958 with fd 26 for user [ USERNAME_MASKED ]
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ===============================================================
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): fd: 26, authenticated: 1, secured: 1, alive: 0
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): username: [ USERNAME_MASKED ]
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ip_address_string: [ IP_MASKED ]
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): type: 2
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): APNDeviceID: (null)
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): login_time: 1511122703
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ssl: 0x830dfb8
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): cmd_buffer: (null), cmd_buffer_size: 0
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ip_list: 0x831e940, num_ip: 1
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ip6_list: (nil), num_ip6: 0
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): mac_list: (nil), num_mac: 0
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): next: (nil)
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_dump_conn): ===============================================================
- INFO Nov 19 12:19:10 [4144125760]: (CA_remove_conn_for_user): User [ USERNAME_MASKED ] has no connections left, removing the user
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_remove_conn_for_user): Releasing user 0x831efb0 username 0x830d010
- DEBUG Nov 19 12:19:10 [4144125760]: (deregister_conn_epoll): releasing ep_data 0x82f56b8
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_close_connection): conn 0x830d958 generation 13, freeing ssl 0x830dfb8
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_remove_conn): Releasing conn 0x830d958 generation 13
- DEBUG Nov 19 12:19:10 [4144125760]: (do_epoll): Waiting for events
- DEBUG Nov 19 12:19:10 [4144125760]: (CA_epoll_wait): timeout=45000, time_to_keep_alive=45000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement