Connecting Stack to Remote On-Rev MySQL Database

[Pierre Sahores]

Hi Rick,

What Sarah and Jim points out is realy the finest way to go to bind  
your remote stack to a clean and secure irev+MySQL process (POST  
Method calls to the irev script + SQL request from the irev script to  
the MySQL db) ! Any other way would let anyone see how to access to  
your MySQL on-rev backend with your own credentials and it would be  
very dangerous, at least... As long as i know, the on-rev security  
model is set to allow localhost databases accesses only and it's fine  
soo.

Best,

P.


Le 15 févr. 10 à 22:09, Rick Harrison a écrit :

> 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
>
>
> _______________________________________________
> 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
>

--
Pierre Sahores
mobile : (33) 6 03 95 77 70

www.woooooooords.com
www.sahores-conseil.com