[Bacula-bugs] [Feature Requests 0002164]: [PATCH] Add SSL connections to database open code

[Mantis B. T. <no...@bu...>]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.bacula.org/view.php?id=2164 
====================================================================== 
Reported By:                emiliaarruda
Assigned To:                
====================================================================== 
Project:                    Feature Requests
Issue ID:                   2164
Category:                   General
Reproducibility:            N/A
Severity:                   minor
Priority:                   normal
Status:                     new
====================================================================== 
Date Submitted:             2015-09-03 22:48 BST
Last Modified:              2015-09-11 14:37 BST
====================================================================== 
Summary:                    [PATCH] Add SSL connections to database open code
Description: 
The MySQL server is configured to use SSL connections. This patch permits that
catalog could be accessed using SSL connections between director and the MySQL
server hosting bacula database.

Additional Information: 
Add SSL connections to database open code:

- ./configure must be run with --with-db-ssl-options new option. The value
informed here will be the value for the GRANT statement / REQUIRE clause. Valid
values are: none, ssl, x509, issuer 'issuer', subject 'subject'
(https://dev.mysql.com/doc/refman/5.0/en/grant.html).

- new catalog directives:

* db_ssl_key:  the path name to the key file.
* db_ssl_cert: the path name to the certificate file.
* db_ssl_ca: the path name to the certificate authority file.
* db_ssl_capath: the path name to a directory that contains trusted SSL CA
certificates in PEM format.
* db_ssl_cipher: a list of permissible ciphers to use for SSL encryption.

Any unused SSL parameters may be given as NULL.

For correctly setting of these new directives, please see
(https://dev.mysql.com/doc/refman/5.0/en/grant.html) for GRANT statement /
REQUIRE clause.
====================================================================== 

---------------------------------------------------------------------- 
 (0007181) emiliaarruda (reporter) - 2015-09-04 05:56
 http://bugs.bacula.org/view.php?id=2164#c7181 
---------------------------------------------------------------------- 
Added the patch for 7.2 version. 

---------------------------------------------------------------------- 
 (0007182) emiliaarruda (reporter) - 2015-09-08 17:30
 http://bugs.bacula.org/view.php?id=2164#c7182 
---------------------------------------------------------------------- 
Sorry, the new catalog directives do not have underscores:

* dbsslkey: the path name to the key file.
* dbsslcert: the path name to the certificate file.
* dbsslca: the path name to the certificate authority file.
* dbsslcapath: the path name to a directory that contains trusted SSL CA
certificates in PEM format.
* dbsslcipher: a list of permissible ciphers to use for SSL encryption. 

---------------------------------------------------------------------- 
 (0007184) emiliaarruda (reporter) - 2015-09-09 18:13
 http://bugs.bacula.org/view.php?id=2164#c7184 
---------------------------------------------------------------------- 
Added new patch for 7.2.0 version with corrections of segmentation fault errors.


---------------------------------------------------------------------- 
 (0007186) emiliaarruda (reporter) - 2015-09-11 14:37
 http://bugs.bacula.org/view.php?id=2164#c7186 
---------------------------------------------------------------------- 
Added 7.2-MySQL-SSL-new-2.patch with corrections. I'm not able to delete the old
ones. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2015-09-03 22:48 emiliaarruda   New Issue                                    
2015-09-03 22:48 emiliaarruda   File Added:
7.0-Add-SSL-connections-to-database-open-code.patch                    
2015-09-04 05:56 emiliaarruda   File Added: 7.2-MySQLSSL.patch                  
 
2015-09-04 05:56 emiliaarruda   Note Added: 0007181                          
2015-09-08 17:30 emiliaarruda   Note Added: 0007182                          
2015-09-09 18:11 emiliaarruda   File Added: 7.2-MySQL-SSL-new.patch             
      
2015-09-09 18:13 emiliaarruda   Note Added: 0007184                          
2015-09-11 14:35 emiliaarruda   File Added: 7.2-MySQL-SSL-new-2.patch           
        
2015-09-11 14:37 emiliaarruda   Note Added: 0007186                          
======================================================================