MySQL Database Query Builder Question

Thu Apr 28 06:29:27 EDT 2005

An excerpt taken from oneandone-

"The MySQL database is stored on a separate database server behind a
firewall to protect your data. You can only access this database server and
your database exclusively through your site. Direct access to the MySQL
database using a home PC (external ODBC connection) cannot be established."

I'm moving Host. Can you suggest anyone?

Regards

Martin  

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of docmann
Sent: 28 April 2005 11:16
To: xbury.cs at clearstream.com
Cc: How to use Revolution
Subject: Re: MySQL Database Query Builder Question

As an afterthought, I'd highly recommend that you have a good look at the
mySQL documentation in regards to security settings. It would be a good
thing to understand the issues *before* making changes. :)

-Doc-

On 4/28/05, docmann <docmann at gmail.com> wrote:
> Hello Xavier,
> Actually there is a link directly from the main phpMyAdmin page where 
> you can check and or change the status (assuming you have the right 
> access privilages).
> 
> I know that on our LAN, I cannot connect from a remote work station 
> without changing the "Host" settings....
> 
> HTH,
> -Doc-
> 
> On 4/28/05, xbury.cs at clearstream.com <xbury.cs at clearstream.com> wrote:
> >
> > Doc,
> >
> > Is this in the config.php file or?
> >
> > cheers
> > Xavier
> >
> >
> > On 28.04.2005 11:32:00 use-revolution-bounces wrote:
> >  >Hello Martin,
> >  >It's a long shot, but there is one more thing to check before giving
up...
> >  >
> >  >Using PhpMyAdmin, have a look at the "privilages" that are set up 
> > for  >your DB and make sure it is set to "% any", which will allow 
> > access  >from any domain address.
> >  >
> >  >-Doc-
> >  >
> >  >On 4/28/05, Martin McCarrick <martin.mccarrick at btinternet.com> wrote:
> >  >> Xavier
> >  >>
> >  >> Oneandone.co.uk use call centre's in the far east, it's not a 
> > pleasant  >> experience trying to simply understand what they are 
> > saying, imagine trying  >> to negotiate!!
> >  >>
> >  >> It's a bit flippant I know but my nerve's have been taken to the 
> > limit with  >> call centre's. I would love to speak to an English 
> > speaking person who I can  >> understand & who isn't simply 
> > referencing a FAQ (that I've already
> > studied)
> >  >> to provide answers.
> >  >>
> >  >> I think id like to simply change ISP (out the frying pan!)  >>  
> > >> Thanks for your help  >>  >> Martin  >>  >>  >> -----Original 
> > Message-----  >> From: use-revolution-bounces at lists.runrev.com
> >  >> [mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of  
> > >> xbury.cs at clearstream.com  >> Sent: 28 April 2005 09:18  >> To: 
> > How to use Revolution  >> Subject: RE: MySQL Database Query Builder 
> > Question  >>  >> Martin,  >>  >> Later I'll be trying to drive the 
> > phpmyadmin post and gets to make it run  >> but as you imagine it's 
> > not very efficient. However i dont really need a  >> "live" access 
> > to it...
> >  >>
> >  >> Have you tried negotiating with the ISP for it?
> >  >>
> >  >> cheers
> >  >> Xavier
> >  >>
> >  >> On 28.04.2005 10:06:43 use-revolution-bounces wrote:
> >  >> >Thanks Sarah & Xavier
> >  >> >
> >  >> >With PHP 3306 is the port used, I tried changing to  >> 
> > 'oneandone.co.uk:port'
> >  >> >with many variations, to no avail.
> >  >> >
> >  >> >It seems that Xavier hit the nail on the head, my ISP wont 
> > allow this  >> type  >> >of access!!
> >  >> >
> >  >> >I really cant see the point of having a database that I cant
access.
> >  >> >
> >  >> >Can anyone recommend a good ISP with 'proper' database hosting 
> > (MySQL  >> >PHP  >> >etc...)  >> >  >> >Regards  >> >  >> >  >> 
> > >Martin McCarrick  >> >  >> >  >> >  >> >  >> >-----Original 
> > Message-----  >> >From: use-revolution-bounces at lists.runrev.com
> >  >> >[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of 
> > Sarah  >> Reichelt  >> >Sent: 28 April 2005 05:00  >> >To: How to 
> > use Revolution  >> >Subject: Re: MySQL Database Query Builder 
> > Question  >> >  >> >Hi Martin,  >> >  >> >> I'm trying to connect to 
> > my database which is hosted by  >> >> oneandone.co.uk. I'm using the 
> > database query builder in RR.
> >  >> >>
> >  >> >> I set the name (Contact),
> >  >> >> host (db141.oneandone.co.uk) - this is the actual server name  
> > >> >> Database (dbxxxxxxxx), User (dboxxxxxxxx) Password (xxxxxxxx)  
> > >> >>  >> >> When I try to press the connect button I get an error 
> > "Unknown MySQL  >> >> Host 'db141.oneandone.co.uk' (11004)'
> >  >> >>
> >  >> >> I am able to connect to the database in PHP MyAdmin without 
> > any  >> >> problems!
> >  >> >>
> >  >> >> The only thing I can think of that could be causing this is 
> > the  >> >> syntax of the host name!! maybe I'm wrong, has anyone had 
> > this problem?
> >  >> >>
> >  >> >When I tried to find the IP address for 
> > "db141.oneandone.co.uk", I got  >> >nothing. However I was able to get
an address for "oneandone.co.uk"
> >  >> >using the hostNameToAddress() function.
> >  >> >
> >  >> >If the Rev database query builder uses the hostNameToAddress 
> > function  >> before  >> >trying to connect, it isn't going to work 
> > for the host name you have  >> >supplied. What happens if you use 
> > just "oneandone.co.uk"?
> >  >> >
> >  >> >When you connect using PHP, does it use the standard MySQL port
(3306)?
> >  >> >If not, you need to add this to the host name e.g.
> >  >> >oneandone.co.uk:12345 where 12345 is my imaginary port number.
> >  >> >
> >  >> >HTH,
> >  >> >Sarah
> >  >> >
> >  >> >_______________________________________________
> >  >> >use-revolution mailing list
> >  >> >use-re
> >
> > ________________________________
> >
> >
> >
> >
> >  Visit us at http://www.clearstream.com
> >
> > IMPORTANT MESSAGE
> >
> > Internet communications are not secure and therefore Clearstream 
> > International does not accept legal responsibility for the contents 
> > of this message.
> >
> > The information contained in this e-mail is confidential and may be 
> > legally privileged. It is intended solely for the addressee. If you 
> > are not the intended recipient, any disclosure, copying, 
> > distribution or any action taken or omitted to be taken in reliance 
> > on it, is prohibited and may be unlawful. Any views expressed in 
> > this e-mail are those of the individual sender, except where the 
> > sender specifically states them to be the views of Clearstream
International or of any of its affiliates or subsidiaries.
> >
> > END OF DISCLAIMER
>
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution