| python |
Pythonタグが付けられた新着投稿 - Qiita |
40代プログラミング初心者：3万件のCSV操作「遅い」からpandasへ |
https://qiita.com/usagi-san/items/ec755d76bac1e4f01fef
|
pandas |
2022-08-06 14:19:12 |
| Ruby |
Rubyタグが付けられた新着投稿 - Qiita |
Rubyバージョンに合わせて Gemfile.lock を切り替える |
https://qiita.com/okazaki-6012/items/3896f7a55a6ac4c6260a
|
gemfile |
2022-08-06 14:37:26 |
| Linux |
Ubuntuタグが付けられた新着投稿 - Qiita |
メモリのスワップを有効にする方法 |
https://qiita.com/skanno/items/45567b02f705cf897422
|
領域 |
2022-08-06 14:50:54 |
| Docker |
dockerタグが付けられた新着投稿 - Qiita |
SpringBootアプリケーションをDockerで実行する |
https://qiita.com/ykdevs/items/3a6115402a9a57097057
|
dockerc |
2022-08-06 14:54:20 |
| Docker |
dockerタグが付けられた新着投稿 - Qiita |
docker composeで手軽にReact＋FastAPI＋MySQLお試しローカル環境を作る |
https://qiita.com/kamiyama_kkkkk/items/c30528c468f0cadac38b
|
fastap |
2022-08-06 14:05:53 |
| 海外TECH |
DEV Community |
OpenVPN with FreeRADIUS User Auth |
https://dev.to/febryandana/openvpn-with-freeradius-user-auth-4912
|
OpenVPN with FreeRADIUS User Auth OverviewOpenVPN can utilize RADIUS services as a source of authentication for its user accounts In this article we will try to integrate OpenVPN with FreeRADIUS and utilize DaloRADIUS for the FreeRADIUS GUI dashboard service That way administrators can easily manage OpenVPN users in one place FreeRADIUS amp DaloRADIUS Configuration FreeRADIUS Install Web Serversudo iapt update amp amp apt y upgradeapt y install apacheapt y install php libapache mod php php gd common mail mail mime mysql pear db mbstring xml curl php v Install DB serverapt y install mariadb servermysql secure installation Create RADIUS databasemysql u root pMariaDB none gt CREATE DATABASE radius MariaDB none gt GRANT ALL ON radius TO radius localhost IDENTIFIED BY StrongPassword MariaDB none gt FLUSH PRIVILEGES MariaDB none gt QUIT Install amp Configure FreeRADIUSapt y install freeradius freeradius mysql freeradius utilsImport freeRADIUS sql databasemysql u root p radius lt etc freeradius mods config sql main mysql schema sqlmysql u root p e use radius show tables Create softlink to enable sql modln s etc freeradius mods available sql etc freeradius mods enabled Configure sql moduleComment SSL sections in mysqlnano etc freeradius mods enabled sql sql driver rlm sql mysql dialect mysql Connection info server localhost port login radius password StrongPassword Database table configuration for everything except Oracleradius db radius Set to yes to read radius clients from the database nas table Clients will ONLY be read on server startup read clients yes Table to keep radius client infoclient table nas Change Groupchgrp h freerad etc freeradius mods available sqlchown R freerad freerad etc freeradius mods enabled sqlRestart freeradius servicesudo systemctl restart freeradius service DaloRADIUS Install daloRadiusapt y install wget unzipwget unzip master zipmv daloradius master daloradiuscd daloradius Configure daloRadiusImport daloRadius tablesmysql u root p radius lt contrib db fr mysql daloradius and freeradius sqlmysql u root p radius lt contrib db mysql daloradius sqlMove daloRadius folder to Web Servercd mv daloradius var www html mv var www html daloradius library daloradius conf php sample var www html daloradius library daloradius conf phpchown R www data www data var www html daloradius chmod var www html daloradius library daloradius conf phpConfigure daloRadius connectionnano var www html daloradius library daloradius conf php configValues CONFIG DB HOST localhost configValues CONFIG DB PORT configValues CONFIG DB USER radius configValues CONFIG DB PASS StrongPassword configValues CONFIG DB NAME radius touch tmp daloradius logRestart servicessystemctl restart freeradius service apache service Verify daloRadiusAccess via http IP ADDRESS daloradius login phpDefault User amp Password User administratorPassword radius OpenVPN Installation OpenVPNWe will install OpenVPN by easy way using automation shell scriptapt install y openvpn openvpn auth radius freeradius utilswget O openvpn install shbash openvpn install sh Public IPv address hostname a b c d IP Server OpenVPN Change the settings whatever you like OpenVPN RADIUS PluginTo connect OpenVPN with FreeRADIUS we need to use external plugin named radiuspluginapt updateapt install openvpn auth radiusBinary file will be downloaded to usr lib openvpn radiusplugin so Integrate OpenVPN with FreeRADIUS FreeRadius Side Create NAS Network Access Server for OpenVPN serverVia DaloRadius NAS IP Host IP ADDRESS OPENVPN SERVERNAS Secret fb ovpnNAS Type otherNA Shortname fb ovpnVia clients conf bashnano clients conf client fb ovpn ipaddr IP ADDRESS OPENVPN SERVER netmask secret fb ovpn shortname fb ovpn nastype other Restart freeradius service everytime you need to create new NASsystemctl restart freeradius service OpenVPN Server Side Create cnf file for connecting OpenVPN to FreeRADIUSnano etc openvpn radiusplugin cnf NAS Identifier openvpnService Type Framed Protocol NAS Port Type NAS IP Address OpenVPNConfig etc openvpn server server confoverwriteccfiles trueserver acctport authport name retry wait sharedsecret fb ovpn Test connection to RADIUS via server OpenVPN You need to create user first from DaloRADIUSradtest username password radius hostname radius secret radtest febry febry fb ovpn Configure file server conf on OpenVPN server so that OpenVPN will use users from FreeRADIUS servernano etc openvpn server server conf plugin usr lib openvpn radiusplugin so etc openvpn radiusplugin cnfverify client certkey direction duplicate cnlocal port proto udpdev tunca ca crtcert server crtkey server keydh dh pemauth SHAtls crypt tc keytopology subnetserver push redirect gateway def bypass dhcp ifconfig pool persist ipp txtpush dhcp option DNS keepalive cipher AES CBCuser nobodygroup nogrouppersist keypersist tunverb crl verify crl pemexplicit exit notify Create ovpn file for clientsnano root client ovpn key direction auth user pass user nobody group nogroupclientdev tunproto udpremote resolv retry infinitenobindpersist keypersist tunremote cert tls serverauth SHAcipher AES CBCignore unknown option block outside dnsblock outside dnsverb lt ca gt Test connection to OpenVPN with RADIUS user Conducted on node fb ubuntu lab openvpn config client ovpn Conducted on personal computersudo openvpn config client ovpn Known Issues Unknown column acctupdatetime in field list DaloRadius RADIUS log ERROR sql ERROR rlm sql mysql ERROR Unknown column acctupdatetime in field list S Solve Rebuild table radacctmysql u root p radiusDROP TABLE radacct CREATE TABLE radacct radacctid bigint NOT NULL auto increment acctsessionid varchar NOT NULL default acctuniqueid varchar NOT NULL default username varchar NOT NULL default groupname varchar NOT NULL default realm varchar default nasipaddress varchar NOT NULL default nasportid varchar default NULL nasporttype varchar default NULL acctstarttime datetime NULL default NULL acctupdatetime datetime NULL default NULL acctstoptime datetime NULL default NULL acctinterval int default NULL acctsessiontime int unsigned default NULL acctauthentic varchar default NULL connectinfo start varchar default NULL connectinfo stop varchar default NULL acctinputoctets bigint default NULL acctoutputoctets bigint default NULL calledstationid varchar NOT NULL default callingstationid varchar NOT NULL default acctterminatecause varchar NOT NULL default servicetype varchar default NULL framedprotocol varchar default NULL framedipvaddress varchar default NULL framedipvprefix varchar default NULL framedinterfaceid varchar default NULL delegatedipvprefix varchar default NULL framedipaddress varchar NOT NULL default PRIMARY KEY radacctid UNIQUE KEY acctuniqueid acctuniqueid KEY username username KEY framedipaddress framedipaddress KEY acctsessionid acctsessionid KEY acctsessiontime acctsessiontime KEY acctstarttime acctstarttime KEY acctinterval acctinterval KEY acctstoptime acctstoptime KEY nasipaddress nasipaddress ENGINE INNODB Error reading log file tmp daloradius logerror reading log file tmp daloradius loglooked for log file in tmp daloradius log but couldn t find it if you know where your daloradius log file is located set it s location in your library daloradius conf fileSolve Create new log filetouch tmp daloradius logchown www data www data daloradius logchmod tmp daloradius log Error reading log file var log syslogerror reading log file var log syslogpossible cause is file permissions or file does not exist Solve Change file permissionchmod var log syslog RADIUS user authentication s type that is compatible with OpenVPN x cleartext password User password AUTH FAILED x Crypt password x MD password SHA password AUTH FAILED CHAP password AUTH FAILED Some OS s dont have nogroup user amp group but they use nobody and vice versa To solve issue with these groups we can Create user nobody and group nogroup Cretae user nobody and group nobody Then edit group nogroup to group nobody in client ovpn file Comment out user nobody and group nogroup in client ovpn file References |
2022-08-06 05:04:29 |
| 海外ニュース |
Japan Times latest articles |
Kishida to reshuffle Cabinet amid Taiwan and Unification Church concerns |
https://www.japantimes.co.jp/news/2022/08/06/national/politics-diplomacy/fumio-kishida-cabinet-defense-minister-nobuo-kishi/
|
Kishida to reshuffle Cabinet amid Taiwan and Unification Church concernsDefense chief Nobuo Kishi is expected to be replaced while LDP Secretary General Toshimitsu Motegi and Chief Cabinet Secretary Hirokazu Matsuno are likely to retain their |
2022-08-06 14:38:07 |
| 海外ニュース |
Japan Times latest articles |
Nuclear weapons a ‘loaded gun,’ U.N. chief warns, as Hiroshima marks 77 years since bombing |
https://www.japantimes.co.jp/news/2022/08/06/national/hiroshima-bombing-77th-anniversary/
|
Nuclear weapons a loaded gun U N chief warns as Hiroshima marks years since bombingAt an annual memorial Antonio Guterres warned of the risk posed by crises in Ukraine the Mideast and the Korean Peninsula |
2022-08-06 14:04:29 |
| ニュース |
BBC News - Home |
Israel-Gaza: Palestinian civilians and militants killed amid flare-up |
https://www.bbc.co.uk/news/world-middle-east-62445951?at_medium=RSS&at_campaign=KARANGA
|
flare |
2022-08-06 05:39:50 |
| ニュース |
BBC News - Home |
Erling Haaland: Manchester City striker and Alan Shearer discuss the art of goalscoring |
https://www.bbc.co.uk/sport/av/football/62437350?at_medium=RSS&at_campaign=KARANGA
|
Erling Haaland Manchester City striker and Alan Shearer discuss the art of goalscoringPremier League record goal scorer Alan Shearer sits down with Manchester City forward Erling Haaland to talk about the art of goalscoring |
2022-08-06 05:15:57 |
| ニュース |
BBC News - Home |
Commonwealth Games: Stories from cricket's last appearance at the Games |
https://www.bbc.co.uk/sport/commonwealth-games/62340817?at_medium=RSS&at_campaign=KARANGA
|
commonwealth |
2022-08-06 05:38:40 |
| 北海道 |
北海道新聞 |
男子４００メートルリレーで優勝 陸上Ｕ２０世界選手権 |
https://www.hokkaido-np.co.jp/article/714967/
|
世界選手権 |
2022-08-06 14:06:05 |
コメント
コメントを投稿