Hi,
thanks for your reply.
I found out that the tables
sogo_acl
sogo_alarms_folder
sogo_cache_folder
sogo_quick_appointment
sogo_quick_contact
and
sogo_store
were missing, seamingly.
The three tables you were talking about are these
"sogousernamehash,_acl,_quick" ones, i guess?
Those are generated at first login, yes.
I found the schema in the sources and applied it so the above tables
have been generated.
Everything seems to work now.
Thanks
Christian
Am 21.09.23 um 14:59 schrieb "Raoul Schroeder"
(raoul.schroe...@global-ist.net):
Hi Christian,
I just set up a similar system myself.
There should be three tables per user for the calendar and three per user for
the contacts.
They are created automatically when a user logs in for the first time, or also
if you ever delete them.
You probably need to enable mysql debugging, but just out of curiosity, can you
look at /var/log/sogo/sogo.log if there is an error message when you try and
create a new calendar entry?
You do get the empty calendar view.
One of the things I got wrong initially was the encoding of the table and what
was configured in /etc/sogo/sogo.conf, so you might want to check that as well.
It does not sound like that is your issue, though.
What does a select * from sogo_folder_info; get in mysql?
-----Ursprüngliche Nachricht-----
Von: users-requ...@sogo.nu <users-requ...@sogo.nu> Im Auftrag von Christian Lox
Gesendet: Donnerstag, 21. September 2023 11:49
An: users@sogo.nu
Betreff: [SOGo] Mysql schema on ubuntu deb
Hi all,
i am evaluating sogo (ubuntu 22.04, nightly build 5.8.4.20230919-1 installed
from repo, mysql as database).
However i am unable to find the mysql schema to apply.
When starting for the first time 3 tables are created (sogo_folder_info,
sogo_sessions_folder and sogo_user_profile). In addition i created a view on
our vmail database.
Simple email use does work, but when trying to add appointments or contacts it
fails.
After digging through the archives and web I found there should be additional
tables (i.e. i read something about c_partmails), but i am unable to find the
schema.
Should the tables be created at sogo startup, like the three i mentioned above?
I only find some updates in /usr/share/docs/ but not some initial schema.
Any hint appreciated,
Christian