SQL Show Status

[Pi Digital]

I was actually trying to look at the sslcypher tag. Wanted to see if it thought the server was enabled for it and if the certs would work. But there was no way of telling using revdb if the certs were wrong, if the server was set or anything. No one was able to tell me how to find out and was just flying blind (as is often the case with LC documentation). 

But I’ve abandoned revdb now and opted entirely for php. That way I just use https for security. 

Next issue when I transfer back to HTML5 deployment of these apps is to work out how to get RSA encryption working. Probably another php script (which again will be insecure while feeding through JS, unless the Post command works ok in that environment - ??).  

All the best Bob 

Sean Cole
Pi Digital


> On 20 Oct 2020, at 22:20, Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> I’m wondering what status you are trying to retrieve. If you are wanting to see if the SQL database is accessible/online, using an actual query has it’s drawbacks. Querying an SQL database that is inaccessible will result in a 60 second timeout during which Livecode will be unresponsive. 
> 
> What I do instead is I first execute a telnet command using shell(). This will tell me if I can get to the SQL server and if it’s listening. The next thing you can do is execute a simple query SHOW STATUS will work as well as anything else. You can also execute something like select 1+1 as sum. You don’t even need to know a table or column. 
> 
> Bob S
> 
> 
>> On Oct 19, 2020, at 10:53 AM, matthias rebbe via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> You have to use
>> 
>> revDataFromQuery()
>> 
>> because that will execute the SQL statement and will return any data that is coming from the DB Server.
>> 
>> Regards,
>> Matthias
>> 
>> -
>> Matthias Rebbe
>> Life Is Too Short For Boring Code
>> 
>>>> Am 19.10.2020 um 19:41 schrieb Sean Cole (Pi) via use-livecode <use-livecode at lists.runrev.com>:
>>> 
>>> Hi Ralph,
>>> 
>>> What do I do to see the data in the two columns? My brain is hurting too
>>> much to figure it out.
>>> 
>>> Thanks
>>> Sean
>>> 
>>> On Mon, 19 Oct 2020 at 18:26, Ralph DiMola via use-livecode <
>>> use-livecode at lists.runrev.com> wrote:
>>> 
>>>> Sean,
>>>> 
>>>> revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer
>>>> 
>>>> That integer is a record set.
>>>> In my case it returned 536 rows.
>>>> Each row has two columns:
>>>> Variable_name
>>>> Value
>>>> 
>>>> 
>>>> Let me tell you Mr. Johnson... Some very interesting stuff in there.
>>>> 
>>>> Ralph DiMola
>>>> IT Director
>>>> Evergreen Information Services
>>>> rdimola at evergreeninfo.net
>>>> 
>>>> 
>>>> -----Original Message-----
>>>> From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On
>>>> Behalf Of Sean Cole (Pi) via use-livecode
>>>> Sent: Monday, October 19, 2020 12:50 PM
>>>> To: How to use LiveCode
>>>> Cc: Sean Cole (Pi)
>>>> Subject: SQL Show Status
>>>> 
>>>> Hi
>>>> 
>>>> As everyone likes to hijack threads here, I’ve started another to make
>>>> sure it gets seen.
>>>> 
>>>> 
>>>> revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer
>>>> 
>>>> Same for revdb_execute which returns 0
>>>> 
>>>> Any clues on how to actually get the status back?
>>>> 
>>>> Still trying to work out why these certificates are not working.
>>>> --
>>>> Sean Cole
>>>> *Pi Digital Productions Ltd*
>>>> www.pidigital.co.uk
>>>> +44(1634)402193
>>>> +44(7702)116447
>>>> 'Don't try to think outside the box. Just remember the truth: There is no
>>>> box!'
>>>> 'For then you realise it is not the box you are trying to look outside of,
>>>> but it is yourself!'
>>>> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode