adminer icon indicating copy to clipboard operation
adminer copied to clipboard

MySQL PDO Add possibility to disable verification of the server SSL certificate.

Open araisch opened this issue 4 years ago • 7 comments

While using explicitly mysqli as driver the server certificate verification is switched to false by default, using Standard driver PDO it can't be disabled. There are some use-cases making that the only way to use TLS (e.g. running with Self-Signed Certificates in Docker). No PHP-Skills, so please check :)

araisch avatar Feb 10 '22 12:02 araisch

@araisch Please add for MS SQL also. You should get something like TrustServerCertificate=yes in connection info

Kabingeran avatar Dec 17 '22 03:12 Kabingeran

@Kabingeran Since this seems pretty abandonded and I have no MS SQL to check and additionally I am no php-coder at all, I can't help you. Sorry.

araisch avatar Dec 19 '22 07:12 araisch

@araisch I use MS SQL in docker just like you use MySQL. If you need a link, I can share. Right now I just change the mssql.inc.php file to make it work.

Kabingeran avatar Dec 20 '22 00:12 Kabingeran

@Kabingeran To be more precisely: I made this PR because I was in need for that feature and wanted to preserve others from searching again. I have absolutely no capacity for doing anything even if I had the skills and the environment needed..

araisch avatar Dec 20 '22 07:12 araisch

OK. I'll do it myself if anyone else votes for this functionality

Kabingeran avatar Dec 20 '22 14:12 Kabingeran

Not sure if you're still willing to accept votes, but count me as +1 for Adminer adding the TrustServerCertificate=yes option for SQL Server.

gth avatar Oct 04 '23 09:10 gth

@gth https://github.com/vrana/adminer/pull/481

Kabingeran avatar Oct 05 '23 18:10 Kabingeran

Are there any projects to develop for a fee?

Kabingeran avatar Oct 06 '23 15:10 Kabingeran