Re: [SOGo] Debian 13 / SOGo / 500 error

["Oli Z."]

> I have never used a mixed DB setup where some stuff is in MySQL while others are in PostGreSQL.

Am 23.12.25 um 16:55 schrieb Washington Odhiambo (odhia...@gmail.com):

It should make no difference if the users are authenticated via ldap, mysql or postgresql. I mean thats how its supposed to work, isnt it. I use sha512-crypt in my db - to what should i change it in SOGo then? Does SOGo automatically detect what is used? The authentication against sql works. I get an 500 from SOGo after authentication. That means, the authentication should work including the configuration (e.g. password hash). At least thats how i understand it.

On Tue, Dec 23, 2025 at 6:37 PM "Oli Z." <users@sogo.nu> wrote:

    I created the view as described in the documentation, thats what
    is in use:

    viewURL =
    "mysql://xxx:xxx@127.0.0.1:3306/postfixadmin/sogo_mailbox
    <http://xxx:xxx@127.0.0.1:3306/postfixadmin/sogo_mailbox>";

    But Sogo still requires a DB, to store data, e.g. calendar
    information.
    And i prefer postgre, thats why i have:
    SOGoProfileURL =
    "postgresql://xxx@127.0.0.1:5433/sogo/sogo_user_profile
    <http://xxx@127.0.0.1:5433/sogo/sogo_user_profile>";
    OCSFolderInfoURL =
    "postgresql://xxx@127.0.0.1:5433/sogo/sogo_folder_info
    <http://xxx@127.0.0.1:5433/sogo/sogo_folder_info>";
    OCSSessionsFolderURL =
    "postgresql://xxx@127.0.0.1:5433/sogo/sogo_sessions_folder
    <http://xxx@127.0.0.1:5433/sogo/sogo_sessions_folder>";
    OCSEMailAlarmsFolderURL =
    "postgresql://xxx@127.0.0.1:5433/sogo/sogo_alarms_folder
    <http://xxx@127.0.0.1:5433/sogo/sogo_alarms_folder>";
    OCSAdminURL = "postgresql://xxx@127.0.0.1:5433/sogo/sogo_admin
    <http://xxx@127.0.0.1:5433/sogo/sogo_admin>";

    As mentioned, the sql auth works like a charm, but SOGo somehow fails
    _after_ authentication. From the log, i assume it should load some
    sort
    of calendar information or so.

    I can paste the full config if required.


Do you have the following in sogo.conf:

 SOGoUserSources =
    (
      {
        type = sql;
        id = directory;

        viewURL = "mysql://xxx:xxx@127.0.0.1:3306/postfixadmin/sogo_mailbox <http://xxx:xxx@127.0.0.1:3306/postfixadmin/sogo_mailbox>";

        canAuthenticate = YES;
        isAddressBook = YES;
        listRequiresDot = NO;

      }
    );



--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
 In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

        userPasswordAlgorithm = sha512-crypt; <================= Change this!! I have never used a mixed DB setup where some stuff is in MySQL while others are in PostGreSQL. [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]

smime.p7s
Description: Kryptografische S/MIME-Signatur