into tDatabasePassword
-- connect to the database
put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName,
tDatabaseUser, tDatabasePassword) into tResult
Worked for me.
-- Mark
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/connec
Yes I do as well. However this is considered in the industry a non-secure way
of connecting to mySQL because of all the exploits that are out there. We use a
digital lock and key system here on this campus (which will remain nameless),
which is managed from a "secure" mySQL server ru
...@lists.runrev.com] On Behalf Of Mark Schonewille
Sent: Saturday, September 29, 2012 2:05 AM
To: How to use LiveCode
Subject: Re: connecting to mysql
Hi Mark,
What made you think that you could use the RunRev server to test your own
MySQL scripts? Have you got any documentation from RunRev about this?
Usually
On Sun, Sep 30, 2012 at 11:26 AM, Malte Brill wrote:
> the server engine is perfectly capable to connect to the databases that are
>supported in the desktop engine. At least for postGres and mySQL I know for
>sure as
>I am using those two. :-)
Yes, I've done it directly to one of my ISPs.
> Wh
Richard,
I agree that RevServer could come with some scripts. A collection of sample
scripts to get you started with databases wouldn't go amiss.
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com
Hi Doc,
the server engine is perfectly capable to connect to the databases that are
supported in the desktop engine. At least for postGres and mySQL I know for
sure as I am using those two. :-)
What you can not do in most cases, is connect from a desktop app to some remote
database, unless you
On Sun, Sep 30, 2012 at 10:27 AM, Mark Schonewille
wrote:
> RunRev Ltd. can't guess which language you're going to use for the server
> side.
>Therefore, they can't deliver those scripts.
But they can. I have the full developer pack and a runrev server
account. At the *very* least, my stack sh
Hi Richard,
RunRev Ltd. can't guess which language you're going to use for the server side.
Therefore, they can't deliver those scripts. If they started delivering such
scripts, then they would also have to deliver server-side scripts for web
forms, e-mailing, uploading files, etc. Surely, it w
On Sun, Sep 30, 2012 at 9:41 AM, ha...@exformedia.se
wrote:
> . What you need is, as suggested before, to have some CGI-script written in a
> server
>language (if you have MySQL that language is probable PHP.)
And I really find it incomprehensible that this isn't built into
livecode with matchin
>
>
>
> --
> View this message in context:
> http://runtime-revolution.278305.n4.nabble.com/connecting-to-mysql-tp4655547p462.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
>
> ___
> use
, I've never setup my computer as a server on the internet.
Is this something I can expect to fairly easily do through my web host?
Thanks
-- Mark
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/connecting-to-mysql-tp4655547p462.html
Sent from the Revo
regards,
>
> Mark Schonewille
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/connecting-to-mysql-tp4655547p461.html
Sent from the Revolution - User mailing list archive at Nabble.com.
___
use-livecode mail
Hi Mark,
What made you think that you could use the RunRev server to test your own MySQL
scripts? Have you got any documentation from RunRev about this?
Usually, web hosting companies don't allow remote connections. You need a
script on your server as a layer between LiveCode and MySQL, which i
utoReconnect])
BTW, the error I am getting at www.runrev.com is
Host 'wnpgmb014uw-ad04-17-21.dynamic.mtsallstream.net' is not allowed to
connect to this MySQL server
Thanks
-- Mark
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/connecting-to-mysql-tp4655547.
Hi William,
as your first time, probably is not a good idea to start connecting to a
remote DB using a PHP script ...
To start to learn, probably the best is to create a little 'TEST'
environment locally ...
... if you run on MAC, you can install MAMP
(http://www.mamp.info/en/mamp/index.htm
Many ISPs have a security scheme in which the MySQL sever will only respond
to IPs that are registered with the current user ... be sure to look in all
your panels for something like this.
Dreamhost and On-Rev allow off site connections to databases, with the
IP feature enabled. This is extremel
Hi Mark,
I just saw you replied as well. Thanks!
Your reply is over my head :-(
groeten,
William
2012/7/1 William de Smet :
> Hi Malte,
>
> Thanks, but I don't get it ;-(
> Do you mean I have to put the db_username and db_password etc. in a
> .php file on my server.
> But how do I connect? And
Hi Malte,
Thanks, but I don't get it ;-(
Do you mean I have to put the db_username and db_password etc. in a
.php file on my server.
But how do I connect? And how do I retrieve the data?
Like I said: it's my first time on database!
groeten,
William
2012/7/1 Malte Brill :
> Hi William,
>
> bes
Malte is right. Also, ISP's more often don't than do allow remote database
access. Here's an example (but no downloads) of a product I made for a customer
to cope with this problem: http://qery.us/2b1 It all works through PHP. If you
have RevServer, you could use iRev instead of PHP. I use a PHP
Hi William,
best bet is to implement a piece of middleware (e.G. a PHP script) you can get
the data from. Then the server does the connection to the mySQL database and
you retrieve the data using a http request.
Hth,
Malte
___
use-livecode mailing
Hi there,
I am doing my first steps on MySQL and LC (trying to update a website
from within LC).
I followed video #10 'Display an SQL Database' from the LiveCode
Academy but I immediately got stuck while connecting.
My Dutch ISP however doesn't allow remote access on databases.
So how do I conti
Are you sure that your tunnel is working?
I'm assuming that for some reason SSL is not an option, neither is a VPN.
You should be able to tunnel a database connection through a SSH tunnel.
I've done it many times with different kinds of databases and servers
(although never with MySQL).
Can you p
In the past, when I was creating a php database and needed to test
it, but did not want to open the floodgates and allow any IP address in,
or if I was moving around from place to place
and my IP would change
depending on where I was, tunnelling was an option with some software.
Essentially
Thanks, Bob. I have to confess that I'm not well educated in networking. I'm
a regular guy who uses livecode to facilitate tasks I perform at work.
Here's a wikipedia article (yeah, know its limitations as a reference
source) that includes an explanation of SSH tunneling.
http://en.wikipedia.org/
Help says:
Syntax:
revOpenDatabase("mysql",host[:port], databaseName,
[userName],[password],[useSSL], [socket], [timeout], [autoReconnect])
Notice the new useSSL argument? All you have to do now is determine if the host
accepts SSL connections, and if so, on what port. I am not
I have an app for managing data in a MySQL database on a remote server. It¹s
worked fine for years but now I would like to route the connection thru an
SSH tunnel. It uses a port number other than 3306 (PortNumberHere in the
function example below). So I¹ve changed the relevant function from this..
26 matches
Mail list logo
