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 <avnelvernon at gmail.com> wrote:
> On Wed, May 10, 2017 at 3:30 PM, <
> freeradius-users-request at lists.freeradius.org> wrote:
>
>> Send Freeradius-Users mailing list submissions to
>>         freeradius-users at lists.freeradius.org
>>
>> 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
>>         freeradius-users-request at lists.freeradius.org
>>
>> You can reach the person managing the list at
>>         freeradius-users-owner at lists.freeradius.org
>>
>> 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 <joseph490 at gmail.com>
>> To: FreeRadius users mailing list
>>         <freeradius-users at lists.freeradius.org>
>> Subject: Re: TLS Variables not set
>> Message-ID:
>>         <CACx-Ti1nZ-S1uEJ84qa-3U77T_L-VSGWdjdBXGu45M0HpejCWA at mail.
>> gmail.com>
>> Content-Type: text/plain; charset=UTF-8
>>
>> Congrats! :-)
>>
>>
>>
>> Regards
>> Mohd Yusuf Siddiqui
>> email: yusuf.siddiqui at fiyutech.com
>> 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 <luke at osnz.co.nz> wrote:
>>
>> > Finally got around to building 3.0.13 for CentOS 7, and yes, the problem
>> is
>> > now fixed.
>> >
>> > Thanks.
>> >
>> > Luke Pascoe
>> >
>> >
>> >
>> > *E* luke at osnz.co.nz
>> > * 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 <aland at deployingradius.com> wrote:
>> >
>> > > On Apr 20, 2017, at 11:28 PM, Luke Pascoe <luke at osnz.co.nz> 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 <aland at deployingradius.com>
>> To: FreeRadius users mailing list
>>         <freeradius-users at lists.freeradius.org>
>> Subject: Re: free radius Not able to add clients from nas table mysql
>> Message-ID: <9361521E-4EFA-4EBF-A3D0-F014241BFC03 at deployingradius.com>
>> Content-Type: text/plain; charset=us-ascii
>>
>> On May 9, 2017, at 7:08 AM, avnel vernon <avnelvernon at gmail.com> wrote:
>> >
>> > [root at 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 <coy.hile at coyhile.com>
>> To: freeradius-users at lists.freeradius.org
>> Subject: Bootstrap portion of 'make install'
>> Message-ID: <B2E81B39-0DCF-49BB-AD52-7BA8FFF5F213 at coyhile.com>
>> 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
>> coy.hile at coyhile.com
>>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Tue, 9 May 2017 21:29:16 -0400
>> From: Alan DeKok <aland at deployingradius.com>
>> To: FreeRadius users mailing list
>>         <freeradius-users at lists.freeradius.org>
>> Subject: Re: Bootstrap portion of 'make install'
>> Message-ID: <C73D6587-E5A4-4DD2-BB67-E034FBEC46C6 at deployingradius.com>
>> Content-Type: text/plain; charset=utf-8
>>
>> On May 9, 2017, at 8:48 PM, Coy Hile <coy.hile at coyhile.com> 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