Hi Tereza,
A host may not allow direct access to a database. You may indeed need
a CGI or PHP script, which I do by default nowadays. However, if you
can connect with Navicat, I'd expect you'd be able to connect with any
other tool, including your own. Haven't you forgotten to set the
password handling of the remote MySQL database to old style?
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
Snapper Screen Recorder 2.0.1 http://snapper.economy-x-talk.com
If you sent me an e-mail before 15 May and haven't got a reply yet,
please send me a reminder.
On 8 jun 2009, at 06:17, Tereza Snyder wrote:
Hi All,
I told my client Rev could do it...and now I'm stuck! Here's what my
app needs to do:
1) user downloads Rev app from web page
2) user runs app
3) user types username and password
4) app looks up username/password in remote MySQL database
...if found:
5) user does stuff with app that generates data
6) app uploads data to remote MySQL database
7) app thanks user and quits.
I have 5) completed—a nice app that does complex stuff to collect
data—and now its time to implement the DB end of things, beginning
with making a connection to a remote database. I have a DB set up on
a remote server that I can configure. I can access the tables there,
etc with Navicat.
Now what?
To get my feet wet, I downloaded Trevor DeVore's libDataBase, and
installed his "recipes" demo db on my local (macos x) MySQL and it
runs fine. I installed the data in the remote MySQL, changed the
"host" stuff in the demo to point to it, but the "recipes" stack
can't connect.
A great chasm of ignorance is open at my feet. I suspect there's
security issues and many many more icky demons lurking in the
depths. I HAVE ONE DAY TO BRIDGE THAT CHASM.
Do I need to install a rev cgi on the remote server to communicate
with the DB? Aaaeeee! What should it do?
I know for a fact that Rev apps can do this. I've seen them. But the
details elude me.
Help!
t
_______________________________________________
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
