[HH#712272] Remote MySQL Not Accessable

[HelioHost]

Username: N/A, Server: N/A, Main Domain: N/A

 

Accessible I am trying to set up an off server site to access the MySQL on tommy. I've tested it on server and it works fine and have followed the instructions in the wiki to no avail. Below is the code (with the user info omitted)

 

$db['default']['hostname'] = 'tommy.heliohost.org';

$db['default']['username'] = '...';

$db['default']['password'] = '...j';

$db['default']['database'] = ...';

$db['default']['dbdriver'] = 'mysql';

$db['default']['dbprefix'] = 'nova_';

$db['default']['pconnect'] = true;

$db['default']['db_debug'] = NOVA_DB_DEBUG;

$db['default']['cache_on'] = false;

$db['default']['cachedir'] = '';

$db['default']['char_set'] = 'utf8';

$db['default']['dbcollat'] = 'utf8_general_ci';

$db['default']['swap_pre'] = '';

$db['default']['autoinit'] = true;

$db['default']['stricton'] = false;

 

Any assistance would be appreciated.

 

Andrew

[wolstech]

It's impossible to actually look at the issue without at least the account username, but the most common issue is not enabling it, or adding the wrong IP.

 

Can you add % as an allowed host here and try again? https://tommy.heliohost.org:2083/frontend/paper_lantern/sql/managehost.html

[HelioHost]

I'm sorry about that, the username is ahorman1. I did put that in there and I also used a test script separate from the site I have to try and it gave me couldn't connect as well.

 

Andrew

[HelioHost]

'Thaat' being the percent sign.

[Krydos]

If I were you I would test the remote mysql separately from what I'm assuming is a php cms software. You can do that by running something like this from the command prompt

 

mysql --host=tommy.heliohost.org --user=ahorman1_whatever --database=ahorman1_db -p

 

That command should give you some useful error message if it fails.

[HelioHost]

I did the same time I emailed, unable to connect

 

Sent from my iPhone

 

> On Aug 21, 2018, at 02:01, Heliohost Support wrote=

:

>

> If I were you I would test the remote mysql separately from what I'm assum=

ing is a php cms software. You can do that by running something like this fr=

om the command promptmysql --host=3Dtommy.heliohost.org --user=3Dahorman1_wh=

atever --database=3Dahorman1_db -pThat command should give you some useful e=

rror message if it fails.

>

> You may view the status of your ticket by visiting:

>

> https://www.helionet.org/index/index.php?showtopic=3D33995

>

> Thank you,

> Heliohost support

> https://www.heliohost.org/

> https://www.helionet.org/

>

[wolstech]

I just checked, your settings are fine.

 

Are you connecting using a network you don't own by chance? A lot of places like free wifi, colleges, and workplaces block port 3306, which would make it impossible to use remote mysql. Unfortunately if that's the case, the issue is with the network owner and the only solution is to use another internet connection.