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";
OCSFolderInfoURL = "mysql://
sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_folder_info";
OCSSessionsFolderURL = "mysql://
sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_sessions_folder";
OCSEMailAlarmsFolderURL="mysql://
sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_alarms_folder";
OCSStoreURL="mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_store";
OCSAclURL="mysql://sogou:XXXXXXXXXX@127.0.0.1:3306/exim4u/sogo_acl";
OCSCacheFolderURL="mysql://
sogou:XXXXXXXXXX@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]
