Re: remote mySQL connection not working
Hi Ton, Before you do anything else, call your ISP and ask if a direct connection is allowed. Very many ISP's only allow connections from applications running on the same server (such as Apache and Perl). If your ISP does allow direct remote connections, make sure that you have set up a username and password correctly for your database. It is weird that the error says using password: NO. Usually, you need to configure a server to explicitly assign a user to a database. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 New: Download the Installer Maker Plugin 1.6 for LiveCode here http://qery.us/ce On 22 feb 2011, at 14:02, tkuyp...@telenet.be wrote: A very strange thing is happening when connecting to a mySQL database. going to my localhost on my Mac, no problems logging in, but when I try to connect to my remote mySQL server, I keep on getting the error Access denied for user 'intelli-pubs'@'94-224-36-65.access.telenet.be' (using password: NO) My first reaction was running the old_password command on the server (SET PASSWORD FOR 'intelli-pubs'@'%' = OLD_PASSWORD('xxx');) but that didn't solve the problem. Who can shine a light on this, any reaction is welcome, because I'm completely stuck :-( Warm regards, Ton Kuypers ___ 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
Re: remote mySQL connection not working
Hi Mark, No, that's ok, I do have remote access. Did some more testing and the plot thickens... When I use put revOpenDatabase(mysql, myFakeURL.com, DatabaseName, UserName, Password) into dbResult it works fine. But when I use variables (put revOpenDatabase(mysql,dbAddr,dbName,dbUser,dbPass) into dbResult) I can't connect... Met vriendelijke groeten, Ton Kuypers ___ 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
Re: remote mySQL connection not working
Step through your code and make sure your variables are what you expect. They probably are not. Bob On Feb 22, 2011, at 6:42 AM, tkuyp...@telenet.be wrote: Hi Mark, No, that's ok, I do have remote access. Did some more testing and the plot thickens... When I use put revOpenDatabase(mysql, myFakeURL.com, DatabaseName, UserName, Password) into dbResult it works fine. But when I use variables (put revOpenDatabase(mysql,dbAddr,dbName,dbUser,dbPass) into dbResult) I can't connect... Met vriendelijke groeten, Ton Kuypers ___ 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 ___ 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
Re: remote mySQL connection not working
I put the variables into the message-box and copied them to my code from there... So sorry, the variables are correct, got no idea why this doesn't work. But because there is nu user-interaction required to set these parameters, I just entered them in the code :-) Met vriendelijke groeten, Ton Kuypers ___ 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
Re: remote mySQL connection not working
Ton - I'd still suspect a problem with the variable or the variable name. Invisible characters have a habit of creeping into the script editor if your fingers are as clumsy as mine. Try deleting the relevant bits of code and retyping them. I make mySQL connections all the time using variables (as in your example) and it works just fine. Terry... On 23/02/11 4:59 AM, tkuyp...@telenet.be tkuyp...@telenet.be wrote: I put the variables into the message-box and copied them to my code from there... So sorry, the variables are correct, got no idea why this doesn't work. But because there is nu user-interaction required to set these parameters, I just entered them in the code :-) Met vriendelijke groeten, Ton Kuypers ___ 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 -- Dr Terry Judd | Senior Lecturer in Medical Education Medical Education Unit Melbourne Medical School The University of Melbourne ___ 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
Re: remote mySQL connection not working
Hi Terry, Will give it another try, it must be something like that. Thanks! Met vriendelijke groeten, Ton Kuypers ___ 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