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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
