2009年8月

dpkg error: trying to overwrite X, which is also in package Y

今天ubuntu9.10 alpha4 升级出现了点问题:

Preparing to replace language-pack-zh 1:9.10 (using .../language-pack-zh_1%3a9.10+20090805_all.deb) ...
Unpacking replacement language-pack-zh ...
Preparing to replace language-pack-zh-base 1:9.10 (using .../language-pack-zh-base_1%3a9.10+20090805_all.deb) ...
Unpacking replacement language-pack-zh-base ...
dpkg: error processing /var/cache/apt/archives/language-pack-zh-base_1%3a9.10+20090805_all.deb (--unpack):
trying to overwrite `/usr/share/locale-langpack/zh_TW/LC_MESSAGES/sed.mo', which is also in package language-pack-zh-hant-base
dpkg-deb: subprocess paste killed by signal (Broken pipe)
Preparing to replace language-pack-gnome-zh 1:9.10 (using .../language-pack-gnome-zh_1%3a9.10+20090805_all.deb) ...
Unpacking replacement language-pack-gnome-zh ...
Preparing to replace language-pack-gnome-zh-base 1:9.10 (using .../language-pack-gnome-zh-base_1%3a9.10+20090805_all.deb) ...
Unpacking replacement language-pack-gnome-zh-base ...
dpkg: error processing /var/cache/apt/archives/language-pack-gnome-zh-base_1%3a9.10+20090805_all.deb (--unpack):
trying to overwrite `/usr/share/locale-langpack/zh_TW/LC_MESSAGES/gnome-settings-daemon.mo', which is also in package language-pack-gnome-zh-hant-base

中文的显示是这样:

(正在读取数据库 ... 系统当前总共安装有 123909 个文件和目录。)
正在解压缩 language-pack-gnome-zh-hans-base (从 .../language-pack-gnome-zh-hans-base_1%3a9.10+20090819_all.deb) ...
dpkg:处理 /var/cache/apt/archives/language-pack-gnome-zh-hans-base_1%3a9.10+20090819_all.deb (--unpack)时出错:
正试图覆盖“/usr/share/locale-langpack/zh_CN/LC_MESSAGES/gnome-settings-daemon.mo”,它属于软件包 language-pack-gnome-zh-base
dpkg-deb: 子进程 粘贴 被信号(Broken pipe)终止了
正在解压缩 language-pack-gnome-zh-hant-base (从 .../language-pack-gnome-zh-hant-base_1%3a9.10+20090819_all.deb) ...
dpkg:处理 /var/cache/apt/archives/language-pack-gnome-zh-hant-base_1%3a9.10+20090819_all.deb (--unpack)时出错:
正试图覆盖“/usr/share/locale-langpack/zh_TW/LC_MESSAGES/gnome-settings-daemon.mo”,它属于软件包 language-pack-gnome-zh-base
dpkg-deb: 子进程 粘贴 被信号(Broken pipe)终止了
在处理时有错误发生:
/var/cache/apt/archives/language-pack-gnome-zh-hans-base_1%3a9.10+20090819_all.deb
/var/cache/apt/archives/language-pack-gnome-zh-hant-base_1%3a9.10+20090819_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

类似这样的错误:

