FreeRadius 1.1.3 and PHPMyPrepaid
Michelle Manning
mmanning at caprarotechnologies.com
Fri Nov 10 17:14:36 CET 2006
I was wondering if anyone has worked the two of these together happily?
I've managed to get Radius configured and running (Thanks guys!). But I
can't
login with a phpmyprepaid user - If I create my own user (very
simplistic) it works, with
no worries, otherwise the user is rejected because of a value in the
database.
Here is an example of the database records.
radcheck is the table.
The create table statement is as follows:
CREATE TABLE `radcheck` (
`id` int(11) unsigned NOT NULL auto_increment,
`UserName` varchar(64) NOT NULL default '',
`FirstName` varchar(40) NOT NULL default '',
`LastName` varchar(40) NOT NULL default '',
`CustID` varchar(5) NOT NULL default '',
`Attribute` varchar(32) NOT NULL default '',
`op` char(2) NOT NULL default '==',
`Value` varchar(253) NOT NULL default '',
`CrDate` timestamp NOT NULL default '0000-00-00 00:00:00',
`creator` varchar(20) default 'NULL',
`Location` smallint(4) default '0',
`activated` smallint(4) NOT NULL default '0',
`activeDate` timestamp NOT NULL default '0000-00-00 00:00:00',
`status` smallint(4) NOT NULL default '0',
`rate` smallint(4) NOT NULL default '1',
`Type` varchar(50) NOT NULL default '',
`BillingPlan` smallint(4) NOT NULL default '0',
`TimeToFinish` smallint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `UserName` (`UserName`(32))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;
id 1 works - username michelle, id 2 fails and the reason given when
running radiusd -X is that it doesn't recognize Max-All-Session. Have I
missed something in the configuration that would set that up for me? Or
am I whistling up a tree trying to get phpmyprepaid to work? I will admit
that it wasn't pleasant getting oddities to work for me in phpmyprepaid,
there were a lot of little things in the code that drove me bonkers....
I am also using DD-WRT on a Linksys, Chillispot, and FreeRadius1.1.3 on
CentOS.
INSERT INTO `radcheck` (`id`, `UserName`, `FirstName`, `LastName`,
`CustID`, `Attribute`, `op`, `Value`, `CrDate`, `creator`, `Location`,
`activated`, `activeDate`, `status`, `rate`, `Type`, `BillingPlan`,
`TimeToFinish`) VALUES
(*1, 'michelle', 'michelle', 'manning', '1', 'Password', ':=',
'michelle', '0000-00-00 00:00:00', 'NULL', 0, 0, '0000-00-00 00:00:00',
0, 1, '', 0, 0)*,
(2, 'tansel6', '', 'tansel6', '', 'Password', ':=', 'tansel6',
'2006-11-09 16:01:52', 'admin', 1, 0, '0000-00-00 00:00:00', 0, 1,
'Hourly', 1, 0),
(3, 'tansel6', '', 'tansel6', '', 'Simultaneous-Use', ':=', '1',
'2006-11-09 16:01:52', 'admin', 1, 0, '0000-00-00 00:00:00', 0, 1,
'Hourly', 1, 0),
(4, 'tansel6', '', 'tansel6', '', '*Max-All-Session*', ':=', '1800',
'2006-11-09 16:01:52', 'admin', 1, 0, '0000-00-00 00:00:00', 0, 1,
'Hourly', 1, 0),
(5, 'tansel6', '', 'tansel6', '', 'WISPr-Location-ID', ':=', '1',
'2006-11-09 16:01:52', 'admin', 1, 0, '0000-00-00 00:00:00', 0, 1,
'Hourly', 1, 0),
(6, 'tansel6', '', 'tansel6', '', 'Expiration', ':=', '09 May 2007
00:00:00', '2006-11-09 16:01:52', 'admin', 1, 0, '0000-00-00 00:00:00',
0, 1, 'Hourly', 1, 0),
More information about the Freeradius-Users
mailing list