https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38760

Thomas Klausner <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Passed QA

--- Comment #13 from Thomas Klausner <[email protected]> ---
I followed the test plan and it worked!

* Timezone settings work, I also see the correct timezone in the ktd-staff
interface (if I patch Koha::Database to ignore the cert)
* SHOW VARIABLES LIKE '%ssl%':
  * have_openssl and have_ssl are set to "YES"
  * The SSL cipher in use is NOT displayed (but I think the test plan is a bit
unclear here)
* STATUS:
  * Here I see the cipher in use:  
  * SSL: Cipher in use is TLS_AES_256_GCM_SHA384

Yay!

Here's the output of the two SQL commands:


MariaDB [koha_kohadev]> SHOW VARIABLES LIKE '%ssl%';
+---------------------+---------------------------------------+
| Variable_name       | Value                                 |
+---------------------+---------------------------------------+
| have_openssl        | YES                                   |
| have_ssl            | YES                                   |
| ssl_ca              | /etc/mysql/ssl/certs/ca-cert.pem      |
| ssl_capath          |                                       |
| ssl_cert            | /etc/mysql/ssl/certs/server-cert.pem  |
| ssl_cipher          |                                       |
| ssl_crl             |                                       |
| ssl_crlpath         |                                       |
| ssl_key             | /etc/mysql/ssl/private/server-key.pem |
| version_ssl_library | OpenSSL 1.1.1f  31 Mar 2020           |
+---------------------+---------------------------------------+


MariaDB [koha_kohadev]> status;
--------------
mysql  Ver 15.1 Distrib 10.5.28-MariaDB, for debian-linux-gnu (x86_64) using
readline 5.2

Connection id:          73
Current database:       koha_kohadev
Current user:           koha_kohadev@localhost
SSL:                    Cipher in use is TLS_AES_256_GCM_SHA384
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.5.28-MariaDB-ubu2004 mariadb.org binary distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /run/mysqld/mysqld.sock
Uptime:                 28 min 2 sec

Threads: 9  Questions: 2963  Slow queries: 0  Opens: 304  Open tables: 297 
Queries per second avg: 1.761
--------------

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to