Rev and MySQL under MacOSX

Jo ë l Guillod joel.guillod at net2000.ch
Fri Nov 21 06:27:09 CST 2003


Thanks Gordon! You gave me some clues.

For those who will encounter the same problem here is the fix:

When building the standalone for MacOSX, Revolution create a folder
containing 3 elements: the application bundle folder (with application name)
and two folders "database_drivers" and "revdb.bundle". Inside the
"database_drivers" there is a subfolder named "MacOSX" with no permission
for group and others, then you have to change the permission for both to
"read". This is my fix!

Dont ask me why Revolution create such a folder with such permission
settings but now it works fine for any user!

Of course if anybody knows how to create a MacOSX standalone without 3
different folders that a user can inadvertantly trash or move... please
explain.


> Hi Joel,
> 
> I'm just getting started with RR and MySQL myself; however, about
> this...
> 
> 
> On Nov 19, 2003, at 7:18 AM, Joël Guillod wrote:
> 
>> Could anyone help me in this issue? I have developed an application
>> with
>> Revolution and MySQL and all works fine. But when the application is
>> launched on the same machine under MacOSX by a user logged without
>> administrative rights, the application is not able to connect to the
>> MySQL
>> DBMS. Any idea? How did you deploy your Rev-MySQL standalone?
> 
> Here is a test for you to try.  On the same machine where you are
> having problems, try connecting to your database using the same user
> information as your RR app uses, but do it from the command line.
> 
> For example:
> 
> mysql --user=xxx --password=yyy --database=zzz
> 
> This assumes that the mysql command is  in your path.  The normal
> installer on osx puts it in:
> 
> /usr/local/mysql/bin
> 
> (well it puts in in /usr/local/... whatever, but creates a symbolic
> link at /usr/local/mysql)
> 
> So you may have to do this:
> 
> /usr/local/mysql/bin/mysql ....
> 
> 
> But try that.  If you can access it ok then there is a problem with
> your RR app.  But I suspect you will find that you have not granted the
> user rights to access the database.
> 
> --gordon



More information about the use-livecode mailing list