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