33616 2017-07-04 16:56:55 +0300 Ejabberd не работает с mysql базой. 2025-11-14 12:25:34 +0300 1 1 3 Distributions Branch p8 ejabberd не указана all Linux CLOSED WONTFIX P3 major --- 1 for_robot cas mattakushi10 rider qa-p8 oldest_to_newest 164556 0 for_robot 2017-07-04 16:56:55 +0300 Установлен стартер-кит P8 4.4.74-std-def-alt0.M80P.1 Установлен mysql 5.5.54-alt0.M80P.1 (ALT) Установлен ejabberd-extra-2.1.13-alt1, ejabberd-2.1.13-alt1 После настройки ejabberd.cfg выполняем: [root@server-jabber opt]# echo "GRANT ALL ON jabber2017.* TO 'jabuser'@'localhost' IDENTIFIED BY '123';" | mysql -h localhost -u root [root@server-jabber opt]# echo "CREATE DATABASE jabber2017;" | mysql -h localhost -u jabuser -p Enter password: [root@server-jabber opt]# mysql -h localhost -D jabber2017 -u jabuser -p < mysql2.1.13.sql Enter password: [root@server-jabber opt]# ejabberdctl start [root@server-jabber opt]# ejabberdctl status The node 'ejabberd@server-jabber' is starting with status: started ejabberd is not running in that node Check for error messages: /var/log/ejabberd/ejabberd.log or other files in that directory. [root@server-jabber opt]# nmap 127.0.0.1 Starting Nmap 5.51 ( http://nmap.org ) at 2017-07-04 18:16 +05 Nmap scan report for localhost.localdomain (127.0.0.1) Host is up (0.0000050s latency). Not shown: 996 closed ports PORT STATE SERVICE 3306/tcp open mysql 5222/tcp open xmpp-client 5269/tcp open xmpp-server 5280/tcp open xmpp-bosh Nmap done: 1 IP address (1 host up) scanned in 0.25 seconds В файл /var/log/ejabberd/erlang.log сыпится: ... =CRASH REPORT==== 4-Jul-2017::18:16:48 === crasher: initial call: ejabberd_odbc:init/1 pid: <0.254.0> registered_name: [] exception error: undefined function gen:debug_options/1 in function p1_fsm:init_it/6 (p1_fsm.erl, line 338) ancestors: ['ejabberd_odbc_sup_ou.v-int.ru',ejabberd_sup,<0.62.0>] messages: [] links: [<0.253.0>] dictionary: [] trap_exit: false status: running heap_size: 376 stack_size: 27 reductions: 111 neighbours: =SUPERVISOR REPORT==== 4-Jul-2017::18:16:48 === Supervisor: {local,'ejabberd_odbc_sup_ou.v-int.ru'} Context: start_error Reason: undef Offender: [{pid,undefined}, {id,1}, {mfargs,{ejabberd_odbc,start_link,["ou.v-int.ru",30000]}}, {restart_type,transient}, {shutdown,2000}, {child_type,worker}] =CRASH REPORT==== 4-Jul-2017::18:16:48 === crasher: initial call: ejabberd_odbc:init/1 pid: <0.258.0> registered_name: [] exception error: undefined function gen:debug_options/1 in function p1_fsm:init_it/6 (p1_fsm.erl, line 338) ancestors: ['ejabberd_odbc_sup_ou.v-int.ru',ejabberd_sup,<0.62.0>] messages: [] links: [<0.257.0>] dictionary: [] trap_exit: false status: running heap_size: 376 stack_size: 27 reductions: 111 neighbours: .... 164557 1 7134 for_robot 2017-07-04 16:58:24 +0300 Created attachment 7134 конфигурационный файл. 192512 2 mattakushi10 2020-09-15 13:00:34 +0300 Поддержка дистрибутива завершена. Используйте новые версии. 192516 3 rider 2020-09-15 13:02:15 +0300 Максим, не закрывайте существующие ошибки. Поддержка дистрибутива не завершена. 276677 4 cas 2025-11-14 12:25:34 +0300 Продукт более не поддерживается. Если актуально, то необходимо перевешать на новый поддерживаемый репозиторий (p10, p11, Sisyphus). 7134 2017-07-04 16:58:24 +0300 2017-07-04 16:58:24 +0300 конфигурационный файл. ejabberd.cfg application/octet-stream 2348 for_robot e2xvZ2xldmVsLCAxfS4Ke2FjbCwgYWRtaW4sIHt1c2VyLCAiMDAwIiwgIm91LnYtaW50LnJ1In19 LgoKe2hvc3RzLCBbIm91LnYtaW50LnJ1Il19Lgp7bGFuZ3VhZ2UsICJydSJ9LgoKe2xpc3RlbiwK IFsKCiAgezUyMjIsIGVqYWJiZXJkX2MycywgWwoJCQl7Y2VydGZpbGUsICIvdmFyL2xpYi9zc2wv c2VydmVyLnBlbSJ9LCBzdGFydHRscywKCQkJe2FjY2VzcywgYzJzfSwKCQkJe3NoYXBlciwgYzJz X3NoYXBlcn0sCgkJCXttYXhfc3RhbnphX3NpemUsIDY1NTM2fQoJCSAgICAgICBdfSwKICB7NTI2 OSwgZWphYmJlcmRfczJzX2luLCBbCgkJCSAgIHtzaGFwZXIsIHMyc19zaGFwZXJ9LAoJCQkgICB7 bWF4X3N0YW56YV9zaXplLCAxMzEwNzJ9CgkJCSAgXX0sCiAgezUyODAsIGVqYWJiZXJkX2h0dHAs IFtodHRwX3BvbGwsIHdlYl9hZG1pbiwgdGxzLCB7Y2VydGZpbGUsICIvdmFyL2xpYi9zc2wvc2Vy dmVyLnBlbSJ9XX0KIF19Lgp7YXV0aF9tZXRob2QsIG9kYmN9Lgp7b2RiY19zZXJ2ZXIsICAgICB7 bXlzcWwsICJsb2NhbGhvc3QiLCAiamFiYmVyMjAxNyIsICJqYWJ1c2VyIiwgICIxMjMifX0uCiUl e29kYmNfc2VydmVyLCAgIHtteXNxbCwgImxvY2FsaG9zdCIsICJqYWJiZXIiLCAiamFidXNlciIs ICAiMTIzIn19LgolJXtvZGJjX3NlcnZlciwge215c3FsLCAic2VydmVyIiwgICAgImRhdGFiYXNl IiwgInVzZXJuYW1lIiwgInBhc3N3b3JkIn19Lgp7c2hhcGVyLCBub3JtYWwsIHttYXhyYXRlLCA0 MDAwMDB9fS4Ke3NoYXBlciwgZmFzdCwgICB7bWF4cmF0ZSwgNTAwMDAwfX0uCgoKCiUlIExvY2Fs IHVzZXJzOiBkb24ndCBtb2RpZnkgdGhpcyBsaW5lLgp7YWNsLCBsb2NhbCwge3VzZXJfcmVnZXhw LCAiIn19Lgp7YWNjZXNzLCBtYXhfdXNlcl9zZXNzaW9ucywgW3sxMCwgYWxsfV19Lgp7YWNjZXNz LCBsb2NhbCwgW3thbGxvdywgbG9jYWx9XX0uCnthY2Nlc3MsIGMycywgW3tkZW55LCBibG9ja2Vk fSwKCSAgICAgIHthbGxvdywgYWxsfV19Lgp7YWNjZXNzLCBjMnNfc2hhcGVyLCBbe25vbmUsIGFk bWlufSwKCSAgICAgIHtub3JtYWwsIGFsbH1dfS4Ke2FjY2VzcywgczJzX3NoYXBlciwgW3tmYXN0 LCBhbGx9XX0uCnthY2Nlc3MsIGFubm91bmNlLCBbe2FsbG93LCBhZG1pbn1dfS4Ke2FjY2Vzcywg Y29uZmlndXJlLCBbe2FsbG93LCBhZG1pbn1dfS4Ke2FjY2VzcywgbXVjX2FkbWluLCBbe2FsbG93 LCBhZG1pbn1dfS4Ke2FjY2VzcywgbXVjLCBbe2FsbG93LCBhbGx9XX0uCnthY2Nlc3MsIHB1YnN1 Yl9jcmVhdGVub2RlLCBbe2FsbG93LCBhbGx9XX0uCnthY2Nlc3MsIHJlZ2lzdGVyLCBbe2FsbG93 LCBhbGx9XX0uCntyZWdpc3RyYXRpb25fdGltZW91dCwgMTB9Lgp7bGFuZ3VhZ2UsICJydSJ9Lgp7 bW9kdWxlcywKIFsKICB7bW9kX2FkaG9jLCAgICBbXX0sCiAge21vZF9hbm5vdW5jZSwgW3thY2Nl c3MsIGFubm91bmNlfV19LCAlIHJlY29tbWVuZHMgbW9kX2FkaG9jCiAge21vZF9jYXBzLCAgICAg W119LCAKICB7bW9kX2NvbmZpZ3VyZSxbXX0sICUgcmVxdWlyZXMgbW9kX2FkaG9jCiAge21vZF9k aXNjbywgICAgW119LAogIHttb2RfbGFzdF9vZGJjLCAgICAgW119LAogIHttb2RfbXVjLCAgICAg IFsKCQkgICUle2hvc3QsICJjb25mZXJlbmNlLkBIT1NUQCJ9LAoJCSAge2FjY2VzcywgbXVjfSwK CQkgIHthY2Nlc3NfY3JlYXRlLCBtdWN9LAoJCSAge2FjY2Vzc19wZXJzaXN0ZW50LCBtdWN9LAoJ CSAge2FjY2Vzc19hZG1pbiwgbXVjX2FkbWlufQoJCSBdfSwKICB7bW9kX2FkbWluX2V4dHJhLCAg W119LAogIHttb2Rfb2ZmbGluZV9vZGJjLCAgW119LAogIHttb2RfcHJpdmFjeV9vZGJjLCAgW119 LAogIHttb2RfcHJpdmF0ZV9vZGJjLCAgW119LAogIHttb2RfcmVnaXN0ZXIsIFsKCQkgIHt3ZWxj b21lX21lc3NhZ2UsIHsi0KPRgNCwISDQktGLINGBINC90LDQvNC4ISIsIAoJCQkJICAgICAi0KHQ stC10YDRiNC40LvQvtGB0YwhXG7QktGLINC/0L7QtNC60LvRjtGH0LjQu9C40YHRjCEifX0sCgkJ ICB7cmVnaXN0cmF0aW9uX3dhdGNoZXJzLCBbIjAwMEBvdS52LWludC5ydSJdfSwKCQkgIHthY2Nl c3MsIHJlZ2lzdGVyfQoJCSBdfSwKICB7bW9kX3Jvc3Rlcl9vZGJjLCAgIFtdfSwKICB7bW9kX3No YXJlZF9yb3N0ZXIsW119LAogIHttb2Rfc3RhdHNkeCwgIFt7aG9va3MsdHJ1ZX1dfSwKICB7bW9k X3RpbWUsICAgICBbXX0sCiAge21vZF92Y2FyZF9vZGJjLCAgICBbXX0sCiAge21vZF92ZXJzaW9u LCAgW119LAogIHttb2RfcmVnaXN0ZXJfd2ViLCBbXX0KIF19LgolJSUgTG9jYWwgVmFyaWFibGVz OgolJSUgbW9kZTogZXJsYW5nCiUlJSBFbmQ6CiUlJSB2aW06IHNldCBmaWxldHlwZT1lcmxhbmcg dGFic3RvcD04Ogo=