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
