Re: [PacketFence-users] radius accounting info not being mapped to users

Actually, the query called for the report is report_nodebandwidth_all_sql (see lib/pf/pfcmd/report.pm at line 364). SELECT radacct.callingstationid as callingstationid, SUM(radacct_log.acctinputoctets) AS acctinputoctets, SUM(radacct_log.acctoutputoctets) AS acctoutputoctets,

Re: [PacketFence-users] radius accounting info not being mapped to users

Hi Louis, One more thing I noticed is the following... The accounting.pm file is using these two queries: $accounting_statements->{'acct_view_sql'} = get_db_handle()->prepare(qq[ SELECT

Re: [PacketFence-users] local SQL vs wireless 802.1x EAP mschav2

Perfect. Thank you for your time and answers. S pozdravem Martin Kylián 20. 7. 2017 v 16:34, Louis Munro via PacketFence-users >: On Jul 20, 2017, at 10:16, LE GALL Yohann via PacketFence-users

Re: [PacketFence-users] local SQL vs wireless 802.1x EAP mschav2

> On Jul 20, 2017, at 10:16, LE GALL Yohann via PacketFence-users > wrote: > > Unfortunately passwords aren't encrypted... Nothing prevents you from hashing the string before inserting it. Regards, -- Louis Munro lmu...@inverse.ca

Re: [PacketFence-users] local SQL vs wireless 802.1x EAP mschav2

Hi, To create users in the local DataBase of PF, you have to use 2 sql requests. The first, create a person and the second create the associated password and rules. Their is 2 importants tables about users named person and password. This is an example about how I'm actually using them :

Re: [PacketFence-users] local SQL vs wireless 802.1x EAP mschav2

> On Jul 20, 2017, at 09:49, Kylián Martin via PacketFence-users > wrote: > > Does anyone use a custom application to create users in local SQL? > I would like to make a portal where Single SignON for domain users will work > - here they set their

Re: [PacketFence-users] local SQL vs wireless 802.1x EAP mschav2

Thank you for quick reply. Does anyone use a custom application to create users in local SQL? I would like to make a portal where Single SignON for domain users will work - here they set their wifi password and the portal stores the password + username and other attributes in local SQL. (Not as

Re: [PacketFence-users] local SQL vs wireless 802.1x EAP mschav2

> On Jul 20, 2017, at 09:10, Kylián Martin via PacketFence-users > wrote: > > Hi everyone, > > I would like to use packetfence for 802.1x PEAP / EAP-MSchapv2 wireless > authentication. (And other features) > But I do not want to use the AD binding

[PacketFence-users] local SQL vs wireless 802.1x EAP mschav2

Hi everyone, I would like to use packetfence for 802.1x PEAP / EAP-MSchapv2 wireless authentication. (And other features) But I do not want to use the AD binding (as it is now). For security reasons, I want to use local SQL and authenticate users there. (Can I insert users to local sql with my

Re: [PacketFence-users] radius accounting info not being mapped to users

Hi Louis, Yes, the radacct table also has data. I just noticed though that on my httpd.admin.error log file the following is being logged each time I try to access the graph. Jul 19 23:00:38 PacketFence-ZEN httpd_admin_err: [Wed Jul 19 23:00:38 2017] -e: Argument "" isn't numeric in numeric gt

[PacketFence-users] Portal Personalization

Hi community, I'm currently configuring my packetfence's infrastructure for a Guest access. I'm french and all my Guest will be french, so I'm modifying the html template for that. I found all css and texts files except one text which is : « Role guest has been assigned to your device with

[PacketFence-users] Packetfence-ZEN-7.2.0 bandwidth violation not working

Hi All I have upgraded Packetfence-6.5.1 to Packetfence-7.2.0 and bandwidth violation of 100MB/Day stop working. Nothing happens when a client uses more than 100MB traffic. Regards Emmanuel DISCLAIMER -- NOTE: This e-mail message is subject to the University of Ghana email

Re: [PacketFence-users] email registration always remains status "incomplete"

On 07/17/2017 04:53 PM, lists via PacketFence-users wrote: Hi Fabrice, list, On 13-7-2017 2:23, Durand fabrice via PacketFence-users wrote: when it happen, can you check in the database just after the duration has been extended ? select * from node where mac="9c:2a:70:31:9b:9f'; ok, here