Re: [SOGo] SOGo database schema

2022-01-04 Thread Peter Beck
Cédric Archambeau quatschte am Wed, Dec 29, 2021 at 12:22:34PM +0100: > Hi Andre, > > Lots of disagrees with the form in your message. > > Remember you benefit from a FOSS. > Not OK with some feature ?  Report a bug, maybe pull a request (*you* could > hire a database administrator to redesign da

Re: [SOGo] SOGo database schema

2021-12-29 Thread cedric.archamb...@solidairesfinancespubliques.org
Hi Andre, Lots of disagrees with the form in your message. Remember you benefit from a FOSS. Not OK with some feature ?  Report a bug, maybe pull a request (*you* could hire a database administrator to redesign database schema), or discuss (not assault !) it here. SOGo nightly is *free*, but

Re: [SOGo] SOGo database schema

2021-12-26 Thread mj
Hi, Only to say: YES, specially on #3: the credentials in clear text inside the database. It's terrible. And additionally makes it so much more difficult to change the database credentials than it really should be. MJ Op 23-12-2021 om 10:33 schreef André Rodier (an...@rodier.me): Good morni

[SOGo] SOGo database schema

2021-12-24 Thread an...@rodier.me
Good morning, all. OK, SOGo is the only working CalDAV / CardDAV server with an acceptable level of quality, at least to me, in the standard Debian repository. The two absolute requirements for me are LDAP authentication and a working user interface over https. So I have to use it, fair enoug

Re: [SOGo] SOGo database move - unsuccessfull

2013-01-28 Thread Khapare Joshi
hi, I had to do pg_dump all and restore then also disabled the ipv6 on the machine. This all worked. thanks KH On Thu, Jan 24, 2013 at 5:19 PM, Christian Mack < christian.m...@uni-konstanz.de> wrote: > Hello Khapare Joshi > > > Am 2013-01-24 18:08, schrieb Khapare Joshi: > > > > I have been ru

Re: [SOGo] SOGo database move - unsuccessfull

2013-01-24 Thread Christian Mack
Hello Khapare Joshi Am 2013-01-24 18:08, schrieb Khapare Joshi: > > I have been running sogo for now two years in virtual server. since > users increased I wanted to move to another physical server. I am having > issue with sogo database. I dumped the sogo database with pg_dump and > tried to re

[SOGo] SOGo database move - unsuccessfull

2013-01-24 Thread Khapare Joshi
Hello all, I have been running sogo for now two years in virtual server. since users increased I wanted to move to another physical server. I am having issue with sogo database. I dumped the sogo database with pg_dump and tried to restore with pg_restore. At the end of the pg_restore i get followi

Re: [SOGo] SOGo Database Cleanup

2011-12-01 Thread Milos Wimmer
On Thu, 1 Dec 2011, Luca Olivetti wrote: More than accents, I had problems with newlines (i.e., when a note is in multiple lines), at least I see funambol complaints about "encountered \r\n" and stops the synchronization. look at http://www.sogo.nu/bugs/view.php?id=904 Regards MW -- users@s

Re: [SOGo] SOGo Database Cleanup

2011-12-01 Thread Luca Olivetti
Al 29/11/2011 21:42, En/na Dominique ha escrit: So now I have a working calendar, but with entries that need to be cleanup. Does anyone have any idea/tools/scripts how to massively cleanup the database: massive change in times depending on the time zone selected, accent cleanups, More than

[SOGo] SOGo Database Cleanup

2011-11-29 Thread Dominique
Hi, I have been trying to sync Sogo with Funanbol to Mobile devices for a long time now. If it basically works, I discovered through trial and error that where two major flows in those processes (probably to my own fault): 1. Time synchronization (GMT+xxx) 2. Languages in use - Mostly accent

[SOGo] SOGo Database Cleanup

2011-11-29 Thread Dominique
Hi, I have been trying to sync Sogo with Funanbol to Mobile devices for a long time now. If it basically works, I discovered through trial and error that where two major flows in those processes (probably to my own fault): 1. Time synchronization (GMT+xxx) 2. Languages in use - Mostly accent

Re: [SOGo] SOGo database

2011-04-25 Thread Milos Wimmer
On Tue, 26 Apr 2011, Sven Marth wrote: Hi Sven, you should increase the kernels maximum size of shared memory segment. To do this. edit your /etc/sysctl.conf. For example: kernel.shmmax = 134217728 (sets the value to 128 MB). You can also find a explanation in http://www.postgresql.org/docs/8.

Re: [SOGo] SOGo database

2011-04-25 Thread Sven Marth
Am 26.04.2011 08:05, schrieb Milos Wimmer: > On Tue, 26 Apr 2011, Pascal Gienger wrote: > > Hello Pascal, > >> What's the size/value of >> >> shared_buffers = ... >> and >> max_locks_per_transaction = ... >> >> in your postgresql.conf? > > > shared_buffers = 24MB [default v

Re: [SOGo] SOGo database

2011-04-25 Thread Milos Wimmer
On Tue, 26 Apr 2011, Pascal Gienger wrote: Hello Pascal, What's the size/value of shared_buffers = ... and max_locks_per_transaction = ... in your postgresql.conf? shared_buffers = 24MB [default value] max_locks_per_transaction = 256 [default value = 64] than

Re: [SOGo] SOGo database

2011-04-25 Thread Pascal Gienger
Am 26.04.11 00:17, schrieb Milos Wimmer: On Thu, 21 Apr 2011, Pascal Gienger wrote: We have 60552 tables now, and the WAL backup (hot backup) is still running without any problem. PostgreSQL 8.4.7 on Ubuntu 10.04 LTS Server with different volumes for DB files and for DB log (WAL) files, 1G sha

Re: [SOGo] SOGo database

2011-04-25 Thread Milos Wimmer
On Thu, 21 Apr 2011, Pascal Gienger wrote: We have 60552 tables now, and the WAL backup (hot backup) is still running without any problem. PostgreSQL 8.4.7 on Ubuntu 10.04 LTS Server with different volumes for DB files and for DB log (WAL) files, 1G shared memory. I have 125406 tables now,

Re: [SOGo] SOGo database

2011-04-20 Thread Pascal Gienger
Am 21.04.11 07:40, schrieb Martin Rabl: @Pascal Gienger: Pascal, you work with a large SOGo-Installation, do you have any problems with the many tables? We use two Postgres instances: One locally on the SOGo system for the session table, and one in a central Postgres Server infrastructure to

Re: [SOGo] SOGo database

2011-04-20 Thread Martin Rabl
Hi, I was wondering, too. It is a little bit ... strange, in terms of common database design ;-) But it is easy to understand: Every table is a folder of an user. Contacts are folders, calendars are folders ... The current used folder for contacts or calendars you will find in the folder_info-

[SOGo] SOGo database

2011-04-20 Thread dkillen
I was wondering about the structure of SOGo's database. I am using MySQL, not that it is probably all that relevant to this question. Each user appears to have many tables generated for it. I was wondering if there is a finite set of tables that a single user is likely to have, or are these generat