Have "Acces denied" to remote database by on-rev sql server!
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 6
- Joined: Wed Aug 20, 2014 2:41 pm
Have "Acces denied" to remote database by on-rev sql server!
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
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
Last edited by lowcostweb on Sat Jan 30, 2016 10:09 am, edited 1 time in total.
Re: Have "Acces denied" to remote stack by on-rev sql server
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
I am not familiar with using "%" for log in.
Could you explain how I need to use "%" to correct this error message?
Thanks,
David
Re: Have "Acces denied" to remote stack by on-rev sql server
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.
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.
Re: Have "Acces denied" to remote stack by on-rev sql server
SparkOut,
That worked nicely!
Thanks,
David
That worked nicely!
Thanks,
David
-
- Posts: 6
- Joined: Wed Aug 20, 2014 2:41 pm
Re: Have "Acces denied" to remote stack by on-rev sql server
Fine! Merci Beaucoup
Jean Marc
Jean Marc
Re: Have "Acces denied" to remote database by on-rev sql ser
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.
Re: Have "Acces denied" to remote database by on-rev sql ser
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
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
-
- Livecode Opensource Backer
- Posts: 366
- Joined: Tue Apr 10, 2012 9:18 am
Re: Have "Acces denied" to remote database by on-rev sql ser
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
Very informative, and a link to a blog-post where someone uses PHP