[SOGo] default 'OCSFolderInfoURL' is not a valid URL

["Dirk Schneider"]

Hi,

I'm new to sogo, trying to get it running.
Installed sogo nightly build like described in
https://www.sogo.nu/support/faq/how-to-install-nightly-sogo-versions-on-debian.html
Created a mysql-database sogo and a user sogo granted to read and write to it.
MySQL tested with this user at mysql console, working fine.

1) When starting sogod I get this in sogo.log:

default 'OCSFolderInfoURL' is not a valid URL:
'mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_folder_info'

I didn't find a description how to initialize the db, so I used a script from
https://github.com/Alinto/sogo/blob/master/Scripts/mysql-utf8mb4.sql to create
tables.
Additional I created a table "user_view" with c_uid, c_name, c_cn, c_password,
mail to store credentials, added one user for test.

When calling the sogo website I get only a 501.
The log added a line
EXCEPTION: <NSException: 0x55df47e2d680> NAME:NSInvalidArgumentException
REASON:Tried to add nil value for key 'userdb' to dictionary INFO:{}

There is a working server I can test too, the configuration is the same, this
one is working.


sogo.conf look like this:
{
    SOGoLanguage = German;
    SOGoTimeZone = Europe/Berlin;
    SOGoFirstDayOfWeek = 1;
    SOGoMailMessageCheck = manually;
    SOGoMailAuxiliaryUserAccountsEnabled = YES;
    SOGoMemcachedHost = "127.0.0.1";
    SOGoRefreshViewCheck = every_5_minutes;

    WOWorkersCount = 5;
    SOGoMaximumMessageSizeLimit = 51200;
    SxVMemLimit = 512;

    MySQL4DebugEnabled = YES;
    OCSFolderManagerSQLDebugEnabled = YES;

    SOGoAppointmentSendEMailNotifications = NO;
    SOGoPasswordChangeEnabled = NO;

    SOGoProfileURL =
"mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_user_profile";
    OCSFolderInfoURL =
"mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_folder_info";
    OCSSessionsFolderURL =
"mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_sessions_folder";
    OCSEMailAlarmsFolderURL =
"mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_alarms_folder";
    OCSStoreURL =
"mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_store";
    OCSAclURL = "mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_acl";
    OCSCacheFolderURL =
"mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_cache_folder";

    SOGoUserSources =
        (
            {
                type = sql;
                id = userdb;
                viewURL =
"mysql://sogo:PASSWORD4USERSOGO@localhost:3306/sogo/sogo_view";
                canAuthenticate = YES;
                isAddressBook = YES;
                userPasswordAlgorithm = ssha512;
                DomainFieldName = "domain";
            }
        );

    SOGoMailingMechanism = smtp;
    SOGoSMTPServer = "smtp://my.mailserver:25/?tls=YES";
    SOGoSMTPAuthenticationType = PLAIN;

    SOGoSentFolderName = "INBOX/Sent";
    SOGoTrashFolderName = "INBOX/Trash";
    SOGoDraftsFolderName = "INBOX/Drafts";
    SOGoJunkFolderName = "INBOX/Spam";
    SOGoIMAPServer = "imaps://my.mailserver:143/?tls=YES";
    SOGoIMAPAclConformsToIMAPExt = NO;
    SOGoMailCustomFromEnabled = YES;
    SOGoAppointmentSendEMailNotifications = YES;

    SOGoSieveServer = "sieve://my.mailserver:4190/?tls=YES";
    SOGoForwardEnabled = YES;
    SOGoVacationEnabled = YES;
    SOGoSieveScriptsEnabled = YES;
}