cannot connect to localhost with Firebird 2.5 64-bit on CentOS 6.2

[hrefofficemanager]

Hi, This is regarding a new clean install of CentOS 6.2, 64-bit.

As root, I ran these 2 commands, without errors:

rpm -Uvh
http://download.fedora.redhat.com/pub/epel/6/i386/epel-release-6-5.noarch.rpm

yum install firebird firebird-superserver

Firewall port 3050 is open for tcp and udp.

Firebird did not start automatically. I tried

bin/fbsvcmgr -start

and

bin-superserver/fbsvcmgr -start

and both give the same error about not being able to connect to localhost.

ping 127.0.0.1 --> works
ping 192.168.x.x --> my router, works
ping 208.201.x.x --> public ip, works

My firebird.conf file has the service bound to the local ip, 192.168.x.14.

Questions:

1. What is the difference between bin/ and bin-superserver/ executables? I wanted to test superserver. Is bin/ the classic version?

2. Does anyone know what I should chase in order to make fbsvcmgr connect on localhost? Is there syntax that would let it connect on 192.168.x.14 instead of localhost? Is there any other way to start firebird server without using fbsvcmgr?

3. Is anyone here running Firebird 2.5 superserver on CentOS 6.2 ?

I'm not sure whether I did something wrong with the CentOS packages. I did NOT customize anything about EPEL package priority as advice on that point was too confusing.

I would greatly appreciate some advice on this one.

Thanks,

Ann

[Steve Wiser]

Post by hrefofficemanager
**
Hi, This is regarding a new clean install of CentOS 6.2, 64-bit.
rpm -Uvh
http://download.fedora.redhat.com/pub/epel/6/i386/epel-release-6-5.noarch.rpm
yum install firebird firebird-superserver
Firewall port 3050 is open for tcp and udp.
Firebird did not start automatically. I tried
bin/fbsvcmgr -start
and
bin-superserver/fbsvcmgr -start
and both give the same error about not being able to connect to localhost.
ping 127.0.0.1 --> works
ping 192.168.x.x --> my router, works
ping 208.201.x.x --> public ip, works
My firebird.conf file has the service bound to the local ip, 192.168.x.14.
1. What is the difference between bin/ and bin-superserver/ executables? I
wanted to test superserver. Is bin/ the classic version?
2. Does anyone know what I should chase in order to make fbsvcmgr connect
on localhost? Is there syntax that would let it connect on 192.168.x.14
instead of localhost? Is there any other way to start firebird server
without using fbsvcmgr?
3. Is anyone here running Firebird 2.5 superserver on CentOS 6.2 ?
I'm not sure whether I did something wrong with the CentOS packages. I did
NOT customize anything about EPEL package priority as advice on that point
was too confusing.
I would greatly appreciate some advice on this one.
Thanks,
Ann

We don't use the CentOS 6.x series yet and we aren't on 2.5... But, I
would suggest you check /etc/hosts and make sure you have an entry to
127.0.0.1 for localhost and more importantly an entry with your IP address
and hostname.

We have had issues where RedHat doesn't like to put in your hostname entry
but Firebird doesn't work properly without it.

-steve

--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139

www.specializedbusinesssoftware.com
www.docunym.com
[phone] - fax [phone]
Toll Free: [phone]


[Non-text portions of this message have been removed]

[hrefofficemanager]

I saw a note elsewhere about /etc/hosts so I did check it. It has several mentions of localhost but whether it is accurate - I am not sure.

My computer domain (during initial installation of CentOS) was fire12.xxxxx.com.

The /etc/hosts file has this:

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

Is that sufficient or should there be mention of fire12.xxxxx.com ?

THANK YOU.

-Ann

Post by Steve Wiser
We don't use the CentOS 6.x series yet and we aren't on 2.5... But, I
would suggest you check /etc/hosts and make sure you have an entry to
127.0.0.1 for localhost and more importantly an entry with your IP address
and hostname.
We have had issues where RedHat doesn't like to put in your hostname entry
but Firebird doesn't work properly without it.
-steve
--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139

[philippe makowski]

Post by hrefofficemanager
Hi, This is regarding a new clean install of CentOS 6.2, 64-bit.
rpm -Uvh

http://download.fedora.redhat.com/pub/epel/6/i386/epel-release-6-5.noarch.rpm

Post by hrefofficemanager
yum install firebird firebird-superserver
Firewall port 3050 is open for tcp and udp.
Firebird did not start automatically. I tried

yes that's a security reason and a RedHat rule
don't start service automaticaly after install

use as root :
/sbin/service firebird-superserver start

If you want to have firebird Superserver started at each boot, as root :
chkconfig --level 345 firebird-superserver on

