Thanks for your Support my friend
Here is the sogo.conf
{
WOPort = 127.0.0.1:2;
WOWorkersCount = 300;
SOGoMaximumPingInterval = 354;
SOGoMaximumSyncInterval = 354;
SOGoInternalSyncInterval = 30;
WOWatchDogRequestTimeout = 10;
SOGoMaximumSyncResponseSize = 512;
SOGoMaximumSyncWindowSize = 256;
SxVMemLimit = 384;
NGImap4DisableIMAP4Pooling = YES;
SOGoProfileURL =
"mysql://sogo:passw...@myexternal.database.server.com:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:passw...@myexternal.database.server.com:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:passw...@myexternal.database.server.com:3306/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL =
"mysql://sogo:passw...@myexternal.database.server.com:3306/sogo/sogo_alarms_folder";
// Default language in the web interface
SOGoLanguage = Spanish;
// 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;
// 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/";
// Allow user to add other IMAP accounts that will be visible from the SOGo
// Webmail interface.
// Default is NO.
//SOGoMailAuxiliaryUserAccountsEnabled = YES;
// SMTP server
SOGoSMTPServer = 127.0.0.1;
SOGoMailingMechanism = smtp;
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSieveScriptsEnabled = YES;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveFolderEncoding = UTF-8;
// Memcached
SOGoMemcachedHost = 127.0.0.1;
SOGoTimeZone = "America/Guayaquil";
SOGoFirstDayOfWeek = 1;
SOGoRefreshViewCheck = every_2_minutes;
SOGoMailReplyPlacement = above;
SOGoAppointmentSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;
// NOTE: PostgreSQL cannot update view in iRedMail
SOGoPasswordChangeEnabled = YES;
// Authentication using SQL
SOGoUserSources = (
{
type = sql;
id = vmail_mailbox;
viewURL =
"mysql://sogo:passw...@myexternal.database.server.com:3306/sogo/users";
canAuthenticate = YES;
// Default algorithm used when changing passwords.
userPasswordAlgorithm = ssha512;
prependPasswordScheme = YES;
// Use `vmail.mailbox` as global address book.
isAddressBook = YES;
displayName = "Global Address Book";
SOGoEnableDomainBasedUID = YES;
DomainFieldName = "domain";
}
);
// Authentication using LDAP
}
And this is the structure of the table “users” from “sogo” table/view, as you
can see there is no column “domain” so I got the error:
1
c_uid
2
c_name
3
c_password
4
c_cn
5
mail
6
home
Fernando Salas
De: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] En nombre de Ludovic
Marcotte (lmarco...@inverse.ca)
Enviado el: miércoles, 18 de enero de 2017 13:22
Para: users@sogo.nu
Asunto: Re: [SOGo] Can't share a calendar
On 2017-01-18 1:08 PM, "Fernando Salas" (fsalas@novanet.network
<mailto:fsalas@novanet.network> ) wrote:
I ave no changed to 9 tables MySQL schema. Is this the reason for that error
message?
Show your sogo.conf file and a description of your table/view used for
authentication.
--
Ludovic Marcotte
lmarco...@inverse.ca <mailto:lmarco...@inverse.ca> :: +1.514.755.3630 ::
http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu), PacketFence
(http://packetfence.org) and Fingerbank (http://fingerbank.org)
--
users@sogo.nu <mailto:users@sogo.nu>
https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists
