Quantcast

free radius Not able to add clients from nas table mysql

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

free radius Not able to add clients from nas table mysql

avnel vernon
On Wed, May 10, 2017 at 3:30 PM, <
[hidden email]> wrote:

> Send Freeradius-Users mailing list submissions to
>         [hidden email]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.freeradius.org/mailman/listinfo/freeradius-users
> or, via email, send a message with subject or body 'help' to
>         [hidden email]
>
> You can reach the person managing the list at
>         [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Freeradius-Users digest..."
>
>
> Today's Topics:
>
>    1. Re: TLS Variables not set (Yusuf Siddiqui)
>    2. Re: free radius Not able to add clients from nas table mysql
>       (Alan DeKok)
>    3. Bootstrap portion of 'make install' (Coy Hile)
>    4. Re: Bootstrap portion of 'make install' (Alan DeKok)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 9 May 2017 17:31:42 +0530
> From: Yusuf Siddiqui <[hidden email]>
> To: FreeRadius users mailing list
>         <[hidden email]>
> Subject: Re: TLS Variables not set
> Message-ID:
>         <CACx-Ti1nZ-S1uEJ84qa-3U77T_L-VSGWdjdBXGu45M0HpejCWA@mail.
> gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Congrats! :-)
>
>
>
> Regards
> Mohd Yusuf Siddiqui
> email: [hidden email]
> www. <http://www.ibots.org/>fiyutech.com
> Mob. +91.991.033.914.3,+91.989.102.455.4
> Off:+91.120.
> ​
> ​49.89.65.4
> U.S. +120.975.347.57
>
> *___________________________________________________________
> ____________________________________________________________
> ___________________________________________*
>
> This communication & accompanying documents ("this e-mail") contains
> confidential and/or privileged information for exclusive    use of the
> individual
> to whom it is addressed. If you are not the intended recipient, please
> immediately notify the company & delete this e-mail. Any unauthorized use
> or disclosure of this e-mail is strictly prohibited. Representations in
> this
> e-mail are subject to contract. As an e-mail user please be cautious of the
> technical & other vulnerabilities of the internet which may result in
> malicious
> and/or unauthorized access to / use / alteration of e-mails/e-mail IDs.
> Thank you.
>
> *___________________________________________________________
> ____________________________________________________________
> ________________________________________*
>
> On Tue, May 9, 2017 at 10:14 AM, Luke Pascoe <[hidden email]> wrote:
>
> > Finally got around to building 3.0.13 for CentOS 7, and yes, the problem
> is
> > now fixed.
> >
> > Thanks.
> >
> > Luke Pascoe
> >
> >
> >
> > *E* [hidden email]
> > * P* +64 (9) 296 2961
> > * M* +64 (27) 426 6649
> > * W* www.osnz.co.nz
> >
> > 24 Wellington St
> > Papakura
> > Auckland, 2110
> > New Zealand
> >
> > On 22 April 2017 at 00:56, Alan DeKok <[hidden email]> wrote:
> >
> > > On Apr 20, 2017, at 11:28 PM, Luke Pascoe <[hidden email]> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I'm having trouble getting some basic TLS checks working for a Wifi
> > > EAP-TLS
> > > > connection.
> > > >
> > > > Centos7, freeradius 3.0.4
> > >
> > >   Use 3.0.13.
> > >
> > >   Alan DeKok.
> > >
> > > -
> > > List info/subscribe/unsubscribe? See http://www.freeradius.org/
> > > list/users.html
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/
> > list/users.html
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 9 May 2017 08:58:37 -0400
> From: Alan DeKok <[hidden email]>
> To: FreeRadius users mailing list
>         <[hidden email]>
> Subject: Re: free radius Not able to add clients from nas table mysql
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=us-ascii
>
> On May 9, 2017, at 7:08 AM, avnel vernon <[hidden email]> wrote:
> >
> > [root@localhost ~]# radiusd -X
> > radiusd: FreeRADIUS Version 3.0.4, for host x86_64-redhat-linux-gnu,
> built
>
>   Upgrade.
>
> > rlm_sql (sql): Executing query: 'SELECT id, nasname, shortname, type,
> > secret, server FROM nas'
> > rlm_sql (sql): Adding client zd (zd) to 192.168.1.173 clients list
> > ip_hton: Name or service not known
>
>   Something in your local system is broken.  I've never seen this issue
> before.
>
>   Upgrade.
>
>   Alan DeKok.
>
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 9 May 2017 20:48:30 -0400
> From: Coy Hile <[hidden email]>
> To: [hidden email]
> Subject: Bootstrap portion of 'make install'
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=utf-8
>
> Hi all,
>
> I’m trying to incorporate FreeRADIUS 3 into pkgsrc.
>
>
> In looking at the spec file in
>
> https://github.com/FreeRADIUS/freeradius-server/blob/v4.0.x/
> redhat/freeradius.spec
>
> one sees an RPM post-install script that calls /etc/raddb/certs/bootstrap
> if needed.  Clearly, if one were actually running ‘make install’ in
> production, that work would be necessary as the Makefile does it.  However,
> if one is building a package, that step in ‘raddb/all.mk’ seems
> superfluous, and means that one need remove a bunch of ephemeral files from
> the DESTDIR before packaging.
>
> Rather than having my package build framework let the bootstrap run in the
> DESTDIR and nuke the artifacts it creates before packaging, is there some
> setting one can tweak to skip that bootstrap as part of make install?
>
> Thanks
>
> —
> Coy Hile
> [hidden email]
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 9 May 2017 21:29:16 -0400
> From: Alan DeKok <[hidden email]>
> To: FreeRadius users mailing list
>         <[hidden email]>
> Subject: Re: Bootstrap portion of 'make install'
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=utf-8
>
> On May 9, 2017, at 8:48 PM, Coy Hile <[hidden email]> wrote:
> > In looking at the spec file in
> >
> > https://github.com/FreeRADIUS/freeradius-server/blob/v4.0.x/
> redhat/freeradius.spec
> >
> > one sees an RPM post-install script that calls
> /etc/raddb/certs/bootstrap if needed.  Clearly, if one were actually
> running ‘make install’ in production, that work would be necessary as the
> Makefile does it.  However, if one is building a package, that step in
> ‘raddb/all.mk’ seems superfluous, and means that one need remove a bunch
> of ephemeral files from the DESTDIR before packaging.
>
>   Yes.  That's why you can do:
>
> $ PACKAGE=yes make install
>
>   And the various auto-generated certs *won't* be created or installed.
>
> > Rather than having my package build framework let the bootstrap run in
> the DESTDIR and nuke the artifacts it creates before packaging, is there
> some setting one can tweak to skip that bootstrap as part of make install?
>
>   See above.  The Linux packages have similar requirements, hence the
> current solution.
>
>   Alan DeKok.
>
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html
>
> ------------------------------
>
> End of Freeradius-Users Digest, Vol 145, Issue 24
> *************************************************
>



Hii i tried in another machine still facing same issue
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: free radius Not able to add clients from nas table mysql

Alan Buxey
what is the output when you run that SELECT statement by hand in the SQL client?

do you have any entries in /etc/hosts ?   do you have working DNS?

alan

On 10 May 2017 at 12:20, avnel vernon <[hidden email]> wrote:

> On Wed, May 10, 2017 at 3:30 PM, <
> [hidden email]> wrote:
>
>> Send Freeradius-Users mailing list submissions to
>>         [hidden email]
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>         http://lists.freeradius.org/mailman/listinfo/freeradius-users
>> or, via email, send a message with subject or body 'help' to
>>         [hidden email]
>>
>> You can reach the person managing the list at
>>         [hidden email]
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of Freeradius-Users digest..."
>>
>>
>> Today's Topics:
>>
>>    1. Re: TLS Variables not set (Yusuf Siddiqui)
>>    2. Re: free radius Not able to add clients from nas table mysql
>>       (Alan DeKok)
>>    3. Bootstrap portion of 'make install' (Coy Hile)
>>    4. Re: Bootstrap portion of 'make install' (Alan DeKok)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Tue, 9 May 2017 17:31:42 +0530
>> From: Yusuf Siddiqui <[hidden email]>
>> To: FreeRadius users mailing list
>>         <[hidden email]>
>> Subject: Re: TLS Variables not set
>> Message-ID:
>>         <CACx-Ti1nZ-S1uEJ84qa-3U77T_L-VSGWdjdBXGu45M0HpejCWA@mail.
>> gmail.com>
>> Content-Type: text/plain; charset=UTF-8
>>
>> Congrats! :-)
>>
>>
>>
>> Regards
>> Mohd Yusuf Siddiqui
>> email: [hidden email]
>> www. <http://www.ibots.org/>fiyutech.com
>> Mob. +91.991.033.914.3,+91.989.102.455.4
>> Off:+91.120.
>>
>> 49.89.65.4
>> U.S. +120.975.347.57
>>
>> *___________________________________________________________
>> ____________________________________________________________
>> ___________________________________________*
>>
>> This communication & accompanying documents ("this e-mail") contains
>> confidential and/or privileged information for exclusive    use of the
>> individual
>> to whom it is addressed. If you are not the intended recipient, please
>> immediately notify the company & delete this e-mail. Any unauthorized use
>> or disclosure of this e-mail is strictly prohibited. Representations in
>> this
>> e-mail are subject to contract. As an e-mail user please be cautious of the
>> technical & other vulnerabilities of the internet which may result in
>> malicious
>> and/or unauthorized access to / use / alteration of e-mails/e-mail IDs.
>> Thank you.
>>
>> *___________________________________________________________
>> ____________________________________________________________
>> ________________________________________*
>>
>> On Tue, May 9, 2017 at 10:14 AM, Luke Pascoe <[hidden email]> wrote:
>>
>> > Finally got around to building 3.0.13 for CentOS 7, and yes, the problem
>> is
>> > now fixed.
>> >
>> > Thanks.
>> >
>> > Luke Pascoe
>> >
>> >
>> >
>> > *E* [hidden email]
>> > * P* +64 (9) 296 2961
>> > * M* +64 (27) 426 6649
>> > * W* www.osnz.co.nz
>> >
>> > 24 Wellington St
>> > Papakura
>> > Auckland, 2110
>> > New Zealand
>> >
>> > On 22 April 2017 at 00:56, Alan DeKok <[hidden email]> wrote:
>> >
>> > > On Apr 20, 2017, at 11:28 PM, Luke Pascoe <[hidden email]> wrote:
>> > > >
>> > > > Hi,
>> > > >
>> > > > I'm having trouble getting some basic TLS checks working for a Wifi
>> > > EAP-TLS
>> > > > connection.
>> > > >
>> > > > Centos7, freeradius 3.0.4
>> > >
>> > >   Use 3.0.13.
>> > >
>> > >   Alan DeKok.
>> > >
>> > > -
>> > > List info/subscribe/unsubscribe? See http://www.freeradius.org/
>> > > list/users.html
>> > -
>> > List info/subscribe/unsubscribe? See http://www.freeradius.org/
>> > list/users.html
>>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Tue, 9 May 2017 08:58:37 -0400
>> From: Alan DeKok <[hidden email]>
>> To: FreeRadius users mailing list
>>         <[hidden email]>
>> Subject: Re: free radius Not able to add clients from nas table mysql
>> Message-ID: <[hidden email]>
>> Content-Type: text/plain; charset=us-ascii
>>
>> On May 9, 2017, at 7:08 AM, avnel vernon <[hidden email]> wrote:
>> >
>> > [root@localhost ~]# radiusd -X
>> > radiusd: FreeRADIUS Version 3.0.4, for host x86_64-redhat-linux-gnu,
>> built
>>
>>   Upgrade.
>>
>> > rlm_sql (sql): Executing query: 'SELECT id, nasname, shortname, type,
>> > secret, server FROM nas'
>> > rlm_sql (sql): Adding client zd (zd) to 192.168.1.173 clients list
>> > ip_hton: Name or service not known
>>
>>   Something in your local system is broken.  I've never seen this issue
>> before.
>>
>>   Upgrade.
>>
>>   Alan DeKok.
>>
>>
>>
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Tue, 9 May 2017 20:48:30 -0400
>> From: Coy Hile <[hidden email]>
>> To: [hidden email]
>> Subject: Bootstrap portion of 'make install'
>> Message-ID: <[hidden email]>
>> Content-Type: text/plain; charset=utf-8
>>
>> Hi all,
>>
>> I’m trying to incorporate FreeRADIUS 3 into pkgsrc.
>>
>>
>> In looking at the spec file in
>>
>> https://github.com/FreeRADIUS/freeradius-server/blob/v4.0.x/
>> redhat/freeradius.spec
>>
>> one sees an RPM post-install script that calls /etc/raddb/certs/bootstrap
>> if needed.  Clearly, if one were actually running ‘make install’ in
>> production, that work would be necessary as the Makefile does it.  However,
>> if one is building a package, that step in ‘raddb/all.mk’ seems
>> superfluous, and means that one need remove a bunch of ephemeral files from
>> the DESTDIR before packaging.
>>
>> Rather than having my package build framework let the bootstrap run in the
>> DESTDIR and nuke the artifacts it creates before packaging, is there some
>> setting one can tweak to skip that bootstrap as part of make install?
>>
>> Thanks
>>
>> —
>> Coy Hile
>> [hidden email]
>>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Tue, 9 May 2017 21:29:16 -0400
>> From: Alan DeKok <[hidden email]>
>> To: FreeRadius users mailing list
>>         <[hidden email]>
>> Subject: Re: Bootstrap portion of 'make install'
>> Message-ID: <[hidden email]>
>> Content-Type: text/plain; charset=utf-8
>>
>> On May 9, 2017, at 8:48 PM, Coy Hile <[hidden email]> wrote:
>> > In looking at the spec file in
>> >
>> > https://github.com/FreeRADIUS/freeradius-server/blob/v4.0.x/
>> redhat/freeradius.spec
>> >
>> > one sees an RPM post-install script that calls
>> /etc/raddb/certs/bootstrap if needed.  Clearly, if one were actually
>> running ‘make install’ in production, that work would be necessary as the
>> Makefile does it.  However, if one is building a package, that step in
>> ‘raddb/all.mk’ seems superfluous, and means that one need remove a bunch
>> of ephemeral files from the DESTDIR before packaging.
>>
>>   Yes.  That's why you can do:
>>
>> $ PACKAGE=yes make install
>>
>>   And the various auto-generated certs *won't* be created or installed.
>>
>> > Rather than having my package build framework let the bootstrap run in
>> the DESTDIR and nuke the artifacts it creates before packaging, is there
>> some setting one can tweak to skip that bootstrap as part of make install?
>>
>>   See above.  The Linux packages have similar requirements, hence the
>> current solution.
>>
>>   Alan DeKok.
>>
>>
>>
>>
>> ------------------------------
>>
>> Subject: Digest Footer
>>
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/
>> list/users.html
>>
>> ------------------------------
>>
>> End of Freeradius-Users Digest, Vol 145, Issue 24
>> *************************************************
>>
>
>
>
> Hii i tried in another machine still facing same issue
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Loading...