Hi Arun,

Since it is a modification of the schema, it will be on the next version 14.1.

As you can see there 
https://github.com/inverse-inc/packetfence/blob/maintenance/14.0/db/pf-schema-14.0.sql#L1108
 the schema is never modified after the release.

So not fixed in 14.0, fixed in 14.1 
(https://github.com/inverse-inc/packetfence/blob/devel/db/pf-schema-X.Y.sql#L1109).

Regards.

Jeremy Goimard
Senior Software Engineer

[signature_117474225]


Office: +1 613 670 8438

Akamai Technologies - Inverse
145 Broadway
Cambridge, MA 02142


Connect with Us:

[signature_1388875202]<https://community.akamai.com/> [signature_3364560605] 
<http://blogs.akamai.com/>  [signature_2499095976] <https://twitter.com/akamai> 
 [signature_3425345268] <http://www.facebook.com/AkamaiTechnologies>  
[signature_4082763092] <http://www.linkedin.com/company/akamai-technologies>  
[signature_1928680685] 
<http://www.youtube.com/user/akamaitechnologies?feature=results_main>


________________________________
From: Arun Kangle via PacketFence-users 
<packetfence-users@lists.sourceforge.net>
Sent: Wednesday, December 18, 2024 10:37:36 AM
To: Zammit, Ludovic
Cc: Arun Kangle; PacketFence-users
Subject: Re: [PacketFence-users] RADIUS Audit Logs are empty after migrating to 
14.0 from 13.2

Thank you very much Ludovic. It was issue no. 1. After updating the DB, I see 
logs appearing with the correct time stamp. (in fact i sent out different email 
asking about wrong timestamp, please ignore that email) Just curious, in the 
link provided,
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd
Thank you very much Ludovic. It was issue no. 1. After updating the DB, I see 
logs appearing with the correct time stamp. (in fact i sent out different email 
asking about wrong timestamp, please ignore that email)

Just curious, in the link provided, it says the bug is resolved but I ran into 
this bug on a fresh ZEN install of 14.0.

Thanks again,
- Arun

On Wed, Dec 18, 2024 at 1:48 AM Zammit, Ludovic 
<luza...@akamai.com<mailto:luza...@akamai.com>> wrote:
Hello Arun,

It could be two thing.

1) the date on the database is not correct.

https://github.com/inverse-inc/packetfence/issues/8314<https://urldefense.com/v3/__https://github.com/inverse-inc/packetfence/issues/8314__;!!GjvTz_vk!QZKE1JqYFpBkXsJ7y-hUx2mphWAx3QMfKOE1tMqfjZ0mRvcSMM_fM3RDwG2i85w05EraYN-I6GL8fhwYyR28GwIrakwNV46Ynj8HWw$>

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
[https://www.akamai.com/us/en/multimedia/images/custom/2019/logo-no-tag-93x45.png]

Cell: +1.613.670.8432
        Akamai Technologies - Inverse
145 Broadway
Cambridge, MA 02142


Connect with Us:        
[https://www.akamai.com/us/en/multimedia/images/custom/community.jpg] 
<https://community.akamai.com>  
[https://www.akamai.com/us/en/multimedia/images/custom/rss.png] 
<http://blogs.akamai.com>  
[https://www.akamai.com/us/en/multimedia/images/custom/twitter.png] 
<https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!QZKE1JqYFpBkXsJ7y-hUx2mphWAx3QMfKOE1tMqfjZ0mRvcSMM_fM3RDwG2i85w05EraYN-I6GL8fhwYyR28GwIrakwNV44H_QYsCg$>
  [https://www.akamai.com/us/en/multimedia/images/custom/fb.png] 
<https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!QZKE1JqYFpBkXsJ7y-hUx2mphWAx3QMfKOE1tMqfjZ0mRvcSMM_fM3RDwG2i85w05EraYN-I6GL8fhwYyR28GwIrakwNV46_NWGOyg$>
  [https://www.akamai.com/us/en/multimedia/images/custom/in.png] 
<https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!QZKE1JqYFpBkXsJ7y-hUx2mphWAx3QMfKOE1tMqfjZ0mRvcSMM_fM3RDwG2i85w05EraYN-I6GL8fhwYyR28GwIrakwNV47VayGz_Q$>
  [https://www.akamai.com/us/en/multimedia/images/custom/youtube.png] 
<https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!QZKE1JqYFpBkXsJ7y-hUx2mphWAx3QMfKOE1tMqfjZ0mRvcSMM_fM3RDwG2i85w05EraYN-I6GL8fhwYyR28GwIrakwNV45dc1aaVA$>

On Dec 11, 2024, at 2:12 AM, Arun Kangle via PacketFence-users 
<packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>>
 wrote:

This Message Is From an External Sender
This message came from outside your organization.
Hello All,
Does anyone have any info on this? Am I missing any patch? Please advise.

Thank in advance,
- Arun

On Mon, Dec 9, 2024 at 12:39 PM Arun Kangle 
<akan...@gmail.com<mailto:akan...@gmail.com>> wrote:
Hello All,
After migrating to 14.0, authentication are happening and nodes are getting 
updated properly but RADIUS Audit logs are empty.

Could someone please help?

Thanks in advance,
- Arun
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net<mailto:PacketFence-users@lists.sourceforge.net>
https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!Rokm-brDLsHf7DIwDa8hmmdZXyubfiAX-c3PkiddGNXC_Dr5RtffSzz8L9ZcyXDt4voBqzlgFjiXqYaBN53elm7xaJdZaiUzpRqu5Q$

_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to