|Subject||RE: [firebird-support] MON$ATTACHMENTS.MON$REMOTE_ADDRESS showing as 0.0.0.0 in FIREBIRD 2.5.4 on CENTOS 7|
I guess this is not a common problem, but I believe I was able to resolve this issue.
I am posting my resolution incase others are encountering the same problem.
CentOS 7 now uses systemd instead of init, I had to look at the corresponding configuration files for firebird. The systemd configuration files for firebird, firebird-classic@.service & firebird-classic.socket are located in /usr/lib/systemd/system.
Description=Firebird Classic Activation Socket
I changed the ListenStream to
and restarted the service and now firebird is listening on 0.0.0.0:3050 and not :::3050, which means it is listening on IPV4 protocol.
I was able to verify that the REMOTE IP ADDRESS is returning correctly on the MON$ATTACHMENTS table.