Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.nlo
	1	+XWiki.sas

Content

...	...	@@ -1,36 +1,35 @@
1	1	{{content/}}
2	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.
	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	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.
5	5
6		-== Configuring the database connection ==
	8	+Further information can be found [[here>>doc:Formcycle.SystemSettings.DatabaseDrivers]].
	9	+{{/warning}}
7	7
8		-{{figure image="database1.png" width="300"/}}
	11	+== Database connection ==
9	9
10		-=== Database type ===
	13	+{{figure image="database_settings_en.png" width="600"}}
	14	+The settings for the database connection. After you change these settings, the database and the system gets updated automatically.
	15	+{{/figure}}
11	11
12		-Select the database type of the database you would like to use.
	17	+; Database type
	18	+: Select the database type of the database you would like to use.
	19	+; JDBC connection URL
	20	+: 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.
	21	+; Database user
	22	+: User name for the database login.
	23	+; DB password
	24	+: Password for the database login.
13	13
14		-=== JDBC-Connection URL ===
	26	+== Advanced settings
15	15
16		-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.
	28	+; Connections
	29	+: The maximum number of connections between {{formcycle/}} and the database at any given time.
	30	+; Timeout
	31	+: 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.
17	17
18		-=== Max. number of parallel connections ===
19		-
20		-The maximum number of connections between {{formcycle/}} and the database at any given time.
21		-
22		-=== Connection timeout in seconds (0 ~= none) ===
23		-
24		-The time an open connection between must remain idle for the connection between {{formcycle/}} and the database to be closed.
25		-
26		-=== Database user ===
27		-
28		-User name for the database login.
29		-
30		-=== DB password ===
31		-
32		-Password for the database login.
33		-
34	34	== Database encryption ==
35	35
36	36	{{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.
...	...	@@ -37,42 +37,27 @@
37	37
38	38	To activate encryption, you must set the following options:
39	39
40		-=== Algorithm ===
	39	+; Algorithm ===
	40	+: The encryption alogrithm to be used. The default is //PBE with SHA and Twofish-CBC (recommended)//.
	41	+; Encrypt form data
	42	+: 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.
	43	+; Update encryption of data sets
	44	+: When thic option is checked, the data gets encrypted with the entered password.
	45	+; Password confirmation
	46	+: The password used to encrypt the data with the selected algorithm.
41	41
42		-The encryption alogrithm to be used. The default is //PBE with SHA and Twofish-CBC (recommended)//.
	48	+{{info}}
	49	+When you enter a passwort, the system checks whether that password is valid. This prevents data loss and data from being encrypted twice. Please note that this feature is available only since version 6. When you update from version 5 to version 6, the password cannot be checked.
	50	+{{/info}}
43	43
44		-=== Encrypt form data ===
45		-
46		-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.
47		-
48		-=== Passwort ===
49		-
50		-The password uses to encrypt the data.
51		-
52	52	{{warning}}
53	53	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.
54	54	{{/warning}}
55	55
56		-=== Migrating data sets ===
	56	+== Migrating data sets ==
57	57
58		-Enable this option to perform data migration when you click next. This needs to done every time you change the password or activate data encryption for the first time. This is possible even while {{formcycle/}} is still running.
	58	+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.
59	59
60		-When this option is selected, the previos configuration will be used to decrypt the data and the newly entered configuration will be used to encrypt the data again.
	60	+== Create or update the database ==
61	61
62		-=== Password confirmation ===
63		-
64		-In case the encryption has already been active, you must enter the password used to encrypt the data here. Otherwise the encryption method cannot be changed or deactivated, even if the database connection has been changed.
65		-
66		-{{error}}
67		-To prevent data loss, it is recommended to make a backup of the current database before modifying the database configuration.
68		-{{/error}}
69		-
70		-=== Initializing the database ===
71		-
72		-{{figure image="FCSnapshot21.png" width="300"/}}
73		-
74		-Click on //Next// to proceed with the database initialization. This will create all required tables and entries automatcally.
75		-
76		-{{figure image="FCSnapshot22.png"/}}
77		-
78		-After the database initialization has completed successfully, you will be redirected to the system update page. This is important only when performing an update of {{formcycle/}}. When you are installing {{formcycle/}} for the first time, you do not need to perform the update.
	62	+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.