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 <[email protected]> wrote:
From: Rick Harrison <[email protected]>
Subject: Re: Connecting Stack to Remote On-Rev MySQL Database
To: "How to use Revolution" <[email protected]>
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, [email protected]
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 <[email protected]>
To: [email protected]
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
[email protected]
Please visit this url to subscribe, unsubscribe
and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
To: [email protected]
_______________________________________________
use-revolution mailing list
[email protected]
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
[email protected]
Please visit this url to subscribe, unsubscribe and manage
your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
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
[email protected]
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
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
