Connecting To A Remote Database

glodrop

Apr 22 2008, 11:42 AM

I wondered if anyone here can help.

I have a database on a remote server (A). I want to access it through a php script on a different server C.

I have allowed access on (A) in Cpanel - mysql dbases - Remote Access by putting the IP address of server C

The host of server (A) has also whitelisted the IP of server C.

Though I am having trouble connecting from server C which is with a different webhost.

any ideas how to get round this?

I have though of SSH forwarding, but I think this can only be used to connect a client - e.g. my pc to the remote server A. I do not have shell access on server C

I have thought of accessing through SSH on an additional server B - but I can't get my head round any of it or see how the final php settings are going to end up.

Comment/Reply (w/o sign-up)

faulty.lee

Apr 22 2008, 01:23 PM

QUOTE(glodrop @ Apr 22 2008, 07:42 PM)

Though I am having trouble connecting from server C which is with a different webhost.

any ideas how to get round this?

Can you access the database on server A from your down PC? If server A's database cannot be access external, maybe it's not meant to be done as such. You can write php script as proxy to do the query and return the result in xml form. You can refer to SQLYog, it's using such method to bypass those server that doesn't allow external access. Though the proxy feature is only available in the enterprise version of SQLyog. The opensource free version doesn't not. Anyway, you can get a trial version and find out how it works. If you're not doing much query, you can also write the php script for a limited number of function.

I'ven't really tested this. http://www.phpclasses.org/browse/package/4000.html. But it should works. Or you can look for something similar.

QUOTE(glodrop @ Apr 22 2008, 07:42 PM)

I have though of SSH forwarding, but I think this can only be used to connect a client - e.g. my pc to the remote server A. I do not have shell access on server C

I have thought of accessing through SSH on an additional server B - but I can't get my head round any of it or see how the final php settings are going to end up.

Not sure about SSH. Normally there's simple way to solve problem. If it ended up with complex solution, think again, there's always simpler ones.

Comment/Reply (w/o sign-up)

glodrop

Apr 22 2008, 02:28 PM

Hi,

Firstly I tried testing access on from my pc through telnet to the remote server A and I just get '4.1.22-standard' and 25 ascii
characters and a flashing cursor.

My host has just installed ssh for me on the cpanel so i'll try and test it through that. I'm new to telnet and ssh.

The script you gave a link for. I will try and test the server with that as well - though my goal is to not just to execute queries.

The database is a directory of websites on server A. On server C is the php script which will access that database. Instead of inputting 'localhost' in the config file I would add the ip of server C. Though when I have done that I have not had much luck - I just get the message -

Can't connect to MySQL server on 'IP for server A' (4) in
/home/a9463775/public_html/directory/index.php on line 72

I wrote $db_host = 'IP for server A:3306' in the config file.

My host of the remote server A assures me that it should work, it is remotely accessible, they have whitelisted the IP and port 3306 is open.

The php script on server C is meant to update the database with new data as well as perform search queries on existing data in the database on server A. It is like any other directory php script with it normally accessing the database on 'localhost'

Any other ideas on this?

Comment/Reply (w/o sign-up)

faulty.lee

Apr 22 2008, 02:55 PM

QUOTE(glodrop @ Apr 22 2008, 10:28 PM)

Firstly I tried testing access on from my pc through telnet to the remote server A and I just get '4.1.22-standard' and 25 ascii
characters and a flashing cursor.

My host has just installed ssh for me on the cpanel so i'll try and test it through that. I'm new to telnet and ssh.

If you can telnet in via 3306, then it's accessable externally. Though you won't be able to do anything via your telnet connection, it's not meant to be connected that way. Thus, I don't see the purpose for ssh connection too. SSH is a secure version of telnet.

QUOTE(glodrop @ Apr 22 2008, 10:28 PM)

The database is a directory of websites on server A. On server C is the php script which will access that database. Instead of inputting 'localhost' in the config file I would add the ip of server C. Though when I have done that I have not had much luck - I just get the message -

Can't connect to MySQL server on 'IP for server A' (4) in
/home/a9463775/public_html/directory/index.php on line 72

I wrote $db_host = 'IP for server A:3306' in the config file.

My host of the remote server A assures me that it should work, it is remotely accessible, they have whitelisted the IP and port 3306 is open.

It seems more that your server C is having problem accessing external databases. Some web server denied external socket connection, to prevent usage for illegal purposes. You can try connect to another external database to confirm, or check with server C's host

Comment/Reply (w/o sign-up)

yordan

Apr 22 2008, 03:16 PM

It has to work.
I did it with a phpbb3 forum, I had php on one system and the dabase on the other system.
So, instad of defining the database server as "localhost" I defined it with the connect hotname and host port given by the database server, and it worked.
Yordan

Comment/Reply (w/o sign-up)

glodrop

Apr 22 2008, 03:33 PM

Hi,

My host on server A suggested me testing it via telnet. Is the reason why I just get a load of ascii characters - because its not meant to be used that way. ? It seems that I am connecting. Is that what I am supposed to get on telnet?

