can't get "SQL Based IP Pool" running

Leander S. Mon, 05 May 2008 11:52:31 -0700

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 faruntil 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 orcallingstationid 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

can't get "SQL Based IP Pool" running

Reply via email to