DB connection error trying to install

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Installation
2.
3.

What is the expected output? What do you see instead?
I can't get the site to connect to the DB from a remote host (namecheap)
but I recently tried to install on the local server and I get the same error:

TrinityWeb Installer: Step 2/3
Error!

Couldn't connect to the MySql server, most likely the given information is
wrong. Please go back and correct it.

MySql error log:
Can't connect to MySQL server on '(ipaddress)' (4)

What revision of the product are you using? In what browser?

Using the latest download posted here and using Firefox to do the intall.

What version are you using? MangosWeb or TrinityWeb?

Latest 3.3.3a

Please provide any additional information below.

Original issue reported on code.google.com by gamerhol...@gmail.com on 23 Apr 2010 at 8:11

[GoogleCodeExporter]

it seems like one of these are true:
1. your username/password/server is wrong
2. the MySQL server is not running
3. your MySQL server doesn't accept connections from other places than 
localhost.

if you are using Ubuntu, MySQL only accepts connections from localhost as 
default.

if you are using windows, you can download the MySQL GUI tools here :
http://dev.mysql.com/downloads/gui-tools/5.0.html
try and make a connection using these tools.

when you answer back, can you let us know which OS you are using to run the 
MySQL
server at ?

Original comment by tomse0...@gmail.com on 25 Apr 2010 at 5:28

[GoogleCodeExporter]

Hi,

Remote connections work fine myself and someone else are able to connect 
remotely
with navicat and Sqlyog. I then made a ticket with the data center and they also
tested connections remotely and said it is working fine. Also, I tried 
installing the
website locally on the server with IIS and had the exact same issue.

The OS is Windows Server Standard 2008.

1) Password / user was correct - definitely not the issue
2) Server is running, had Trinitycore running at the same time.
3) Does accept remote connections

Original comment by gamerhol...@gmail.com on 25 Apr 2010 at 5:41

[GoogleCodeExporter]

are you connecting with the same user as the one you use for mangosweb ?

MySQL has a built-in functionality for allowing only _this_ user from _that_ 
IP. as
default it's only localhost.

if that is the case you can either edit using your MySQL tool, or run this 
script
using the CLI:

GRANT ALL PRIVILEGES ON database.* TO 'mangosweb-user'@'mangosweb-remote-ip';

instead of ALL you can choose  SELECT,INSERT,UPDATE,DELETE  if you want

database = realmd, mangos, characters databases

I've never tried the tools you mention, so I cannot help you with the how-to 
there.

Original comment by tomse0...@gmail.com on 25 Apr 2010 at 6:05

[GoogleCodeExporter]

Hi,

Did use the command to grant all privileges, and so did the datacenter just to 
be
sure (this is also configured when setting up the instance to allow remote
connections I believe).

I did create another user with checked all boxes for permissions.

At this point it's boiled down to me trying to hire someone that's more of an 
expert
to go in and trouble shoot what's going on or even just set up everything from
scratch. I paid a lot for this server and this down time is killing me right 
now.

If anyone would like to take on this job and get this figured out, please email 
me -
gamerholdings@gmail.com and I can set you up with all the necessary accounts. 
Please
include what sort of compensation you will require for your time.

I've been trying to figure this out for a week now, searched for every sort of
solution I can think of online and it's just gotten overly frustrating and is 
costing
me too much time and money.

Also, when we get this figured out, we can provide that info here so no one 
else has
to go through this.

Original comment by gamerhol...@gmail.com on 25 Apr 2010 at 6:15

[GoogleCodeExporter]

One thing that I would not think mattered but: Would the fact that I'm using 64 
bit
effect this at all? Are there any problems connecting to mysql 64 bit or Windows
server running in 64 bit?

Original comment by gamerhol...@gmail.com on 26 Apr 2010 at 6:06

[GoogleCodeExporter]

no, there should be no problem there, same as when you connect from a windows 
to a
linux or the other way around, no problems there either.

Original comment by tomse0...@gmail.com on 26 Apr 2010 at 8:14

[GoogleCodeExporter]

Would you mind taking a look at the setup? I really can't figure it out.

Original comment by gamerhol...@gmail.com on 26 Apr 2010 at 9:19

[GoogleCodeExporter]

Hey, is your datastorage system a InnoDB or MyISAM?

Original comment by wilson.steven10@gmail.com on 26 Apr 2010 at 11:00

• Changed state: Accepted

[GoogleCodeExporter]

the last one I set up as Inno I believe.

Original comment by gamerhol...@gmail.com on 26 Apr 2010 at 11:52

[GoogleCodeExporter]

if you want me to take a look, I'd need some data.

you can write to myusername at gmail.com. and please be patient, since I don't 
check
it that often.

Original comment by tomse0...@gmail.com on 29 Apr 2010 at 8:13

[GoogleCodeExporter]

I got this resolved with him already. His NAMECHEAP server won't allow outgoing 
links on port 3306/3307 or any similar. I used my website and connected to his 
remote site no problems. Now we have teamed up and working on several together 
with 
one website.

Original comment by Stanbargers@gmail.com on 29 Apr 2010 at 8:31

[GoogleCodeExporter]

as I wrote in step 3 of my first post :-)

good work :-)

Original comment by tomse0...@gmail.com on 30 Apr 2010 at 8:08

[GoogleCodeExporter]

No, the MYsql server does accept connections just fine, that was not the issue. 
The
problem with name cheap allowing their hosted sites to connect to remote MYsql
databases. In fact I had set up a site on Namecheap a few years back that did 
that
and it worked fine so it must have changed since then. Very odd thing of them 
to not
allow.

Original comment by gamerhol...@gmail.com on 30 Apr 2010 at 10:05

[GoogleCodeExporter]

And actually, tomse0008, it's the reverse of step 3. His webhost won't allow 
connections to remote MySQL databases. And after I poked around a bit, found 
that 
there are MANY hosts that don't. It is always good to check if you are going to 
host 
your website on one server and the gameservers & databases on another.

Original comment by Stanbargers@gmail.com on 1 May 2010 at 5:16

[GoogleCodeExporter]

Original comment by wilson.steven10@gmail.com on 5 May 2010 at 11:32

• Changed state: Done