View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004931SOGoBackend Calendarpublic2020-01-09 16:192022-01-07 21:20
Reporterfrancesco.malevolti Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionfixed 
PlatformLINUXOSDebianOS Version9.11
Product Version4.1.0 
Summary0004931: Sogo doesn't create table in db
Description

Hi,
we have Sogo 4.1.0 with a MariaDB database. Database are located on another VM.
With some of our users when we create an event in the calendar the event is not displayed in the gui. If I am the user A and create an event by inviting user B, B gets the invitation correctly and the related event is shown correctly in B calendar. But in my calendar, the A calendar the event is not displayed.
Checking in SOGo log we find several attempts to access tables related to the user A in the database that do not exist.
For example in sogo.log we get something like this:
"<MySQL4Exception: 0x55850bb52b20> NAME:ExecutionFailed REASON:Table 'sogo.sogoprovaeve00251e7b20c_quick' doesn't exist" related to the user prova_calendar@xxx.com

There are no such tables related to this user in the database, and the same goes for many other users. If I create new user, same story, no tables for him.

Can you help us?
Thanks

Francesco

Tagscalendar, MariaDB, mysql, tables

Activities

Christian Mack

Christian Mack

2020-01-10 09:06

developer   ~0014044

Did you move your database from a local one to that remote VM, or did the remote VM change its DNS name?
Does your account for mysql access have the necessary permissions to create tables in the sogo database?
francesco.malevolti

francesco.malevolti

2020-01-10 11:25

reporter   ~0014046

Hi, thanks for the reply.
No there were no changes on the db or VM, not even in DNS name.
The account have all privileges on sogo database.
Trying to manually create one of the tables on which sogo tries to access but which do not exist, I get an error on the length of the primary key (c_name field). Based on the tests I did, names of the tables that sogo tries to access are always the same length, can I work on the names that sogo generates for these tables somewhere in the configuration files?
francis

francis

2022-01-07 21:20

administrator   ~0015734

Please try the latest version. Reopen the ticket if necessary.

Issue History

Date Modified Username Field Change
2020-01-09 16:19 francesco.malevolti New Issue
2020-01-09 16:19 francesco.malevolti Tag Attached: calendar
2020-01-09 16:19 francesco.malevolti Tag Attached: tables
2020-01-09 16:19 francesco.malevolti Tag Attached: mysql
2020-01-09 16:19 francesco.malevolti Tag Attached: MariaDB
2020-01-10 09:06 Christian Mack Note Added: 0014044
2020-01-10 11:25 francesco.malevolti Note Added: 0014046
2022-01-07 21:20 francis Status new => closed
2022-01-07 21:20 francis Resolution open => fixed
2022-01-07 21:20 francis Note Added: 0015734