dpkg: error processing /var/cache/apt/archives/AAA (--unpack):
trying to overwrite `/usr/lib/BBB', which is also in package CCC
dpkg-deb: subprocess paste killed by signal (Broken pipe)
Errors were encountered while processing:
AAA
E: Sub-process /usr/bin/dpkg returned an error code (1)
解决方法:

sudo dpkg -i --force-overwrite AAA

(give full path of AAA), and then run

sudo apt-get -f install

again.

[via(翻墙的需要..)]

php写的cet成绩批量查询

php写的cet成绩批量查询

一直都关注cnbeta的动态,没想到20号的时候登录尽然有这条新闻:“2009年6月CET6成绩于今天2009年8月20号早上9点公布” ,cnbeta现在是嘛新闻都出啊。于是乎就拿出了俺的“证件夹”,掏出了准考证开始查成绩,我对这个网上cet查分的网站的认识和评价基本上和"另一个角度看CET查分"一文一样,这次6级得到437分,感觉还是差不多了,因为还重来没有认认真真的停下来背单词、作题,除了考四级的时候作了一张模拟卷。

php写的cet成绩批量查询

这个查询网站通过ajax来查询,需要等待15秒的时间,每次限查询一人成绩,听说08年的时候还要安装activex控件才能查询,对于linux用户就恼火了。通过分析一下http://cet.99sushe.com/这个页面发现没有表单(form),而是这样一句:

<input id="btn" type="button" name="" value="查询" onclick="submit_search();" /></p>

调用了一个js函数submit_search(); 网页引用了一个js文件:http://cet.99sushe.com/res/js/cet0908.js 。内容如下。

var testid = "";
var score = "";
var contenthtml = "";
var sec = 15;  //默认等待15秒钟
String.prototype.trim  =  function(){
return  this.replace(/(^\s*)|(\s*$)/g,  ""); //javascrip没有自带trim函数,用来消除空白符
}
function gid(id) {return document.getElementById(id);} //返回表单输入的准考证号的值
function assertFormat(tid){   //检查准考证号格式
    var reg = /^\d{1,}$/;  //regexp 表示全部为数字
    if (!reg.test(tid) || tid.length != 15 || tid.substr(6, 3) != "091" || get_testtype(tid) == "") { //第6位其的三位数不是091的不准查,意思就是只能查09年上半年的成绩,而后用curl发现根本就没有其他几次考试的数据
    alert("准考证号格式不正确");
    return false;
}
else {
    for (var i = 1; i <= 7; i++) {
        if (gid("t" + i).checked) {
            if (tid.substr(9, 1) != gid("t" + i).value) {
                alert("考试类型和准考证号不匹配");
                return false;
        }
    }
}
}
return true;
}
function submit_search() { //提交查询
    var testid_c = gid("id");
    var c = assertFormat(testid_c.value.trim());
    if(!c) {
        testid_c.focus();
        return;
}
testid = testid_c.value.trim();
if (contenthtml == "") contenthtml = gid("content").innerHTML; //得到content的div的innerHTML
//search(testid);
wait(); //等待15秒
}
function wait(){ //等待的时候把waithtml插入到content的div中
    var sec_all = sec;
    var waithtml = "
    <div id="score_result">
    <div id="score_inner">";
    waithtml += "
    <div id="wait_title">系统正在查询中请稍候</div>
    ";
    waithtml += "
    <div id="time">" + sec + "</div>
    ";
    waithtml += "</div>
    </div>
    ";
    gid("content").innerHTML = waithtml;
    setTimeout("search(" + testid + ")", 0);
    wait_time(sec_all);
}
function wait_time(waitsec){
    if (waitsec > 0) { //15秒没有到
        gid("time").innerHTML = waitsec;
        waitsec--;
        setTimeout("wait_time(" + waitsec + ")", 1000);   //难道这就是传说的中递归调用函数?!
}
    else{
        showscore(score); //时间到了也该显示分数得了
    }
}
function showscore(tscore){
var name = "";
var school = "";
var sarray=new Array();
if(tscore != ""){
    sarray = tscore.split(',');//根据不同的考试类型来给sarray数列赋值
if (sarray.length >= 7) {
    name = sarray[6];
    school = sarray[5];
}
else {
    name = sarray[2];
    school = sarray[1];
}
}
var resulthtml = "
<div id="score_result">
<h1>2009年6月考试成绩查询结果:</h1>
<div id="score_inner">";
resulthtml += " <dl> <dt class="dtleft">考生姓名:</dt> <dd class="ddright">"+name+"</dd>";
resulthtml += "
<dt class="dtleft">学校:</dt> <dd class="ddright">" + school + "</dd>";

resulthtml += "


<dt class="dtleft">考试类别:</dt> <dd class="ddright">";

resulthtml += get_testtype(testid);

resulthtml += "</dd> <dt></dt> <dd style="overflow: hidden; height: 0px; clear: both;"></dd>";

resulthtml += "


<dt class="dtleft">准考证号:</dt> <dd class="ddright">";

resulthtml += testid;

resulthtml += "</dd> </dl>

<ul>";

if(tscore == "") resulthtml += "<li>无法找到对应准考证号的分数,请确认你输入的准考证号无误</li>";

else {

if (sarray.length >= 7) {

resulthtml += "

<li>

<div class="lileft">您的成绩总分:</div>

<div class="liright" style="font-weight:bold;">" + sarray[4] + "</div></li>

";

resulthtml += "

<li>

<div class="lileft">听力:</div>

<div class="liright">" + sarray[0] + "</div></li>

";

resulthtml += "

<li>

<div class="lileft">阅读:</div>

<div class="liright">" + sarray1 + "</div></li>

";

resulthtml += "

<li>

<div class="lileft">综合:</div>

<div class="liright">" + sarray2 + "</div></li>

";

resulthtml += "

<li>

<div class="lileft">写作:</div>

<div class="liright">" + sarray[3] + "</div></li>

";

}

else {

resulthtml += "

<li>

<div class="lileft">您的成绩总分:</div>

<div class="liright" style="font-weight:bold;">" + sarray[0] + "</div></li>

";

}

}

resulthtml += "</ul>

<div style="text-align:center;">姓名中的生僻字可能无法正常显示,以成绩单为准</div>

</div>

";

resulthtml += "

<p class="lang" style="margin-top:-10px;text-align:center;"><input id="btn" onclick="re_search();" type="button" value="返回" /></p>


";

resulthtml += "</div>

";

gid("content").innerHTML = resulthtml; //通过js写html到dom上,用IE,firefox默认的源代码查看工具都没有发现源代码的变化,但是firefox扩展firebug就能看到,看来还是firebug牛逼。

}

function re_search() { //清空数据

var testid = "";

var score = "";

gid("content").innerHTML = contenthtml;

}


function get_testtype(tid) { //根据考号得到考试类型

switch (tid.substr(9, 1)) {

case "1": return "英语四级";

case "2": return "英语六级";

case "3": return "日语四级";

case "4": return "日语六级";

case "5": return "德语四级";

case "7": return "俄语四级";

case "9": return "法语四级";

default: return "";

}

}

function search(tid){ //通过ajax post数据"id="+xxxxxxxxxxxxxxx

var ajax = new Ajax();

ajax.Post("/getscore.html", "id="+tid, search_callback); //这个就是关键,通过post发送数据到getscore.html来完成查询。

}

function search_callback(success, responsetext) {

if (success) {

score = responsetext;

//showscore(score);

}

else {

search(testid);

}

}

总结起来就是向getscore.html post一个数据"id="+xxxxxxxxxxxx

可以通过curl向指定的服务器发送数据包,具体方法此文 “斗智斗勇续 四六级查分技巧” 有介绍,需要注意的一点是查询的服务器有referer验证,referer验证一般用来防盗链,防止数据从非本站的提交上去,不过自定义referer并不是什么好难的事情,此为的作者还做了一个c#的gui前端,基本上就是把cmd的输出放在gui界面上,没有多大的意义。这个 “CET在线连续查分程序” 是别人用c#弄的一个在线查询,可以指定准考证号的起始号码和结束号码,就可以连续查询了。

然后我受到这样的启发,做了一个php版本的,演示地址:http://tunpishuang.iamspace.com/cet.php , 和c#那个略有不同的是并不是指定起始和结束地址,而是直接输入前6位,最多输出6000人的成绩,我贴一下源代码:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>2009年上半年CET院校成绩批量查询 by tunpishuang</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<style type="text/css">
#description{
    border:solid 4px 4px 10px 4px #828282;
    color:#8B0000;
    width:420px;
}
#form{
    border:solid 4px #828282;
    color:#8B0000;
    width:520px;
}
</style>
</head>
<body>
<h1>2009年上半年CET院校成绩批量查询 by tunpishuang</h1>
<div id="description">
A.前6位是地区号.(可以问与你同一城市报名的任何一人)<br />
B.然后是071 (表示07年的第1次,即07年6月份的)<br />
C.然后是1或2 (1代表四级,2代表6级)<br />
D.然后的三位是你的考场号,多为0**或1**<br />
E.最后两位是你的座位<br />
</div>
<form method="post" action="cet_query.php">
<div id="form">
单人成绩查询(输入准考证号)<input type="text" name="tid" id="tid" size="15" maxlength="15" /><input type="submit" value="查一查,更健康" /><p></p>
院校成绩查询(输入准考证号前六位)<input type="text" name="cid" id="cid" size="8" maxlength="6" /><input type="submit" value="查一查,更健康" />
</div>
</form>
<div>
<h1>这个查询程序草草完工,有待完善的地方,但是我不想弄了,弄老一天,人都矿鸟<p></p>
有空到我博客来耍哈,<a href="http://tunps.com">http://tunps.com</a></h1>
</div>
</body>
</html>

cet_query.php

<?php
echo "
<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<title>查询结果</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />
<style type=\"text/css\">
table,td,tr,th{
    border:solid 1px #1E90FF;
    text-align:center;
}
</style>
</head>
<body>
<table cellpadding=\"15\" cellspacing=\"0\" >
<tr>
    <th>听力</th>
    <th>阅读</th>
    <th>综合</th>
    <th>写作</th>
    <th>总分</th>
    <th>学校</th>
    <th>姓名</th>
</tr>
";
$data_fmt=array();

function query($id){

$curl = curl_init();

$curlpost='id='.$id;

curl_setopt($curl, CURLOPT_URL, 'http://cet.99sushe.com/getscore.html');

curl_setopt($curl, CURLOPT_REFERER, 'http://cet.99sushe.com');

curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

curl_setopt($curl, CURLOPT_POST,1);

curl_setopt($curl, CURLOPT_POSTFIELDS,$curlpost);

curl_setopt($curl, CURLOPT_CONNECTTIMEOUT,0);

$data = curl_exec($curl);

global $data_fmt;

$data_fmt=explode(",",$data);

echo "

<tr>

<td>$data_fmt[0]</td>

<td>$data_fmt1</td>

<td>$data_fmt2</td>

<td>$data_fmt[3]</td>

<td>$data_fmt[4]</td>

<td>$data_fmt[5]</td>

<td>$data_fmt[6]</td>

</tr>"

;

curl_close($curl);

}


function person_query($tid){

query($tid);


}

function college_query($cid)

{    $cid=$_POST['cid'];

$cid=sprintf("%.0f",$cid."091200100");

$j=0;

$k=0;

while($k<2){

while($j<100){

for($i=0;$i<30;$i++)

{    $cid=sprintf("%.0f",$cid+1);

query($cid);

}

$cid=$cid-30;

$cid=$cid+100;

$j++;

}

$cid=$_POST['cid'];

$cid=sprintf("%.0f",$cid."091200100");

$j=0;

$k++;


}

}

if(($_POST['tid'])!=0){

$tid=$_POST['tid'];

person_query($tid);

}

if(($_POST['cid'])!=0){

$cid=$_POST['cid'];

college_query($_POST['cid']);

}

echo "</table>

</body>

</html>";

?>

<!--

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>查询结果</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

<style type="text/css">

table,td,tr,th{

border:solid 1px #1E90FF;

text-align:center;

}

</style>

</head>

<body>

<table cellpadding="15" cellspacing="0" >

<tr>

<th>听力</th>

<th>阅读</th>

<th>综合</th>

<th>写作</th>

<th>总分</th>

<th>学校</th>

<th>姓名</th>

</tr>


<tr>

<td><?php echo $data_fmt[0]?></td>

<td><?php echo $data_fmt1?></td>

<td><?php echo $data_fmt2?></td>

<td><?php echo $data_fmt[3]?></td>

<td><?php echo $data_fmt[4]?></td>

<td><?php echo $data_fmt[5]?></td>

<td><?php echo $data_fmt[6]?></td>

</tr>

</table>

</body>

</html>

本博升级到wordpress 2.8.4

wordpress程序的更新确实很快,有时候升级起来都觉得麻烦,担心出现兼容性的问题,记得最后一次升级是升级到2.7.1解决了一个WordPress2.7.1升级超时问题。

我的方法是:

首先一定要做好的工作就是备份,要是没有备份就升级,要是出了问题就完蛋了。我把备份的sql导入本地搭建的wordpress2.8.4,首先查看本地的wordpress升级后运行有没有问题。具体的做法是:

  • cn.wordpress.com下载最新中文版的wordpress。
  • 使用wordpress database backup插件导出sql
  • 本地安装phpnow之类的amp套件,登录自带的phpmyadmin,然后建立一个数据库,比如叫做wordpress。
  • 修改下载下来的wordpress2.8.4-zh_CN根目录下载wp-config-sample.php 改名为wp-config.php 然后打开wp-config.php添加上自己的数据库名,用户名和密码。
  • 用ultrastudio打开sql文件,批量替换http://tunps.com 为http://localhost/wordpress 保存
  • 在phpmysql导入sql文件,打开http://localhost/wordpress/wp-admin/ 应该可以看到升级数据库结构的网页,点升级。
  • 浏览网页是否正常,我浏览自己的主页正常,但是进入单个页面就自动转入主页,或者显示404错误,解决的方法是:打开apache2的配置文件httpd.conf 确认
  • LoadModule rewrite_module modules/mod_rewrite.so 这句前面没有#符号,

    Options FollowSymLinks
    AllowOverride No  //改为AllowOverride All
    Order deny,allow  //改为Order allow,deny
    Deny from all  //改为Allow from all


     

    重启动apache2,再次浏览就没有问题了。

  • 确认本地的没有问题后,在后台,禁用所有插件,使用wordpress默认主题,移除所有小工具。然后直接点“自动升级”,等待4-5分钟,升级完成了,然后进自己的页面看看有没有错误,将出错的插件禁用,然后升级插件或者琢磨其他的方法。

  • 最后将自己的主题还原,小工具都添加上,搞定。

此文是2.8.4升级后的第一文,给我的感觉布局没有太大的变化,后台看稍加的清爽了一下,后台的配色我喜欢,估计是因为之前那个灰色有点审美疲劳了,其他的还在挖掘中。

用gpg(Gnu 隐私卫士)来生成自己的密钥

root@ubuntu:/mirrors/debian# gpg -bao dists/karmic/Release.gpg dists/karmic/Release
gpg: directory `/home/tun/.gnupg' created
gpg: new configuration file `/home/tun/.gnupg/gpg.conf' created
gpg: WARNING: options in `/home/tun/.gnupg/gpg.conf' are not yet active during this run
gpg: keyring `/home/tun/.gnupg/secring.gpg' created
gpg: keyring `/home/tun/.gnupg/pubring.gpg' created
gpg: no default secret key: secret key not available
gpg: signing failed: secret key not available

