Error in DB

[Michael Cooper]

Hey Guys,

       I am trying to install the freeradius in sql on my server when I do 
the db dump I get the following error:

mysql -uxxxx -pxxxxxx radius < db_mysql.sql
ERROR 1067 (42000) at line 155: Invalid default value for 'id'

This is the line in question:

->  id int(10) DEFAULT '0' NOT NULL auto_increment, <--
Does anyone know How I can fix this problem?

Thanks in Advance,
Michael A Cooper
BCCISP.net
http://www.bccisp.net
281-854-2079
"Technology that counts, voices that matter!"
----- Original Message ----- 
From: "Alan DeKok" <aland at ox.org>
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Sent: Saturday, June 18, 2005 10:52 AM
Subject: Re: 'authorize' module


> Edgars Klavinskis <edzix19 at inbox.lv> wrote:
>> it not required for me to check this in authenticate section, i just
>> though it is the only place where I could check these passwd attributes.
>> Can you please tell me how to check them in authorize section assuming
>> that they are added to config_items?
>
>  In the CVS head, rlm_policy.  In 1.0.x, you can't.
>
>  You also can't check them in the authenticate section in 1.0.x.
> It's a rare enough request that the server doesn't do it.
>
>  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.323 / Virus Database: 267.7.8/22 - Release Date: 6/17/2005
>
>