RE: MySQL Database Query Builder Question
Dreamhost. <$10/month for all goodies. Great dedicated deals too. I host 15 sites there. Even the 'shared' hosting rocks... Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
Hi Martin, I just had a look at the feature matrix provided by your hosting company and an upgrade may in fact be required, depending on the hosting package you have now Bummer. :( -Doc- On 4/28/05, Martin McCarrick <[EMAIL PROTECTED]> wrote: > Hi Docmann > > It seems that I cant even use phpAdmin anymoreI have it installed (v > 2.3.2) on my site but cant access it anymore as I would normally, the link I > had saved in favourites does nothing now! Not good. > > Oneandone.co.uk now have a MySQL admin link from within their own web > control panel which utilises phpMyadmin 2.6.1, in it there is no access to > privileges. > > I think they have restricted access in favour of me 'upgrading' by the look > of it ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: MySQL Database Query Builder Question
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of docmann Sent: 28 April 2005 11:16 To: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > >> [mailto:[EMAIL PROTECTED] On Behalf Of > > >> [EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] > > >> >[mailto:[EMAIL PROTECTED] On Behalf Of > > Sarah >> Reichelt >> >Sent: 28 April 2005 05:00 >> >To: How to > > use Revolution >&
RE: MySQL Database Query Builder Question
Hi Docmann It seems that I cant even use phpAdmin anymoreI have it installed (v 2.3.2) on my site but cant access it anymore as I would normally, the link I had saved in favourites does nothing now! Not good. Oneandone.co.uk now have a MySQL admin link from within their own web control panel which utilises phpMyadmin 2.6.1, in it there is no access to privileges. I think they have restricted access in favour of me 'upgrading' by the look of it. Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of docmann Sent: 28 April 2005 10:49 To: [EMAIL PROTECTED] Cc: How to use Revolution Subject: Re: MySQL Database Query Builder Question 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] On Behalf Of >> > [EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] > >> >[mailto:[EMAIL PROTECTED] 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 (db), User (dbo) Password () > >> >> >> >> When I try to pres
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 <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > >> [mailto:[EMAIL PROTECTED] On > > Behalf Of > > >> [EMAIL PROTECTED] > > >> 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: [EMAIL PROTECTED] > > >> >[mailto:[EMAIL PROTECTED] 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. > > >> >> > > >>
Re: MySQL Database Query Builder Question
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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] On > Behalf Of > >> [EMAIL PROTECTED] > >> 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: [EMAIL PROTECTED] > >> >[mailto:[EMAIL PROTECTED] 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 (db), User (dbo) Password () > >> >> > >> >> 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
Re: MySQL Database Query Builder Question
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> [EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] >> >[mailto:[EMAIL PROTECTED] 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 (db), User (dbo) Password () >> >> >> >> 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 MESSAGEInternet 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@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] 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 (db), User (dbo) Password () > >> > >> 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-revolution@lists.runrev.com > >http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > >___ > >use-revolution mailing list > >use-revolution@lists.runrev.com > >http://lists.runrev.com/mailman/listinfo/use-revolution > > - > Visit us at http://www.clearstream.com > IMPORTANT MESSAGEInternet 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 privi
RE: MySQL Database Query Builder Question
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] 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: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] 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 (db), User (dbo) Password () >> >> 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-revolution@lists.runrev.com >http://lists.runrev.com/mailman/listinfo/use-revolution > > >___ >use-revolution mailing list >use-revolution@lists.runrev.com >http://lists.runrev.com/mailman/listinfo/use-revolution - Visit us at http://www.clearstream.com IMPORTANT MESSAGEInternet 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@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
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: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] 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 >> (db), User (dbo) Password () >> >> 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-revolution@lists.runrev.com >http://lists.runrev.com/mailman/listinfo/use-revolution > > >___ >use-revolution mailing list >use-revolution@lists.runrev.com >http://lists.runrev.com/mailman/listinfo/use-revolution - Visit us at http://www.clearstream.com IMPORTANT MESSAGEInternet 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@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: MySQL Database Query Builder Question
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 > (db), User (dbo) Password () > > 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-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
Note that some ISPs block this capability... Mine does... cheers Xavier On 28.04.2005 06:00:02 use-revolution-bounces wrote: >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 (db), >> User (dbo) >> Password () >> >> 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-revolution@lists.runrev.com >http://lists.runrev.com/mailman/listinfo/use-revolution - Visit us at http://www.clearstream.com IMPORTANT MESSAGEInternet 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@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
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 (db), User (dbo) Password () 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-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
MySQL Database Query Builder Question
Hi, 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 (db), User (dbo) Password () 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? I've tried the MySQL database example in RR's video tutorials and it connects fine. Thank you Martin McCarrick ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
