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