Hello, Firstly, SOGo set up the database tables itself if it is not done yet.
Then for your problem, do you have a special character in your password? If yes, it must be url-encoded -> https://www.urlencoder.org/ For example, if your password is "sogo%a", you should write "sogo%25a" in your sogo.conf Cheers, -- Quentin Hivert || Alinto || R&D Lead Developer 19 Quai Perrache 69002 Lyon www.alinto.com -----Original Message----- From: [email protected] <[email protected]> On Behalf Of "Dirk Schneider" Sent: mardi 10 juin 2025 14:24 To: [email protected] Subject: [SOGo] default 'OCSFolderInfoURL' is not a valid URL 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-debi an.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; }
