Re: [PacketFence-users] Bandwidth statistics make no sense (Cisco 2960x)

2017-11-15 Thread Fabrice Durand via PacketFence-users 
Hello Cristian,

so i am able to replicate it and it looks to be a bug with the ios version.

Let's say i have a nothing connected on the port Gi1/0/8, if i do that:

Switch#sh interfaces gigabitEthernet 1/0/8
GigabitEthernet1/0/8 is administratively down, line protocol is down
(disabled)
  Hardware is Gigabit Ethernet, address is dca5.f434.5508 (bia
dca5.f434.5508)
  MTU 1500 bytes, BW 1 Kbit/sec, DLY 1000 usec,
 reliability 255/255, txload 1/255, rxload 1/255
  Encapsulation ARPA, loopback not set
  Keepalive set (10 sec)
  Auto-duplex, Auto-speed, media type is 10/100/1000BaseTX
  input flow-control is off, output flow-control is unsupported
  ARP type: ARPA, ARP Timeout 04:00:00
  Last input 00:07:35, output 00:07:05, output hang never
  Last clearing of "show interface" counters never
  Input queue: 0/75/0/0 (size/max/drops/flushes); Total output drops: 0
  Queueing strategy: fifo
  Output queue: 0/40 (size/max)
  5 minute input rate 0 bits/sec, 0 packets/sec
  5 minute output rate 0 bits/sec, 0 packets/sec
 484517 packets input, 59890752 bytes, 0 no buffer
 Received 266453 broadcasts (221983 multicasts)
 0 runts, 0 giants, 0 throttles
 0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored
 0 watchdog, 221983 multicast, 0 pause input
 0 input packets with dribble condition detected
 618866 packets output, 72946865 bytes, 0 underruns
 0 output errors, 0 collisions, 35 interface resets
 0 unknown protocol drops
 0 babbles, 0 late collision, 0 deferred
 0 lost carrier, 0 no carrier, 0 pause output
 0 output buffer failures, 0 output buffers swapped out

I have 59890752 bytes in and 72946865 bytes out.


I plug a laptop on it, pf receive a accounting packet with in 0 and out
0 (normal).

If i shutdown the port then pf receive a accounting packet with 59890752
(a little bit more) bytes in and 72946865 (a little bit more) bytes out.

++---++---++-+-+--+-+--+
| id | acctsessionid | username   | nasipaddress  |
acctstatustype | timestamp   | acctinputoctets |
acctoutputoctets | acctsessiontime | acctuniqueid |
++---++---++-+-+--+-+--+
|  3 | 005C  | host/inverse-8.inverse.inc | 172.20.135.77 |
Start  | 2017-11-15 16:19:21 |   0 |   
0 |   0 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
|  6 | 005C  | host/inverse-8.inverse.inc | 172.20.135.77 |
Stop   | 2017-11-15 16:19:28 |    59665537 |
72749820 |   7 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
|  9 | 005D  | host/inverse-8.inverse.inc | 172.20.135.77 |
Start  | 2017-11-15 16:19:31 |   0 |   
0 |   0 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
| 12 | 005D  | host/inverse-8.inverse.inc | 172.20.135.77 |
Stop   | 2017-11-15 16:36:05 |    59846611 |
72909854 | 994 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
| 15 | 0060  | host/inverse-8.inverse.inc | 172.20.135.77 |
Start  | 2017-11-15 16:36:26 |   0 |   
0 |   0 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
| 18 | 0060  | host/inverse-8.inverse.inc | 172.20.135.77 |
Stop   | 2017-11-15 16:36:57 |    59869432 |
72929035 |  30 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
| 21 | 0061  | host/inverse-8.inverse.inc | 172.20.135.77 |
Start  | 2017-11-15 16:38:25 |   0 |   
0 |   0 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
| 24 | 0061  | host/inverse-8.inverse.inc | 172.20.135.77 |
Stop   | 2017-11-15 16:38:56 |    59890752 |
72946865 |  31 | 8cf6eb6093c8ef5f8f5b94ebe8e81265 |
++---++---++-+-+--+-+--+

So it looks that the in/out bytes are never reseted and the switch send
the in/out bytes since the switch started.

What i can recommend is there is a new ios version then upgrade, if it
doesn't fix the issue then open a TAC with cisco.

Regards

Fabrice



Le 2017-11-15 à 06:09, Cristian Mammoli via PacketFence-users a écrit :
> Ok this my Notebook wifi adapter (E4:B3:18:2C:E0:C0) and 192.168.7.221
> is a Cisco WLC. No problem here, the accounting data looks ok:
>
> MariaDB [pf]> select * from radacct_log where
> acctuniqueid="c16c078f963c875d37013c5cba979106";
>

Re: [PacketFence-users] Packetfence-PKI / Setup Wizard Error

2017-11-15 Thread Jason Sloan via PacketFence-users 
Cool, I was wondering if you could type cast in python and if that would
fix it. I also see you added SHA256 for the CA digest. Thanks!

On Wed, Nov 15, 2017 at 9:22 AM, Fabrice Durand via PacketFence-users <
packetfence-users@lists.sourceforge.net> wrote:

> Ok so here the patch https://github.com/inverse-
> inc/packetfence-pki/commit/c66ef2ab34964caecda3d2cdff1c956656227ffc.diff
>
> Regards
>
> Fabrice
>
>
>
> Le 2017-11-15 à 08:56, Fabrice Durand via PacketFence-users a écrit :
>
> Ok i am able to replicate it, let me fix it and i will give you a patch.
>
> Regards
>
> Fabrice
>
>
>
> Le 2017-11-14 à 22:41, Jason Sloan a écrit :
>
> Sorry, I should have included the values.
> I wasn't sure if the values should be comma delimited or not. I tried both
> comma and space delimited.
>
> KU:
> digitalSignature, keyCertSign, cRLSign
>
> EKU:
> serverAuth
>
> pyOpenSSL version:
> pyOpenSSL-17.2.0-9.1.noarch
>
> On Tue, Nov 14, 2017 at 6:32 PM, Durand fabrice via PacketFence-users <
> packetfence-users@lists.sourceforge.net> wrote:
>
>> Hello Jason,
>>
>> i did a try and i am not able to reproduce the error.
>>
>> So it can be an issue with the keyUsage value or an issue with pyopenssl.
>>
>> What did you define for keyUsage and can you give me the version of
>> pyopenssl you use ?
>>
>> rpm -qa|grep -i openssl
>>
>> Regards
>>
>> Fabrice
>>
>>
>>
>> Le 2017-11-14 à 16:14, Jason Sloan via PacketFence-users a écrit :
>>
>> Error:
>> Environment:
>>
>> Centos 7 - Clean Install
>>
>> Steps to reproduce:
>> Install Packetfence-PKI
>> Browse to PKI Admin site & login.
>> Complete all 4 steps of initial setup wizard & Submit
>>
>> Error condition occurs.
>>
>> Looks like a bad variable type, probably also related to the newer django
>> version?
>>
>>
>>
>>
>>
>> Error details:
>>
>> Request Method: POST
>> Request URL: https://localhost:9393/pki/init_wizard/
>>
>> Django Version: 1.8.1
>> Python Version: 2.7.5
>> Installed Applications:
>> ('django.contrib.admin',
>>  'django.contrib.auth',
>>  'django.contrib.contenttypes',
>>  'django.contrib.sessions',
>>  'django.contrib.messages',
>>  'django.contrib.staticfiles',
>>  'rest_framework',
>>  'rest_framework.authtoken',
>>  'bootstrap3',
>>  'pki')
>> Installed Middleware:
>> ('django.contrib.sessions.middleware.SessionMiddleware',
>>  'django.middleware.common.CommonMiddleware',
>>  'django.middleware.csrf.CsrfViewMiddleware',
>>  'django.contrib.auth.middleware.AuthenticationMiddleware',
>>  'django.contrib.messages.middleware.MessageMiddleware',
>>  'django.middleware.clickjacking.XFrameOptionsMiddleware',
>>  'inverse.middleware.SecurityMiddleware')
>>
>>
>> Traceback:
>> File "/usr/lib/python2.7/site-packages/django/core/handlers/base.py" in
>> get_response
>>   132. response = wrapped_callback(request,
>> *callback_args, **callback_kwargs)
>> File "/usr/lib/python2.7/site-packages/django/contrib/auth/decorators.py"
>> in _wrapped_view
>>   22. return view_func(request, *args, **kwargs)
>> File "/usr/lib/python2.7/site-packages/django/views/generic/base.py" in
>> view
>>   71. return self.dispatch(request, *args, **kwargs)
>> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in
>> dispatch
>>   237. response = super(WizardView, self).dispatch(request,
>> *args, **kwargs)
>> File "/usr/lib/python2.7/site-packages/django/views/generic/base.py" in
>> dispatch
>>   89. return handler(request, *args, **kwargs)
>> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in post
>>   300. return self.render_done(form, **kwargs)
>> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in
>> render_done
>>   357.   **kwargs)
>> File "/usr/local/packetfence-pki/pki/views.py" in done
>>   539. certif.sign()
>> File "/usr/local/packetfence-pki/pki/models.py" in sign
>>   61. cert.add_extensions([crypto.X509Extension("keyUsage",
>> True,self.key_usage)])
>> File "/usr/lib/python2.7/site-packages/OpenSSL/crypto.py" in __init__
>>   723. extension = _lib.X509V3_EXT_nconf(_ffi.NULL, ctx,
>> type_name, value)
>>
>> Exception Type: TypeError at /pki/init_wizard/
>> Exception Value: initializer for ctype 'char *' must be a str or list or
>> tuple, not unicode
>>
>>
>>
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>
>>
>>
>> ___
>> PacketFence-users mailing 
>> listPacketFence-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/packetfence-users
>>
>>
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>

