Need help ASAP, error HY000/2002 while connect to remote via Mysqli or PDO

kabantejay · Feb 19, 2016

hi! please, eva2008, help me, i'm stuck
im from ukraine sorry for bad english.
CentOS 6.7 64bit, installed stable last centminmod
mariadb 10

everything works fine except remote connection to mysql DB via mysqli or PDO:
Code:
$mysqli  = new mysqli($host, $user, $pass, $db);
if ($mysqli->connect_error) {
    die('Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}
if (mysqli_connect_error()) {
    die('Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
}
echo 'SUccess... ' . $mysqli->host_info . "\n";
$mysqli->close();
this code works fine with localhost, but i need to connect to remote DB to use SMS sending service.
the code above and the whole module works well on other shared hosting, but on VPS with centminmod i'm in trouble((

i also tried to add port 3306 and socket directli to new mysqli($host, $user, $pass, $db, $port, $socket);
but this not helped.

eva2000 · Feb 19, 2016

Centmin Mod LEMP stack installs CSF Firewall out of the box, so to be able to remotely connect to external servers, you need to whitelist and allow the remote IP address see the info below:

Getting Started Guide step 4

centminmod.com/csf_firewall.html

CSF - CSF Firewall info

welcome @kabantejay to Centmin Mod Community

Threads you might want to participate in

What are you using Centmin Mod for ?

How did you find out about Centmin Mod ?

What PHP Version do you use ?

How much memory installed on server running Centmin Mod ?

Fill out Centmin Mod 2016 Survey

Threads to read, pages to bookmark and threads to watch/subscribe to get to know Centmin Mod would include:

Getting Started Guide, FAQ and What's New and centmin.sh guide.

How to Install Centmin Mod 1.2.3-eva2000.08 Stable - you'd want to bookmark or subscribe to this thread for updates to the code, bug fixes, security updates etc.

How to upgrade Centmin Mod 1.2.3-eva2000.08+ stable

How to troubleshoot initial installs (as well as find the log files for all software for troubleshooting).

Centmin Mod Configuration Files Overview

Centmin Mod + Youtube Resources - recently created to illustrate visually what Centmin Mod can do. Alot of the vidoes are to showcase Centmin Mod .08 betas features which eventually will become the next stable release.

All things SSL https related at SSL - HTTPS as a Google ranking signal

Centmin Mod Insights forum - delve deeper into Centmin Mod code if you want to tweak it or extend it yourself. Find out how PHP Opcode cachers like APC Cache, Zend Opcache and Xcache are configured and installed and how Memcached server is setup etc.

Several ways to follow Centmin Mod code development and changes/commits via Github Commit forum or directly on Centmin Mod Github repository - 123.08stable branche

For forums, also check threads in dedicated Forum Software Usage forums. Some Xenforo users including myself have posted out Nginx vhost configs at Xenforo - My Xenforo Nginx vhost configuration

For Nginx Pagespeed check out the official site page for Centmin Mod's integration of ngx_pagespeed module. Also check out the prefix linked forum url Nginx, PHP-FPM & MariaDB MySQL | Centmin Mod Community easy way to jump into all threads and info related to ngx_pagespeed. In particular bookmark the Nginx PageSpeed Troubleshooting sticky thread as there is high chance you need to tweak your Nginx pagespeed.conf config file for your web apps and styles used. You can see an example of this forum's pagespeed.conf tweaked for Xenforo and my particular used Xenforo style/theme and some discussion of troubleshooting advertising and ngx_pagespeed.

Nginx example configuration listing at centminmod.com/nginx_configure.html

Premium Membership

Centmin Mod Premium Membership Benefits - including access to custom tailored dbbackup.sh mysql database backup script and updates/improvements.

kabantejay · Feb 19, 2016

great! thanks a lot!!

everything i need was:
1. csf -a XX.XXX.XXX.XXX
(where xxx.xxx... - is IP of remote host what i was trying to connect to)
2. csf -r
(is to restart the firewall)

eva2000 · Feb 19, 2016

FYI you don't need to restart csf firewall when adding or denying ips

Log in / Register

Forums

Get the most out of your Centmin Mod LEMP stack

Need help ASAP, error HY000/2002 while connect to remote via Mysqli or PDO

kabantejay New Member

eva2000 Administrator Staff Member

kabantejay New Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Get the most out of your Centmin Mod LEMP stack

Need help ASAP, error HY000/2002 while connect to remote via Mysqli or PDO

kabantejay New Member

eva2000 Administrator Staff Member

kabantejay New Member

eva2000 Administrator Staff Member

.