Live code Server revOpenDatabase help needed

[kevin at stallibrass.com]

Thanks Ralph,

I checked out this possibility by putting this (and the associated variable
population in a button in livecode:

   put revOpenDatabase("mysql", tDatabaseAddress, tDatabaseName,
tDatabaseUser, tDatabasePassword) into tResult
   
Works fine from livecode so I know there is no issue with the database but
when I place the same line into a single page website and use 64bit livecode
server, it fails on every version from 7 to 9. 
I'm doing my tests using livecode-community-server and was wondering if this
was a limitation of the community version. It certainly wasn't with the old
32bit version because I've tried it on my old server

Interestingly, my old 32 bit v6.x livecode & livecode server were happy with
"MySql" but v9 Livecode only accepts "mysql"

I would test a 32bit server version but it's seemingly impossible to install
working 32bit libraries in Debian 8 or 9

Regards
Kevin

-----Original Message-----


Message: 9
Date: Wed, 15 Jul 2020 08:36:34 -0400
From: "Ralph DiMola" <rdimola at evergreeninfo.net>
To: "'How to use LiveCode'" <use-livecode at lists.runrev.com>
Subject: RE: Live code Server revOpenDatabase help needed
Message-ID: <000d01d65aa4$96c81640$c45842c0$@net>
Content-Type: text/plain;	charset="us-ascii"

Kevin,

I ran into this when I updated to 64 bit. It was a script only library
stack. I don't know why it worked in v6 but did not work in v9. For me it
was fastJson.livecodescript that caused the problem so I just used the built
json in v9 and all was OK. Why it showed up in a DB open is a mystery?
https://quality.livecode.com/show_bug.cgi?id=22514

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 kevin--- via use-livecode
Sent: Wednesday, July 15, 2020 6:08 AM
To: use-livecode at lists.runrev.com
Cc: kevin at stallibrass.com
Subject: Live code Server revOpenDatabase help needed

Hi,

I've been running a very old (32bit lc server v6 on Ubuntu 16) for years and
the following script works to connect to the SQL database.
My new(er) server (64bit lc server v9 on Debian 8) throws up ~Function:
error in function handler (revOpenDatabase)~ so something has clearly
changed. I've tried removing the socket references, changing the connection
type but the error message remains the same. Has the syntax for
revOpenDatabase changed and I'm reading old documentation again?

Thanks
Kevin

# connect to the database
command dbConnect
put "/var/run/mysqld/mysqld.sock" into _Socket
	put revOpenDatabase("MySql", "localhost:3306", _dbName, _dbUser,
_dbPass,, _Socket) into DB
	if DB is not a number then put "Error: could not connect to
database!" & BR end dbConnect




_______________________________________________
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




------------------------------

Subject: Digest Footer

_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-livecode


------------------------------

End of use-livecode Digest, Vol 202, Issue 16
*********************************************