Have "Acces denied" to remote database by on-rev sql server!

[lowcostweb]

Hi from France
When configuring your mySql database in on-rev, don't forget to allow remote servers in cPanel with "%", otherwise you get access denied to revOpenDatabase
Regards
Jean-Marc

[DR White]

I am also having a "Access denied", when trying to use "revOpenDatabase".

I am not familiar with using "%" for log in.

Could you explain how I need to use "%" to correct this error message?

Thanks,

David

[SparkOut]

This refers to the configuration on the hosting server to allow direct connection from "external" clients. It is usually restricted by default by the ISP, but depending on the host and the hosting package, may be controlled by the administrator (customer). If so, typically in cPanel settings for the database access, allowed ip addresses can be configured. To allow any and all, the wildcard % may be set.
Denial of external addresses is a security feature. It's not best practice to allow open access, and traditionally a middleware script on the server will receive posts from clients, sanitise and update as necessary.

[DR White]

SparkOut,

That worked nicely!

Thanks,

David

[lowcostweb]

Fine! Merci Beaucoup
Jean Marc

[SparkOut]

It works, but I would not personally say "nicely". Easily, yes, but it's really NOT a good idea. I would prefer to avoid a direct connection and use a middleware script on the server. That's more work and more learning, but will be safer - in security and robustness.

[DR White]

I still have the SQL table name, user name and password protection. That should be OK for a file that does not contain any personal info.

I keep hearing certain people talk about the need to use middle ware, instead of a wildcard.
So, how does one create the necessary middle ware, using LC and the LC server?

Thanks,

David

[ghettocottage]

There was a long thread about this last year: http://forums.livecode.com/viewtopic.ph ... middleware

Very informative, and a link to a blog-post where someone uses PHP