On Fri, 23 Jul 2004, Jeff Green wrote: > Hi, > > I can't help but notice, but these updated files don't appear in > the "nightly CVS snapshot" either. > > I assume this deliberate. > > BTW,I'm currently running 0.9.3 in production (great product) and > testing > 1.0.0-prel3 - I was hoping this functionality would be in the 1.0.0 > release.
If you mean sql based clients it's already there: http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/src/modules/rlm_sql/rlm_sql.c?rev=1.131&content-type=text/x-cvsweb-markup&only_with_tag=release_1_0_0_pre3 Look for the function generate_sql_clients There was a directive missing in sql.conf which i fixed today (so you 'll see that in tomorrow's CVS snapshot) and there are a few things which need to be fixed in the non mysql db/conf files (sorry i 'm using mysql). > > > Regards, > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kostas > Kalevras > Sent: 23 July 2004 13:00 > To: [EMAIL PROTECTED] > Subject: Re: clients date from DB > > On Fri, 23 Jul 2004, Edgars wrote: > > > should i install that rlm_sql?because i can't find it on my machine? i > > > just found it in not freeradiusd extracting directory. > > Where can i get that new rlm_sql version?my current one is v1.116.2.3 > > >From the usual place www.freeradius.org > You could also use the CVS web interface yo only download the latest > rlm_sql.c and conf.h for src/modules/rlm_sql > > > > > Edgars > > > > Kostas Kalevras wrote: > > > > >On Fri, 23 Jul 2004, Edgars wrote: > > > > > > > > > > > >>nope,doesn't work for me, the same error. Maybe i should use the > > >>lates version? now the table looks like this: > > >> > > >>freeradius=# select*from nas2; > > >> id | nasname | shortname | type | ports | secret | > comunity | > > >>description > > > >>----+------------+------------------+------+-------+--------+--------- > -+------------- > > >> 1 | 10.5.8.103 | testings_baigais | | | xxx | > | > > >> > > >> > > > > > >sql clients was added in revision 1.125 of rlm_sql (check rlm_sql.c > > >rcsid for that). > > > > > >Also run the server in debug mode to see exactly what's happening. > > > > > > > > > > > >>Edgars > > >> > > >>Kostas Kalevras wrote: > > >> > > >> > > >> > > >>>On Fri, 23 Jul 2004, Edgars wrote: > > >>> > > >>> > > >>> > > >>> > > >>> > > >>>>so the structure of the table should be as yours? Because my > > >>>>deasn't work (error message about unknow client 1-.5.8.103): > > >>>> > > >>>> > > >>>> > > >>>> > > >>>db_postgresql.sql has not been updated yet. Please use my table > structure. > > >>> > > >>> > > >>> > > >>> > > >>> > > >>>>freeradius=# select*from nas; > > >>>> ipaddr | shortname | secret | nasname | type | ports | > > >>>>community | snmp | naslocation > > > >>>>------------+------------------+--------+---------+------+-------+-- > ---------+------+------------- > > >>>>10.5.8.103 | testings_baigais | xxx | | | > > >>>>| | | > > >>>>(1 row) > > >>>> > > >>>>Regards, > > >>>>Edgars > > >>>> > > >>>>Kostas Kalevras wrote: > > >>>> > > >>>> > > >>>> > > >>>> > > >>>> > > >>>>>On Fri, 23 Jul 2004, Edgars wrote: > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>>>ok, have added readclients=yes in the radiusd.conf, added rows > > >>>>>>in the > > >>>>>>postgresql.conf: > > >>>>>> > > >>>>>>nas_table="nas" > > >>>>>>readclients=yes > > >>>>>> > > >>>>>>I should write some SQL query now in this postgresql file, > > >>>>>>right? Can you please give some example (i am checking IP and > secret coming from NAS)? > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>No you don't need to write any SQL queries, the query is hard > > >>>>>coded in the sql module code. > > >>>>> > > >>>>>mysql> select * from nas; > > > >>>>>+----+---------------------------+-------------------+-------+----- > --+--------+-----------+--------------------------+ > > >>>>>| id | nasname | shortname | type | > ports | secret | > > >>>>>community | description | > > > >>>>>+----+---------------------------+-------------------+-------+----- > --+--------+-----------+--------------------------+ > > >>>>>| 1 | nas.hostname.com | prometheus.dialup | cisco | 180 | > secret | > > >>>>>public | Cisco 5350 Access Server | > > > >>>>>+----+---------------------------+-------------------+-------+----- > --+--------+-----------+--------------------------+ > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>>>Edgars > > >>>>>> > > >>>>>> > > >>>>>>Kostas Kalevras wrote: > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>>>On Fri, 23 Jul 2004, Edgars wrote: > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>>>ok, thanx! > > >>>>>>>>But how does freeradius know from which postgresql table to > > >>>>>>>>check client IPs? > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>Hmm, that information is missing ... fixed > > >>>>>>> > > >>>>>>>You will need to add the following directives to your > postgresql.conf: > > >>>>>>> > > >>>>>>>nas_table = "nas" > > >>>>>>>readclients = yes > > >>>>>>> > > >>>>>>>Also add a nas table with the same structure as the one defined > in db_mysql.sql. > > >>>>>>>The db_postgresql.sql file has not been updated yet and still > > >>>>>>>has the old structure. > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>>>Regards, > > >>>>>>>>Edgars > > >>>>>>>> > > >>>>>>>>Kostas Kalevras wrote: > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>>>On Thu, 22 Jul 2004, Edgars wrote: > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>>>Hi! > > >>>>>>>>>> > > >>>>>>>>>>how to 'tell' freeradius to look after clients' data in the > > >>>>>>>>>>postgresql DB?Should i write some queries in the > postgresql.conf file? > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>In latest versions of freeradius set readclients = yes in the > > > >>>>>>>>>sql.conf > > >>>>>>>>> > > >>>>>>>>>postgresql conf and sql schema files may not have been > > >>>>>>>>>updated so compare them to the corresponding mysql files. > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>>>Regards, > > >>>>>>>>>>Edgars > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>>- > > >>>>>>>>>>List info/subscribe/unsubscribe? See > > >>>>>>>>>>http://www.freeradius.org/list/users.html > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>> > > >>>>>>>>>-- > > >>>>>>>>>Kostas Kalevras Network Operations Center > > >>>>>>>>>[EMAIL PROTECTED] National Technical University of Athens, > Greece > > >>>>>>>>>Work Phone: +30 210 7721861 > > >>>>>>>>>'Go back to the shadow' Gandalf > > >>>>>>>>> > > >>>>>>>>>- > > >>>>>>>>>List info/subscribe/unsubscribe? See > > >>>>>>>>>http://www.freeradius.org/list/users.html > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>> > > >>>>>>>>- > > >>>>>>>>List info/subscribe/unsubscribe? See > > >>>>>>>>http://www.freeradius.org/list/users.html > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> > > >>>>>>>-- > > >>>>>>>Kostas Kalevras Network Operations Center > > >>>>>>>[EMAIL PROTECTED] National Technical University of Athens, > Greece > > >>>>>>>Work Phone: +30 210 7721861 > > >>>>>>>'Go back to the shadow' Gandalf > > >>>>>>> > > >>>>>>>- > > >>>>>>>List info/subscribe/unsubscribe? See > > >>>>>>>http://www.freeradius.org/list/users.html > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>- > > >>>>>>List info/subscribe/unsubscribe? See > > >>>>>>http://www.freeradius.org/list/users.html > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>> > > >>>>>-- > > >>>>>Kostas Kalevras Network Operations Center > > >>>>>[EMAIL PROTECTED] National Technical University of Athens, > Greece > > >>>>>Work Phone: +30 210 7721861 > > >>>>>'Go back to the shadow' Gandalf > > >>>>> > > >>>>>- > > >>>>>List info/subscribe/unsubscribe? See > > >>>>>http://www.freeradius.org/list/users.html > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>- > > >>>>List info/subscribe/unsubscribe? See > > >>>>http://www.freeradius.org/list/users.html > > >>>> > > >>>> > > >>>> > > >>>> > > >>>> > > >>>-- > > >>>Kostas Kalevras Network Operations Center > > >>>[EMAIL PROTECTED] National Technical University of Athens, Greece > > >>>Work Phone: +30 210 7721861 > > >>>'Go back to the shadow' Gandalf > > >>> > > >>>- > > >>>List info/subscribe/unsubscribe? See > > >>>http://www.freeradius.org/list/users.html > > >>> > > >>> > > >>> > > >>> > > >>> > > >>> > > >>- > > >>List info/subscribe/unsubscribe? See > > >>http://www.freeradius.org/list/users.html > > >> > > >> > > >> > > > > > >-- > > >Kostas Kalevras Network Operations Center > > >[EMAIL PROTECTED] National Technical University of Athens, Greece > > >Work Phone: +30 210 7721861 > > >'Go back to the shadow' Gandalf > > > > > >- > > >List info/subscribe/unsubscribe? See > > >http://www.freeradius.org/list/users.html > > > > > > > > > > > > > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > -- > Kostas Kalevras Network Operations Center > [EMAIL PROTECTED] National Technical University of Athens, Greece > Work Phone: +30 210 7721861 > 'Go back to the shadow' Gandalf > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > ------------------------------------------------------------------------ > Confidentiality Note: The information contained in this email and > document(s) attached are for the exclusive use of the addressee and may contain > confidential, privileged and non-disclosable information. If the recipient of this > email is not the addressee, such recipient is strictly prohibited from reading, > photocopying, distribution or otherwise using this email or its contents in any way. > Please notify the Sapiens (UK) Ltd. Systems Administrator via e-mail immediately at > [EMAIL PROTECTED], if you have received this email in error. > > Disclaimer: The views, opinions and guidelines contained in this confidential e-mail > are those of the originating author and may not be representative of Sapiens (UK) > Ltd. > ------------------------------------------------------------------------ > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
