Hello Ludovic,

First of all, thank you for your support.

I followed the 2 instructions you gave.
Unfortunately, none of the  2 workarounds solved the issue .
So the problem is still there.

1) In mysql:

MariaDB [niagarafalls]> ALTER TABLE radius_audit_log MODIFY created_at
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
Query OK, 0 rows affected (0,014 sec)
Records: 0  Duplicates: 0  Warnings: 0

2) Redis cache issue:

Clear the cache with:

redis-cli -p 6379

FLUSHALL
exit

redis-cli -p 6380

FLUSHALL
exit

I  appreciate any help you can give me.

Best Regards
Mickael BOUBALA

Le ven. 28 févr. 2025 à 15:10, Arun Kangle <akan...@gmail.com> a écrit :

> Hi Mickael,
> I faced the same issue when i upgraded to 14.0 from 13.2. Try below,
> option 1 worked for me:
>
> ---------- Forwarded message ---------
> From: Zammit, Ludovic <luza...@akamai.com>
> Date: Wed, Dec 18, 2024 at 1:48 AM
> Subject: Re: [PacketFence-users] RADIUS Audit Logs are empty after
> migrating to 14.0 from 13.2
> To: PacketFence-users <packetfence-users@lists.sourceforge.net>
> Cc: Arun Kangle <akan...@gmail.com>
>
>
> Hello Arun,
>
> It could be two thing.
>
> 1) the date on the database is not correct.
>
> https://github.com/inverse-inc/packetfence/issues/8314
>
> In mysql:
>
> ALTER TABLE radius_audit_log MODIFY created_at TIMESTAMP NOT NULL DEFAULT 
> CURRENT_TIMESTAMP;
>
>
> 2) Redis cache issue:
>
> Clear the cache with:
>
> redis-cli -p 6379
>
> FLUSHALL
> exit
>
> redis-cli -p 6380
>
> FLUSHALL
> exit
>
> /usr/local/pf/pfcmd service pf restart
>
> *Ludovic Zammit*
> *Product Support Engineer Principal Lead*
>
>
> On Fri, Feb 28, 2025 at 7:17 PM Mickael BOUBALA via PacketFence-users <
> packetfence-users@lists.sourceforge.net> wrote:
>
>> Helo,
>>
>> 1/ after upgrading from Packetfence 13.2 to 14.1 using the Upgrade-Guide
>> (17. Upgrading from a version prior to 14.1.0)
>> The RADIUS auditing module stopped displaying live RADIUS Log.
>> This issue occurs randomly after a  period of no using the PacketFence
>> web admin interface.
>> The period coulbe 30 minutes, 1 hour or maybe 2 hours without using the
>> web admin interface.
>>
>> 2/ But I can  still seing full list of log files  when using Audit → Live
>> logs menu in web admin.
>>
>> 3/ Also,the RADIUS auditing module is displaying live RADIUS Logs again
>> after I made a restart of pf service (/usr/local/pf/bin/pfcmd service pf
>> restart).
>>
>> I  appreciate any help
>>
>> Best Regards
>> Mickael BOUBALA
>> _______________________________________________
>> PacketFence-users mailing list
>> PacketFence-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>
>
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to