Tag: MySQL’

MovableType携帯版【Mobile】

 - by naoki

最近やっとPHPとMySQL(データベース)とのやりとりが分かってきたから、いろんなもんを自分で作ってみようかと思ってる。
手始めに、MovableTypeの携帯版を自作してみようかと。
といっても、MTをカスタマイズしてなんとかかんとかするわけじゃなくて、単純にMTのエントリーとタイトルをデータベースから引っ張ってきたあげるスクリプトを書けばいいかなと。
データベース接続はmt-config.php(名前合ってるかわからん)の情報をそのままIncludeすればいいわけだし。
ってことで、週末にでも着手してみようかしら。

【CentOS5】今日のyum update@20100505

 - by naoki
[root@俺の鯖~]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: ftp.yz.yamagata-u.ac.jp
* base: ftp.yz.yamagata-u.ac.jp
* extras: ftp.yz.yamagata-u.ac.jp
* rpmforge: apt.sw.be
* updates: ftp.yz.yamagata-u.ac.jp
Excluding Packages in global exclude list
Finished
Setting up Update Process
Resolving Dependencies
–> Running transaction check
—> Package perl-DBD-mysql.i386 0:4.014-1.el5.rf set to be updated
–> Finished Dependency Resolution
Dependencies Resolved
======================================
Package Arch Version Repository Size
======================================
Updating:
perl-DBD-mysql i386 4.014-1.el5.rf rpmforge 225 k
Transaction Summary
======================================
Install 0 Package(s)
Update 1 Package(s)
Remove 0 Package(s)
Total download size: 225 k
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : perl-DBD-mysql 1/2
Cleanup : perl-DBD-mysql 2/2
Updated:
perl-DBD-mysql.i386 0:4.014-1.el5.rf
Complete!

【CentOS5】今日のyum update@20100118

 - by naoki
