CI: Mysqli - Broken

So, I've been working with CI since 1.x

Today I've come across the following error

I have a database configured as mysqli.
All my credentials are correct. <- yes they are.

I get this from Codeigniter:
Unable to connect to your database server using the provided settings.
From logs:
ERROR - 2016-05-03 23:01:43 --> Severity: Warning --> mysqli::real_connect(): (HY000/2002): Permission denied /.../database/drivers/mysqli/mysqli_driver.php 202

However, doing a simple php script on the same server using the same credentials connects to the database without issue.
Literally copied and pasted the credentials.
The php script that works is straight from php.net:

\

PHP Code:

<?php


$mysqli = mysqli_init();
if (!$mysqli) {
    die('mysqli_init failed');
}

if (!$mysqli->options(MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0')) {
    die('Setting MYSQLI_INIT_COMMAND failed');
}

if (!$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5)) {
    die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');
}

if (!$mysqli->real_connect('DBHOST', 'DBUSER', 'DBPASS', 'DBNAME')) {
    die('Connect Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
}

echo 'Success... ' . $mysqli->host_info . "\n";

$mysqli->close(); 


Do you try with socket option? Try to config default socket in your system.

e.g: in my localhost, I'm using XAMPP on Mac OS and mysqli defaul socket is: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

PHP Code:

$servername = "127.0.0.1";
$username = "username";
$password = "password";
$port = 3306;
$socket = "/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock";
// Create connection
$conn = new mysqli($servername, $username, $password, $port, $socket);
var_dump($conn); 


Note: use 127.0.0.1 instead localhost

Hey thienhaxanh2405, thanks for the response, sorry did not mention this is an RDS (AWS) server.

The mysqli code works outside of Codeigniter for the remote server connection.
Just not the codeigniter driver itself.

During the writing of this reply, looked into 1 more thing and discovered this:

Code:

setsebool -P httpd_can_network_connect_db=1

My working stand alone script was being run command line so, when I tried running it via an http request, I got the error.

#$^$#%^ you SElinux.

Thanks, hope this helps someone else!

Great, it works.

SElinux.

Ha ha, very helpful for security reasons but for common user or beginner, SElinux is so complicated.