Looking for ejabberd docs?

To access the most up-to-date ejabberd documentation, please visit docs.ejabberd.im »

ejabberd 13.10 mysql problem

Submitted by larry_kong on Fri, 2013-11-08 19:13

ejabberd Development

I have install the ejabberd 13.10. I cannot start it by using mysql. No sure what I did wrong. Please help?

1: odbc.ini
Driver = MySQL
DATABASE = ejabberd
PWD = secret
SERVER = localhost
SOCKET = /var/lib/mysql/mysql.sock
UID = root

2: changed two lines in ejabberd.cfg
{odbc_server, {mysql, "localhost", "ejabberd", "root", "secret"}}.
{mod_last, [{db_type, odbc}]},

start ejabberd by:
# .//ejabberdctl live

[critical] failed to start application 'p1_mysql': {error,
{"no such file or directory",
"p1_mysql.app"}}

Crash dump was written to: /opt/ejabberd-13.10/logs/erl_crash_20131108-140530.dump
failed to start application 'p1_mysql': {error,
{"no such file or directory",
"p1_mysql.app"}}

Did I missed anything? Where is p1_mysql.app? Thanks!

p1_mysql.app should be

Submitted by mfoss on Mon, 2013-11-25 11:02.

p1_mysql.app should be included, or automatically downloaded/compiled by ejabberd, so it's strange it isn't already there. How did you install ejabberd: source package, git master branch, binary installer...?

Thank you for your reply: I

Submitted by larry_kong on Mon, 2013-12-02 05:15.

Thank you for your reply:

I installed ejabberd-2.1.13-linux-x86_64-installer.run on CentOS 6.4 by using the following commands:

# yum install ImageMagick
# rpm -hiv libyaml-0.1.4-1.el6.rf.x86_64.rpm
# chmod a+x ejabberd-13.10-linux-x86_64-installer.run
# ./ejabberd-13.10-linux-x86_64-installer.run
# mysqladmin -p create ejabberd
# mysql -p ejabberd < /opt/ejabberd-13.10/lib/ejabberd-13.10/priv/sql/mysql.sql

Made the change of the configuration file as described in early message and copy it over to /opt/ejabberd-13.10/conf

# /opt/ejabberd-13.10/bin/ejabberdctl live
Got the following errors:

19:03:50.520 [debug] Supervisor ejabberd_sup started ejabberd_tmp_sup:start_link(ejabberd_iq_sup, gen_iq_handler) at pid <0.352.0>
19:03:50.521 [critical] failed to start application 'p1_mysql': {error,
{"no such file or directory",
"p1_mysql.app"}}
19:03:50.522 [debug] Supervisor ejabberd_sup started ejabberd_tmp_sup:start_link(ejabberd_frontend_socket_sup, ejabberd_frontend_socket) at pid <0.353.0>
19:03:50.523 [debug] Supervisor ejabberd_sup started ejabberd_listener:start_link() at pid <0.354.0>

Crash dump was written to: /opt/ejabberd-13.10/logs/erl_crash_20131019-190347.dump
failed to start application 'p1_mysql': {error,
{"no such file or directory",
"p1_mysql.app"}}

I have the same problem. when

Submitted by marcus1989 on Wed, 2013-12-04 16:28.

I have the same problem. when i compile ejabberd 13.10 with mysql i get this
I got my source from the website. I will try the git version too.

root@ubuntu:/home/marcus/ejabberd# ./configure --enable-mysql
checking whether make sets $(MAKE)... yes
checking for a BSD-compatible install... /usr/bin/install -c
checking for a sed that does not truncate output... /bin/sed
checking for erl... /usr/bin/erl
checking for erlc... /usr/bin/erlc
checking for erl... /usr/bin/erl
checking for erlc... /usr/bin/erlc
checking Erlang/OTP version... ok
checking for Erlang/OTP root directory... /usr/lib/erlang
checking for escript... /usr/lib/erlang/bin/escript
checking for make... make
checking for Erlang/OTP 'sasl' library subdirectory... /usr/lib/erlang/lib/sasl-2.2.1
checking for Erlang/OTP 'sasl' library version... 2.2.1
checking for Erlang/OTP 'crypto' library subdirectory... /usr/lib/erlang/lib/crypto-2.1
checking for Erlang/OTP 'crypto' library version... 2.1
checking for Erlang/OTP 'public_key' library subdirectory... /usr/lib/erlang/lib/public_key-0.15
checking for Erlang/OTP 'public_key' library version... 0.15
checking for Erlang/OTP 'ssl' library subdirectory... /usr/lib/erlang/lib/ssl-5.0.1
checking for Erlang/OTP 'ssl' library version... 5.0.1
checking for Erlang/OTP 'mnesia' library subdirectory... /usr/lib/erlang/lib/mnesia-4.7
checking for Erlang/OTP 'mnesia' library version... 4.7
checking for Erlang/OTP 'inets' library subdirectory... /usr/lib/erlang/lib/inets-5.9
checking for Erlang/OTP 'inets' library version... 5.9
checking for Erlang/OTP 'compiler' library subdirectory... /usr/lib/erlang/lib/compiler-4.8.1
checking for Erlang/OTP 'compiler' library version... 4.8.1
configure: creating ./config.status
config.status: creating Makefile
config.status: creating vars.config
config.status: creating src/ejabberd.app.src
root@ubuntu:/home/marcus/ejabberd# make
/usr/lib/erlang/bin/escript rebar skip_deps=true compile
==> rel (compile)
==> ejabberd (compile)
Dependency not available: p1_mysql-.* ({git,
                                        "git://github.com/processone/mysql"})
ERROR: compile failed while processing /home/marcus/ejabberd: rebar_abort
make: *** [src] Error 1
root@ubuntu:/home/marcus/ejabberd# 

Then i thought maybe it worked so i try to run the ejabberd server

But i get this:

16:06:23.425 [critical] failed to start application 'p1_mysql': {error,
                                         {"no such file or directory",
                                          "p1_mysql.app"}}

If you need anymore info on this please ask

Try running: ./rebar

Submitted by mfoss on Thu, 2013-12-12 14:43.

Try running:

./rebar get-deps

and then again:

make