Wednesday, February 16, 2011

Freeradius 2 with mysql setting ,cannot start by the as error,



Wed Jun  9 09:38:56 2010 : Info: rlm_sql (sql): Connected new DB handle, #4
Wed Jun  9 09:38:56 2010 : Error: rlm_sql (sql): database query error, SELECT id, nasname, shortname, type, secret, server FROM nas: Unknown column 'server' in 'field list'
Wed Jun  9 09:38:56 2010 : Error: Failed to load clients from SQL.
Wed Jun  9 09:38:56 2010 : Info: rlm_sql (sql): Closing sqlsocket 4
Wed Jun  9 09:38:56 2010 : Info: rlm_sql (sql): Closing sqlsocket 3
Wed Jun  9 09:38:56 2010 : Info: rlm_sql (sql): Closing sqlsocket 2
Wed Jun  9 09:38:56 2010 : Info: rlm_sql (sql): Closing sqlsocket 1
Wed Jun  9 09:38:56 2010 : Info: rlm_sql (sql): Closing sqlsocket 0
Wed Jun  9 09:38:56 2010 : Error: /etc/freeradius/sql.conf[22]: Instantiation failed for module "sql"
Wed Jun  9 09:38:56 2010 : Error: /etc/freeradius/sites-enabled/default[159]: Failed to load module "sql".
Wed Jun  9 09:38:56 2010 : Error: /etc/freeradius/sites-enabled/default[62]: Errors parsing authorize section.
Wed Jun  9 09:38:56 2010 : Error: Failed to load virtual server <default>



    mysql> ALTER TABLE `radius`.`nas` ADD COLUMN `server` VARCHAR(45) NOT NULL AFTER `secret` ;




    3 comments: