(pt-BR) Olá Marcos,
Eu tinha me deparado com este mesmo problema a um tempo atrás, eu retirei o default e mudei de Date para IncidentDate, isso resolveu.
----
(en-US) Hi, Marcos,
I saw this problem a time ago, I delete the default in ID and replace Date to IncidentDate, appers to work fine.
--------------------------------------------------------------------------------
I was making some tests with the freeradius 2 install, and found that
the
creation schema for the "badusers" table for dialupadmin (in the
/dialup_admin/sql/mysql folder) has 2 problems:
#
# Table
structure for table 'badusers'
#
CREATE TABLE badusers (
id
int(10) DEFAULT '0' NOT NULL auto_increment,
UserName varchar(30),
IncidentDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
Reason
varchar(200),
Admin varchar(30) DEFAULT '-',
PRIMARY KEY (id),
KEY UserName (UserName),
KEY Date (Date)
);
The
first is in the 'id' creation line. Starting with version 4.11 (I
think its
this version), MySQL does not accept having a default value
when you use
auto_increment. So, "id int(10) NOT NULL auto_increment"
would be
the correct entry.
The second problem is in the last line. There is a
reference to 'Date'
beeing used as key, but the 'Date' was not created.
There is no
reference creating it. Checking version 1.1.7, the line was
" Date
datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,". Now,
was it removed
because it's no longer used, or was it removed by accident,
ir should it
be renamed to the "IncidentDate" field? I guess it
would be the last
option....
Thanks,
Roberto
--
-----------------------------------------------------
Marcos Roberto Greiner
Os otimistas acham que estamos no
melhor dos mundos
Os pessimistas tem medo de que isto seja verdade
Murphy
-----------------------------------------------------
-
List
info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------------------------------------
Acelerador POP
Acelere a sua conexão discada em até 19 x. Use o Acelerador POP. É grátis, pegue já o seu.
http://www.pop.com.br/acelerador
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
