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
