Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Wcp knowledge Management system deployment document

2025-02-23 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Wcp knowledge Management system deployment document

Environment

CentOS-6.5-x86_64-bin-DVD1.iso

Jdk-7u79-linux-x64.tar.gz

Apache-tomcat-7.0.72.tar.gz

MySQL-5.6.33-1.el6.x86_64.rpm-bundle.tar

WCP knowledge management system v3.2.0 (free version. Open source) http://www.wcpdoc.com/webdoc/view/Pub8a2831b350e6b01f0150e6c1ad5a009f.html

Download address: Baidu cloud disk http://yun.baidu.com/s/1gfoHuYB

Configure IP addr

Vi / etc/sysconfig/network-scripts/ifcfg-eth0 # Press I key to start editing

... ...

BOOTPROTO=none # not specified (dhcp | static)

IPADDR=192.168.8.11 # configure IP address

NETMASK=255.255.255.0 # configure subnet mask

GATEWAY=192.168.8.1 # configure Gateway

: wq # (press the ESC key first) save and exit editing

Service network restart # restart the network card

Ifconfig # to see if it works

DNS:

Vim / etc/resolv.conf

Add:

Configure JAVA

Decompress jdkxxxxxxx

Copy jdk to / opt/java/ directory

Chmod 777 / opt/java/bin/* # set the bin directory to have execution permission

Configure environment variables:

Vim / etc/profile

Add the following at the end of the file:

JAVA_HOME=/opt/java (note that the path should be the same as the copy location above)

PATH=$PATH:$JAVA_HOME/bin

Export JAVA_HOME

Export PATH

: wq # (press the ESC key first) save and exit editing

Reload the profile file

# source / etc/profile

Java-version # if successful, you can see the java version number

*

If an older version is displayed, do the following:

1. # cd / usr/bin

2. # ln-s-f / usr/java/jre/bin/java

3. # ln-s-f / usr/java/bin/javac

# java-version

You can see that the jdk version is normal.

*

Configure tomcat

Decompress apache-tomcat-7.0.72.tar.gz

# tar-ixvf apache-tomcat-7.0.72.tar.gz

Copy apache-tomcat-7.0.72 to the / opt/ directory.

Repeat the command to tomcat7

# mv apache-tomcat-7.0.72 tomcat7

Configure mysql

Rpm-qa | grep mariadb # to see if there are conflicting packets

Rpm-e-- nodeps xxxxxxx # Uninstall the conflict package, and the file found by the xxx representative

Rpm-qa | grep-I mysql # check to see if there are conflicting packets

Rpm-e-- nodeps xxxxxxxxxx # Uninstall the conflict package, and the file found by the xxx representative

Install the server and client of mysql

Unzip: MySQL-5.6.33-1.el6.x86_64.rpm-bundle.tar

# tar-ixvf MySQL-5.6.33-1.el6.x86_64.rpm-bundle.tar

After decompression, you get the following rpm package:

Install client and server side

Rpm-ivh MySQL-client-5.6.33-1.el6.x86_64.rpm

Rpm-ivh MySQL-server-5.6.33-1.el6.x86_64.rpm

Start the service

# service mysqldstart

Netstat-nat | grep 3306 # if there is a port 3306, mysql starts successfully

Modify the initial password of the root user for mysql

Cat / root/.mysql_secret # View mysql password

Mysql-uroot-pxJ9Jo4kLbc9uM0rq # enters mysql, and "xJ9Jo4kLbc9uM0rq" is the mysql password (note that there is no space after-u and-p)

# SET PASSWORD FOR 'root'@'localhost' = PASSWORD (' 123456') (set the root password to 123456)

Flush privileges; # Refresh permissions

Quit # exit mysql

Modify the mysql configuration file to make it case-insensitive:

1. Copy the template to the / etc directory first

# cp / usr/share/doc/MySQL-server-5.6.33/my-default.cnf / etc/my.cnf

2. Set case insensitivity

# vim / etc/my.con

Under the [mysqld] node, add a line: lower_case_table_names=1

3. Restart MySQL.

Configure Firewall iptables

If you enable the firewall, you need to add a rule:

Vi / etc/sysconfig/iptables # add firewall rules for public network access

# press I key to start editing

-An INPUT-m state-state NEW-m tcp-p tcp-dport 8080-j ACCEPT

(Port number 8080, which is the default port for tomcat)

: wq # (press the ESC key first) save and exit editing

Service iptables restart # restart Firewall / etc/init.d/iptables restart

-

Vi / etc/sysconfig/iptables # adds firewall rules for public network access. # press I key to start editing

-An INPUT-m state-state NEW-m tcp-p tcp-dport 3306-j ACCEPT

(3306 is the MySQL port number)

: wq # (press the ESC key first) save and exit editing

Service iptables restart # restart Firewall / etc/init.d/iptables restart

Deploy the wpc knowledge base

The downloaded linux system files are as follows:

1. Database script: wcp2.v3.2.1.none.opensource.sql

2. Program file

3. Copy the above program folder to the webapps directory under tomcat

4. Log in to the mysql database (the database name is arbitrary, but it should be consistent with the jdbc.properties content described later, here the name is: wcp2)

Create the database:

View the database:

Select the data path:

Execute wcp2.v3.2.1.none.opensource.sql script

(the directory is where the script is stored)

Exit the database.

5. Modify the configuration file of the wcp system program file

Jdbc.properties file under the directory

Modify the appropriate information:

6. Modify config.properties files in the directory

7. Restart the tomcat service

Access login test

Http://192.168.1.150:8080/wcp/login/webPage.html; (ip is server ip)

User name: sysadmin

Password: 111111

After logging in:

Download the WCP product deployment manual V3.2.1.docx:

Http://www.wcpdoc.com/webdoc/view/Pub8a2831b3572e7bc501573b5900270006.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report