Topic: Location of SOGo UI address book
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: Debian 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP 2.4.40
- Web server (Apache or Nginx):Nginx 1.62-5
- Manage mail accounts with iRedAdmin-Pro? No
-sogo 2.3.1-1
- Related log if you're reporting an issue:
====
Good Day
I was trying to locate where the address book that is used in the SOGo web UI. I tried searching Openldap directory with Web2ldap and could not find the address book entries. I could find the users that are registered. Did thes end up in Mysql? I am not sure the best way to check this. Even so I would prefer the address book to be located in ldap. Maybe SOGo uses a diffeent DIT for storing the address book and if so were does one look?
Thanks
Here is /etc/sogo/sogo.conf
WOWorkersCount = 10;
// Daemon address and port
WOPort = 127.0.0.1:20000;
// PID file
//WOPidFile = /var/run/sogo/sogo.pid;
// Log file
//WOLogFile = /var/log/sogo/sogo.log;
// IMAP connection pool.
// Your performance will slightly increase, as you won't open a new
// connection for every access to your IMAP server.
// But you will get a lot of simultaneous open connections to your IMAP
// server, so make sure he can handle them.
// For debugging it is reasonable to turn pooling off.
//NGImap4DisableIMAP4Pooling = NO;
SOGoProfileURL = "mysql://sogo:SFlQQdEmXcOHnntkaPV4ci4L7X5vNU@127.0.0.1:3306/sogo/sogo_user_profile";
OCSFolderInfoURL = "mysql://sogo:SFlQQdEmXcOHnntkaPV4ci4L7X5vNU@127.0.0.1:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL = "mysql://sogo:SFlQQdEmXcOHnntkaPV4ci4L7X5vNU@127.0.0.1:3306/sogo/sogo_sessions_folder";
// Default language in the web interface
SOGoLanguage = English;
// Specify which module to show after login: Calendar, Mail, Contacts.
SOGoLoginModule = Mail;
// Must login with full email address
SOGoForceExternalLoginWithEmail = YES;
// Allow user to change full name and email address.
SOGoMailCustomFromEnabled = YES;
// Enable email-based alarms on events and tasks.
SOGoEnableEMailAlarms = YES;
OCSEMailAlarmsFolderURL = "mysql://sogo:SFlQQdEmXcOHnntkaPV4ci4L7X5vNU@127.0.0.1:3306/sogo/sogo_alarms_folder";
// IMAP server
//SOGoIMAPServer = "imaps://127.0.0.1:143/?tls=YES";
// Local connection is considered as secure by Dovecot.
SOGoIMAPServer = "imap://127.0.0.1:143/";
// SMTP server
SOGoMailingMechanism = smtp;
SOGoSMTPServer = 127.0.0.1;
//SOGoSMTPAuthenticationType = PLAIN;
// Enable managesieve service
//
// WARNING: Sieve scripts generated by SOGo is not compatible with Roundcube
// webmail, don't use sieve service in both webmails, otherwise
// it will be messy.
//
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSieveScriptsEnabled = YES;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
// Memcached
SOGoMemcachedHost = 127.0.0.1;
// Parameter used to set which usernames require administrative privileges
// over all the users tables. For example, this could be used to post
// events in the users calendar without requiring the user to configure
// his/her ACLs. In this case you will need to specify those superuser's
// usernames like this :
// SOGoSuperUsernames = (<username1>[,<username2>, ...]);
//SOGoSuperUsernames = ();
SOGoTimeZone = "America/Toronto";
SOGoFirstDayOfWeek = 1;
SOGoRefreshViewCheck = every_5_minutes;
SOGoMailReplyPlacement = below;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;
// NOTE: PostgreSQL cannot update view in iRedMail
SOGoPasswordChangeEnabled = YES;
// Authentication using SQL
/* SQL backend
SOGoUserSources = (
{
type = sql;
id = vmail_mailbox;
viewURL = "mysql://sogo:SFlQQdEmXcOHnntkaPV4ci4L7X5vNU@127.0.0.1:3306/sogo/users";
canAuthenticate = YES;
// Default algorithm used when changing passwords.
userPasswordAlgorithm = ssha;
prependPasswordScheme = YES;
// Use vmail.mailbox as global address book.
// WARNING: This will search all user accounts, not just accounts
// under same domain as login user.
//isAddressBook = YES;
//displayName = "Global Address Book";
}
);
SQL backend */
// Authentication using LDAP
SOGoUserSources = (
{
type = ldap;
hostname = "ldap://127.0.0.1:389";
baseDN = "o=domains,dc=mail1,dc=internal,dc=network";
//bindAsCurrentUser = YES;
bindDN = "cn=vmailadmin,dc=mail1,dc=internal,dc=network";
bindPassword = "Q8mImkN9jhkcPP6IBdspXfEOdQj8aW";
filter = "objectClass=mailUser AND accountStatus=active AND enabledService=mail";
scope = SUB;
// The algorithm used for password encryption when changing
// passwords without Password Policies enabled.
// Possible values are: plain, crypt, md5-crypt, ssha.
userPasswordAlgorithm = ssha;
IDFieldName = mail;
bindFields = (mail);
CNFieldName = cn;
// value of UID field must be unique on whole server.
UIDFieldName = mail;
IMAPLoginFieldName = mail;
SearchFieldNames = (cn, sn, displayName, telephoneNumber, mail, shadowAddress);
canAuthenticate = YES;
displayName = "Global Address Book";
id = ldap_auth;
isAddressBook = YES;
}
);
}
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.