当执行以上蓝色字体的命令的时候出错了。这个命令功能是生成Release文件的gpg密钥。从字面意思来理解应该是gpg没有默认的gpg密钥, 参照这个minihowto: Gnu 隐私卫士 (GnuPG) 袖珍 HOWTO (中文版) 发现可以用gpg --gen-key来生成自己的密钥:(蓝色字体是我输入的)

root@ubuntu:/mirrors/debian# gpg --gen-key
gpg (GnuPG) 1.4.9; Copyright (C) 2008 Free Software Foundation, Inc.
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

Please select what kind of key you want:
(1) DSA and Elgamal (default)
(2) DSA (sign only)
(5) RSA (sign only)
Your selection? 1
DSA keypair will have 1024 bits.
ELG-E keys may be between 1024 and 4096 bits long.
What keysize do you want? (2048) (直接回车)
Requested keysize is 2048 bits
Please specify how long the key should be valid.
0 = key does not expire
  = key expires in n days
w = key expires in n weeks
m = key expires in n months
y = key expires in n years
Key is valid for? (0) (直接回车)
Key does not expire at all
Is this correct? (y/N)y

You need a user ID to identify your key; the software constructs the user ID
from the Real Name, Comment and Email Address in this form:
"Heinrich Heine (Der Dichter) heinrichh@duesseldorf.de"

