[HELP] [Request] Error when connecting to an external database

[JackLee]

Hey DevBest,​

I'm having some trouble setting up a R63 emulator alongside the IlluminaCMS. I have purchased both a VPS and web hosting along with a domain so i'm not trying to wing this. I haven't been on the Habbo scene since PHPRetro and V26 Emulators so excuse my ignorance if its a blatant mistake.​

​

The Error:​

​

MySql.Data.MySqlClient.MySqlException <0x80004005> Unable to connect to any of the specified MySQL hosts

​

​

​

I have received this error with the following emulators:​

​

Phoenix​

Butterfly​

Butterstorm​

BCStorm​

​

This leads me to assume the emulator is not the problem.​

​

I have used a portforwarded computer to host the Emulator and now a VPS​

​

This leads me to assume the host pc is not the problem either.​

​

I am using a Phoenix 3.11 database with Illumina sql added. There is no firewall on the VPS and I have added the VPS IP as a remote access server in CPanel.​

​

Please don't slate my ignorance or state I shouldn't be running a hotel. I just want help from the community, thanks.​

 

[Jeffrey]

Jack, A) Your configuration with the mysql part may be wrong
b) if your using xampp check if your mysql is on..

OFT: Are you using webhosting to host the cms just wondering?

 

[JackLee]

You must be registered for see links

I've corresponded the config several times and worked fine when both the website, emu and database were all local. Now the VPS is hosting the emulator and a CPanel web server is hosting the site and database it chucks up this error with any/all emulators.

So A) heres my config for you too have a look incase:

## MySQL Configuration
db.hostname=dolphin.uksrvmgr.com
db.port=3306
db.username=USERNAME IS FINE
db.password=PASSWORD IS FINE
db.name=pixelate_holodb
 
## MySQL pooling setup (controls amount of connections)
db.pool.minsize=1
db.pool.maxsize=100
 
## Game TCP/IP Configuration
game.tcp.bindip=VPS IP
game.tcp.port=300
game.tcp.conlimit=11000
game.tcp.conperip=100
game.tcp.enablenagles=False

and B) I'm not using XAMPP

 

[Jeffrey]

5) Setting Up The Hotel
-You need to have an emulator, and something to run it on so I recommend Habbohosting.info for a low priced, .5GB-1GB RAM VPS. You will need to buy one somewhere else eventually if your hotel gets big enough, but seriously Habbohosting is the place to go :)
 
-To setup the emulator (assuming your using Phoenix) i have a copy of the Phoenix config file that you should fill out below:

Spoiler

Code:
## Phoenix 3.0 System Configuration File

## Licence Information
*************.username= *Your Phoenix Username*
*************.password= *Your Phoenix Password*

## MySQL Configuration
db.hostname=*ping your website, then put the IP that returns here*
db.port=3306
db.username=*the db user you created from above*
db.password=*the password to the db user you created from above*
db.name=*the name of the db that was created from above*

## MySQL pooling setup (controls amount of connections)
db.pool.minsize=5
db.pool.maxsize=30

## Game TCP/IP Configuration
game.tcp.bindip=*The IP of the machine you are hosting the EMULATOR on*
game.tcp.port=*The Gameport*
game.tcp.conlimit=5000

## Client configuration
client.ping.enabled=1
client.ping.interval=30000

## MUS TCP/IP Configuration
mus.tcp.bindip=*The IP of the machine you are hosting the EMULATOR on*
mus.tcp.port=*The MUS port*
mus.tcp.allowedaddr=*ping your website, then put the IP that returns here*

 

[JackLee]

I've done all of this, it doesn't help.

I am adamant the config files and emulator along with the database are perfectly fine and believe it to be something with the MySQL connector or some what, what can you tell me about that?