phpmyadmin / phpmyadmin/phpmyadmin
Setting ssl_ca results in OpenSSL error.
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 7.9k
- Forks
- 3.6k
- Avg merge
- 4d 18h
- Merged PRs (30d)
- 36
Description
Describe the bug
Login fails with:
mysqli_real_connect(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed
To Reproduce
Set options ssl and ssl_ca in config.inc.php
Expected behavior
Successful login and message in database server info box that Server connection: SSL is used with certification authority.
Server configuration
- Operating system: Debian GNU/Linux 9
- Web server: apache 2.4.25-3+deb9u9
- Database version: 10.4.12-MariaDB-1:10.4.12+maria~buster-log - mariadb.org binary distribution
- PHP version: 7.2.29-1+0~20200320.39+debian9~1.gbp513c2e
- phpMyAdmin version: 4.9.5
Client configuration
- Browser: firefox 75.0+build3-0ubuntu0.19.10.1
- Operating system: Ubuntu 19.10
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the ssl and ssl_ca settings in config.inc.php and reproduce the failed login using the reported MariaDB and PHP versions. Trace the connection failure from the OpenSSL certificate verification error. Done means login succeeds and the database server information reports SSL with a certification authority.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mariadb, php
- Domain
- databases, security
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 28/100