remote mysql, how?

[hlmaster]

I run a TFC server and im trying to get the skillsrank timer speed run thing going.. anyways it has php files already done.. this is the site... http://hlm.exofire.net/stats/

there was an include file I needed to configure to set this up.. unfortunately the server isnt on x10hosting, so I needed to make the server connect remotely to the website (woah, wasnt that kind of obvious?) my question is.. what is the mysql host I need to feed to the server? its not my subdomain is it? im kinda new to mysql altogether, not so much with php.. so can anyone help me out, im kinda at a loss..

to sum things up I just need to know what the $serverip = "DNS Possible?" when im configuring it..

basically just need to know the mysql remote ip thingy..

 

[zen-r]

Mysql can only be accessed locally on the server.

See ;

http://forums.x10hosting.com/free-hosting/100499-mysql-database-home.html

 

[Russ]

Yes, due to security issues, it has been disabled for the freehosting servers. You should look into a vps package if you must have it.

 

[lhyman]

Do a forum search, we keep answering this question every day...

You can not have remote mysql access here....

If that bothers you, you can download mysql server and run it on your home computer...

Maybe an admin can make a sticky about remote mysql or include it in a FAQ somewhere...

Thanks

 

[xav0989]

I believe that you had it wrong guys. From what I understand and from what I see resulting from the error on http://hlm.exofire.net/stats/ , he wants to connect to a MySQL server hosted somewhere else.

In that case, hlmaster, you need to ask where the mysql server is hosted ( http://freemysql.net/ ) for the correct information to remotely connect.

I am registering at FreeMySQL.net, and as soon as I know the info, I'm gonna post back here.

 

[galaxyAbstractor]

I believe that you had it wrong guys. From what I understand and from what I see resulting from the error on http://hlm.exofire.net/stats/ , he wants to connect to a MySQL server hosted somewhere else.

In that case, hlmaster, you need to ask where the mysql server is hosted ( http://freemysql.net/ ) for the correct information to remotely connect.

I am registering at FreeMySQL.net, and as soon as I know the info, I'm gonna post back here.

The same rule is both ways

 

[lhyman]

Final !!!!!

MySql Server here is localhost and only web apps running on localhost (your website and your web apps in your x10 account) can access it

web apps on local host can only access the mysql server on localhost

web apps on localhost can not access any mysql server not on localhost

web apps and apps not on localhost can not access the mysql server on localhost

if you need access to a mysql server and you can not find one on the net that allows remote access, then you can go to the mysql server web site and download it and run it on your personal computer
Edit:

( http://freemysql.net/ )

BTW-> Thanks for the link

 

[a94060]

The same rule is both ways

Im pretty sure if you are able to make a socket connection using php, you should be able to connect to a remote mysql server. If you cant make a remote socket connection, then this post is pointless:biggrin:

 

[lhyman]

You don't understand that x10 has closed the firewall to ports 3306, no traffic is allowed in or out through the firewall, meaning that only apps inside the firewall can access the mysql servers that are also inside the firewall

 

[galaxyAbstractor]

Im pretty sure if you are able to make a socket connection using php, you should be able to connect to a remote mysql server. If you cant make a remote socket connection, then this post is pointless:biggrin:

If you mean fsockopen, then you're wrong. fsockopen is also disabled for security reasons.

 

[Smith6612]

As others I'm sure have stated, Remote SQL for the most part is blocked by the server's firewall. x10Hosting especially does it. Really, I have seen hosts out there that allow SQL Queues to outside servers, and game server plans that come with MySQL/web services as well. Now, whether or not x10Hosting allows this on the paid plans, I'm not sure, but Russ did state that the VPSs from x10Hosting allow this.

Ultimately, the best solution to what you are doing is to find a host who will give you Remote SQL access through the server's firewall, co-locate your own server that will host the game server, MySQL database and your site, buy a dedicated server or a VPS on a strong server with a lot of resources and a hunk of bandwidth and run your site and game server off of that server, or see if your game server hoster can offer up what I've suggested above, or of course get a VPS from x10Hosting. What people have suggested about running a server off of your home connection, as unfortunately, many ISPs still offer pathetic amounts of upload speed (don't get me started on how ISPs can offer 50Mbps download and give a pathetic 2Mbps upload) and do not allow servers in the first place.

 

[lhyman]

yes, but X10 is giving us free web hosting for free web hosting, not for game servers. If people don't like this, well they are free to find a pay solution.

I have no problem with x10's free hosting and all my web scripts can access mysql just fine.

Everything is perfect and I am very thankful that I am getting about $30.00 a month of service for free !

For sure, no complaints from me !

 

[Smith6612]

yes, but X10 is giving us free web hosting for free web hosting, not for game servers. If people don't like this, well they are free to find a pay solution.

I have no problem with x10's free hosting and all my web scripts can access mysql just fine.

Everything is perfect and I am very thankful that I am getting about $30.00 a month of service for free !

For sure, no complaints from me !

This is the thing though. He already has a game server on another host's server already, and he is also using a free MySQL provider in which the game server is writing data to. Now, what he needs to do is make the script he has running on his x10Hosting site be able to use his site's bandwidth to call up the database from the free MySQL host for the script to use, which x10Hosting doesn't allow to happen. Now, he could host the MySQL database on x10Hosting but the game server wouldn't be able to write to that database either, since x10hosting does not allow any form of MySQL communication outside of the server except on the VPS packages, which is why I suggested what I did above.

But really I have no complaints with x10Hosting either. When it comes down to it I get what I pay for. If I needed to do such a thing that the OP is doing, I have a few spare PCs and a Linux router that can take care of all of these (game server, MySQL and Scripts) for me as well as a decent amount of bandwidth (upstream and downstream) to handle some pretty big things.

 

[galaxyAbstractor]

You could use HTTP POST to send/get data from the database. Just make a PHP file containing some POST fields, like $_POST['mysql_query'], then submit data to it through HTTP. And well, you need to make some sort of authentication first, like some sort of access key, so only you can use it.