Prosody with Mysql backend migrated, no longer Working

128 views
Skip to first unread message

Simon Hönscheid

unread,
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

unread,
Aug 8, 2016, 8:58:43 AM8/8/16
to prosod...@googlegroups.com
Hi

Is LuaDBI installed on the system?
https://prosody.im/doc/depends#luadbi

regards

Simon Hönscheid

unread,
Aug 8, 2016, 9:18:30 AM8/8/16
to Prosody IM Users
Hi LK,

the Package is installed:

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

Kim Alvefur

unread,
Aug 8, 2016, 10:17:18 AM8/8/16
to prosod...@googlegroups.com
Hi,

On 2016-08-02 22:09, 'Simon Hönscheid' via Prosody IM Users wrote:
> storage = sql

You are missing quotes there.

--
Regards,
Kim "Zash" Alvefur

signature.asc
Reply all
Reply to author
Forward
0 new messages