Prosody with Mysql backend migrated, no longer Working
128 views
Skip to first unread message
Simon Hönscheid
Aug 2, 2016, 4:09:59 PM8/2/16
to Prosody IM Users
Hello List,
I migrated my Prosody Server with Mysql backend. Package is from Debian Jessie. DB was migrated using mysql dump.
The Login seems no longer possible: Prosody is looking for the user in flat file DB:
Aug 02 21:49:42 datamanager debug Assuming empty accounts storage ('cannot open /var/lib/prosody/jabber%2eexample%2ecom/accounts/user.dat: No such file or directory') for user: us...@jabber.example.com
My Config:
admins = {
}
prosody_user = "prosody"
prosody_group = "prosody"
interfaces = {
"0.0.0.0",
"::",
}
use_libevent = true;
modules_enabled = {
"roster";
"saslauth";
"tls";
"dialback";
"disco";
"posix";
"private";
"vcard";
"version";
"uptime";
"time";
"ping";
"pep";
"admin_adhoc";
};
modules_disabled = {};
allow_registration = false;
daemonize = true;
ssl = {
protocol = "tlsv1";
options = {
"no_ticket",
"no_compression",
"cipher_server_preference",
};
ciphers = "DH+AES:ECDH+AES:+ECDH+SHA:AES:!PSK:!SRP:!DSS:!ADH:!AECDH";
curve = "secp521r1";
dhparam = "";
}
c2s_require_encryption = true
s2s_require_encryption = true
s2s_secure_auth = true
s2s_insecure_domains = {
}
s2s_secure_domains = {
}
sql = { driver = "MySQL"; database = "prosody"; host = "localhost"; username = "prosody"; password = "xxxx"; }
storage = sql
pidfile = "/var/run/prosody/prosody.pid"
authentication = "internal_hashed"
log = {
error = "/var/log/prosody/prosody.err";
"*syslog";
}
Include "conf.d/*.cfg.lua"
Vhosts are defined in seperate config
Kind regards simon
lukn
Aug 8, 2016, 8:58:43 AM8/8/16
to prosod...@googlegroups.com
Simon Hönscheid
Aug 8, 2016, 9:18:30 AM8/8/16
to Prosody IM Users
Hi LK,
the Package is installed:
Kind Regards
dpkg -l|grep prosody
ii prosody 0.9.7-2+deb8u3 amd64 Lightweight Jabber/XMPP server
dpkg -l|grep lua
ii lua-dbi-common 0.5.hg5ba1dd988961-2 all DBI library for the Lua language, common files
ii lua-dbi-mysql:amd64 0.5.hg5ba1dd988961-2 amd64 DBI library for the Lua language, MySQL backend
ii lua-event:amd64 0.4.3-1 amd64 asynchronous event notification library for Lua
ii lua-expat:amd64 1.3.0-2 amd64 libexpat bindings for the Lua language
ii lua-filesystem:amd64 1.6.2-3 amd64 luafilesystem library for the Lua language
ii lua-sec:amd64 0.5-1 amd64 SSL socket library for the Lua language
ii lua-socket:amd64 3.0~rc1-3 amd64 TCP/UDP socket library for the Lua language
ii lua5.1 5.1.5-7.1 amd64 Simple, extensible, embeddable programming language
Kind Regards
Simon
0 new messages