Re: [PacketFence-users] Packetfence-PKI / Setup Wizard Error

2017-11-15 Thread Fabrice Durand via PacketFence-users 
Ok so here the patch
https://github.com/inverse-inc/packetfence-pki/commit/c66ef2ab34964caecda3d2cdff1c956656227ffc.diff

Regards

Fabrice



Le 2017-11-15 à 08:56, Fabrice Durand via PacketFence-users a écrit :
>
> Ok i am able to replicate it, let me fix it and i will give you a patch.
>
> Regards
>
> Fabrice
>
>
>
> Le 2017-11-14 à 22:41, Jason Sloan a écrit :
>> Sorry, I should have included the values.
>> I wasn't sure if the values should be comma delimited or not. I tried
>> both comma and space delimited.
>>
>> KU:
>> digitalSignature, keyCertSign, cRLSign
>>
>> EKU:
>> serverAuth
>>
>> pyOpenSSL version:
>> pyOpenSSL-17.2.0-9.1.noarch
>>
>> On Tue, Nov 14, 2017 at 6:32 PM, Durand fabrice via PacketFence-users
>> > > wrote:
>>
>> Hello Jason,
>>
>> i did a try and i am not able to reproduce the error.
>>
>> So it can be an issue with the keyUsage value or an issue with
>> pyopenssl.
>>
>> What did you define for keyUsage and can you give me the version
>> of pyopenssl you use ?
>>
>> rpm -qa|grep -i openssl
>>
>> Regards
>>
>> Fabrice
>>
>>
>>
>> Le 2017-11-14 à 16:14, Jason Sloan via PacketFence-users a écrit :
>>> Error:
>>> Environment:
>>>
>>> Centos 7 - Clean Install
>>>
>>> Steps to reproduce:
>>> Install Packetfence-PKI
>>> Browse to PKI Admin site & login.
>>> Complete all 4 steps of initial setup wizard & Submit
>>>
>>> Error condition occurs.
>>>
>>> Looks like a bad variable type, probably also related to the
>>> newer django version?
>>>
>>>
>>>
>>>
>>>
>>> Error details:
>>>
>>> Request Method: POST
>>> Request URL: https://localhost:9393/pki/init_wizard/
>>> 
>>>
>>> Django Version: 1.8.1
>>> Python Version: 2.7.5
>>> Installed Applications:
>>> ('django.contrib.admin',
>>>  'django.contrib.auth',
>>>  'django.contrib.contenttypes',
>>>  'django.contrib.sessions',
>>>  'django.contrib.messages',
>>>  'django.contrib.staticfiles',
>>>  'rest_framework',
>>>  'rest_framework.authtoken',
>>>  'bootstrap3',
>>>  'pki')
>>> Installed Middleware:
>>> ('django.contrib.sessions.middleware.SessionMiddleware',
>>>  'django.middleware.common.CommonMiddleware',
>>>  'django.middleware.csrf.CsrfViewMiddleware',
>>>  'django.contrib.auth.middleware.AuthenticationMiddleware',
>>>  'django.contrib.messages.middleware.MessageMiddleware',
>>>  'django.middleware.clickjacking.XFrameOptionsMiddleware',
>>>  'inverse.middleware.SecurityMiddleware')
>>>
>>>
>>> Traceback:
>>> File
>>> "/usr/lib/python2.7/site-packages/django/core/handlers/base.py"
>>> in get_response
>>>   132.                     response = wrapped_callback(request,
>>> *callback_args, **callback_kwargs)
>>> File
>>> "/usr/lib/python2.7/site-packages/django/contrib/auth/decorators.py"
>>> in _wrapped_view
>>>   22.                 return view_func(request, *args, **kwargs)
>>> File
>>> "/usr/lib/python2.7/site-packages/django/views/generic/base.py"
>>> in view
>>>   71.             return self.dispatch(request, *args, **kwargs)
>>> File
>>> "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in
>>> dispatch
>>>   237.         response = super(WizardView,
>>> self).dispatch(request, *args, **kwargs)
>>> File
>>> "/usr/lib/python2.7/site-packages/django/views/generic/base.py"
>>> in dispatch
>>>   89.         return handler(request, *args, **kwargs)
>>> File
>>> "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in post
>>>   300.                 return self.render_done(form, **kwargs)
>>> File
>>> "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in
>>> render_done
>>>   357.                                   **kwargs)
>>> File "/usr/local/packetfence-pki/pki/views.py" in done
>>>   539.             certif.sign()
>>> File "/usr/local/packetfence-pki/pki/models.py" in sign
>>>   61.           
>>>  cert.add_extensions([crypto.X509Extension("keyUsage",
>>> True,self.key_usage)])
>>> File "/usr/lib/python2.7/site-packages/OpenSSL/crypto.py" in
>>> __init__
>>>   723.         extension = _lib.X509V3_EXT_nconf(_ffi.NULL, ctx,
>>> type_name, value)
>>>
>>> Exception Type: TypeError at /pki/init_wizard/
>>> Exception Value: initializer for ctype 'char *' must be a str or
>>> list or tuple, not unicode
>>>
>>>
>>>
>>> 
>>> --
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>>
>>>
>>> ___
>>> PacketFence-users mailing list

