Styjun

Giving blur shadow to plot

Is it ethical to tell my teaching assistant that I like him?

How did pilots avoid thunderstorms and related weather before “reliable” airborne weather radar was introduced on airliners?

Can't understand how static works exactly

High income and difficulty during interviews

Can someone explain the English 'W' sound?

Short story where a flexible reality hardens to an unchanging one

How can I deal with someone that wants to kill something that isn't supposed to be killed?

RC differentiator giving a higher output amplitude than input amplitude

What rules turn any attack that hits a given target into a critical hit?

What does a black-and-white Puerto Rican flag signify?

Are there any English words pronounced with sounds/syllables that aren't part of the spelling?

Is it OK to accept a job opportunity while planning on not taking it?

Why do people say "I am broke" instead of "I am broken"?

My current job follows "worst practices". How can I talk about my experience in an interview without giving off red flags?

What kind of vegetable has pink and white concentric rings?

What kind of anatomy does a centaur have?

Does Impedance Matching Imply any Practical RF Transmitter Must Waste >=50% of Energy?

Can I make an Opportunity Attack during Time Stop?

How does mathematics work?

Why can't a country print its own money to spend it only abroad?

How can I indicate that what I'm saying is not sarcastic online?

"It is what it is" in French

How often should alkaline batteries be checked when they are in a device?

mysqli sll connection fails with “Got an error reading communication packets”

How to use mysqli connection with SSLMySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytesLocking in PHP to acheive a crtitical section - unexpected results with MySQLRe-sizing a webpagePhp echo a row values by unique code and emailHow can I pull Data from an SQL table using PHP inside an HTMLSSL self-signed certifications to connect with Mysql with PHPCan't count records in PHP result set hitting a SQL database?mysql is not connected in my local serverdata not retrieving from online mysql serverUnable to connect my sql server from PHP

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

When trying to connect to a mysql database in php-7.2 using ssl, it results in the error Got an error reading communication packets

SSL was setup on the server using the command:

sudo mysql_ssl_rsa_setup --uid=mysql

So far I have tried the following approaches:

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


$conn->options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
mysqli_ssl_set($conn,NULL,NULL,"scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?>

and...

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


mysqli_ssl_set($conn,"scripts/ssl/client-key.pem","scripts/ssl/client-cert.pem","scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?> 

I temporally added:

$homepage = file_get_contents("scripts/ssl/client-key.pem");
echo $homepage;

to the code which printed the cert to the screen, so I know that the file paths are correct.

The SSL files were all pulled straight from the server running mysql so there should be no issues there either.

mysqli_connect_error() returns nothing. The only error is Got an error reading communication packets from /var/log/mysql/error.log

I found the methods above from this stack overflow question.

The linked post references this documentation, which is only slightly more useful than the official docs. Documentation on SSL with mysqli seems rather lacking.

Any suggestions on what I am doing wrong

php mysql ssl mysqli

share|improve this question

asked Mar 26 at 14:22

cheesemarathoncheesemarathon

2566 bronze badges

add a comment | 

0

When trying to connect to a mysql database in php-7.2 using ssl, it results in the error Got an error reading communication packets

SSL was setup on the server using the command:

sudo mysql_ssl_rsa_setup --uid=mysql

So far I have tried the following approaches:

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


$conn->options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
mysqli_ssl_set($conn,NULL,NULL,"scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?>

and...

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


mysqli_ssl_set($conn,"scripts/ssl/client-key.pem","scripts/ssl/client-cert.pem","scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?> 

I temporally added:

$homepage = file_get_contents("scripts/ssl/client-key.pem");
echo $homepage;

to the code which printed the cert to the screen, so I know that the file paths are correct.

The SSL files were all pulled straight from the server running mysql so there should be no issues there either.

mysqli_connect_error() returns nothing. The only error is Got an error reading communication packets from /var/log/mysql/error.log

I found the methods above from this stack overflow question.

The linked post references this documentation, which is only slightly more useful than the official docs. Documentation on SSL with mysqli seems rather lacking.

Any suggestions on what I am doing wrong

php mysql ssl mysqli

share|improve this question

asked Mar 26 at 14:22

cheesemarathoncheesemarathon

2566 bronze badges

add a comment | 

When trying to connect to a mysql database in php-7.2 using ssl, it results in the error Got an error reading communication packets

SSL was setup on the server using the command:

sudo mysql_ssl_rsa_setup --uid=mysql

So far I have tried the following approaches:

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


$conn->options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
mysqli_ssl_set($conn,NULL,NULL,"scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?>

and...

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


mysqli_ssl_set($conn,"scripts/ssl/client-key.pem","scripts/ssl/client-cert.pem","scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?> 

I temporally added:

$homepage = file_get_contents("scripts/ssl/client-key.pem");
echo $homepage;

to the code which printed the cert to the screen, so I know that the file paths are correct.

The SSL files were all pulled straight from the server running mysql so there should be no issues there either.

mysqli_connect_error() returns nothing. The only error is Got an error reading communication packets from /var/log/mysql/error.log

I found the methods above from this stack overflow question.

The linked post references this documentation, which is only slightly more useful than the official docs. Documentation on SSL with mysqli seems rather lacking.

Any suggestions on what I am doing wrong

php mysql ssl mysqli

share|improve this question

asked Mar 26 at 14:22

cheesemarathoncheesemarathon

2566 bronze badges

sudo mysql_ssl_rsa_setup --uid=mysql

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


$conn->options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
mysqli_ssl_set($conn,NULL,NULL,"scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?>

<?php
$conn=mysqli_init();
if (!$conn)
 die("mysqli_init failed");


mysqli_ssl_set($conn,"scripts/ssl/client-key.pem","scripts/ssl/client-cert.pem","scripts/ssl/ca.pem",NULL,NULL);

if (!mysqli_real_connect($conn,"<ip-address>","<user>","<passsword>","<database>"))
 die("Connect Error: " . mysqli_connect_error());


$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
 // output data of each row
 while($row = $result->fetch_assoc()) 
 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
 
 else 
 echo "0 results";


mysqli_close($conn);
?> 

$homepage = file_get_contents("scripts/ssl/client-key.pem");
echo $homepage;

share|improve this question

asked Mar 26 at 14:22

cheesemarathoncheesemarathon

2566 bronze badges

share|improve this question

asked Mar 26 at 14:22

cheesemarathoncheesemarathon

2566 bronze badges

asked Mar 26 at 14:22

cheesemarathoncheesemarathon

2566 bronze badges

asked Mar 26 at 14:22

cheesemarathoncheesemarathon

2566 bronze badges