网上书店营销系统的软硬件安装与配置说明(beta)
运行平台:
intel-i686-40g-256m----server;
red hat linux 7.2(engima),postgresql7.2.1,apache1.3.22
基本软件需要及获得:
操作系统:red hat linux7.2;
数据库系统:postgresql7.2.1;
web服务器:apache1.3.22;
jdk1.3.1,linux version(rpm包);
java&jsp解析引擎:caucho resin 2.0.4;
postgresql--jdbc驱动程序:pgjdbc2.jar;
安装步骤:
采用默认安装好red hat linux7.2;
系统环境设置:
export lang=zh_cn
export lc_all=zh_cn
根据以下步骤安装系统运行时环境:
1,安装jdk1.3.1(red hat linux安装版的rpm包);
rpm ?civh jdk1.3.1.i386.rpm
export java_home=/usr/java/jdk
export classpath=$classpath:$java_home/lib:$java_home/jre/lib
2,安装apache1.3.22( current path=/usr/local )
tar ?cxzvf apache1.3.22.tar.gz
./configure ?cprefix=/usr/local/apache ?cenable-module=so
make
make install
3,安装resin2.0.4( current path=/usr/local/resin )
tar ?cxvf resin2.0.4.tar
./configure ?cwith-apache=/usr/local/apache
make
make install
4,安装postgresql7.2.1(red hat linux安装版的rpm包)
rpm ?civh postgresql-libs-7.2.1-5.i386.rpm
rpm ?civh postgresql-7.2.1-5.i386.rpm
rpm ?civh postgresql-server-7.2.1-5.i386.rpm
rpm ?civh postgresql-devel-7.2.1-5.i386.rpm
rpm ?civh postgresql-jdbc-7.2.1-5.i386.rpm
mv pgjdbc2.jar $java_home/lib
export classpath=$classpath:$java_home/lib/pgjdbc2.jar
初始化数据库:
mkdir /usr/local/pgsql/data
export pgdata=/usr/local/pgsql/data
su postgres
initdb
postmaster ?ci &
createdb ?ce euc-cn dbebook
psql dbebook
create table users(id serial,name varchar(16),passwd varchar(16),email varchar(60),address varchar(100),zipcode varchar(8),phone varchar(14),level varchar(12));
create table books (id serial,isbn varchar(15),title varchar(255),author varchar(50),summary varchar(500),price decimal(12),classid int,discount int,image bytea);
create table bookclass (id serial,class varchar(16),parentid int,depth int);
create table orders (id serial,shopcartid integer [],email varchar(100),ordertime timestamp(0),totalprice decimal(16),status varchar(10));
alter table orders alter ordertime set default now();
create table shopcarts (id serial,bookid int,quantity int,unitprice decimal(12),commit boolean );
create table operators (id serial,name varchar(10),passwd varchar(16),email varchar(50),dept varchar(10));
alter table operators alter dept set default 'normal';
alter table shopcarts alter commit set default false;
alter table orders alter status set default 'notpayfor';
设置数据库的网络端口侦听及用户:
emacs(or vi) $pgdata/pg_hba.conf
5,安装文档及运行
拷贝web应用到/usr/local/apache/htdocs下;
重启所有服务(apachectl, postmaster, httpd.sh);
6,通过http://[hostname]/直接访问页面。
闽公网安备 35060202000074号