WD MySql problem

Hi folks, i keep getting


Unknown MySQL server host 'http://91.121.173.32' (11004)
ERROR: MySQL server has gone away at time/date 06:34:21 22/06/2015

When i last used the db side of it was back in early 2013, all i used was http://IPADDRESS
and obviously the rest of the login deets,

Trying it this way again is not working, what could i be missing please?


Well I stopped using MySQL a while back, had it running for years but never used the data :wink:

So a couple of things come to mind, firstly it looks like you are using a remote ip address for MySQL so has it gone away? Second does your firewall allow access out to it and then if it is hosted does it allow remote connections. Another though if it is hosted somewhere does it need to allow access from your WD ip address as often they dont allow remote access to MySQL from hosting sites for security reasons which may mean you need to provide a fixed ip address for your WD system so you can authorise it at the remote end.

Stuart

My provider for example only allows uploads from local scripts that are on the same server as the db.

erm… lol Its my own dedicated server so as far as i am aware i have not restricted myself but ya never know :confused:

Its the same IP that wd uses for ftp/clientraw

What’s puzzling me is that this is not a normal private IP address on a local lan. Most folks use 192.168.0.1 upwards. If this is your external IP address then it may not work and you should use a private one.

Stuart

It’s the IP of his dedicated (leased) server, which is in a data center.

Ah OK when he said that I assumed he meant hosted locally.

Stuart

I tried that IP with a MySQL client and get a total fail, not a user/pass fail, so I think it’s not set up for access on the server.

I think it should probably be just the IP, not http://IP.

I seem to remember when I did use it all I had was localhost in that field as it was on the same pc.

Stuart

Ha, forgot top blank out the error ip lol oh well #-o

I have tried it with and without http, this server is setup the same as my old server, i will have to
see if there is something stopping me…

Hardly a secret, it was in the code box at the top of your post too, to say nothing of that master hacker tool “ping” :lol:

I will at some stage be doing a re write of the WDMYSQL program
as soon as they add in 6 more hours to the day :slight_smile:

Thats a double DOH! lol when i 1st posted i forgot to blank any box lol

Sorted now, i had to add my hostname to Remote Database Access Hosts
thanks folks :slight_smile: