Afternoon all,

this thread just keeps getting more and more interesting!

On 01/04/11 20:16, Helen Borrie wrote:

> root bypasses authentication and connects with SYSDBA privileges to everything.

That's what I though had happened originally - especially as I've
written about it in one or other of the manuals - but when I tested it,
I found this:

tux> su -
password: ***********

tux> id
uid=0(root) gid=0(root) groups=0(root)

tux> export PATH=$PATH:/opt/firebird/bin

tux> gbak -Z employee ./employee.fbk
gbak:gbak version LI-V2.5.0.26074 Firebird 2.5
gbak: ERROR:Your user name and password are not defined. Ask your
database administrator to set up a Firebird login.
gbak:Exiting before completion due to errors

This is on OpenSuse 11.2 64 bit. I've logged in as me, and switched into
root. Ok, maybe I need to login as root .....

Exactly the same again, even when directly logged in as root, I get
prompted for a username and password.

Ok, Centos 5 is Red Hat 5 is Oracle Enterprise Linux 5, and I use OEL
for work, so Firebird 2.5 on OEL here I come...

[root@penguin ~]# rpm -ivh
/media/downloads/Firebird/2.5/FirebirdSS-2.5.0.26074-0.amd64.rpm
Preparing... ###########################################
[100%]
1:FirebirdSS ###########################################
[100%]
Updated /etc/services
Starting Firebird server [default] [ OK ]

[root@penguin ~]# id
uid=0(root) gid=0(root)
groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

[root@penguin ~]# export PATH=$PATH:/opt/firebird/bin

[root@penguin ~]# gbak -Z employee ./employee.bak
gbak:gbak version LI-V2.5.0.26074 Firebird 2.5
gbak: ERROR:Your user name and password are not defined. Ask your
database administrator to set up a Firebird login.
gbak:Exiting before completion due to errors

Hmmm. Something strange here? This Firebird install was carried out
using the downloaded RPM for Firebird 2.5 :
/FirebirdSS-2.5.0.26074-0.amd64.rpm - which is the same one I have
installed on OpenSuse and was obtained from the downloads link on
Firebirdsql.org.

Even running isql as root asks for a username and password at version 2.5.

Puzzled!


Cheers,
Norman.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767