Enable xmpp

I followed
https://wiki.diasporafoundation.org/Integration/XMPP/Prosody
and
https://wiki.debian.org/Diaspora/XMPP

In the debian wiki instruction I'm not sure if I followed step 7 of creating users correctly. What I did was run

sudo -u postgres -i
createuser --interactive # n, n, n to all extra privileges
exit
sudo -u postgres psql
grant all privileges on database diaspora_production to prosody;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO prosody;

@praveenarimbrathod can you verify the above?

Prosody uses port 5222 and 5269 @saurabh can you open those ports?

@akshay Allowed the requested ports.

@akshay Do you have test accounts in diasp.in for checks ?

@akshay looks good to me, that should have been, add user prosody. We are creating a prosody user for postgresql, with peer auth active, prosody unix user can connect to postgresql as prosody postgresql user without password.

@fayadfami yes, I'm akshay@diasp.in
@praveenarimbrathod
I did name the user prosody :P

postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
diaspora | Create DB | {}
postgres | Superuser, Create role, Create DB, Replication | {}
prosody | | {}

It is connecting (thanks @saurabh for opening the port), but says password is wrong.

@akshay check the logs of prosody and postgresql

@akshay sudo -u postgres psql diaspora_production

GRANT SELECT ON ALL TABLES IN SCHEMA public TO prosody;

Ah! psql is the command. I was thinking it's the database all this while :P

That worked. Although I've no idea why there was no error on running grant select with no database selected.

xmpp is now enabled on diasp.in

Shall I start setting up bosh? :P

We should make a press release, I have started a draft here, contribute https://etherpad.mozilla.org/JabberPodderyDiaspIN

@akshay enable mod_smacks and mod_carbons and update both wikies.

Also do you want to try and make a diaspora-prosody package like we do for diaspora-installer? SSL config can be inside the VirtualHost and you just have to append that to prosody.cfg.lua