On Friday 14 March 2003 19:33, Bryan Koschmann - GKT wrote: > On Fri, 14 Mar 2003, tarvid wrote: > |http://www.frontios.com/freeradius.html got me going. Once "file" > |authentication worked i settled for sql accounting > | > |but i did export an old icradius database by patching in a "==" operator > | and duplicating a couple of fields in the old accounting records. > | > |There is a text to sql converter but I have never used it. > | > |If you are desparate and will settle for less my config notes are around > |someplace. > > Thanks for the link! I think it will give me a better basis on getting > started. > > Would you be able to send me a couple rows from the database, so I can see > some real world examples (nwames changed to protect the customer of course > > :) ) Don't worry about it if it's a hassle, I'm just trying to get a good > > grasp before I dive into all this. > > Thanks, > > Bryan > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html
mysql> select * from radcheck order by username limit 10; +------+---------------+-----------+----+---------------+ | id | UserName | Attribute | op | Value | +------+---------------+-----------+----+---------------+ | 3293 | 24th_virginia | Auth-Type | == | Crypt-Local | | 3294 | 24th_virginia | Password | == | SDAZ49.6SbKeE | | 4293 | 3swyrs | Auth-Type | == | Crypt-Local | | 4294 | 3swyrs | Password | == | $sPrs8fiXWyhM | | 3445 | 4reeces | Auth-Type | == | Crypt-Local | | 3446 | 4reeces | Password | == | RAtLD.G6wNfpU | | 3706 | aaron87 | Auth-Type | == | Crypt-Local | | 3707 | aaron87 | Password | == | $sy4.P1Uto40. | | 3081 | abransco | Auth-Type | == | Crypt-Local | | 3082 | abransco | Password | == | XJW7.LFJYhhXk | +------+---------------+-----------+----+---------------+ mysql> select * from radreply limit 3; +----+-------------+-------------------+----+---------------+ | id | UserName | Attribute | op | Value | +----+-------------+-------------------+----+---------------+ | 12 | hrblock2 | Framed-IP-Address | == | 12.43.223.196 | | 21 | waltersdrug | Framed-IP-Address | == | 12.43.223.198 | | 19 | ford | Framed-IP-Address | == | 12.43.223.194 | +----+-------------+-------------------+----+---------------+ mysql> select * from radacct order by acctstarttime limit 2; +-----------+---------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ | RadAcctId | AcctSessionId | AcctUniqueId | UserName | Realm | NASIPAddress | NASPortId | NASPortType | AcctStartTime | AcctStopTime | AcctSessionTime | AcctAuthentic | ConnectInfo_start | ConnectInfo_stop | AcctInputOctets | AcctOutputOctets | CalledStationId | CallingStationId | AcctTerminateCause | ServiceType | FramedProtocol | FramedIPAddress | AcctStartDelay | AcctStopDelay | +-----------+---------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ | 1546806 | 00000005 | a932bd30c115e6ee | barb | | 66.242.243.1 | 9 | Async | 0000-00-00 00:00:00 | 2003-03-09 22:43:04 | 908 | RADIUS | | | 82565 | 372259 | 2766622040 | | User-Request | Framed-User | PPP | 66.242.243.23 | 0 | 0 | | 1546807 | 00000005 | 4fc67df93aa5df19 | tarvid | | 66.242.243.2 | 30 | Async | 0000-00-00 00:00:00 | 2003-03-09 23:09:16 | 1219 | RADIUS | | | 140943 | 1347807 | 2766622040 | | User-Request | Framed-User | PPP | 66.242.243.73 | 0 | 0 | +-----------+---------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html