Where can i get that new rlm_sql version?my current one is v1.116.2.3
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