[PacketFence-users] reply?? Can't login self-registration portaltoregister device

2017-11-15 Thread Yan via PacketFence-users 
Can anyone used device registration portal help ?--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] user management on web portal

2017-11-15 Thread Nicolay Rytchev via PacketFence-users 
Hello Fabrice,

Thank you for your answer. The new role works, user can`t remove the
foreign accounts ,but in this case the user can`t remove also the accounts
that he created by himself.
Can it be fixed ?

Regards,
Nicolay





2017-11-09 15:05 GMT+01:00 Fabrice Durand via PacketFence-users <
packetfence-users@lists.sourceforge.net>:

> Hello Nicolay,
>
> can you try that in adminroles.conf
>
> [Create_User]
> allowed_node_roles=
> actions=USERS_READ,USERS_CREATE
> allowed_roles=
> allowed_access_levels=
> allowed_actions=
> description=Create User
>
>
> Regards
>
> Fabrice
>
>
>
> Le 2017-11-09 à 01:56, Nicolay Rytchev via PacketFence-users a écrit :
>
> Hello Fabrice,
>
> I mean the following:
>
> I want to create a several users and grant  them rights to create a local
> database users (lobby management )  for authentication proccess.
> But all these users can see each other and remove any accounts from
> database.
> All these accounts have only user management rights.
>
> Regards,
> Nicolay
>
>
> 2017-11-07 22:17 GMT+01:00 Fabrice Durand via PacketFence-users <
> packetfence-users@lists.sourceforge.net>:
>
>> Hello Nicolay,
>>
>> not sure to understand , you mean in the admin gui ?
>>
>> Regards
>>
>> Fabrice
>>
>>
>>
>> Le 2017-11-07 à 08:23, Nicolay Rytchev via PacketFence-users a écrit :
>>
>> Hello all,
>>
>> Is it possible to hide from the user or forbid to him see or change
>> user's account in local database that is not created by him ?
>> I have successfuly remove user account that was created from another
>> account.
>>
>>
>> Regards,
>> Nicolay
>>
>>
>>
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>
>>
>>
>> ___
>> PacketFence-users mailing 
>> listPacketFence-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/packetfence-users
>>
>>
>> --
>> Fabrice durandfdur...@inverse.ca ::  +1.514.447.4918 <%28514%29%20447-4918> 
>> (x135) ::  www.inverse.ca
>> Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence 
>> (http://packetfence.org)
>>
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> ___
>> PacketFence-users mailing list
>> PacketFence-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>
>>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
> ___
> PacketFence-users mailing 
> listPacketFence-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
> --
> Fabrice durandfdur...@inverse.ca ::  +1.514.447.4918 <%28514%29%20447-4918> 
> (x135) ::  www.inverse.ca
> Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence 
> (http://packetfence.org)
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] Packetfence-PKI / Setup Wizard Error

2017-11-15 Thread Jason Sloan via PacketFence-users 
Sorry, I should have included the values.
I wasn't sure if the values should be comma delimited or not. I tried both
comma and space delimited.

KU:
digitalSignature, keyCertSign, cRLSign

EKU:
serverAuth

pyOpenSSL version:
pyOpenSSL-17.2.0-9.1.noarch

On Tue, Nov 14, 2017 at 6:32 PM, Durand fabrice via PacketFence-users <
packetfence-users@lists.sourceforge.net> wrote:

> Hello Jason,
>
> i did a try and i am not able to reproduce the error.
>
> So it can be an issue with the keyUsage value or an issue with pyopenssl.
>
> What did you define for keyUsage and can you give me the version of
> pyopenssl you use ?
>
> rpm -qa|grep -i openssl
>
> Regards
>
> Fabrice
>
>
>
> Le 2017-11-14 à 16:14, Jason Sloan via PacketFence-users a écrit :
>
> Error:
> Environment:
>
> Centos 7 - Clean Install
>
> Steps to reproduce:
> Install Packetfence-PKI
> Browse to PKI Admin site & login.
> Complete all 4 steps of initial setup wizard & Submit
>
> Error condition occurs.
>
> Looks like a bad variable type, probably also related to the newer django
> version?
>
>
>
>
>
> Error details:
>
> Request Method: POST
> Request URL: https://localhost:9393/pki/init_wizard/
>
> Django Version: 1.8.1
> Python Version: 2.7.5
> Installed Applications:
> ('django.contrib.admin',
>  'django.contrib.auth',
>  'django.contrib.contenttypes',
>  'django.contrib.sessions',
>  'django.contrib.messages',
>  'django.contrib.staticfiles',
>  'rest_framework',
>  'rest_framework.authtoken',
>  'bootstrap3',
>  'pki')
> Installed Middleware:
> ('django.contrib.sessions.middleware.SessionMiddleware',
>  'django.middleware.common.CommonMiddleware',
>  'django.middleware.csrf.CsrfViewMiddleware',
>  'django.contrib.auth.middleware.AuthenticationMiddleware',
>  'django.contrib.messages.middleware.MessageMiddleware',
>  'django.middleware.clickjacking.XFrameOptionsMiddleware',
>  'inverse.middleware.SecurityMiddleware')
>
>
> Traceback:
> File "/usr/lib/python2.7/site-packages/django/core/handlers/base.py" in
> get_response
>   132. response = wrapped_callback(request,
> *callback_args, **callback_kwargs)
> File "/usr/lib/python2.7/site-packages/django/contrib/auth/decorators.py"
> in _wrapped_view
>   22. return view_func(request, *args, **kwargs)
> File "/usr/lib/python2.7/site-packages/django/views/generic/base.py" in
> view
>   71. return self.dispatch(request, *args, **kwargs)
> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in
> dispatch
>   237. response = super(WizardView, self).dispatch(request, *args,
> **kwargs)
> File "/usr/lib/python2.7/site-packages/django/views/generic/base.py" in
> dispatch
>   89. return handler(request, *args, **kwargs)
> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in post
>   300. return self.render_done(form, **kwargs)
> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py" in
> render_done
>   357.   **kwargs)
> File "/usr/local/packetfence-pki/pki/views.py" in done
>   539. certif.sign()
> File "/usr/local/packetfence-pki/pki/models.py" in sign
>   61. cert.add_extensions([crypto.X509Extension("keyUsage",
> True,self.key_usage)])
> File "/usr/lib/python2.7/site-packages/OpenSSL/crypto.py" in __init__
>   723. extension = _lib.X509V3_EXT_nconf(_ffi.NULL, ctx,
> type_name, value)
>
> Exception Type: TypeError at /pki/init_wizard/
> Exception Value: initializer for ctype 'char *' must be a str or list or
> tuple, not unicode
>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
> ___
> PacketFence-users mailing 
> listPacketFence-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] Packetfence-PKI / Setup Wizard Error

2017-11-15 Thread Fabrice Durand via PacketFence-users 
Ok i am able to replicate it, let me fix it and i will give you a patch.

Regards

Fabrice



Le 2017-11-14 à 22:41, Jason Sloan a écrit :
> Sorry, I should have included the values.
> I wasn't sure if the values should be comma delimited or not. I tried
> both comma and space delimited.
>
> KU:
> digitalSignature, keyCertSign, cRLSign
>
> EKU:
> serverAuth
>
> pyOpenSSL version:
> pyOpenSSL-17.2.0-9.1.noarch
>
> On Tue, Nov 14, 2017 at 6:32 PM, Durand fabrice via PacketFence-users
>  > wrote:
>
> Hello Jason,
>
> i did a try and i am not able to reproduce the error.
>
> So it can be an issue with the keyUsage value or an issue with
> pyopenssl.
>
> What did you define for keyUsage and can you give me the version
> of pyopenssl you use ?
>
> rpm -qa|grep -i openssl
>
> Regards
>
> Fabrice
>
>
>
> Le 2017-11-14 à 16:14, Jason Sloan via PacketFence-users a écrit :
>> Error:
>> Environment:
>>
>> Centos 7 - Clean Install
>>
>> Steps to reproduce:
>> Install Packetfence-PKI
>> Browse to PKI Admin site & login.
>> Complete all 4 steps of initial setup wizard & Submit
>>
>> Error condition occurs.
>>
>> Looks like a bad variable type, probably also related to the
>> newer django version?
>>
>>
>>
>>
>>
>> Error details:
>>
>> Request Method: POST
>> Request URL: https://localhost:9393/pki/init_wizard/
>> 
>>
>> Django Version: 1.8.1
>> Python Version: 2.7.5
>> Installed Applications:
>> ('django.contrib.admin',
>>  'django.contrib.auth',
>>  'django.contrib.contenttypes',
>>  'django.contrib.sessions',
>>  'django.contrib.messages',
>>  'django.contrib.staticfiles',
>>  'rest_framework',
>>  'rest_framework.authtoken',
>>  'bootstrap3',
>>  'pki')
>> Installed Middleware:
>> ('django.contrib.sessions.middleware.SessionMiddleware',
>>  'django.middleware.common.CommonMiddleware',
>>  'django.middleware.csrf.CsrfViewMiddleware',
>>  'django.contrib.auth.middleware.AuthenticationMiddleware',
>>  'django.contrib.messages.middleware.MessageMiddleware',
>>  'django.middleware.clickjacking.XFrameOptionsMiddleware',
>>  'inverse.middleware.SecurityMiddleware')
>>
>>
>> Traceback:
>> File
>> "/usr/lib/python2.7/site-packages/django/core/handlers/base.py"
>> in get_response
>>   132.                     response = wrapped_callback(request,
>> *callback_args, **callback_kwargs)
>> File
>> "/usr/lib/python2.7/site-packages/django/contrib/auth/decorators.py"
>> in _wrapped_view
>>   22.                 return view_func(request, *args, **kwargs)
>> File
>> "/usr/lib/python2.7/site-packages/django/views/generic/base.py"
>> in view
>>   71.             return self.dispatch(request, *args, **kwargs)
>> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py"
>> in dispatch
>>   237.         response = super(WizardView,
>> self).dispatch(request, *args, **kwargs)
>> File
>> "/usr/lib/python2.7/site-packages/django/views/generic/base.py"
>> in dispatch
>>   89.         return handler(request, *args, **kwargs)
>> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py"
>> in post
>>   300.                 return self.render_done(form, **kwargs)
>> File "/usr/lib/python2.7/site-packages/formtools/wizard/views.py"
>> in render_done
>>   357.                                   **kwargs)
>> File "/usr/local/packetfence-pki/pki/views.py" in done
>>   539.             certif.sign()
>> File "/usr/local/packetfence-pki/pki/models.py" in sign
>>   61.           
>>  cert.add_extensions([crypto.X509Extension("keyUsage",
>> True,self.key_usage)])
>> File "/usr/lib/python2.7/site-packages/OpenSSL/crypto.py" in __init__
>>   723.         extension = _lib.X509V3_EXT_nconf(_ffi.NULL, ctx,
>> type_name, value)
>>
>> Exception Type: TypeError at /pki/init_wizard/
>> Exception Value: initializer for ctype 'char *' must be a str or
>> list or tuple, not unicode
>>
>>
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>
>>
>> ___
>> PacketFence-users mailing list
>> PacketFence-users@lists.sourceforge.net
>> 
>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>> 
>
>
> 
> --
> Check out the vibrant tech community on one

Re: [PacketFence-users] Bandwidth statistics make no sense (Cisco 2960x)

2017-11-15 Thread Cristian Mammoli via PacketFence-users 
Ok this my Notebook wifi adapter (E4:B3:18:2C:E0:C0) and 192.168.7.221 
is a Cisco WLC. No problem here, the accounting data looks ok:


MariaDB [pf]> select * from radacct_log where 
acctuniqueid="c16c078f963c875d37013c5cba979106";

++--+-+---++-+-+--+-+--+
| id | acctsessionid| username| 
nasipaddress  | acctstatustype | timestamp   | acctinputoctets | 
acctoutputoctets | acctsessiontime | acctuniqueid |

++--+-+---++-+-+--+-+--+
| 145688 | 5a042efb/e4:b3:18:2c:e0:c0/7093  | APRA=5C=5Cc.mammoli | 
192.168.7.221 | Start  | 2017-11-09 11:33:31 |   0 
|0 |   0 | c16c078f963c875d37013c5cba979106 |
| 145705 | 5a042efb/e4:b3:18:2c:e0:c0/7093  | APRA=5C=5Cc.mammoli | 
192.168.7.221 | Interim-Update | 2017-11-09 11:35:03 |5803 
| 8401 |  93 | c16c078f963c875d37013c5cba979106 |
| 145784 | 5a042efb/e4:b3:18:2c:e0:c0/7093  | APRA=5C=5Cc.mammoli | 
192.168.7.221 | Stop   | 2017-11-09 11:40:29 |  223227 
|44823 | 326 | c16c078f963c875d37013c5cba979106 |
| 183214 | 5a0aa387/e4:b3:18:2c:e0:c0/11165 | APRA=5C=5Cc.mammoli | 
192.168.7.221 | Start  | 2017-11-14 09:04:24 |   0 
|0 |   0 | c16c078f963c875d37013c5cba979106 |
| 183481 | 5a0aa387/e4:b3:18:2c:e0:c0/11165 | APRA=5C=5Cc.mammoli | 
192.168.7.221 | Stop   | 2017-11-14 09:15:25 | 6705186 
| 63346445 | 661 | c16c078f963c875d37013c5cba979106 |

++--+-+---++-+-+--+-+--+
5 rows in set (0.00 sec)

This is my ethernet Adapter (84:7B:EB:4A:52:05), here the traffic looks 
"out of scale", the same happens for everyone on this switches.


MariaDB [pf]> select * from radacct_log where 
acctuniqueid="085b986ead6b7d9a6951d1486493d889";

++---+-+---++-+-+--+-+--+
| id | acctsessionid | username| nasipaddress  | 
acctstatustype | timestamp   | acctinputoctets | 
acctoutputoctets | acctsessiontime | acctuniqueid |

++---+-+---++-+-+--+-+--+
| 143611 | 1212  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Start  | 2017-11-09 09:01:15 |   0 |
0 |   0 | 085b986ead6b7d9a6951d1486493d889 |
| 143612 | 1212  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Interim-Update | 2017-11-09 09:01:15 | 2512995005 |   2056003245 
|   0 | 085b986ead6b7d9a6951d1486493d889 |
| 143613 | 1212  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Interim-Update | 2017-11-09 09:01:15 | 2512995005 |   2056003245 
|   0 | 085b986ead6b7d9a6951d1486493d889 |
| 144184 | 1212  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Stop   | 2017-11-09 09:32:36 | 6535801 | 64990835 
|1881 | 085b986ead6b7d9a6951d1486493d889 |
| 144373 | 1217  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Start  | 2017-11-09 09:45:34 |   0 |
0 |   0 | 085b986ead6b7d9a6951d1486493d889 |
| 146834 | 1217  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Interim-Update | 2017-11-09 12:46:07 | 2543121066 |   2372276848 
|   0 | 085b986ead6b7d9a6951d1486493d889 |
| 149206 | 1217  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Interim-Update | 2017-11-09 15:46:40 | 29469179 |261831473 
|   0 | 085b986ead6b7d9a6951d1486493d889 |
| 149848 | 1217  | APRA=5C=5Cc.mammoli | 192.168.16.43 | 
Stop   | 2017-11-09 16:40:12 | 7283459 | 86594327 
|3212 | 085b986ead6b7d9a6951d1486493d889 |

++---+-+---++-+-+--+-+--+
8 rows in set (0.00 sec)

MariaDB [pf]> select * from radacct_log where 
acctuniqueid="a707be366d38eae790c9baf62fb087df";