Re: Add users and multi mysql
Dnia 2012-03-21, śro o godzinie 17:39 -0500, Ladar Levison pisze: I use a custom authreg plugin for authentication that uses the same auth database as the rest of my website BTW, this is intentionally hidden feature, but you're able to define DB queries for RDBMS authreg plugins in c2s.xml config file, without modyfing jabberd2 code. Just define authreg.mysql.sql.create authreg.mysql.sql.select authreg.mysql.sql.setpassword authreg.mysql.sql.delete See https://github.com/Jabberd2/jabberd2/blob/master/storage/authreg_mysql.c#L476 or https://github.com/Jabberd2/jabberd2/blob/master/storage/authreg_pgsql.c#L443 for default queries and work from there. While I have your attention, I noticed the link to the ChangeLog at http://codex.xiaoka.com/wiki/jabberd2:start uses the wrong Github account Thanks for the info. Fixed. -- Tomasz Sterna Instant Messaging Consultant : Open Source Developer http://tomasz.sterna.tv/ http://www.xiaoka.com/portfolio
Re: Add users and multi mysql
Dnia 2012-03-21, śro o godzinie 16:59 -0600, Stephen Mahood pisze: Would this support a sasl with Channel Binding? (I will admit I am not entirely familiar with channel binding) http://xmpp.org/rfcs/rfc3920.html#rfc.section.14.6 Looks like XMPP does not support channel binding. -- Tomasz Sterna Instant Messaging Consultant : Open Source Developer http://tomasz.sterna.tv/ http://www.xiaoka.com/portfolio
Re: Add users and multi mysql
Dne 21.3.2012 23:20, Tomasz Sterna napsal(a): Dnia 2012-03-21, śro o godzinie 22:50 +0100, Marek Červenka pisze: i'm modified PBX integration to set highest possible priority. now my contacts can see that i'm on the phone BUT if they send me message, the message is lost because PBX module cannot receive messages i can sponsor patch which reroute the message for PBX module to highest priority connected client. programmers? dont write me all ;) Could you create a feature request on Launchpad for this? i cant find feature request method. i filled bug https://bugs.launchpad.net/jabberd2/+bug/961958 -- --- Marek Cervenka ===
Re: Add users and multi mysql
Dne 21.3.2012 23:17, Tomasz Sterna napsal(a): P.S. If anyone volunteers to fix the documentation, I will be more than happy. :-) [1] https://github.com/Jabberd2/jabberd2/blob/master/etc/c2s.xml.dist.in [2] https://github.com/Jabberd2/jabberd2/blob/master/etc/sm.xml.dist.in [3] https://github.com/Jabberd2/jabberd2/wiki/InstallGuide-CommonConfigurationTasks we will be happy if you will be happy ;) we will try fix the documentation BUT what will be the final state? everything on github? everything on github except launchpad for bugs? what will be the primary website (google indexing and marketing)? i offered you www.jabberd2.org domain. i redirected *.jabberd2.org to http://codex.xiaoka.com/wiki/ NOW (registrator doesnt support : in this url http://codex.xiaoka.com/wiki/jabberd2:start) https://github.com/Jabberd2/jabberd2/wiki/InstallGuide-CommonConfigurationTasks this document is not linked from github wiki imho -- --- Marek Cervenka ===
Re: Add users and multi mysql
On Thu, 03/22/12 3:24 AM, Tomasz Sterna wrote: BTW, this is intentionally hidden feature, but you're able to define DB queries for RDBMS authreg plugins in c2s.xml config file, without modyfing jabberd2 code. Just define authreg.mysql.sql.create authreg.mysql.sql.select authreg.mysql.sql.setpassword authreg.mysql.sql.delete Alas my plugin does more than execute a SQL query. I had to build logic that strips off the domain portion of the username if its lavabit.com but leave it intact for everyone else. Then I run the cleansed username and plain text password through SHA 512. The SQL query then searches the database for a match. If that fails, I look for a matching email address in the mailboxes table and use that to map back to a username so I can repeat the process with the correct username... I also added logic to detect and handle situations where the credentials are valid, but the account is locked. Or if the account is configured to require SSL for access, I'll check the connection status and enforce that rule on XMPP connections. There are a few more things its doing, but I'd have to check the code to get the list accurate. :)
Re: Add users and multi mysql
On Wed, 03/21/12 11:38 AM, Stephen Mahood wrote: Hi I am researching different jabber server software and do like the xml approach of jabberd2.x but I have a couple of questions. Namely the setup we are looking at is a a central server to run the software, but to have multiple VPN having the ability to create jabber accounts specific to their address (virtual hosting) but the other thing we want to restrict the creating of accounts to the local mysql for the virtual hosted site. Is that feasible with jabberd2.x? Stephen I second that request. Specifically the ability to support new domains without having to launch instances of 'sm' for each one. Not to mention creating a new config file, and updating the 'c2s' config file. (I think it was 'c2s'.) It should be possible to support a new domain with a single line in the XML config... and down the road, perhaps the ability to control support for alternate/alias/child domains via the database? P.S. I'll probably wait for the 2.3.0 release, since my system seems to be stable. Might I suggest a 2.3.0 release candidate? Personally I've lost track of the new features were introduced by the last couple of releases and/or in development. I've seen mention of PBX support which I'll probably need to investigate since I have no idea what that means or its impact? When I hear PBX I think of private branch exchange, or voice/video support via a protocol like SIP. Is jabberd2 adding support for this? Or does PBX mean integration with something like Asterisk?
Re: Add users and multi mysql
Dne 21.3.2012 21:12, Ladar Levison napsal(a): On Wed, 03/21/12 11:38 AM, Stephen Mahood wrote: Hi I am researching different jabber server software and do like the xml approach of jabberd2.x but I have a couple of questions. Namely the setup we are looking at is a a central server to run the software, but to have multiple VPN having the ability to create jabber accounts specific to their address (virtual hosting) but the other thing we want to restrict the creating of accounts to the local mysql for the virtual hosted site. Is that feasible with jabberd2.x? Stephen I second that request. Specifically the ability to support new domains without having to launch instances of 'sm' for each one. Not to mention creating a new config file, and updating the 'c2s' config file. (I think it was 'c2s'.) It should be possible to support a new domain with a single line in the XML config... and down the road, perhaps the ability to control support for alternate/alias/child domains via the database? P.S. I'll probably wait for the 2.3.0 release, since my system seems to be stable. Might I suggest a 2.3.0 release candidate? Personally I've lost track of the new features were introduced by the last couple of releases and/or in development. I've seen mention of PBX support which I'll probably need to investigate since I have no idea what that means or its impact? When I hear PBX I think of private branch exchange, or voice/video support via a protocol like SIP. Is jabberd2 adding support for this? Or does PBX mean integration with something like Asterisk? you can set from your PBX like asterisk that you are on the phone(status DND) when you have call echo START cerve...@jabber.com/someresource DND 'on the phone' /usr/local/var/jabberd/run/pbx OR you can synchronize your calendar status to jabber status/info like MS Lync there is one problem in XMPP generally standard clients connect to jabber server with priority i.e. 5 in XMPP is recommended that external systems must set negative priority when connecting to jabber server (like PBX integration module) BUT for other users is not visible your DND status when you are on the phone, because bigger priority have preference i'm modified PBX integration to set highest possible priority. now my contacts can see that i'm on the phone BUT if they send me message, the message is lost because PBX module cannot receive messages i can sponsor patch which reroute the message for PBX module to highest priority connected client. programmers? dont write me all ;) -- --- Marek Cervenka ===
Re: Add users and multi mysql
Would this support a sasl with Channel Binding? (I will admit I am not entirely familiar with channel binding) On 03/21/2012 04:17 PM, Tomasz Sterna wrote: Dnia 2012-03-21, śro o godzinie 10:38 -0600, Stephen Mahood pisze: a central server to run the software, but to have multiple VPN having the ability to create jabber accounts specific to their address (virtual hosting) but the other thing we want to restrict the creating of accounts to the local mysql for the virtual hosted site. Is that feasible with jabberd2.x? Of course it is. It always was. :-) What you need is to: 1. configure several domains in c2s.xml - local/id sections 2. configure sm.xml for every domain and launch sm instance At least how it is used to be. Since 2.1.16 you don't have to do 1, as you may configure one default local/id entry in c2s.xml[1], which will be used if there is no specific id for a domain. Since 2.2.9 jabberd2 is able to support many domains in one SM process, so you may run just one sm instance holding all your domains, similarly by configuring several local/id sections in sm.xml[2]. To lock account creation, setup local/id section in c2s.xml to not include register-enable attribute. You will then need to create the users manually in DB. See section 5.5 of the InstallGuide[3]. It may be feasible to add password-change attribute then, to allow existing users to change password. P.S. If anyone volunteers to fix the documentation, I will be more than happy. :-) [1] https://github.com/Jabberd2/jabberd2/blob/master/etc/c2s.xml.dist.in [2] https://github.com/Jabberd2/jabberd2/blob/master/etc/sm.xml.dist.in [3] https://github.com/Jabberd2/jabberd2/wiki/InstallGuide-CommonConfigurationTasks