Sql_log against postgresql

Have 2.0 running against a Postgresql database. The sql_log code looks like it functions differently than the sql statements in the postgres driver (stop packets are another insert instead of an update). Has anyone already changed out the sql lines match the way it works without sql_log, don't se

Patch for SQL and SQLIPPool performance

This patch has 2 things. Rewritten SQL queries for Postgres on the SQLIPPool. This actually makes using the SQLIPPool possible with a lot of clients (for Postgres at least, the FOR UPDATE was unnecessary since it is already in a transaction block, and actually dangerous as you could leave ha

RE: SQL usage ideas

Maybe I am misunderstanding you, but are you saying there is already a method to pull the data from the database and cache it using 'fastusers'? I do not see anyway to do that... There are a lot reasons to keep the data in a database, look at the NAS table (I realize it is read-on-start for D

RE: SQL usage ideas

, "Roy Walker" <[EMAIL PROTECTED]> piše: >I think I have a pretty good idea of how the sql structure works for radius. >Here are some ideas I have: > >It looks like the clients query is cached at startup (guessing this since I >don't see thousands of queri

SQL usage ideas

I think I have a pretty good idea of how the sql structure works for radius. Here are some ideas I have: It looks like the clients query is cached at startup (guessing this since I don't see thousands of queries to the nas table like I do to the other tables). One really useful option would

SQL read_group patch - please apply!

FOR THE SAKE OF MY SANITY!!! Please apply the patch from http://readlist.com/lists/lists.freeradius.org/freeradius-users/2/10462. html, which was posted 3 and a half months ago! PLEASE, pretty please, with sugar on top! Thanks, Roy - List info/subscribe/unsubscribe? See http://www.fr

RE: SQLIPPool performance issue

Here is the config lines: max_connections = 100 shared_buffers = 400MB temp_buffers = 32MB work_mem = 1MB maintenance_work_mem = 128MB max_fsm_pages = 204800 Didn't change any of these as for my testing I don't have autovacuum enabled. #vacuum_cost_delay = 0 # 0-1000 milliseconds

RE: SQLIPPool performance issue

radippool USING btree (nasipaddress, pool_key, framedipaddress); CREATE INDEX radippool_framedipaddress ON radippool USING btree (framedipaddress); Cheers Peter On Thu 26 Jul 2007, Roy Walker wrote: > Using freeradius-server-snapshot-20070705. > > I have setup a test scenario where rad

RE: SQLIPPool performance issue

they can be optimized. Maybe you are missing an index or two, although you may just have too little I/O capacity. Good luck. Ken On Wed, Jul 25, 2007 at 01:19:04PM -0500, Roy Walker wrote: > I am having a problem with the SQLIPPOOL performance. This is migration > of an existing radius

RE: SQLIPPool performance issue

list Subject: Re: SQLIPPool performance issue On Wed 25 Jul 2007, Roy Walker wrote: > I am having a problem with the SQLIPPOOL performance. This is migration > of an existing radius server using flat user files (old server is > running radius 1.1.0). Hi Roy You don't specify wh

SQLIPPool performance issue

I am having a problem with the SQLIPPOOL performance. This is migration of an existing radius server using flat user files (old server is running radius 1.1.0). Running freeradius-server-snapshot-20070705 on a P4 2.8GHZ machine Database is Postgres 8.1.9 running on a monstrous Sun Opteron mac

2.0.0-pre2 Time?

Don't know if there is an official list of things needed to be done before pre2? It's been a few months, maybe time for a pre2? Roy - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: Adding an attribute to an incoming Access-Request

Added this to the hints file: DEFAULT Suffix == "", Strip-User-Name = No Hint = "GPRS", NAS-Port = 0 Worked. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] s.org] On Behalf Of Roy Walker Sent: Friday, July 06, 2007 3:15 PM To: FreeRadius users

Adding an attribute to an incoming Access-Request

I have played with this a bit and can't seem to get it working... I need to add the "NAS-Port = 0" attribute to an incoming request if it is not set. This is currently breaking my sqlippool config and the upstream partner making the requests is not giving me a NAS-Port attribute. It looks

SIGHUP working?

Is SIGHUP working in CVS? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Useful sqlippool script w/ GPL and copyright

://www.freeradius.org # # 7-05-07 - Author: Roy Walker <[EMAIL PROTECTED]> # Enter the pool-name attribute POOL_NAME=your_pool_name # Set the first 2 octets of the IP network NETWORK=1.1 # Set the starting point of the third octet START_RANGE=1 # Set the ending point of the third octet END

Useful sqlippool script

For those working with sqlippool, I made a quick script which will make it easy for you to create the ip blocks in the radippool table. Might be nice for new users if this was included in the scripts directory. #!/bin/sh # This script will output the necessary INSERT commands # for the sq

Requesting CVS checkin

Back in April the following post was sent out and it is still not in CVS as of July 2nd. Is it possible to get this checked in? http://readlist.com/lists/lists.freeradius.org/freeradius-users/2/11069. html Here is a patch someone posted: http://www.mail-archive.com/freeradius-users@lists.fre