Re: [SOGo] Something for my webhosting company?

[Harry M. Aasterud]

Hi Peter,

Thank you for your reply from December 7th.. You have got my attention :o)
 

I posted a new question only yesterday concerning multi domain hosting. So I hope your view solution can do the trick.

I'm still learning the trade when it comes to interacting with MySQL and Postgresql. But I hear what you are saying. I'm trying to get some more in-depth understanding on how your solution could work for me.

Are you saying you bypassed the LDAP entirely? I used ClearOS as OS. COS uses openLDAP as an integrated solution for user authentication. So I entered maindomain.com, and all users created got @maindomain.com as email address in SOGo.

So I am bit confused about how to set up all the other domains. They are all hosted on an external web server, so theoretically there is no use to create them on the SOGo server as virtual hosts in Apache. But I noticed that on the SOGo manual, the don't talk about creating the other domains in LDAP. They only talk about adding them to GNUstepDefaults. So... what is the story here... ?

And how did you do it. Did you only used VIEW to retrieve all email addresses on your email server? All under the same domain, or different domains? 

I would be extremely grateful if you could guide me a little. If you have the time, that is...

Many thanks in advance.

Harry

 

On Woensdag 7 December 2011 03:46 PM CET, Peter Peltonen <peter.pelto...@gmail.com> wrote:
 

Hi,

On Wed, Dec 7, 2011 at 1:59 PM, ha...@aasterud.com wrote:
> In the mean time I have been doing some research. I found it rather
> complicated to use LDAP. LDAP does not really fit in to my webhosting
> business. But I found some info saying that Sogo also can authenticate
> from MySql. As I wrote earlier, I have all my user info, domain info and
> email accounts stored in both postgresql and mysql. Is there a way to let
> these databases interact with SOGO? Any suggestions?

I'm no SOGo expert, but I do know that SOGo can play together with
MySQL and PostgreSQL.

You can for example create a view in your db that maps to your
existing user data in that database, and use that for authentication.
I did that myself with a vpopmail user database and it seems to work
fine. This is the SQL for that MySQL view I used:

CREATE VIEW sogo AS SELECT concat( pw_name, '@example.com' ) AS c_uid,
pw_name AS c_name, pw_passwd AS c_password, pw_name AS c_cn, concat(
pw_name, '@example.com' ) AS mail FROM example_com;

Hope this helps.

Best,
Peter
--
users@sogo.nu
https://inverse.ca/sogo/lists