I installed Carbonio CE 24.9.1 on Ubuntu 22 by Automation script from docs.zextras.com. Everything is ok but the chat and video meeting not work, anyone know where I can check log or related check, pls show me. Thank you very much.
Hello QuangSang,
Got the same problem here. After few searches on all logs on my system, i found some on /var/log/syslog:
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.099 [error] gen_server 'wpool_pool-mongoose_wpool$rdbms$global$default-5' terminated with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.099323+00:00 level=error reason="{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}" pid=<0.3225.0> at=gen_server:error_info/8:1391 client_info="{<0.3881.0>,{<0.3881.0>,[{gen,do_call,4,[{file,\"gen.erl\"},{line,259}]},{gen_server,call,3,[{file,\"gen_server.erl\"},{line,415}]},{mongoose_rdbms,execute_successfully,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,271}]},{mod_muc_light_db_rdbms,get_aff_users,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light_db_rdbms.erl\"},{line,551}]},{timer,tc,4,[{file,\"timer.erl\"},{line,312}]},{mongoose_backend,call_tracked,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_backend.erl\"},{line,97}]},{mod_muc_light,acc_room_affiliations,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light.erl\"},{line,543}]},{gen_hook,apply_hook_function,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/gen_hook.erl\"},{line,251}]}]}}" last_message="{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831294}" state={state,<0.3226.0>,#{},30,5000} log= name=wpool_pool-mongoose_wpool$rdbms$global$default-5 label={gen_server,terminate}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.101 [error] CRASH REPORT Process 'wpool_pool-mongoose_wpool$rdbms$global$default-5' with 0 neighbours crashed with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.101453+00:00 level=error pid=<0.3225.0> at=proc_lib:crash_report/4:584 report="[[{initial_call,{wpool_process,init,['Argument__1']}},{pid,<0.3225.0>},{registered_name,'wpool_pool-mongoose_wpool$rdbms$global$default-5'},{error_info,{error,{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{ancestors,['wpool_pool-mongoose_wpool$rdbms$global$default-process-sup','mongoose_wpool$rdbms$global$default',mongoose_wpool_rdbms_sup,mongoose_wpool_sup,ejabberd_sup,<0.292.0>]},{message_queue_len,1},{messages,[{'EXIT',<0.3226.0>,normal}]},{links,[<0.3214.0>]},{dictionary,[{wpool_task,{undefined,1731341290,{call,{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831294}}}}]},{trap_exit,true},{status,running},{heap_size,6772},{stack_size,28},{reductions,46514}],[]]" label={proc_lib,crash}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.104 [error] Supervisor 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-5' started with wpool_process:start_link('wpool_pool-mongoose_wpool$rdbms$global$default-5', mongoose_rdbms, #{driver => pgsql,port => 20000,host => "127.78.0.10",password => "10b2ef0a46aa89cecc5946877714...",...}, [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3225.0> exit with reason no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894 in context child_terminated
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.103081+00:00 level=error pid=<0.3214.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,child_terminated},{reason,{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{offender,[{pid,<0.3225.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-5'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-5',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,child_terminated}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.103590+00:00 level=error what=hook_failed reason="{{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]},{gen_server,call,['wpool_pool-mongoose_wpool$rdbms$global$default-5',{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831294},60000]}}" pid=<0.3881.0> at=gen_hook:error_running_hook/5:254 from_jid=1d55f392-0b0d-4bed-bac9-46a4f442838e@carbonio/1731-341284-544685-72d479454012092a to_jid=ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio stacktrace="gen_server:call/3:419 mongoose_rdbms:execute_successfully/4:271 mod_muc_light_db_rdbms:get_aff_users/2:551 timer:tc/4:312 mongoose_backend:call_tracked/4:97 mod_muc_light:acc_room_affiliations/3:543 gen_hook:apply_hook_function/3:251 gen_hook:run_hook/4:237" text="Error running hook" acc_timestamp=2024-11-11T16:08:10.070268+00:00 origin_pid=<0.3848.0> key="{acc_room_affiliations,<<\"carbonio\">>}" params_room="{jid,<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>,<<>>}" handler="{hook_handler,50,fun mod_muc_light:acc_room_affiliations/3,#{host_type => <<\"carbonio\">>,hook_name => acc_room_affiliations,hook_tag => <<\"carbonio\">>}}" packet="<iq id='898f5d5e-858c-48f9-822a-2030129e6b74:sendIQ' to='ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio' type='set' xmlns='jabber:client'><query queryid='history' xmlns='urn:xmpp:mam:2'><x type='submit' xmlns='jabber:x:data'><field type='hidden' var='FORM_TYPE'><value>urn:xmpp:mam:2</value></field><field var='start'><value>2024-11-11T17:02:07.128+01:00</value></field><field var='end'><value>2024-11-11T17:08:09.840+01:00</value></field></x><set xmlns='http://jabber.org/protocol/rsm'><max>50</max><before/></set></query></iq>"
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.108 [error] gen_server 'wpool_pool-mongoose_wpool$rdbms$global$default-8' terminated with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.107925+00:00 level=error reason="{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}" pid=<0.3231.0> at=gen_server:error_info/8:1391 client_info="{<0.3881.0>,{<0.3881.0>,[{gen,do_call,4,[{file,\"gen.erl\"},{line,259}]},{gen_server,call,3,[{file,\"gen_server.erl\"},{line,415}]},{mongoose_rdbms,execute_successfully,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,271}]},{mod_muc_light_db_rdbms,get_aff_users,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light_db_rdbms.erl\"},{line,551}]},{timer,tc,4,[{file,\"timer.erl\"},{line,312}]},{mongoose_backend,call_tracked,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_backend.erl\"},{line,97}]},{mod_muc_light,acc_room_affiliations,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light.erl\"},{line,543}]},{gen_hook,apply_hook_function,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/gen_hook.erl\"},{line,251}]}]}}" last_message="{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831284}" state={state,<0.3232.0>,#{},30,5000} log= name=wpool_pool-mongoose_wpool$rdbms$global$default-8 label={gen_server,terminate}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.109 [error] CRASH REPORT Process 'wpool_pool-mongoose_wpool$rdbms$global$default-8' with 0 neighbours crashed with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.109717+00:00 level=error pid=<0.3231.0> at=proc_lib:crash_report/4:584 report="[[{initial_call,{wpool_process,init,['Argument__1']}},{pid,<0.3231.0>},{registered_name,'wpool_pool-mongoose_wpool$rdbms$global$default-8'},{error_info,{error,{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{ancestors,['wpool_pool-mongoose_wpool$rdbms$global$default-process-sup','mongoose_wpool$rdbms$global$default',mongoose_wpool_rdbms_sup,mongoose_wpool_sup,ejabberd_sup,<0.292.0>]},{message_queue_len,1},{messages,[{'EXIT',<0.3232.0>,normal}]},{links,[<0.3214.0>]},{dictionary,[{wpool_task,{undefined,1731341290,{call,{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831284}}}}]},{trap_exit,true},{status,running},{heap_size,6772},{stack_size,28},{reductions,46326}],[]]" label={proc_lib,crash}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.110976+00:00 level=error what=hook_failed reason="{{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]},{gen_server,call,['wpool_pool-mongoose_wpool$rdbms$global$default-8',{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831284},60000]}}" pid=<0.3881.0> at=gen_hook:error_running_hook/5:254 from_jid=1d55f392-0b0d-4bed-bac9-46a4f442838e@carbonio/1731-341284-544685-72d479454012092a to_jid=ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio stacktrace="gen_server:call/3:419 mongoose_rdbms:execute_successfully/4:271 mod_muc_light_db_rdbms:get_aff_users/2:551 timer:tc/4:312 mongoose_backend:call_tracked/4:97 mod_muc_light:acc_room_affiliations/3:543 gen_hook:apply_hook_function/3:251 gen_hook:run_hook/4:237" text="Error running hook" acc_timestamp=2024-11-11T16:08:10.070268+00:00 origin_pid=<0.3848.0> key="{acc_room_affiliations,<<\"carbonio\">>}" params_room="{jid,<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>,<<>>}" handler="{hook_handler,50,fun mod_muc_light:acc_room_affiliations/3,#{host_type => <<\"carbonio\">>,hook_name => acc_room_affiliations,hook_tag => <<\"carbonio\">>}}" packet="<iq id='898f5d5e-858c-48f9-822a-2030129e6b74:sendIQ' to='ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio' type='set' xmlns='jabber:client'><query queryid='history' xmlns='urn:xmpp:mam:2'><x type='submit' xmlns='jabber:x:data'><field type='hidden' var='FORM_TYPE'><value>urn:xmpp:mam:2</value></field><field var='start'><value>2024-11-11T17:02:07.128+01:00</value></field><field var='end'><value>2024-11-11T17:08:09.840+01:00</value></field></x><set xmlns='http://jabber.org/protocol/rsm'><max>50</max><before/></set></query></iq>"
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.112387+00:00 level=warning what=action_not_allowed reason="Not allowed to enter the room." pid=<0.3881.0> at=mod_mam_muc:room_process_mam_iq/5:236 from_jid=1d55f392-0b0d-4bed-bac9-46a4f442838e@carbonio/1731-341284-544685-72d479454012092a to_jid=ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio acc_timestamp=2024-11-11T16:08:10.070268+00:00 origin_pid=<0.3848.0> can_access_room=false action=mam_set_message_form packet="<iq id='898f5d5e-858c-48f9-822a-2030129e6b74:sendIQ' to='ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio' type='set' xmlns='jabber:client'><query queryid='history' xmlns='urn:xmpp:mam:2'><x type='submit' xmlns='jabber:x:data'><field type='hidden' var='FORM_TYPE'><value>urn:xmpp:mam:2</value></field><field var='start'><value>2024-11-11T17:02:07.128+01:00</value></field><field var='end'><value>2024-11-11T17:08:09.840+01:00</value></field></x><set xmlns='http://jabber.org/protocol/rsm'><max>50</max><before/></set></query></iq>"
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.134 [error] Supervisor 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-8' started with wpool_process:start_link('wpool_pool-mongoose_wpool$rdbms$global$default-8', mongoose_rdbms, #{driver => pgsql,port => 20000,host => "127.78.0.10",password => "10b2ef0a46aa89cecc5946877714...",...}, [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3231.0> exit with reason no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894 in context child_terminated
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.134229+00:00 level=error pid=<0.3214.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,child_terminated},{reason,{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{offender,[{pid,<0.3231.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-8'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-8',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,child_terminated}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.134949+00:00 level=error pid=<0.3214.0> at=supervisor:restart/2:813 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,shutdown},{reason,reached_max_restart_intensity},{offender,[{pid,<0.3231.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-8'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-8',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,shutdown}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.137376+00:00 level=error pid=<0.492.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'mongoose_wpool$rdbms$global$default'}},{errorContext,child_terminated},{reason,shutdown},{offender,[{pid,<0.3214.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'},{mfargs,{wpool_process_sup,start_link,['mongoose_wpool$rdbms$global$default','wpool_pool-mongoose_wpool$rdbms$global$default-process-sup',[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,infinity},{child_type,supervisor}]}]" label={supervisor,child_terminated}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.135 [error] Supervisor 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-8' started with wpool_process:start_link('wpool_pool-mongoose_wpool$rdbms$global$default-8', mongoose_rdbms, #{driver => pgsql,port => 20000,host => "127.78.0.10",password => "10b2ef0a46aa89cecc5946877714...",...}, [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3231.0> exit with reason reached_max_restart_intensity in context shutdown
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.137 [error] Supervisor 'mongoose_wpool$rdbms$global$default' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' started with wpool_process_sup:start_link('mongoose_wpool$rdbms$global$default', 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup', [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3214.0> exit with reason shutdown in context child_terminated
Could you please share the output of following commands:
root@mail:~# curl -s -v http://127.78.0.4:10000/health | jq
and
root@mail:~# systemctl list-units carbonio*
And restart services as per following order:
root@mail:~# systemctl restart carbonio-tasks root@mail:~# systemctl restart carbonio-message-broker root@mail:~# systemctl restart carbonio-message-dispatcher root@mail:~# systemctl restart carbonio-ws-collaboration root@mail:~# systemctl restart carbonio-videoserver
And later check the status of these services if needed.
Regards,
Sharif
root@carbonio:~# curl -s -v http://127.78.0.4:10000/health | jq
* Trying 127.78.0.4:10000...
* Connected to 127.78.0.4 (127.78.0.4) port 10000 (#0)
> GET /health HTTP/1.1
> Host: 127.78.0.4:10000
> User-Agent: curl/7.81.0
> Accept: */*
>
* Mark bundle as not supporting multiuse
< HTTP/1.1 200 OK
< Server: Jetty(12.0.8)
< Date: Tue, 12 Nov 2024 07:18:19 GMT
< Content-Type: application/json
< Content-Length: 403
<
{ [403 bytes data]
* Connection #0 to host 127.78.0.4 left intact
{
"isLive": true,
"status": "ok",
"dependencies": [
{
"name": "database",
"isHealthy": true
},
{
"name": "authentication_service",
"isHealthy": true
},
{
"name": "profiling_service",
"isHealthy": true
},
{
"name": "xmpp_server",
"isHealthy": true
},
{
"name": "event_dispatcher",
"isHealthy": true
},
{
"name": "storage_service",
"isHealthy": true
},
{
"name": "previewer_service",
"isHealthy": true
},
{
"name": "videoserver_service",
"isHealthy": true
}
]
}
-----------------------
root@carbonio:~# systemctl list-units carbonio*
UNIT LOAD ACTIVE SUB DESCRIPTION
carbonio-clamav-sidecar.service loaded active running Carbonio clamav sidecar proxy
carbonio-clamav-signature-provider-sidecar.service loaded active running NGINX Carbonio ClamAV signature provider sidecar
carbonio-docs-connector-db-sidecar.service loaded active running Carbonio Docs Connector database sidecar
carbonio-docs-connector-sidecar.service loaded active running Carbonio docs connector sidecar proxy
carbonio-docs-connector.service loaded active running Carbonio docs connector daemon
carbonio-docs-editor-sidecar.service loaded active running Carbonio Docs server sidecar proxy
carbonio-docs-editor.service loaded active running Carbonio Docs Server
carbonio-files-db-sidecar.service loaded active running Carbonio Files database sidecar
carbonio-files-sidecar.service loaded active running Carbonio Files sidecar proxy
carbonio-files.service loaded active running Carbonio Files daemon
carbonio-mailbox-admin-sidecar.service loaded active running Carbonio Mailbox Admin proxy sidecar
carbonio-mailbox-db-sidecar.service loaded active running Carbonio Mailbox database sidecar
carbonio-mailbox-nslookup-sidecar.service loaded active running Carbonio Mailbox NSLookup proxy sidecar
carbonio-mailbox-sidecar.service loaded active running Mailbox carbonio proxy sidecar
carbonio-message-broker-sidecar.service loaded active running Carbonio message broker sidecar proxy
carbonio-message-broker.service loaded active running Carbonio message broker daemon
carbonio-message-dispatcher-auth-sidecar.service loaded active running Carbonio Message Dispatcher auth sidecar proxy
carbonio-message-dispatcher-auth.service loaded active running Carbonio Message Dispatcher auth daemon
carbonio-message-dispatcher-db-sidecar.service loaded active running Carbonio Message Dispatcher database sidecar
carbonio-message-dispatcher-http-sidecar.service loaded active running Carbonio Message Dispatcher HTTP sidecar proxy
carbonio-message-dispatcher-xmpp-sidecar.service loaded active running Carbonio Message Dispatcher XMPP sidecar proxy
carbonio-message-dispatcher.service loaded active running Carbonio Message Dispatcher daemon
carbonio-mta-sidecar.service loaded active running Carbonio mta sidecar proxy
carbonio-preview-sidecar.service loaded active running Carbonio Preview sidecar proxy
carbonio-preview.service loaded active running Carbonio Preview daemon
carbonio-prometheus-consul-exporter.service loaded active running Carbonio Prometheus Consul exporter
carbonio-prometheus-mysqld-exporter.service loaded active running Carbonio Prometheus MySQL exporter
carbonio-prometheus-nginx-exporter.service loaded active running Carbonio Prometheus NGINX exporter
carbonio-prometheus-node-exporter.service loaded active running Carbonio Prometheus Node Exporter
carbonio-prometheus-openldap-exporter.service loaded active running Carbonio Prometheus OpenLDAP exporter
carbonio-proxy-sidecar.service loaded active running NGINX carbonio proxy sidecar
carbonio-storages-sidecar.service loaded active running Storages-CE sidecar proxy
carbonio-storages.service loaded active running Carbonio Storages-CE daemon
carbonio-tasks-db-sidecar.service loaded active running Carbonio Tasks database sidecar
carbonio-tasks-sidecar.service loaded active running Carbonio Tasks sidecar proxy
carbonio-tasks.service loaded active running Carbonio Tasks daemon
carbonio-user-management-sidecar.service loaded active running Carbonio User Management sidecar proxy
carbonio-user-management.service loaded active running Carbonio User Management daemon
carbonio-videoserver-sidecar.service loaded active running Carbonio Videoserver sidecar proxy
carbonio-videoserver.service loaded active running Zextras Videoserver
carbonio-ws-collaboration-db-sidecar.service loaded active running Carbonio Workstream Collaboration database sidecar
carbonio-ws-collaboration-sidecar.service loaded active running Carbonio Workstream Collaboration sidecar proxy
carbonio-ws-collaboration.service loaded active running Carbonio Workstream Collaboration daemon
carbonio.service loaded active exited LSB: Carbonio Services
LOAD = Reflects whether the unit definition was properly loaded.
ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
SUB = The low-level unit activation state, values depend on unit type.
44 loaded units listed. Pass --all to see loaded but inactive units, too.
To show all installed unit files use 'systemctl list-unit-files'.
-----------------------
root@carbonio:~# systemctl restart carbonio-tasks
root@carbonio:~# systemctl status carbonio-tasks
● carbonio-tasks.service - Carbonio Tasks daemon
Loaded: loaded (/lib/systemd/system/carbonio-tasks.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-tasks.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:20:10 HKT; 8s ago
Main PID: 889676 (carbonio-tasks)
Tasks: 35 (limit: 19057)
Memory: 193.2M
CPU: 5.768s
CGroup: /system.slice/carbonio-tasks.service
├─889676 /bin/bash /usr/bin/carbonio-tasks
└─889677 /opt/zextras/common/bin/java -Djava.net.preferIPv4Stack=true -Xms1024m -Xmx2048m -DTASKS_LOG_LEVEL=warn -jar /usr/share/carbonio/carbonio-tasks.jar
Nov 12 15:20:10 carbonio.arestos.net systemd[1]: Started Carbonio Tasks daemon.
Nov 12 15:20:11 carbonio.arestos.net carbonio-tasks[889677]: 15:20:11.367 [main] WARN c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-max-pool-size from consul
Nov 12 15:20:11 carbonio.arestos.net carbonio-tasks[889677]: 15:20:11.375 [main] WARN c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-min-idle-connections from consul
Nov 12 15:20:12 carbonio.arestos.net carbonio-tasks[889677]: 15:20:12.120 [main] WARN o.jboss.resteasy.resteasy_jaxrs.i18n - RESTEASY002160: Provider instance org.jboss.resteasy.plugins.provid>
root@carbonio:~# systemctl restart carbonio-message-broker
root@carbonio:~# systemctl status carbonio-message-broker
● carbonio-message-broker.service - Carbonio message broker daemon
Loaded: loaded (/lib/systemd/system/carbonio-message-broker.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-message-broker.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:21:05 HKT; 7s ago
Main PID: 890198 (beam.smp)
Tasks: 32 (limit: 19057)
Memory: 143.5M
CPU: 6.602s
CGroup: /system.slice/carbonio-message-broker.service
├─890198 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/beam.smp -W w -MBas ageffcbf -MHas ageffcbf -MBlmbcs 512 -MHlmbcs 512 -MMmcs 30 -pc unicode -P 1048576 -t 5000000 -stbt db>
├─890210 erl_child_setup 32768
├─890231 sh -s disksup
├─890233 /opt/zextras/common/lib/erlang/lib/os_mon-2.9.1/priv/bin/memsup
├─890234 /opt/zextras/common/lib/erlang/lib/os_mon-2.9.1/priv/bin/cpu_sup
├─890242 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/inet_gethost 4
├─890243 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/inet_gethost 4
├─890254 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/epmd -daemon
└─890286 /bin/sh -s rabbit_disk_monitor
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.448153+08:00 [info] <0.664.0> started TCP listener on 127.78.0.18:10000
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: completed with 5 plugins.
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> Server startup complete; 5 plugins started.
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_peer_discovery_consul
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_peer_discovery_common
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_management
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_management_agent
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_web_dispatch
Nov 12 15:21:05 carbonio.arestos.net systemd[1]: Started Carbonio message broker daemon.
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.597353+08:00 [info] <0.9.0> Time to start RabbitMQ: 6864 ms
root@carbonio:~# systemctl restart carbonio-ws-collaboration
root@carbonio:~# systemctl status carbonio-ws-collaboration
● carbonio-ws-collaboration.service - Carbonio Workstream Collaboration daemon
Loaded: loaded (/lib/systemd/system/carbonio-ws-collaboration.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-ws-collaboration.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:21:31 HKT; 6s ago
Docs: https://docs.zextras.com/
Main PID: 890400 (carbonio-ws-col)
Tasks: 59 (limit: 19057)
Memory: 1.1G
CPU: 9.334s
CGroup: /system.slice/carbonio-ws-collaboration.service
├─890400 /bin/bash /usr/bin/carbonio-ws-collaboration
└─890404 /opt/zextras/common/bin/java -Djava.net.preferIPv4Stack=true -Xms1024m -Xmx2048m -XX:+UseZGC -jar /usr/share/carbonio/carbonio-ws-collaboration.jar
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.587 INFO o.j.r.plugins.validation.i18n : RESTEASY008550: Unable to find CDI supporting ValidatorFac>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.734 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.738 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.747 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.755 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.757 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.758 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.775 INFO .e.j.e.s.ServletContextHandler : Started oeje10s.ServletContextHandler@3cb6e0ee{ROOT,/,b=nu>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.782 INFO o.e.j.s.AbstractConnector : Started ServerConnector@78d5654b{HTTP/1.1, (http/1.1)}{127>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.784 INFO o.eclipse.jetty.server.Server : Started oejs.Server@590d6c76{STARTING}[12.0.8,sto=0] @5154>
root@carbonio:~# systemctl restart carbonio-videoserver
root@carbonio:~# systemctl status carbonio-videoserver
● carbonio-videoserver.service - Zextras Videoserver
Loaded: loaded (/lib/systemd/system/carbonio-videoserver.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-videoserver.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:21:50 HKT; 7s ago
Main PID: 890811 (janus)
Tasks: 48
Memory: 5.3M
CPU: 44ms
CGroup: /system.slice/carbonio-videoserver.service
└─890811 /opt/zextras/common/bin/janus
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: Loading transport plugin 'libjanus_websockets.so'...
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: [WARN] libwebsockets has been built without IPv6 support, will bind to IPv4 only
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: libwebsockets logging: 0
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: Websockets server started (port 8188)...
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: JANUS WebSockets transport plugin initialized!
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: Loading transport plugin 'libjanus_rabbitmq.so'...
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: WebSockets thread started
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: RabbitMQ SSL support disabled
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: [WARN] RabbitMQ support disabled for both Janus and Admin API, giving up
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: [WARN] The 'janus.transport.rabbitmq' plugin could not be initialized
Everything is ok but still not working
@nicolas-blanc yes, my syslog has same issue
Nov 12 15:37:35 carbonio mongooseimctl[5067]: when=2024-11-12T07:37:35.880012+00:00 level=error reason="{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"inbox\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"91\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}" pid=<0.82225.0> at=gen_server:error_info/8:1391 client_info="{<0.82242.0>,{<0.82242.0>,[{gen,do_call,4,[{file,\"gen.erl\"},{line,259}]},{gen_server,call,3,[{file,\"gen_server.erl\"},{line,415}]},{mongoose_rdbms,execute_successfully,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,271}]},{mod_inbox_rdbms,get_inbox,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/inbox/mod_inbox_rdbms.erl\"},{line,118}]},{timer,tc,4,[{file,\"timer.erl\"},{line,312}]},{mongoose_backend,call_tracked,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_backend.erl\"},{line,97}]},{mod_inbox,process_iq,5,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/inbox/mod_inbox.erl\"},{line,206}]},{mongoose_iq_handler,execute_handler,5,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_iq_handler.erl\"},{line,105}]}]}}" last_message="{sql_cmd,{sql_execute,inbox_lookup_desc_no_bin,[<<\"10dbe6d6-984d-4578-9be5-d9218fa2b4c1\">>,<<\"carbonio\">>]},-576372244073}" state={state,<0.82226.0>,#{},30,5000} log= name=wpool_pool-mongoose_wpool$rdbms$global$default-2 label={gen_server,terminate}
Nov 12 15:37:35 carbonio mongooseimctl[5067]: when=2024-11-12T07:37:35.881460+00:00 level=error pid=<0.82225.0> at=proc_lib:crash_report/4:584 report="[[{initial_call,{wpool_process,init,['Argument__1']}},{pid,<0.82225.0>},{registered_name,'wpool_pool-mongoose_wpool$rdbms$global$default-2'},{error_info,{error,{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"inbox\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"91\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{ancestors,['wpool_pool-mongoose_wpool$rdbms$global$default-process-sup','mongoose_wpool$rdbms$global$default',mongoose_wpool_rdbms_sup,mongoose_wpool_sup,ejabberd_sup,<0.285.0>]},{message_queue_len,1},{messages,[{'EXIT',<0.82226.0>,normal}]},{links,[<0.28444.0>]},{dictionary,[{wpool_task,{undefined,1731397055,{call,{sql_cmd,{sql_execute,inbox_lookup_desc_no_bin,[<<\"10dbe6d6-984d-4578-9be5-d9218fa2b4c1\">>,<<\"carbonio\">>]},-576372244073}}}}]},{trap_exit,true},{status,running},{heap_size,10958},{stack_size,28},{reductions,42739}],[]]" label={proc_lib,crash}
Nov 12 15:37:35 carbonio mongooseimctl[5067]: when=2024-11-12T07:37:35.882259+00:00 level=error pid=<0.28444.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,child_terminated},{reason,{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"inbox\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"91\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{offender,[{pid,<0.82225.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-2'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-2',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"25dfce98fe3233a0d751c26da5011d6d\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"25dfce98fe3233a0d751c26da5011d6d\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,child_terminated}
Nov 12 15:37:35 carbonio mongooseimctl[5067]: 15:37:35.880 [error] gen_server 'wpool_pool-mongoose_wpool$rdbms$global$default-2' terminated with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"inbox\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"91">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Hi Sharif,
After a hard battle with the logs, and digging into your documentations, i found a thread between you and Anahuac (Upgradation From Carbonio CE 23.11.0 to 23.12.0 Workstream Collaboration – Install & Setup – Zextras Forum). Where Anahuac said :
carbonio-message-dispatcher-migration This one is the tricky one. If it fails you must wait like 5 minutes and try again. There is something running in background that takes that time to be done and allow it to run successfully. So, insist running it till it works: PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000
So, i did as explained (replaced $DB_ADM_PWD by the passwd i got from first installation). And try each 5 minutes for 20 minutes until it succeed. After that, everything worked fine !
@quang-sang, before launching the command i did a sudo -i
Have a nice day !
Hi,
Glad to know that you fixed it.
Thanks for your insight and feedback.
Have a good day 😊
Regards,
Sharif
Hi,
I runned update, added hosts, reboot and also sudo -i to root permission before run install script.
But the chat and video still not work.
I have tried installed 3 times on new blank server. Got same issue
Tell me how to fix the error, I started a chat to check, made a test message to a person, and then I remembered that I did not make a couple of commands, after I installed and configured everything, and I can't write to only one person now, respectively, and he to me, I see in the logs that there is no access
2024-12-11T09:05:11.595430+00:00 mail mongooseimctl[53371]: when=2024-12-11T09:05:11.587628+00:00 level=warning what=action_not_allowed reason="Not allowed to enter the room." pid=<0.20616.0> at=mod_mam_muc:room_process_mam_iq/5:236 from_jid=c9f64a9d-692c-4240-97a2-d14bc626f6de@carbonio/1733-907910-414647-28232e3c77adeb3a to_jid=627b913f-6d44-471d-ac0a-28bb1f35f956@muclight.carbonio acc_timestamp=2024-12-11T09:05:11.578451+00:00 origin_pid=<0.20612.0> can_access_room=false action=mam_set_message_form packet="<iq id='5777b2bd-cc70-4dfd-acd9-54e0bd3e8670:sendIQ' to='627b913f-6d44-471d-ac0a-28bb1f35f956@muclight.carbonio' type='set' xmlns='jabber:client'><query queryid='history' xmlns='urn:xmpp:mam:2'><x type='submit' xmlns='jabber:x:data'><field type='hidden' var='FORM_TYPE'><value>urn:xmpp:mam:2</value></field><field var='start'><value>2024-12-11T08:06:47.133+07:00</value></field><field var='end'><value>2024-12-11T16:05:11.567+07:00</value></field></x><set xmlns='http://jabber.org/protocol/rsm'><max>50</max><before/></set></query></iq>"
Hello, I'm using Version 24.12.4 CE.
I've already installed Carbonio CE about 10 times and also used this script and the one from the official documentation.
But nothing makes CHAT and VIDEO work, the chat just goes offline.
And no service is offline and I've done the official procedure to install CHAT and VIDEO about 5 times.
Can anyone help me?
If you want, I can give you ssh access to my server.