Notifications
Clear all

MySQL Custom Port

3 Posts
2 Users
0 Likes
1,078 Views
(@neris)
Posts: 2
New Member
Topic starter
 

Hi,
I had a big problem installing eFiction on my OVH hosting. In the end, I 'solved' it by installing eFiction on the horrible database included in the hosting and not on my Private SQL (a VPS only for databases). But in the future, I'll surely need to move it on my Private SQL. The problem is that the Private SQL uses a custom port... and eFiction cannot read the database. Is there a way to solve the problem?

 
Posted : 15/05/2019 5:10 am
(@sheepcontrol)
Posts: 332
Reputable Member
 

Open this file: "includes/mysqli_functions.php"

Change

function dbconnect($dbhost, $dbuser, $dbpass, $dbname ) {
$mysql_access = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

to

function dbconnect($dbhost, $dbuser, $dbpass, $dbname ) {
$mysql_access = new mysqli($dbhost, $dbuser, $dbpass, $dbname, 3399);

(3399 or whatever your port is).

Ugly as can be, but will work.
eFiction 5 (which is being worked on, despite me being rather silent lately) will allow custom ports from the get go.

 
Posted : 19/05/2019 10:32 am
(@neris)
Posts: 2
New Member
Topic starter
 

I haven't tried it yet, but thank you very much!  πŸ˜€

 
Posted : 20/05/2019 9:32 am
Share: