Hello Fabrice,
I did as you recommended but error appeared while i don't know how to
resolved.
These are some errors related that i look on radius.log and packetfence.log
*#packetfence.log:*
*Mar 20 15:53:45 httpd.aaa(6337) INFO: [2c:27:d7:c3:c0:08] handling radius
autz request: from switch_ip => (10.126.123.10), connection_type =>
WIRED_MAC_AUTH,switch_mac => (Unknown), mac => [2c:27:d7:c3:c0:08], port =>
10001, username => "2c27d7c3c008" (pf::radius::authorize)Mar 20 15:53:45
httpd.aaa(6337) WARN: database query failed with: Unknown column
'machine_account' in 'field list' (errno: 1054), will try again
(pf::db::db_query_execute)Mar 20 15:53:45 httpd.aaa(6337) WARN: database
query failed with: Unknown column 'machine_account' in 'field list' (errno:
1054), will try again (pf::db::db_query_execute)Mar 20 15:53:45
httpd.aaa(6337) WARN: database query failed with: Unknown column
'machine_account' in 'field list' (errno: 1054), will try again
(pf::db::db_query_execute)Mar 20 15:53:45 httpd.aaa(6337) ERROR: Database
issue: We tried 3 times to serve query node_attributes_with_fingerprint_sql
called from pf::node::node_attributes_with_fingerprint and we failed. Is
the database running? (pf::db::db_query_execute)Mar 20 15:53:45
httpd.aaa(6337) ERROR: radius authorize failed with error: Can't use string
("0") as a HASH ref while "strict refs" in use at
/usr/local/pf/lib/pf/Switch.pm line 1562. (pf::api::radius_authorize)*
*#radius.log:*
*Fri Mar 20 15:53:45 2015 : Auth: Login OK: [2c27d7c3c008] (from client
10.126.123.10 port 50001 cli 2C-27-D7-C3-C0-08)Fri Mar 20 15:53:45 2015 :
Error: rlm_perl: No or invalid reply in RPC communication with server.
Check server side logs for details.*
*Here is the switch.conf:*
*## Copyright (C) 2005-2015 Inverse inc.## See the enclosed file COPYING
for license information (GPL).# If you did not receive this file, see#
http://www.fsf.org/licensing/licenses/gpl.html
<http://www.fsf.org/licensing/licenses/gpl.html>[default]description=Switches
Default
Valuesvlans=1,2,3,4,5normalVlan=1registrationVlan=2isolationVlan=3macDetectionVlan=4voiceVlan=5inlineVlan=6inlineTrigger=normalRole=normalregistrationRole=registrationisolationRole=isolationmacDetectionRole=macDetectionvoiceRole=voiceinlineRole=inlineVoIPEnabled=noVlanMap=YRoleMap=Ymode=testingmacSearchesMaxNb=30macSearchesSleepInterval=2uplink=dynamic##
Command Line Interface ## cliTransport could be: Telnet, SSH or
SerialcliTransport=TelnetcliUser=cliPwd=cliEnablePwd=## SNMP section##
PacketFence ->
SwitchSNMPVersion=1SNMPCommunityRead=publicSNMPCommunityWrite=private#SNMPEngineID
= 0000000000000#SNMPUserNameRead = readUser#SNMPAuthProtocolRead =
MD5#SNMPAuthPasswordRead = authpwdread#SNMPPrivProtocolRead = DES
#SNMPPrivPasswordRead = privpwdread#SNMPUserNameWrite =
writeUser#SNMPAuthProtocolWrite = MD5#SNMPAuthPasswordWrite =
authpwdwrite#SNMPPrivProtocolWrite = DES #SNMPPrivPasswordWrite =
privpwdwrite# Switch ->
PacketFenceSNMPVersionTrap=1SNMPCommunityTrap=public#SNMPAuthProtocolTrap =
MD5#SNMPAuthPasswordTrap = authpwdread#SNMPPrivProtocolTrap =
DES#SNMPPrivPasswordTrap = privpwdread## Web Services Interface ##
wsTransport could be: http or httpswsTransport=httpwsUser=wsPwd=## RADIUS
NAS Client config## RADIUS shared secret with
switchradiusSecret=[10.126.123.10]RoleMap=Nmode=productionSNMPCommunityRead=kvpguestVlan=230SNMPCommunityWrite=kvpacliUser=minhdefaultVlan=123AccessListMap=Ndescription=KVP_R4_OA2type=Cisco::Catalyst_2960cliPwd=xxxxxVoIPEnabled=YisolationVlan=220radiusSecret=xxxxxxuplink_dynamic=0SNMPVersion=2ccliEnablePwd=xxxxxuplink=1001registrationVlan=210voiceVlan=124*
*#pf.conf*
*[general]## general.domain## Domain name of PacketFence
system.domain=KVP.global## general.hostname## Hostname of PacketFence
system. This is concatenated with the domain in Apache rewriting rules and
therefore must be resolvable by clients.hostname=vmvnnetsec01##
general.dhcpservers## Comma-delimited list of DHCP servers. Passthroughs
are created to allow DHCP transactions from even "trapped"
nodes.dhcpservers=127.0.0.1,10.126.122.11,10.126.122.12##
general.timezone## System's timezone in string format. Supported list:#
http://www.php.net/manual/en/timezones.php
<http://www.php.net/manual/en/timezones.php>timezone=Asia/Ho_Chi_Minh[alerting]##
alerting.emailaddr## Email address to which notifications of rogue DHCP
servers, violations with an action of "email", or any other #
PacketFence-related message goes [email protected][scan]##
scan.engine## Which scan engine to use to perform client-side policy
compliance.engine=openvas[database]## database.pass## Password for the
mysql database used by PacketFence.pass=xxxxx[interface
eth0]ip=10.126.122.27type=managementmask=255.255.255.0[interface
eth0.210]enforcement=vlanip=10.126.210.1type=internalmask=255.255.255.0[interface
eth0.220]enforcement=vlanip=10.126.220.1type=internalmask=255.255.255.0*
If i can provide you more information to solved this issue please let me
know.
Thank and Best regards,
On 17 March 2015 at 08:59, Durand fabrice <[email protected]> wrote:
> Hello Minh,
>
>
> Le 2015-03-16 05:20, Minh Trung a écrit :
>
> Hello Fabrice,
>
> Thank you for your quick responded,
>
> My LAN Cisco switches 2960 are almost using Version 12.2(44)SE6, does this
> version enough condition to MAB configured?
> And Core switches are 4500 model, Version 12.2(50)SG3.
>
> 2960 and 4500 support MAB but i don't have in mind which ios version
> exactly support it (google it)
>
> I did as you recommended but after configuration radius on switch then i
> can not log in to switch again, it asked Username, while i don't know that
> :( .
>
> you probably changed:
> aaa authentication login default local
>
> How to use AD accounts to authenticate all users on Vlan123?(I own DNS, AD,
> DHCP on windows server).
>
> You have 2 options:
>
> use mac-authentication and hit the portal to authenticate (create a AD
> authentication source in packetfence)
>
> use 802.1x authentication (you must join the windows domain) and
> autoregister 802.1x users
>
> In the 2 case create a portal profile and include the AD source you
> created.
>
>
> I also want to create a Vlan for guests with name Guest but can not change
> type on web UI. This Vlan use for only guests when they come to work and
> don't have account on our AD. Which is better method, condition, rules that
> i have to look?
>
> Register by email or by sms is the better choice i think.
>
>
> I hope you can explain more detail about Radius, using AD to authenticate
> to me more clearly.
>
> Have a look here, it explain how to configure freeradius to authenticate
> against AD
>
> https://github.com/inverse-inc/packetfence/blob/devel/docs/PacketFence_Administration_Guide.asciidoc#option-2-authentication-against-active-directory-ad
>
> Any help is appreciated,
>
> Best regard,
>
> On 14 March 2015 at 20:49, Durand fabrice <[email protected]>
> <[email protected]> wrote:
>
>
> Hello Minh,
>
> your packetfence config looks ok, now next step is to configure your cisco
> switch, so let's check the documentation:
> https://github.com/inverse-inc/packetfence/blob/devel/docs/PacketFence_Network_Devices_Configuration_Guide.asciidoc#cisco
>
> If your cisco switch support MAB then use it and let's configure only one
> port for the test.
>
> On the packetfence side add a new switch, select Voip enabled, configure
> the role (registration: 210, isolation: 220, voip: 124, default: 123),
> radius secret, snmp v2c and set the community read and write. (btw enable
> snmp on the cisco switch too).
>
> So now if you plug a device in the test switch port a radius request will
> go on packetfence server (radius server 10.126.122.27) and pf will answer
> the registration vlan (210).
> You will hit the portal (you can create a portal profile base with a
> filter like switch ip) and register on a authentication source and pf will
> return the vlan id based on the role the authentication source set based on
> the rules.
>
> For iphone, if you plug it in the switch port then packetfence will try to
> know if it's an ipphone by doing an snmp read on the cdp/lldp mib and if
> the flag is on then packetfence will answer a specific radius attribute to
> tell the switch to use the voip vlan configured on the switch port (switch
> port voice vlan 124).
>
> For printer you can create a violation based on the dhcp fingerprint, like
> if packetfence detect that it's a printer then register the device and set
> the role to printer (of course add a new category and assign the correct
> vlan id to the role in the switch config).
>
> For the wifi it's the same workflow (it depend of your AP) but if it
> support Mac auth then folow the configuration and create a portal profile
> with ssid filter = your ssid and add the sponsor source.
>
> Btw you will probably have to add a Active Directory auth source and set
> rule that will set a role as default , an access duration to 1W and add a
> Mark as Sponsor (for wifi sponsor).
>
>
> Regards
> Fabrice
>
>
> Le 2015-03-14 05:23, Minh Trung a écrit :
>
> Hello experts,
>
> I am newbie.
>
> My network as attached file and i suggested i should use PF as Vlan
> enforcement.
>
> My infrastructure already has:
>
> Vlan122: Servers (including PF server, pf is vmware)
> Vlan123: Office Users (PCs, Desktops, IP Phone, Printer)
> Vlan124: Telephone
> Vlan:125 Firewall
> Vlan126: Access Door
> .........
>
> I already own DNS, DHCP by Windows server
> Vlan123 will be DHCP via Windows Server 2008
> Now i want PF only apply for Vlan123, how to do that and which method i
> should use to authenticate for all Users, IP phone, Printer (This Vlan used
> wired)?
> I also plan used wifi in case visitor come to work, which authenticate
> method should i used in this case?
>
> On PF server already created 2 Vlan Registration and Isolation.
>
> These are config file that PF generated:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *#pf.conf:[interface eth0]ip=10.126.122.27 --> my IP address's PF server
> type=managementmask=255.255.255.0[interface
> eth0.210]enforcement=vlanip=10.126.210.1type=internalmask=255.255.255.0[interface
> eth0.220]enforcement=vlanip=10.126.220.1type=internalmask=255.255.255.0*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *And
> network.conf:[10.126.210.0]dns=10.126.210.1dhcp_start=10.126.210.10gateway=10.126.210.1domain-name=vlan-registration.globalnat_enabled=disablednamed=enableddhcp_max_lease_time=30fake_mac_enabled=disableddhcpd=enableddhcp_end=10.126.210.246type=vlan-registrationnetmask=255.255.255.0dhcp_default_lease_time=30[10.126.220.0]dns=10.126.220.1dhcp_start=10.126.220.10gateway=10.126.220.1domain-name=vlan-isolation.globalnat_enabled=disablednamed=enableddhcp_max_lease_time=30fake_mac_enabled=disableddhcpd=enableddhcp_end=10.126.220.246type=vlan-isolationnetmask=255.255.255.0dhcp_default_lease_time=30*
>
> What are the next step i should to do to apply PF for Vlan123 while many
> devices in this vlan.
> How to configuration of my Cisco switches look like?
> I have still many confused here.
> Hope someone can make me clearly.
> Any help is very very appreciated,
>
> Best regards,
>
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website, sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for all
> things parallel software development, from weekly thought leadership blogs to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
>
>
>
> ______________________________
> _________________
> PacketFence-users mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> PacketFence-users mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website, sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for all
> things parallel software development, from weekly thought leadership blogs to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
>
>
>
> _______________________________________________
> PacketFence-users mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