Server C is a free host, server A isn't, so I can't get anything from server C, I've tried communicating with them before on this. I have tried accessing the dbase uploaded to other remote(free) hosts though they had a firewall themselves, I couldn't connect to the database there either. Which is why I thought i'd go over to paid hosting and have IPs whitelisted.

Is there anyway round accessing it through an external socket, and instead access solely with the IP?

I would therefore put $db_host = 'IP for server A' without the port in the config file.

or any other ideas????

Yordan - what is different about the way your servers are set up as opposed to the ones I'm using?

It is correct to write the port with the ip as ip:port in place of 'localhost' ?? in the php script.

Comment/Reply (w/o sign-up)

faulty.lee

Apr 22 2008, 04:26 PM

QUOTE(glodrop @ Apr 22 2008, 11:33 PM)

My host on server A suggested me testing it via telnet. Is the reason why I just get a load of ascii characters - because its not meant to be used that way. ? It seems that I am connecting. Is that what I am supposed to get on telnet?

Yes, that's what you should be getting, meaning, you don't even need whitelist, the port is already open, and they allow external access

QUOTE(glodrop @ Apr 22 2008, 11:33 PM)

Server C is a free host, server A isn't, so I can't get anything from server C, I've tried communicating with them before on this. I have tried accessing the dbase uploaded to other remote(free) hosts though they had a firewall themselves, I couldn't connect to the database there either. Which is why I thought i'd go over to paid hosting and have IPs whitelisted.

Why not just host your pages and database on the same server. If you're worried about your domain name, you can assign it to another server of your choice.

QUOTE(glodrop @ Apr 22 2008, 11:33 PM)

Is there anyway round accessing it through an external socket, and instead access solely with the IP?

I would therefore put $db_host = 'IP for server A' without the port in the config file.

or any other ideas????

Yordan - what is different about the way your servers are set up as opposed to the ones I'm using?

It is correct to write the port with the ip as ip:port in place of 'localhost' ?? in the php script.

Yes, that's the way to put the port. If you ignore the port, it will use the default 3306. So, if you're using default port, you don't have to put it in the config. IP alone will do. I guess you mean "route" (round), since you can't make socket connection, i guess you can't route also, you still need a socket connection to route.

Comment/Reply (w/o sign-up)

glodrop

Apr 22 2008, 05:49 PM

I don't host my pages and database together on the same server as the domain name is a sub-domain of the free host; I can't just change nameservers. I am running out of space on server C and server C doesn't allow upgrades. It would also be useful to have a few sites on different servers accessing the same database

Would it be possible to have a port eg. 22 or 2222 with the ip - to read as ip:22 in the php script and then once connected to server A it would then be forwarded to port 3306 still giving the necessary login and password.

Perhaps server C is only denying external socket connection for port 3306, perhaps not for all the ports????

How could I set this up to work on server A?

Perhaps I could ask the host of server A to assign my database to a different port. Though if server C is not denying external socket connection for all ports - which would be the best port to use?

Comment/Reply (w/o sign-up)

faulty.lee

Apr 22 2008, 06:49 PM

QUOTE(glodrop @ Apr 23 2008, 01:49 AM)

Perhaps server C is only denying external socket connection for port 3306, perhaps not for all the ports????

Denial of external socket connection means all ports. You should first try to confirm if server C is in fact denying all external socket connection including MySQL.

It's really not worth the effort to setup proxy via php. It's a very complex solution for a very simple problem. Running php based proxy will make you face more problem later, as proxy require more direct access to the host's hardware as oppose to conventional method. 99% of all web host limit such functionality as it post a huge risk of security.

You can setup redirection to your subdomain on server C to your server A and host everything there. You can keep those non data related pages/images on server C if space is a constrain. Though the best practice is still keeping everything under one roof for easy maintenance and faster access(performance)

Comment/Reply (w/o sign-up)

yordan

Apr 24 2008, 04:39 PM

Maybe your database server has a problem.
I would suggest, for debugging purposes, to use a public free database server.
For instance, try http://www.freemysql.net/v2/ , register to an account, create a database, use their phpmyadmin to verifiy that the database is functionnal, and then try to remotely connect to your database.
I don't like freemysql.net because their control panel has a lot of ads and popups ; however, their remote database server works fine, so for testing purposes it's OK.
yordan

Comment/Reply (w/o sign-up)

Similar Topics

Keywords : Connecting Remote Database

Want Help In Connecting DB To Java - (7)
Actually i know how to create an independent database and how to update it manually. But i just
want to know that how can i make that update thing automatically. Like suppose if i give somekind of
username and password to members of my site and i wish to have them updated , like addition ,
deletion or changes in password, to be automatic how can i do that. i have a rough idea that it can
be done with the help of Java and jdbc but i don't know exactly. I m good at programming
languages C and Java....

MySQL Output Database Question - (19)

I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?...

How To Understand A Database Schema - A very nice and simple tutorial (9)

Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
Understand a Database Schema . As its name says, this tutorial will help you to better understand a
Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
"Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ...

