connecting to db on-rev.com

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
emmefisch
Posts: 27
Joined: Thu Jul 23, 2009 2:50 am

connecting to db on-rev.com

Post by emmefisch » Sun Sep 21, 2014 4:47 pm

Hi

When I connect to my db on the server on-rev.com I get this error: unable to connect to the database: Unknown MySQL server host "frediger.on-rev.com"
All my parameters in revOpenDatabase are correct. Where is the problem? Any Idea?

put revOpenDatabase("mysql", "frediger.on-rev.com", "xxxxxx", "xxxxxx", "xxxxxx") into tResult

if tResult is a number then
put tResult into gConnectionID
answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID
else
put empty into gConnectionID
answer error "Unable to connect to the database: " & cr & tResult
end if

Klaus
Posts: 14191
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: connecting to db on-rev.com

Post by Klaus » Sun Sep 21, 2014 5:13 pm

Grüezi Fredi,

I xxxx-ed out the database name, your username and password! 8)

No idea, just guessing, but maybe you need to add "www.frediger.on-rev.com"?
Modern internet browsers may be smarter than revdb and do NOT need this :D


Best

Klaus

emmefisch
Posts: 27
Joined: Thu Jul 23, 2009 2:50 am

Re: connecting to db on-rev.com

Post by emmefisch » Sun Sep 21, 2014 7:57 pm

Grüezi Klaus
and thank you for the xxx ;-).

It is the server from runrev and it is exact the code from the example - but it does not function....

Simon
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3901
Joined: Sat Mar 24, 2007 2:54 am

Re: connecting to db on-rev.com

Post by Simon » Sun Sep 21, 2014 8:19 pm

Hi emmefisch,
In your cPanel there is also a security setting in Remote MySql (Remote Database Access Hosts) make sure you have allowed your or everybody's (%) domain access.

Simon
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!

emmefisch
Posts: 27
Joined: Thu Jul 23, 2009 2:50 am

Re: connecting to db on-rev.com

Post by emmefisch » Tue Sep 23, 2014 5:21 am

Hi Simon
Thank you - i added % in the host list. But the error message is still the same...

emmefisch
Posts: 27
Joined: Thu Jul 23, 2009 2:50 am

Re: connecting to db on-rev.com

Post by emmefisch » Tue Sep 23, 2014 5:31 am

Oooops, I have written my databaseaddress false - sorry! Now I get this error-message:
Unable to connect to the database: access denied for user xxx@% to database xxxx
the username and databasename ar correct ;-)
in the access host list i added %

Simon
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3901
Joined: Sat Mar 24, 2007 2:54 am

Re: connecting to db on-rev.com

Post by Simon » Tue Sep 23, 2014 5:44 am

Hi emmefisch,
Sorry, but this goes beyond liveCode.
I can tell you that I can successfully connect to MySQL via liveCode on on-rev.com.

I've just changed my UserName to something incorrect and I get the error message you see.
Double check your Database Name and Privileged User from cPanel MySQL Databases.

Simon
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!

emmefisch
Posts: 27
Joined: Thu Jul 23, 2009 2:50 am

Re: connecting to db on-rev.com

Post by emmefisch » Tue Sep 23, 2014 6:15 am

Hi Simon

Thank you for your help - i have found now the error (my error) ;-) I have forgotten to define the access-rights for the user. Now it does function. Thanx.

Regards, Fredi

Post Reply