Subject Re: [firebird-support] Ouch!
Author Mark Rotteveel
On 27-2-2015 21:47, JuuS JuuS@... [firebird-support] wrote:
> I've spent about 10 hours now trying to get firebird to work < don't
> hate me!>. I'm kubuntu 14.04 64 bit.

A suggestion: use a descriptive subject instead of "Ouch!", and refrain
from weird interjections like "<don't hate me!>". It is distracting.

> I followed directions from two sources, one using the sh script, the
> other using the ppa.
> sh method simply didn't work, firebird server wouldn't run.
> ppa method worked...sort of.
> following the instrunctions here:
> I was able to get the firebird server to run (yea!0). I continued to
> follow the instructions and opened isql-fb.
> I was able to use the connect command to view the example db.
> But...when I tried to create a test database it wouldn't work.
> In fact the ONLY THING I can do is use isql-fb to connect to the example
> database.
> NOTHING else works. gsec won't open the db to add new users. flamerobin
> also won't work (though it did allow me to add a user!).
> gsec gives this:
> cannot attach to password database
> unable to open database
> I think, "hmm, maybe I need to be the firebird user?" I try to su to
> firebird, it asks for a password. None of the passwords I've used (yes,
> I found my password in the etc branch, that's how I was able to at least
> connect) works.
> What is the firebird user password? Or is that not even the problem?

The firebird user has - afaik - no password and you can't log in, you
need to be a member of the firebird group (you may need to logout and
back in after adding yourself to the firebird group).

> I'm a lazarus user and in their listserv many people praise firebird for
> its easy install and use...after 10 hours I'm am perplexed and find the
> opposite.
> I'm testing db's and yesterday installed was a breeze.
> What am I running into here?

Depending on the exact way of connecting (ie if you didn't specify a
hostname (or localhost)), you are connecting to the database directly
(not through the Firebird server), meaning you yourself need to have
sufficient file-level access to the database.

If you don't want that, you should connect through the database server
(meaning you need to specify the hostname as part of the connection string).


Mark Rotteveel