Jump to content
  • Advertisement
Sign in to follow this  
levjs

[web] More(hopefully last) SQL Problems

This topic is 4390 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Hi, So I've got the C MySQL up and running, and I'm almost done with this whole mess of a project, but now I'm running into some trouble. What I want to be able to do, is connect to a SQL server on my site http://www.backyardproductions.org/ hosted by OLM.net from my customers computer. Now, the problem is, I can't seem to get the host right. I'm using mysql_real_connect, and for the host I've tried a mutliple thing of things, and none of them work. When I put "backyardproductions.org", I get an erorr: Access denied for user username@adsl-074-229-240-227.sip.bhm.bellsouth.net(bellsouth is my ISP). Does anyone know of something I should try, or if there is a different way to connect remotely? Thanks so much. Levi [Edited by - levjs on May 17, 2006 10:14:35 AM]

Share this post


Link to post
Share on other sites
Advertisement
You more than likely have to download the driver that allows remote connection of SQL statements, though that wouldn't necessarily explain the error.

Is the SQL server on your website set up to receive connections?

Share this post


Link to post
Share on other sites
Well if it is set up on a Windows Server then there is normally a graphical setup that you go through that will have the options, you then need to run the server to get it to run.

On a linux server is a little more difficult to set up, you need to specify a number of option (I can't remember off hand, but will look it up if I can find it) and then again will have to run it.

The key thing is that it has to be actually running in the background to be accessed (unless I'm missing a specific kind of way). I'm also somewhat assuming you are using MySQL as the server?

Share this post


Link to post
Share on other sites
Ask your host the IP address of the MySQL server and connect to that. You'll probably need to authenticate with the User/pass they give you (usually the same as your hosting account).

Share this post


Link to post
Share on other sites
Ok, I contacted my host, and they set it up for remote access(it is disabled by default). So now it's working. One more question. This is a C++ program I'm going to distribute to my customers. Obviously, the password and username to my account has to be in the code. My question is, is there anyway somebody could decompile it and get my password? Thanks
Levi

Share this post


Link to post
Share on other sites
Quote:
Original post by levjs
Ok, I contacted my host, and they set it up for remote access(it is disabled by default). So now it's working. One more question. This is a C++ program I'm going to distribute to my customers. Obviously, the password and username to my account has to be in the code. My question is, is there anyway somebody could decompile it and get my password? Thanks
Levi

The answer is yes. That is if they know what to look for, from everything I've seen decompilers are hard to decode variables at best.

If you are worried, see if you can make it so that there is only access to the server's database.

Edit: Here's a presentation that was from my Software Engineering class on Reverse Engineering, it talks about decompilers a little. It is not very indepth explaination, but it gives you an idea.

Presentation

[Edited by - Terlenth on May 18, 2006 9:13:51 AM]

Share this post


Link to post
Share on other sites
Quote:
Original post by Terlenth
Quote:
Original post by levjs
Ok, I contacted my host, and they set it up for remote access(it is disabled by default). So now it's working. One more question. This is a C++ program I'm going to distribute to my customers. Obviously, the password and username to my account has to be in the code. My question is, is there anyway somebody could decompile it and get my password? Thanks
Levi

The answer is yes. That is if they know what to look for, from everything I've seen decompilers are hard to decode variables at best.

If you are worried, see if you can make it so that there is only access to the server's database.

Edit: Here's a presentation that was from my Software Engineering class on Reverse Engineering, it talks about decompilers a little. It is not very indepth explaination, but it gives you an idea.

Presentation


Ok, so basically, if they try hard enough, they can do it. I didn't quite get what you were saying here. Thanks
Quote:

If you are worried, see if you can make it so that there is only access to the server's database.



Share this post


Link to post
Share on other sites
What I meant was, that if you are worried about someone accessing something they shouldn't, see if you can set up a priveledges based login that only has priveledges to see the specific things you want it to.

That way the only thing that you may have to worry about is someone hacking the database and relevant files that the specific loging can access.

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

Participate in the game development conversation and more when you create an account on GameDev.net!

Sign me up!