Connecting Rev stack to On-Rev mySQL DB?

[Andre Garzia]

John,

check the allowed hosts on your control panel, add the % wildcard there.

Cheers
andre
PS: Power grid failure over here, working on batts, sorry for the hushed
reply

On Thu, Mar 25, 2010 at 5:53 PM, John Patten <johnpatten at mac.com> wrote:

> Hi All...
>
> My Developer Conference 2009 DVDs arrived yesterday and I listened to Devin
> do his presentations on connecting rev to an on-rev mysql db. He made it
> look so easy, I thought I'd give it a try!
>
>
> My attempts are failing with the error: "Access denied for user
> 'jpatten_elearn'@'216.64.xxx.xx' (using password: YES)"
>
> I'm behind a firewall, however anything that we initiate from inside is
> allowed. I pretty much used Devin's example straight from the DVD,
>
>  put "mysql" into tType
>   put "jpatten.on-rev.com" into tHost
>   put "jpatten_theDB" into tDB
>   put "jpatten_elearn" into tUser
>   put "theDBuser_passwd" into tPass
>   put revOpenDatabase(tType,tHost,tDB,tUser,tPass) into tConnID
>   put tConnID
>
>
>
>
> But instead of getting what I would think would be a connection ID, I get
> the access denied error.
>
>
> I will try from home tonight to see if it works from outside my school
> network, but was also curious if anybody had a suggestions? ...Have a stack
> you can share that connects to a mySQL db on the web I can test?
>
>
> Thank you!
>
> John Patten
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.andregarzia.com All We Do Is Code.