[minimiller]

Ok so im not sure where to put this, so ill whack it in here

Im in the process of making a KZ plugin that uses SQL saving methods. (i say "in the process", but ive almost finished)
When i got around to testing i put it on my mix server and everything worked fine. So i bought a new server from UKGame to use as a dedicated KZ server. I uploaded a few maps, installed amxx and copied the exact same KZAIO.amxx file from my old server to my new 1 (Bolded for importance)

I then went to my website cpanel and done the remote access thing to my new server, just like i did with the old

Bearing in mind ive hardcoded the SQL information into my plugin (host, username, password and database), nothing has changed there.
I have allowed my KZ server to access the databases on my web server, so theres no problems there either.
When the server initially changes map and loads the plugins n whatnot, everything loads properly

So i run the map and hit the stop timer... but oh wait! rcon amxx plugins shows that the plugin has broken!
checking my logs i get this error:

[AMXX] Cannot connect to SQL database

so why is it not working?
ive contacted the server host and they said this

Hi The ports have been opened for sql connections on this server any other issues you have will be related to human error or your web server is blocking connections from our IP's

but as you can see above, everything in my plugin is the same, ive allowed the server to access my databases but it still dosent work


any1 got any other ideas?

[/wall of text]

[8088]

Are you sure you added the correct ip? I didn't see any Goldsource servers on that ip:



Try (temporarily) a wildcard to verify.

[minimiller]

hmm thats weird. it shows up on mine


i also added the wildcard and completed the map again, but it kerploded again



im so confused right now

[8088]

Have you tried to connect to your database with the same credentials from your own (home?) location?

By the way, your server's now findable in my servers list too. It was probably something coincidental.

[minimiller]

i put my ip in the remote sql thingy and tried the map on my LAN server
it still didnt work =[
(if thats what u meant)

just to make triple sure, i uploaded the plugin back onto my old server and it still works there
The only difference between the 2 servers is that the old 1 is linux and the new 1 is windows
i dont see how that would be part of the problem though...

[8088]

Originally Posted by minimiller (if thats what u meant)

Sort of. It would be better to use something that returns a more detailed error report to see if it's the host that has no access at all.

Normally you have to specify the host per MySQL user (user, host, privileges, etc). It's been quite a while since I've used cPanel so I'm not sure if this is done for you or that you have to specify it yourself, after you've created a global list of hosts. I can imagine that the user specified in your AMXX settings is only allowed from only one address.

[minimiller]

ok ive found the problem
for some reason, UKGame have ballsed it up COMPLETELY
my server ip (as you can see in the images above) is 195.90.98.6 but i needed to allow access from 89.238.152.206
i have no idea why, but its fixed now

thanks for ur help dude
seeing as though i cant give karma, ill give you a virtual hug!
:hug:

EDIT:
Maybe not
piece of shit still wont connect even with both IPs and the wildcard... :@