Am 04.01.26 um 11:41 schrieb Washington Odhiambo ([email protected]):
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]
smime.p7s
Description: Kryptografische S/MIME-Signatur
