fenek
commented
5 years ago Hi @igorcferreira
It seems to me that you've recently migrated to MongooseIM 3.2.0 from some older version, is it correct? If so, then a method of configuring database connections has changed significantly and everything is described in https://mongooseim.readthedocs.io/en/latest/migrations/3.1.1_3.2.0/
igorcferreira
MongooseIM version: master Installed from: source Erlang/OTP version: 21
I'm trying to configure a MongooseIM server, and, when trying to connect Postgres server, the application fails with the error
{pool,rdbms,default}. Unfortunately, the error messages and logs do not provide any useful information regarding of where the error can be.I tested the Postegres connection, and it is possible to connect through TCP into the database configured, with the user that is passed in the configuration file. And the database was configured using the pg.sql file available in the priv folder.
Is there something that I'm missing? Or, is there any way to get a better report of what can be the issue?
Error:
Configuration file:
%%% %%% ejabberd configuration file %%% %%%' %%% The parameters used in this configuration file are explained in more detail %%% in the ejabberd Installation and Operation Guide. %%% Please consult the Guide in case of doubts, it is included with %%% your copy of ejabberd, and is also available online at %%% http://www.process-one.net/en/ejabberd/docs/ %%% This configuration file contains Erlang terms. %%% In case you want to understand the syntax, here are the concepts: %%% %%% - The character to comment a line is % %%% %%% - Each term ends in a dot, for example: %%% override_global. %%% %%% - A tuple has a fixed definition, its elements are %%% enclosed in {}, and separated with commas: %%% {loglevel, 4}. %%% %%% - A list can have as many elements as you want, %%% and is enclosed in [], for example: %%% [http_poll, web_admin, tls] %%% %%% Pay attention that list elements are delimited with commas, %%% but no comma is allowed after the last list element. This will %%% give a syntax error unlike in more lenient languages (e.g. Python). %%% %%% - A keyword of ejabberd is a word in lowercase. %%% Strings are enclosed in "" and can contain spaces, dots, ... %%% {language, "en"}. %%% {ldap_rootdn, "dc=example,dc=com"}. %%% %%% - This term includes a tuple, a keyword, a list, and two strings: %%% {hosts, ["jabber.example.net", "im.example.com"]}. %%% %%% - This config is preprocessed during release generation by a tool which %%% interprets double curly braces as substitution markers, so avoid this %%% syntax in this file (though it's valid Erlang). %%% %%% So this is OK (though arguably looks quite ugly): %%% { {s2s_addr, "example-host.net"}, {127,0,0,1} }. %%% %%% And I can't give an example of what's not OK exactly because %%% of this rule. %%% %%%. ======================= %%%' OVERRIDE STORED OPTIONS %% %% Override the old values stored in the database. %% %% %% Override global options (shared by all ejabberd nodes in a cluster). %% %%override_global. %% %% Override local options (specific for this particular ejabberd node). %% %%override_local. %% %% Remove the Access Control Lists before new ones are added. %% %%override_acls. %%%. ========= %%%' DEBUGGING %% %% loglevel: Verbosity of log files generated by ejabberd. %% 0: No ejabberd log at all (not recommended) %% 1: Critical %% 2: Error %% 3: Warning %% 4: Info %% 5: Debug %% {loglevel, 5}. %%%. ================ %%%' SERVED HOSTNAMES %% %% hosts: Domains served by ejabberd. %% You can define one or several, for example: %% {hosts, ["example.net", "example.com", "example.org"]}. %% {hosts, ["localhost"] }. %% %% route_subdomains: Delegate subdomains to other XMPP servers. %% For example, if this ejabberd serves example.org and you want %% to allow communication with an XMPP server called im.example.org. %% %%{route_subdomains, s2s}. %%%. =============== %%%' LISTENING PORTS %% %% listen: The ports ejabberd will listen on, which service each is handled %% by and what options to start it with. %% {listen, [ %% BOSH and WS endpoints over HTTP { 5280, ejabberd_cowboy, [ {num_acceptors, 10}, {transport_options, [{max_connections, 1024}]}, {modules, [ {"_", "/http-bind", mod_bosh}, {"_", "/ws-xmpp", mod_websockets, []} ]} ]}, %% BOSH and WS endpoints over HTTPS { 5285, ejabberd_cowboy, [ {num_acceptors, 10}, {transport_options, [{max_connections, 1024}]}, {ssl, [{certfile, "priv/ssl/fake_cert.pem"}, {keyfile, "priv/ssl/fake_key.pem"}, {password, ""}]}, {modules, [ {"_", "/http-bind", mod_bosh}, {"_", "/ws-xmpp", mod_websockets, [ %% Uncomment to enable connection dropping or/and server-side pings %{timeout, 600000}, {ping_rate, 60000} ]} %% Uncomment to serve static files %{"_", "/static/[...]", cowboy_static, % {dir, "/var/www", [{mimetypes, cow_mimetypes, all}]} %}, ]} ]}, %% MongooseIM HTTP API it's important to start it on localhost %% or some private interface only (not accessible from the outside) %% At least start it on different port which will be hidden behind firewall { {8088, "127.0.0.1"} , ejabberd_cowboy, [ {num_acceptors, 10}, {transport_options, [{max_connections, 1024}]}, {modules, [ {"localhost", "/api", mongoose_api_admin, []} ]} ]}, { 8089 , ejabberd_cowboy, [ {num_acceptors, 10}, {transport_options, [{max_connections, 1024}]}, {protocol_options, [{compress, true}]}, {ssl, [{certfile, "priv/ssl/fake_cert.pem"}, {keyfile, "priv/ssl/fake_key.pem"}, {password, ""}]}, {modules, [ {"_", "/api/sse", lasse_handler, [mongoose_client_api_sse]}, {"_", "/api/messages/[:with]", mongoose_client_api_messages, []}, {"_", "/api/contacts/[:jid]", mongoose_client_api_contacts, []}, {"_", "/api/rooms/[:id]", mongoose_client_api_rooms, []}, {"_", "/api/rooms/[:id]/config", mongoose_client_api_rooms_config, []}, {"_", "/api/rooms/:id/users/[:user]", mongoose_client_api_rooms_users, []}, {"_", "/api/rooms/[:id]/messages", mongoose_client_api_rooms_messages, []} ]} ]}, %% Following HTTP API is deprected, the new one abouve should be used instead { {5288, "127.0.0.1"} , ejabberd_cowboy, [ {num_acceptors, 10}, {transport_options, [{max_connections, 1024}]}, {modules, [ {"localhost", "/api", mongoose_api, [{handlers, [mongoose_api_metrics, mongoose_api_users]}]} ]} ]}, { 5222, ejabberd_c2s, [ %% %% If TLS is compiled in and you installed a SSL %% certificate, specify the full path to the %% file and uncomment this line: %% {certfile, "priv/ssl/fake_server.pem"}, starttls, %%{zlib, 10000}, %% https://www.openssl.org/docs/apps/ciphers.html#CIPHER_STRINGS %% {ciphers, "DEFAULT:!EXPORT:!LOW:!SSLv2"}, {access, c2s}, {shaper, c2s_shaper}, {max_stanza_size, 65536}, {protocol_options, ["no_sslv3"]} ]}, %% %% To enable the old SSL connection method on port 5223: %% %%{5223, ejabberd_c2s, [ %% {access, c2s}, %% {shaper, c2s_shaper}, %% {certfile, "/path/to/ssl.pem"}, tls, %% {max_stanza_size, 65536} %% ]}, { 5269, ejabberd_s2s_in, [ {shaper, s2s_shaper}, {max_stanza_size, 131072}, {protocol_options, ["no_sslv3"]} ]} %% %% ejabberd_service: Interact with external components (transports, ...) %% ,{8888, ejabberd_service, [ {access, all}, {shaper_rule, fast}, {ip, {127, 0, 0, 1}}, {password, "secret"} ]} %% %% ejabberd_stun: Handles STUN Binding requests %% %%{ {3478, udp}, ejabberd_stun, []} ]}. %% %% s2s_use_starttls: Enable STARTTLS + Dialback for S2S connections. %% Allowed values are: false optional required required_trusted %% You must specify a certificate file. %% {s2s_use_starttls, optional}. %% %% s2s_certfile: Specify a certificate file. %% {s2s_certfile, "priv/ssl/fake_server.pem"}. %% https://www.openssl.org/docs/apps/ciphers.html#CIPHER_STRINGS %% {s2s_ciphers, "DEFAULT:!EXPORT:!LOW:!SSLv2"}. %% %% domain_certfile: Specify a different certificate for each served hostname. %% %%{domain_certfile, "example.org", "/path/to/example_org.pem"}. %%{domain_certfile, "example.com", "/path/to/example_com.pem"}. %% %% S2S whitelist or blacklist %% %% Default s2s policy for undefined hosts. %% {s2s_default_policy, deny }. %% %% Allow or deny communication with specific servers. %% %%{ {s2s_host, "goodhost.org"}, allow}. %%{ {s2s_host, "badhost.org"}, deny}. {outgoing_s2s_port, 5269 }. %% %% IP addresses predefined for specific hosts to skip DNS lookups. %% Ports defined here take precedence over outgoing_s2s_port. %% Examples: %% %% { {s2s_addr, "example-host.net"}, {127,0,0,1} }. %% { {s2s_addr, "example-host.net"}, { {127,0,0,1}, 5269 } }. %% { {s2s_addr, "example-host.net"}, { {127,0,0,1}, 5269 } }. %% %% Outgoing S2S options %% %% Preferred address families (which to try first) and connect timeout %% in milliseconds. %% %%{outgoing_s2s_options, [ipv4, ipv6], 10000}. %% %%% ============== %%% OUTGOING CONNECTION POOLS % {outgoing_pools, [ % {riak, global, default, [{workers, 5}], [{address, "127.0.0.1"}, {port, 8087}]} % ]}. %%%. ============== %%%' SESSION BACKEND %%{sm_backend, {mnesia, []}}. %%{sm_backend, {redis, [{pool_size, 3}, {worker_config, [{host, "localhost"}, {port, 6379}]}]}}. {sm_backend, {mnesia, []} }. %%%. ============== %%%' AUTHENTICATION {auth_method, internal }. {auth_opts, [ {password_formet, "scram"} ]}. %%%. ============== %%%' DATABASE SETUP %% ejabberd by default uses the internal Mnesia database, %% so you do not necessarily need this section. %% This section provides configuration examples in case %% you want to use other database backends. %% Please consult the ejabberd Guide for details on database creation. %% %% MySQL server: %% %%{rdbms_server, {mysql, "localhost", 3306, "ejabberd_local", "ejabberd", "ejabberd"}}. %% %% If you want to specify the port: %%{rdbms_server, {mysql, "server", 1234, "database", "username", "password"}}. %% %% PostgreSQL server: %% {rdbms_server, {pgsql, "mongooseim-postgres", "mongooseim", "mongooseim", "mongooseim"}}. %% %% If you want to specify the port: %%{rdbms_server, {pgsql, "server", 1234, "database", "username", "password"}}. %% %% If you use PostgreSQL, have a large database, and need a %% faster but inexact replacement for "select count(*) from users" %% {pgsql_users_number_estimate, true}. %% %% RDBMS compatible or MSSQL server: %% %%{rdbms_server, "DSN=ejabberd;UID=ejabberd;PWD=ejabberd"}. %% Specifies what database is used over the RDBMS layer %% Can take values rdbms, pgsql, mysql %% In some cases (for example for MAM with pgsql) it is required to set proper value. {rdbms_server_type, pgsql}. %% %% Number of connections to open to the database for each virtual host %% {rdbms_pool_size, 10}. %% Enable the default database connection pool {pool, rdbms, default}. %% Interval to make a dummy SQL request to keep the connections to the %% database alive. Specify in seconds: for example 28800 means 8 hours %% {rdbms_keepalive_interval, undefined}. %%% ==================== %%% RIAK SETUP %%% ==================== %%{riak_server, [{pool_size, 20}, {address, "127.0.0.1"}, {port, 8087}, {riak_pb_socket_opts, []}]}. %% %% %%% ==================== %%% CASSANDRA SETUP %%% ==================== %%{cassandra_servers, [{default, []}]}. %% Connect to localhost:9042, one worker, one pool, shared between all hosts %%{cassandra_servers, [{default, []}]}. %% ALTERNATIVE CONFIGURATION: Custom server address %% - 100 connections to all four Cassandra servers in total %% - Keyspace "big_mongooseim" %% %%{cassandra_servers, %% [ %% {default, 100, %% [ %% {servers, %% [ %% {"cassandra_server1.example.com", 9042}, %% {"cassandra_server2.example.com", 9042}, %% {"cassandra_server3.example.com", 9042}, %% {"cassandra_server4.example.com", 9042} %% ] %% }, %% {keyspace, "big_mongooseim"} %% ] %% } %% ] %%}. %% ALTERNATIVE CONFIGURATION: Two pools: for mam and for mam_muc %% - Each pool uses different keyspace %% - Module mod_mam_cassandra_arch uses pool "mam" and keyspace "mam_space" %% - Module mod_mam_muc_cassandra_arch uses pool "mam_muc" and keyspace "mam_muc_space" %% %% Set pool_name for modules like this (not just uncomment this example!) %% {modules, %% [{mod_mam_cassandra_arch, [{pool_name, mam}]}, %% {mod_mam_muc_cassandra_arch, [{pool_name, mam_muc}]}]}. %% %%{cassandra_servers, [{mam, [{keyspace, "mam_space"}]}, {mam_muc, [{keyspace, "mam_muc_space"}]}]}. %%% ==================== %%% ELASTICSEARCH SETUP %%% ==================== %%{elasticsearch_server, []}. %% %% Choose arbitrary hostname and port. %% {elasticsearch_server, [{host, "es.server.example.com"}, {port, 9123}]}. %%%. =============== %%%' TRAFFIC SHAPERS %% %% The "normal" shaper limits traffic speed to 1000 B/s %% {shaper, normal, {maxrate, 1000}}. %% %% The "fast" shaper limits traffic speed to 50000 B/s %% {shaper, fast, {maxrate, 50000}}. %% %% This option specifies the maximum number of elements in the queue %% of the FSM. Refer to the documentation for details. %% {max_fsm_queue, 1000}. %%%. ==================== %%%' ACCESS CONTROL LISTS %% %% The 'admin' ACL grants administrative privileges to XMPP accounts. %% You can put here as many accounts as you want. %% {acl, admin, {user, "igor", "localhost"}}. %{acl, admin, {user, "a", "localhost"}}. %% %% Blocked users %% %%{acl, blocked, {user, "baduser", "example.org"}}. %%{acl, blocked, {user, "test"}}. %% %% Local users: don't modify this line. %% {acl, local, {user_regexp, ""}}. %% %% More examples of ACLs %% %%{acl, jabberorg, {server, "jabber.org"}}. %%{acl, aleksey, {user, "aleksey", "jabber.ru"}}. %%{acl, test, {user_regexp, "^test"}}. %%{acl, test, {user_glob, "test*"}}. %% %% Define specific ACLs in a virtual host. %% %%{host_config, "localhost", %% [ %% {acl, admin, {user, "bob-local", "localhost"}} %% ] %%}. %%%. ============ %%%' ACCESS RULES %% Maximum number of simultaneous sessions allowed for a single user: {access, max_user_sessions, [{10, all}]}. %% Maximum number of offline messages that users can have: {access, max_user_offline_messages, [{5000, admin}, {100, all}]}. %% This rule allows access only for local users: {access, local, [{allow, local}]}. %% Only non-blocked users can use c2s connections: {access, c2s, [{deny, blocked}, {allow, all}]}. %% For C2S connections, all users except admins use the "normal" shaper {access, c2s_shaper, [{none, admin}, {normal, all}]}. %% All S2S connections use the "fast" shaper {access, s2s_shaper, [{fast, all}]}. %% Admins of this server are also admins of the MUC service: {access, muc_admin, [{allow, admin}]}. %% Only accounts of the local ejabberd server can create rooms: {access, muc_create, [{allow, local}]}. %% All users are allowed to use the MUC service: {access, muc, [{allow, all}]}. %% In-band registration allows registration of any possible username. %% To disable in-band registration, replace 'allow' with 'deny'. {access, register, [{allow, all}]}. %% By default the frequency of account registrations from the same IP %% is limited to 1 account every 10 minutes. To disable, specify: infinity {registration_timeout, infinity}. %% Default settings for MAM. %% To set non-standard value, replace 'default' with 'allow' or 'deny'. %% Only user can access his/her archive by default. %% An online user can read room's archive by default. %% Only an owner can change settings and purge messages by default. %% Empty list (i.e. `[]`) means `[{deny, all}]`. {access, mam_set_prefs, [{default, all}]}. {access, mam_get_prefs, [{default, all}]}. {access, mam_lookup_messages, [{default, all}]}. {access, mam_purge_single_message, [{default, all}]}. {access, mam_purge_multiple_messages, [{default, all}]}. %% 1 command of the specified type per second. {shaper, mam_shaper, {maxrate, 1}}. %% This shaper is primeraly for Mnesia overload protection during stress testing. %% The limit is 1000 operations of each type per second. {shaper, mam_global_shaper, {maxrate, 1000}}. {access, mam_set_prefs_shaper, [{mam_shaper, all}]}. {access, mam_get_prefs_shaper, [{mam_shaper, all}]}. {access, mam_lookup_messages_shaper, [{mam_shaper, all}]}. {access, mam_purge_single_message_shaper, [{mam_shaper, all}]}. {access, mam_purge_multiple_messages_shaper, [{mam_shaper, all}]}. {access, mam_set_prefs_global_shaper, [{mam_global_shaper, all}]}. {access, mam_get_prefs_global_shaper, [{mam_global_shaper, all}]}. {access, mam_lookup_messages_global_shaper, [{mam_global_shaper, all}]}. {access, mam_purge_single_message_global_shaper, [{mam_global_shaper, all}]}. {access, mam_purge_multiple_messages_global_shaper, [{mam_global_shaper, all}]}. %% %% Define specific Access Rules in a virtual host. %% %%{host_config, "localhost", %% [ %% {access, c2s, [{allow, admin}, {deny, all}]}, %% {access, register, [{deny, all}]} %% ] %%}. %%%. ================ %%%' DEFAULT LANGUAGE %% %% language: Default language used for server messages. %% {language, "en"}. %% %% Set a different default language in a virtual host. %% %%{host_config, "localhost", %% [{language, "ru"}] %%}. %%%. ================ %%%' MISCELLANEOUS {all_metrics_are_global, false }. %%%. ======== %%%' SERVICES %% Unlike modules, services are started per node and provide either features which are not %% related to any particular host, or backend stuff which is used by modules. %% This is handled by `mongoose_service` module. {services, [ {service_admin_extra, [{submods, [node, accounts, sessions, vcard, roster, last, private, stanza, stats]}]} ] }. %%%. ======= %%%' MODULES %% %% Modules enabled in all mongooseim virtual hosts. %% For list of possible modules options, check documentation. %% {modules, [ %% The format for a single route is as follows: %% {Host, Path, Method, Upstream} %% %% "_" can be used as wildcard for Host, Path and Method %% Upstream can be either host (just http(s)://host:port) or uri %% The difference is that host upstreams append whole path while %% uri upstreams append only remainder that follows the matched Path %% (this behaviour is similar to nginx's proxy_pass rules) %% %% Bindings can be used to match certain parts of host or path. %% They will be later overlaid with parts of the upstream uri. %% %% {mod_revproxy, %% [{routes, [{"www.erlang-solutions.com", "/admin", "_", %% "https://www.erlang-solutions.com/"}, %% {":var.com", "/:var", "_", "http://localhost:8080/"}, %% {":domain.com", "/", "_", "http://localhost:8080/:domain"}] %% }]}, % {mod_http_upload, [ %% Set max file size in bytes. Defaults to 10 MB. %% Disabled if value is `undefined`. % {max_file_size, 1024}, %% Use S3 storage backend % {backend, s3}, %% Set options for S3 backend % {s3, [ % {bucket_url, "http://s3-eu-west-1.amazonaws.com/konbucket2"}, % {region, "eu-west-1"}, % {access_key_id, "AKIAIAOAONIULXQGMOUA"}, % {secret_access_key, "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"} % ]} % ]}, {mod_adhoc, []}, {mod_disco, [{users_can_see_hidden_services, false}]}, {mod_commands, []}, {mod_muc_commands, []}, {mod_muc_light_commands, []}, {mod_last, []}, {mod_stream_management, [ % default 100 % size of a buffer of unacked messages % {buffer_max, 100} % default 1 - server sends the ack request after each stanza {ack_freq, 1}, % default: 600 seconds {resume_timeout, 10} ]}, {mod_muc_light, [{host, "muclight.@HOST@"},{backend,rdbms},{max_occupants, 50},{rooms_per_page, 50}]}, %% {mod_muc, [{host, "muc.@HOST@"}, %% {access, muc}, %% {access_create, muc_create} %% ]}, %% {mod_muc_log, [ %% {outdir, "/tmp/muclogs"}, %% {access_log, muc} %% ]}, %%{mod_offline, [{backend,rdbms},{access_max_user_messages, max_user_offline_messages}]}, {mod_privacy, []}, {mod_blocking, []}, {mod_private, []}, % {mod_private, [{backend, mnesia}]}, % {mod_private, [{backend, rdbms}]}, {mod_register, [ %% %% Set the minimum informational entropy for passwords. %% %%{password_strength, 32}, %% %% After successful registration, the user receives %% a message with this subject and body. %% {welcome_message, {""}}, %% %% When a user registers, send a notification to %% these XMPP accounts. %% %% %% Only clients in the server machine can register accounts %% {ip_access, [{allow, "127.0.0.0/8"}, {deny, "0.0.0.0/0"}]}, %% %% Local c2s or remote s2s users cannot register accounts %% %%{access_from, deny}, {access, register} ]}, {mod_roster, [{backend,rdbms}]}, {mod_recent_chats, [{backend,rdbms}]}, {mod_sync_contact, [{backend,rdbms}]}, {mod_sic, []}, {mod_vcard, [%{matches, 1}, %{search, true}, %{ldap_search_operator, 'or'}, %% either 'or' or 'and' %{ldap_binary_search_fields, [<<"PHOTO">>]}, %% list of binary search fields (as in vcard after mapping) {host, "vjud.@HOST@"} ]}, {mod_bosh, []}, {mod_carboncopy, []}, %% %% Message Archive Management (MAM, XEP-0313) for registered users and %% Multi-User chats (MUCs). %% % {mod_mam_meta, [ %% Use RDBMS backend (default) % {backend, rdbms}, %% Do not store user preferences (default) % {user_prefs_store, false}, %% Store user preferences in RDBMS % {user_prefs_store, rdbms}, %% Store user preferences in Mnesia (recommended). %% The preferences store will be called each time, as a message is routed. %% That is why Mnesia is better suited for this job. % {user_prefs_store, mnesia}, %% Enables a pool of asynchronous writers. (default) %% Messages will be grouped together based on archive id. % {async_writer, true}, %% Cache information about users (default) % {cache_users, true}, %% Enable archivization for private messages (default) % {pm, [ %% Top-level options can be overriden here if needed, for example: % {async_writer, false} % ]}, %% %% Message Archive Management (MAM) for multi-user chats (MUC). %% Enable XEP-0313 for "muc.@HOST@". %% % {muc, [ % {host, "muc.@HOST@"} %% As with pm, top-level options can be overriden for MUC archive % ]}, % %% Do not use a