Accessing Ms Access Database From A Centralized Location? - (10)

Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t...

MS-database To MySQL - I'd like to batch them (6)

Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've
got two vocable trainers, one is Windows-native, the other one is on the web. While I can't
control the output of the Windows-thing (so I can't export them to a *csv or something), I can
write an import script. But since I'm not that great with Regular Expressions and don't know
anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make
out the field information and put it in arrays or something more readable. It wou...

Database Access On Remote Server W/jsp - (2)

Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
not sure exactly what needs to be packaged with my Java application to make it work. Since I
don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
JDBC driver would be bundled with my site but not sure. Thanks!...

Mirror My MySQL Database To Another Mysql Server - (7)

Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility....

How Can I Import Csv Files To My MySQL Database? - I was able to export but where's import? (3)

I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv
files and someone imported it on the mysql server. I was not able to ask him. Does someone know how
can I import csv files in mysql server?...

Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database - (6)

Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks...

Best Database - (16)

What is the best free database if some one trying built a social networking website? And how to
operate it with dreamweaver 8?...

MySQL Database Problems - (8)

My friends have a little forum running here . The problem is that quite often we get the following
message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
/home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied
argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on
line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/vhosts/roh...

Free Or Opensource Database/schema Browser? - Alternatives to TOAD or PL/SQL Developer (6)

Some Useful Database Links. - (7)

I thought I would take a moment to point the users here to some of the database resources available
for reference and learning. First I will start with actually designing the database. This site by
R937 covers the basics of database design. The author is professional database guru and a frequent
helper at the at DB forums listed below. The Library of Free Data Models is an excellent
resource for finding data models for projects you may have or as examples of well put together data
models. With around 500 data models the chances are you find something at least cl...

Space Needed For Database - (10)

Iam assuming the information in the databases i will create will be stored in the 500 MB space i
get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
and big int...

Mysql Database Entry By Excel Sheets - (2)

Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks...

Mysql Database Management - (1)

Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ...

Integrate Access Database Onto Intranet Site - Looking to integrate access database into my intranet site (5)

Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the same d...

Database - prblem with it (1)

i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
edit its config.php right and but my database name and my user name and password every thing right
and when i try to install it it gives me this error can`t connect to database please choose file
from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend...

Permission Problem With Mysql Database Creation - Please Help! (8)

I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?...

Need Help In Database Auto_increment - (9)

i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx...

Embedded Database - Embedded Data base at client side, (7)

Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
EDB Cheers Arunkumar.H.G...

Need Advice On Creating Online Music Database - ps - dont know anything about databases! (6)

I need to create a database of around 1000 music albums that I can put on my site, with the ability
to search the database according to several different criteria. Being a complete and total NOOB to
the world of databases, can anyone point me in the direction of some software that will let me
create a good-looking and functional database, but that isn't too complicated for me to use?!
Sounds like a tall order I know, be grateful if anyone can help though. Thanks!
Notice from microscopic^earthling: Topic edited to reflect content...

The Best Database - What do you think is the best database? (48)

Ive been planning to create a online application which requires tons of stuff from database. Ive
been using interbase, at first it was good but after a month i find it not user friendly at all...
Its to hard to code in php.. Can any of you guys give me a good database which is easy to use?...

phpBB Database Transfer - Anyone here knows how to? (10)

Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I
transfer the datas(users,configs, all of them) contained in my current forum to another one in
phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want
to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks
in advance, hope anyone here knows how to....

My Sql Database Help? - (3)

Ok, i am new at web design, i dont know too much about it... I was working on a website for about
a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all
of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to
acquire the URL of the database or any information i dont know what it means at all.. i just want to
do a simple login feature, i mean this is my first website and i am learning so I think it would be
a great feature to add in and learn. i can create data bases from there but do n...

Database Size? - So how big is everybody's MySQL database? (10)

Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies
databases were? Do you have really big ones, or are they relatively small? Also what do you store in
them? (just text, or binary data as well)...

How Many Concurrent Users For Oracle Database? - This is to analyse and get perfect result for How many concurrent use (1)

Hi friends, How many concurrent users can practically access the oracle database?
they say tht the figure is hundreds of thousands users...is there any exact figure? or does the
number of concurrent users depend on any other factors as wel? I think depend on parameter
1.session 2.processes session Specific connection of a user to an Oracle instance through a user
process. A session lasts from the time the user connects until the time the user disconnects or
exits the database application. Multiple sessions can be created and exist concurrently for ...

Database Programming In Vba 6.0 - (1)

hi , i need some sample program in database.thanks...

Need Info On Database Programming Courses - Oracle Database Programming (2)

I know Database Programming on MS-ACCESS, now i am planning to go for some other Database
Programming courses, People told me to go for Oracle or VisualAge. Can anyone told me to start with
which one and how long is the course period and which one is easy and is it similar to ms access or
somthig different....

Can I Remotely Access Astahost MySQL DBs? - Remote Ascess??? (11)

I can Access This MySQL Server using a Software like MySQL-Front?...

Looking for connecting, remote, database