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
