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