[root@俺の鯖~]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: ftp.riken.jp
* base: ftp.riken.jp
* extras: ftp.riken.jp
* rpmforge: apt.sw.be
* updates: ftp.riken.jp
Excluding Packages in global exclude list
Finished
Setting up Update Process
Resolving Dependencies
–> Running transaction check
—> Package acpid.i386 0:1.0.4-9.el5_4.2 set to be updated
—> Package cpp.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package dbus.i386 0:1.1.2-12.el5_4.1 set to be updated
—> Package dbus-devel.i386 0:1.1.2-12.el5_4.1 set to be updated
—> Package dbus-libs.i386 0:1.1.2-12.el5_4.1 set to be updated
—> Package dhclient.i386 12:3.0.5-21.el5_4.1 set to be updated
—> Package gcc.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package gcc-c++.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package gcc-gfortran.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package gcc-gnat.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package gcc-java.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package gcc-objc.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package gcc-objc++.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package kernel.i686 0:2.6.18-164.10.1.el5 set to be installed
—> Package kernel-devel.i686 0:2.6.18-164.10.1.el5 set to be installed
—> Package kernel-headers.i386 0:2.6.18-164.10.1.el5 set to be updated
—> Package krb5-devel.i386 0:1.6.1-36.el5_4.1 set to be updated
—> Package krb5-libs.i386 0:1.6.1-36.el5_4.1 set to be updated
—> Package krb5-workstation.i386 0:1.6.1-36.el5_4.1 set to be updated
—> Package ksh.i386 0:20080202-14.el5_4.2 set to be updated
—> Package libgcc.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libgcj.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libgcj-devel.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libgcj-src.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libgfortran.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libgnat.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libobjc.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libstdc++.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package libstdc++-devel.i386 0:4.1.2-46.el5_4.2 set to be updated
—> Package mysql.i386 0:5.0.77-4.el5_4.1 set to be updated
—> Package mysql-devel.i386 0:5.0.77-4.el5_4.1 set to be updated
—> Package mysql-server.i386 0:5.0.77-4.el5_4.1 set to be updated
—> Package php-cli.i386 0:5.1.6-24.el5_4.5 set to be updated
—> Package php-common.i386 0:5.1.6-24.el5_4.5 set to be updated
—> Package php-mbstring.i386 0:5.1.6-24.el5_4.5 set to be updated
—> Package php-mysql.i386 0:5.1.6-24.el5_4.5 set to be updated
—> Package php-pdo.i386 0:5.1.6-24.el5_4.5 set to be updated
—> Package ruby.i386 0:1.8.5-5.el5_4.8 set to be updated
—> Package ruby-devel.i386 0:1.8.5-5.el5_4.8 set to be updated
—> Package ruby-libs.i386 0:1.8.5-5.el5_4.8 set to be updated
—> Package selinux-policy.noarch 0:2.4.6-255.el5_4.3 set to be updated
—> Package selinux-policy-targeted.noarch 0:2.4.6-255.el5_4.3 set to be updated
—> Package tcsh.i386 0:6.14-14.el5_4.3 set to be updated
—> Package tzdata.noarch 0:2009u-1.el5 set to be updated
—> Package vixie-cron.i386 4:4.1-77.el5_4.1 set to be updated
—> Package xorg-x11-server-Xvfb.i386 0:1.1.1-48.67.el5_4.1 set to be updated
–> Finished Dependency Resolution
–> Running transaction check
—> Package kernel.i686 0:2.6.18-164.2.1.el5 set to be erased
—> Package kernel-devel.i686 0:2.6.18-164.2.1.el5 set to be erased
–> Finished Dependency Resolution
Dependencies Resolved
======================================
Package Arch Version Repository Size
======================================
Installing:
kernel i686 2.6.18-164.10.1.el5 updates 16 M
kernel-devel i686 2.6.18-164.10.1.el5 updates 5.2 M
Updating:
acpid i386 1.0.4-9.el5_4.2 updates 24 k
cpp i386 4.1.2-46.el5_4.2 updates 2.6 M
dbus i386 1.1.2-12.el5_4.1 updates 235 k
dbus-devel i386 1.1.2-12.el5_4.1 updates 1.4 M
dbus-libs i386 1.1.2-12.el5_4.1 updates 123 k
dhclient i386 12:3.0.5-21.el5_4.1 updates 276 k
gcc i386 4.1.2-46.el5_4.2 updates 5.2 M
gcc-c++ i386 4.1.2-46.el5_4.2 updates 3.4 M
gcc-gfortran i386 4.1.2-46.el5_4.2 updates 3.1 M
gcc-gnat i386 4.1.2-46.el5_4.2 updates 11 M
gcc-java i386 4.1.2-46.el5_4.2 updates 2.9 M
gcc-objc i386 4.1.2-46.el5_4.2 updates 2.5 M
gcc-objc++ i386 4.1.2-46.el5_4.2 updates 2.7 M
kernel-headers i386 2.6.18-164.10.1.el5 updates 1.0 M
krb5-devel i386 1.6.1-36.el5_4.1 updates 1.8 M
krb5-libs i386 1.6.1-36.el5_4.1 updates 661 k
krb5-workstation i386 1.6.1-36.el5_4.1 updates 881 k
ksh i386 20080202-14.el5_4.2 updates 1.1 M
libgcc i386 4.1.2-46.el5_4.2 updates 95 k
libgcj i386 4.1.2-46.el5_4.2 updates 16 M
libgcj-devel i386 4.1.2-46.el5_4.2 updates 1.4 M
libgcj-src i386 4.1.2-46.el5_4.2 updates 11 M
libgfortran i386 4.1.2-46.el5_4.2 updates 231 k
libgnat i386 4.1.2-46.el5_4.2 updates 980 k
libobjc i386 4.1.2-46.el5_4.2 updates 103 k
libstdc++ i386 4.1.2-46.el5_4.2 updates 361 k
libstdc++-devel i386 4.1.2-46.el5_4.2 updates 2.8 M
mysql i386 5.0.77-4.el5_4.1 updates 4.8 M
mysql-devel i386 5.0.77-4.el5_4.1 updates 2.4 M
mysql-server i386 5.0.77-4.el5_4.1 updates 9.8 M
php-cli i386 5.1.6-24.el5_4.5 updates 2.1 M
php-common i386 5.1.6-24.el5_4.5 updates 152 k
php-mbstring i386 5.1.6-24.el5_4.5 updates 994 k
php-mysql i386 5.1.6-24.el5_4.5 updates 85 k
php-pdo i386 5.1.6-24.el5_4.5 updates 64 k
ruby i386 1.8.5-5.el5_4.8 updates 274 k
ruby-devel i386 1.8.5-5.el5_4.8 updates 556 k
ruby-libs i386 1.8.5-5.el5_4.8 updates 1.6 M
selinux-policy noarch 2.4.6-255.el5_4.3 updates 393 k
selinux-policy-targeted noarch 2.4.6-255.el5_4.3 updates 1.1 M
tcsh i386 6.14-14.el5_4.3 updates 464 k
tzdata noarch 2009u-1.el5 updates 786 k
vixie-cron i386 4:4.1-77.el5_4.1 updates 79 k
xorg-x11-server-Xvfb i386 1.1.1-48.67.el5_4.1 updates 1.6 M
Removing:
kernel i686 2.6.18-164.2.1.el5 installed 41 M
kernel-devel i686 2.6.18-164.2.1.el5 installed 16 M
Transaction Summary
======================================
Install 2 Package(s)
Update 44 Package(s)
Remove 2 Package(s)
Total download size: 123 M
Downloading Packages:
——————————————————————————–
Total 4.0 MB/s | 123 MB 00:30
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : libgcc 1/93
Updating : libstdc++ 2/93
Updating : mysql 3/93
Updating : krb5-libs 4/93
Updating : libgcj 5/93
Updating : ruby-libs 6/93
Updating : php-common 7/93
Updating : libobjc 8/93
Updating : libgfortran 9/93
Updating : php-pdo 10/93
Updating : libgnat 11/93
Updating : ruby 12/93
Updating : cpp 13/93
Updating : gcc 14/93
Updating : gcc-objc 15/93
Updating : gcc-gnat 16/93
Updating : gcc-gfortran 17/93
Updating : php-mysql 18/93
Updating : php-cli 19/93
Updating : php-mbstring 20/93
Updating : krb5-workstation 21/93
Updating : krb5-devel 22/93
Updating : mysql-server 23/93
Updating : vixie-cron 24/93
Updating : dhclient 25/93
Updating : acpid 26/93
Updating : ksh 27/93
Updating : tcsh 28/93
Updating : xorg-x11-server-Xvfb 29/93
Updating : libgcj-devel 30/93
Updating : libstdc++-devel 31/93
Updating : selinux-policy 32/93
Updating : selinux-policy-targeted 33/93
Updating : ruby-devel 34/93
Updating : libgcj-src 35/93
Updating : mysql-devel 36/93
Updating : kernel-headers 37/93
Installing : kernel 38/93
Installing : kernel-devel 39/93
Updating : tzdata 40/93
Updating : gcc-c++ 41/93
Updating : gcc-objc++ 42/93
Updating : gcc-java 43/93
Updating : dbus-libs 44/93
Updating : dbus 45/93
Updating : dbus-devel 46/93
Cleanup : gcc-c++ 47/93
Cleanup : gcc-objc 48/93
Cleanup : selinux-policy-targeted 49/93
Cleanup : gcc-gnat 50/93
Cleanup : xorg-x11-server-Xvfb 51/93
Cleanup : php-pdo 52/93
Cleanup : tcsh 53/93
Cleanup : mysql 54/93
Cleanup : php-common 55/93
Cleanup : ruby-libs 56/93
Cleanup : tzdata 57/93
Cleanup : krb5-libs 58/93
Cleanup : ksh 59/93
Cleanup : ruby 60/93
Cleanup : libgcj-devel 61/93
Cleanup : kernel-devel 62/93
Cleanup : krb5-workstation 63/93
Cleanup : dbus-libs 64/93
Cleanup : libgnat 65/93
Cleanup : php-mysql 66/93
Cleanup : dbus-devel 67/93
Cleanup : kernel-headers 68/93
Cleanup : php-cli 69/93
Cleanup : libgcc 70/93
Cleanup : php-mbstring 71/93
Cleanup : mysql-devel 72/93
Cleanup : gcc 73/93
Cleanup : acpid 74/93
Cleanup : acpid 75/93
Cleanup : dbus 76/93
Cleanup : libgcj-src 77/93
Cleanup : mysql-server 78/93
Cleanup : libstdc++ 79/93
Cleanup : gcc-objc++ 80/93
Cleanup : ruby-devel 81/93
Cleanup : gcc-gfortran 82/93
Cleanup : libobjc 83/93
Cleanup : libgfortran 84/93
Cleanup : dhclient 85/93
Cleanup : krb5-devel 86/93
Cleanup : vixie-cron 87/93
Cleanup : libgcj 88/93
Cleanup : libstdc++-devel 89/93
Cleanup : selinux-policy 90/93
Cleanup : gcc-java 91/93
Cleanup : kernel 92/93
Cleanup : cpp 93/93
Removed:
kernel.i686 0:2.6.18-164.2.1.el5 kernel-devel.i686 0:2.6.18-164.2.1.el5
Installed:
kernel.i686 0:2.6.18-164.10.1.el5 kernel-devel.i686 0:2.6.18-164.10.1.el5
Updated:
acpid.i386 0:1.0.4-9.el5_4.2
cpp.i386 0:4.1.2-46.el5_4.2
dbus.i386 0:1.1.2-12.el5_4.1
dbus-devel.i386 0:1.1.2-12.el5_4.1
dbus-libs.i386 0:1.1.2-12.el5_4.1
dhclient.i386 12:3.0.5-21.el5_4.1
gcc.i386 0:4.1.2-46.el5_4.2
gcc-c++.i386 0:4.1.2-46.el5_4.2
gcc-gfortran.i386 0:4.1.2-46.el5_4.2
gcc-gnat.i386 0:4.1.2-46.el5_4.2
gcc-java.i386 0:4.1.2-46.el5_4.2
gcc-objc.i386 0:4.1.2-46.el5_4.2
gcc-objc++.i386 0:4.1.2-46.el5_4.2
kernel-headers.i386 0:2.6.18-164.10.1.el5
krb5-devel.i386 0:1.6.1-36.el5_4.1
krb5-libs.i386 0:1.6.1-36.el5_4.1
krb5-workstation.i386 0:1.6.1-36.el5_4.1
ksh.i386 0:20080202-14.el5_4.2
libgcc.i386 0:4.1.2-46.el5_4.2
libgcj.i386 0:4.1.2-46.el5_4.2
libgcj-devel.i386 0:4.1.2-46.el5_4.2
libgcj-src.i386 0:4.1.2-46.el5_4.2
libgfortran.i386 0:4.1.2-46.el5_4.2
libgnat.i386 0:4.1.2-46.el5_4.2
libobjc.i386 0:4.1.2-46.el5_4.2
libstdc++.i386 0:4.1.2-46.el5_4.2
libstdc++-devel.i386 0:4.1.2-46.el5_4.2
mysql.i386 0:5.0.77-4.el5_4.1
mysql-devel.i386 0:5.0.77-4.el5_4.1
mysql-server.i386 0:5.0.77-4.el5_4.1
php-cli.i386 0:5.1.6-24.el5_4.5
php-common.i386 0:5.1.6-24.el5_4.5
php-mbstring.i386 0:5.1.6-24.el5_4.5
php-mysql.i386 0:5.1.6-24.el5_4.5
php-pdo.i386 0:5.1.6-24.el5_4.5
ruby.i386 0:1.8.5-5.el5_4.8
ruby-devel.i386 0:1.8.5-5.el5_4.8
ruby-libs.i386 0:1.8.5-5.el5_4.8
selinux-policy.noarch 0:2.4.6-255.el5_4.3
selinux-policy-targeted.noarch 0:2.4.6-255.el5_4.3
tcsh.i386 0:6.14-14.el5_4.3
tzdata.noarch 0:2009u-1.el5
vixie-cron.i386 4:4.1-77.el5_4.1
xorg-x11-server-Xvfb.i386 0:1.1.1-48.67.el5_4.1
Complete!

centos, centos5,

【CentOS5】今日のyum update@20090921

 - by naoki
[root@俺の鯖~]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* rpmforge: ftp-stud.fht-esslingen.de
* base: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
* addons: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
Excluding Packages in global exclude list
Finished
Setting up Update Process
Resolving Dependencies
–> Running transaction check
—> Package openssh-clients.i386 0:4.3p2-36.el5 set to be updated
—> Package nspr-devel.i386 0:4.7.5-1.el5_4 set to be updated
—> Package mysql.i386 0:5.0.77-3.el5 set to be updated
—> Package kernel-devel.i686 0:2.6.18-164.el5 set to be installed
—> Package mysql-devel.i386 0:5.0.77-3.el5 set to be updated
—> Package xmlsec1-devel.i386 0:1.2.9-8.1.1 set to be updated
—> Package openssl.i686 0:0.9.8e-12.el5 set to be updated
—> Package openssh-server.i386 0:4.3p2-36.el5 set to be updated
—> Package nspr.i386 0:4.7.5-1.el5_4 set to be updated
—> Package perl-HTML-Parser.i386 0:3.62-1.el5.rf set to be updated
—> Package openssl-devel.i386 0:0.9.8e-12.el5 set to be updated
—> Package nfs-utils.i386 1:1.0.9-42.el5 set to be updated
—> Package mysql-server.i386 0:5.0.77-3.el5 set to be updated
—> Package openssh.i386 0:4.3p2-36.el5 set to be updated
—> Package kernel.i686 0:2.6.18-164.el5 set to be installed
—> Package fetchmail.i386 0:6.3.6-1.1.el5_3.1 set to be updated
—> Package kernel-headers.i386 0:2.6.18-164.el5 set to be updated
—> Package xmlsec1.i386 0:1.2.9-8.1.1 set to be updated
–> Finished Dependency Resolution
–> Running transaction check
—> Package kernel.i686 0:2.6.18-128.1.14.el5 set to be erased
—> Package kernel-devel.i686 0:2.6.18-128.1.14.el5 set to be erased
–> Finished Dependency Resolution
Dependencies Resolved
======================================
Package Arch Version Repository Size
======================================
Installing:
kernel i686 2.6.18-164.el5 updates 16 M
kernel-devel i686 2.6.18-164.el5 updates 5.2 M
Updating:
fetchmail i386 6.3.6-1.1.el5_3.1 updates 527 k
kernel-headers i386 2.6.18-164.el5 updates 993 k
mysql i386 5.0.77-3.el5 updates 4.8 M
mysql-devel i386 5.0.77-3.el5 updates 2.4 M
mysql-server i386 5.0.77-3.el5 updates 9.8 M
nfs-utils i386 1:1.0.9-42.el5 updates 381 k
nspr i386 4.7.5-1.el5_4 updates 119 k
nspr-devel i386 4.7.5-1.el5_4 updates 112 k
openssh i386 4.3p2-36.el5 updates 286 k
openssh-clients i386 4.3p2-36.el5 updates 447 k
openssh-server i386 4.3p2-36.el5 updates 268 k
openssl i686 0.9.8e-12.el5 updates 1.4 M
openssl-devel i386 0.9.8e-12.el5 updates 1.9 M
perl-HTML-Parser i386 3.62-1.el5.rf rpmforge 148 k
xmlsec1 i386 1.2.9-8.1.1 updates 175 k
xmlsec1-devel i386 1.2.9-8.1.1 updates 658 k
Removing:
kernel i686 2.6.18-128.1.14.el5 installed 40 M
kernel-devel i686 2.6.18-128.1.14.el5 installed 15 M
Transaction Summary
======================================
Install 2 Package(s)
Update 16 Package(s)
Remove 2 Package(s)
Total download size: 45 M
Downloading Packages:
——————————————————————————–
Total 3.4 MB/s | 45 MB 00:13
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : kernel-devel [ 1/36]
Installing : kernel [ 2/36]
Updating : kernel-headers [ 3/36]
Updating : openssl [ 4/36]
Updating : nspr [ 5/36]
Updating : mysql [ 6/36]
Updating : xmlsec1 [ 7/36]
Updating : openssh [ 8/36]
Updating : perl-HTML-Parser [ 9/36]
Updating : openssh-clients [10/36]
Updating : openssh-server [11/36]
warning: /etc/ssh/sshd_config created as /etc/ssh/sshd_config.rpmnew
Updating : mysql-server [12/36]
Updating : fetchmail [13/36]
Updating : nfs-utils [14/36]
Updating : openssl-devel [15/36]
Updating : nspr-devel [16/36]
Updating : xmlsec1-devel [17/36]
Updating : mysql-devel [18/36]
Cleanup : openssh-clients [19/36]
Cleanup : kernel-headers [20/36]
Cleanup : openssh [21/36]
Cleanup : kernel-devel [22/36]
Cleanup : perl-HTML-Parser [23/36]
Cleanup : nfs-utils [24/36]
Cleanup : openssl-devel [25/36]
Cleanup : xmlsec1 [26/36]
Cleanup : nspr-devel [27/36]
Cleanup : mysql-server [28/36]
Cleanup : openssh-server [29/36]
Cleanup : xmlsec1-devel [30/36]
Cleanup : mysql-devel [31/36]
Cleanup : mysql [32/36]
Cleanup : kernel [33/36]
Cleanup : fetchmail [34/36]
Cleanup : nspr [35/36]
Cleanup : openssl [36/36]
Removed: kernel.i686 0:2.6.18-128.1.14.el5 kernel-devel.i686 0:2.6.18-128.1.14.el5
Installed: kernel.i686 0:2.6.18-164.el5 kernel-devel.i686 0:2.6.18-164.el5
Updated: fetchmail.i386 0:6.3.6-1.1.el5_3.1 kernel-headers.i386 0:2.6.18-164.el5 mysql.i386 0:5.0.77-3.el5 mysql-devel.i386 0:5.0.77-3.el5 mysql-server.i386 0:5.0.77-3.el5 nfs-utils.i386 1:1.0.9-42.el5 nspr.i386 0:4.7.5-1.el5_4 nspr-devel.i386 0:4.7.5-1.el5_4 openssh.i386 0:4.3p2-36.el5 openssh-clients.i386 0:4.3p2-36.el5 openssh-server.i386 0:4.3p2-36.el5 openssl.i686 0:0.9.8e-12.el5 openssl-devel.i386 0:0.9.8e-12.el5 perl-HTML-Parser.i386 0:3.62-1.el5.rf xmlsec1.i386 0:1.2.9-8.1.1 xmlsec1-devel.i386 0:1.2.9-8.1.1
Complete!