New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
"Firebird User" on OSX considered harmful [CORE3871] #4209
Comments
Commented by: @paulbeach Not true. What happened in this case is that your initial access to the database was via a local connection with a user that was not part of the firebird group. As such the ownership of the lock files etc defaulted to this user. In future either connect initially using either localhost or the host name first or make sure that any user who connects to firebird directly is part of the Firebird group. |
Commented by: Maury Markowitz (maury.markowitz_gmail.com) I am not sure about what the comment is saying, but here is the connections string used in this case: localhost:/Library/Frameworks/Firebird.framework/Resources/examples/empbuild/employee.fdb Is this not matching "either localhost or the host name first"? |
Commented by: @paulbeach There are essentially two ways to acess a firebird database, via the remote access method using either the host name, IP address or localhost, and you can also access Firebird using the embedded method by just specifying the local database name on disk. |
Commented by: Maury Markowitz (maury.markowitz_gmail.com) I remain confused. Let me describe exactly the steps I followed that caused this error to occur, and maybe you can point out where the problem came in. 1) I installed FB on my Mac under my (the only) account wait... a) I svn'ed the latest version of ODBCQueryTool and re-tested a bug in the ODBC side I've been trying to solve. I can see how the numbered steps led to the problem, but I don't believe the lettered series should have caused it again. Nothing else changed between these runs, they were literally seconds apart. |
Commented by: @paulbeach Give me a simple reproducable test case or try the support list. At the moment I don't see how this can be a bug. |
Submitted by: Maury Markowitz (maury.markowitz_gmail.com)
Installing using the Mac installer uses a new userid for all file ownership and permissions that makes the system unusable out of the box.
1) the permissions/ownership on /tmp/firebird are set such that the system is in an unusable state:
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird
The directory must be deleted by hand in terminal.
2) the permissions/ownership of everything else likewise leaves the system in an unusable state:
Statement failed, SQLSTATE = 28000
no permission for read-write access to database /Library/Frameworks/Firebird.framework/Versions/A/Resources/examples/empbuild/employee.fdb
The user must chown or set permissions for everyone read/write to get even the example DB to work.
The text was updated successfully, but these errors were encountered: