PPPoE with FreeRadius and MySQL - Revision history

Admin at 13:17, 8 December 2010

2010-12-08T13:17:35Z

← Older revision		Revision as of 16:17, 8 December 2010
Line 179:		Line 179:
	Post-Auth-Type REJECT {		Post-Auth-Type REJECT {
	attr_filter.access_reject		attr_filter.access_reject
			sql
	}		}
	}		}

Admin at 11:23, 8 December 2010

2010-12-08T11:23:24Z

← Older revision		Revision as of 14:23, 8 December 2010
Line 222:		Line 222:
	}		}
	EOF		EOF
			</source>

	In /etc/raddb/sql/mysql/dialup.conf you want: sql_user_name = "%{User-Name}"		In /etc/raddb/sql/mysql/dialup.conf you want: sql_user_name = "%{User-Name}"

Admin at 11:22, 8 December 2010

2010-12-08T11:22:25Z

@@ Line 52: / Line 52: @@
 EOF
-I'll only have myself as a client so in /etc/raddb/clients.conf I just changed the "secret".
+cat << EOF > /etc/raddb/clients.conf
-Add "localhost secret" (replace secret with your secret) in /etc/ppp/radius/servers and set this up in your /etc/ppp/options
+echo "localhost r4d1usP4ssw0rd" > /etc/ppp/radius/servers
 cat << EOF > /etc/raddb/radiusd.conf

Admin at 11:18, 8 December 2010

2010-12-08T11:18:57Z

Show changes

Admin at 13:40, 2 December 2010

2010-12-02T13:40:18Z

← Older revision		Revision as of 16:40, 2 December 2010
Line 73:		Line 73:

	[http://www.frontios.com/freeradius.html FreeRadius with MySQL HowTo Notes]		[http://www.frontios.com/freeradius.html FreeRadius with MySQL HowTo Notes]

			[http://wiki.freeradius.org/SQL_HOWTO SQL HOWTO - FreeRADIUS Wiki]

Admin at 13:39, 2 December 2010

2010-12-02T13:39:39Z

@@ Line 5: / Line 5: @@
 ==HOW==
-On the gentoo machine:
+Be sure to have your gentoo machine up to date ( emerge --sync ). On the gentoo machine:
-Put this in your package.keywords ( so you get the "latest" versions ... they're stable enough )
+Put this in your package.keywords ( so you get the "latest" versions ... they're stable enough ). I'm gonna use MySQL as a backend.
 net-dialup/rp-pppoe ** <br/>
@@ Line 21: / Line 21: @@
 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">
+<source lang="bash">
 mysql -u root -p < admin.sql
 mysqladmin -p create radius
 mysql -u root -p -D radius < schema.sql
-</script>
+mysql -u root -p -D radius < nas.sql

Admin: 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 …'

2010-12-02T11:07:47Z

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 …'

New page

==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 ** <br/>
net-dialup/ppp ** <br/>

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

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

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>