1. Utworzyc wszystkie tabele zwiazane z radiusem w bazie lms'a 2. w tabeli np.: radgroupreply przyklad Akcje id https://ares.starlan.pl/adminpg/display.php?server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=2&sortdir=asc&strings=collapsed&page=1 groupname https://ares.starlan.pl/adminpg/display.php?server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=3&sortdir=asc&strings=collapsed&page=1 attribute https://ares.starlan.pl/adminpg/display.php?server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=4&sortdir=asc&strings=collapsed&page=1 op https://ares.starlan.pl/adminpg/display.php?server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=5&sortdir=asc&strings=collapsed&page=1 value https://ares.starlan.pl/adminpg/display.php?server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=6&sortdir=asc&strings=collapsed&page=1

Edycja https://ares.starlan.pl/adminpg/display.php?action=confeditrow&strings=collapsed&page=1&key%5Bid%5D=5&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= Usuń https://ares.starlan.pl/adminpg/display.php?action=confdelrow&strings=collapsed&page=1&key%5Bid%5D=5&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= 5 pppoe Framed-Compression := Van-Jacobsen-TCP-IP Edycja https://ares.starlan.pl/adminpg/display.php?action=confeditrow&strings=collapsed&page=1&key%5Bid%5D=1&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= Usuń https://ares.starlan.pl/adminpg/display.php?action=confdelrow&strings=collapsed&page=1&key%5Bid%5D=1&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= 1 pppoe Framed-Protocol := PPP Edycja https://ares.starlan.pl/adminpg/display.php?action=confeditrow&strings=collapsed&page=1&key%5Bid%5D=2&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= Usuń https://ares.starlan.pl/adminpg/display.php?action=confdelrow&strings=collapsed&page=1&key%5Bid%5D=2&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= 2 pppoe Framed-IP-Netmask := 255.255.255.255 Edycja https://ares.starlan.pl/adminpg/display.php?action=confeditrow&strings=collapsed&page=1&key%5Bid%5D=4&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= Usuń https://ares.starlan.pl/adminpg/display.php?action=confdelrow&strings=collapsed&page=1&key%5Bid%5D=4&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= 4 pppoe Service-Type := Framed Edycja https://ares.starlan.pl/adminpg/display.php?action=confeditrow&strings=collapsed&page=1&key%5Bid%5D=6&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= Usuń https://ares.starlan.pl/adminpg/display.php?action=confdelrow&strings=collapsed&page=1&key%5Bid%5D=6&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= 6 pppoe MS-Primary-DNS-Server := 172.16.49.3 Edycja https://ares.starlan.pl/adminpg/display.php?action=confeditrow&strings=collapsed&page=1&key%5Bid%5D=7&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= Usuń https://ares.starlan.pl/adminpg/display.php?action=confdelrow&strings=collapsed&page=1&key%5Bid%5D=7&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= 7 pppoe Framed-Routing := Broadcast-Listen Edycja https://ares.starlan.pl/adminpg/display.php?action=confeditrow&strings=collapsed&page=1&key%5Bid%5D=3&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= Usuń https://ares.starlan.pl/adminpg/display.php?action=confdelrow&strings=collapsed&page=1&key%5Bid%5D=3&server=localhost%3A5432&database=lms&schema=public&table=radgroupreply&subject=table&return_url=tblproperties.php%3Fserver%3Dlocalhost%253A5432%26amp%3Bdatabase%3Dlms%26amp%3Bschema%3Dpublic%26table%3Dradgroupreply&return_desc=Wstecz&sortkey=&sortdir= 3 pppoe Framed-MTU := 1480

w załączniku patch do wersji 1.10.1

reszte ustawiam na mikrotiku :)

radius korzysta z bazy lms'a

Pozdro

1073a1074,1086

/* Zmieniamy rowniez wpisy zwiazane z radiusem Start */ $this->DB->Execute('UPDATE radreply SET username=UPPER(?), attribute='Framed-IP-Address', op=':=', value=? WHERE id=?', array($nodedata['name'], $nodedata['ipaddr'], $nodedata['id'])); $this->DB->Execute('UPDATE radcheck SET username=UPPER(?), attribute='User-Password', op=':=', value=? WHERE id=?', array($nodedata['name'], $nodedata['passwd'], $nodedata['id'])); // END

1099a1113,1118

//RADIUS START $this->DB->Execute('DELETE FROM usergroup WHERE username=(SELECT username FROM radcheck WHERE id = ?)', array($id)); $this->DB->Execute('DELETE FROM radcheck WHERE id = ?', array($id)); $this->DB->Execute('DELETE FROM radreply WHERE id = ?', array($id)); //END

1357a1377

1358a1379,1393

    //RADIUS
	$this->DB->Execute('INSERT INTO radreply (id, username, attribute, op, value)
			VALUES (?, ?, \'Framed-IP-Address\', \'=\', ?)',
			array($id,
			    strtoupper($nodedata['name']),
			    $nodedata['ipaddr']));
	$this->DB->Execute('INSERT INTO radcheck (id, username, attribute, op, value)
			VALUES (?, ?, \'User-Password\', \':=\', ?)',
			array($id,
			    strtoupper($nodedata['name']),
			    $nodedata['passwd']));
	$this->DB->Execute('INSERT INTO usergroup VALUES (?, \'pppoe\', 0)',
			array($id,
			    strtoupper($nodedata['name'])));

// $nodedata['location'));

_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms