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 <users@sogo.nu> 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]
