catfan / Medoo

The lightweight PHP database framework to accelerate the development.
https://medoo.in
MIT License
4.83k stars 1.15k forks source link

Can't connect to db #1095

Closed renetsk closed 1 year ago

renetsk commented 1 year ago

Hello, how can I fix this please? Fatal error: Uncaught PDOException: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /data/testweb/vendor/catfan/medoo/src/Medoo.php:478 Stack trace: #0 /data/testweb/include/config.php(7): Medoo\Medoo->__construct(Array) #1 /data/testweb/index.php(6): require('/data/c/5/c560d...') #2 {main} thrown in /data/testweb/vendor/catfan/medoo/src/Medoo.php on line 478

Database is on AWS. My config looks like:

<?php
// Using Medoo namespace.
use Medoo\Medoo;

// Connect the database.
$database = new Medoo([
    'type' => 'mysql',
    'host' => '***.amazonaws.com',
    'database' => '***',
    'username' => '***',
    'password' => '***'
]);
renetsk commented 1 year ago

ok fixed by add:

'option' => array(
        PDO::MYSQL_ATTR_SSL_CA => '',
            PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false
        )