6 months ago
"Hello, my web application needs to connect to an external MySQL database. The connection is being blocked. Could you please ensure your firewall allows outgoing TCP traffic to the hostname
shuttle.proxy.rlwy.neton port17464?"
getting this error{
A PHP Error was encountered
Severity: Warning
Message: mysqli::real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers
Filename: mysqli/mysqli_driver.php
Line Number: 211
Backtrace:
File: /var/www/html/index.php
Line: 320
Function: require_once
A PHP Error was encountered
Severity: Warning
Message: mysqli::real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers
Filename: mysqli/mysqli_driver.php
Line Number: 211
Backtrace:
File: /var/www/html/index.php
Line: 320
Function: require_once
A PHP Error was encountered
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /var/www/html/system/core/Exceptions.php:272)
Filename: core/Common.php
Line Number: 571
Backtrace:
File: /var/www/html/index.php
Line: 320
Function: require_once
A Database Error Occurred
Unable to connect to your database server using the provided settings.
Filename: core/CodeIgniter.php
Line Number: 519
}
my db array{
$db['default'] = array(
'dsn' => '',
// Hostname should NOT include the port number.
'hostname' => 'shuttle.proxy.rlwy.net',
'username' => 'root',
'password' => '<password>',
'database' => 'railway',
'dbdriver' => 'mysqli',
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE,
// The correct port from Railway goes here.
'port' => 17464,
);
}3 Replies
6 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
6 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 6 months ago
6 months ago
It seems there's some issues in your code, shuttle.proxy.rlwy.net:17464 is perfectly accessible publicly.
6 months ago
It looks like you might be using a old version of php
Try changing
'char_set' => 'utf8mb4',
'dbcollat' => 'utf8mb4_general_ci',
The other option is to update your php. By the way which version of php are you using?