Wiki source code of Datenbank
Show last authors
author | version | line-number | content |
---|---|---|---|
1 | {{content/}} | ||
2 | |||
3 | {{formcycle/}} requires a pre-existing database for storing system related data. When installing {{formcycle/}}, the database structure is initialized automatically by the system. You only need to provide a connection to working database. | ||
4 | |||
5 | {{warning}} | ||
6 | {{formcycle case="dat"/}}no longer supplies database drivers. It is necessary to install the appropriate database driver for the database management system you are using. | ||
7 | |||
8 | {{version major="7" minor="0" patch="10"}}{{/version}} Starting with {{formcycle/}} version 7.0.10, this also applies to the H2 database driver that was still included in earlier releases. | ||
9 | |||
10 | Further information can be found [[here>>doc:Formcycle.SystemSettings.DatabaseDrivers]]. | ||
11 | {{/warning}} | ||
12 | |||
13 | == Database connection == | ||
14 | |||
15 | {{figure image="database_settings_en.png" width="600"}} | ||
16 | The settings for the database connection. After you change these settings, the database and the system gets updated automatically. | ||
17 | {{/figure}} | ||
18 | |||
19 | ; Database type | ||
20 | : Select the database type of the database you would like to use. | ||
21 | ; JDBC connection URL | ||
22 | : Every database has got slightly different URL for establishing a connection. Click on the //example// button to the right to see a list of common URLs. | ||
23 | ; Database user | ||
24 | : User name for the database login. | ||
25 | ; DB password | ||
26 | : Password for the database login. | ||
27 | |||
28 | == Advanced settings == | ||
29 | |||
30 | {{info}} | ||
31 | {{version major="7" minor="1"/}} You can also use the JVM parameters //xfcAutoUpdate// and //xfcUpdateCallbackEmails// to override the settings for the auto update. | ||
32 | {{/info}} | ||
33 | |||
34 | |||
35 | ; {{version major="7" minor="1"/}} Apply pending updates automatically on system start | ||
36 | : When enabled, all pending database and system updates are run automatically when the {{formcycle/}} application is started. This avoids having to run the updates manually and helps to reduces down times during updates. | ||
37 | ; {{version major="7" minor="1"/}} Send notification about update results to the following email addresses | ||
38 | : A list of email addresses. When the automatic update finishes, a status report is sent to these email addresses (requires a valid mail server configuration). The report contains information about the update status (success or error) and any error messages in case of an error. | ||
39 | ; Connections | ||
40 | : The maximum number of connections between {{formcycle/}} and the database at any given time. | ||
41 | ; Timeout | ||
42 | : The time an open connection between must remain idle for the connection between {{formcycle/}} and the database to be closed. When set to 0, no timeout is applied. | ||
43 | |||
44 | == Database encryption == | ||
45 | |||
46 | {{formcycle/}} provides the option to enable encryption for the database to prevent against unauthorized access. Meta data is always encrypted and form data may be encrypted optionally. | ||
47 | |||
48 | To activate encryption, you must set the following options: | ||
49 | |||
50 | ; Algorithm | ||
51 | : The encryption alogrithm to be used. The default is //PBE with SHA and Twofish-CBC (recommended)//. | ||
52 | ; Encrypt form data | ||
53 | : Enable this option to encrypt data of submitted forms including all attachments. When you use a mySQL database, [[form specific data tables>>Formcycle.UserInterface.MyForms.Inbox]] are encrypted as well. | ||
54 | ; Update encryption of data sets | ||
55 | : When thic option is checked, the data gets encrypted with the entered password. | ||
56 | ; Password confirmation | ||
57 | : The password used to encrypt the data with the selected algorithm. | ||
58 | |||
59 | {{warning}} | ||
60 | Depening on the chosen encryption algorithm, the password and the Java version you are using it may become necessary to install the //Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files//. If these files are missing, an appropriate error message will be displayed. | ||
61 | {{/warning}} | ||
62 | |||
63 | == Migrating data sets == | ||
64 | |||
65 | Enable the option //Update encryption of data sets// to migrate existing, encrypted data. The encrypted data is decrypted with the password entered in //Password confirmation// and encrypted again with the new password. | ||
66 | |||
67 | == Create or update the database == | ||
68 | |||
69 | Click on //Save and update// to continue to update the database and system. If the database is empty, new tables will be created. Otherwise, the database is updated. Once the database is up-to-date, all necessary system updates are run automatically. |