General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] SOGO Installation on Plesk


Chronological Thread 
  • From: Luca Müller ( ) < >
  • To:
  • Subject: Re: [SOGo] SOGO Installation on Plesk
  • Date: Mon, 15 Jul 2019 16:44:30 +0200
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca EB7AA1DE5017

Hey Christian,

Thank you for your reply.
This is our current sogo.conf File:

====================================================
{
  SOGoTimeZone = Europe/Berlin;
  SOGoMailDomain = http://sr65.firestorm.ch/SOgo/;
  SOGoLanguage = English;
  SOGoAppointmentSendEMailNotifications = YES;
  SOGoFoldersSendEMailNotifications = YES;
  SOGoACLsSendEMailNotifications = YES;
  SOGoCalendarDefaultRoles = ("PublicViewer","ConfidentialDAndTViewer");
  SOGoUserSources = ({
    //canAuthenticate = YES;
    displayName = "SOGo Users";
    id = users;
    isAddressBook = YES;
    type = sql;
    userPasswordAlgorithm = md5;
    viewURL = "mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_users";  
  });
  SOGoMailingMechanism = smtp;
  SOGoSMTPServer = localhost;
  SOGoIMAPServer = imaps://localhost:993;
  SOGoMemcachedHost = 127.0.0.1;
  SOGoEnableEMailAlarms = No;
  SOGoProfileURL = "mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_user_profile";
  OCSFolderInfoURL = "mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_folder_info";
  OCSSessionsFolderURL = "mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_sessions_folder";
  OCSEMailAlarmsFolderURL = "mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_alarms_folder";

  SOGoPageTitle = "SOGo WebMailer";
  SOGoMailAuxiliaryUserAccountsEnabled = NO;
  SOGoFirstDayOfWeek = 1;
  SOGoMailComposeMessageType = html;

  SOGoDraftsFolderName = Drafts;
  SOGoSentFolderName = Sent;
  SOGoTrashFolderName = Trash;

  SxVMemLimit = 4096;
  SOGoDebugRequests = YES;
  SOGoEASDebugEnabled = YES;
  ImapDebugEnabled = YES;
    //LDAPDebugEnabled = YES;
  MySQL4DebugEnabled = YES;
    //PGDebugEnabled = YES;
  WOPort = 20000;
  SOGoForceExternalLoginWithEmail = YES;
}
==================================================== 

 On our Plesk Server i've created a test user and tried to login. But it failed without a Error Message:
Jul 15 16:41:20 sogod [2711]: |SOGo| starting method 'POST' on uri '/SOGo/connect'
Jul 15 16:41:20 sogod [2711]: SOGoRootPage Login from '46.140.230.170' for user ' ' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
Jul 15 16:41:20 sogod [2711]: |SOGo| request took 0.004622 seconds to execute
Jul 15 16:41:20 sogod [2711]: 46.140.230.170 "POST /SOGo/connect HTTP/1.1" 403 34/67 0.009 - - 0


Next i've inserted the same username and password into the Table 'sogo_users'.
So IMAP and the Database had the exact same password. Then i was able to login using this user Account.
However in Plesk we can't get the hashed or plain password of our users. So filling all these Credentials into a database is not possible.
We need a IMAP only auth.

Bests,
Luca

Am Fr., 12. Juli 2019 um 15:59 Uhr schrieb "Christian M. Jensen" < >:

Hi.

When you try to login what is shown in the logs.

If i remember correctly for authentication you just need to have view with users that are allowed to use SOGo and a working imap server, SOGo sends the authentication to the imap server and that is where the password is validated happens.

Also the option 'userPasswordAlgorithm' in SOGo (according to the doc and my own findings) only has effect if i want to change the password from within SOGo, so that should not be an issue. i use sha512 and changing that option to plain has no effect on authentication at least for me.

On 12-07-2019 13:31, Luca Müller ( ) wrote:
Hello,

We're trying to install SOGO on our Plesk Onyx 17.8.11 Server.
The installation of SOGO itsself was successful. We're able to open SOGO Webmail using domain.tld/SOgo. However we have some trouble in choosing the correct Authentication method. On Plesk we use dovecot & postfix. In the Plesk Database there's the Users password. However it's not hashed with any of the supported Hashing Algorithms. The Mail-Password is encrypted using "AES-256-CBC". Since there's only the option to use a Database or LDAP we can't login to the webmail. Has anyone ever tried to setup Sogo with Plesk ? Are there any tutorials (i couldn't fine one). Or does anyone know another option how the authentification could work ?
Thanks in advance.
Best regards,
Luca
-- 
Hilsen/Regards
Christian M. Jensen



Archive powered by MHonArc 2.6.18.

Top of page