hey
i can' seem to get the sql module working again.
i moved all the data to the new table structure but when i try to run
radiusd i get an error saying:
radiusd: radiusd.conf: "SQL" modules aren't allowed in 'authenticate'
sections -- they have no such method.
i loaded the module in authorize, but how do i tell radiusd to use it?
thanks :)
> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
