processone / ejabberd

Robust, Ubiquitous and Massively Scalable Messaging Platform (XMPP, MQTT, SIP Server)
https://www.process-one.net/en/ejabberd/
Other
6.09k stars 1.51k forks source link

Switching to SCRAM on PostgreSQL database for one vhost (for test) #1177

Closed drixter closed 8 years ago

drixter commented 8 years ago

What version of ejabberd are you using?

16.04

What operating system (version) are you using?

CentOS

How did you install ejabberd (source, package, distribution)?

RPM

What did not work as expected? Are there error messages in the log? What was the unexpected behavior? What was the expected result?

Following https://www.ejabberd.im/node/24818 added a additional column to the PostgreSQL table: ALTER TABLE users ADD COLUMN serverkey text NOT NULL DEFAULT ''; ALTER TABLE users ADD COLUMN salt text NOT NULL DEFAULT ''; ALTER TABLE users ADD COLUMN iterationcount integer NOT NULL DEFAULT 0;

And then:

[root@ip-172-22-164-94 bin]# ./ejabberdctl debug

IMPORTANT: we will attempt to attach an INTERACTIVE shell to an already running ejabberd node. If an ERROR is printed, it means the connection was not successful. You can interact with the ejabberd node if you know how to use it. Please be extremely cautious with your actions, and exit immediately if you are not completely sure.

To detach this shell from ejabberd, press: control+c, control+c


To bypass permanently this warning, add to ejabberdctl.cfg the line: EJABBERD_BYPASS_WARNINGS=true Press return to continue

Erlang/OTP 18 [erts-7.3] [source] [64-bit] [smp:1:1] [async-threads:10] [hipe] [ kernel-poll:true]

Eshell V7.3 (abort with ^G) (ejabberd@localhost)1> ejabberd_auth_odbc:convert_to_scram(<<"e-utp.net">>). * exception error: undefined function ejabberd_auth_odbc:convert_to_scram/1 (ejabberd@localhost)2> ejabberd_auth_odbc:convert_to_scram(<<"e-utp.net">>) (ejabberd@localhost)2> . * exception error: undefined function ejabberd_auth_odbc:convert_to_scram/1 (ejabberd@localhost)3>

Am I missing something?

drixter commented 8 years ago

done by ./ejabberdctl convert_to_scram e-utp.net

lock[bot] commented 5 years ago

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.