Several different users need to run the commands. There can be as many as 3 users on a system and they each have several databases in their own directory off of their home directory. None of them are firebird and I do not want all of them to be logging in as root.
[email protected] wrote: > Did you change the owner of the firebird database file and it's directory to > the firebird user? Are you running these commands as the firebird user or as > root? > Sent via my BlackBerry from Vodacom - let your email find you! > > -----Original Message----- > From: "lyotchik" <[email protected]> > Sender: [email protected] > Date: Sat, 07 Jul 2012 18:59:18 > To: <[email protected]> > Reply-To: [email protected] > Subject: [firebird-support] Permission denied with qli and isql > > I am trying to convert from IB 6 on Unix to FB 2.1 on Ubuntu Linux. I > have used IB since version 3.1 on a variety of different platforms. > >>From what I understand this should be easy. However, I cannot even ready a >>database using qli or isql using FB. The system is located in a secure >>environment with absolutely no Internet access. There are several users on >>the system and they all have a number of databases which they own. FB seems >>to need a firebird user. I do not know why that users is required but it has >>been created. Any attempt to restore a gbak using any user but root fails >>with "Permission denied". The directory into which I tried to restore the >>database has permission of 777. Anybody can do anything. I was able to >>restore a database using something called flamerobin. But the user (who >>should also have unlimited access to the database) cannot access it using >>gbak, qli or isql. It does not seem to matter who owns the database file, the >>owner or firebird. It also does not seem to matter what the permissions on >>the database are. > > How can this ridiculous security (I our installation) be turned off so the > normal Linux users can access their databases without permission problems? I > would prefer not having everyone log into the system as root. > > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > >
