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` ;
This comment has been removed by the author.
ReplyDeleteThank you, it's useful.
ReplyDeleteI thank you, sir.
ReplyDelete