Subject | RE: Failing to run gsec as sysdba |
---|---|
Author | Renuka Manavalan |
Post date | 2016-02-18T22:34:56Z |
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