Post by hrefofficemanager
bin/fbsvcmgr -start

bad

Post by hrefofficemanager
and
bin-superserver/fbsvcmgr -start

that's the same that bin/fbsvcmgr -start

Post by hrefofficemanager
1. What is the difference between bin/ and bin-superserver/

executables? I wanted to test superserver. Is bin/ the classic version?
symlinks see for example a ls -la /usr/bin/isql-fb

for classic you would have bin-classic and again with symlinks in bin/

[hrefofficemanager]

Thanks Philippe!

Post by philippe makowski
/sbin/service firebird-superserver start

WORKS to start the server. My next problems is that gsec does not like me. "Your username and password are not defined" -- yet I am using SYSDBA with the default password.

When I run this from / as root,

whereis security2

, no files are found.

Is that normal? Isn't security2.fdb the storage of the usernames?

Thank you also for explaining about the symbolic links - got it.

I will probably start the installation again from the beginning. At this point I have tried YUM, then the RPM files for AMD64 and x64, then deleted all the firebird files, then reinstalled with YUM. So I could believe that a file or two is mixed up.

I had some surprising messages when I tried the RPM files. I will post those in a separate thread.

-Ann

Post by philippe makowski

Post by hrefofficemanager
Hi, This is regarding a new clean install of CentOS 6.2, 64-bit.
rpm -Uvh

http://download.fedora.redhat.com/pub/epel/6/i386/epel-release-6-5.noarch.rpm

Post by hrefofficemanager
yum install firebird firebird-superserver
Firewall port 3050 is open for tcp and udp.
Firebird did not start automatically. I tried

yes that's a security reason and a RedHat rule
don't start service automaticaly after install
/sbin/service firebird-superserver start
chkconfig --level 345 firebird-superserver on

Post by hrefofficemanager
bin/fbsvcmgr -start

bad

Post by hrefofficemanager
and
bin-superserver/fbsvcmgr -start

that's the same that bin/fbsvcmgr -start

Post by hrefofficemanager
1. What is the difference between bin/ and bin-superserver/

executables? I wanted to test superserver. Is bin/ the classic version?
symlinks see for example a ls -la /usr/bin/isql-fb
for classic you would have bin-classic and again with symlinks in bin/

[Helen Borrie]

Post by hrefofficemanager
Thanks Philippe!

Post by philippe makowski
/sbin/service firebird-superserver start

WORKS to start the server. My next problems is that gsec does not like me. "Your username and password are not defined" -- yet I am using SYSDBA with the default password.
When I run this from / as root,
whereis security2
, no files are found.

security2.fdb. But that's not your problem...find the Firebird root directory, which is /opt/firebird in a regular POSIX installation but is probably buried a bit deeper in an EL installation.
With a "remote" connection (which is all you can do with SS on Linux) the connection protocol requires the -database parameter.

Suppose you find security2.fdb in /usr/firebird. Then, your gsec command (if from Firebird's /bin directory) would be

./gsec -database localhost:/usr/firebird/security2.fdb -user sysdba -password whatever
(note the dot-slash)

Or, if doing it the fully qualified way:

/usr/firebird/bin/gsec -database /usr/firebird/security2.fdb -user sysdba -password whatever

Note that root does not need to supply SYSDBA credentials: it has them already.
Also consider making a database alias for the security database!

./heLen

[hrefofficemanager]

Helen, Thank you for the extra details. I did end up doing a complete reinstall and there was no longer any issue with gsec. It is all working now.

Recap: CentOS 6.2 did not need anything extra in the /etc/hosts file as it turns out, at least not with the package choices that I made. My "problem" with localhost was caused by me trying to run "bin/fbsvcmgr -start" instead of starting the firebird superserver service from /sbin service...

-Ann

[hrefofficemanager]

The following URL has my notes about what DID WORK -- for anyone who stumbles upon this thread later and wants to do their own installation:

http://needs-be.blogspot.com/2011/01/centos-55-vsftpf-with-virtual-users.html

Cheers,
Ann

[hrefofficemanager]

The following URL has notes about what DID WORK and in the end, it was very simple:

http://needs-be.blogspot.com/2012/02/installing-firebird-25-64-bit-on-centos.html

Cheers,
Ann

[philippe makowski]

Post by hrefofficemanager
http://needs-be.blogspot.com/2012/02/installing-firebird-25-64-bit-on-centos.html

just two points about your notes :

- instead of creating /var/firebirddata
you can use /var/lib/firebird/data
that is already created by the package
and have firebird:firebird as owner

- you have gsec in /usr/bin/
so no need to put full path to use it
or use directly /usr/bin/gsec instead of /usr/lib64/firebird/bin
this way it will be always ok, even if you use 32 bits platform