{"id":852,"date":"2020-04-02T18:58:25","date_gmt":"2020-04-02T16:58:25","guid":{"rendered":"https:\/\/blog.mhasin.eu\/?p=852"},"modified":"2020-04-14T10:27:24","modified_gmt":"2020-04-14T08:27:24","slug":"debian-freeradius-sql-instalacia","status":"publish","type":"post","link":"https:\/\/blog.mhasin.eu\/?p=852","title":{"rendered":"Debian freeradius SQL in\u0161tal\u00e1cia"},"content":{"rendered":"\n<figure class=\"wp-block-embed-wordpress wp-block-embed is-type-wp-embed is-provider-blog\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"JVqofh8ZC5\"><a href=\"https:\/\/blog.mhasin.eu\/?p=829\">Debian in\u0161tal\u00e1cia mariadb<\/a><\/blockquote><iframe loading=\"lazy\" title=\"\u201cDebian in\u0161tal\u00e1cia mariadb\u201d \u2014 BLOG\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"https:\/\/blog.mhasin.eu\/?p=829&embed=true#?secret=JVqofh8ZC5\" data-secret=\"JVqofh8ZC5\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In\u0161tal\u00e1cia radius serveru:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>apt install freeradius freeradius-mysql\nsystemctl enable freeradius<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Import MYSQL \u0161trukt\u00fary:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/etc\/freeradius\/3.0\/mods-config\/sql\/main\/mysql\/\nmysql -u root radius < schema.sql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Vytvorenie tabu\u013eky pre z\u00e1pis pou\u017e\u00edvate\u013eov s \u010dasov\u00fdm obmedzen\u00edm:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" decoding=\"async\" width=\"1016\" height=\"595\" src=\"https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/04\/image-1.png\" alt=\"\" class=\"wp-image-864\" srcset=\"https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/04\/image-1.png 1016w, https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/04\/image-1-300x176.png 300w, https:\/\/blog.mhasin.eu\/wp-content\/uploads\/2020\/04\/image-1-768x450.png 768w\" sizes=\"auto, (max-width: 1016px) 100vw, 1016px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>--\n-- Datab\u00e1za: `radius`\n--\n\n-- --------------------------------------------------------\n\n--\n-- \u0160trukt\u00fara tabu\u013eky pre tabu\u013eku `real_radcheck`\n--\n\nCREATE TABLE `real_radcheck` (\n  `id` int(11) NOT NULL,\n  `username` varchar(64) NOT NULL DEFAULT '',\n  `attribute` varchar(32) NOT NULL DEFAULT 'Cleartext-Password',\n  `op` char(2) NOT NULL DEFAULT ':=',\n  `value` varchar(253) NOT NULL DEFAULT '',\n  `created` timestamp NOT NULL DEFAULT current_timestamp(),\n  `starts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `expire` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `tukeid` varchar(9) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\n\n--\n-- K\u013e\u00fa\u010de pre exportovan\u00e9 tabu\u013eky\n--\n\n--\n-- Indexy pre tabu\u013eku `real_radcheck`\n--\nALTER TABLE `real_radcheck`\n  ADD PRIMARY KEY (`id`);\n\n--\n-- AUTO_INCREMENT pre exportovan\u00e9 tabu\u013eky\n--\n\n--\n-- AUTO_INCREMENT pre tabu\u013eku `real_radcheck`\n--\nALTER TABLE `real_radcheck`\n  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Vytvorenie poh\u013eadu pre tabu\u013eku radcheck. Tento poh\u013ead zabezpe\u010d\u00ed na\u010d\u00edtanie iba u\u017e\u00edvate\u013eov s platn\u00fdmi \u00fadajmi pod\u013ea d\u00e1tumu starts a expire. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE or replace VIEW `radcheck` AS select `real_radcheck`.`id` AS `id`,CONCAT(`real_radcheck`.`id`,'@iguest') AS `username`,`real_radcheck`.`attribute` AS `attribute`,`real_radcheck`.`op` AS `op`,`real_radcheck`.`value` AS `value` from `real_radcheck` where current_timestamp() between `real_radcheck`.`starts` and `real_radcheck`.`expire`<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Zabezpe\u010denie automatick\u00e9ho mazania star\u00fdch z\u00e1znamov z datab\u00e1zy star\u0161\u00edch ako 5 dn\u00ed po d\u00e1tume exspir\u00e1cie:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>0 * * * * echo \"DELETE FROM radius.real_radcheck WHERE  datediff(now(), radius.real_radcheck.expire) > 5;\" | mysql -u root\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Uprava freeradius SQL config<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/freeradius\/3.0\/mods-available\/sql<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>driver = \"rlm_sql_mysql\"\ndialect = \"sqlite\"\nserver = \"localhost\"\nport = 3306\nlogin = \"radius\"\npassword = \"radpass\"\nradius_db = \"radius\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">povolenie SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/etc\/freeradius\/3.0\/mods-enabled\nln -s ..\/mods-available\/sql .<\/code><\/pre>\n<div class=\"pdf24Plugin-cp\"> \t<form name=\"pdf24Form0\" method=\"post\" action=\"https:\/\/doc2pdf.pdf24.org\/wordpress.php\" target=\"pdf24PopWin\" onsubmit=\"var pdf24Win = window.open('about:blank', 'pdf24PopWin', 'resizable=yes,scrollbars=yes,width=600,height=250,left='+(screen.width\/2-300)+',top='+(screen.height\/3-125)+''); pdf24Win.focus(); if(typeof pdf24OnCreatePDF === 'function'){void(pdf24OnCreatePDF(this,pdf24Win));}\"> \t\t<input type=\"hidden\" name=\"blogCharset\" value=\"Cw1x07UAAA==\" \/><input type=\"hidden\" name=\"blogPosts\" value=\"MwQA\" \/><input type=\"hidden\" name=\"blogUrl\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLQUA\" \/><input type=\"hidden\" name=\"blogName\" value=\"c\/LxdwcA\" \/><input type=\"hidden\" name=\"blogValueEncoding\" value=\"gzdeflate base64\" \/><input type=\"hidden\" name=\"postId_0\" value=\"szA1AgA=\" \/><input type=\"hidden\" name=\"postTitle_0\" value=\"c0lNykzMU0grSk0tSkzJLC1WCA70UcjMO7qwJDHn8MLkzEQA\" \/><input type=\"hidden\" name=\"postLink_0\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLdW3L7C1MDUCAA==\" \/><input type=\"hidden\" name=\"postAuthor_0\" value=\"y00syfcwNAIA\" \/><input type=\"hidden\" name=\"postDateTime_0\" value=\"MzIwMtA1MNE1MFIwtLAyMLEyMgUA\" \/><input type=\"hidden\" name=\"postContent_0\" value=\"rVfbUttIEH3XV3QpVQFvIUu2gRBsedfBTsKGS5aYpMiLGUuDPYukUUYjG7v2F\/IPy2Me+IFUhRfDf23P+Ao2l5AVLkYz3dPd03P6IqN0wlqpoOAFJElcsxtbzYB7pxYNm9S3ulz4saBJAjcJwBJL9mJq4fJkIRa8w3wqFGPLLJd81lksttHoChLHVJhlo6TXv6Rcztqg2Xw0wOORpJE0wSeSWAn1BJWu+efHL\/ykvfF5aw3VEGgLeuKabSnjZNO2lfZs2CYJi7I0tX+P3Y38S7NcpU1GImDR9bkkweDcYwRCIhjxmyWblEv21JByiZ0IElIIOPFZ1HLNgPR7JkgmA+qaz59t5PNO8R6BmiNXBDXm8kV4tbP\/xrz3eAmJ\/CY\/c00SBLxrJZ5gsUxwnXqpYLLnmngLUjBPUh9XZU8ZEvOEScajTSDNhAeppEVUwuJNENSTy7n4bAVu\/MsUca\/wHvDV82dOYaOobXSlSOmz30d+n3H7nfcBXebLtmuuO44JbcpabaQXChsmaJc2EVBUuCYS0VctFo3YJ\/PxFlxAJ\/Ag0P6POF60PbwVxIyN0ML5ELplA59SPAe1mAjSQpy1zfL27B0JvNM0Qc+KDhXpZsmORxIWRIHHfYqa1VAmscTLTlBOgGehdCRn+mqFveRLYCS9RNLQkwHQiDQDOsNRsrUkVPk4s8OYCwm7Rx\/+2gE8gUhP5eC76D3eZs8Hm0rPnppgF7KOHXI\/UdhDB9posh0SFtnaetvQA1gpCM7l2FnPA1nE+2jTkGSR\/JPn+NiTHS5oxChI0kyvLk97oCzvD85jlkDM0+vLwUWHSHp1yTuQwNVXkvDO4EcIvBlSv0+jwUU4PfUdKYuFpEUhYX1qBYglqnKSjhSrz\/EJ0SksbN0Oap\/iWfScJL3ImwA45+TWpwhee7l2f+igFaNgttNYqUjsvJN3bGfV1nZZuWwctUwgAUqbzQVD6sb6qpafqHD6JRWgDO+uwJOFWAXHOcu9WNfC8P2XZL1Y3zhbXXO0LHzvmvp+8OQklXwFlkNyZmmHb2q7MUXh6HRQ53Bqgn070B+AvGUZlgVVTE\/NwXmfbMLxEMPHuGwokvXER21W+6\/\/HQciuQnn0SRFjZQEDVSLAeOdDhVvHdQq9RrUK692arcZYNkAOGb+MeYXTNu5DOzt12HvcGdnRRFSTFURJr5j6BDhtYlYXl+dskC19rpyuFOHpSXNTSSWiSbWgil7Ib+IfSugREh6Jq336E1V6YcCeHwMetvCXZvukKtDgnRGRX6tcLdJWCQwtvF4koVYxUgYz7NimcMMIRsTluWM3ovvQib3bl1y8LH0DxxnU\/+GiulZzAR94maZnlJ1J+MjvsxMNikJRgZqe2+292rudhTx6qsJcett5eBDre4GRLIoVxzD5t3V5eD71VeqoYKGYWbnHRINvk1AZEwxth359OxhVFV26rWDxZjCE1SqVXh\/sL1bOTiCd7UjWFYQy0wMqhzW9xvbewjM3dpe\/VFmLdjydPN296vbr48W4\/6WpuLTC07M21eXxE9vGju2Iwt1BB0fc0GfNGk\/pldfBxcQETVIoqSwJoHbRSrGC46wRjEYfPfJ3zjG3Ecp4A\/OZRqmMIQuEBjCMAuPLtujZMEFNnKoxqPwcbv2SWeyUcaofMAGJsAu77Zjs9qfSFbjytb+3lalvryIZ2XpD8yqGBZLGc0+yTIrc9wzKUVxTqfzrCp5KB4c54mjnKHoo9cTwcO5bNhtU+Wf+YQATSq7lEbzZx5nCeyi54mjLPCTGPo8hoKGkSpXIQa0dzr41ubYq\/YRF0Rf8eCH11atTB+9h8Do69ZY1Z6eJl+fDy6QgZxyWAMfGxmEyQgiKuAStE31pfTxTZ0Dv43+qIe2mNXaTg3R8vpgf3fUr2VvuAA+va0d1EDZRX12crIc8S5m14W82aGzMlCGNfxY+AdutIPGT\/rwMBakQ2a7ZdXJDhvPRx83IhG\/u4tF+SxQbba9uC99QLgvGH4FgAumCMIGimjoA5uGz4gOL6TgnElqGsMvBrWCYkjQ5ok0Dd2hu1AoOOsGdkcs0rK0kUgcFdbRmpqaxpDY8JsznD\/p15h3eKBxif78Xz4Ghp8qvhFEYCWQzS5wLmRvWvkf\" \/> \t\t<a href=\"https:\/\/www.pdf24.org\" target=\"_blank\" title=\"www.pdf24.org\" rel=\"nofollow\"><img src=\"https:\/\/blog.mhasin.eu\/wp-content\/plugins\/pdf24-post-to-pdf\/img\/pdf_32x32.png\" alt=\"\" border=\"0\" height=\"32\" \/><\/a> \t\t<span class=\"pdf24Plugin-cp-space\">\u00a0\u00a0<\/span> \t\t<span class=\"pdf24Plugin-cp-text\">Send article as PDF<\/span> \t\t<span class=\"pdf24Plugin-cp-space\">\u00a0\u00a0<\/span> \t\t<input class=\"pdf24Plugin-cp-input\" style=\"margin: 0px;\" type=\"text\" name=\"sendEmailTo\" placeholder=\"Enter email address\" \/> \t\t<input class=\"pdf24Plugin-cp-submit\" style=\"margin: 0px;\" type=\"submit\" value=\"Send\" \/> \t<\/form> <\/div>","protected":false},"excerpt":{"rendered":"In\u0161tal\u00e1cia radius serveru: Import MYSQL \u0161trukt\u00fary: Vytvorenie tabu\u013eky pre z\u00e1pis pou\u017e\u00edvate\u013eov s \u010dasov\u00fdm obmedzen\u00edm: Vytvorenie poh\u013eadu pre tabu\u013eku radcheck. Tento poh\u013ead zabezpe\u010d\u00ed na\u010d\u00edtanie iba u\u017e\u00edvate\u013eov s platn\u00fdmi \u00fadajmi pod\u013ea d\u00e1tumu starts a expire. Zabezpe\u010denie automatick\u00e9ho mazania star\u00fdch z\u00e1znamov z datab\u00e1zy star\u0161\u00edch ako 5 dn\u00ed po d\u00e1tume exspir\u00e1cie: Uprava freeradius SQL config povolenie SQL \u00a0\u00a0 Send article as PDF \u00a0\u00a0\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"arc_restricted_post":false,"footnotes":""},"categories":[13,4],"tags":[],"class_list":["post-852","post","type-post","status-publish","format-standard","hentry","category-freeradius","category-linux"],"_links":{"self":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=852"}],"version-history":[{"count":9,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":872,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/852\/revisions\/872"}],"wp:attachment":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}