Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@xmpp:/mnt# sudo tail -f /var/log/ejabberd/ejabberd.log
- 2017-12-13 22:47:20.605 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9250>) Ac cepted connection ::FFFF:192.168.88.231:58942 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:47:20.606 [info] <0.2271.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9250>,#Port<0.9251>}}
- 2017-12-13 22:48:20.622 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9252>) Ac cepted connection ::FFFF:192.168.88.231:58952 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:48:20.623 [info] <0.2272.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9252>,#Port<0.9253>}}
- 2017-12-13 22:48:21.606 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9254>) Ac cepted connection ::FFFF:192.168.88.231:58954 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:48:21.607 [info] <0.2273.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9254>,#Port<0.9255>}}
- 2017-12-13 22:49:21.629 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9256>) Ac cepted connection ::FFFF:192.168.88.231:58972 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:49:21.629 [info] <0.2276.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9256>,#Port<0.9257>}}
- 2017-12-13 22:49:22.604 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9258>) Ac cepted connection ::FFFF:192.168.88.231:58974 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:49:22.605 [info] <0.2277.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9258>,#Port<0.9259>}}
- 2017-12-13 22:50:22.625 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9260>) Ac cepted connection ::FFFF:192.168.88.231:58988 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:50:22.626 [info] <0.2278.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9260>,#Port<0.9261>}}
- 2017-12-13 22:50:23.599 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9262>) Ac cepted connection ::FFFF:192.168.88.231:58990 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:50:23.599 [info] <0.2279.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9262>,#Port<0.9263>}}
- 2017-12-13 22:50:56.924 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9264>) Ac cepted connection ::FFFF:192.168.88.231:59814 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:50:56.924 [info] <0.2280.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9264>,#Port<0.9265>}}
- 2017-12-13 22:50:59.402 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9266>) Ac cepted connection ::FFFF:192.168.88.231:59824 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:50:59.402 [info] <0.2281.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9266>,#Port<0.9267>}}
- 2017-12-13 22:51:04.522 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9268>) Ac cepted connection ::FFFF:192.168.88.231:59872 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:04.523 [info] <0.2282.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9268>,#Port<0.9269>}}
- 2017-12-13 22:51:04.737 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9270>) Ac cepted connection ::FFFF:192.168.88.231:59874 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:04.738 [info] <0.2285.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9270>,#Port<0.9271>}}
- 2017-12-13 22:51:04.753 [info] <0.2284.0>@ejabberd_c2s:wait_for_feature_request:740 ({so cket_state,ejabberd_http_bind,{http_bind,<0.2283.0>,{{0,0,0,0,0,65535,49320,22759},59872 }},ejabberd_http_bind}) Accepted authentication for yaroslav by ejabberd_auth_ldap from ::FFFF:192.168.88.231
- 2017-12-13 22:51:04.963 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9272>) Ac cepted connection ::FFFF:192.168.88.231:59876 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:04.964 [info] <0.2286.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9272>,#Port<0.9273>}}
- 2017-12-13 22:51:05.188 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9274>) Ac cepted connection ::FFFF:192.168.88.231:59878 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:05.189 [info] <0.2287.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9274>,#Port<0.9275>}}
- 2017-12-13 22:51:05.405 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9276>) Ac cepted connection ::FFFF:192.168.88.231:59880 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:05.406 [info] <0.2288.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9276>,#Port<0.9277>}}
- 2017-12-13 22:51:05.410 [info] <0.2284.0>@ejabberd_c2s:wait_for_session:1106 ({socket_st ate,ejabberd_http_bind,{http_bind,<0.2283.0>,{{0,0,0,0,0,65535,49320,22759},59872}},ejab berd_http_bind}) Opened session for yaroslav@xmpp.home.lan/10499527738846045561744531522 241648609217774078643043824288
- 2017-12-13 22:51:07.862 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9278>) Ac cepted connection ::FFFF:192.168.88.231:60286 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:07.862 [info] <0.2289.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9278>,#Port<0.9279>}}
- 2017-12-13 22:51:07.865 [info] <0.394.0>@mod_carboncopy:iq_handler:110 carbons enabled f or user yaroslav@xmpp.home.lan/104995277388460455617445315222416486092177740786430438242 88
- 2017-12-13 22:51:07.992 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9280>) Ac cepted connection ::FFFF:192.168.88.231:60288 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:07.992 [info] <0.2290.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9280>,#Port<0.9281>}}
- 2017-12-13 22:51:08.096 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9282>) Ac cepted connection ::FFFF:192.168.88.231:60290 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:08.097 [info] <0.2293.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9282>,#Port<0.9283>}}
- 2017-12-13 22:51:08.219 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9284>) Ac cepted connection ::FFFF:192.168.88.231:60292 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:08.220 [info] <0.2294.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9284>,#Port<0.9285>}}
- 2017-12-13 22:51:08.427 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9286>) Ac cepted connection ::FFFF:192.168.88.231:60294 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:08.427 [info] <0.2295.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9286>,#Port<0.9287>}}
- 2017-12-13 22:51:38.008 [info] <0.463.0>@ejabberd_http_bind:handle_info:507 Session time out. Closing the HTTP bind session: <<"dc509652b7d48aba6d078f232fcae87a5713387f">>
- 2017-12-13 22:51:38.008 [info] <0.464.0>@ejabberd_c2s:terminate:1788 ({socket_state,ejab berd_http_bind,{http_bind,<0.463.0>,{{0,0,0,0,0,65535,49320,22759},54588}},ejabberd_http _bind}) Close session for yaroslav@xmpp.home.lan/308087979000582422326653675581296080029 240926787435451919
- 2017-12-13 22:51:38.086 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9288>) Ac cepted connection ::FFFF:192.168.88.231:60304 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:38.087 [info] <0.2297.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9288>,#Port<0.9289>}}
- 2017-12-13 22:51:56.733 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9290>) Ac cepted connection ::FFFF:192.168.88.231:60354 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:51:56.734 [info] <0.2298.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9290>,#Port<0.9291>}}
- 2017-12-13 22:51:56.767 [error] <0.354.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( yaroslav, null, rick@xmpp.home.lan, , N, N, , N, , item, 2017-12-13 22:51:56.769744).">> },{115,<<"public">>},{116,<<"rosterusers">>},{99,<<"server_host">>},{file,<<"execMain.c" >>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{odbc_queries,upda te_roster,5,[{file,"src/odbc_queries.erl"},{line,373}]},{mod_roster,'-process_item_set/4 -fun-0-',7,[{file,"src/mod_roster.erl"},{line,526}]},{ejabberd_odbc,outer_transaction,3, [{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cmd,4,[{file,"src/ej abberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fsm.erl"},{line,582} ]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.374.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:51:56.782 [error] <0.354.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( yaroslav, null, rick@xmpp.home.lan, , N, O, , N, , item, 2017-12-13 22:51:56.784268).">> },{115,<<"public">>},{116,<<"rosterusers">>},{99,<<"server_host">>},{file,<<"execMain.c" >>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{mod_roster,'-proc ess_subscription/6-fun-0-',6,[{file,"src/mod_roster.erl"},{line,822}]},{ejabberd_odbc,ou ter_transaction,3,[{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cm d,4,[{file,"src/ejabberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fs m.erl"},{line,582}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.374.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:51:56.795 [error] <0.354.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( rick, null, yaroslav@xmpp.home.lan, , N, I, , N, , item, 2017-12-13 22:51:56.797471).">> },{115,<<"public">>},{116,<<"rosterusers">>},{99,<<"server_host">>},{file,<<"execMain.c" >>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{mod_roster,'-proc ess_subscription/6-fun-0-',6,[{file,"src/mod_roster.erl"},{line,822}]},{ejabberd_odbc,ou ter_transaction,3,[{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cm d,4,[{file,"src/ejabberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fs m.erl"},{line,582}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.374.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:52:28.852 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9292>) Ac cepted connection ::FFFF:192.168.88.231:60384 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:28.852 [info] <0.2300.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9292>,#Port<0.9293>}}
- 2017-12-13 22:52:29.091 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9294>) Ac cepted connection ::FFFF:192.168.88.231:60386 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:29.092 [info] <0.2303.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9294>,#Port<0.9295>}}
- 2017-12-13 22:52:29.099 [info] <0.2302.0>@ejabberd_c2s:wait_for_feature_request:740 ({so cket_state,ejabberd_http_bind,{http_bind,<0.2301.0>,{{0,0,0,0,0,65535,49320,22759},60384 }},ejabberd_http_bind}) Accepted authentication for rick by ejabberd_auth_ldap from ::FF FF:192.168.88.231
- 2017-12-13 22:52:29.305 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9296>) Ac cepted connection ::FFFF:192.168.88.231:60388 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:29.305 [info] <0.2304.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9296>,#Port<0.9297>}}
- 2017-12-13 22:52:29.539 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9298>) Ac cepted connection ::FFFF:192.168.88.231:60390 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:29.539 [info] <0.2305.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9298>,#Port<0.9299>}}
- 2017-12-13 22:52:29.755 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9300>) Ac cepted connection ::FFFF:192.168.88.231:60392 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:29.756 [info] <0.2306.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9300>,#Port<0.9301>}}
- 2017-12-13 22:52:29.760 [info] <0.2302.0>@ejabberd_c2s:wait_for_session:1106 ({socket_st ate,ejabberd_http_bind,{http_bind,<0.2301.0>,{{0,0,0,0,0,65535,49320,22759},60384}},ejab berd_http_bind}) Opened session for rick@xmpp.home.lan/797841341304899434510179055031758 29113312515456018214889704
- 2017-12-13 22:52:31.747 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9302>) Ac cepted connection ::FFFF:192.168.88.231:60466 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:31.748 [info] <0.2307.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9302>,#Port<0.9303>}}
- 2017-12-13 22:52:31.752 [info] <0.394.0>@mod_carboncopy:iq_handler:110 carbons enabled f or user rick@xmpp.home.lan/79784134130489943451017905503175829113312515456018214889704
- 2017-12-13 22:52:31.895 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9304>) Ac cepted connection ::FFFF:192.168.88.231:60468 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:31.896 [info] <0.2308.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9304>,#Port<0.9305>}}
- 2017-12-13 22:52:31.999 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9306>) Ac cepted connection ::FFFF:192.168.88.231:60470 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:31.999 [info] <0.2311.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9306>,#Port<0.9307>}}
- 2017-12-13 22:52:32.148 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9308>) Ac cepted connection ::FFFF:192.168.88.231:60472 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:32.148 [info] <0.2312.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9308>,#Port<0.9309>}}
- 2017-12-13 22:52:32.324 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9310>) Ac cepted connection ::FFFF:192.168.88.231:60474 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:32.325 [info] <0.2313.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9310>,#Port<0.9311>}}
- 2017-12-13 22:52:50.208 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9312>) Ac cepted connection ::FFFF:192.168.88.231:60562 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:50.208 [info] <0.2314.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9312>,#Port<0.9313>}}
- 2017-12-13 22:52:50.223 [error] <0.352.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( rick, null, f74d42de-68a9-1037-91ea-6f64c1a40810@xmpp.home.lan, yaroslav, N, N, , N, , i tem, 2017-12-13 22:52:50.225421).">>},{115,<<"public">>},{116,<<"rosterusers">>},{99,<<" server_host">>},{file,<<"execMain.c">>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{odbc_queries,upda te_roster,5,[{file,"src/odbc_queries.erl"},{line,373}]},{mod_roster,'-process_item_set/4 -fun-0-',7,[{file,"src/mod_roster.erl"},{line,526}]},{ejabberd_odbc,outer_transaction,3, [{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cmd,4,[{file,"src/ej abberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fsm.erl"},{line,582} ]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.372.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:52:50.235 [error] <0.352.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( rick, null, f74d42de-68a9-1037-91ea-6f64c1a40810@xmpp.home.lan, , N, O, , N, , item, 201 7-12-13 22:52:50.238166).">>},{115,<<"public">>},{116,<<"rosterusers">>},{99,<<"server_h ost">>},{file,<<"execMain.c">>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{mod_roster,'-proc ess_subscription/6-fun-0-',6,[{file,"src/mod_roster.erl"},{line,822}]},{ejabberd_odbc,ou ter_transaction,3,[{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cm d,4,[{file,"src/ejabberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fs m.erl"},{line,582}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.372.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:52:56.752 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9314>) Ac cepted connection ::FFFF:192.168.88.231:60564 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:56.753 [info] <0.2315.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9314>,#Port<0.9315>}}
- 2017-12-13 22:52:56.921 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9316>) Ac cepted connection ::FFFF:192.168.88.231:60566 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:52:56.921 [info] <0.2316.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9316>,#Port<0.9317>}}
- 2017-12-13 22:53:50.234 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9318>) Ac cepted connection ::FFFF:192.168.88.231:60592 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:53:50.235 [info] <0.2318.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9318>,#Port<0.9319>}}
- 2017-12-13 22:53:50.422 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9320>) Ac cepted connection ::FFFF:192.168.88.231:60594 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:53:50.423 [info] <0.2319.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9320>,#Port<0.9321>}}
- 2017-12-13 22:53:56.935 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9322>) Ac cepted connection ::FFFF:192.168.88.231:60596 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:53:56.935 [info] <0.2320.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9322>,#Port<0.9323>}}
- 2017-12-13 22:53:57.121 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9324>) Ac cepted connection ::FFFF:192.168.88.231:60598 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:53:57.121 [info] <0.2321.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9324>,#Port<0.9325>}}
- 2017-12-13 22:54:21.819 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9326>) Ac cepted connection ::FFFF:192.168.88.231:60818 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:21.819 [info] <0.2322.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9326>,#Port<0.9327>}}
- 2017-12-13 22:54:21.860 [error] <0.354.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( rick, null, yaroslav@xmpp.home.lan, yaroslav, N, N, , N, , item, 2017-12-13 22:54:21.861 786).">>},{115,<<"public">>},{116,<<"rosterusers">>},{99,<<"server_host">>},{file,<<"exe cMain.c">>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{odbc_queries,upda te_roster,5,[{file,"src/odbc_queries.erl"},{line,373}]},{mod_roster,'-process_item_set/4 -fun-0-',7,[{file,"src/mod_roster.erl"},{line,526}]},{ejabberd_odbc,outer_transaction,3, [{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cmd,4,[{file,"src/ej abberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fsm.erl"},{line,582} ]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.374.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:54:21.877 [error] <0.354.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( rick, null, yaroslav@xmpp.home.lan, , N, O, , N, , item, 2017-12-13 22:54:21.879609).">> },{115,<<"public">>},{116,<<"rosterusers">>},{99,<<"server_host">>},{file,<<"execMain.c" >>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{mod_roster,'-proc ess_subscription/6-fun-0-',6,[{file,"src/mod_roster.erl"},{line,822}]},{ejabberd_odbc,ou ter_transaction,3,[{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cm d,4,[{file,"src/ejabberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fs m.erl"},{line,582}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.374.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:54:21.894 [error] <0.354.0>@ejabberd_odbc:outer_transaction:452 SQL transa ction restarts exceeded
- ** Restarts: 10
- ** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in c olumn \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains ( yaroslav, null, rick@xmpp.home.lan, , N, I, , N, , item, 2017-12-13 22:54:21.896982).">> },{115,<<"public">>},{116,<<"rosterusers">>},{99,<<"server_host">>},{file,<<"execMain.c" >>},{line,1699},{routine,<<"ExecConstraints">>}]
- ** Stacktrace: [{ejabberd_odbc,sql_query_t,1,[{file,"src/ejabberd_odbc.erl"},{line,175}] },{odbc_queries,update_t,4,[{file,"src/odbc_queries.erl"},{line,84}]},{mod_roster,'-proc ess_subscription/6-fun-0-',6,[{file,"src/mod_roster.erl"},{line,822}]},{ejabberd_odbc,ou ter_transaction,3,[{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cm d,4,[{file,"src/ejabberd_odbc.erl"},{line,382}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fs m.erl"},{line,582}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]
- ** When State == {state,<0.374.0>,pgsql,30000,<<"xmpp.home.lan">>,1000,{0,{[],[]}}}
- 2017-12-13 22:54:40.558 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9328>) Ac cepted connection ::FFFF:192.168.88.231:32874 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:40.558 [info] <0.2323.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9328>,#Port<0.9329>}}
- 2017-12-13 22:54:48.492 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9330>) Ac cepted connection ::FFFF:192.168.88.231:32884 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:48.493 [info] <0.2324.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9330>,#Port<0.9331>}}
- 2017-12-13 22:54:50.336 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9332>) Ac cepted connection ::FFFF:192.168.88.231:32984 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:50.336 [info] <0.2325.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9332>,#Port<0.9333>}}
- 2017-12-13 22:54:58.734 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9334>) Ac cepted connection ::FFFF:192.168.88.231:33026 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:58.734 [info] <0.2326.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9334>,#Port<0.9335>}}
- 2017-12-13 22:54:58.943 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9336>) Ac cepted connection ::FFFF:192.168.88.231:33028 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:58.944 [info] <0.2329.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9336>,#Port<0.9337>}}
- 2017-12-13 22:54:58.947 [info] <0.2328.0>@ejabberd_c2s:wait_for_feature_request:740 ({so cket_state,ejabberd_http_bind,{http_bind,<0.2327.0>,{{0,0,0,0,0,65535,49320,22759},33026 }},ejabberd_http_bind}) Accepted authentication for yaroslav by ejabberd_auth_ldap from ::FFFF:192.168.88.231
- 2017-12-13 22:54:59.154 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9338>) Ac cepted connection ::FFFF:192.168.88.231:33030 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:59.154 [info] <0.2330.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9338>,#Port<0.9339>}}
- 2017-12-13 22:54:59.366 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9340>) Ac cepted connection ::FFFF:192.168.88.231:33032 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:59.367 [info] <0.2331.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9340>,#Port<0.9341>}}
- 2017-12-13 22:54:59.579 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9342>) Ac cepted connection ::FFFF:192.168.88.231:33034 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:54:59.579 [info] <0.2332.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9342>,#Port<0.9343>}}
- 2017-12-13 22:54:59.583 [info] <0.2328.0>@ejabberd_c2s:wait_for_session:1106 ({socket_st ate,ejabberd_http_bind,{http_bind,<0.2327.0>,{{0,0,0,0,0,65535,49320,22759},33026}},ejab berd_http_bind}) Opened session for yaroslav@xmpp.home.lan/10722200461752753192596619700 3894366024106437373830986679
- 2017-12-13 22:55:02.260 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9344>) Ac cepted connection ::FFFF:192.168.88.231:33440 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:02.260 [info] <0.2333.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9344>,#Port<0.9345>}}
- 2017-12-13 22:55:02.275 [info] <0.394.0>@mod_carboncopy:iq_handler:110 carbons enabled f or user yaroslav@xmpp.home.lan/107222004617527531925966197003894366024106437373830986679
- 2017-12-13 22:55:02.429 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9346>) Ac cepted connection ::FFFF:192.168.88.231:33442 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:02.429 [info] <0.2334.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9346>,#Port<0.9347>}}
- 2017-12-13 22:55:02.532 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9348>) Ac cepted connection ::FFFF:192.168.88.231:33444 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:02.532 [info] <0.2337.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9348>,#Port<0.9349>}}
- 2017-12-13 22:55:02.666 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9350>) Ac cepted connection ::FFFF:192.168.88.231:33446 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:02.666 [info] <0.2338.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9350>,#Port<0.9351>}}
- 2017-12-13 22:55:02.871 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9352>) Ac cepted connection ::FFFF:192.168.88.231:33448 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:02.872 [info] <0.2339.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9352>,#Port<0.9353>}}
- 2017-12-13 22:55:32.448 [info] <0.2283.0>@ejabberd_http_bind:handle_info:507 Session tim eout. Closing the HTTP bind session: <<"6093164c4a5c098fce14ac8ff97681c333bb1efc">>
- 2017-12-13 22:55:32.448 [info] <0.2284.0>@ejabberd_c2s:terminate:1788 ({socket_state,eja bberd_http_bind,{http_bind,<0.2283.0>,{{0,0,0,0,0,65535,49320,22759},59872}},ejabberd_ht tp_bind}) Close session for yaroslav@xmpp.home.lan/1049952773884604556174453152224164860 9217774078643043824288
- 2017-12-13 22:55:32.517 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9354>) Ac cepted connection ::FFFF:192.168.88.231:33536 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:32.517 [info] <0.2342.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9354>,#Port<0.9355>}}
- 2017-12-13 22:55:40.567 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9356>) Ac cepted connection ::FFFF:192.168.88.231:33542 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:40.567 [info] <0.2343.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9356>,#Port<0.9357>}}
- 2017-12-13 22:55:40.744 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9358>) Ac cepted connection ::FFFF:192.168.88.231:33544 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:55:40.744 [info] <0.2344.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9358>,#Port<0.9359>}}
- 2017-12-13 22:56:32.526 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9360>) Ac cepted connection ::FFFF:192.168.88.231:33562 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:56:32.527 [info] <0.2345.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9360>,#Port<0.9361>}}
- 2017-12-13 22:56:32.730 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9362>) Ac cepted connection ::FFFF:192.168.88.231:33564 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:56:32.731 [info] <0.2346.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9362>,#Port<0.9363>}}
- 2017-12-13 22:56:40.762 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9364>) Ac cepted connection ::FFFF:192.168.88.231:33570 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:56:40.762 [info] <0.2347.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9364>,#Port<0.9365>}}
- 2017-12-13 22:56:40.944 [info] <0.461.0>@ejabberd_listener:accept:333 (#Port<0.9366>) Ac cepted connection ::FFFF:192.168.88.231:33572 -> ::FFFF:192.168.88.232:5280
- 2017-12-13 22:56:40.945 [info] <0.2348.0>@ejabberd_http:init:158 started: {p1_tls,{tlsso ck,#Port<0.9366>,#Port<0.9367>}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement