メインメニュー
ログイン
ユーザ名:

パスワード:


パスワード紛失

オンライン状況
7 人のユーザが現在オンラインです。 (3 人のユーザが i-Diary を参照しています。)

登録ユーザ: 0
ゲスト: 7

もっと...
検索
情報サイト

特定のサイト内で、特定のファイルのみをキーワード検索できます。
Key: File Type: Site:

2008 年 8 月
     1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31       


Search
::: 最新の5件を日付順に表示しています :::
Inode 33226757 was part of the orphaned
2008-08-22
ハードディスクの障害が発生し、Inodeが一部壊れてしまいました。

早速、fsckでファイルシステムのチェックと修復を行い、なんとかブートできる状態になりました。
SSHでもログインでき、WEBのほうも問題なく表示できているようでした。

管理者画面に行こうとすると、なんと再度ログインを促してきます。
なぜ?と思い、デバッグモードでuser.phpにアクセスしても、なにも手がかりは表示されません。

DBをチェックしてみると、なんとこんなエラーがありました。

An error occured while executing the database request for:
MySQL
5.0.51a
MySQL-AB JDBC Driver
mysql-connector-java-5.0.5 ( $Date: 2007-03-01 00:01:06 +0100 (Thu, 01 Mar 2007) $, $Revision: 6329 $ )

The command that caused the error was:
select * from `xoops_session`

Error Details:

早速、テーブルの修復をします。

DROP TABLE IF EXISTS `xoops_session`;

