[SOLVED]Firebird error in Mac 10.6.8
lazarus / 16-Databases

----------------------------------------------------------------------
IndianaJones · 2012-11-20 16:15

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 · 2012-11-20 16:22

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 · 2012-11-20 17:00

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 · 2012-11-20 17:53

Quote from: IndianaJones on November 20, 2012, 06:00:20 pm
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 · 2012-11-20 18:45

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 · 2012-11-20 19:23

@BigChimp
QuoteWhat 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 · 2012-11-21 08:24

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 · 2012-11-24 12:34

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.