Поставил PostgreSQL Server 8.3, Client 8.3, Freeradius 2.1.7...делаю все мо мануалу..в логах radius вижу
Код: Выделить всё
Wed Oct 14 16:39:59 2009 : Info: rlm_sql (sql): Driver rlm_sql_postgresql (module rlm_sql_postgresql) loaded and linked
Wed Oct 14 16:39:59 2009 : Info: rlm_sql (sql): Attempting to connect to postgres@127.0.0.1:/dhcp
Wed Oct 14 16:39:59 2009 : Info: Ready to process requests.
Wed Oct 14 16:44:11 2009 : Error: rlm_sql_getvpdata: database query error
Wed Oct 14 16:44:11 2009 : Error: [sql] SQL query error; rejecting user
Код: Выделить всё
Oct 14 16:44:11 testbilling dhcpd: Convert DHCPDISCOVER 00:1a:4b:74:dd:a6/10.1.10.253 to RADIUS and forwarded to 127.0.0.1
Oct 14 16:44:38 testbilling last message repeated 3 times
Oct 14 16:45:41 testbilling last message repeated 4 times
Oct 14 16:51:19 testbilling last message repeated 4 times
Код: Выделить всё
dhcp=# select * from pg_shadow;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
----------+----------+-------------+----------+-----------+--------+----------+-----------
postgres | 10 | t | t | t | | |
radius | 16386 | f | f | f | | |
Код: Выделить всё
List of databases
Name | Owner | Encoding
-----------+----------+-----------
dhcp | postgres | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
test | postgres | SQL_ASCII
(5 rows)
Код: Выделить всё
sql {
<------>#
<------># Set the database to one of:
<------>#
<------>#<----->mysql, mssql, oracle, postgresql
<------>#
<------>database = "postgresql"
<------>#
<------># Which FreeRADIUS driver to use.
<------>#
<------>driver = "rlm_sql_${database}"
<------># Connection info:
<------>server = "127.0.0.1"
<------>#port = 3306
<------>login ="postgres"
<------>password ="1234"
Код: Выделить всё
ddns-update-style interim;
use-dhcp2radius true;
radius-servers localhost;
radius-secret dhcpdsecret;
radius-password 1234;
#radius-server-restore 1000;
#radius-port 1812;
#radius-client-freq 4;
#radius-freq-summ 10;
#radius-cache-ttl 86400;
#radius-update-arp false;
#radius-cache-maxlen 3000;
#radius-allow-cache true;
#radius-allow-dynamic-cache false;
#radius-use-mac-delimiter false;
radius-send-opts-to-srv 82;