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.
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
