not logged in | [Login]
Always use radiusd -X
when debugging!
/*
/*
-- For use by update-, stop- and simul_* queries CREATE INDEX radacct_active_session_idx ON radacct (AcctUniqueId) WHERE AcctStopTime IS NULL;
-- Add if you you regularly have to replay packets -- CREATE INDEX radacct_session_idx ON radacct (AcctUniqueId);
-- For use by onoff- CREATE INDEX radacct_bulk_close ON radacct (NASIPAddress, AcctStartTime) WHERE AcctStopTime IS NULL;
-- For use by cleanup scripts -- Works well for timeout queries, where ((acctstoptime IS NULL) AND (acctupdatetime < (now() - '1 day'::interval)))
-- Although at first glance it appears where an index on AcctUpdateTime with condition WHERE AcctStopTime IS NULL; -- would be more effective, the query planner refused to use the index (for some unknown reason), and doing it this -- way allows the index to be used for both timeouts and cleanup. CREATE INDEX radacct_bulk_timeout ON radacct (AcctStopTime NULLS FIRST, AcctUpdateTime);
-- and for common statistic queries: CREATE INDEX radacct_start_user_idx ON radacct (AcctStartTime, UserName); -- and, optionally -- CREATE INDEX radacct_stop_user_idx ON radacct (acctStopTime, UserName);
/*
/*
/*
/*
/*
CREATE TABLE radpostauth ( id bigserial PRIMARY KEY, username text NOT NULL, pass text, reply text, CalledStationId text, CallingStationId text, authdate timestamp with time zone NOT NULL default now() );
/*
Last edited by Giedrius (baronkis), 2020-12-26 20:48:24
Sponsored by Network RADIUS