Thanks Alan with your guidance, I was able to manage this configuration as required for me. I have two questions: 1. in dhcp_sqlippool sqlippool_log_exists = "DHCP: Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" sqlippool_log_success = "DHCP: Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" sqlippool_log_clear = "DHCP: Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" sqlippool_log_failed = "DHCP: IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" sqlippool_log_nopool = "DHCP: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" How to enable this log, cannot figure where it writes this information? 2. Inside virtual server, I have define this: Post-Auth-Type REJECT { attr_filter.access_reject update reply { User-Name := "%{User-Name}" Calling-Station-Id := "%{Calling-Station-Id}" Reply-Message := "PASSWORD incorrect or IPPool Full = %{Pool-Name} for %{NAS-IP-Address}" } sql reply_log } 3. How can I show different error messages? Thanks, Kabin ________________________________ From: Freeradius-Users <freeradius-users-bounces+kabin_mool=hotmail.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Friday, October 9, 2020 12:58 AM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: IP allocation from Pool On Oct 8, 2020, at 1:09 PM, kabin mool <kabin_mool@hotmail.com> wrote:
I went through the document mods-available/dhcp_sqlippool and mods-available/sqlippool , do I need to enable both the files
It depends what you want to do. The comments in those files should make it *very* clear when / why they're being used.
or what are necessary steps , can you please help me on this?
Read the docs and follow them? We're not going to cut & paste the docs into a message on the mailing list. There's no point.
Do I need to do something on mods-enabled/dhcp files?
Maybe. Are you using DHCP? You should know that. And if you know if you're using DHCP, you have the answer to your question. Please ask SPECIFIC questions: http://wiki.freeradius.org/list-help Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html