On Tue, Jan 30, 2024 at 9:19 PM Bits 'n Tricks <users@sogo.nu> 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:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_user_profile [1]";
OCSFolderInfoURL =
"mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_folder_info [2]";
OCSSessionsFolderURL =
"mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_sessions_folder
[3]";
OCSEMailAlarmsFolderURL="mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_alarms_folder
[4]";
OCSStoreURL="mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_store
[5]";
OCSAclURL="mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_acl
[6]";
OCSCacheFolderURL="mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_cache_folder
[7]";
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]
Bottom postingi in HTML mails is not ideal, that's why I don't do it
usually.
Anyway, I have only one occurrence in the sogo.conf file and it is
this:
viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users";
But it is also in my other serverwhich does work with that config and
it also has the sogo_users table ...
BC
Links:
------
[1] http://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_user_profile
[2] http://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_folder_info
[3] http://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_sessions_folder
[4] http://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_alarms_folder
[5] http://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_store
[6] http://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_acl
[7] http://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_cache_folder