Re: connecting to mysql

2012-10-01 Thread Mark Smith
Hi Mark, I contacted RR about their MySQL lesson and they sent me updated connection parameters: put "runrev.com" into tDatabaseAddress put "runrev_test" into tDatabaseName put "runrev_example" into tDatabaseUser put "example" into tDatabasePassword -- connect t

Re: connecting to MySql

2012-10-01 Thread Bob Sneidar
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 running on a L

RE: connecting to MySql

2012-10-01 Thread Ralph DiMola
...@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

Re: connecting to mysql

2012-09-30 Thread Dr. Hawkins
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

Re: connecting to mysql

2012-09-30 Thread Mark Schonewille
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

Re: connecting to mysql

2012-09-30 Thread Malte Brill
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

Re: connecting to mysql

2012-09-30 Thread Dr. Hawkins
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

Re: connecting to mysql

2012-09-30 Thread Mark Schonewille
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

Re: connecting to mysql

2012-09-30 Thread Dr. Hawkins
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

Re: connecting to mysql

2012-09-30 Thread ha...@exformedia.se
Most web hosting companies have one or more MySQL-eneabled offerings, but only a few of them allow you to connect remotely to their database, and most doesn't allow you to add users. I.e. all users will run as the same user. What you need is, as suggested before, to have some CGI-script written

Re: connecting to mysql

2012-09-29 Thread Mark Smith
Mark Schonewille-3 wrote > 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? Hi Mark, I think the part that confused me was the line "RunRev has set up a sample database which these scripts will use". T

Re: connecting to mysql

2012-09-29 Thread Mark Smith
Thanks Mark. I'm new to the server stuff so was not familiar with the process. LC has a lesson where they suggest you can connect to MySQL directly on their site (I think) but maybe I am misunderstanding them. http://lessons.runrev.com/s/lessons/m/4071/l/7003-Connecting-to-a-MySQL-database Thats

Re: connecting to mysql

2012-09-28 Thread Mark Schonewille
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

Re: connecting to MySQL database thru SSH tunnel

2011-12-08 Thread Bernard Devlin
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

Re: connecting to MySQL database thru SSH tunnel

2011-12-08 Thread Admin
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

Re: connecting to MySQL database thru SSH tunnel

2011-12-08 Thread Sieg Lindstrom
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/

Re: connecting to MySQL database thru SSH tunnel

2011-12-07 Thread Bob Sneidar
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