0

Its impossible to connect to Planetscale cloud Mysql DB from PHP. I try with mysqli doing :

$hostname = "secret";
                $dbName = "secret";
                $port = "3306";
                $ssl = "/etc/ssl/certs/ca-certificates.crt";
                $user="secret";
                $passs="pscale_pw_xxx";

                $mysqli = mysqli_init();
                $mysqli->ssl_set(NULL, NULL, $ssl, NULL, NULL);
                $mysqli->real_connect($hostname,$user, $passs, $dbName, $port);

                if ($mysqli->connect_error) {
                    echo 'not connected to the database';
                } else {
                    echo "Connected successfully";
                    $mysqli->query("create table test(TOTO text)");
                }

i have bad messages : "
Warning: mysqli::real_connect(): this stream does not support SSL" and message like "
Warning: mysqli::real_connect(): Cannot connect to MySQL by using SSL" and also "
Warning: mysqli::query(): invalid object or resource mysqli"
etc...

I have tried PDO solution with no sucess at all, my code below


  
  
  function Connect_Planet($HOST, $LOGIN, $PASS, $DB_NAME)
  {
      
      
        try {
            
            $dsn = 'mysql:host=' . $HOST . ';dbname=' . $DB_NAME;
            $user = "";
            $dbP = "";
            $options = array(
                1009 => "/etc/ssl/certs/ca-certificates.crt",
                1014 => false,
                PDO::MYSQL_ATTR_SSL_CA => "/etc/ssl/certs/ca-certificates.crt"
            );
            
          
                                    
            $this->CONN = new PDO($dsn, $LOGIN, $PASS,$options);
            $this->CONN->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
       
        } catch(PDOException $e) {
            
            $this->MSG= $e->getMessage();
             $this->IS_OPEN=0;
            return 0;
        }
        
            $this->VAR_HOST=$HOST;
            $this->VAR_LOGIN=$LOGIN;
            $this->VAR_PASS=$PASS;
            $this->VAR_DBNAME=$DB_NAME;
            $this->IS_OPEN=1;
            
          return 1;   
         
                     
  }

If someone have succeed with php and planetscale database working fine, please let me know how u did it. Thanks in advance,

Paul T.
  • 4,703
  • 11
  • 25
  • 29
Johna Pop
  • 11
  • 4
  • Why do you try to use SSL encryption if the error message clearly tells you that this is not working? – Nico Haase May 07 '23 at 14:32
  • if i try using mysqli without ssl, still have errors : ```Warning: mysqli::real_connect(): (HY000/1105): unknown error: Code: UNAVAILABLE server does not allow insecure connections, client must use SSL/TLS``` – Johna Pop May 07 '23 at 15:20
  • Can you try to create a single php file with a very simple connection like shown in either https://dev.to/iamluisj/connecting-to-planetscale-with-a-pdo-object-in-php-2h09 or https://github.com/planetscale/php-example/blob/main/db.php and see if that helps? Once a small connection PHP script is created, you can do more testing on it. https://planetscale.com/docs/concepts/secure-connections#ca-root-configuration shows which CA cert to use. – zedfoxus May 07 '23 at 15:25
  • thanks for your answers any of the solutions provided worked...No solutions for now – Johna Pop May 07 '23 at 22:17
  • Which OS are you using? Did you test the connection with the sample php/pdo code provided in the dashboard? – Drk May 22 '23 at 16:58

0 Answers0