Thanx Frank, that's it.
The target has 6 fields and the table of freeradius-0.4 has 4 fields. I
appended manually two fields ('NULL', '0') per row and afterwards the
insertion was possible. I wonder if there is a more elegant way to
convert the tables. Seems more a MySQL than Freeradius Question to me.
Nice day
-Oliver
>>>>>>>>>>>>>>>>>> Urspr�ngliche Nachricht <<<<<<<<<<<<<<<<<<
Am 25/03/02, 02:44:06, schrieb tywe <[EMAIL PROTECTED]> zum Thema Re: 0.4 ->
0.5 and MySQL tables:
> Oliver,
> I don't know much about FreeRADIUS, but I do know that the MySQL error
your
> getting is because your VALUES aren't matching the number of columns in
the
> radcheck table. Go look at the radcheck table (desc radcheck) and see how
> many columns there are. Must be more or less than the 4 you are giving
it.
> Hope that helps
> Frank
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, March 24, 2002 11:04 AM
> Subject: 0.4 -> 0.5 and MySQL tables
> I am looking for a way to transfer the radius-data from 0.4 in the new
> mysql-data-scheme of 0.5.
> For example I did a Data-Dump with phpMyAdmin of the usergroup-table and
> re-inserted
> them in the new usergroup-table coming with 0.5, like this:
> INSERT INTO usergroup VALUES (1, 'benni', 'flatrate');
> INSERT INTO usergroup VALUES (2, 'max', 'flatrate');
> etc.
> But this procedure doesn't work with the tables radgroupcheck or radcheck
> for example, when I get errors like this:
> Error
> SQL-query :
> INSERT INTO radcheck VALUES (2, 'bob', 'Password', '13starX1')
> MySQL said:
> Column count doesn't match value count at row 1
> I am not so deep into databases, so how can I make the existing data
> "fit" into the new table structure from freeradius 0.5?
> Thanks in advance
> Oliver
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
