News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Connect to external DDBB

Started by Dimitrix1011, May 14, 2019, 10:28:47 AM

Previous topic - Next topic

Dimitrix1011

Hi!

I need to connect to a external DDBB with port like: hxxp:pl52230-004.dbaas.ovh.net [nonactive]:35148

I change the Settings.php with the next configuration:

########## Database Info ##########
$db_type = 'mysql';
$db_server = 'pl52230-004.dbaas.ovh.net:35148';
$db_name = 'mydbname';
$db_user = 'mydbuser';
$db_passwd = 'mypassword';
$ssi_db_user = '';
$ssi_db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;


But don't work, anyone can help me?

Thank you,

Arantor

Is it definitely a MySQL database? That's a weird port number if it is.

Dimitrix1011

Is MySQL, the port is from OVH.

I authorized my VPS IP, and I am using the database with PHPmyadmin without problems.

Illori

are you connecting to phpmyadmin from the same machine you are trying to connect with SMF?

Arantor

I checked the code, SMF 2.0 does not support MySQL on a non default port out of the box.

If you change your php.ini file, though, with the setting mysqli.default_port, you can set that to be the port you care about.

Dimitrix1011

Quote from: Arantor on May 14, 2019, 11:03:54 AM
I checked the code, SMF 2.0 does not support MySQL on a non default port out of the box.

If you change your php.ini file, though, with the setting mysqli.default_port, you can set that to be the port you care about.

Thank you, work it!

Advertisement: