|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.
Ok, do they all use at least the Firebird 2.1 client library?
> 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).
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> *De :*firstname.lastname@example.org
> *Envoyé :* mercredi 10 juin 2015 08:32
> *À :* email@example.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
> > 2.5.4 Classic server (I forgot to mention it in my first mail)).
>> By following the centos FAQ :
>> 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
> Professional Tools and Services for Firebird
> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>> De :firstname.lastname@example.org
>> Envoyé : lundi 8 juin 2015 12:47
>> À :email@example.com <mailto:firstname.lastname@example.org>
>> Objet : [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address
>> 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:
>> 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