Re: [SOGo] Ldap vs Mysql

[Pablo Carranza]

While dated, the SOGo article that appeared in the Linux Journal back in
2008 may be of interest to you:
http://www.linuxjournal.com/magazine/scalable-opengroupwareorg

​Also, according to the SOGo Installation and Configuration
Guide@
p. 29:
​
​

> SOGo can use a SQL-based database server for authentication. The
> ​ ​
> configuration is very similar
> ​
> to LDAP-based authentication.​
> ​..​
>

​Regards,

​
-Pablo

vDevices.com  | Providing Hosted IT Solutions for
Lawyers & Other Mobile Professionals


On Thu, Dec 5, 2013 at 2:30 AM, Burk Al  wrote:

> Hi,
>
> I have already have a running mail server setup on postfix, dovecot,
> mysql, roundcube and I am using postfix admin to manage domains & users.
>
> Now I want to install sogo on this setup. I have two main goals.
> 1- I want to natively connect some of my outlook users to the mail server.
> 2- Some of my users need both personal address book as well as the domain
> wide global address book. And they want to be able to access these two
> address books through both from their outlooks and also from the webmail.
>
> I believe sogo is my solution.
>
> I was taking a quick look at the documentation and I have noticed that I
> will need some sort of an Ldap server to achieve my goals with sogo.
> How does this supposed to work? I already have a mysql database running
> the domain and user data. Do I need to first change my current setup and
> replace mysql with an ldap server, which sounds like a quite task.
>
> Please advice...
> Thanks
>
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Ldap vs Mysql

[Igor Vitorac]

If you have your users in mysql, you don't need to migrate them to LDAP. 
You can use MySQL as user source. Check documentation and some 
earlier/older posts on this mailing list.


Regards,
Igor



Burk Al wrote, On 05/12/2013 09:30:

Hi,

I have already have a running mail server setup on postfix, dovecot, 
mysql, roundcube and I am using postfix admin to manage domains & users.


Now I want to install sogo on this setup. I have two main goals.
1- I want to natively connect some of my outlook users to the mail server.
2- Some of my users need both personal address book as well as the 
domain wide global address book. And they want to be able to access 
these two address books through both from their outlooks and also from 
the webmail.


I believe sogo is my solution.

I was taking a quick look at the documentation and I have noticed that 
I will need some sort of an Ldap server to achieve my goals with sogo.
How does this supposed to work? I already have a mysql database 
running the domain and user data. Do I need to first change my current 
setup and replace mysql with an ldap server, which sounds like a quite 
task.


Please advice...
Thanks



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

Re: [SOGo] Ldap vs Mysql

[Burk Al]

Well, that setup is not feasible in my situation.




On Thu, Dec 5, 2013 at 8:35 AM, Martin Rabl  wrote:

> Hi,
>
> Am 05.12.2013 09:30, schrieb Burk Al:
>
>> I will need some sort of an Ldap server to achieve my goals with sogo.
>> How does this supposed to work? I already have a mysql database
>> running the domain and user data. Do I need to first change my current
>> setup and replace mysql with an ldap server, which sounds like a quite
>> task.
>>
>
> At our company we use a mixed setup:
> * internal (company) users
>   - auth. against AD/LDAP
>   - Email-Adr., aliases, data are in database
>
> * external users
>   - auth. against database
>   - Email-Adr., aliases, data are in database
>
> * technical users (if needed)
>   - auth. against database (if needed)
>   - Email-Adr, data in database
>
> * Groups planned to store in database, but low prio.
>
> We are happy, it es flexible as we need it and our AD/LDAP is clean from
> other than MS schemas.
>
> Database is MySQL, AD from Win Server 2012, SOGo runs on an Ubuntu 12.04
> LTS.
>
> --
> Greetings,
>
>Martin Rabl
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Ldap vs Mysql

[Martin Rabl]

Hi,

Am 05.12.2013 09:30, schrieb Burk Al:

I will need some sort of an Ldap server to achieve my goals with sogo.
How does this supposed to work? I already have a mysql database
running the domain and user data. Do I need to first change my current
setup and replace mysql with an ldap server, which sounds like a quite
task.


At our company we use a mixed setup:
* internal (company) users
  - auth. against AD/LDAP
  - Email-Adr., aliases, data are in database

* external users
  - auth. against database
  - Email-Adr., aliases, data are in database

* technical users (if needed)
  - auth. against database (if needed)
  - Email-Adr, data in database

* Groups planned to store in database, but low prio.

We are happy, it es flexible as we need it and our AD/LDAP is clean 
from other than MS schemas.


Database is MySQL, AD from Win Server 2012, SOGo runs on an Ubuntu 
12.04 LTS.


--
Greetings,

   Martin Rabl
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Ldap vs Mysql

[Burk Al]

Hi,

I have already have a running mail server setup on postfix, dovecot, mysql,
roundcube and I am using postfix admin to manage domains & users.

Now I want to install sogo on this setup. I have two main goals.
1- I want to natively connect some of my outlook users to the mail server.
2- Some of my users need both personal address book as well as the domain
wide global address book. And they want to be able to access these two
address books through both from their outlooks and also from the webmail.

I believe sogo is my solution.

I was taking a quick look at the documentation and I have noticed that I
will need some sort of an Ldap server to achieve my goals with sogo.
How does this supposed to work? I already have a mysql database running the
domain and user data. Do I need to first change my current setup and
replace mysql with an ldap server, which sounds like a quite task.

Please advice...
Thanks
-- 
users@sogo.nu
https://inverse.ca/sogo/lists