{"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=\"&#8220;Debian in\u0161tal\u00e1cia mariadb&#8221; &#8212; 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&#038;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>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>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 &lt; schema.sql<\/code><\/pre>\n\n\n\n<p>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>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>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>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>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=\"rVfbUttIEH3XV3QpVQG2kCVjIARb3nXASbzhkiUmKfICY2mwZ5E0ymhkY9f+Qv5hecwDP5Cq8GL4r+0ZyRewuVSygmKk6Z7uM91nehqjcsraqaDgBSRJXLMXW62Ae2cWDVvUt3pc+LGgSQK3BcASS\/ZjauH0eCIWvMt8KpRi26xWfNadb\/b4uCdIHFNhVo2Knv+ScjmNQav5CMDjkaSRNMEnklgJ9QSVrvnnxy\/8tLPxeWsN3RDoCHrqmh0p42TTtpX3QtghCYsKNLV\/j92NlZdmdZu2GImARTcXkgTDC48RCIlgxG9VbFKt2BMg1Qo7FSSkEHDis6jtmgEZ9E2QTAbUNZ8\/21hZccoPGNQaxTKosbhShlc7+2\/MB7eXkMhv8XPXJEHAe1biCRbLBOeplwom+66JWZCCeZL6OCv7CkjMEyYZjzaBtBIepJKW0QmLN0FQTy4W4\/NluPVnqYxrhfdIrJ4\/c0obZY3RlSKlz37P4z4V9nvzAT3my45rrjuOCR3K2h2Ul0obJuiQtpBQVLgmCjFWbRbl6uPv0RKcwCDwINDxjzgm2s6ygpyxkVr4nVG3auBTiauN6UQITFyaYPhEl4p0s2LHudocqnvcp2heDVUSS8xognYCBExpbmfyaoX95EtgJP1E0tCTAdCItAI6pVGxtSV0OYUtjLmQsHv04a8dQJgiPZPD76L\/dGCeDzaVnj3xY5cKjh1yP1EswlDYiMsOCYtsDdE29ABWCoJzOYrI80CWMbIdGpICiueB\/diXXS5oxChI0kqvr876oOANhhcxSyDm6c3V8LJLJL2+4l1I4PorSXh3+CME3gqpP6DR8DKcbO2eCsNC0qaQsAG1Akw9VSVEE9sacHxC3DkL23fPoE8RsP4mST\/yxnwrOsX1CeHWXq49zHREkZ89O42Vi8RecVYc21m1NS6rWIijtgkkQGvTRzeTbqyvavuJYv8vuQAFvLcMP23EKjnOefHFujaG779k68X6xvnqmqNt4XvP1PnBnZNU8mVYDMm5pQO+qXFjRcHR6aLP7NME++65fITXlmVYFmxjNWkNLwZkE04yop7gtKFE1k8+arFaf\/Pv6LSR23TOP1L0SElwjG7xVHhnmeOtg3qtWYdm7dVO\/a4CLBoAJ8w\/wUqBVba4BHv7Tdg73NlZVoIUi06EdeoEukR4HSIW11cnKrBdf1073GnCwoLWJhKregtL90S9tDJPfSugREh6Lq33GE11MWcGeHwCetncVZtuptUlQTrlYmWtdD8krOl4tnF7koV46ZAwnlXFWwkrhDweqywu6bX4LmTy4NIFBx9L\/4LjbOrfzDE9j5mgP7lYpmdU5WS0xZdL40XKgrEE9b03jb2624givv1qLNx6Wzv4UG+6AZEsKpZHtHl3fTX8fv2VaqogMCzfvEui4bcxiYwJxxqRT88fZ1Vtp1k\/mM8p3EFtexveHzR2awdH8K5+BIuKYktjQLXD5v5xYw+JuVvfaz4J1pwlPw9vd3+78fpoPu\/veCo\/cqvEvHN9Rfz0NqKRswI0kVl8pAUD0qKDmF5\/HV5CRNQgibLCWgTu3kQxZjHCi4jB8LtP\/sYx5j5aAX94IdMwhYyfQCDjWgGefAHnFYELbK7QjUfhY6P+SZervCzUPmC\/EWDndTd6BR00FKtxeWt\/b6vWXJyns7zwB5ZO5P7CklYfl5LlGe2puqE0J5+zqqpCKB0cZ4V5YVDy\/PVU8HCm5PU6VMVn9tRDi8oepdHsnkelADvbWWF+1OcR5fMo35or6uIJ8Wh6Z8NvHY5N4gCTT3Qehz+8jmpKBhgizP5A96TqFulr8c3F8BIVyBmHNfCxJUEu5DxQRydBAKpXpE\/vwRz4Lf+hHmIxt+s7daTE64P93by9KtzaJ3x6Wz+og8JFfXZ6uhjxHtbJubqFLCJLUIU17NL\/gVvdmzEvUIexIF0y3aaq7jJrBp+8p4hE\/P7OEu2zQPW39vxe8RHjvmDYfoMLpgjCYzRxrHdlGj4j+qCgBL+ZpKaRtepqBs2QoMMTaRq6a3ahVHLWDWxmWKRtaZAozO\/BfE59mkYmPPZbU5rzghfzLg80wzBo\/0sXnv0j4BtBBFYChcKcCELhNpT\/AA==\" \/> \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\">&nbsp;&nbsp;<\/span> \t\t<span class=\"pdf24Plugin-cp-text\">Send article as PDF<\/span> \t\t<span class=\"pdf24Plugin-cp-space\">&nbsp;&nbsp;<\/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 &nbsp;&nbsp; Send article as PDF &nbsp;&nbsp;\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}]}}