multi-user access of DB fails in 2.5.1 CS
-----------------------------------------
Key: CORE-3824
URL: http://tracker.firebirdsql.org/browse/CORE-3824
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1
Environment: Linux - (Fedora 16 not important, nor is hardware in this
case)
Reporter: Ray Holme
Priority: Critical
I access the DB as myself (ray) and tomcat - with 4 tomcat web applications -
each using a separate gsec login name.
DBs each have their own list of user/password combinations in a table - with
the one allowed gsec user as the only one who logs into the DB and privilege
control meted out by the DB table user's permissions.
The first user (ray or one of the four application logins) works just fine. A
new directory (firebird) and one or more files is created in /tmp (new to
2.5.xxx). However the other web "users" and/or myself cannot access anything as
the permissions for the named tmp directory and files are exclusive to the
first user who did a DB operation.
I CAN (as root) change the permissions and things work for a short time, but
the permissions revert pretty quickly to the original exclusive single-user
mentality (how or why eludes me right now).
I reverted to 2.1.4 which is the most working release for me.
While I like the idea of handling permissions using file tokens in /tmp appears
better than /opt/firebird/isc.... files (which I used to give 666 permissions
to allow all to do things as they once did in the VERY old Unix Interbase
versions), this new form of access control is not working for me at all in the
Linux/Unix environment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
