Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
On Tue, Jan 30, 2024 at 9:19 PM Bits 'n Tricks wrote: > Hi, > > it came from /var/log/sogo/sogo.log: > > > ERROR: Table 'sogo.sogo_users' doesn't exist > PS: I hate to-posting! In one of my setups, I have these definitions in sogo.conf: /* Database Configuration */ SOGoProfileURL = "mysql://sogou:/* Database Configuration */ SOGoProfileURL = "mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_user_profile"; OCSFolderInfoURL = "mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_folder_info"; OCSSessionsFolderURL = "mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_sessions_folder"; OCSEMailAlarmsFolderURL="mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_alarms_folder"; OCSStoreURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_store"; OCSAclURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_acl"; OCSCacheFolderURL="mysql:// sogou:XX@127.0.0.1:3306/exim4u/sogo_cache_folder"; Looking at the exim4u DB: ``` root@localhost [exim4u]> show tables; ++ | Tables_in_exim4u | ++ | blocklists | | domainalias| | domains| | group_contents | | ml | | mygroups | | sogo_acl | | sogo_alarms_folder | | sogo_auth_view | | sogo_cache_folder | | sogo_folder_info | | sogo_quick_appointment | | sogo_quick_contact | | sogo_sessions_folder | | sogo_store | | sogo_user_profile | | users | ++ ``` As you can see, there's nothing like sogo_users table in the DB! If you need more help, I will do that, but only IF you do not top-post! -- 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]
Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
Hi, it came from /var/log/sogo/sogo.log: ERROR: Table 'sogo.sogo_users' doesn't exist --- Met Vriendelijke Groet, Kind Regards, Salutations, Bart Coninckx Bits 'n Tricks On 30/01/2024 15:18, Odhiambo Washington wrote: On Tue, Jan 30, 2024 at 4:02 PM Bits 'n Tricks wrote: Hi, I just did a new Sogo install on MariaDB and I get this error when logging in. Followed the instructions on https://www.sogo.nu/support/faq/how-do-i-configure-sogo-to-use-mysql.html. Deleted the database again and recreated it, same error. Using the nightly repo. Thanks! That link contains: ``` defaults -u sogo write sogod OCSFolderInfoURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_folder_info" defaults -u sogo write sogod SOGoProfileURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_user_profile" defaults -u sogo write sogod OCSSessionsFolderURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_sessions_folder" ``` So those are 3 tables: sogo_folder_info, sogo_user_profile and sogo_sessions_folder. Where did you get the sogo_users from ?? Looking at my setup, I don't see any table with that name too: ``` MariaDB [sogo]> show tables; ++ | Tables_in_sogo | ++ | sogo_acl | | sogo_alarms_folder | | sogo_cache_folder | | sogo_folder_info | | sogo_quick_appointment | | sogo_quick_contact | | sogo_sessions_folder | | sogo_store | | sogo_user_profile | | users | ++ ``` So there is something you are not doing right! -- 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]
Re: [SOGo] Table 'sogo.sogo_users' doesn't exist
On Tue, Jan 30, 2024 at 4:02 PM Bits 'n Tricks wrote: > Hi, > > I just did a new Sogo install on MariaDB and I get this error when > logging in. > Followed the instructions on > https://www.sogo.nu/support/faq/how-do-i-configure-sogo-to-use-mysql.html. > > Deleted the database again and recreated it, same error. > Using the nightly repo. > > Thanks! > That link contains: ``` defaults -u sogo write sogod OCSFolderInfoURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_folder_info" defaults -u sogo write sogod SOGoProfileURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_user_profile" defaults -u sogo write sogod OCSSessionsFolderURL "mysql://sogo:sogopasswd@localhost:3306/sogo/sogo_sessions_folder" ``` So those are 3 tables: sogo_folder_info, sogo_user_profile and sogo_sessions_folder. Where did you get the sogo_users from ?? Looking at my setup, I don't see any table with that name too: ``` MariaDB [sogo]> show tables; ++ | Tables_in_sogo | ++ | sogo_acl | | sogo_alarms_folder | | sogo_cache_folder | | sogo_folder_info | | sogo_quick_appointment | | sogo_quick_contact | | sogo_sessions_folder | | sogo_store | | sogo_user_profile | | users | ++ ``` So there is something you are not doing right! -- 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]
[SOGo] Table 'sogo.sogo_users' doesn't exist
Hi, I just did a new Sogo install on MariaDB and I get this error when logging in. Followed the instructions on https://www.sogo.nu/support/faq/how-do-i-configure-sogo-to-use-mysql.html. Deleted the database again and recreated it, same error. Using the nightly repo. Thanks! -- Met Vriendelijke Groet, Kind Regards, Salutations, Bart Coninckx Bits 'n Tricks
