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

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
lowcostweb
Posts: 6
Joined: Wed Aug 20, 2014 2:41 pm

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

Post by lowcostweb » Thu Jan 21, 2016 11:23 am

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
Last edited by lowcostweb on Sat Jan 30, 2016 10:09 am, edited 1 time in total.

DR White
Posts: 516
Joined: Fri Aug 23, 2013 12:29 pm
Location: Virginia, USA

Re: Have "Acces denied" to remote stack by on-rev sql server

Post by DR White » Fri Jan 29, 2016 11:33 pm

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
Posts: 2260
Joined: Sun Sep 23, 2007 4:58 pm

Re: Have "Acces denied" to remote stack by on-rev sql server

Post by SparkOut » Fri Jan 29, 2016 11:58 pm

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
Posts: 516
Joined: Fri Aug 23, 2013 12:29 pm
Location: Virginia, USA

Re: Have "Acces denied" to remote stack by on-rev sql server

Post by DR White » Sat Jan 30, 2016 1:08 am

SparkOut,

That worked nicely!

Thanks,

David

lowcostweb
Posts: 6
Joined: Wed Aug 20, 2014 2:41 pm

Re: Have "Acces denied" to remote stack by on-rev sql server

Post by lowcostweb » Sat Jan 30, 2016 10:08 am

Fine! Merci Beaucoup
Jean Marc

SparkOut
Posts: 2260
Joined: Sun Sep 23, 2007 4:58 pm

Re: Have "Acces denied" to remote database by on-rev sql ser

Post by SparkOut » Sat Jan 30, 2016 11:19 am

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
Posts: 516
Joined: Fri Aug 23, 2013 12:29 pm
Location: Virginia, USA

Re: Have "Acces denied" to remote database by on-rev sql ser

Post by DR White » Mon Feb 01, 2016 6:39 pm

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
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 343
Joined: Tue Apr 10, 2012 9:18 am

Re: Have "Acces denied" to remote database by on-rev sql ser

Post by ghettocottage » Mon Feb 01, 2016 7:37 pm

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

Post Reply

Return to “Databases”