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" <rdim...@evergreeninfo.net> To: "'How to use LiveCode'" <use-livecode@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 rdim...@evergreeninfo.net -----Original Message----- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of kevin--- via use-livecode Sent: Wednesday, July 15, 2020 6:08 AM To: use-livecode@lists.runrev.com Cc: ke...@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@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@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-livecode ------------------------------ End of use-livecode Digest, Vol 202, Issue 16 ********************************************* _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode