Re: session updates

2007-08-21 Thread Douglas Lane
On 8/20/07, Alan DeKok [EMAIL PROTECTED] wrote: Fred Zinsli wrote: This is a wifi system, so we are using chillispot as a captive portal with hotcakes as a manager. Hence when an unautherized user attempts to use the network there requests are trapped and they have to logon via a web

Chap password to user password

2007-08-21 Thread Carl aniams
hi Alan, i was able to fix it in chillispot by uncommenting the user password thanks a lot for your assistance -- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ ANIAMBOSSOU Carl NIAMS TECHNOLOGIES tel: +229 90 04 08 58 +229 97 48 01 33 COTONOU REPUBLIC OF BENIN WEST AFRICA - List

RE: PAM Radius

2007-08-21 Thread Sayan S
yes josh, as you guessed it, it doesn't work with HP-UX and Solaris (to some extent, as it provides a warning during useradd command with '@' in the username). We don't plan to use LDAP for NSS immediately. thanks to all. sayan Josh Howlett [EMAIL PROTECTED] wrote: Hi Sayan, I think I have

customise dialup admin

2007-08-21 Thread Carl aniams
Hi i'm presently using dialup admin for client connexion to the net. but my handicap is the time counter. i would like to know if it would be possible to set graphical time counter for a customer . also is it possible to increase the time limit for a customer that may require an hour more. if yes

Database Population problem with mysql

2007-08-21 Thread ram
Hi iam trying to populate mysql datatabase iam getting following error any suggstions mysql -u root -ppassword radius mysql.sql ERROR 1067 (42000) at line 15: Invalid default value for 'AcctStartTime' line 15 looks like below AcctStartTime datetime NOT NULL default '-00-00 00:00:00',

RE: Database Population problem with mysql

2007-08-21 Thread Josh Howlett
(42000) at line 15: Invalid default value for 'AcctStartTime' Try using a valid value for this. josh. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: I am a first timer !

2007-08-21 Thread Alan DeKok
Joshua Mashiane wrote: The problem comes when i have to configure it so Windows XP machine can connect, i have followed lots and lots of tutorial i don't even remember what i did, That's a bit of a problem. Administrating systems by randomly changing things isn't a good practice. Now this

Re: Database Population problem with mysql

2007-08-21 Thread ram
On 8/21/07, Josh Howlett [EMAIL PROTECTED] wrote: (42000) at line 15: Invalid default value for 'AcctStartTime' Try using a valid value for this. Hi what is the correct value for that record as per the document iam populating iam using mysql mysql Ver 14.12 Distrib 5.0.32, for

RE: Database Population problem with mysql

2007-08-21 Thread Josh Howlett
Post mysql.sql to the list. josh. -Original Message- From: ram [mailto:[EMAIL PROTECTED] Sent: 21 August 2007 16:29 To: FreeRadius users mailing list Cc: Josh Howlett Subject: Re: Database Population problem with mysql On 8/21/07, Josh Howlett [EMAIL PROTECTED] wrote:

Re: Database Population problem with mysql

2007-08-21 Thread ram
On 8/21/07, Josh Howlett [EMAIL PROTECTED] wrote: Post mysql.sql to the list. ### # db_mysql.sql rlm_sql - FreeRADIUS SQL Module # #

RE: Database Population problem with mysql

2007-08-21 Thread Josh Howlett
Not sure why this is failing; FWIW, according to the MySQL docs: The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in '-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '-12-31

Re: Database Population problem with mysql

2007-08-21 Thread Don Krause
I know I'm a newb here, and I'm not a Mysql expert, but it looks to me like '-00-00 00:00:00 is clearly outside the allowed range, if that range is published as '1000-01-01 00:00:00' - '-12-31 23:59:59' On Aug 21, 2007, at 8:59 AM, ram wrote: On 8/21/07, Josh Howlett [EMAIL

Re: Database Population problem with mysql

2007-08-21 Thread ram
On 8/21/07, Josh Howlett [EMAIL PROTECTED] wrote: Not sure why this is failing; FWIW, according to the MySQL docs: The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in '-MM-DD HH:MM:SS' format. The

Strange problem

2007-08-21 Thread Sean Bracken
/attachments/20070821/8287c4ad/attachment-0001.html -- Message: 2 Date: Tue, 21 Aug 2007 15:32:04 +0200 From: Carl aniams [EMAIL PROTECTED] Subject: customise dialup admin To: freeradius-users@lists.freeradius.org Message-ID: [EMAIL PROTECTED] Content-Type

Re: Database Population problem with mysql

2007-08-21 Thread A . L . M . Buxey
Hi, I know I'm a newb here, and I'm not a Mysql expert, but it looks to me like '-00-00 00:00:00 is clearly outside the allowed range, if that range is published as '1000-01-01 00:00:00' - '-12-31 23:59:59' just what i was thinking - but its worked until now ..hang on... nope.

Re: Database Population problem with mysql

2007-08-21 Thread ram
On 8/21/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I know I'm a newb here, and I'm not a Mysql expert, but it looks to me like '-00-00 00:00:00 is clearly outside the allowed range, if that range is published as '1000-01-01 00:00:00' - '-12-31 23:59:59' just what i was

Re: Database Population problem with mysql

2007-08-21 Thread Don Krause
That's what I get for thinking... I just tried that, ie: create table test (dt datetime NOT NULL default '-00-00 00:00:00'); on mysql 3,4 and 5. No problems. At least not with 'C' or 'en_US' locales set. Sorry for wasting the bandwidth... On Aug 21, 2007, at 10:26 AM, [EMAIL PROTECTED]

2.0.0pre1 not starting when reading NAS from mysql

2007-08-21 Thread Roberto Greiner
I'm having a problem with 2.0.0pre1. I'm using a clean install. All I changed were entries to enable mysql. The lines I uncommented where the sql entries in authorize, accounting and session, and I commented the files entry in authorize{}. I also commented the 'unix' line in authorize to avoid

Re: Database Population problem with mysql

2007-08-21 Thread A . L . M . Buxey
Hi, mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 hmm, what is your LOCALE? (and if you change the schema to default value of 1000-01-01 00:00:00 does it work?) alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: 2.0.0pre1 not starting when reading NAS from mysql

2007-08-21 Thread A . L . M . Buxey
Hi, I'm having a problem with 2.0.0pre1. o funny - we just came across this ourselves recently! you cannot have a DUPLICATE entry in the naslist any more since 1.1.x series. your entry in the naslist is the same as one in clients.conf - simply make the entry in clients.conf obsolete - eg

Re: 2.0.0pre1 not starting when reading NAS from mysql

2007-08-21 Thread Roberto Greiner
Yup, that solved it. :-) thank you very much Roberto [EMAIL PROTECTED] wrote: Hi, I'm having a problem with 2.0.0pre1. o funny - we just came across this ourselves recently! you cannot have a DUPLICATE entry in the naslist any more since 1.1.x series. your entry in the naslist is

Freeradius, OpenLDAP and Cisco Switch

2007-08-21 Thread Diego Woitasen
Hi, I am configuring a freeradius authenticating against a OpenLDAP. The tests with radtest and radclient worked fine, but I have problems with a Cisco Switch. Running radiusd -f -x I get the following output: rad_recv: Access-Request packet from host 10.0.0.72:1645, id=7, length=76

Re: 2.0.0pre1 not starting when reading NAS from mysql

2007-08-21 Thread Alan DeKok
Roberto Greiner wrote: I'm having a problem with 2.0.0pre1. Please use the CVS head. I think I'll remove 2.0.0pre1 from the web site. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Strange problem

2007-08-21 Thread Alan DeKok
Sean Bracken wrote: Hi, I am using Freeradius with a MySQL backend and the users log in through Chillispot running on Buffalo and Linksys routers running DD-WRT. The problem is that randomly users are recorded up to five times in radacct with one login. This is not a problem for users with

Re: Freeradius, OpenLDAP and Cisco Switch

2007-08-21 Thread Alan DeKok
Diego Woitasen wrote: a Cisco Switch. Running radiusd -f -x I get the following output: And why not -X? rad_recv: Access-Request packet from host 10.0.0.72:1645, id=7, length=76 ... User-Password = \023\r)N-\323\344\377q\257\350\316JK\224\364 The shared secret is wrong. Fix it.