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 : firstname.lastname@example.org [mailto:email@example.com] Envoyé : jeudi 11 juin 2015 10:10 À : firstname.lastname@example.org 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 :*email@example.com > [mailto:firstname.lastname@example.org] > *Envoyé :* mercredi 10 juin 2015 08:32 > *À :* > email@example.com<mailto:firstname.lastname@example.org> > *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 :email@example.com > <mailto:firstname.lastname@example.org>[mailto:email@example.com] >> Envoyé : lundi 8 juin 2015 12:47 >> À :firstname.lastname@example.org <mailto:email@example.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 > > > > > > > >