Error when integrating ejabberd into Nextcloud?

Question

linux

Hey! Can't get chat to work.
Set up xmpp chat on a separate server, set up Nextcloud cloud storage. Added JavaScript XMPP Chat app to Nextcloud. Registered settings "BOSH url" and xmpp domain. The chat connects, the connection is established.
I will add that the chat has separate ldap servers and a database.
My task is to get users into the chat from Ldap. Users from ldap are visible in the ejabberd admin panel. The chat is starting. But when adding a user to the chat, for communication, he takes the uid from Nextcloud, and not from ldap. Screen below .
There are no errors during startup and operation. The ldap and bd settings are correct.
Here is the error that pops up only when adding a login:

2017-12-14 22:22:36.752 [error] <0.354.0>@ejabberd_odbc:outer_transaction:452 SQL transaction restarts exceeded
** Restarts: 10
** Last abort reason: [{severity,'ERROR'},{code,<<"23502">>},{message,<<"null value in column \"server_host\" violates not-null constraint">>},{detail,<<"Failing row contains (xen, null, [email protected], , N, I, , N, , item, 2017-12-14 22:22:36.714091).">>},{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,'-process_subscription/6-fun-0-',6,[{file,"src/mod_roster.erl"},{line,822}]},{ejabberd_odbc,outer_transaction,3,[{file,"src/ejabberd_odbc.erl"},{line,445}]},{ejabberd_odbc,run_sql_cmd,4,[{file,"src/ejabberd_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,<<"appxmpp.lab.lan">>,1000,{0,{[],[]}}}

ejabberd_odbc:outer transaction:452 SQL transaction restarts exceeded

What can I be wrong about? I will be grateful for any help. Thanks in advance.
Screen of adding a user from ldap, and the chat takes uid from Nextcloud.

Answer 1

The error turned out to be "funny", I installed jabber from the Ubuntu repository. And when importing tables into the database, I imported a new file for postgressa, but I needed a regular one. Imported pg.sql and the error is gone.