This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

After HDD fill up on Node 2 variables messed up: "Successful WebAdmin login from $IP at $TIMESTAMP with username $USERNAME."

Hello!

Approximately one week after upgrading the PostgreSQL database to 64 Bit, we had a problem with Node2-passive (active/passive configuration) in HA.
Node2 coredumped continuously, filling up the Hard Disk with the fast-growing kernel-log (50+ Gigabyte). There was the risk that even Node1 would become completely full.


We cleaned the kernel-log and rebooted Node2 twice (didn't boot correctly at first try), and now everything seems to work correctly again.

The problem we see is, that some variables seem to be messed up, as you can see from the login notification:
"Successful WebAdmin login from $IP at $TIMESTAMP with username $USERNAME."
The variables are no longer replaced correctly.

I'm concerned that there might be a problem with the database in general.


Is there a way to repair/check this?

Best regards,
SA



This thread was automatically locked due to age.
Parents
  • I don't know that the following works with 64-bit files.  Be aware that you lose all history in Reporting, but it has no effect on logs.  It might also re-initialize your graphs.

    /etc/init.d/postgresql92 rebuild

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Thank you, Bob!

    After another restart of the full HA-System it seems to work flawlessly now. Just in case it is again messed up, we will try your suggestion to rebuild the Database!

    BR,

    SA

  • Thanks, Hanspeter, for the reminder that a reboot is the thing to try before doing anything that interrupts work or causes the loss of information.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Reply
  • Thanks, Hanspeter, for the reminder that a reboot is the thing to try before doing anything that interrupts work or causes the loss of information.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Children
No Data