The fact that everything is stored in the database makes the migration much simpler. chatgpt can do the mapping of the columns and even write a migration script for your case. It knows a lot about these systems :-)
Assuming you can whip up a VM for staging the migration, feel free to ping me if you can grant access to the VM. We can do the staging together. On Wed, Dec 31, 2025 at 6:07 PM "Oli Z." <[email protected]> wrote: > I am not a fan of guessing, i prefer hard facts. If i would knew that > this is caused by the db mix, i would go with mariadb or postgresql > only. But i dont know that. > > I will see, for testing purposes, if it works in mariadb only. There is > no way to get all this migrated in 2hrs with testing etc. - i have > roundcube and other applications that rely on the database. In 2 hrs i > might have the test-machine set up and running. Anyway, i will see what > happens when "everything" (SOGo) runs in mariadb. > > Am 29.12.25 um 12:33 schrieb Washington Odhiambo ([email protected]): > > I remember you said something to the effect that you only have about > > 10 or so users. > > Why don't you just setup a system based on > > Postfixadmin+PostgreSQL+SOGo, then migrate the users from MySQL? > > https://www.linuxbabe.com/mail-server/postfixadmin-ubuntu-postgresql > > It should be easier. Takes about 2hrs at most, IIRC. > > > > Alternatively, stick to MariaDB for everything. > > > > > > > > On Sun, Dec 28, 2025 at 8:37 PM Oli <[email protected]> wrote: > > > > No i did not > > > > > > Am 28. Dezember 2025 12:36:09 UTC schrieb Washington Odhiambo > > <[email protected]>: > > > > You resolved this issue already, I suppose. > > > > > > On Sun, Dec 28, 2025 at 3:25 PM "Oli Z." <[email protected]> wrote: > > > > See my last log, thats exactly this > > > > Am 24.12.25 um 09:15 schrieb Washington Odhiambo > > ([email protected]): > > > > > > > > > On Wed, Dec 24, 2025 at 11:07 AM "Oli Z." > > <[email protected]> wrote: > > > > > > > I have never used a mixed DB setup where some > > stuff is in MySQL > > > while > > > others are in PostGreSQL. > > > > > > 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. > > > > > > > > > True. As long as SOGo can make the connections. > > > > > > 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. > > > > > > > > > You are at that point where: > > > > > > SOGoDebugRequests = YES; > > > ImapDebugEnabled = YES; > > > PGDebugEnabled = YES; > > > MySQL4DebugEnabled = YES; > > > > > > Wil be helpful. > > > > > > > > > > > > > > > -- > > > 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 '^$|^.*#' ¯\_(ツ)_/¯ :-) > > > [How to ask smart questions: > > > http://www.catb.org/~esr/faqs/smart-questions.html] > > > > > > > > -- > > Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet. > > > > > > > > -- > > 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 '^$|^.*#' ¯\_(ツ)_/¯ :-) > > [How to ask smart questions: > > http://www.catb.org/~esr/faqs/smart-questions.html] > -- 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 '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
