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),
participants (1)
-
Michelle Manning