http://www.kernel.org/pub/linux/kernel/v2.6/
http://ace-host.stuart.id.au/russell/files/debian/sarge/kernel-source-2.6.17/
ソースの入手
sarge:/home/xxxx# dpkg -i kernel-source-2.6.15_2.6.15-7.1_all.deb
未選択パッケージ kernel-source-2.6.15 を選択しています。
(データベースを読み込んでいます... 現在 112111 個のファイルとディレクトリがイン
ストールされています。)
(kernel-source-2.6.15_2.6.15-7.1_all.deb から) kernel-source-2.6.15 を展開してい
ます...
kernel-source-2.6.15 (2.6.15-7.1) を設定しています ...
sarge:/boot# apt-get install kernel-source-`uname -r` rpm
パッケージリストを読みこんでいます... 完了
依存関係ツリーを作成しています... 完了
kernel-source-2.6.15 は既に最新バージョンです。
以下の特別パッケージがインストールされます:
librpm4
提案パッケージ:
alien
以下のパッケージが新たにインストールされます:
librpm4 rpm
アップグレード: 0 個、新規インストール: 2 個、削除: 0 個、保留: 131 個。
885kB のアーカイブを取得する必要があります。
展開後に追加で 2810kB のディスク容量が消費されます。
続行しますか? [Y/n] Y
取得:1 http://ftp.jp.debian.org sarge/main librpm4 4.0.4-31 [369kB]
取得:2 http://ftp.jp.debian.org sarge/main rpm 4.0.4-31 [517kB]
885kB を 1s で取得しました (510kB/s)
未選択パッケージ librpm4 を選択しています。
(データベースを読み込んでいます... 現在 115214 個のファイルとディレクトリがイン
ストールされています。)
(.../librpm4_4.0.4-31_i386.deb から) librpm4 を展開しています...
未選択パッケージ rpm を選択しています。
(.../archives/rpm_4.0.4-31_i386.deb から) rpm を展開しています...
librpm4 (4.0.4-31) を設定しています ...
rpm (4.0.4-31) を設定しています ...
sarge:/boot#
カーネルのmake を行う
-------------------------------------------------------------------------------
sarge:/usr/src#
sarge:/home/xxxx# cd /usr/src
sarge:/usr/src# ls
kernel-source-2.6.15.tar.bz2
sarge:/usr/src# tar jxf kernel-source-2.6.15.tar.bz2
sarge:/usr/src# ls
kernel-source-2.6.15 kernel-source-2.6.15.tar.bz2
sarge:/usr/src#
# apt-get install (kernel-source-2.6.15) kernel-package
# apt-get install libncurses5-dev
# cd /usr/src/
# tar xvfj kernel-source-2.6.15.tar.bz2
# rm linux
# ln -s kernel-source-2.6.15 linux
# cd linux
# cp /boot/config-2.6.15-1-686 .config
# make-kpkg clean
# make menuconfig
# make-kpkg --append_to_version -1-686 --initrd kernel_image
# cd ..
# dpkg -i kernel-image-2.6.15_custom.1_i386.deb
本題のF-Secure Anti-Virus Linux Server Security導入
-----------------------------------------------------------------------------
sarge:/home/xxxx# tar zxvf fsav-linux-server-security-5.21.5442.tgz
fsav-linux-server-security-5.21.5442/
fsav-linux-server-security-5.21.5442/fsav-linux-server-security-5.21.5442
fsav-linux-server-security-5.21.5442/AdminGuide_English.pdf
fsav-linux-server-security-5.21.5442/AdminGuide_German.pdf
fsav-linux-server-security-5.21.5442/Release-notes.txt
fsav-linux-server-security-5.21.5442/TroubleshootingGuide.txt
fsav-linux-server-security-5.21.5442/WorkArounds.txt
fsav-linux-server-security-5.21.5442/fsav_linux_521_mib-signed.jar
fsav-linux-server-security-5.21.5442/pmc_upgrade.txt
fsav-linux-server-security-5.21.5442/windows_pmc_upgrade_5.60.2745-5.zip
fsav-linux-server-security-5.21.5442/windows_pmc_upgrade_5.70.282x-2901.zip
sarge:/home/xxxx#
arge:/home/xxxx/fsav-linux-server-security-5.21.5442# ./fsav-linux-server-secur
ity-5.21.5442
F-Secure Anti-Virus Linux Server Security installation
Copyright (c) 1999-2005 F-Secure Corporation. All Rights Reserved.
Select language to use in Web User Interface
[1] English (default)
[2] Japanese
[3] German
Please select 1, 2, or 3 [1]: 2
You must accept following F-Secure license agreement
to install F-Secure Anti-Virus Linux Server Security.
Press enter to view license agreement.
Do you accept this license agreement? yes
The license agreement text is available at /opt/f-secure/fsav/LICENSE.
Preparing installation (this will take a few minutes)....
Checking the environment:
- found kernel headers
- found compiler
- found make
We will now ask you some questions regarding the installation of this product.
A default value will be shown in square brackets after the question. To accept
the default, just press enter.
To install F-Secure Anti-Virus Linux Server Security, enter the keycode you
have received with your purchase or press enter to install evaluation version.
keycode:
No keycode. Installing evaluation version.
Do you want to install F-Secure Anti-Virus Linux Server Security as
standalone or centrally managed?
Select [s]tandalone or [c]entrally managed [standalone]:
Configuring system.......
Allow remote access to the web user interface? [no] yes
Allow connections from localhost to the web user interface
without login? [yes] yes
Please enter the user name who is allowed to use the web user interface.
User name: xxxx
Please insert passphrase for HMAC creation (max 80 characters)
********
Retype passphrase
********
HMAC is fe7783ac695a2182f4f383fc98bca8858a73f941110979318ae5f6b18e41600c
Baseline successfully created.
- Linux kernel module verification is enabled.
- /dev/kmem write protection is enabled.
- Real-time virus protection enabled
- Integrity checking enabled
- Firewall enabled
F-Secure Anti-Virus Linux Server Security installation finished.
Tips:
You can scan all local hard drives for viruses like this:
- Open K-menu -> F-Secure Anti-Virus Linux Server Security ->
Scan all hard drives
or
- Type 'fsav /' into a terminal window
You can scan any file or directory by right-clicking it in
the KDE file manager and choosing Actions -> Scan This Entry
Installation completed successfully.
sarge:/home/xxxx/fsav-linux-server-security-5.21.5442# /etc/init.d/fsma stop
Stopping FSMA modules
Stopping F-Secure FSAV Web UI (/opt/f-secure/fsav/tomcat/bin/shutdown.sh) as
root
Stopping F-Secure FSAV PostgreSQL daemon (/opt/f-secure/fsav/pgsql/bin/shutd
own.sh) as fsma
Stopping F-Secure Management Agent
sarge:/home/xxxx/fsav-linux-server-security-5.21.5442# /etc/init.d/fsma start
Starting F-Secure Management Agent (running as fsma user)
Starting FSMA modules
Starting F-Secure Alert Database Handler Daemon (/opt/f-secure/fsav/bin/fsad
hd.run) as fsma
Starting F-Secure FSAV Policy Manager Daemon (/opt/f-secure/fsav/bin/fsavpmd
) as root
Starting F-Secure Firewall Daemon (/opt/f-secure/fsav/bin/fsfwd.run) as root
Starting F-Secure FSAV License Alerter (/opt/f-secure/fsav/bin/fslmalerter)
as root
Starting F-Secure FSAV On-Access Scanner Daemon (/opt/f-secure/fsav/bin/fsoa
sd.run) as root
Starting F-Secure FSAV Status Daemon (/opt/f-secure/fsav/bin/fstatusd) as ro
ot
Starting F-Secure FSAV Web UI (/opt/f-secure/fsav/tomcat/bin/catalina.sh sta
rt) as root
Starting F-Secure FSAV PostgreSQL daemon (/opt/f-secure/fsav/pgsql/bin/start
up.sh) as fsma
sarge:/home/xxxx/fsav-linux-server-security-5.21.5442#
sarge:/home/xxxx# cd /root/fs_dazuko
sarge:~/fs_dazuko# make -f Makefile.fsecure
./configure --enable-event-unlink --enable-event-close-modified --disable-compat
1 --without-library --without-example-c --enable-syscalls
checking host system type... Linux
checking for make utility... ok (make)
checking for C compiler... ok (cc)
kernel source in /lib/modules/2.6.16/build... yes
acquiring Linux kernel code configuration... ok
checking if Linux is RSBAC patched... no
checking if devfs is enabled... no
discovered host system... Linux (2.6.16)
inspecting suspend function... ok (suspend1)
checking whether __d_path() is exported... no (using local copy)
inspecting class type... ok (class)
configure: creating Makefile
Finding do_execve from: /boot/System.map-2.6.16 OK
./configure successful
=======================
Configuration summary
=======================
module events = ON_OPEN ON_CLOSE ON_EXEC ON_UNLINK ON_CLOSE_MODIFIED
devfs support = no
rsbac support = no
using system call hooking
local __d_path() = yes
module debug = no
library 1.x compatibility = no
make -f Makefile
make[1]: Entering directory `/root/fs_dazuko'
make -C /lib/modules/2.6.16/build SUBDIRS="/root/fs_dazuko" modules
make[2]: Entering directory `/usr/src/kernel-source-2.6.16'
CC [M] /root/fs_dazuko/dazuko_core.o
CC [M] /root/fs_dazuko/dazuko_transport.o
CC [M] /root/fs_dazuko/dazuko_linux26_syscall.o
/root/fs_dazuko/dazuko_linux26_syscall.c: 関数 `dazuko_get_fd_dentry' 内:
/root/fs_dazuko/dazuko_linux26_syscall.c:499: error: structure has no member nam
ed `fd'
/root/fs_dazuko/dazuko_linux26_syscall.c: 関数 `linux_dazuko_sys_dup2' 内:
/root/fs_dazuko/dazuko_linux26_syscall.c:1134: error: structure has no member na
med `max_fds'
/root/fs_dazuko/dazuko_linux26_syscall.c: 関数 `linux_dazuko_sys_close' 内:
/root/fs_dazuko/dazuko_linux26_syscall.c:1212: error: structure has no member na
med `max_fds'
/root/fs_dazuko/dazuko_linux26_syscall.c: 関数 `xp_sys_hook' 内:
/root/fs_dazuko/dazuko_linux26_syscall.c:1548: 警告: 引数 2 個の `class_device_c
reate' を渡しますにより、キャストなしで整数からポインタを作りました
/root/fs_dazuko/dazuko_linux26_syscall.c:1548: 警告: 引数 3 個の `class_device_c
reate' を渡しますにより、キャストなしでポインタから整数を作りました
/root/fs_dazuko/dazuko_linux26_syscall.c:1548: 警告: 互換性のないポインタ型から
の引数 4 個の `class_device_create' を渡しますです
/root/fs_dazuko/dazuko_linux26_syscall.c:1548: error: too few arguments to funct
ion `class_device_create'
make[3]: *** [/root/fs_dazuko/dazuko_linux26_syscall.o] エラー 1
make[2]: *** [_module_/root/fs_dazuko] エラー 2
make[2]: Leaving directory `/usr/src/kernel-source-2.6.16'
make[1]: *** [dummy_rule] エラー 2
make[1]: Leaving directory `/root/fs_dazuko'
make: *** [all] エラー 2
sarge:~/fs_dazuko#
https://172.21.20.41:28082/fsecure/webui にアクセスして画面が出ればOK
|
xxxx@sarge:~$ su Password: sarge:/home/xxxx# cd /usr/local/src sarge:/usr/local/src# ls sarge:/usr/local/src# cd /tmp sarge:/tmp# ls KAVUNIXFSEN1m.tgz blob hsperfdata_root wfc.control wfc.jma-receipt sarge:/tmp# mv KAVUNIXFSEN1m.tgz /usr/local/src sarge:/tmp# cd /usr/local/src sarge:/usr/local/src# ls KAVUNIXFSEN1m.tgz sarge:/usr/local/src# tar zxvf KAVUNIXFSEN1m.tgz KAVUNIXFSEN1m/doc/kav5.5_unixfsen.pdf KAVUNIXFSEN1m/doc/release_notes_en.txt KAVUNIXFSEN1m/kavfreebsd/4.x/kav4fs-5.5.24.tgz KAVUNIXFSEN1m/kavfreebsd/5.x/kav4fs-5.5.24.tgz KAVUNIXFSEN1m/kavfreebsd/6.x/kav4fs-5.5.24.tgz KAVUNIXFSEN1m/kavlinux/kav4fs-5.5-24.i386.rpm KAVUNIXFSEN1m/kavlinux/kav4fs-5.5.24.deb KAVUNIXFSEN1m/license/0092927F.key sarge:/usr/local/src# cd KAVUNIXFSEN1m/kavlinux/ sarge:/usr/local/src/KAVUNIXFSEN1m/kavlinux# ls kav4fs-5.5-24.i386.rpm kav4fs-5.5.24.deb sarge:/usr/local/src/KAVUNIXFSEN1m/kavlinux# dpkg -i kav4fs-5.5.24.deb (データベースを読み込んでいます... 現在 120030 個のファイルとディレクトリがイン ストールされています。) kav4fs 5.5.24 を(kav4fs-5.5.24.deb で)置換するための準備をしています... update-rc.d: /etc/init.d/kav4fs exists during rc.d purge (continuing) kav4fs を展開し、置換しています... kav4fs (5.5.24) を設定しています ... Installing license files. License file (a file with .key extension) is your personal license key. You need to install it to use the application. To install it right now, just enter the path to the location of your license file (enter an empty string to continue without key file installation): /usr/local/src/KAVUNIXFSEN1m/license/ License file /usr/local/src/KAVUNIXFSEN1m/license/0092927F.key has been installed Configuring KeepUp2Date proxy settings. If you use an http proxy server to access the Internet, you need to tell the Kaspersky Anti-Virus for Unix KeepUp2Date component about it. Please enter the address of your http proxy server in one of the following forms, http://proxyIP:port or http://user:pass@proxyIP:port. If you don't have or need a proxy server to access the Internet, enter 'no' here: Latest anti-virus bases are an essential part of your anti-virus protection. Do you want to download the latest anti-virus bases right now to insure your application is up to date? (If you answer 'yes', make sure you are connected to the Internet): [yes]: no Default Webmin configuration file was not found. This means that either Webmin is not installed at all, or is installed into a non-default location. Webmin (www.webmin.com) is a web-based interface for system administration for various Unix components. If you install it, you'll be able to configure and use Kaspersky Anti-Virus through the web interface. If you want to use this functionality, but haven't installed Webmin yet, you can skip this stage and install this module later using Webmin's built-in installation procedure. If you have Webmin installed in a non-default path, please enter the path to the location of the Webmin configuration file, or leave blank to skip? If you want to use this module later, you can install it using Webmin's own installation procedure. The module will be placed in /opt/kaspersky/kav4fs/share/contrib/kav4fs.wbm. Kaspersky Anti-Virus for Unix is installed. Configuration file was installed in /etc/opt/kaspersky/kav4fs.conf Binaries were installed in /opt/kaspersky/kav4fs/bin Latest anti-virus bases are an essential part of your anti-virus protection, and without them the application will not function. You must run keepup2date component to download the latest anti-virus bases before using the application, and then run /opt/kaspersky/kav4fs/lib/bin/setup/setup.pl configuration script to set up the Kaspersky Anti-Virus for Unix. sarge:/usr/local/src/KAVUNIXFSEN1m/kavlinux# sarge:/home/xxxx# /opt/kaspersky/kav4fs/lib/bin/setup/setup.pl Would you like to compile the kavmonitor module [Y]: Enter the linux kernel source path [/usr/src/linux]: /usr/src/kernel-source-2.6.15 checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu Debian 3.1 checking for linux kernel sources... /usr/src/kernel-source-2.6.15 checking for linux kernel version... 2.6 checking for linux/syscalls.h... yes checking for module arch... 32 checking for vmlinux... /usr/src/kernel-source-2.6.15/vmlinux checking for sys_call_table... sys_call_table address = 0xc02ba8dc checking for sys_call_table readonly... no checking for do_execve is exported... no, do_execve address=0xc01519a0 checking for __d_path is exported... __d_path address=0xc015c4a9 configure: creating ./config.status config.status: creating Makefile config.status: creating kavmon.h config.status: creating osdef.h config.status: creating module.linux/Makefile Cleaning module.linux make[1]: Entering directory `/opt/kaspersky/kav4fs/src/module.linux' rm -f **.o *.ko ../bin//kavmon.ko monitor_helpers.c kernel.c queue.c md5.c ca che.c util.c cache.h kavmon.h kernel.h md5.h monitor.h monitor_helpers.h osdef.h queue.h util.h *.mod.c .*.cmd Makefile.in make[1]: Leaving directory `/opt/kaspersky/kav4fs/src/module.linux' Making link in module.linux make[1]: Entering directory `/opt/kaspersky/kav4fs/src/module.linux' make -C /usr/src/kernel-source-2.6.15 SUBDIRS=/opt/kaspersky/kav4fs/src/module.l inux modules make[2]: Entering directory `/usr/src/kernel-source-2.6.15' CC [M] /opt/kaspersky/kav4fs/src/module.linux/utils.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/module.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/interface.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/interface_monitor.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/interface_exploit.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/interceptor.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/files.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/monitor_helpers.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/kernel.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/queue.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/md5.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/cache.o CC [M] /opt/kaspersky/kav4fs/src/module.linux/util.o LD [M] /opt/kaspersky/kav4fs/src/module.linux/kavmon.o Building modules, stage 2. MODPOST CC /opt/kaspersky/kav4fs/src/module.linux/kavmon.mod.o LD [M] /opt/kaspersky/kav4fs/src/module.linux/kavmon.ko make[2]: Leaving directory `/usr/src/kernel-source-2.6.15' make[1]: Leaving directory `/opt/kaspersky/kav4fs/src/module.linux' Starting kavmonitor: kavmonitor started sarge:/home/xxxx# bin sarge:/opt/kaspersky/kav4fs/lib# cd ../bin sarge:/opt/kaspersky/kav4fs/bin# ls kav4fs-kavscanner kav4fs-keepup2date kav4fs-licensemanager sarge:/opt/kaspersky/kav4fs/bin# ./kav4fs-keepup2date Kaspersky KeepUp2Date 5.5.18/RELEASE build #25 Copyright (C) Kaspersky Lab, 1997-2006. Portions Copyright (C) Lan Crypto Configuration file: /etc/opt/kaspersky/kav4fs.conf === Update task started Update source selected 'http://dnl-eu5.kaspersky-labs.com/' Downloading file 'index/master.xml.klz' Downloading file 'bases/av/avc/i386/kavset.xml.klz' Downloading file 'AutoPatches/soft.xml.klz' Downloading file 'diffs/index/updcfg.xml.dsd' Downloading file 'index/updcfg.xml' Downloading file 'bases/av/avc/i386/black.lst' Downloading file 'bases/av/avc/i386/kernel.avc' Downloading file 'bases/av/avc/i386/krnunp.avc' Downloading file 'bases/av/avc/i386/krnexe.avc' Downloading file 'bases/av/avc/i386/krnmacro.avc' Downloading file 'bases/av/avc/i386/krnjava.avc' Downloading file 'bases/av/avc/i386/krndos.avc' Downloading file 'bases/av/avc/i386/krn001.avc' Downloading file 'bases/av/avc/i386/krn002.avc' Downloading file 'bases/av/avc/i386/krn003.avc' Downloading file 'bases/av/avc/i386/krn004.avc' Downloading file 'bases/av/avc/i386/krnexe32.avc' Downloading file 'bases/av/avc/i386/krnengn.avc' Downloading file 'bases/av/avc/i386/smart.avc' Downloading file 'bases/av/avc/i386/ocr.avc' Downloading file 'bases/av/avc/i386/chuka.avc' Downloading file 'bases/av/avc/i386/fa001.avc' Downloading file 'bases/av/avc/i386/base001c.avc' Downloading file 'bases/av/avc/i386/base002c.avc' Downloading file 'bases/av/avc/i386/base003c.avc' Downloading file 'bases/av/avc/i386/base004c.avc' Downloading file 'bases/av/avc/i386/base005c.avc' Downloading file 'bases/av/avc/i386/base006c.avc' Downloading file 'bases/av/avc/i386/base007c.avc' Downloading file 'bases/av/avc/i386/base008c.avc' Downloading file 'bases/av/avc/i386/base009c.avc' Downloading file 'bases/av/avc/i386/base010c.avc' Downloading file 'bases/av/avc/i386/base011c.avc' Downloading file 'bases/av/avc/i386/dailyc.avc' Downloading file 'bases/av/avc/i386/ext001c.avc' New file installed '/var/opt/kaspersky/kav4fs/bases/avp.vnd' New file installed '/var/opt/kaspersky/kav4fs/bases/avp.klb' New file installed '/var/opt/kaspersky/kav4fs/bases/Patches/soft.ver' Update 'Kaspersky Anti-Virus for Unix' completed successfully Executing command /etc/init.d/kav4fs reload_avbase kavmonitor could not reload AV bases: pid file not found Command /etc/init.d/kav4fs reload_avbase was executed with code 120 sarge:/opt/kaspersky/kav4fs/bin# ps -ax 4510 pts/0 Ss 0:00 -bash 4515 pts/0 S 0:00 bash 6952 ? S 0:00 /opt/kaspersky/kav4fs/sbin/kav4fs-kavmonitor -C /etc/ 6953 ? S 0:02 /opt/kaspersky/kav4fs/sbin/kav4fs-kavmonitor -C /etc/ 6956 ? S 0:00 /opt/kaspersky/kav4fs/sbin/kav4fs-kavmonitor -C /etc/ 6957 ? S 0:00 /opt/kaspersky/kav4fs/sbin/kav4fs-kavmonitor -C /etc/ 6958 ? R 0:00 /opt/kaspersky/kav4fs/sbin/kav4fs-kavmonitor -C /etc/ 6961 pts/0 R+ 0:00 ps -ax sarge:/opt/kaspersky/kav4fs/bin# arge:/opt/kaspersky/kav4fs/bin# ./kav4fs-kavscanner -i0 ./ Kaspersky Anti-Virus On-Demand Scanner for Linux. Version 5.5.18/RELEASE build # 146, compiled Sep 28 2006, 15:14:07 Copyright (C) Kaspersky Lab, 1997-2006. Portions Copyright (C) Lan Crypto There are 289451 records loaded, the latest update 01-05-2007 Config file: /etc/opt/kaspersky/kav4fs.conf /opt/kaspersky/kav4fs/bin/kav4fs-licensemanager OK /opt/kaspersky/kav4fs/bin/kav4fs-kavscanner OK /opt/kaspersky/kav4fs/bin/kav4fs-keepup2date OK home/xxxx/kernel-source-2.6.8_2.6.8-16sarge6_all.deb OK /home/xxxx/A34YM19.red OK /home/xxxx/A34YM19.INC OK /home/xxxx/totani070427_v34.tar.gz Archive GZIP /home/xxxx/totani070427_v34.tar.gz/totani070427_v34.tar.tar Archive Tar ~rca/totani070427_v34.tar.gz/totani070427_v34.tar.tar/totani070427_v34.dump OK /home/xxxx/totani070427_v34.tar.gz/totani070427_v34.tar.tar OK /home/xxxx/totani070427_v34.tar.gz OK /home/xxxx/xxxx070427emp_v34.dump OK /home/xxxx/xxxx_wdclient.sh OK /home/xxxx/recept1a.log OK /home/xxxx/recept4.log OK /home/xxxx/recept9a.log OK /home/xxxx/.ganttproject OK sarge:/opt/kaspersky/kav4fs/bin# arge:/etc/init.d# /opt/kaspersky/kav4fs/bin/kav4fs-keepup2date Kaspersky KeepUp2Date 5.5.18/RELEASE build #25 Copyright (C) Kaspersky Lab, 1997-2006. Portions Copyright (C) Lan Crypto Configuration file: /etc/opt/kaspersky/kav4fs.conf === Update task started Update source selected 'http://dnl-eu5.kaspersky-labs.com/' Downloading file 'index/master.xml.klz' === Checking new bases Standard AV bases are OK, latest update: 01-05-2007, total records: 289451. Extended AV bases are OK, latest update: 01-05-2007, total records: 307687. === All files downloaded. Replacing files File updated '/var/opt/kaspersky/kav4fs/bases/master.xml' Update 'Kaspersky Anti-Virus for Unix' completed successfully Executing command /etc/init.d/kav4fs reload_avbase kavmonitor could not reload AV bases: pid file not found Command /etc/init.d/kav4fs reload_avbase was executed with code 120 sarge:/etc/init.d# /etc/init.d/kav4fs start kavmonitor started sarge:/etc/init.d# /opt/kaspersky/kav4fs/bin/kav4fs-keepup2date Kaspersky KeepUp2Date 5.5.18/RELEASE build #25 Copyright (C) Kaspersky Lab, 1997-2006. Portions Copyright (C) Lan Crypto Configuration file: /etc/opt/kaspersky/kav4fs.conf === Update task started Update source selected 'http://dnl-us3.kaspersky-labs.com/' Downloading file 'index/master.xml.klz' All files are up-to-date sarge:/etc/init.d |
Debian sarge に挑戦するが、libc6の関係で導入エラー、気を取り直してEtchに sarge:/home/xxxx# apt-get install mysql-server パッケージリストを読みこんでいます... 完了 依存関係ツリーを作成しています... 完了 以下の特別パッケージがインストールされます: libdbd-mysql-perl libdbi-perl libmysqlclient12 libnet-daemon-perl libplrpc-perl mysql-client mysql-common 提案パッケージ: dbishell libcompress-zlib-perl mysql-doc 以下のパッケージが新たにインストールされます: libdbd-mysql-perl libdbi-perl libmysqlclient12 libnet-daemon-perl libplrpc-perl mysql-client mysql-common mysql-server アップグレード: 0 個、新規インストール: 8 個、削除: 0 個、保留: 0 個。 5212kB のアーカイブを取得する必要があります。 展開後に追加で 12.5MB のディスク容量が消費されます。 続行しますか? [Y/n] Y 未選択パッケージ mysql-common を選択しています。 (データベースを読み込んでいます... 現在 120030 個のファイルとディレクトリがイン ストールされています。) (.../mysql-common_4.0.24-10sarge2_all.deb から) mysql-common を展開しています... 未選択パッケージ libmysqlclient12 を選択しています。 (.../libmysqlclient12_4.0.24-10sarge2_i386.deb から) libmysqlclient12 を展開して います... 未選択パッケージ libnet-daemon-perl を選択しています。 (.../libnet-daemon-perl_0.38-1_all.deb から) libnet-daemon-perl を展開しています ... 未選択パッケージ libplrpc-perl を選択しています。 (.../libplrpc-perl_0.2017-1_all.deb から) libplrpc-perl を展開しています... 未選択パッケージ libdbi-perl を選択しています。 (.../libdbi-perl_1.46-6_i386.deb から) libdbi-perl を展開しています... 未選択パッケージ libdbd-mysql-perl を選択しています。 (.../libdbd-mysql-perl_2.9006-1_i386.deb から) libdbd-mysql-perl を展開していま す... 未選択パッケージ mysql-client を選択しています。 (.../mysql-client_4.0.24-10sarge2_i386.deb から) mysql-client を展開しています.. . 未選択パッケージ mysql-server を選択しています。 (.../mysql-server_4.0.24-10sarge2_i386.deb から) mysql-server を展開しています.. . mysql-common (4.0.24-10sarge2) を設定しています ... libmysqlclient12 (4.0.24-10sarge2) を設定しています ... libnet-daemon-perl (0.38-1) を設定しています ... libplrpc-perl (0.2017-1) を設定しています ... libdbi-perl (1.46-6) を設定しています ... libdbd-mysql-perl (2.9006-1) を設定しています ... mysql-client (4.0.24-10sarge2) を設定しています ... mysql-server (4.0.24-10sarge2) を設定しています ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld. Checking for crashed MySQL tables in the background. sarge:/home/xxxx# mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.24_Debian-10sarge2-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database zabbix;exit cd Query OK, 1 row affected (0.00 sec) mysql> exit Bye sarge:/home/xxxx# 各種 Zabbixのパッケージはこちらから http://ftp.yz.yamagata-u.ac.jp/debian/pool/main/z/zabbix/?C=M;O=A etch:/home/xxxx/zabbix# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select Host, User, Password from mysql.user; +-----------+------------------+-------------------------------------------+ | Host | User | Password | +-----------+------------------+-------------------------------------------+ | localhost | root | *D8B1558350BAC9AF2135EA07127712062C7C292C | | etch | root | | | localhost | debian-sys-maint | *F3B029BC46958FAAAD8CACF39BAF1AC15A57D7E8 | | localhost | wwwdata | *D8B1558350BAC9AF2135EA07127712062C7C292C | +-----------+------------------+-------------------------------------------+ 4 rows in set (0.00 sec) mysql> grant all privilegges on zabbix.* to zabbix@localhost identified by 'xxxxx'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'privilegges on zabbix.* to zabbix@localhost identified by 'xxxxx'' at line 1 mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'xxxxx'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> select Host, User, Password from mysql.user; +-----------+------------------+-------------------------------------------+ | Host | User | Password | +-----------+------------------+-------------------------------------------+ | localhost | root | *D8B1558350BAC9AF2135EA07127712062C7C292C | | etch | root | | | localhost | debian-sys-maint | *F3B029BC46958FAAAD8CACF39BAF1AC15A57D7E8 | | localhost | wwwdata | *D8B1558350BAC9AF2135EA07127712062C7C292C | | localhost | zabbix | *D8B1558350BAC9AF2135EA07127712062C7C292C | +-----------+------------------+-------------------------------------------+ 5 rows in set (0.00 sec) mysql> grant all privileges on zabbix.* to www-data@localhost identified by 'xxxx'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-data@localhost identified by 'xxxx'' at line 1 mysql> grant all privileges on www-data.* to www-data@localhost identified by 'xxxx'; ERROR 1046 (3D000): No database selected mysql> select Host, User, Password from mysql.user; +-----------+------------------+-------------------------------------------+ | Host | User | Password | +-----------+------------------+-------------------------------------------+ | localhost | root | *D8B1558350BAC9AF2135EA07127712062C7C292C | | etch | root | | | localhost | debian-sys-maint | *F3B029BC46958FAAAD8CACF39BAF1AC15A57D7E8 | | localhost | wwwdata | *D8B1558350BAC9AF2135EA07127712062C7C292C | | localhost | zabbix | *D8B1558350BAC9AF2135EA07127712062C7C292C | +-----------+------------------+-------------------------------------------+ 5 rows in set (0.00 sec) mysql> 4552 tty1 S+ 0:00 -bash 4709 ? Ss 0:00 sshd: xxxx [priv] 4711 ? S 0:00 sshd: xxxx@pts/0 4712 pts/0 Ss 0:00 -bash 4752 ? SNs 0:00 /usr/sbin/lpd -s 7790 ? S 0:00 /usr/sbin/winbindd 8965 ? Ss 0:00 /usr/sbin/apache2 -k start 8970 ? S 0:04 /usr/sbin/apache2 -k start 8971 ? S 0:04 /usr/sbin/apache2 -k start 8972 ? S 0:04 /usr/sbin/apache2 -k start 8973 ? S 0:04 /usr/sbin/apache2 -k start 8974 ? S 0:05 /usr/sbin/apache2 -k start 8975 ? S 0:04 /usr/sbin/apache2 -k start 9163 ? S 0:03 /usr/sbin/apache2 -k start 9238 ? SN 0:00 /usr/sbin/zabbix_agentd 9239 ? SN 0:00 /usr/sbin/zabbix_agentd 9240 ? SN 0:00 /usr/sbin/zabbix_agentd 9241 ? SN 0:00 /usr/sbin/zabbix_agentd 9242 ? SN 0:00 /usr/sbin/zabbix_agentd 9243 ? SN 0:00 /usr/sbin/zabbix_agentd 9586 pts/0 S 0:00 su 9587 pts/0 S 0:00 bash 9661 pts/0 S 0:00 /bin/sh /usr/bin/mysqld_safe 9698 pts/0 Sl 0:04 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/ 9699 pts/0 S 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld 9768 ? S 0:00 /usr/sbin/zabbix_server 9769 ? S 0:00 /usr/sbin/zabbix_server 9770 ? S 0:00 /usr/sbin/zabbix_server 9771 ? S 0:00 /usr/sbin/zabbix_server 9773 ? S 0:00 /usr/sbin/zabbix_server 9775 ? S 0:00 /usr/sbin/zabbix_server 9776 ? S 0:00 /usr/sbin/zabbix_server 9778 ? S 0:00 /usr/sbin/zabbix_server 9780 ? S 0:00 /usr/sbin/zabbix_server 9782 ? S 0:00 /usr/sbin/zabbix_server 9784 ? S 0:00 /usr/sbin/zabbix_server 9799 ? Ssl 0:00 identd 9984 pts/0 R+ 0:00 ps -ax etch:/etc/zabbix# mysql root passwd は mysqladmin で変更 mysqladmin -u root password "xxxxxx" zabbix_server.conf 確認 mysql -u zabbix -p xxxx zabbix < schema.sql mysql -u zabbix -p xxxx zabbix < data.sql エラーが出たら、log(/var/log/zabbix-server/zabbix_server.log) を見る、mysqlに関する 権限とかの問題が大きいと思います。 007773:20070512:052002 Starting zabbix_server. ZABBIX 1.1.7. 007773:20070512:052002 Failed to connect to database: Error: Access denied for user 'zabbix'@'localhost' (using password: YES) 008801:20070512:061642 Starting zabbix_server. ZABBIX 1.1.7. 008801:20070512:061642 Failed to connect to database: Error: Access denied for user 'zabbix'@'localhost' (using password: NO) 009251:20070512:070721 Starting zabbix_server. ZABBIX 1.1.7. 009251:20070512:070721 Failed to connect to database: Error: Access denied for user 'zabbix'@'localhost' (using password: NO) 009370:20070512:074530 Starting zabbix_server. ZABBIX 1.1.7. 009370:20070512:074530 Failed to connect to database: Error: Access denied for user 'zabbix'@'localhost' (using password: NO) 009376:20070512:074544 Starting zabbix_server. ZABBIX 1.1.7. 009376:20070512:074544 Failed to connect to database: Error: Access denied for user 'zabbix'@'localhost' (using password: NO) 導入した、ツール類 apache2 PHP5 zabbix-server-mysql-1.1.7.deb zabbix-agent-1.1.7.deb zabbix-frontend-php-1.1.7.deb mysql-server |
仕事で、PRO*COBOL が必要になる。XXXX.pco を作りPRO*COBOLでコンパイル、XXXX.cblが出来上がる。出来上がった物を、コンパイル、出来たオブジェクトの実行。
---------------------------------------------------------------------------- pco
*****************************************************************
* Sample Program 2: Cursor Operations *
* *
* This program logs on to ORACLE, declares and opens a cursor, *
* fetches the names, salaries, and commissions of all *
* salespeople, displays the results, then closes the cursor. *
*****************************************************************
IDENTIFICATION DIVISION.
PROGRAM-ID. CURSOR-OPS.
ENVIRONMENT DIVISION.
DATA DIVISION.
WORKING-STORAGE SECTION.
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
01 USERNAME PIC X(10) VARYING.
01 PASSWD PIC X(10) VARYING.
01 EMP-REC-VARS.
05 EMP-NAME PIC X(10) VARYING.
05 SALARY PIC S9(6)V99
DISPLAY SIGN LEADING SEPARATE.
05 COMMISSION PIC S9(6)V99
DISPLAY SIGN LEADING SEPARATE.
PROCEDURE DIVISION.
BEGIN-PGM.
EXEC SQL WHENEVER SQLERROR
DO PERFORM SQL-ERROR END-EXEC.
PERFORM LOGON.
EXEC SQL DECLARE SALESPEOPLE CURSOR FOR
SELECT ENAME, SAL, COMM
FROM EMP
WHERE JOB LIKE 'SALES%'
END-EXEC.
EXEC SQL OPEN SALESPEOPLE END-EXEC.
DISPLAY " ".
DISPLAY "SALESPERSON SALARY COMMISSION".
DISPLAY "----------- ---------- ----------".
FETCH-LOOP.
EXEC SQL WHENEVER NOT FOUND
DO PERFORM SIGN-OFF END-EXEC.
EXEC SQL FETCH SALESPEOPLE
------------------------------------------------------------------------ cbl
****************************************************************
* Sample Program 2: Cursor Operations *
* *
* This program logs on to ORACLE, declares and opens a cursor, *
* fetches the names, salaries, and commissions of all *
* salespeople, displays the results, then closes the cursor. *
*****************************************************************
IDENTIFICATION DIVISION.
PROGRAM-ID. CURSOR-OPS.
ENVIRONMENT DIVISION.
DATA DIVISION.
WORKING-STORAGE SECTION.
01 SQLFPN GLOBAL.
02 SQLFPN-FILE-LEN PIC S9(4) COMP-5 VALUE +9.
02 SQLFPN-FILENAME PIC X(9) VALUE "scott.pco".
01 SQLCTX GLOBAL PIC S9(9) COMP-5 VALUE +39813.
01 SQLEXD GLOBAL.
02 SQL-SQLVSN PIC S9(9) COMP-5 VALUE +10.
01 SQLEXD GLOBAL.
02 SQL-SQLVSN PIC S9(9) COMP-5 VALUE +10.
02 SQL-ARRSIZ PIC S9(9) COMP-5 VALUE +4.
02 SQL-ITERS PIC S9(9) COMP-5.
02 SQL-OFFSET PIC S9(9) COMP-5.
02 SQL-SELERR PIC S9(4) COMP-5.
02 SQL-SQLETY PIC S9(4) COMP-5.
02 SQL-OCCURS PIC S9(9) COMP-5.
02 SQL-CUD PIC S9(9) COMP-5.
02 SQL-SQLEST PIC S9(9) COMP-5.
02 SQL-STMT PIC S9(9) COMP-5.
02 SQL-SQLADTP PIC S9(9) COMP-5 VALUE 0.
02 SQL-SQLTDSP PIC S9(9) COMP-5 VALUE 0.
02 SQL-SQPHSV PIC S9(9) COMP-5.
02 SQL-SQPHSL PIC S9(9) COMP-5.
02 SQL-SQPHSS PIC S9(9) COMP-5.
02 SQL-SQPIND PIC S9(9) COMP-5.
02 SQL-SQPINS PIC S9(9) COMP-5.
02 SQL-SQPARM PIC S9(9) COMP-5.
PROCEDURE DIVISION.
BEGIN-PGM.
* EXEC SQL WHENEVER SQLERROR
* DO PERFORM SQL-ERROR END-EXEC.
PERFORM LOGON.
* EXEC SQL DECLARE SALESPEOPLE CURSOR FOR
* SELECT ENAME, SAL, COMM
* FROM EMP
* WHERE JOB LIKE 'SALES%'
* END-EXEC.
* EXEC SQL OPEN SALESPEOPLE END-EXEC.
CALL "SQLADR" USING SQ0001 SQL-STMT
MOVE 1 TO SQL-ITERS
MOVE 5 TO SQL-OFFSET
MOVE 0 TO SQL-OCCURS
MOVE 1 TO SQL-SELERR
CALL "SQLADR" USING
--------------------------------------------------------------------------
[oracle@RHEL4 jcl] procob scott.pco
Pro*COBOL: Release 10.1.0.3.0 - Production on 木 5月 31 21:27:17 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
System default option values taken from: /u01/app/oracle/product/10.1.0/db_1/precomp/admin/pcbcfg.cfg
[acms@RHEL4 jcl]$ J_SCOTTM
070531:202524:J_SCOTTM: START JOB J_SCOTTM
login scott
CONNECTED TO ORACLE AS USER: SCOTT
SALESPERSON SALARY COMMISSION
----------- ---------- ----------
ALLEN 1600.00 300.00
WARD 1250.00 500.00
MARTIN 1250.00 1400.00
TURNER 1500.00 0.00
HAVE A GOOD DAY.
070531:202525:J_SCOTTM: END JOB J_SCOTTM
|
Linux+ASP関連のリンク集
ritsuo＠mxy.mesh.ne.jp
