Subject RE: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0
Author Marianne Castel - Titelive

Yes. They have all a Firebird 2.5.2 client library.

And before we went on Centos 7 for the server we were working on a debian server and at that time de mon$remote_address had a correct information.

 

De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Envoyé : jeudi 11 juin 2015 10:10
À : firebird-support@yahoogroups.com
Objet : Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0

 

 

> Thanks Steve for the information. I think we’ll try on a virtual machine
> the centOS versions with the different mode of firebird (classic,
> superserver, superclassic).
>
> To Thomas, yes that’s real remote connections from different remote
> servers (there is no local connections).

Ok, do they all use at least the Firebird 2.1 client library?

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

> *De :*firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> *Envoyé :* mercredi 10 juin 2015 08:32
> *À :* firebird-support@yahoogroups.com
> *Objet :* Re: [firebird-support] Re: Firebird 2.5.4 - CentOS -
> mon$remote_address 0.0.0.0
>
>
> > Hello ,
> >
> > So Dmitry suggested it , we have disabled IPV6 on our server CentOS 7
> (Firebird
> > 2.5.4 Classic server (I forgot to mention it in my first mail)).
>> By following the centos FAQ :
>>http://wiki.centos.org/FAQ/CentOS7#head-8984faf811faccca74c7bcdd74de7467f2fcd8ee
>> Rebooting the server.
> > But even after this modification the mon$remote_address is still giving
> > 0.0.0.0
> >
> > Any ideas are welcome.
>
> Is this a real remote connection from a remote client or an attachment
> locally on the server?
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com
>
> Professional Tools and Services for Firebird
> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>
>> Marianne
>>
>> De :firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>[mailto:firebird-support@yahoogroups.com]
>> Envoyé : lundi 8 juin 2015 12:47
>> À :firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com>
>> Objet : [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address
>> 0.0.0.0
>>
>>
>>
>> 08.06.2015 10:02, Marianne Castel wrote:
>>>
>>> We were working with Firebird 2.5.2 on Debian .At that time, in the
> >> monitoring table MON$ATTACHEMENTS I could see the IP address of the
> >> client connected to a database.
> >>
> >> Now our administrators have decided to work with CentOS and the last
> >> available packages thus Firebird 2.5.4, and now in the databases on
> >> that server in the table MON$ATTACHEMENTS table the field
> >> mon$remote_address always contains : 0.0.0.0
> >>
> >> May be that the server is different too (network connection?) …
> >>
> >> Any idea why the IP address is no more reported ? How could we have the
> >> IP address again in the monitoring table ?
> >
> > Interesting. One possible explanation can be found here:
>>
>>http://stackoverflow.com/questions/17220006/in-what-conditions-getpeername-returns-ipport-0-0-0-00
>>
>> Firebird 2.x does not support IPv6 and always listens on a AF_INET (i.e.
>> v4) socket, but maybe it could be related somehow.Have you tried to
> > disable IPv6 on the new server box?
> >
> > Dmitry
> >
> >
>
>
>
>