1

Topic: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Here you can find a howto for iRedMail Mysql SOGo authentication.

http://www.wynni.com/iredmail-sogo-mysq … ntication/

Wynni

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Cool, thanks for your sharing. smile May i copy your tutorial to our wiki site as a backup copy?

P.S.

1) I linked your tutorial in the wiki tutorial (LDAP).

2) There's a minor typo error:

Wynni wrote:

The password will be in the “RedMail tips for mail server administrator” mail. Check also the technical documentation for SOGO

The file name is iRedMail.tips. smile

3) Step 12 in your tutorial is not needed anymore with the latest iRedAdmin which will be shipped in iRedMail-0.8.0. What you need to do is just update 'SQL_DEFAULT_PASSWD_SCHEME' to 'PLAIN-MD5' (it's a dash, not underscore) in libs/settings.py.

3

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

I am having a really hard time getting Sogo to run.
can you please take a look at my post:
http://www.iredmail.org/forum/topic3354 … dmail.html

4

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

check the new tutorial for Debian and Ubuntu... now is correct.
http://www.wynni.com/

5 (edited by mekerri 2012-06-04 15:17:05)

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Hi all,
Frist, sorry for my english, it's so bad.
Thank's for the sogo's tutorial.
I followed all the steps for installing sogo with mysql, but I'm stuck at the password sogo. example: defaults write sogod OCSFolderInfoURL "mysql :// vmail: PASSWORD @ localhost: 3306/vmail/sogo_folder_info" What should I put in PASSWORD?? Thank you for the help.

6

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

mekerri wrote:

"mysql hmm/ vmail: PASSWORD @ localhost: 3306/vmail/sogo_folder_info" What should I put in PASSWORD??

You can find password of MySQL vmail user in /etc/postfix/mysql/*.cf.

7

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

It's work's thank's

ZhangHuangbin wrote:
mekerri wrote:

"mysql hmm/ vmail: PASSWORD @ localhost: 3306/vmail/sogo_folder_info" What should I put in PASSWORD??

You can find password of MySQL vmail user in /etc/postfix/mysql/*.cf.

8

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Hi again,
I can't create a event on my calender with sogo; when i click on create an event , not thing happends.
any idea to help me???
A nother question: can i have both sogo and roundcubemail ???
Thank's for help

9

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Hi again;
I can't  now login to my roundcube mail.....
please help me

mekerri wrote:

It's work's thank's

ZhangHuangbin wrote:
mekerri wrote:

"mysql hmm/ vmail: PASSWORD @ localhost: 3306/vmail/sogo_folder_info" What should I put in PASSWORD??

You can find password of MySQL vmail user in /etc/postfix/mysql/*.cf.

10

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Create a new mysql user:
mysql> GRANT ALL PRIVILEGES ON vmail.* TO ‘sogo’@'localhost’
-> IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;

Change also the SOGo configuration:

defaults write sogod SOGoUserSources ‘({canAuthenticate=YES;id=directory;isAddressBook=YES;type=sql;userPasswordAlgorithm=md5;viewURL=”mysql://user:some_pass@localhost:3306/vmail/sogo_auth”;})’
defaults write sogod OCSFolderInfoURL “mysql://user:some_pass@localhost:3306/vmail/sogo_folder_info”
defaults write sogod OCSSessionsFolderURL mysql://user:some_pass@localhost:3306/vmail/sogo_sessions_folder
defaults write sogod SOGoProfileURL “mysql://user:some_pass@localhost:3306/vmail/sogo_user_profile”
defaults write sogod OCSEMailAlarmsFolderURL mysql://user:some_pass@localhost:3306/vmail/sogo_alarms_folder



mekerri wrote:

Hi again,
I can't create a event on my calender with sogo; when i click on create an event , not thing happends.
any idea to help me???
A nother question: can i have both sogo and roundcubemail ???
Thank's for help

11

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Try to change the password for the user. In this example the password the user "www@example.org" is "test"


mysql -u root -p
use vmail;
update mailbox set password ='098f6bcd4621d373cade4e832627b4f6' where username = 'www@example.org';



have fun

wynni

mekerri wrote:

Hi again;
I can't  now login to my roundcube mail.....
please help me

mekerri wrote:

It's work's thank's

ZhangHuangbin wrote:

You can find password of MySQL vmail user in /etc/postfix/mysql/*.cf.

12

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

yes you can use both.

wynni



mekerri wrote:

Hi again,
I can't create a event on my calender with sogo; when i click on create an event , not thing happends.
any idea to help me???
A nother question: can i have both sogo and roundcubemail ???
Thank's for help

13

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Hi again,
There is my problem:
When i create a user with iredadmin:
-In the table auth_sogo my user line looks like this:

user1@domaine.edu    user1@domaine.edu    user1    user1 user     user1@domaine.edu    domaine.edu/user1/
the password is not crypted in this table --> problem
Than i must change it manually (with sql request)
How can i automate this please.
Thank's for help

14 (edited by pf@wynsim.org 2012-06-06 19:24:42)

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

check the config File:

12.) Change iRedadmin for MD5 in usr/share/apache2/iredadmin/libs/settings.py

SQL_DEFAULT_PASSWD_SCHEME = ‘PLAIN-MD5′


www.wynni.com

15

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

It's  PLAIN-MD5 and i still have no password crypted ...
Thank's again fo help


pf@wynsim.org wrote:

check the config File:

12.) Change iRedadmin for MD5 in usr/share/apache2/iredadmin/libs/settings.py

SQL_DEFAULT_PASSWD_SCHEME = ‘PLAIN-MD5′


www.wynni.com

16

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Hello to everyone!
I followed this setup and all it's working, I need only some information about filter and sieve, because SOGo don't read sieve filter added via RoundCube or Iredadmin.

Is this configuration correct?
<key>SOGoSieveScriptsEnabled</key>
<string>YES</string>
<key>SOGoSieveServer</key>
<string>sieve://localhost:4190</string>

Thank you!

17

Re: Debian (squeeze) + iRedMail (MySQL backend) + SOGo groupware

Looks file. Please paste related error message/log here to help troubleshoot. Creating a new forum topic is better.