-- write sessional data to ATS database
put revOpenDatabase("MySQL","localhost","ATS",<username
here>,<password here>) into pMysql
put "INSERT INTO inter
VALUES(pSession,pInit,pUser,pAddress,pLocation,tData)" into tStatement
revExecuteSQL
pMysql,tStatement,"pSession","pInit","pUser","pAddress","pLocation","tD
ata"
..problem is that it falls at the first hurdle (ie revOpenDatabase)
which returns the following error message:
'Client does not support authentication protocol requested by server;
consider upgrading MySQL client'
Meaning what? That the rev db library is out of date? I'm running
MySQL server version 4.1.11-standard on OSX.3
Hi Terry,
A few weeks ago, Dave Cragg suggested a way around this problem:
I got round this by resetting the user passwords on the newer server
using the OLD_PASSWORD function.
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');
HTH,
Sarah
_______________________________________________
use-revolution mailing list
[email protected]
http://lists.runrev.com/mailman/listinfo/use-revolution
