On Tue, Dec 23, 2025 at 2:02 PM "Oli Z." <[email protected]> wrote:
> I am not exactly sure what you mean. My users are in mariadb, the > database is called "postfixadmin" because i set this email server up > about 15 years ago and did not know that its a bad idea to call the db > like the product thats in use :D > Who said that it's a bad idea to call the db like the product that's in use?? > I have about 7 users (friends). Next time i would call it > "mailbox_users" or so. Anyway... i followed this guide > > https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL > and the authentication works. When i log in to SOGo, it shows a green > splash with my name, and then the white page appears. So authentication > against SQL works. But i did not run any other SQL to populate the SOGo DB. You actually do NOT need the SOGo DB! If you had an existing database with your users, it should have been easier to create a view of your existing tables for use with SOGo. For example, with Mariadb, for postfixadmin, I used: https://narkive.com/gJeHppYI.4 > I was not aware that anything like this is required. Thats why i migrated > this mysql sql script to postgresql so that i have at least the > sogo_user_profile table. I have the feeling there is a lot missing in the > documentation... or i am blind. Or both 😉 > > Maybe something in the log shows something that i dont see, which might be > a problem or relevant. > Once you create the VIEW, you just configure SOGo with the DB details, using the VIEW as the table. -- 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]
