Versions Compared

Old Version 4

changes.mady.by.user Barry Leibson

Saved on

compared with

New Version 5

changes.mady.by.user MikeDouglassn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
title*DBMS Recommendation

Note: as of Bedework 3.7, PostgreSQL is the preferred database system used by Bedework.
While MySQL is fully supported, there is a long-standing bug in MySQL that can lead to performance issues in Bedework.

Create

...

databases; check the character set

Create five databases , one for the Calendar server, the Timezone server, the Synchronization engine, the CardDAV server, and the Event Registration system.

Name them something like: bedework3p10_cal, bedework3p10_tz, bedework3p10_synch, bedework3p10_card, bedework3p10_reg. 
Provide full access rights to an appropriately named user such as bedework.

...

Info
title In Postgres the Bedework databases might look like this:
# \list
                                     List of databases
       Name       |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges
------------------+----------+----------+-------------+-------------+-----------------------
 bedework3p10_cal  | bedework | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/bedework
                                                                    : bedework=CTc/bedework
 bedework3p10_card | bedework | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/bedework
                                                                    : bedework=CTc/bedework
 bedework3p10_reg  | bedework | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/bedework
                                                                    : bedework=CTc/bedework
 bedework3p10_synch| bedework | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/bedework
                                                                    : bedework=CTc/bedework
 bedework3p10_tz   | bedework | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/bedework
                                                                    : bedework=CTc/bedework

...

Unsupported databases
Because we use Hibernate, we don’t support databases they don’t support.  While Hibernate should make it possible to run Bedework on any Hibernate-supported database, in reality, there are problems with some systems that may require hand-editing of the schema.  We expect in time to discover a workable solution to such problems.
...