xiaoga

Unable to load dynamic library '/usr/lib64/php/modules/mysql.so' - libmysqlclient.so.15

2011-10-31T18:44:00.000-07:00

vi /etc/ld.so.conf.d/mysql-x86_64.conf
/usr/lib64/mysql

https://bugzilla.redhat.com/show_bug.cgi?id=176353

fix exception Unknown relation alias Translation in Doctrine

2011-04-12T05:51:00.000-07:00

Fatal error: Uncaught exception 'Doctrine_Table_Exception' with message 'Unknown relation alias Translation' in

method:
rm model/*Translation*

download directory by ftp

2011-02-26T21:48:00.000-08:00

wget -m -rt10 ftp://user:pass@somehost/x/y/z

eAccelerator install

2010-06-23T21:11:00.000-07:00

wget http://bart.eaccelerator.net/source/0.9.6.1/eaccelerator-0.9.6.1.zip
or
wget http://bart.eaccelerator.net/source/0.9.5/eaccelerator-0.9.5.zip

phpize
./configure
make
make install

cp eaccelerator.ini /etc/php.d/
vi /etc/php.d/eaccelerator.ini

mkdir /tmp/eaccelerator
chmod 0777 /tmp/eaccelerator

php 5.2.13 configure sample

2010-05-29T09:19:00.000-07:00

./configure --build=i686-redhat-linux-gnu --host=i686-redhat-linux-gnu --target=i386-redhat-linux-gnu --program-prefix= --program-suffix=_5.2.13 --prefix=/home/setup/usr --exec-prefix=/home/setup/usr --bindir=/home/setup/usr/bin --sbindir=/home/setup/usr/sbin --sysconfdir=/home/setup/etc --datadir=/home/setup/usr/share --includedir=/home/setup/usr/include --libdir=/home/setup/usr/lib --libexecdir=/home/setup/usr/libexec --localstatedir=/home/setup/var --sharedstatedir=/home/setup/usr/com --mandir=/home/setup/usr/share/man --infodir=/home/setup/usr/share/info --cache-file=../config.cache --with-libdir=lib --with-config-file-path=/home/setup/etc --with-config-file-scan-dir=/etc/php.d --disable-debug --with-pic --disable-rpath --without-pear --with-bz2 --with-curl --with-exec-dir=/usr/bin --with-freetype-dir=/usr --with-png-dir=/usr --enable-gd-native-ttf --without-gdbm --with-gettext --with-gmp --with-iconv --with-jpeg-dir=/usr --with-openssl --with-png --with-pspell --with-expat-dir=/usr --with-pcre-regex=/usr --with-zlib --with-layout=GNU --enable-exif --enable-ftp --enable-magic-quotes --enable-sockets --enable-sysvsem --enable-sysvshm --enable-sysvmsg --enable-track-vars --enable-trans-sid --enable-yp --enable-wddx --with-kerberos --enable-ucd-snmp-hack --with-unixODBC=shared,/usr --enable-memory-limit --enable-shmop --enable-calendar --enable-dbx --enable-dio --with-mime-magic=/usr/share/file/magic.mime --without-sqlite --with-system-tzdata --without-mysql --without-gd --without-odbc --disable-dba --without-unixODBC --disable-pdo --with-xml --enable-soap

clear sendmail queue

2010-05-11T20:29:00.000-07:00

If you ever felt the need of flushing the sendmail queue then this post will be handy to you.

How to flush sendmail queue under linux sendmail mailq command in linux how to flush mail queue in sendmail under linux

If u r worried about sendmail pending mail flush do the following 2 things.

1) manually method –>

delete /var/spool/mail/*.* files in this dir –>

delete /var/mqueue/*.* files

delete /var/spool/mqueue/*.* files

then check if all mail gone using mailq command. all mail will be deleted.

2) using command:

use simple command sendmail -v -q in root prompt. it will flush all pending mails. rest to confirm u can run mailq command if all are really gone !!….

3) if u want perticular domain or user or recepitience mail to delete use this command

sendmail -qS -v test.com it will delete all mail from *@test.com

sendmail -qR -v hotmail.com it will delete all mail from recepient of hotmail….

mysql performance optimization -- add filter

2010-01-19T09:23:00.000-08:00

SELECT id
FROM question
WHERE id <> 8668
AND deleted=0
AND status = 'resolved'
ORDER BY created_at DESC
limit 0,10;

43814 lines
0.26s

SELECT id
FROM question
WHERE id <> 8668
AND deleted=0
AND status = 'resolved'
AND created_at > '2010-01-18'
ORDER BY created_at DESC
limit 0,10;

40 lines
0.01s

clear sendmail mail queue

2009-10-17T19:32:00.001-07:00

rm -f /var/spool/mqueue/*

php memcache

2009-10-16T23:02:00.000-07:00

1. install memcached

wget http://dag.wieers.com/rpm/packages/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm
rpm --install rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm

Or
http://dag.wieers.com/rpm/packages/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
rpm --install rpmforge-release-0.3.6-1.el5.rf.i386.rpm

yum install --enablerepo=rpmforge memcached

2. download memcache.php
wget http://livebookmark.net/memcachephp/memcachephp.zip

3. start memcache

service memcached restart
/usr/local/bin/memcached -d -u root -m 512

Reference:
http://www.howtoforge.com/php_memcache_centos5.0
http://www.nioxiao.com/php-memcached
http://www.ibm.com/developerworks/cn/opensource/os-php-fastapps3/index.html

smtp receive mail error

2009-10-11T22:25:00.000-07:00

ERROR:
(reason: 553 5.3.5 system config error)
config error: mail loops back to me (MX problem?)
554 5.3.5 Local configuration error
Diagnostic-Code: SMTP; 553 5.3.5 system config error

SOLUTION:
If it is Sendmail that you're using, then you should be able to just edit the /etc/mail/local-host-names file and add your domain names that the MTA should recognize as being its self.

REFERENCE:
http://www.webdeveloper.com/forum/showthread.php?t=173882
open webmail

check network listen and connect

2009-09-17T12:11:00.000-07:00

netstat -anp

config smtp server using sendmail

2009-09-17T00:11:00.000-07:00

service saslauthd restart
service sendmail restart

PHPMailer
http://sourceforge.net/projects/phpmailer/files/

redhat下的sendmail+smtp 的配置
http://www.myfaq.com.cn/2005September/2005-09-13/198608.html

用Sendmail配置你的第一台e-mail服务器
http://www.5dmail.net/html/2004-10-26/20041026133839.htm

Configuring Linux Mail Servers
http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch21_:_Configuring_Linux_Mail_Servers

setup Chinese Font in Nokia E75

2009-09-13T19:08:00.000-07:00

1. get a cer file and "DOSPY SignTool v2.2.9.0627.exe" from http://cer.dospy.com/
2. get FontRouter.LT.for.v9.Build20071109.unsigned.sis
3. use the cer file sign FontRouter get Administrator_Signed_FontRouter.LT.for.v9.Build20071109.sisx
4. setup FontRouter on E75
5. copy Simsun Nina ZL by Loname.ttf to E:/data/fonts
6. restart E75

http://www.mitbbs.com/clubarticle/smartphone/30994727_0.html
http://www.dospy.com/bbs/thread-4550277-1-1.html

createElement('div').innerHTML

2009-09-10T19:49:00.000-07:00

function fnGetId(){
var aa = document.getElementById('aa');
alert(aa.innerHTML);
var bb = document.createElement('div');
bb.innerHTML = '

';
aa.insertBefore(bb, aa.firstChild);
alert(aa.innerHTML);
}

to easy use element.innerHTML, you should document.createElement('div'), but not document.createElement('p');

license server of simics

2009-08-13T21:11:00.000-07:00

export LM_LICENSE_FILE=/opt/virtutech/simics-3.0.31/licenses/simics.lic
lmgrd &

gcc keep library path information in binary

2009-07-23T12:42:00.000-07:00

-Wl,-rpath -Wl,/op/gcc-4.2.2/lib

coustom sql query on propel

2009-07-21T13:33:00.000-07:00

$dbMap = Propel::getDatabaseMap();
$con = Propel::getConnection();
$sql = 'xxx sql query...';
$stmt = $con->prepareStatement($sql);
$rs = $stmt->executeQuery(ResultSet::FETCHMODE_NUM);
return XXXPeer::populateObjects($rs);

get google search result

2009-07-13T13:20:00.000-07:00

http://code.google.com/intl/zh-CN/apis/ajaxsearch/documentation/

$url = "http://ajax.googleapis.com/ajax/services/search/web?v=1.0&q=Paris%20Hilton";

// sendRequest
// note how referer is set manually
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_REFERER, "http://www.mysite.com/index.html");
$body = curl_exec($ch);
curl_close($ch);

// now, process the JSON string
$json = json_decode($body);
// now have some fun with the results...

sort links on wordpress

2009-07-08T14:21:00.000-07:00

wp_list_bookmarks($args = '') {
$defaults = array(
'orderby' => 'rating'

Change the orderby parameter in function wp_list_bookmarks.

set time and date in Linux

2009-06-15T11:08:00.000-07:00

date --set="2 OCT 2006 18:00:00"

bind & named DNS service

2009-06-11T13:12:00.000-07:00

http://zh.linuxvirtualserver.org/node/695
http://hi.baidu.com/it0820/blog/item/d37cb7021b7e677f3812bb8e.html
http://blog.csdn.net/orapeasant/archive/2007/09/26/1801395.aspx

SimFlex changing for Sparc+Linux

2009-06-05T18:07:00.000-07:00

/opt/virtutech/flexus-3.0.0/components/DecoupledFeeder/SimicsTracer.cpp
line 389
//DBG_Assert(false);

/opt/virtutech/flexus-3.0.0/core/simics/mai_api.hpp
line 386
//DBG_Assert(false);

/opt/virtutech/flexus-3.0.0/core/simics/sparcmmu.cpp
line 1297
FM_COPY_LIST_FROM_SIMICS

/opt/virtutech/flexus-3.0.0/components/uArch/CoreModel/cycle.cpp
line 1321
//DBG_Assert( getTL() + 1 < 5, ( << theName << " Trap when TL == 5. Processor enters RED_state. Unsupported." ) );

host ip file

2009-05-20T07:51:00.000-07:00

Windows 95/98/Me c:\windows\hosts

Windows NT/2000/XP Pro c:\winnt\system32\drivers\etc\hosts

Windows XP Home c:\windows\system32\drivers\etc\hosts

Linux (/etc/hosts)

create multiple IP for one net card

2009-05-19T12:25:00.000-07:00

ifconfig eth0:0 xx.xx.xx.xx netmask xx.xx.xx.xx

Reference:
http://publish.it168.com/2005/0925/20050925041401.shtml

create a scsi disk on Simics

2009-05-18T13:13:00.000-07:00

1. create a image file
craff --decompress -o mydisk.img mydisk.craff

2. edit machine config file

$scsi_disk2 = (create-std-scsi-disk scsi_id = 2 size = $disk_size)

$scsi_bus.connect $scsi_disk2

@image2 = sim.objects[simenv.scsi_disk2].object_list['sd_image']
@image2.files = [["/mnt/sdb1/simics_image/mydisk.img", simenv.disk_perm, 0, simenv.disk_size]]

4. create partition on new disk
fdisk /dev/sdb

5. format new disk
mkfs.ext3 /dev/sdb1

5. mount new disk
mount /dev/sdb1 /mnt/sdb1

simics profiling cache miss

2009-05-07T12:42:00.000-07:00

./simics -stall targets/sunfire/walnut-common.simics

list-components
list-modules
list-objects

cache_cpu0.add-profiler type = data-read-miss-per-instruction
cache_cpu0.add-profiler type = data-write-miss-per-instruction

c 10000000
r

cache_cpu0.statistics
cache_cpu0_prof_data_read_miss_per_instruction.address-profile-data

http://youngdean.spaces.live.com/blog/cns!C9DCEEC5C7C0B32F!619.entry
http://youngdean.spaces.live.com/blog/cns!C9DCEEC5C7C0B32F!640.entry
http://youngdean.spaces.live.com/blog/cns!C9DCEEC5C7C0B32F!641.entry

submit and update sitemap.xml to Google

2009-05-05T07:10:00.001-07:00

http://www.google.com/support/webmasters/bin/answer.py?answer=34609

To resubmit your Sitemap using an HTTP request:

Issue your request to the following URL:
```
www.google.com/webmasters/tools/ping?sitemap=sitemap_url
```
For example, if your Sitemap is located at http://www.example.com/sitemap.gz, your URL will become:
```
www.google.com/webmasters/tools/ping?sitemap=http://www.example.com/sitemap.gz
```

URL encode everything after the /ping?sitemap=:

www.google.com/webmasters/tools/ping?sitemap=http%3A%2F%2Fwww.yoursite.com%2Fsitemap.gz

Issue the HTTP request using wget, curl, or another mechanism of your choosing.

complie tpcw java using gij

2009-04-30T14:58:00.000-07:00

javac -classpath /root/setup/apache-tomcat-5.5.27/common/lib/servlet-api.jar:/root/setup/tpc-w/src/servlets/ *.java

gij connect mysql using jdbc

2009-04-30T14:51:00.000-07:00

please using mysql-connector-java-3.0.17-ga-bin.jar
mysql jdbc driver version 3.1, 5.0, 5.1 all not available.

java -cp .:/root/setup/mysql-connector-java-3.0.17-ga/mysql-connector-java-3.0.17-ga-bin.jar TPCW_Populate

mysql -V
mysql Ver 14.7 Distrib 4.1.12, for unknown-linux-gnu (sparc) using readline 4.3

gij --version
java version "1.4.2"
gij (GNU libgcj) version 4.1.2

Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

setup tomcat under sparc linux

2009-04-28T09:49:00.000-07:00

1. install gcc, g++, gcj, gij 4.1.2
../gcc-4.1.2/configure --prefix=/opt/gcc-4.1.2 --program-suffix=4.1.2 --host=sparc-redhat-linux --build=sparc-redhat-linux --target=sparc-redhat-linux

2. install java compat

3. export JAVA_HOME=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0

4. download apache-tomcat-5.5.27.tar.gz and apache-tomcat-5.5.27-compat.tar.gz

5. vi bin/setclasspath.sh
_RUNJAVA='/opt/gcc-4.1.2/bin/gij4.1.2'

6. ./startup.sh

rss feed xml parser

2009-04-26T20:48:00.000-07:00

http://rssphp.net/
http://www.phpclasses.org/browse/package/3724.html

URL redirect 301 by .htaccess file

2009-04-26T15:45:00.000-07:00

RewriteEngine On

RewriteCond %{HTTP_HOST} ^francetop.net [NC]
RewriteRule ^(.*)$ http://www.francetop.net/$1 [L,R=301]

Reference
http://www.webweaver.nu/html-tips/web-redirection.shtml

mysql slow queries log

2009-04-23T12:13:00.000-07:00

1. config start slow query log
vi my.cnf

[mysqld]
set-variable=long_query_time=1
log-slow-queries=/home/www/log/mysql-log-slow-queries.log

2. restart mysql server

3. setup mysqlsla
yum install perl-DBI perl-DBD-MySQL perl-DBD-Pg
wget http://hackmysql.com/scripts/mysqlsla

4. using mysqlsla parse mysql slow query log

./mysqlsla-2.03/bin/mysqlsla --user xxx --password -lt slow --ex mysql-log-slow-queries.log --socke=/tmp/mysql.sock

./mysqlsla-1.8-DEBUG --user xxx --password --slow mysql-log-slow-queries.log --socke=/tmp/mysql.sock

web server performance analysis

2009-04-23T12:11:00.000-07:00

1. check system load
w

2. check cpu utilization
ps

3. check memory usage and swap disk usage

eAccelerator log

2009-04-13T05:47:00.000-07:00

eAccelerator will write many log on apache error_log, link this:

EACCELERATOR hit:"/usr/local/www/xxxx.php"

To avoid this,
add option 
eaccelerator.debug="0"
to your server php.ini configure.

php 301 redirect

2009-04-10T12:15:00.000-07:00

header ('HTTP/1.1 301 Moved Permanently');
header ('Location: '.$location);

HTTP Status Code Definitions

2009-04-10T11:56:00.000-07:00

301 Moved Permanently

http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html

tpcw

2009-04-10T11:09:00.000-07:00

homepage
http://localhost:8080/tpcw/TPCW_home_interaction

Chinese character UTF8 encoding

2009-04-10T07:25:00.000-07:00

http://theorem.ca/~mvcorks/cgi-bin/unicode.pl.cgi?start=4E00&end=9FFF
http://www.zhouhaihe.com/tool/UTF-8.htm
http://www.dc9.cn/post/85.html

ssh

2009-04-09T13:06:00.000-07:00

problem:

ssh_exchange_identification: Connection closed by remote host

Check /etc/hosts.allow and /etc/hosts.deny.
/etc/init.d/sshd restart

/etc/ssh/sshd_config

simics usage

2009-04-06T12:00:00.000-07:00

start

./simics targets/x86-440bx/enterprise-common.simics
continue

copy file into simics

mkisofs -r -o setup.iso ./setup/
new-file-cdrom setup.iso
cd0.insert setup
mkdir /mnt/cdrom
mount /dev/cdrom /mnt/cdrom

network

connect-real-network 10.10.0.12
list-port-forwarding-setup
connect-real-network-port-in ethernet-link=link0 target-ip=10.10.0.12 target-port=8080 host-port=4880 -tcp

ifconfig eth0 10.10.0.12 netmask 255.255.255.0 broadcast 10.10.0.255

setup new OS

./simics targets/sunfire/walnut-cd-install1.simics
new-file-cdrom install-sparc64-universal-2008.0.iso
cd0.insert install-sparc64-universal-2008
save-persistent-state install-phase1.state

./simics targets/sunfire/walnut-cd-install2.simics
load-persistent-state install-phase1.state
save-persistent-state install-phase2.state

./simics targets/sunfire/walnut-common.simics

bin/craff walnut-install.disk

send mail in linux server

2009-04-06T11:20:00.000-07:00

send a mail

mail -v -s "test of my mail on fr" xxx@gmail.com

start mail service

service sendmail start

forward ssh server's graphic display to client

2009-04-05T10:39:00.000-07:00

on client:

vi /etc/ssh/ssh_config

ForwardX11 yes

test

firefox -no-remote

Reference:

http://www.ixdba.net/article/29/2026.html

website seo

2009-04-05T09:41:00.000-07:00

http://www.seomoz.org
http://www.seomoz.org/blog/the-beginners-checklist-for-small-business-seo
http://www.seomoz.org/blog/the-beginners-checklist-for-learning-seo
http://www.seomoz.org/tools

SVN server configure

2009-04-04T13:52:00.000-07:00

0. setup svn
mkdir svn_dir
cd svn_dir
svnadmin create xxx_dir
svn import . file:///xxx_dir/
svnserve -d -r svn_dir
svn co svn://domain/xxx_dir/

1. not allow anonymous access
vi conf/svnserve.conf
anon-access = none
auth-access = write
password-db = passwd

2. not cache password
vi ~/.subversion/config
store-passwords = no
store-auth-creds = no

Reference:
http://www.subversion.org.cn/svnbook/1.4/index.html
http://www.subversion.org.cn/?action-viewnews-itemid-1

Cron timer in Linux

2009-04-04T11:16:00.001-07:00

timer task in Linux
http://cn.tech.yahoo.com/050531/55/26zxf.html

setup JDK JRE

2009-04-02T12:00:00.000-07:00

http://java.sun.com/javase/6/webnotes/install/jdk/install-linux.html

get a setup file such as jdk-6u12-linux-i586.bin
run it directly

character web browser: lynx

2009-04-02T11:57:00.000-07:00

get it from http://lynx.isc.org/current/index.html
very cool when you on a console

./configure
make
cp lynx.cfg /usr/local/etc/
cp samples/lynx.lss /usr/local/etc/
./lynx

msn protocol and bot

2009-03-30T16:56:00.000-07:00

http://www.hypothetic.org/docs/msn/notification/authentication.php

serve gzip compressed content using apache 2

2009-03-27T13:39:00.000-07:00

enable mod_deflate in httpd.conf

edit .htaccess file

AddOutputFilterByType DEFLATE text/html text/css text/plain text/xml application/x-javascript application/json
Header append Vary Accept-Encoding

check


http://www.port80software.com/tools/compresscheck.asp

nginx

2009-03-26T06:52:00.000-07:00

Nginx 0.7.x + PHP 5.2.8（FastCGI）搭建胜过Apache十倍的Web服务器（第4版） http://blog.s135.com/post/366/

setup Postgresql

2009-03-19T07:24:00.000-07:00

1. download Postgresql (postgresql-8.3.7.tar.gz) from http://www.postgresql.org/download/

2. ./configure --prefix=

3. gmake

4. gmake install

5. adduser postgres

6. mkdir /data

7. chown postgres /data

8. initdb -D /data

9. export PATH=$PATH:/bin/

setup axis2

2009-03-19T07:12:00.000-07:00

1. download axis2 from http://ws.apache.org/axis2/
2. unzip axis2-std-0.95-bin.zip
3. jar -xvf ../axis2.war
4. export AXIS2_HOME=....

Geronimo setup

2009-03-19T06:57:00.000-07:00

1. download Geronimo (Geronimo 1.0 with Tomcat) from http://geronimo.apache.org/

2. follow the steps in Quick start

3. start the server
java -jar server.jar
then you can see Geronimo's welcome page in http://localhost:8080/

4. mkdir webapps as

5. Deploy an application
java -jar deployer.jar --user system --password manager deploy /HelloWorld.war

6. manage applications
http://localhost:8080/console
default user: system:manager

7. export GERONIMO_HOME=...

DBT4 setup

2009-03-19T06:55:00.000-07:00

1. download DBT4 from http://osdldbt.sourceforge.net/

2. setup Germonimo 1.0

3. setup Axis2 version 0.95

4. setup Postgresql

5. vi scripts/pgsql/pgsql_profile.in

6. autoreconf --install

7. ./configure

8. vi src/Lcg64Rng/build.xml

9. cd src/Lcg64Rng/; ant

10. vi src/data/build.xml

11. cd src/data/; ant

12. vi src/app/build.xml

13. cd src/app/; ant

14. vi src/driver/build.xml

15. cd src/driver/; ant

16. ./scripts/pgsql/build_db.sh -e 1 -g

17. unzip axis2.war

18. cp geronimo-1.0/repository/activemq/jars/activemq-core-3.2.1.jar WEB-INF/lib/

19. cp dbt4-0.5/build/lib/Lcg64Rng.jar WEB-INF/lib/

20. cp postgresql-8.3-604.jdbc4.jar WEB-INF/lib/

21. cp dbt4-0.5/build/lib/Dbt4Service.aar WEB-INF/services/

22. jar cvf ~/axis2.war ./*

23. java -jar deployer.jar --user system --password manager deploy ~/axis2.war
now you can see dbt4 service from http://localhost:8080/axis2

24. vi scripts/myjava
JDBC_DRIVER=........./postgresql-8.3-604.jdbc4.jar

24. ./scripts/run_workload.sh -b 1 -d 1

mysql config

2009-03-09T08:17:00.000-07:00

connect number

add to my.cnf mysqld part

max_connections=250
tmp_table_size=67108864
sort_buffer_size=4194288
table_cache=128

mysql
show variables; to query config data for mysql

build.xml java

2009-03-07T14:15:00.000-08:00

mysql operation

2009-03-07T13:18:00.000-08:00

/usr/bin/mysqladmin -u root password 'new-password'

GRANT ALL ON *.* TO 'myuser'@'somehost' IDENTIFIED BY 'mypass';

GRANT ALL PRIVILEGES ON *.* TO msentissi@"192.168.3.10" identified by
"yourpassword";

apache log

2009-03-06T14:40:00.001-08:00

log format
http://httpd.apache.org/docs/2.2/mod/mod_log_config.html

apache code read

2009-03-06T12:21:00.000-08:00

httpd.h
struct request_rec

mod_log_config.c

static const char *process_item(request_rec *r, request_rec *orig, log_format_item *item)

log_request_time()

web server measurment tool

2009-03-06T12:10:00.000-08:00

webstone

linux context switch number query

2009-03-06T12:02:00.000-08:00

sar -w 2 5

lxr

2009-03-06T11:57:00.000-08:00

/tmp/lxr/bin/genxref /www/lxr/source/httpd-2.2.11
glimpseindex -n -o -H /www/lxr/source/httpd-2.2.11 www/lxr/source/httpd-2.2.11

website speed up

2009-02-27T08:45:00.000-08:00

page analysis tool

http://www.websiteoptimization.com/services/analyze/

tutorial

http://www.sitepoint.com/article/web-site-optimization-steps/
http://developer.yahoo.com/performance/rules.html

http://www.seomoz.org

msn messager robot

2009-02-25T05:55:00.000-08:00

http://flumpcakes.co.uk/php/msn-messenger

http://www.findmysoft.com/scripts/msn_web_messenger_script/

http://www.phpclasses.org/browse/package/1407.html

get contact list from email account

2009-02-25T05:45:00.000-08:00

http://drupal.org/node/297877

http://forums.pligg.com/modification-tutorials/9637-contact-import-msn-yahoo-gmail-myspace.html

http://www.e-citizen.com/contacts/libs/

http://www.dominican.eventsworldwide.net/include/contactgrabber/contacts/libs/

http://forums.devarticles.com/php-development-48/import-email-addressess-from-yahoo-gmail-hotmail-86529.html

http://www.phphulp.nl/php/print/4/1355/0/scripts/

configure culture in symfony

2009-02-24T06:36:00.000-08:00

./apps/frontend/config/settings.yml: default_culture: fr

./apps/frontend/config/i18n.yml: default_culture: en

./apps/frontend/config/factories.yml:# default_culture: %SF_DEFAULT_CULTURE%

gmail contactor list

2009-02-23T10:19:00.000-08:00

setup python
http://code.google.com/support/bin/answer.py?answer=75582

http://code.google.com/apis/contacts/docs/1.0/developers_guide_python.html

http://code.google.com/apis/gdata/articles/php_client_lib.html
http://code.google.com/apis/gdata/samples.html

http://code.google.com/apis/contacts/
http://code.google.com/apis/contacts/docs/2.0/developers_guide_protocol.html

cookie in symfony

2009-02-23T05:17:00.000-08:00

http://www.symfony-project.org/cookbook/1_0/en/cookie
http://www.symfony-project.org/book/1_0/06-Inside-the-Controller-Layer
http://us2.php.net/setcookie

html table style

2009-02-21T08:51:00.001-08:00

svn command

2009-02-20T13:55:00.000-08:00

svn log -v
svn revert --recursive .

ssh to remote host without password

2009-02-19T09:08:00.000-08:00

ssh-keygen -t dsa
ssh-copy-id -i ~/.ssh/id_dsa.pub user_name@remote_host_name

spin lock perfer same chip core

2009-02-18T13:30:00.000-08:00

typedef struct{
int __triger;
volatile int spin;
volatile int flags[800];
volatile int queueLast;
volatile int owner;
volatile int count;
}my_spinlock_t;

int my_spin_init(my_spinlock_t * s, void *);

void my_spin_lock(my_spinlock_t * s);

void my_spin_unlock(my_spinlock_t * s);

void my_spin_dump(my_spinlock_t * s);

#define HAS_LOCK 0
#define MUST_WAIT 1
#define BACKOFF_BASE 100000

inline int g_atomic_int_exchange_and_add (int *atomic, int val)
{
int result;
__asm__ __volatile__ ("lock; xaddl %0,%1"
: "=r" (result), "=m" (*atomic)
: "0" (val), "m" (*atomic));
return result;
}

inline int g_atomic_int_compare_and_exchange (int *atomic, int oldval, int newval)
{
int result;

__asm__ __volatile__ ("lock; cmpxchgl %2, %1"
: "=a" (result), "=m" (*atomic)
: "r" (newval), "m" (*atomic), "0" (oldval));

return result;
}

int my_gettid()
{
int * p = (int*)pthread_self();
return p[18];
}

int my_spin_init(my_spinlock_t * s, void *p)
{
s->spin = HAS_LOCK;
return 0;
}

void my_spin_lock(my_spinlock_t * s)
{
volatile int i;
int b;
int cur_id, my_id = my_gettid();
my_id = my_id%8/2+1;

while( cur_id = g_atomic_int_compare_and_exchange(&s->spin, HAS_LOCK, my_id) ){
b = BACKOFF_BASE;
if(cur_id == my_id) b=0;
while(s->spin != HAS_LOCK)
for(i=b;i;i--);
}
}

void my_spin_unlock(my_spinlock_t * s)
{
s->spin = HAS_LOCK;
}

simple spin lock with backoff delay

2009-02-18T11:21:00.000-08:00

typedef struct{
volatile int spin;
}my_spinlock_t;

int my_spin_init(my_spinlock_t * s, void *);

void my_spin_lock(my_spinlock_t * s);

void my_spin_unlock(my_spinlock_t * s);

void my_spin_dump(my_spinlock_t * s);

#define HAS_LOCK 0
#define MUST_WAIT 1
#define BACKOFF_BASE 100000

inline int g_atomic_int_exchange_and_add (int *atomic, int val)
{
int result;
__asm__ __volatile__ ("lock; xaddl %0,%1"
: "=r" (result), "=m" (*atomic)
: "0" (val), "m" (*atomic));
return result;
}

inline int g_atomic_int_compare_and_exchange (int *atomic, int oldval, int newval)
{
int result;

__asm__ __volatile__ ("lock; cmpxchgl %2, %1"
: "=a" (result), "=m" (*atomic)
: "r" (newval), "m" (*atomic), "0" (oldval));

return result == oldval;
}

int my_spin_init(my_spinlock_t * s, void *p)
{
s->spin = HAS_LOCK;
return 0;
}

void my_spin_lock(my_spinlock_t * s)
{
volatile int i;
while( !g_atomic_int_compare_and_exchange(&s->spin, HAS_LOCK, MUST_WAIT) ){
for(i=BACKOFF_BASE;i;i--);
}
}

void my_spin_unlock(my_spinlock_t * s)
{
s->spin = HAS_LOCK;
}

void my_spin_lock(my_spinlock_t * s)
{
volatile int i;
while( !g_atomic_int_compare_and_exchange(&s->spin, HAS_LOCK, MUST_WAIT) ){
while(s->spin == MUST_WAIT)
for(i=BACKOFF_BASE;i;i--);
}
}

simple spin lock

2009-02-18T10:50:00.000-08:00

typedef struct{
int spin;
}my_spinlock_t;

int my_spin_init(my_spinlock_t * s, void *);

void my_spin_lock(my_spinlock_t * s);

void my_spin_unlock(my_spinlock_t * s);

void my_spin_dump(my_spinlock_t * s);

#define HAS_LOCK 0
#define MUST_WAIT 1

inline int g_atomic_int_compare_and_exchange (int *atomic, int oldval, int newval)
{
int result;

__asm__ __volatile__ ("lock; cmpxchgl %2, %1"
: "=a" (result), "=m" (*atomic)
: "r" (newval), "m" (*atomic), "0" (oldval));

return result == oldval;
}

int my_spin_init(my_spinlock_t * s, void *p)
{
s->spin = HAS_LOCK;
return 0;
}

void my_spin_lock(my_spinlock_t * s)
{
while( !g_atomic_int_compare_and_exchange(&s->spin, HAS_LOCK, MUST_WAIT) );
}

void my_spin_unlock(my_spinlock_t * s)
{
s->spin = HAS_LOCK;
}

queue-based spin lock

2009-02-18T10:27:00.000-08:00

typedef struct{
volatile int flags[80];
volatile int queueLast;
volatile int owner;
}my_spinlock_t;

int my_spin_init(my_spinlock_t * s, void *);

void my_spin_lock(my_spinlock_t * s);

void my_spin_unlock(my_spinlock_t * s);

#define HAS_LOCK 0
#define MUST_WAIT 1

int g_atomic_int_exchange_and_add (int *atomic, int val)
{
int result;
__asm__ __volatile__ ("lock; xaddl %0,%1"
: "=r" (result), "=m" (*atomic)
: "0" (val), "m" (*atomic));
return result;
}

int my_gettid()
{
int * p = (int*)pthread_self();
return p[18];
}

int my_spin_init(my_spinlock_t * s, void *p)
{
int i;
s->flags[0] = HAS_LOCK;
for(i=1;i<8;i++)
s->flags[i*10] = MUST_WAIT;
s->queueLast = 0;
return 0;
}

void my_spin_lock(my_spinlock_t * s)
{
int myPlace, t;
volatile int * p;

myPlace = g_atomic_int_exchange_and_add(&s->queueLast, 1);
//myPlace = my_gettid();

t = myPlace % 8;

p = &s->flags[t*10];
while(*p == MUST_WAIT);
s->flags[t*10] = MUST_WAIT;
s->owner = myPlace;
}

void my_spin_unlock(my_spinlock_t * s)
{
int myPlace = s->owner;
s->flags[((myPlace+1) % 8)*10] = HAS_LOCK;
}

Reference
Thomas E. Anderson, "The Performance of Spin Lock Alternatives for Shared-Memory Multiprocessors", IEEE Transactions on Parallel and Distributed Systems, 1990

atomic operation function in C language

2009-02-17T12:58:00.000-08:00

http://gcc.gnu.org/onlinedocs/gcc/Atomic-Builtins.html
http://library.gnome.org/devel/glib/2.16/glib-Atomic-Operations.html
http://java.sun.com/javase/6/docs/api/java/util/concurrent/atomic/AtomicReferenceFieldUpdater.html
https://stage.maemo.org/svn/maemo/projects/haf/branches/glib2.0/2.8.6-1osso5/glib/gatomic.c
http://www.sogou.com/labs/report/4-2.pdf

div's position and overlap

2009-02-15T14:24:00.000-08:00

blue

red

blue

red

blue

red

ext js library

2009-02-15T12:15:00.000-08:00

Firfox error message: ext is not defined

<link type="text/css" rel="stylesheet" href="/js/ext-2.2/resources/css/ext-all.css"/>
<script type="text/javascript" src="/js/ext-2.2/adapter/ext/ext-base.js"></script>
<script type="text/javascript" src="/js/ext-2.2/ext-all.js"></script>

vsftpd config

2009-02-12T09:40:00.000-08:00

add user

useradd -d /dir -s /sbin/nologin ftpusername
passwd ftpusername

SQL sample

2009-02-11T10:01:00.000-08:00

1. one table join itself
select file.id from history t1, history t2, file where file.id=t1.file_id and t1.id<>t2.id and t1.updated_at=t2.updated_at and t1.ip=t2.ip and t1.file_id<>114 and t2.file_id=114 group by t1.file_id order by count(t1.file_id) desc;

URL rewrite

2009-02-09T16:25:00.000-08:00

vi .htaccess

<IfModule mod_rewrite.c>
RewriteEngine On

#rewrite xxxx.org to www.xxxx.org
RewriteCond %{HTTP_HOST} ^xxxx.org$
RewriteRule ^(.*) http://www.xxxx.org/$1 [QSA,L,R=301]

</ifmodule>

Apache log setting

2009-02-09T09:06:00.000-08:00

LogFormat "%h %l %u %t \"%r\" %>s %b" common
      CustomLog logs/access_log common

<virtualhost>
  ServerName xxxx
  ServerAlias xxxx.com
  DocumentRoot /home/www/xxxx.com/web
  AddType application/x-httpd-php .php
      <directory>
          AllowOverride All
          Order allow,deny
          Allow from all
      </directory>
  RewriteLog /home/www/xxxx.com/log/xxxx.com_rewrite_log
  RewriteLogLevel 3
  ErrorLog /home/www/xxxx.com/log/xxxx.com_error_log
  CustomLog /home/www/xxxx.com/log/xxxx.com_access_log common
</virtualhost>

Reference
http://httpd.apache.org/docs/1.3/logs.html

Linux system call

2009-02-09T08:06:00.000-08:00

include/asm/unistd_32.h
arch/x86/kernel/syscall_table_32.S

#include <linux/unistd.h>
#define __NR_my_kernel_init 327

//_syscall1(int, my_kernel_init, int, debug);
int my_kernel_init(int debug)
{
return syscall(__NR_my_kernel_init, debug);
}
int main()
{
int ret = my_kernel_init(1);
printf( "%d\n", ret);
return 0;
}

when I using _syscall1(int, my_kernel_init, int, debug), I got an error:
test.c:6: error: expected declaration specifiers or ‘...’ before ‘my_kernel_init’
test.c:6: error: expected declaration specifiers or ‘...’ before ‘debug’
test.c:6: warning: data definition has no type or storage class

Reference:
Linux system call list

Kernel command using Linux system calls, Explore the SCI and add your own calls

MySql error

2009-02-07T12:01:00.000-08:00

Can't open file: 'xxxx.MYI' (errno: 13)

perror 13
OS error code 13: Permission denied
chmod 777 xxxx.MYI

Repair MySql database table index file

myisamchk -r -q xxxx.MYI

MySQL said: Documentation
#1114 - The table 'xxxx' is full

table xxxx is too large

ERROR 1030 (HY000): Got error 127 from storage engine

perror 127
MySQL error code 127: Record-file is crashed

repair table xxx USE_FRM;

Reference
http://bbs.ylqonline.net/redirect.php?tid=332&goto=lastpost

set icon for your website

2009-02-05T14:35:00.000-08:00

add in head part of page

<link rel="shortcut icon" href="/img/favicon.png">

not only ico file, but also png image work well.

vi config

2009-02-05T14:31:00.000-08:00

vi ~/.vimrc

set tabstop=4
set shiftwidth=4
set nu
syntax on
set smartindent
set incsearch
set vb t_vb=

In CentOS, vim doesn't alias to vi for root (see /etc/profile.d/vim.sh)
so root must use vim directly.

set CPU frequency in Linux

2009-02-05T13:43:00.000-08:00

ls /sys/devices/system/cpu/cpu0/
cat /sys/devices/system/cpu/cpu0/cpufreq/scaling_driver etc.

scaling_available_governors: ondemand userspace performance
scaling_available_frequencies

modprobe acpi-cpufreq
cat /proc/cpuinfo | grep 'cpu MHz'
cpufreq-selector
-c, --cpu CPU Number
-g, --governor Governor
-f, --frequency Frequency in KHz
/usr/sbin/cpuspeed -m 2000000 -M 2000000 -s 7

/etc/sysconfig/cpuspeed, configuration file
/etc/init.d/cpuspeed, initialzation script
/usr/sbin/cpuspeed, cpuspeed program

cpufreq-set

cpufreq-set -d 2667000 -u 2667000 -c 0

cpufreq-info

linux networking command

2009-02-05T13:36:00.000-08:00

print route table

netstat -r

add route table entry

route add -net 172.16.2.0 netmask 255.255.255.0 gw 172.16.2.2

restart network

/etc/init.d/networking restart

Build and using a new glibc

2009-02-05T13:25:00.000-08:00

export LD_LIBRARY_PATH=
../glibc-2.5/configure --prefix=/home/xxxx/nptl/install
make
make install
link to new glibc

gcc test.c -L/home/xxxx/nptl/install/lib -I/home/xxxx/nptl/install/include -static -lpthread

modify glibc

some definition, include pthread_mutex_t etc.
glibc-2.5/nptl/sysdeps/unix/sysv/linux/i386/bits/pthreadtypes.h

some nptl function
glibc-2.5/nptl/pthread_mutex_lock.c
glibc-2.5/nptl/sysdeps/i386/pthread_spin_lock.c

cp glibc-2.5/nptl/sysdeps/unix/sysv/linux/i386/bits/pthreadtypes.h install/include/bits/pthreadtypes.h
cp build/nptl/libp* install/lib
rm build/libc.so

Assembly manual

2009-02-05T09:43:00.000-08:00

Inline assembly for x86 in Linux

AT&T ASM Syntax

manual

set meta information for a page in Symfony

2009-02-04T14:57:00.000-08:00

$response = $this->getResponse();
$response->setTitle($title);
$response->addMeta('keywords', $kws);
$response->addMeta('description', $desc);

get thread id

2009-02-04T11:47:00.000-08:00

#include
#include
#include

int my_gettid()
{
int * p = (int*)pthread_self();
int pid = getpid();
assert(pid == p[19]);
return p[18];
}

int my_gettid(pthread_t thread)
{
int *p = (int*)thread;
return p[18];
}

void BusyWork(void* t)
{
int tid = my_gettid();
int pid = getpid();
printf("worker tid %d pid %d\n",tid,pid);
}

int main()
{
int tid = my_gettid();
int pid = getpid();
printf("main tid %d pid %d\n",tid,pid);

pthread_t thread;
pthread_create(&thread, NULL, BusyWork, NULL);

pthread_join(thread,NULL);
return 0;
}

pthread spin lock in glibc nptl

2009-02-04T11:17:00.000-08:00

The Glibc I using is glibc-2.5, computer architecture is i386

type definition of pthread_spinlock_t

nptl/sysdeps/unix/sysv/linux/i386/bits/pthreadtypes.h
/* POSIX spinlock data type. */
typedef volatile int pthread_spinlock_t;

function pthread_spin_lock

nptl/sysdeps/i386/pthread_spin_lock.c

my test of spin lock

#include
#include

#define NUM_THREADS 8
long sum;
pthread_spinlock_t sumlock;

int my_sleep(int i)
{
int j,k,n=0;
for(;i>0;i--)
for(j=0;j<100;j++)
for(k=0;k<100;k++)
n++;
return n;
}

void *BusyWork(void *threadid)
{
int i,k;
long tid = (long)threadid;
for(i=0;i<10;i++){
k = my_sleep(3);
pthread_spin_lock (&sumlock);
printf("%d ", tid);
sum += k;
pthread_spin_unlock (&sumlock);
}
pthread_exit((void *) 0);
}

int main (int argc, char *argv[])
{
pthread_t thread[NUM_THREADS];
int rc, t;
void *status;
pthread_spin_init(&sumlock, NULL);
for(t=0; t
rc = pthread_create(&thread[t], NULL, BusyWork, (void*)t);
if (rc){
return 0;
}
}
for(t=0; t
rc = pthread_join(thread[t], &status);
if (rc){
printf("ERROR; return code from pthread_join() is %d\n", rc);
return 0;
}
}
printf("sum = %ld\n", sum);
pthread_spin_destroy(&sumlock);
pthread_exit(NULL);
}

Bind a thread/process to a CPU core

2009-02-04T10:59:00.000-08:00

#include <sched.h>

Bind the invoke thread to a CPU core which id is p

void thread_bind(int p)
{
cpu_set_t mask;
__CPU_ZERO(&mask);
__CPU_SET(p, &mask);
sched_setaffinity(0, sizeof(mask), &mask);
}

Bind thread which id is tid to a CPU core p

void thread_bind(int p, int tid)
{
cpu_set_t mask;
__CPU_ZERO(&mask);
__CPU_SET(p, &mask);
sched_setaffinity(tid, sizeof(mask), &mask);
}

Reference

Get thread id

Add a /proc/ file using Linux kernel module

2009-02-04T10:46:00.000-08:00

Reference
1. Create a Linux Module
2. http://www.ibm.com/developerworks/linux/library/l-proc.html

vi command

2009-02-04T08:19:00.000-08:00

1. full text replacement
:1,$s/tom/David/g
from first line to last line, replace tom with David

Search in Linux

2009-02-04T08:15:00.001-08:00

grep -R xxxx .

Create a Linux module

2009-02-03T19:02:00.000-08:00

1. vi simple-lmk.c

#include 

/* Defines the license for this LKM */
MODULE_LICENSE("GPL");

/* Init function called on module entry */
int my_module_init( void )
{
printk(KERN_INFO "my_module_init called.  Module is now loaded.\n");
return 0;
}

/* Cleanup function called on module exit */
void my_module_cleanup( void )
{
printk(KERN_INFO "my_module_cleanup called.  Module is now unloaded.\n");
return;
}

/* Declare entry and exit functions */
module_init( my_module_init );
module_exit( my_module_cleanup );

2. vi Makefile

obj-m += simple-lkm.o

3. build

make -C /usr/src/linux-`uname -r` SUBDIRS=$PWD modules

4. insert module
insmod simple-lkm.ko

5. check module
lsmod

6. check print message
dmesg | tail -5

7. remove module
rmmod simple-lkm

Connect VMware client from Linux host

2009-02-03T18:07:00.000-08:00

I setup a Linux virtual machine on a Linux host, using NAT network.
When connect from virtual machine to host, it is successful. But there is a problem from host connect to virtual machine, the error message of ping is:
ping sendmsg operation not permitted

There need set an port mapping of NAT.
In host Linux, edit configure file /etc/vmware/vmnet8/nat/nat.conf
add one line "2222 = 192.168.27.128:22" under [incomingtcp]192.168.27.128 is IP of virtual machine. Then reboot ssh -l root -p 2222 localhost will telnet to virtual machine from host Linux.
Reference
1. http://www.vmware.com/support/ws55/doc/ws_net_nat_advanced.html