<?xml version="1.0" encoding="UTF-8"?>
  <feed xmlns="http://www.w3.org/2005/Atom">
  <title type="html"><![CDATA[X-Blog!]]></title>
  <subtitle type="html"><![CDATA[创造机会的人是勇者；等待机会的人是愚者]]></subtitle>
  <id>http://blog.3gcomet.com/</id>
  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/" /> 
  <link rel="self" type="application/atom+xml" href="http://blog.3gcomet.com/atom.asp" /> 
  <generator uri="http://www.pjhome.net/" version="2.8">PJBlog3</generator> 
  <updated>2012-01-30T09:40:17+08:00</updated>

  <entry>
	  <title type="html"><![CDATA[excel中粘贴身份证]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=30" label="MsOffice" /> 
	  <updated>2012-01-30T09:40:17+08:00</updated>
	  <published>2012-01-30T09:40:17+08:00</published>
		  <summary type="html"><![CDATA[<p>&nbsp; 在excel中录入长的数字，如身份证时，会自动地使用科学计数法显示或把最后3位以0代替，这样看起来方便或是不正确，那么这里给个方法解决：</p>
<p>先把那一列选中，把单元格格式设置为&ldquo;文本&rdquo;，再粘帖就可以了。如果是单个录入，可以先录入一个英文的引号再输入数字。</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=572" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=572</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[ubuntu 添加中文字符编码支持]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=11" label="Ubuntu" /> 
	  <updated>2012-01-26T04:11:56+08:00</updated>
	  <published>2012-01-26T04:11:56+08:00</published>
		  <summary type="html"><![CDATA[<div>默认 /var/lib/locales/supported.d/local 只有</div>
<div>en_US.UTF-8 UTF-8</div>
<div>&nbsp;</div>
<div><strong>1.添加中文支持</strong></div>
<div><span style="color: rgb(255,102,0)">sudo locale-gen zh_CN.UTF-8 UTF-8</span></div>
<div>会生成对应的语言配置</div>
<div><span style="color: rgb(255,102,0)">ls /usr/lib/locale</span></div>
<div>&nbsp;</div>
<div><strong>2.如果要删除</strong></div>
<div>先删除local中的编码支持，再</div>
<div><span style="color: rgb(255,102,0)">sudo locale-gen --purge</span></div>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=571" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=571</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[mssql 数据库查询库、表、字段的语句]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=9" label="数据库集" /> 
	  <updated>2012-01-16T11:36:03+08:00</updated>
	  <published>2012-01-16T11:36:03+08:00</published>
		  <summary type="html"><![CDATA[<p>记录一下，备用。</p>
<p><strong>1.查询所有库名</strong></p>
<p><span style="color: rgb(255, 102, 0); ">Select Name From Master..SysDatabases order By Name</span></p>
<p><strong>2.查询该库所有的用户表名</strong></p>
<p><span style="color: rgb(255, 102, 0); ">Select Name From SysObjects Where XType='U' order By Name</span></p>
<p><strong>3.查询TABLENAME表所有字段名</strong></p>
<p><span style="color: rgb(255, 102, 0); ">Select Name From SysColumns Where id=Object_Id('TABLENAME')</span></p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=570" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=570</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[ubuntu中ntp时间服务器配置]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=11" label="Ubuntu" /> 
	  <updated>2012-01-02T09:03:16+08:00</updated>
	  <published>2012-01-02T09:03:16+08:00</published>
		  <summary type="html"><![CDATA[<p>管理的机器多了，为了保证时间的准确性，时间同步服务器是少不了的。</p>
<p>os:Ubuntu 10.04.3 LTS</p>
<p>ntp:1:4.2.4p8+dfsg-1ubuntu2.1</p>
<p><strong>1.安装</strong></p>
<p><span style="color: rgb(255, 102, 0); ">sudo apt-get install ntp</span></p>
<p><strong>2.ntp服务器配置如下</strong></p>
<p><span style="color: rgb(255, 102, 0); ">grep -v &quot;#&quot; /etc/ntp.conf</span></p>
<div>
<div>#本机服务器时间与远程NTP服务器时间后的时间差，由NTP自动计算。</div>
<div>driftfile /var/lib/ntp/ntp.drift</div>
<div>&nbsp;</div>
<div>#统计用的</div>
<div>statistics loopstats peerstats clockstats</div>
<div>filegen loopstats file loopstats type day enable</div>
<div>filegen peerstats file peerstats type day enable</div>
<div>filegen clockstats file clockstats type day enable</div>
<div>&nbsp;</div>
<div>#默认不允许全部IPv4和IPv6客户端连接</div>
<div>restrict -4 default kod notrap nomodify nopeer noquery</div>
<div>restrict -6 default kod notrap nomodify nopeer noquery</div>
<div>&nbsp;</div>
<div>#允许本地环路连接</div>
<div>restrict 127.0.0.1</div>
<div>restrict ::1</div>
<div>&nbsp;</div>
<div>#下面的配置是自行添加的</div>
<div>#上级NTP服务器，带prefer的为主要来源服务器</div>
<div>server 61.153.197.226 prefer</div>
<div>server 210.72.145.44</div>
<div>&nbsp;</div>
<div>#允许本地IP连接</div>
<div>restrict 192.168.1.254</div>
<div>restrict 192.168.10.254</div>
<div>&nbsp;</div>
<div>#允许NTP服务器对本地服务器做任何更改</div>
<div>restrict 61.153.197.226</div>
<div>restrict 210.72.145.44</div>
<div>&nbsp;</div>
<div>#仅允许客户端对本地服务器进行时间同步，不允许修改、远程登录、查询详细服务器信息</div>
<div>restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap noquery</div>
<div>restrict 192.168.10.0 mask 255.255.255.0 nomodify notrap noquery</div>
<div>&nbsp;</div>
</div>
<div><strong>3.重启ntp服务</strong><br />
<span style="color: rgb(255, 102, 0); ">sudo service ntp restart</span></div>
<div>&nbsp;</div>
<div><strong>4.服务器需开放UDP的123端口</strong></div>
<div>&nbsp;</div>
<div><strong>5.参考</strong></div>
<div>
<div>本文参考：http://twiki.ntp.org/bin/view/Support/AccessRestrictions</div>
<div>客户端配置参考：http://linux.vbird.org/linux_server/0440ntp.php#client</div>
</div>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=569" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=569</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[使用wmi获取intel cpu信息不正确的解决方法]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=5" label="微软系统" /> 
	  <updated>2011-12-26T00:46:29+08:00</updated>
	  <published>2011-12-26T00:46:29+08:00</published>
		  <summary type="html"><![CDATA[<p>&nbsp;使用wmi获取 intel&nbsp;&nbsp;酷睿2系列&nbsp;cpu 名称的时候（Select Name from Win32_Processor）会显示不正确，如：Pentium(R) Dual-Core &nbsp;CPU &nbsp; &nbsp; &nbsp;E8400 &nbsp;@ 3.00GHz 显示为 Intel Pentium III Xeon 处理器。这个是windows的问题，需要打补丁。这个补丁地址是需要通过邮件去申请的。详细如下：</p>
<p>知识库网址：http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=953955&amp;kbln=en-us</p>
<p>&nbsp;</p>
<p>收到的邮件部分内容：</p>
<p>NOTE &nbsp; For your convenience, we send the hotfix location to you in a hyperlink. To connect to this hotfix location, you can click the hyperlink in the &quot;Location&quot; field that is listed in the table at the end of this e-mail message to have your Web browser open that location. However, sometimes e-mail program settings disable hyperlinks. If the hyperlink in this e-mail message is disabled, please copy the hyperlink in the &quot;Location&quot; field and then pastes it into the address box of your Web browser. Make sure that you include the exact text (without spaces) between the parentheses in the http:// address.&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Package:&nbsp;</p>
<p>-----------------------------------------------------------&nbsp;</p>
<p>-----------------------------------------------------------&nbsp;</p>
<p>KB Article Number(s): 953955&nbsp;</p>
<p>Language: English&nbsp;</p>
<p>Platform: i386&nbsp;</p>
<p>Location: (http://hotfixv4.microsoft.com/Windows%20Server%202003/sp3/Fix248823/3790/free/364260_ENU_i386_zip.exe)&nbsp;</p>
<p>&nbsp;</p>
<p>-----------------------------------------------------------&nbsp;</p>
<p>KB Article Number(s): 953955&nbsp;</p>
<p>Language: Chinese (Simplified)&nbsp;</p>
<p>Platform: i386&nbsp;</p>
<p>Location: (http://hotfixv4.microsoft.com/Windows%20Server%202003/sp3/Fix248823/3790/free/364257_CHS_i386_zip.exe)&nbsp;</p>
<p>&nbsp;</p>
<p>-----------------------------------------------------------&nbsp;</p>
<p>KB Article Number(s): 953955&nbsp;</p>
<p>Language: English&nbsp;</p>
<p>Platform: i386&nbsp;</p>
<p>Location: (http://hotfixv4.microsoft.com/Windows%20XP/sp4/Fix237501/2600/free/353854_ENU_i386_zip.exe)&nbsp;</p>
<p>&nbsp;</p>
<p>-----------------------------------------------------------&nbsp;</p>
<p>KB Article Number(s): 953955&nbsp;</p>
<p>Language: Chinese (Simplified)&nbsp;</p>
<p>Platform: i386&nbsp;</p>
<p>Location: (http://hotfixv4.microsoft.com/Windows%20XP/sp4/Fix237501/2600/free/353849_CHS_i386_zip.exe)&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>NOTE &nbsp; Make sure that you include all the text between &quot;(&quot; and &quot;)&quot; when you visit this hotfix location.&nbsp;</p>
<p>&nbsp;</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=568" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=568</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[phpmyadmin 隐藏数据库]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=9" label="数据库集" /> 
	  <updated>2011-12-19T00:52:42+08:00</updated>
	  <published>2011-12-19T00:52:42+08:00</published>
		  <summary type="html"><![CDATA[<p>os: ubuntu&nbsp;</p>
<p>phpmyadmin:3.x 以上的版本</p>
<p>&nbsp; &nbsp;在phpmyadmin中，默认情况下不管用哪个账户登录都可以看到&nbsp;&nbsp;information_schema 数据库，这个数据库里面存放的是数据库的表名、数据类型、访问权限等。为了提高安全性，隐藏这个数据库，不让它默认显示出来。</p>
<p>&nbsp;找到&nbsp;/etc/phpmyadmin/config.inc.php，添加&nbsp;&nbsp;$cfg['Servers'][$i]['hide_db'] = 'information_schema'; 即可。隐藏其他数据库也是一样的操作。</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=567" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=567</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[mysql中视图的算法说明]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=9" label="数据库集" /> 
	  <updated>2011-12-12T08:20:47+08:00</updated>
	  <published>2011-12-12T08:20:47+08:00</published>
		  <summary type="html"><![CDATA[<p>记录一下：</p>
<p>可选的ALGORITHM子句是对标准SQL的MySQL扩展。ALGORITHM可取三个值：MERGE、TEMPTABLE或UNDEFINED。如果没有ALGORITHM子句，默认算法是UNDEFINED（未定义的）。算法会影响MySQL处理视图的方式。</p>
<div>对于MERGE，会将引用视图的语句的文本与视图定义合并起来，使得视图定义的某一部分取代语句的对应部分。</div>
<div>&nbsp;</div>
<div>对于TEMPTABLE，视图的结果将被置于临时表中，然后使用它执行语句。</div>
<div>&nbsp;</div>
<div>对于UNDEFINED，MySQL将选择所要使用的算法。如果可能，它倾向于MERGE而不是TEMPTABLE，这是因为MERGE通常更有效，而且如果使用了临时表，视图是不可更新的。</div>
<div>&nbsp;</div>
<div>明确选择TEMPTABLE的1个原因在于，创建临时表之后、并在完成语句处理之前，能够释放基表上的锁定。与MERGE算法相比，锁定释放的速度更快，这样，使用视图的其他客户端不会被屏蔽过长时间。</div>
<div>&nbsp;</div>
<div>&nbsp;</div>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=566" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=566</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[收集到的mysql客户端工具]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=9" label="数据库集" /> 
	  <updated>2011-12-05T00:08:29+08:00</updated>
	  <published>2011-12-05T00:08:29+08:00</published>
		  <summary type="html"><![CDATA[<p>windows的：</p>
<p>heidisql</p>
<p>&nbsp;<a href="http://code.google.com/p/heidisql/downloads/list">http://code.google.com/p/heidisql/downloads/list</a>&nbsp;</p>
<p>linux的：</p>
<p>mysql query browser（主要负责查询） + mysql administrator （主要负责管理）</p>
<p>基于web的：</p>
<p>phpmyadmin</p>
<p>&nbsp;</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=565" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=565</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[e46g  电源的信息]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=7" label="硬件资料" /> 
	  <updated>2011-11-28T09:38:06+08:00</updated>
	  <published>2011-11-28T09:38:06+08:00</published>
		  <summary type="html"><![CDATA[<p>&nbsp;e46g 笔记本的电源变压器信息，做个记录，以免以后要找不方便：</p>
<p>输入：100~240V, 1.7A, 50-60Hz</p>
<p>输出：20V, 3.25A</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=564" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=564</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[openwrt挂载u盘做系统盘]]></title>
	  <author>
		 <name>comet</name>
		 <uri>http://blog.3gcomet.com/</uri>
		 <email>iamcomet#163.com</email>
	  </author>
	  <category term="" scheme="http://blog.3gcomet.com/default.asp?cateID=6" label="网络相关" /> 
	  <updated>2011-11-21T08:35:50+08:00</updated>
	  <published>2011-11-21T08:35:50+08:00</published>
		  <summary type="html"><![CDATA[<p>&nbsp; &nbsp; 购入了ddnas，由于自带只有512MB的rom，一番设置安装之后只剩下1MB左右的空间，手上又有个4GB的U盘，打算直接把系统装到U盘上，除开空间大了之外，以后刷固件也不用重新下载和配置软件。把U盘插上去后可以直接识别出来，然后选择挂载为root文件系统，并且一定要把挂载前先进行检查，否则会挂载不成功。</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://blog.3gcomet.com/article.asp?id=563" /> 
	  <id>http://blog.3gcomet.com/default.asp?id=563</id>
  </entry>	
		
</feed>

