Subject RE: Failing to run gsec as sysdba
Author Renuka Manavalan

 

 

From: Renuka Manavalan
Sent: Thursday, February 18, 2016 2:33 PM
To: 'firebird-support-subscribe@yahoogroups.com'
Subject: RE: Failing to run gsec as sysdba

 

Thanks to everyone, for the moral support that there is someone out there to help!

 

I managed to solve it. Apparently masterkey is not the installed password. Got the installed password from  "SYSDBA.password" file. Reading the "./bin/changeRunUser.sh" helped me.

 

Thank you,

Renuka

 

From: Renuka Manavalan
Sent: Thursday, February 18, 2016 2:10 PM
To: 'firebird-support-subscribe@yahoogroups.com'
Subject: Failing to run gsec as sysdba

 

Hi all,

 

First my thanks to your time and effort to help me out. Very much appreciated. Once I am good at this, I will try to return the favor by becoming a support volunteer.

 

Here is state:

1)      Installed Firebird firebird 2.5.5 (proof: lib/libfbclient.so.2.5.5).

2)      On CentOS: Linux version 2.6.32-573.18.1.el6.x86_64

3)      The servers are running

[root@64CentOS-65-1 firebird]#  top -b -n1 | grep fb

2525 firebird  20   0  4732  788  536 S  0.0  0.1   0:00.00 fbguard

2527 firebird  20   0 66428 5416 3904 S  0.0  0.5   0:00.13 fbserver

[root@64CentOS-65-1 firebird]#

 

[root@64CentOS-65-1 firebird]# netstat -an |grep 3050

tcp        0      0 0.0.0.0:3050                0.0.0.0:*                   LISTEN

 

 

 

Problem:

    Running as root user “gsec –user sysdba –pass masterkey –display” fails with message

use gsec -? to get help

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

unable to open database

 

More details:

Tried many flavors with no luck. All my trials are copy/paste here, for your reference.

 

Attempt 1:

[root@64CentOS-65-1 firebird]# bin/gsec

use gsec -? to get help

Cannot attach to services manager

user name and password are required while attaching to the services manager

unable to open database

 

Attempt 2:

[root@64CentOS-65-1 firebird]# bin/gsec -user sysdba -pass masterkey -display

use gsec -? to get help

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

unable to open database

 

Attempt 2:

[root@64CentOS-65-1 firebird]# bin/gsec -user SYSDBA -password masterkey -display

use gsec -? to get help

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

unable to open database

 

Attempt 2:

[root@64CentOS-65-1 firebird]# bin/gsec -database ./security2.fdb -user SYSDBA -password masterkey -display

use gsec -? to get help

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

unable to open database

 

Other attempts with same error message

 

bin/gsec -database /opt/firebird/security2.fdb -user SYSDBA -password masterkey –display

bin/gsec -database localhost:/opt/firebird/security2.fdb -user SYSDBA -password masterkey –display

 

Any help is very much appreciated.

 

Thank you,

Renuka