PPPoE with FreeRadius and MySQL

From D3xt3r01.tk
Revision as of 14:07, 2 December 2010 by Admin (talk | contribs) (Created page with '==WHY== At my old ISP I setup the PPPoE server with the authentication part .. and I forgot how to do it again at my new workplace .. I'll take notes this time ==HOW== On the …')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

WHY

At my old ISP I setup the PPPoE server with the authentication part .. and I forgot how to do it again at my new workplace .. I'll take notes this time

HOW

On the gentoo machine:

Put this in your package.keywords ( so you get the "latest" versions ... they're stable enough )

net-dialup/rp-pppoe **
net-dialup/ppp **

Put this in your package.use ( this will set the support for packages

net-dialup/ppp radius
dev-db/mysql -minimal
net-dialup/freeradius mysql threads

And do an "emerge mysql freeradius rp-pppoe". If this is a new mysql installation .. don't forget to "mysql_install_db && /etc/init.d/mysql start && mysql_secure_installation".

I'll only have myself as a client so in /etc/raddb/clients.conf I just changed the "secret".

Edit /etc/raddb/sql/mysql/admin.sql and change the default "radpass" to something more convenient to you. Then do

<script lang="bash"> mysql -u root -p < admin.sql mysqladmin -p create radius mysql -u root -p -D radius < schema.sql </script>