Hi Bartosz,
you have an invalid parameter in your sogo.conf.
viewUrl vs. viewURL
Regards,
Thomas
-Ursprüngliche Nachricht-
Von: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Im Auftrag von
Bartosz Stepien
Gesendet: Freitag, 22. Dezember 2017 18:09
An: users@sogo.nu
Betreff: [SOGo] Multi-domain + MySQL setup
Hello,
after long and successful adventure with SOGo 2 now I'm trying to setup a
v3 server for our customers. Straight to the point: I fail.
Request to WWW frontend result in error 501; sogo.log states:
#v+
2017-12-22 16:58:36.601 sogod[3339] EXCEPTION:
NAME:NSInvalidArgumentException REASON:Tried to add nil value for key
'seconddomain.pl' to dictionary INFO:{} Dec 22 16:58:36 sogod [3339]:
123.45.135.246 "GET /SOGo/ HTTP/1.1" 501 0/0 0.030 - - 2M
#v-
(domain name and IP changed; there is also another error, "could not create
bundle for path:
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.22/Resources/SSL.bundl
e'",
but according to https://sogo.nu/bugs/view.php?id=287 it's harmless).
Intended setup is multi-domain (two domains atm), with users coming from
MySQL.
Domains should be isolated from each other. Username is equal to email
address.
Looking for solution I've found some suggestions online, but none helped:
- sope4.9-gdl1-mysql is installed
- I can access MySQL server and views from the machine, using credentials
from
sogo.conf
- memcached is running on the SOGo machine
- adding DomainFieldName to SOGoUserSources, as suggested once on list, did
not
help
- when I remove second domain section, the same error appears for first
domain.
- plist shows no errors in sogo.conf structure
It's probably some omission on my side, but I fail to recognize it, so if
anybody has a suggestion, I'd be most grateful. Or maybe someone can show
his working example?
Setup details: Debian Wheezy (I know, I know), latest SOGo nightly from
packages.inverse.ca (earlier nightlies worked in exactly the same way),
Apache as a frontend (with default config from package).
Here is my sogo.conf (password, "db-alias" and domain names sanitized; but
I've checked the original values many times):
#v+
{
SOGoProfileURL =
"mysql://sogo:password@db-alias:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:password@db-alias:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:password@db-alias:3306/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL =
"mysql://sogo:password@db-alias:3306/sogo/sogo_alarms_folder";
OCSStoreURL =
"mysql://sogo:password@db-alias:3306/sogo/sogo_store";
OCSAclURL =
"mysql://sogo:password@db-alias:3306/sogo/sogo_acl";
OCSCacheFolderURL =
"mysql://sogo:password@db-alias:3306/sogo/sogo_cache_folder";
SOGoEnableEMailAlarms = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoCalendarDefaultRoles = (
PublicViewer,
ConfidentialDAndTViewer
);
SOGoLanguage = Polish;
SOGoTimeZone = Europe/Warsaw;
SOGoIMAPServer = mailserver.pl;
SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoJunkFolderName = Spam;
SOGoMailingMechanism = smtp;
SOGoSMTPServer = mailserver.pl;
/*SOGoEnableDomainBasedUID = YES; */
domains = {
"first-domain.pl" = {
SOGoMailDomain = "first-domain.pl";
SOGoUserSources = (
{
type = sql;
id = "first-domain.pl";
viewUrl =
"mysql://sogo:password@db-alias:3306/sogo/_auth_first";
canAuthenticate = YES;
DomainFieldName = c_domains;
isAddressBook = YES;
}
);
};
"seconddomain.pl" = {
SOGoMailDomain = "seconddomain.pl";
SOGoUserSources = (
{
type = sql;
id = "seconddomain.pl";
viewUrl =
"mysql://sogo:password@db-alias:3306/sogo/_auth_second";
canAuthenticate = YES;
DomainFieldName = c_domains;
isAddressBook = YES;
}
);
};
};
}
#v-
(I started without many quotes, as in documentation; DomainFieldName and
SOGoEnableDomainBasedUID were added/commented during tests, with no result).
~sogo/GNUstep/Defaults/.GNUstepDefaults looks as follows:
#v+
http://www.gnustep.org/plist-0_9.xml";>
NSGlobalDomain
sogod
#v-
Views have columns named c_uid, c_domains, c_name, c_password, c_cn, mail;
c_domains contains domain, c_password -- password, all other -- email
address (that is also username).
Sincerely,
Bartosz 'briest' Stępień
--
Warning! You're entering Japanese pintelou!
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists
