Forum Debian Users Gang

http://linux.usr.ro/pppoe/

szkoda ze nie po angielsku albo po polsku.

no i ten artykul [url]http://linux.usr.ro/pppoe/[/url] mi pomogl. ruszylo.
zastosowalem sie rowniez do artykulu [url]http://netkod.pl/pppoe/[/url] i dziala z lms'em - ale nie do konca dobrze i to nie jest to czego oczekuje. chcialbym dodatkowo filtrowac po mac'adresie czyli  mac > login > haslo

zastanawiam sie teraz jak przerobic freeradiusa, zeby korzystal z danych w bazie lms'a.

czy da sie zmusic freeradiusa+mysql, zeby pobieral dane z innej bazy??
dla radiusa zalkada sie m.in. taka tabele w bazie:

CREATE TABLE radcheck (
  id int(11) unsigned NOT NULL auto_increment,
  UserName varchar(64) NOT NULL default '',
  Attribute varchar(32)  NOT NULL default '',
  op char(2) NOT NULL DEFAULT '==',
  Value varchar(253) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY UserName (UserName(32))
) ;

w bazie lms jest tabela nodes, w ktorej trzymane sa wszstkie dane o hoscie:
CREATE TABLE nodes (
  id int(11) NOT NULL auto_increment,
  name varchar(16) NOT NULL default '',
  mac varchar(20) NOT NULL default '',
  ipaddr int(16) unsigned NOT NULL default '0',
  ipaddr_pub int(16) unsigned NOT NULL default '0',
  passwd varchar(32) NOT NULL default '',
  ownerid int(11) NOT NULL default '0',
  creationdate int(11) NOT NULL default '0',
  moddate int(11) NOT NULL default '0',
  creatorid int(11) NOT NULL default '0',
  modid int(11) NOT NULL default '0',
  netdev int(11) NOT NULL default '0',
  linktype tinyint(1) NOT NULL default '0',
  access tinyint(1) NOT NULL default '1',
  warning tinyint(1) NOT NULL default '0',
  lastonline int(11) NOT NULL default '0',
  info text NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name),
  UNIQUE KEY ipaddr (ipaddr),
  INDEX netdev (netdev)
) TYPE=MyISAM;

w configu radiusa sql.conf sa linie:
----------------
authcheck_table = "radcheck"
[..]
authorize_check_query = "SELECT id, UserName, Attribute, Value, op
          FROM ${authcheck_table}
          WHERE Username = '%{SQL-User-Name}'
          ORDER BY id"
authorize_reply_query = "SELECT id, UserName, Attribute, Value, op
          FROM ${authreply_table}
          WHERE Username = '%{SQL-User-Name}'
          ORDER BY id"
authorize_group_check_query = "SELECT
${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value,${groupcheck_table}.op
FROM ${groupcheck_table},${usergroup_table} WHERE
${usergroup_table}.Username = '%{SQL-User-Name}' AND
${usergroup_table}.GroupName = ${groupcheck_table}.GroupName ORDER BY
${groupcheck_table}.id"
authorize_group_reply_query = "SELECT
${groupreply_table}.id,${groupreply_table}.GroupName,${groupreply_table}.Attribute,${groupreply_table}.Value,${groupreply_table}.op
FROM ${groupreply_table},${usergroup_table} WHERE
${usergroup_table}.Username = '%{SQL-User-Name}' AND
${usergroup_table}.GroupName = ${groupreply_table}.GroupName ORDER BY
${groupreply_table}.id"
----------------------

jak to przerobic aby z bazy lms, z tabeli nodes wyciagnal te dane ktore mu
sa potrzebne?
prawie wszystkie dane zawarte w tabeli "radcheck" sa rowniez w tabeli "nodes" lms'a. wiec cane musialby pobrac z dwoch tabel jednoczesnie.
czy da sie tak zrobic jak ja mysle??