| Subject | RE: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 |
|---|---|
| Author | Marianne Castel - Titelive |
| Post date | 2015-06-09T07:56:39Z |
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.
Marianne
De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Envoyé : lundi 8 juin 2015 12:47
À : 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:
>Interesting. One possible explanation can be found here:
> 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 ?
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