AAC (Znote acc) Failed to connect to MySQL: (2005) Unknown MySQL server host

[majsters]

Hello
My znote can't connet to database on a port other than 3306. I changed ports (2x) in etc/mysql/my.cnf.

(engine/database/connect.php)

$connect = new mysqli($config['sqlHost'], $config['sqlUser'], $config['sqlPassword'], $config['sqlDatabase']);

This works perfectly in port 3306


$connect = new mysqli(['xx.xx.xx.xx:3309'], $config['sqlUser'], $config['sqlPassword'], $config['sqlDatabase']);

It probably works but I see:

string(91) "SELECT `id`, `name`, `password`, `email`, `premdays` FROM `accounts` WHERE `id` = LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

who has the idea?

 

[majsters]

ref

 

[Znote]

What is the error text below "Type: select_single"?

You configure the host here:
Znote/ZnoteAAC

What TFS version is your server based on?
What client are you using?

 

[majsters]

I only see it:
string(91) "SELECT `id`, `name`, `password`, `email`, `premdays` FROM `accounts` WHERE `id` = LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

i use the newest acc from your github. tfs 1.3. debian 8. firewall disabled
on port 3306 it works perfectly

$config['sqlHost'] = 'xx.xx.xx.xx:MYNEWPORT'; <-- still not work : /

 

[Xandress]

bump, how can I cannect an external database with port other than 3306? My website can't connect - it is on whitelist. I suppose the problem is custom port.

tfs 1.3, config.php is configured well.

 

[Webo]

www gets the port and host mysql from the server config.lua

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "forgottenserver"
mysqlPass = ""
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

 

[Xandress]

My config.lua is set up properly, a server is running. btw if the acc takes info from config.lua then why bother changing anything in config.php in znote?

 

[Webo]

My config.lua is set up properly, a server is running. btw if the acc takes info from config.lua then why bother changing anything in config.php in znote?

to connect to the database

 

[Xandress]

Exactly, however, there is no port to change in config.php to connect my database. Correct me if Im wrong, youre saying that znote will somehow use a port from config.lua?

 

[Xandress]

BUMP

Website shows error: Failed to connect to MySQL: (2002) Connection refused
Im out of ideas how to connect the databse from my website. Both server and domain are on whitelist in my database, server is up and running.
Database is on ovh and domain and www hosting is on hitme.
Here's my config.lua and config.php
lua:

mysqlHost = "xxx.ovh.net"
mysqlUser = "dawid"
mysqlPass = "password"
mysqlDatabase = "new"
mysqlPort = 35259
mysqlSock = ""

php:

    $config['sqlUser'] = 'dawid';

    // phpmyadmin password for OT server:
    $config['sqlPassword'] = 'password';

    // The database name to connect to. (This is usually same as username).
    $config['sqlDatabase'] = 'new';

    // Hostname is usually localhost or 127.0.0.1.
    $config['sqlHost'] = 'xxx.ovh.net';

Any ideas what Im doing wrong?
PS. what direction should I put in znote if my tfs is on different vps than website? Should I import the config to the website hosting and link the direction?

 

[Xandress]

--SOLVED--
engine->database->connect.php
in

$connect = new mysqli

add

$config['sqlPort'],

then in config.php look for

$config['sqlHost']

and add

$config['sqlPort'] = 'yourport';