CREATE TABLE `xoops_session` (
`sess_id` varchar(32) NOT NULL default '',
`sess_updated` int(10) unsigned NOT NULL default '0',
`sess_ip` varchar(15) NOT NULL default '',
`sess_data` text NOT NULL,
PRIMARY KEY (`sess_id`),
KEY `updated` (`sess_updated`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

再度、管理者画面にログインすると問題なくログインできました。

音のない記憶
2008-08-16
"ろうあの天才写真家井上孝治の生涯"
1919年、福岡生まれ。一度彼の作品を見るとどんな生き方をしたのだろうと興味が沸いてくる写真家の一人です。93年アルル国際写真フェスティバルの直前で亡くなられたのは残念です。



Bugzilla 2.22.1から3.0.4へのアップグレード
2008-08-01
手順を以下に記します。
1.http://www.bugzilla.org/ からソフトをダウンロードし、解凍します。
2.次のコマンドにより、設定します。

# ./checksetup.pl

するとモジュールが足りないなどとエラーが吐かれるので、モジュールをインストールします。
インストールしてもまだ見つからないとエラーが出るので調べると、Perl 5.10では動作しないようです。

Perl 5.10で動かす解決策:
# perl -MCPAN -e 'install "Bundle::Bugzilla"'

3.bugzilla/localconfigのDBの値を適宜変更します。

4.再度以下のコマンドを実行します。
# ./checksetup.pl

出力結果(例):
# ./checksetup.pl

* This is Bugzilla 3.0.4 on perl 5.10.0
* Running on Linux 2.6.25.10-86.fc9.x86_64 #1 SMP Mon Jul 7 20:23:46 EDT 2008

Checking perl modules...
Checking for CGI.pm (v3.33) ok: found v3.39
Checking for TimeDate (v2.21) ok: found v2.22
Checking for DBI (v1.41) ok: found v1.607
Checking for PathTools (v0.84) ok: found v3.2701
Checking for Template-Toolkit (v2.12) ok: found v2.19
Checking for Email-Send (v2.00) ok: found v2.192
Checking for Email-MIME-Modifier (any) ok: found v1.442

Checking available perl DBD modules...
Checking for DBD-Pg (v1.45) not found
Checking for DBD-mysql (v2.9003) ok: found v4.005

The following Perl modules are optional:
Checking for GD (v1.20) not found
Checking for Template-GD (any) not found
Checking for Chart (v1.0) not found
Checking for GDGraph (any) not found
Checking for GDTextUtil (any) not found
Checking for XML-Twig (any) not found
Checking for MIME-tools (v5.406) ok: found v5.427
Checking for libwww-perl (any) ok: found v2.036
Checking for PatchReader (v0.9.4) not found
Checking for PerlMagick (any) not found
Checking for perl-ldap (any) not found
Checking for SOAP-Lite (any) not found
Checking for HTML-Parser (v3.40) ok: found v3.56
Checking for HTML-Scrubber (any) not found
Checking for Email-MIME-Attachment-Stripper (any) not found
Checking for Email-Reply (any) not found
Checking for mod_perl (v1.999022) ok: found v2.000003

* NOTE: You must run any commands listed below as root.

**********************************************************************
* OPTIONAL MODULES *
**********************************************************************
* Certain Perl modules are not required by Bugzilla, but by *
* installing the latest version you gain access to additional *
* features. *
* *
* The optional modules you do not have installed are listed below, *
* with the name of the feature they enable. If you want to install *
* one of these modules, just run the appropriate command in the *
* "COMMANDS TO INSTALL" section. *
**********************************************************************

***********************************************************************
* MODULE NAME * ENABLES FEATURE(S) *
***********************************************************************
* GDGraph * Graphical Reports *
* GDTextUtil * Graphical Reports *
* Template-GD * Graphical Reports *
* GD * Graphical Reports, New Charts, Old Charts *
* Email-MIME-Attachment-Stripper * Inbound Email *
* Email-Reply * Inbound Email *
* perl-ldap * LDAP Authentication *
* HTML-Scrubber * More HTML in Product/Group Descriptions *
* XML-Twig * Move Bugs Between Installations *
* Chart * New Charts, Old Charts *
* PerlMagick * Optionally Convert BMP Attachments to PNGs *
* PatchReader * Patch Viewer *
* SOAP-Lite * XML-RPC Interface *
***********************************************************************
COMMANDS TO INSTALL:

GDGraph: /usr/bin/perl -MCPAN -e 'install "GD::Graph"'
GDTextUtil: /usr/bin/perl -MCPAN -e 'install "GD::Text"'
Template-GD: /usr/bin/perl -MCPAN -e 'install "Template::Plugin::GD::Image"'
GD: /usr/bin/perl -MCPAN -e 'install "GD"'
Email-MIME-Attachment-Stripper: /usr/bin/perl -MCPAN -e 'install "Email::MIME::Attachment::Stripper"'
Email-Reply: /usr/bin/perl -MCPAN -e 'install "Email::Reply"'
perl-ldap: /usr/bin/perl -MCPAN -e 'install "Net::LDAP"'
HTML-Scrubber: /usr/bin/perl -MCPAN -e 'install "HTML::Scrubber"'
XML-Twig: /usr/bin/perl -MCPAN -e 'install "XML::Twig"'
Chart: /usr/bin/perl -MCPAN -e 'install "Chart::Base"'
PerlMagick: /usr/bin/perl -MCPAN -e 'install "Image::Magick"'
PatchReader: /usr/bin/perl -MCPAN -e 'install "PatchReader"'
SOAP-Lite: /usr/bin/perl -MCPAN -e 'install "SOAP::Lite"'
Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

http://cyberelk.net/tim/patchutils/

Checking for DBD-mysql (v2.9003) ok: found v4.005
Checking for MySQL (v4.1.2) ok: found v5.0.51a

Adding new table component_cc ...
Adding new table namedqueries_link_in_footer ...
Adding new table namedquery_group_map ...
Creating ./data directory...
Creating ./data/attachments directory...
Creating ./data/duplicates directory...
Creating ./data/mimedump-tmp directory...
Creating ./data/mining directory...
Creating ./data/webdot directory...
Creating ./extensions directory...
Creating graphs directory...
Creating skins/contrib directory...
Creating skins/custom directory...
Creating ./data/mail...
Creating ./Bugzilla/.htaccess...
Creating ./data/.htaccess...
Creating ./data/attachments/.htaccess...
Creating ./data/webdot/.htaccess...
Creating ./template/.htaccess...
Creating .htaccess...
Precompiling templates...
Fixing file permissions...
Adding new column 'type' to the 'fielddefs' table...
Adding new column 'custom' to the 'fielddefs' table...
Adding new column 'enter_bug' to the 'fielddefs' table...
Renaming column 'fielddefs.fieldid' to 'fielddefs.id'...
Updating column creator in table series ...
Old: mediumint NOT NULL
New: mediumint
Adding new column 'comment_id' to the 'longdescs' table...
Updating column id in table flags ...
Old: mediumint NOT NULL PRIMARY KEY
New: mediumint auto_increment NOT NULL PRIMARY KEY
Deleting the 'is_active' column from the 'flags' table...
Updating column short_desc in table bugs ...
Old: mediumtext NOT NULL
New: varchar(255) NOT NULL
Adding new column 'id' to the 'namedqueries' table...
Deleting the 'linkinfooter' column from the 'namedqueries' table...
Adding new column 'sortkey' to the 'classifications' table...
Adding new column 'disable_mail' to the 'profiles' table...
Updating column milestoneurl in table products ...
Old: tinytext NOT NULL
New: tinytext DEFAULT '' NOT NULL
Updating column disallownew in table products ...
Old: tinyint NOT NULL
New: tinyint DEFAULT 0 NOT NULL
Updating column votesperuser in table products ...
Old: smallint NOT NULL
New: smallint DEFAULT 0 NOT NULL
Updating column votestoconfirm in table products ...
Old: smallint NOT NULL
New: smallint DEFAULT 0 NOT NULL
Deleting the 'refreshed_when' column from the 'profiles' table...
Deleting the 'last_changed' column from the 'groups' table...
Updating column id in table flagtypes ...
Old: smallint NOT NULL PRIMARY KEY
New: smallint auto_increment NOT NULL PRIMARY KEY
Updating column id in table keyworddefs ...
Old: smallint NOT NULL PRIMARY KEY
New: smallint auto_increment NOT NULL PRIMARY KEY
Updating column userid in table tokens ...
Old: mediumint NOT NULL
New: mediumint
Removing index 'bugs_short_desc_idx' from the bugs table...
Updating column disabledtext in table profiles ...
Old: mediumtext NOT NULL
New: mediumtext DEFAULT '' NOT NULL
Updating column realname in table profiles ...
Old: varchar(255)
New: varchar(255) DEFAULT '' NOT NULL
Removing index 'longdescs_who_idx' from the longdescs table...
Adding new index 'longdescs_who_idx' to the longdescs table ...
Adding new column 'subclass' to the 'setting' table...
Updating column thetext in table longdescs ...
Old: mediumtext
New: mediumtext NOT NULL
Adding new column 'editcomponents' to the 'group_control_map' table...
Adding new column 'editbugs' to the 'group_control_map' table...
Adding new column 'canconfirm' to the 'group_control_map' table...
Adding new column 'type' to the 'longdescs' table...
Adding new column 'extra_data' to the 'longdescs' table...
Adding new column 'id' to the 'versions' table...
Adding new column 'id' to the 'milestones' table...
Adding a new user setting called 'skin'
Adding a new user setting called 'lang'
Adding a new user setting called 'zoom_textareas'
Adding a new user setting called 'state_addselfcc'

Now that you have installed Bugzilla, you should visit the
'Parameters' page (linked in the footer of the Administrator
account) to ensure it is set up as you wish - this includes
setting the 'urlbase' option to the correct URL.


以上で、Bugzillaにアクセスできます。問題なく過去のバグも表示できます。



awstatsが更新されない問題
2008-07-31
fc9にアップグレードしてから、awstatsが更新されていないことがわかりました。原因を調べていると、以下のエラーがありました。

Error: Plugin load for plugin 'geoipfree' failed with return code: Error: Can't locate Geo/IPfree.pm in @INC (@INC contains: /usr/lib64/perl5/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/5.10.0 /usr/local/lib64/perl5/site_perl/5.10.0/x86_64-linux-thread-multi /usr/local/lib/perl5/site_perl/5.10.0 /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl . /usr/share/awstats/lib /usr/share/awstats/plugins /usr/share/awstats/wwwroot/cgi-bin/plugins) at (eval 1) line 1.

早速、モジュールを再度インストールしてみます。
#/usr/bin/perl -MCPAN -e 'install "Geo::IPfree"'

CPAN: Storable loaded ok (v2.18)
Going to read /root/.cpan/Metadata
Database was generated on Thu, 31 Jul 2008 03:02:52 GMT
Running install for module 'Geo::IPfree'
CPAN: Data::Dumper loaded ok (v2.121_14)
'YAML' not installed, falling back to Data::Dumper and Storable to read prefs '/root/.cpan/prefs'
Running make for G/GM/GMPASSOS/Geo-IPfree-0.2.tar.gz
CPAN: LWP::UserAgent loaded ok (v2.036)
CPAN: Time::HiRes loaded ok (v1.9711)

I would like to connect to one of the following sites to get 'authors/id/G/GM/GMPASSOS/Geo-IPfree-0.2.tar.gz':

http://www.perl.org/CPAN/
ftp://ftp.perl.org/pub/CPAN/

Is it OK to try to connect to the Internet? [yes] yes
Fetching with LWP:
http://www.perl.org/CPAN/authors/id/G/GM/GMPASSOS/Geo-IPfree-0.2.tar.gz

CPAN: checksum security checks disabled because Digest::SHA not installed.
Please consider installing the Digest::SHA module.

Geo-IPfree-0.2/
Geo-IPfree-0.2/benchmark/
Geo-IPfree-0.2/benchmark/benchmark.pl
Geo-IPfree-0.2/benchmark/benchmark2.pl
Geo-IPfree-0.2/Changes
Geo-IPfree-0.2/lib/
Geo-IPfree-0.2/lib/Geo/
Geo-IPfree-0.2/lib/Geo/ipct2txt.pl
Geo-IPfree-0.2/lib/Geo/IPfree.pm
Geo-IPfree-0.2/lib/Geo/ipscountry.dat
Geo-IPfree-0.2/lib/Geo/txt2ipct.pl
Geo-IPfree-0.2/Makefile.PL
Geo-IPfree-0.2/MANIFEST
Geo-IPfree-0.2/README
Geo-IPfree-0.2/test.pl
CPAN: File::Temp loaded ok (v0.18)
Warning (usually harmless): 'YAML' not installed, will not store persistent state

CPAN.pm: Going to build G/GM/GMPASSOS/Geo-IPfree-0.2.tar.gz

Checking if your kit is complete...
Looks good
Writing Makefile for Geo::IPfree
cp lib/Geo/IPfree.pm blib/lib/Geo/IPfree.pm
cp lib/Geo/ipscountry.dat blib/lib/Geo/ipscountry.dat
cp lib/Geo/ipct2txt.pl blib/lib/Geo/ipct2txt.pl
cp lib/Geo/txt2ipct.pl blib/lib/Geo/txt2ipct.pl
Manifying blib/man3/Geo::IPfree.3pm
GMPASSOS/Geo-IPfree-0.2.tar.gz
/usr/bin/make -- OK
Warning (usually harmless): 'YAML' not installed, will not store persistent state
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
1..5
# Running under perl version 5.010000 for linux
# Current time local: Thu Jul 31 14:15:42 2008
# Current time GMT: Thu Jul 31 05:15:42 2008
# Using Test.pm version 1.25
ok 1
ok 2
ok 3
ok 4
ok 5
GMPASSOS/Geo-IPfree-0.2.tar.gz
/usr/bin/make test -- OK
Warning (usually harmless): 'YAML' not installed, will not store persistent state
Running make install
Prepending /root/.cpan/build/Geo-IPfree-0.2-KQnTJt/blib/arch /root/.cpan/build/Geo-IPfree-0.2-KQnTJt/blib/lib to PERL5 LIB for 'install'
Installing /usr/local/lib/perl5/site_perl/5.10.0/Geo/IPfree.pm
Installing /usr/local/lib/perl5/site_perl/5.10.0/Geo/ipct2txt.pl
Installing /usr/local/lib/perl5/site_perl/5.10.0/Geo/ipscountry.dat
Installing /usr/local/lib/perl5/site_perl/5.10.0/Geo/txt2ipct.pl
Installing /usr/local/share/man/man3/Geo::IPfree.3pm
Writing /usr/local/lib64/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/Geo/IPfree/.packlist
Appending installation info to /usr/lib64/perl5/5.10.0/x86_64-linux-thread-multi/perllocal.pod
GMPASSOS/Geo-IPfree-0.2.tar.gz
/usr/bin/make install -- OK
Warning (usually harmless): 'YAML' not installed, will not store persistent state

その後、手動でawstatsをアップデートし、確認します。

# /usr/share/awstats/tools/awstats_updateall.pl now
Running '"/usr/share/awstats/wwwroot/cgi-bin/awstats.pl" -update -config=localhost.localdomain -configdir="/etc/awstats"' to update config localhost.localdomain
Create/Update database for config "/etc/awstats/awstats.localhost.localdomain.conf" by AWStats version 6.8 (build 1.910)
From data in log file "/var/log/httpd/access_log"...
Phase 1 : First bypass old records, searching new record...
Direct access after last parsed record (after line 7274)
Jumped lines in file: 7274
Found 7274 already parsed records.
Parsed lines in file: 25
Found 0 dropped records,
Found 0 corrupted records,
Found 0 old records,
Found 25 new qualified records.

Running '"/usr/share/awstats/wwwroot/cgi-bin/awstats.pl" -update -config=skito.no-ip.org -configdir="/etc/awstats"' to update config skito.no-ip.org
Create/Update database for config "/etc/awstats/awstats.skito.no-ip.org.conf" by AWStats version 6.8 (build 1.910)
From data in log file "/var/log/httpd/access_log"...
Phase 1 : First bypass old records, searching new record...
Direct access to last remembered record has fallen on another record.
So searching new records from beginning of log file...
Phase 2 : Now process new records (Flush history on disk after 20000 hosts)...
Jumped lines in file: 0
Parsed lines in file: 7299
Found 0 dropped records,
Found 0 corrupted records,
Found 0 old records,
Found 7299 new qualified records.

問題なく更新ができるようになりました。

“BadName (named color or font does not exist)” error
2008-07-22
Fedora9にアップグレードしたら、firefoxが起動しなくなりました。
エラーを見ると、"BadName (named color or font does not exist)"と。

手っ取り早く直すために、xfsを停止してみます。
#/etc/init.d/xfs stop

次回からも停止するためは、次のようにします。
# /sbin/chkconfig --level 2345 xfs off

最後に確認です。
# /sbin/chkconfig --list xfs
xfs 0:off 1:off 2:off 3:off 4:off 5:off 6:off