Help With Multi Tier Mysql Application Over Net receiving data connection from client

[oncombeureum 0]

hi..i want to make a connection from my desktop client into mysql database at web server.currently i think it can be provided by PHP.1. i'm thinking like this:CLIENT -> PHP + MYSQLCLIENT {sent file} -> PHP {receive file, open connection to MYSQL, insert data from file}how it will be done ???2. the securitydo you know how to secure it ?thanks..

Edited June 29, 2005 by microscopic^earthling (see edit history)

[Alpha six 0]

what for a file do you want to insert?
I myself have installed "phpmyadmin" on my pc and use it to edit my sql database for testings. you only have to download it from https://www.phpmyadmin.net/ and then you have to configurate it by editing the "config.default". Least you only have to upload all files on a php supporting webspace. Open it and have fun with a very good database tool!

[oncombeureum 0]

thanks Alpha.butforgot to mention... that{*** no user intervention on what so ever ***}just UPLOAD button...on the desktop client program (currently it's built using Delphi)so the protokol to use (i'm thinking of) HTTP.or perhaps FTP (but this require username/password)thanks

[mobious 0]

why not just a mysql lib and connect to the server directly? it would be much faster and efficient.

[oncombeureum 0]

can't do that...as the database server protect the connection available only from inside connection only..

[manymanymuch 0]

Sounds like a job that can use web services namely SOAP protocol to accomplish. It's possible to call objects on the server. I'm not familiar with multi-platform connectivity though.

Look at these few sites:

http://phpsoaptoolkit.sourceforge.net/phpsoap/
http://forums.xisto.com/no_longer_exists/
https://www.aspfree.com/c/a/.NET/NET-Remoting-and-Delphi/

Although, they look kind of complicated and new. Maybe you only want something simpler. Anyway, hope this helps.

[miCRoSCoPiC^eaRthLinG 0]

can't do that...

 

as the database server protect the connection available only from inside connection only..

<{POST_SNAPBACK}>

Nope - is IS possible for your Desktop client to communicate with your database at Xisto.

 

Here's how:

=========

1. Lets take an example database "abcd" - when you create a database/user on Xisto, it's prefixed with your cPanel username, right ?

 

So supposing your cPanel username is "myself", your database name will be: myself_abcd

 

2. Now you need to create an user and grant him with all permissions to the database. Lets create an user called "admin". Even this will be prefixed with your cPanel username..

So your actual db access username will be: myself_admin

 

3. Grant this user with ALL permissions to that database

 

4. Now comes the critical part - specifying the ACCESS MASK to this database. Normally it always defaults to localhost. Under this circumstance, you can ONLY access this db using a script/client on your Xisto account. You need to add a separate mask that will allow you to access the database from your own IP.

First, find out your own IP. If it is Static, nothing like it. But even if its Dynamic, no problem... Usually for dynamic IPs only the last two octets change everytime you log in... i.e.:

 

Say, your IP is: 100.200.300.400 - only the 300.400 keeps changing every time you login.. So we're going to replace this with the MySQL version of WildCard - % symbol

 

In the last option of cPanel MySQL Databases, you'll find a section named Access Hosts - here you've to enter the string,

100.200.%.% and click Add.

 

We're DONE

 

Now you can directly connect to this database straight from your desktop using your client... Supposing you're going to distribute this client to a lot of users who will upload data into your mysql db - make sure, instead of granting ALL permission, you set the permission to ONLY INSERT & SELECT - that will enable them to add new data and view old data - but not mess around with already added data.

 

For manipulating your database, adding/deleting/tables.. setting permissions etc.. general database administration job - I'd highly recommend this freeware tool named SQLYog which is freely downloadable at: https://www.webyog.com/

 

Other than that you can also use MySQL's own Administrator and Query Browser.. all of them work just fine

 

Hope this helps - any more help with distributed apps and networked db's let me know..

 

Regards,

m^e