Re: trying to use Post-Auth-Type REJECT to insert users

2009-03-21 Thread Arran Cudbard-Bell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave Sinclair wrote: Hi, Their isnt' a backup. So I'm having problems with: postauth_query = INSERT INTO ${authcheck_table} VALUES (NULL,'%{User-Name}','Password', '==', '%{User-Password:-Chap-Password}'); postauth_query = INSERT INTO

Re: trying to use Post-Auth-Type REJECT to insert users

2009-03-15 Thread tnt
The high level goal is to have a new radius server slurp all the users on a DSL ATM aggregation link into a SQL database. We are taking over a bunch of users from a defunct ISP and don't have the UserName / Password data. What I'm thinking is that there should be a way to have Post-Auth-Type

Re: trying to use Post-Auth-Type REJECT to insert users

2009-03-15 Thread Fajar A. Nugraha
On Sun, Mar 15, 2009 at 4:35 PM, t...@kalik.net wrote: Is there a better way ?? Don't they have a backup of their user database on a tape/DVD? Unlikely. We had a similar situation once (also with DSL ATM), and the only user data we got was usernames and encrypted (with some unknown

Re: trying to use Post-Auth-Type REJECT to insert users

2009-03-15 Thread Dave Sinclair
Hi, Their isnt' a backup. So I'm having problems with: postauth_query = INSERT INTO ${authcheck_table} VALUES (NULL,'%{User-Name}','Password', '==', '%{User-Password:-Chap-Password}'); postauth_query = INSERT INTO ${usergroup_table} values ('%{User-Name}','Dynamic',''); I

trying to use Post-Auth-Type REJECT to insert users

2009-03-14 Thread Dave Sinclair
Hi, The high level goal is to have a new radius server slurp all the users on a DSL ATM aggregation link into a SQL database. We are taking over a bunch of users from a defunct ISP and don't have the UserName / Password data. What I'm thinking is that there should be a way to have Post-Auth-Type