[Lazarus] Permission denied error with Firebird SS on OSX

[Giuseppe Luigi Punzi Ruiz]

Seriously, I can't understand. I'm sure is something silly I can't  
see, but.............

galilea:testfb glpunzi$ ls -all /Library/Frameworks/Firebird.framework/ 
Versions/Current/Resources/examples/empbuild/
total 2120
drwxr-xr-x   3 firebird  firebird      102  4 jun  2008 .
drwxr-xr-x  10 firebird  firebird      340  4 jun  2008 ..
-rw-r--r--   1 firebird  firebird  1085440  2 abr 21:03 employee.fdb
galilea:testfb glpunzi$

And I can open 'employee' from Flamerobin and from Lazarus without  
problems.

under a folder on my Documents User folder.

galilea:testfb glpunzi$ ls -all
total 1360
drwxr-xr-x   3 glpunzi   staff        102  2 abr 20:48 .
drwx------+ 37 glpunzi   staff       1258  2 abr 21:01 ..
-rw-rw----   1 firebird  firebird  696320  2 abr 20:55 test.fdb

I created this DB from isql with my user. once created, with some data  
(and after see I can't connect to it) I did:
sudo chown -R firebird:firebird test.fdb

And still without connection to it. From lazarus, flamerobin and isql,  
the same error.
 From isql:
Statement failed, SQLCODE = -902
I/O error for file "test.fdb"
-Error while trying to open file
-Permission denied

from flamerobin: http://img183.imageshack.us/img183/4519/flamerobinscreensnapz00.png

If I revert the chown to:
sudo chown -R glpunzi test.fdb

Then, isql works, but still without connceting flamerobin or Lazarus.

Some idea?

Cheers.



El 02/04/2009, a las 16:54, Graeme Geldenhuys escribió:

> On Thu, Apr 2, 2009 at 4:08 PM, Giuseppe Luigi Punzi
> <glpunzi at lordzealon.com> wrote:
>> I'm starting some projects, and I will develop them from OSX and
>> Windows. On windows, seems all ok, but from OSX I'm getting some
>> troubles thath stops me now.
>
> It's because Windows has crappy security. :-)
>
>> Now, I can't open any database from Lazarus/SQLdb nor Flamerobin,
>> getting an error about 'Permission Denied'.
>
> In Firebird config file (/etc/firebird/2.0/firebird.conf under Linux)
> you can setup what directories are allow do have database in. By
> default I think not all directories are allowed. It's the
> "DatabaseAccess" setting.
>
> Also you need to be sure about your User and Group access writes to
> the database file (*.fdb) itself and the write access to the directory
> containing the *.fdb files.
>
>> I'm missing something? Is better to install Classic Server instead
>> SuperServer? If so, is enough deleting Firebird.Framework directory?
>
> Your problem has nothing to do with Classic vs Super Server installs.
> It's a permission issue - that's all.
>
>
> Regards,
>  - Graeme -
>
>
> _______________________________________________
> fpGUI - a cross-platform Free Pascal GUI toolkit
> http://opensoft.homeip.net/fpgui/
> _______________________________________________
> Lazarus mailing list
> Lazarus at lazarus.freepascal.org
> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20090402/e49a4e9c/attachment-0007.html>