Connecting Stack to Remote On-Rev MySQL Database

[Rick Harrison]

Hi Michael,

Yes, I'm using MySQL on the on-rev server.

I can access it fine from an irev script.

I need to access it remotely from a stack.

Rick

On Feb 15, 2010, at 1:40 PM, Michael Kann wrote:

> Rick, 
> 
> Are you using MySQL on the on-rev server?
> 
> --- On Mon, 2/15/10, Rick Harrison <harrison at all-auctions.com> wrote:
> 
>> From: Rick Harrison <harrison at all-auctions.com>
>> Subject: Re: Connecting Stack to Remote On-Rev MySQL Database
>> To: "How to use Revolution" <use-revolution at lists.runrev.com>
>> Date: Monday, February 15, 2010, 11:19 AM
>> Hi Matthias,
>> 
>> I've already seen http://samples.on-rev.com/database.irev which only
>> shows
>> how to open a local MySQL database not a remote one.
>> 
>> I am specifically looking for code examples, not the
>> basics.
>> 
>> The information you provided about %.%.%.% as an ip-address
>> was helpful,
>> and I thank you for that!
>> 
>> Rick
>> 
>> 
>> 
>> On Feb 14, 2010, at 4:58 PM, runrev260805 at m-r-d.de
>> wrote:
>> 
>>> Rick,
>>> 
>>> first of all you have to enable Remote Access for your
>> database. You can do that in cPanel
>> ->Databases->RemoteDatabase Access Hosts. If the
>> computer, which runs the stack, does not have a static
>> internet ip, then you have to  enter %.%.%.% as
>> ip-adress in Access Hosts. 
>>> 
>>> At http://samples.on-rev.com/database.irev
>> you find a code example how to access an MySQL database. It
>> is an irev example, but the sections  
>>> 
>>> #Open the database connection
>>> #Construct the SQL Statement
>>> #Close the database connection
>>> can also be used in an stack.
>>> 
>>> Hth,
>>> 
>>> Matthias
>>> 
>>> -------- Original Message --------
>>> Subject: Connecting Stack to Remote On-Rev MySQL
>> Database (14-Feb-2010 22:29)
>>> From:    Rick Harrison <harrison at all-auctions.com>
>>> To:      runrev260805 at m-r-d.de
>>> 
>>>> Hi there,
>>>> 
>>>> I've been all through the archives, and found
>>>> some hints that it is possible to connect to
>>>> a remote MySQL database on On-Rev.
>>>> 
>>>> Doe anyone have a clear step by step
>>>> example of how this is done?
>>>> 
>>>> I don't have time to keep struggling with this
>>>> problem.  I need a solution A.S.A.P.
>>>> 
>>>> Any help is greatly appreciated!
>>>> 
>>>> Thanks,
>>>> 
>>>> Rick 
>>>> _______________________________________________
>>>> use-revolution mailing list
>>>> use-revolution at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe
>> and manage your 
>>>> subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>> 
>>>> 
>>>> 
>>>> 
>>>> To: use-revolution at lists.runrev.com
>>> 
>>> 
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and
>> manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
>> __________________________________
>> Rick Harrison
>> 
>> You can buy my $10 music album "Funny Time Machine" digital
>> CD on the iTunes Store Now!
>> 
>> To visit the iTunes Store now to listen to samples of my CD
>> please click on the
>> following link.  (Please note you must have iTunes
>> installed on your computer for this link to work.)  
>> 
>> http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewAlbum?playListId=213668290
>> 
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage
>> your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
> 
> 
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution

__________________________________
Rick Harrison

You can buy my $10 music album "Funny Time Machine" digital CD on the iTunes Store Now!

To visit the iTunes Store now to listen to samples of my CD please click on the
following link.  (Please note you must have iTunes installed on your computer for this link to work.)  

http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewAlbum?playListId=213668290