PPPoE with FreeRadius and MySQL
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>