Hi Michael I had the same problem. If you remove the part of line 4 that says "DEFAULT '0'" it'll run fine.
Cheers, Justin. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Cooper Sent: 21 May 2005 05:11 PM To: freeradius-users@lists.freeradius.org Subject: Re: Dialup Admin Hi everyone, Iam very new to this and I really need help here, I am trying to install Dialup Admin and I got the Database configured and I have two of the 4 .sql files in however two of the files are giving me a problem and here it is: I type this at the command prompt: mysql -u root -p radius < badusers.sql and this is the reponse I get: ERROR 1067 (42000) at line 4: invalid default value for 'id': I haven't got a clue where to look for, or how to fix this, can anyone point me in the right direction please. I am checking faqs on the site but i don't see anything pertaining to this. Thanks, Michael A Cooper BCCISP.net http://www.bccisp.net 281-854-2079 "Technology that counts, voices that matter!" ----- Original Message ----- From: "Alan DeKok" <[EMAIL PROTECTED]> To: <freeradius-users@lists.freeradius.org> Sent: Friday, May 20, 2005 3:54 PM Subject: Re: (no subject) > "John Riggs" <[EMAIL PROTECTED]> wrote: >> >> A local user can log on but a user using the default system password file >> can not log on. I've look at the debug but I'm not sure I understand the >> problem and how to correct it. I believe this is the problem; modcall: >> entering group authenticate, modcall[authenticate]: module "unix" returns >> notfound, > > The user wasn't found in /etc/passwd? Why would he be able to > authenticate? > > Alan DeKok. > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.322 / Virus Database: 266.11.14 - Release Date: 5/20/2005 > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html