codema.in
Thu 28 May 2015 3:20PM

Enable xmpp

A Akshay Public Seen by 370

Poddery.com has xmpp enabled. https://poddery.com/posts/1820692
We can enable it too

A

Akshay Thu 28 May 2015 3:24PM

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?

S

Saurabh Thu 28 May 2015 3:36PM

@akshay Allowed the requested ports.

FF

Fayad Fami Thu 28 May 2015 4:02PM

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

PP

Pirate Praveen Thu 28 May 2015 4:26PM

@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.

A

Akshay Thu 28 May 2015 4:33PM

@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.

PP

Pirate Praveen Thu 28 May 2015 4:47PM

@akshay check the logs of prosody and postgresql

PP

Pirate Praveen Thu 28 May 2015 4:59PM

@akshay sudo -u postgres psql diaspora_production

GRANT SELECT ON ALL TABLES IN SCHEMA public TO prosody;

A

Akshay Thu 28 May 2015 5:03PM

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

PP

Pirate Praveen Fri 29 May 2015 5:14AM

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

PP

Pirate Praveen Fri 29 May 2015 6:20AM

@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

Load More