﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>C++博客-朱的工作记录</title><link>http://www.cppblog.com/van201314/</link><description>技术博客</description><language>zh-cn</language><lastBuildDate>Mon, 13 Apr 2026 09:39:16 GMT</lastBuildDate><pubDate>Mon, 13 Apr 2026 09:39:16 GMT</pubDate><ttl>60</ttl><item><title>常用开源软件</title><link>http://www.cppblog.com/van201314/archive/2012/03/27/169204.html</link><dc:creator>朱</dc:creator><author>朱</author><pubDate>Tue, 27 Mar 2012 13:17:00 GMT</pubDate><guid>http://www.cppblog.com/van201314/archive/2012/03/27/169204.html</guid><wfw:comment>http://www.cppblog.com/van201314/comments/169204.html</wfw:comment><comments>http://www.cppblog.com/van201314/archive/2012/03/27/169204.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cppblog.com/van201314/comments/commentRss/169204.html</wfw:commentRss><trackback:ping>http://www.cppblog.com/van201314/services/trackbacks/169204.html</trackback:ping><description><![CDATA[整理下比较常用的或者接触过的开源软件：<br /><br /><strong style="font-size: 24pt; ">网络类的：</strong><br /><br />SIP协议：<br />exosip和osip2<br />pjsip<br /><br />802.1x：<br /><div>wpa_supplicant<br /></div>VPN：<br />openvpn<br /><br />SNMP：<font class="Apple-style-span" color="#333333" face="verdana, arial, helvetica, sans-serif" size="3"><span class="Apple-style-span" style="line-height: 20px; "><br /></span></font><span class="Apple-style-span" style="color: #333333; font-family: verdana, arial, helvetica, sans-serif; line-height: 20px; font-size: medium; ">Net-SNMP（旧版本为UCD-SNMP）</span><br /><br />抓包工具:<br /><div>libpcap</div><br />Web服务器：<br />Apache Server<br />nginx<br />Goahead（版本为2.5，后面被oracle收购了）<br />appweb<br />lighttp<br />mini_httpd<br /><br />其他：<br />LDAP轻量目录搜索：<br />openldap<br /><br />lldp<br /><br /><strong style="font-size: 24pt; ">工具类：</strong><br /><br />内存检测：<br /><div>valgrind</div><br /><strong style="font-size: 24pt; ">其他：</strong><br /><br />SSL库：<br />openssl<br />matrixssl<br /><br />未完，待整理<img src ="http://www.cppblog.com/van201314/aggbug/169204.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cppblog.com/van201314/" target="_blank">朱</a> 2012-03-27 21:17 <a href="http://www.cppblog.com/van201314/archive/2012/03/27/169204.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>freeradius和mysql的集成</title><link>http://www.cppblog.com/van201314/archive/2011/05/20/146799.html</link><dc:creator>朱</dc:creator><author>朱</author><pubDate>Fri, 20 May 2011 02:31:00 GMT</pubDate><guid>http://www.cppblog.com/van201314/archive/2011/05/20/146799.html</guid><wfw:comment>http://www.cppblog.com/van201314/comments/146799.html</wfw:comment><comments>http://www.cppblog.com/van201314/archive/2011/05/20/146799.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cppblog.com/van201314/comments/commentRss/146799.html</wfw:commentRss><trackback:ping>http://www.cppblog.com/van201314/services/trackbacks/146799.html</trackback:ping><description><![CDATA[<div><span>网上转载：<br /><br />环境：fedora 13或者centos 5<br />&nbsp;&nbsp; &nbsp; &nbsp;freeradius-server-2.1.10<br />&nbsp;&nbsp; &nbsp; &nbsp;mysql&nbsp;Ver 14.14 Distrib 5.1.48<br /><br />#&nbsp;<span>mysqladmin -uroot password 111111 &nbsp; &nbsp; &nbsp; --创建初始密码<br /><br /># mysql -uroot -p111111<br /># mysql&gt; create database radius; &nbsp; &nbsp; &nbsp;</span>-- 创建radius 数据库<span><br /># mysql&gt; quit;</span><br /></span><span><br /></span><span># mysql -u root -p111111 radius &lt; /etc/raddb/sql/mysql/schema.sql &nbsp; &nbsp;--radius安装路径</span><span><br /></span><span># mysql -u root -p111111 radius &lt; /etc/raddb/sql/mysql/nas.sql</span><span><br /></span><span># mysql -u root -p111111 radius &lt; /etc/raddb/sql/mysql/ippool.sql</span><span><br /></span><span># mysql -u root -p111111 radius &lt; /etc/raddb/sql/mysql/wimax.sql&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --如果没有wimax.sql 就执行admin.sql</span><span>授权&nbsp;</span><span><br /></span><span># mysql -u root -p111111</span><span><br /></span><span>mysql&gt; GRANT SELECT ON radius.* TO 'radius'@'localhost' IDENTIFIED BY 'radpass';</span><span><br /></span><span>mysql&gt; GRANT ALL on radius.radacct TO 'radius'@'localhost';</span><span><br /></span><span>mysql&gt; GRANT ALL on radius.radpostauth TO 'radius'@'localhost';</span><span><br /></span><span>先加入一些组信息:<br /></span><span>mysql&gt; use radius;<br /></span><span>mysql&gt; insert into radgroupreply (groupname,attribute,op,value) values ('user','Auth-Type',':=','Local');</span><span><br /></span><span>mysql&gt; insert into radgroupreply (groupname,attribute,op,value) values ('user','Service-Type','=','Framed-User');</span><span><br /></span><span>mysql&gt; insert into radgroupreply (groupname,attribute,op,value) values ('user','Framed-IP-Netmask','=','255.255.255.255');</span><span><br /></span><span>mysql&gt; insert into radgroupreply (groupname,attribute,op,value) values ('user','Framed-IP-Netmask',':=','255.255.255.0');</span><span><br /></span><span>然后加入用户信息：</span><span><br /></span><span>mysql&gt; INSERT INTO radcheck (UserName, Attribute, Value) VALUES ('sqltest', 'Password', 'testpwd');</span><span><br /></span><span>然后把用户加到组里：</span><span><br /></span><span>mysql&gt; insert into radusergroup(username,groupname) values('sqltest','user');</span><span><br /></span><span>mysql&gt; select * from radcheck where UserName='sqltest';<br />mysql&gt; quit;</span></div><img src ="http://www.cppblog.com/van201314/aggbug/146799.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cppblog.com/van201314/" target="_blank">朱</a> 2011-05-20 10:31 <a href="http://www.cppblog.com/van201314/archive/2011/05/20/146799.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>