Flux on web connecting to local server problem

[sietse11]

I am trying to connect xantara flux to my local server.

 

However, everything I try comes back with a QLSTATE[HY000] [2003] Can't connect to MySQL server on '85.#.#.#(4)

 

I am using the ip adress my client uses to connect to the server

With the second sql user(so not root)

 

In application.php i put this

 

'ServerAddress'        => 'web.host.IP:and port',
'BaseURI'              => '  ', //located in root so I dont have to write a redirect

 

In my servers.php I changed 127.0.0.1 to my WAN address (85.#.#.#)

 

In my router I opened up ports 3306 and the port specified by my webhost(not sure if i need this since my ftp client doesnt)

 

Firewalls are off

 

Any ideas why I cant connect to my mysql server?

[Asura]

Hi sietse11,

 

If your MySQL server is hosted within the same system (local), then you might as well just stick with '127.0.0.1' instead of your WAN IP. It may be possible that you did not port forward within your router to the proper LAN IP.

[sietse11]

well, thats the problem.
flux is running on a host, mysql in my local machine.

 

I checked and my host doenst block any traffic on ports.

And I opened up port 80 in my router for my second router, which also has port 80 open for my server.

 

 

-----------------------

 

I tried using Wamp, disabled its sql. Copied flux to the www folder, redirected my site to my desktop. Flux installed but after the installation of the queries I couldnt log in or create accounts. And my domain name got replaced by my WAN.

 

-----------------------

 

So I cant get flux to run properly using my domain or wamp.

Which is stupid cause it worked perfectly when my host also had mysql database.

But since the server runs on my desktop I had huge lags whenever a change was made in the sql database

[Asura]

Hi sietse11,

 

Please contact your webhosting provider and check if they have any firewall blocking the connection; also ask to whitelist your static IP.