[SOLVED]Firebird error in Mac 10.6.8

[IndianaJones]

Hi all,
Have someone experienced with firebird database with Mac OS X? Cos it bumps the attached error. I tested with the following code in Windows 7 and works fine. Any advice will be appreciated. Thanks.

      IBConnection1.HostName:='localhost';
      IBConnection1.DatabaseName:= GetCurrentDir+PathDelim+'exampledb.fdb';
      IBConnection1.UserName:= 'SYSDBA';
      IBConnection1.Password:= 'masterkey';
      IBConnection1.CharSet:= 'UTF8';
      IBConnection1.Dialect:= 3;

      SQLTransaction1.Active:=False;
      IBConnection1.Transaction:=SQLTransaction1;
      IBConnection1.CreateDB;

[anis2505]

Hi,

I have no experience with Mac but as I can see it's not firebird problem but it's the system you don't have permission on the destination folder.

Anyway I guess if you run the executable file as administrator everything will be working just fine.

regards

[IndianaJones]

Thanks anis2505 for the reply. Yes you are right, it is related with permission problem but it is nonsense cos the directory permission already 755 (rwxr_xr_x) and I cant write to the directory except when I change to chmod 757, i can.
Isnt it silly?

[anis2505]

Thanks anis2505 for the reply. Yes you are right, it is related with permission problem but it is nonsense cos the directory permission already 755 (rwxr_xr_x) and I cant write to the directory except when I change to chmod 757, i can.
Isnt it silly?

Well I don't know. I guess The system is considering the firebird connecting via network as 'other user' maybe try set the IBConnection hostname to localhost.

regards

[BigChimp]

What user does the Firebird server run under? A separate Firebird user? That may explain the permission problems.

Don't use OSX much, and haven't used it with Firebird in anger yet.

[IndianaJones]

@BigChimp

What user does the Firebird server run under? A separate Firebird user? That may explain the permission problems.

The Firebird server run under indiana:staff. The directory belongs to indiana:staff. But database user is sysdba. If I am wrong correct me, adding another database user as (indiana) doesnt solve the problem.
Regards.

[BigChimp]

I assume you mean the user on the database server is sysdba (it's the default Firebird admin user).
A user on the Firebird server is a different concept than an operating system user.

The Firebird server software itself is started under a certain user account as well (could be root, or indiana, or perhaps a new user firebird set up by the installer).

When Firebird is running, a command like ps aux | grep -i firebird should show under which operating system user Firebird is running.

[IndianaJones]

To clarify the case, the server process belongs to the firebird user in mac and also other unixes. I did some googling and find the result, changing the owner of the directory to firebird overcome the problem.
Or adding the user to the firebird group.
Thanks.