PROB HOST Install Osclass and Define PORT

[Guib]

Hi, excuse to post on the forum this message.

I have a problem with the install of Osclass
I'm on OVH (hosting site).

There are change the sql privé (private SQL) and now, when we want to create a new website, we must writte the PORT (define port).
I have see on the forum two solutions but they don't work…
The fisrt was go to the osclass files oc-include and ad code… Nothing, the second juste ad after the name of host ": and numbers of PORT" (as :12345) but nothing too…

Anybody have the same problem or have an OVH hosting site with a SQL Private "Docker"?

Thanks for Helping

GuiB

[teseo]

Hi,

Try this:

oc-includes/osclass/classes/database/DBConnectionClass.php

Replace this block:

Code: [Select]

        function _connectToDb($host, $user, $password, &$connId)
        {
            if( OSC_DEBUG ) {
                $connId = new mysqli($host, $user, $password);
            } else {
                $connId = @new mysqli($host, $user, $password);
            }
with:

Code: [Select]

        function _connectToDb($host, $user, $password, &$connId)
        {
            if( OSC_DEBUG ) {
                $connId = new mysqli($host, $user, $password, DB_NAME, '12345');
            } else {
                $connId = @new mysqli($host, $user, $password, DB_NAME, '12345');
            }
Of course change 12345 to your real MySQL port.

Regards

[Guib]

Hi Tesso Thanks for your rapidity.

I have test but nothing, always the same message :
Osclass database server is not available. Need more help?

I don't understand why…

whith another Private SQL all is ok.
Here, it's a Private SQL "Docker".
Whith the "Legacy" all was Ok

[teseo]

Sorry, I know nothing of that technology. Wait for someone familiar with it or ask to OVH if you can set default port 3306 for you Docker.

REgards

[Guib]

Thanks Tesso.

I don't know if it's Osclass or Docker cause I have test to install on a subdomain a Wordpress and after ad to the HOST :PORT it work…

Thanks again.

Regards.

GuiB

[Guib]

I WINNNNNNNNNNN YOUHOUUUUU

If another guy have the same problem with OVH HOST and private SQL DOCKER : the solution :

Before, big thanks to Teseo :

On the file on oc-include :

function _connectToDb($host, $user, $password, &$connId)
        {
            if( OSC_DEBUG ) {
                $connId = new mysqli($host, $user, $password, DB_NAME, '12345');
            } else {
                $connId = @new mysqli($host, $user, $password, DB_NAME, '12345');
            }

Put the real name of the DB_NAME and real numbers of PORT

Yesterday I changed juste the number of PORT and no add the name of database. With the name of the BDD it work.

[dev101]

This seems to be omission in the core, rarely MySQL is not using default port, but there should be support for custom value.

I will have opened an issue here: https://github.com/osclass/Osclass/issues/2004

This should be manageable via installation and config.php, without core modifications.

Regards

[teseo]

You're welcome, glad you solvedt it.

Put the real name of the DB_NAME

Weird, because constant DB_NAME is usually defined in config.php:

Code: [Select]

/** MySQL database name for Osclass */
define('DB_NAME', 'database_name');
Regards

[Guib]

I test yesterday without the name of the DB and it's good…

Maybe it will be necessary for install… Now I rewrite DB_NAME

I understand nothing. It work and It's ccool

Mystery of code

[dev101]

Maybe it will be necessary for install… Now I rewrite DB_NAME

Exactly, since during installation config.php does not exist yet, so the constant is not defined.

Regards

[dev101]

Carlos pointed us to an older blog post, there is no need to modify core files for MySQL with custom port.
Simply define host:port for DB_HOST in config.php:

https://dev.osclass.org/2012/10/22/mysql-alternate-port-number/

But, it still could be a problem during installation...