Real name: tunpishuang
Email address: tunpishuang@gmail.com
Comment: just 4 fun.
You selected this USER-ID:
"tunpishuang (just 4 fun.) tunpishuang@gmail.com"

Change (N)ame, (C)omment, (E)mail or (O)kay/(Q)uit? o
You need a Passphrase to protect your secret key.

gpg: gpg-agent is not available in this session
We need to generate a lot of random bytes. It is a good idea to perform
some other action (type on the keyboard, move the mouse, utilize the
disks) during the prime generation; this gives the random number
generator a better chance to gain enough entropy.
++++++++++++++++++++++++++++++.+++++.++++++++++++++++++++++++++++++.++++++++++++++++++++++++++++++.+++++++++++++++++++++++++.+++++.+++++>+++++.+++++.................>+++++...+++++
ds
Not enough random bytes available.  Please do some other work to give
the OS a chance to collect more entropy! (Need 283 more bytes)
We need to generate a lot of random bytes. It is a good idea to perform
some other action (type on the keyboard, move the mouse, utilize the
disks) during the prime generation; this gives the random number
generator a better chance to gain enough entropy.
+++++...++++++++++..++++++++++.++++++++++..+++++++++++++++..+++++...++++++++++++++++++++.+++++++++++++++++++++++++.+++++..++++++++++++++++++++++++++++++...+++++..+++++>...++++++++++>+++++.>.+++++......<.+++++.................<+++++>..+++++..............................................................................................................................................................<+++++...>+++++.........................................+++++^^^^^^^^^

(上面这一砣蓝字的主要意思是通过移动鼠标和写入/输出硬盘数据来生成随机数字,我一般使用du / 命令)
gpg: key EDA38ECC marked as ultimately trusted
public and secret key created and signed.

gpg: checking the trustdb
gpg: 3 marginal(s) needed, 1 complete(s) needed, PGP trust model
gpg: depth: 0  valid:   1  signed:   0  trust: 0-, 0q, 0n, 0m, 0f, 1u
pub   1024D/EDA38ECC 2009-08-20
Key fingerprint = 8B43 BB97 2716 0124 83C5  D73B DEE3 732F EDA3 8ECC
uid                  tunpishuang (just 4 fun.) tunpishuang@gmail.com
sub   2048g/15197563 2009-08-20

root@ubuntu:/mirrors/debian# gpg --list-keys    (生成成功了)
/home/tun/.gnupg/pubring.gpg
----------------------------
pub   1024D/EDA38ECC 2009-08-20
uid                  tunpishuang (just 4 fun.) tunpishuang@gmail.com
sub   2048g/15197563 2009-08-20

root@ubuntu:/mirrors/debian# apt-key list(通过这个我们发现改gpg的key和apt的key不是一个库的,但是可以通过gpg导入到apt-key中)
/etc/apt/trusted.gpg
--------------------
pub   1024D/437D05B5 2004-09-12
uid                  Ubuntu Archive Automatic Signing Key ftpmaster@ubuntu.com
sub   2048g/79164387 2004-09-12

pub   1024D/FBB75451 2004-12-30
uid                  Ubuntu CD Image Automatic Signing Key cdimage@ubuntu.com

root@ubuntu:/mirrors/debian# gpg -bao dists/karmic/Release.gpg dists/karmic/Release(执行成功)

You need a passphrase to unlock the secret key for (这点输入私人密钥就ok)
user: "tunpishuang (just 4 fun.) tunpishuang@gmail.com"
1024-bit DSA key, ID EDA38ECC, created 2009-08-20

gpg: gpg-agent is not available in this session