Differences

This shows you the differences between two versions of the page.

--- deployment:network:freeradius:install-debian13-sql [2026/04/03 20:35] – [Install MariaDB dan konfigurasi database untuk FreeRadius] ilyasa
+++ deployment:network:freeradius:install-debian13-sql [2026/04/05 17:21] (current) – ilyasa
@@ Line 127: / Line 127: @@
 sudo ln -s /etc/freeradius/3.0/mods-available/sql /etc/freeradius/3.0/mods-enabled/
 </code>
- * Edit Module SQL Untuk Dapat terhubung dengan Database yang telah kita buat
+  * Edit Module SQL Untuk Dapat terhubung dengan Database yang telah kita buat
 <code bash>
 sudo nano /etc/freeradius/3.0/mods-enabled/sql
 </code>
+  * Ubah opsi database dari sqlite (default) ke mysql(mariadb)
 <code bash>
 # Rubah
@@ Line 137: / Line 138: @@
         dialect = "mysql"
 </code>
-* coment ''driver = "rlm_sql_null"''
+  * coment ''driver = "rlm_sql_null"''
 <code bash>
         driver = "rlm_sql_null"
 #       driver = "rlm_sql_${dialect}"
 </code>
-* uncoment ''driver = "rlm_sql_${dialect}"''
+  * uncoment ''driver = "rlm_sql_${dialect}"''
 <code bash>
         driver = "rlm_sql_null"
 #       driver = "rlm_sql_${dialect}"
 </code>
-* Sebab koneksi database bersifat local configurasi tls dapat di comment
+  * Sebab koneksi database bersifat local configurasi tls dapat di comment
 {{ :deployment:network:freeradius:mysql-no-tls-freeradius.png?nolink |}}
-* Uncomment connection info dan ganti sesuai dbname dan passwrod yang telah dibuat
+  * Uncomment connection info dan ganti sesuai dbname dan passwrod yang telah dibuat
-{{ :deployment:network:freeradius:connection_info-sql-freeradius.png?nolink&900 |}}
+{{ :deployment:network:freeradius:connection_info-sql-freeradius.png?nolink&1000 |}}
+==== Running Test ====
+=== Menambahkan RADIUS User ke Database ===
+<code bash>
+mysql -u root -p
+</code>
+<code sql>
+USE radius;
+-- Add user with plain-text password (Cleartext-Password)
+INSERT INTO radcheck (username, attribute, op, value)
+VALUES ('ilyasa', 'Cleartext-Password', ':=', 'pass123');
+-- Optional: add user to a group
+INSERT INTO radusergroup (username, groupname, priority)
+VALUES ('testuser', 'users', 1);
+</code>
+==== Run FreeRadius dengan Debug Mode ====
+<code>
+# Stop and start clean
+sudo systemctl restart freeradius
+# Or run in debug mode (recommended for first test)
+sudo systemctl stop freeradius
+sudo radiusd -X
+</code>