If your two systems are supposed to be identical, then just dump the other database schema and import it into the new server.
On Thu, Feb 1, 2024 at 11:17 AM Bits 'n Tricks <users@sogo.nu> wrote: > > > 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] > > 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 > > > -- 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]
