Enabling IP addresses in your firewall.

[1337scape]

Hello,

First I would like to state my problem
Ok I have coded a Java server which has a highscores, that should connect to x10's MySQL. Then I use that information in MySQL and make it a highscores.php and put it on my website. All that is done, but my problem here is that apparently my IP addresses that I am hosting my server on, are not in x10hosting's firewall.

This was stated by "Corey" to me:

If your program is not located on the server it won't be able to connect unless we add the static IP of where it is coming from to our firewall.

So I was just wondering if either Corey, or any other administrator that has access to this enable my IP addresses, which are needed to host the server.

They are:

99.227.226.9
192.168.0.101


Please reply if you can, because that would be greatly appreciated and please reply if you can't with a reason stated or explanation.

Kind Regards,

Peter (1337scape)

 

[aneotoena]

As far as I know 192.168.0.101 is not a valid ip address since it's a local ip not an external ip.
You need external static ip addressess.

 

[KFMRadio]

I am having the same problem connecting to our shoutcast server.. which I have posted... yet still unresolved. So I need some help with the firewall as well.

 

[1337scape]

Ok, then may an admin please let this IP through the firewall: 99.227.226.9

Again please post.

 

[Brandon]

I am having the same problem connecting to our shoutcast server.. which I have posted... yet still unresolved. So I need some help with the firewall as well.

Can you link me to your post?

OP: I added the IP to the firewall.

 

[1337scape]

Brandon thank you so much!! So technically, now my Java coded server should be able to connec to MySQL...correct?

 

[ganjaman]

i had same problem running squery and teamspeak query on my site but corey sorted it.... what a top dude

 

[1337scape]

Nice, well Brandon said he enabled the IPs so it should work now.

 

[Blazer9131]

192.168.0.101, is not a valid external IP, as aneotoena stated. But since Brandon added the IP to the Firewall, it should work now. Man i love x10's staff.. they're AMAZING.

 

[1337scape]

I do agree, and couldn't disagree. But now riddle me this lol http://1337scape.exofire.net/highscores.php Still aint working, look at the error.
Edit:
OK here is our new problem. For some reason Your MySQL denies the "INSERT" command. May I know why. Because when I run my java server, it connects fine to MySQL but MySQL denies the "INSERT" command. I know this because I get this error on my java server.

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'mining'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'prayer'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'ranged'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'magic'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'runecraft'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'herblore'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'crafting'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'slayer'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'smithing'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'fishing'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'cooking'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'firemaking'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'woodcutting'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'farming'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'fletching'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'overall'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'attack'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'strength'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'defence'
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: INSERT command denied to us
er 'pclipse_main'@'CPE001346a4f38b-CM0011e6c4c793.cpe.net.cable.rogers.com' for
table 'agility'

 

[Blazer9131]

Umm. This is X10's Database, or yours? If its yours, add the usernameclipse_main on grant all access o.o.. If its x10's, Go to Cpanel, and database manager, and make sure you have added pclipse_main to the database your trying to connect to, and that he has the access needed, *insert command in this case*

 

[1337scape]

I have granted ALL PRIVELAGES, and it still gives me the same error. An pclipse_main is the account assigned to pclipse_highscores

 

[Brandon]

Make sure you grant access for the user on the IP 74.86.116.187.

By default, it's only accessible via 'localhost', but adding 74.86.116.187 to the hosts list for that user should make it work.

 

[1337scape]

May I ask where I go to do that. Possibly step by step instructions?

 

[Brandon]

What MySQL version are you using?

You are talking about the MySQL you have installed on your PC, correct?

 

[1337scape]

Well no, because it's x10's MySQL that is giving me this error on my java coded server which is hosted on my PC but connects to x10's MySQL.

 

[Brandon]

Ok, go to your cPanel, under "Databases", you'll see "Remote SQL", go into there and add your IP as a host.

That should take care of the problems.

 

[1337scape]

I have all this and for some reason I still get the error.

Access Hosts Remove
%.%.%.%
127.0.0.1
192.168.0.101
75.57.68.246
99.227.226.9
Edit:
Why did you mention this IP by the way? 74.86.116.187
Edit:
Brandon amd I supposed to add 74.86.116.187 and why?

 

[Brandon]

No, it should work after you add your IP.

http://cmyip.com/

I mentioned that IP, it's the server IP.

I thought you had MySQL on your local PC and were trying to connect to it through x10. It's the other way around though.

 

[1337scape]

If I did have MySQL on my local PC and was trying to connect it through x10, then what would I have to do, to make it work?