can't get "SQL Based IP Pool" running
Leander S.
leander.schaefer at gmx.net
Mon May 5 20:47:59 CEST 2008
Hi,
I'm running *FreeRADIUS Version 1.1.7* on *FreeBSD 7.0* with
*Postgresql-Server-8.3beta2*.
I got everything working fine so far except *SQL Based IP Pool* -->
"/http://wiki.freeradius.org/Rlm_sqlippool/" <-- ; )
I changed the config like the how to told me to - looks good so far
until I got to the step which told me to fill in data into the Database.
This is how the standard "*radippool*" table looks like:
Spalte Datentyp Nicht Null Vorgabe Constraints Aktionen Kommentar
id
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=id&>
bigint
NOT NULL
nextval('radippool_id_seq'::regclass) [pk]
<http://10.1.10.80/phpPgAdmin/constraints.php?server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&schema=public>
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22id%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22id%22+ORDER+BY+%22id%22&column=id&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=id&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=id&>
pool_name
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=pool_name&>
text
NOT NULL
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22pool_name%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22pool_name%22+ORDER+BY+%22pool_name%22&column=pool_name&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=pool_name&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=pool_name&>
framedipaddress
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=framedipaddress&>
inet
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22framedipaddress%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22framedipaddress%22+ORDER+BY+%22framedipaddress%22&column=framedipaddress&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=framedipaddress&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=framedipaddress&>
nasipaddress
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=nasipaddress&>
text
NOT NULL
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22nasipaddress%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22nasipaddress%22+ORDER+BY+%22nasipaddress%22&column=nasipaddress&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=nasipaddress&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=nasipaddress&>
calledstationid
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=calledstationid&>
character varying(64)
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22calledstationid%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22calledstationid%22+ORDER+BY+%22calledstationid%22&column=calledstationid&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=calledstationid&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=calledstationid&>
callingstationid
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=callingstationid&>
text
NOT NULL
''::text
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22callingstationid%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22callingstationid%22+ORDER+BY+%22callingstationid%22&column=callingstationid&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=callingstationid&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=callingstationid&>
expiry_time
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=expiry_time&>
timestamp(0) without time zone
NOT NULL
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22expiry_time%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22expiry_time%22+ORDER+BY+%22expiry_time%22&column=expiry_time&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=expiry_time&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=expiry_time&>
username
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=username&>
text
''::text
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22username%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22username%22+ORDER+BY+%22username%22&column=username&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=username&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=username&>
pool_key
<http://10.1.10.80/phpPgAdmin/colproperties.php?subject=column&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=pool_key&>
character varying(30)
NOT NULL
Durchsuchen
<http://10.1.10.80/phpPgAdmin/display.php?server=%3A5432%3Aallow&database=radius&schema=public&subject=column&return_url=tblproperties.php%3Fserver%3D%253A5432%253Aallow%26amp%3Bdatabase%3Dradius%26amp%3Bschema%3Dpublic%26amp%3Btable%3Dradippool&table=radippool&return_desc=Zur%26%23252%3Bck&query=SELECT+%22pool_key%22%2C+count%28%2A%29+AS+%22count%22+FROM+%22radippool%22+GROUP+BY+%22pool_key%22+ORDER+BY+%22pool_key%22&column=pool_key&>
Ändern
<http://10.1.10.80/phpPgAdmin/colproperties.php?action=properties&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=pool_key&>
Löschen
<http://10.1.10.80/phpPgAdmin/tblproperties.php?action=confirm_drop&server=%3A5432%3Aallow&database=radius&schema=public&table=radippool&column=pool_key&>
Is there any description of the fields? Or a example of a working one??
I mean - for example - why do I have to fill in calledstationid or
callingstationid if it's an pool for more than only one client?
Would be very great & helpful if someone could paste me a working one.
Regards,
LeoLinux
More information about the Freeradius-Users
mailing list