MySQL 2002 error "No such file or directory" in purely local app

roparzhhemon 2019-06-21 13:03:57 UTC #1

Keywords: PhpBB - OS X - Technical issue - Other
Description:
I've got several Bitami apps running on my Mac (some of which use Bitnami's Mysql) in a purely local way, with no internet involved.
I've just started creating another one consisting as of now of a short and unique file :

<?php

phpInfo();

$dbhost = 'localhost';
$dbport = '8087';
$dbname = 'hex_database';
$dbuser = 'root';
$dbpasswd = 'yUJKL78L91P';
try {
$pdo = new PDO("mysql:host=$host;port=$dbport;dbname=$dbname", $username, $password);
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "
";
die();
}

I get a "Error!: SQLSTATE[HY000] [2002] No such file or directory".

I know that MySQL is open and running because the other apps (including PhpMyAdmin) are working.
I double-checked the database name in PhpMyAdmin.

Any idea about what may be causing the problem here ? What other checks may I perform ?

michiel 2019-06-24 11:33:24 UTC #2

Hi @roparzhhemon,

The default MySQL port is 3306. Could you try that one?

Please, click on if you think my answer was helpful

roparzhhemon 2019-06-26 11:16:58 UTC #3

I tried it and the problem stayed the same.
By the way, one of my other apps uses 3307 as a port and works flawlessly.

michiel 2019-06-27 09:51:46 UTC #4

Hi @roparzhhemon,

Could you run the bnsupport tool, following the steps described in the guide below?

How to Run the Bitnami Support Tool

Please note that you need to paste the code outputted by the tool in your reply.

Please, click on if you think my answer was helpful

roparzhhemon 2019-06-28 09:04:15 UTC #5

Done. The output is the following :

The support bundle was uploaded successfully to the Bitnami servers. Please copy the following code:

437a5cdf-431f-853e-8658-1550b6128d91

And paste it in your Bitnami Support ticket.

michiel 2019-06-28 09:30:52 UTC #6

Can you try connecting to mysql manually?

INSTALLDIR/mysql/bin/mysql -u root -p

Please, click on if you think my answer was helpful

roparzhhemon 2019-06-28 10:28:38 UTC #7

It works as expected (remember also that as I said before, other apps using MySQL work fine, so the problem is specific to my new app)

michiel 2019-07-01 11:56:29 UTC #8

Hi @roparzhhemon,

Could you try the following:

<?php
$servername = "localhost";
$username = "root";
$password = "PASSWORD";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully";
?>

Please, click on if you think my answer was helpful

roparzhhemon 2019-07-02 08:21:57 UTC #9

This works, it outputs "Connection successful". The upshot seems to be that I can use mysqli but not PDO with Bitnami ? (Now that I remember it, my other working apps used mysqli too).

michiel 2019-07-02 09:07:06 UTC #10

Hi @roparzhhemon,

Can you try enabling the PDO_IBM module:

https://docs.bitnami.com/general/apps/phpbb/configuration/install-modules-php/#pdo-ibm

Please, click on if you think my answer was helpful

roparzhhemon 2019-07-03 07:36:37 UTC #11

Are you sure it's PDO_IBM I need to install ? Shouldn't it be something like PDO_MYSQL ?
Anyhow, my php.ini file at /Applications/mampstack-7.1.24-0/php/etc/php.ini does not contain any mention of pdo_ibm, so I cannot apply the instructions in the link you gave.

By the way, my phpInfo(); output contains the following snippet :

michiel 2019-07-03 11:24:34 UTC #12

Hi @roparzhhemon,

You are right, I jumped to conclusions too soon. My apologies for the mistake. pdo_ibm has nothing to do with it and you can disable it.

I checked your original PHP code again and saw that the variables you are setting initially are not the same as you are using in the PDO statement. For example you are setting $dbuser but in the statement it's $username. Can you try the following:

<?php
$dbhost = 'localhost';
$dbport = '8087';
$dbname = 'hex_database';
$username = 'root';
$password = 'yUJKL78L91P';
try {
        $pdo = new PDO("mysql:host=$dbhost;port=$dbport;dbname=$dbname", $username, $password);
} catch (PDOException $e) {
        print "Error!: " . $e->getMessage() . "
";
die();
}

Regards,
Michiel

Please, click on if you think my answer was helpful

?>
`

system 2019-07-17 11:24:34 UTC #13

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!