Added new MySQLi parameters/info to default database config file. Fixed missing new MySQLi parameters from database configuration documentation examples.
Signed-off-by: Tim Nolte <noltet@sekisui-spi.com>
diff --git a/application/config/database.php b/application/config/database.php
index 925b3e5..36ae83d 100644
--- a/application/config/database.php
+++ b/application/config/database.php
@@ -43,6 +43,12 @@
| ['compress'] Whether or not to use client compression (MySQL only)
| ['stricton'] TRUE/FALSE - forces 'Strict Mode' connections
| - good for ensuring strict SQL while developing
+| ['db_options'] Used to set various database connections options and values. (MySQLi only)
+| ['ssl_key'] The path name to the key file. (MySQLi only)
+| ['ssl_cert'] The path name to the certificate file. (MySQLi only)
+| ['ssl_ca'] The path name to the certificate authority file. (MySQLi only)
+| ['ssl_capath'] The pathname to a directory that contains trusted SSL CA certificates in PEM format. (MySQLi only)
+| ['ssl_cipher'] A list of allowable ciphers to use for SSL encryption. (MySQLi only)
| ['failover'] array - A array with 0 or more data for connections if the main should fail.
| ['save_queries'] TRUE/FALSE - Whether to "save" all executed queries.
| NOTE: Disabling this will also effectively disable both
@@ -80,6 +86,12 @@
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
+ 'db_options' => array(),
+ 'ssl_key' => '',
+ 'ssl_cert' => '',
+ 'ssl_ca' => '',
+ 'ssl_capath' => '',
+ 'ssl_cipher' => '',
'failover' => array(),
'save_queries' => TRUE
);
diff --git a/user_guide_src/source/database/configuration.rst b/user_guide_src/source/database/configuration.rst
index 1d10bc1..510037d 100644
--- a/user_guide_src/source/database/configuration.rst
+++ b/user_guide_src/source/database/configuration.rst
@@ -30,6 +30,12 @@
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
+ 'db_options' => array(),
+ 'ssl_key' => '',
+ 'ssl_cert' => '',
+ 'ssl_ca' => '',
+ 'ssl_capath' => '',
+ 'ssl_cipher' => '',
'failover' => array()
);
@@ -71,7 +77,13 @@
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
- 'stricton' => FALSE
+ 'stricton' => FALSE,
+ 'db_options' => array(),
+ 'ssl_key' => '',
+ 'ssl_cert' => '',
+ 'ssl_ca' => '',
+ 'ssl_capath' => '',
+ 'ssl_cipher' => ''
),
array(
'hostname' => 'localhost2',
@@ -89,7 +101,13 @@
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
- 'stricton' => FALSE
+ 'stricton' => FALSE,
+ 'db_options' => array(),
+ 'ssl_key' => '',
+ 'ssl_cert' => '',
+ 'ssl_ca' => '',
+ 'ssl_capath' => '',
+ 'ssl_cipher' => ''
)
);
@@ -120,6 +138,12 @@
'compress' => FALSE,
'encrypt' => FALSE,
'stricton' => FALSE,
+ 'db_options' => array(),
+ 'ssl_key' => '',
+ 'ssl_cert' => '',
+ 'ssl_ca' => '',
+ 'ssl_capath' => '',
+ 'ssl_cipher' => '',
'failover' => array()
);