radius\u30b5\u30fc\u30d0\u306e\u69cb\u7bc9\u5b9f\u9a13
FreeBSD-12.0
\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u30b5\u30fc\u30d0\u30bd\u30d5\u30c8
\u307b\u3068\u3093\u3069pkg\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb
apache24
MariaDB104
PHP7.2
pkg install -y php72 mod_php72 php72-mysqli php72-xml php72-hash php72-gd php72-curl php72-tokenizer php72-zlib php72-extensions php72-mbstring php72-fileinfo php72-fileinfo php72-pdo_mysql php72-pecl-APCu php72-pear php72-pear-DB
freeradius3
radiusd.conf
$INCLUDE mods-enabled\/sql\u3092\u6709\u52b9\u306b\u3059\u308b
<\/p>\n\n\n\n
\u30ed\u30b0\u53d6\u308a\u3092\u53ef\u80fd\u306b\u3059\u308b
sed -i -e ‘s\/^\\tauth = no\/\\tauth = yes\/g’ \/usr\/local\/\/etc\/raddb\/radiusd.conf
sed -i -e ‘s\/^\\tauth_badpass = no\/\\tauth_badpass = yes\/g’ \/usr\/local\/\/etc\/raddb\/radiusd.conf
sed -i -e ‘s\/^\\tauth_goodpass = no\/\\tauth_goodpass = yes\/g’ \/usr\/local\/\/etc\/raddb\/radiusd.conf
\/usr\/local\/etc\/raddb\/mods-enabled\/sql\u3092\u8ffd\u52a0 <\/p>\n\n\n\n
sql {\n driver = \"rlm_sql_mysql\"\n dialect = \"mysql\"\n server = \"localhost\"\n port = 3306\n login = \"radius\"\n password = \"passsword\"\n radius_db = \"radius\"\n acct_table1 = \"radacct\"\n acct_table2 = \"radacct\"\n postauth_table = \"radpostauth\"\n authcheck_table = \"radcheck\"\n groupcheck_table = \"radgroupcheck\"\n authreply_table = \"radreply\"\n groupreply_table = \"radgroupreply\"\n usergroup_table = \"radusergroup\"\n delete_stale_sessions = yes\n pool {\n start = ${thread[pool].start_servers}\n min = ${thread[pool].min_spare_servers}\n max = ${thread[pool].max_servers}\n spare = ${thread[pool].max_spare_servers}\n uses = 0\n retry_delay = 30\n lifetime = 0\n idle_timeout = 60\n }\n read_clients = yes\n client_table = \"nas\"\n group_attribute = \"SQL-Group\"\n $INCLUDE ${modconfdir}\/${.:name}\/main\/${dialect}\/queries.conf\n }\nmysql -u radius -p radius < \/usr\/local\/etc\/raddb\/mods-config\/sql\/main\/mysql\/schema.sql<\/code><\/pre>\n\n\n\n
daloradius
daloradius.conf.php\u3092\u7de8\u96c6
www\u30e6\u30fc\u30b6\u306b\u3066\u66f8\u304d\u8fbc\u307f\u53ef\u80fd\u306b\u3059\u308b
<\/p>\n\n\n\n
$configValues[‘CONFIG_DB_HOST’] = ‘localhost’;
$configValues[‘CONFIG_DB_PORT’] = ‘3306’;
$configValues[‘CONFIG_DB_USER’] = ‘radius’;
$configValues[‘CONFIG_DB_PASS’] = ‘password’;
$configValues[‘CONFIG_DB_NAME’] = ‘radius’;<\/p>\n\n\n\n
mysql -u radius -p radius < fr2-mysql-daloradius-and-freeradius.sql
\nmysql -u radius -p radius < mysql-daloradius.sql<\/p>\n\n\n\n
\u3053\u3093\u306a\u611f\u3058
<\/p>\n","protected":false},"excerpt":{"rendered":"
radius\u30b5\u30fc\u30d0\u306e\u69cb\u7bc9\u5b9f\u9a13FreeBSD-12.0\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u30b5\u30fc\u30d0\u30bd\u30d5\u30c8 … \u7d9a\u304d\u3092\u8aad\u3080