Thursday, March 19, 2009

在只有header的情况下编译Linux Module

按照 http://www.cyberciti.biz/tips/compiling-linux-kernel-module.html 给的例子编译hello内核,怎么都给出错误信息: make: Nothing to be done for `default'.
网上找解决办法,说要下子source,于是下子了source,还是不可以。最后发现是一个很stupid的问题,因为make前面是空格不是tab键,很是郁闷一下。 |||-_-
解决办法是在这个网页看到的: http://www.captain.at/programming/kernel-2.6/


Wednesday, March 18, 2009

发现一款不错的sqlite管理工具

网上浏览的时候发现有人推荐一款基于Firefox插件的sqlite管理工具,sqlite manager, 试用了一下,很是不错. 下载地址 https://addons.mozilla.org/en-US/firefox/addon/5817

Tuesday, March 17, 2009

evince 中文乱码解决

安装了evince看PDF,因为听说比xpdf好,但是安装了不能看中文。继续Google,得到答案如下,实验证明OK:
  1. sudo apt-get install xpdf-chinese-simplified
  2. 下载popper-data,http://poppler.freedesktop.org/poppler-data-0.2.1.tar.gz
  3. 解压 tar xzvf poppler-data-0.2.1.tar.gz
  4. 安装 sudo make install datadir=/usr/share
然后就搞掂了,hoho...

Friday, March 13, 2009

给andLinux配置网络

安装了andLinux,因为要安装新软件,要联网,所以花了一些时间做了配置,具体步骤如下:
  1. Windows, "Network Connections", enable network sharing on your main network card (the one for internet access), by doing so, IP address for "TAP-Colinux" will changed to 192.168.0.1
  2. Modify "TAP-Colinux", set network mask to 255.255.0.0 (the 3rd byte is 0, not 255), also add your DNS server and WINS server IP address
  3. Run "regedt32", do the following changes, andLinux key is not there, so you need to create by yourself.
         [HKEY_LOCAL_MACHINE\SOFTWARE\andLinux\Launcher]
         "IP"="192.168.11.150"
         "Port"=dword:00001f91
  4. In andLinux console. edit /etc/network/interfaces, change
         iface eth1 inet static
         address 192.168.11.150
         netmask 255.255.0.0
         gateway 192.168.0.1
  5. edit /etc/resolv.conf to add your DNS server
  6. edit /etc/hosts, /etc/profile to change windows host IP address to 192.168.0.1
  7. /etc/init.d/networking restart


Thursday, March 12, 2009

在Ubuntu上面安装DBDesigner4

在windows上面用了DBDesigner4了以后,感觉很好用,于是今晚费了一些时间给我的Ubuntu也安装了一份,Ubuntu上面安装比较麻烦,根据不同的电脑,具体步骤可能不一样,这里把我做的步骤列下来供以后参考(我的机子上面已经安装了mysql server和mysql client)

第一部当然是让DBDesigner能够跑起来:
  1. Go to http://www.fabforce.net/downloads.php to download file DBDesigner4.0.5.4.tar.gz, unpack it.
  2. run ./stardb, then view log file at ~/.DBDesigner4/DBD4.log to check what are the library missing (libXft.so.1, libstdc++-libc6.2-2.so.3, libqt.so.2)
  3. libXft.so.1 : ln -s /usr/lib/libXft.so.2.1.2 /usr/lib/libXft.so.1
  4. libsdc++-libc6.2-2.so.3 : Go to http://packages.ubuntu.com/zh-cn/gutsy/libstdc++2.10-glibc2.2 to download the library  file and install
  5. libqt.so.2: Go to http://prdownloads.sourceforge.net/kylixlibs/kylixlibs3-borqt-3.0-2.tar.gz?download to download the package, then unpack, then

    • sudo cp kylixlibs3-borqt/libborqt-6.9.0-qt2.3.so /usr/lib/libborqt-6.9-qt2.3.so

    • cd DBDesigner4/Linuxlib

    • sudo rm libqt.so.2

    • ln -s /usr/lib/usr/lib/kylix3/libborqt-6.9.0-qt2.3.so libqt.so.2


第二步就是让DBDesigner能够顺利连接MySQL

  1. Go to http://www.devart.com/dbx/download.html to download dbExpress MySQL driver for linux, unpack,  sudo cp libsqlmda.so.4.40 /usr/lib/
  2. Under folder DBDesigner4/Linuxlib, do

    • sudo rm libmysqlclient.soln -s /usr/lib/libmysqlclient.so.15 libmysqlclient.so

    • rm libsqlmy.so

    • ln -s /usr/lib/libsqlmda.so.4.40 libsqlmy.so
  3. Run ./startdb,
    ”Database”->”Connect to Database”->"New Database Connection"->"Advance"
     Set GetDriverFunc: getSQLDriverMySQL
接下来就是修改stardb.desktop,把里面的路径改一下,然后把startdb.desktop放到桌面就可以了

使用DBDesigner4进行mysql5建模

这两天需要构建一个MySQL的数据库,想要留下比较正规的文档,就考虑用MySQL建模软件,这样数据库结构比较清晰.

下载了MySQL Workbench最新版本,建模搞定后导出的SQL竟然运行错误,有两个table怎么也创建不了.于是在google上找到了DBDesigner.又用它把数据库重建了一次,然后直接和MySQL server synchronize,很顺利的创建了整个数据库. 以后考虑就是用这个了.

下面是网上找到的DBDesigner的安装方法:

URL: http://www.phpd.cn/show-51-1.html

=============================

DBDesigner4.0.5.6_Setup.exe下载地址:

http://www.fabforce.net/downloadfile.php

官方网站下载的DBDesinger 4中是不能连接MySQL 5的,那是驱动的原因,可以到http://crlab.com/dbx/download.html 下载最新版的驱动,安装好后,复制安装目录中的dbexpmda.dll到DBDesigner的目录当中,还需要下载最新版本的libmysql.dll,同样复制到DBDesigner的目录当中.

驱动准备好了,打开DBDesigner,新建一个MySQL连接,在 Advanced修改GetDriverFunc为getSQLDriverMySQL,这是因为新版驱动对函数名称做了修改的缘故,还要修改 LibraryName为dbexpmda.dll,现在应该能连上MySQL 5了.