【Vertica】centos 安装vertica单机详细过程

[root@localhost java]# ls
jdk1.8.0_191  jdk-8u191-linux-x64.tar.gz
[root@localhost java]# vi /etc/profile

export JAVA_HOME=/usr/java/jdk1.8.0_191 

export CLASSPATH=.:%JAVA_HOME%/lib/dt.jar:%JAVA_HOME%/lib/tools.jar

export PATH=$PATH:$JAVA_HOME/bin 

#保留yum包,将/etc/yum.conf里对应的keepcache参数改为1即可
[root@localhost java]#source /etc/profile #使文件立即生效

[root@localhost java]# vim /etc/yum.conf

keepcache=1

[root@localhost java]# cat  /etc/yum.conf
[main]
cachedir=/var/cache/yum/$basearch/$releasever
keepcache=1
debuglevel=2
logfile=/var/log/yum.log
exactarch=1
obsoletes=1
gpgcheck=1
plugins=1
installonly_limit=5
bugtracker_url=http://bugs.centos.org/set_project.php?project_id=23&ref=http://bugs.centos.org/bug_report_page.php?category=yum
distroverpkg=centos-release


#  This is the default, if you make this bigger yum won't see if the metadata
# is newer on the remote and so you'll "gain" the bandwidth of not having to
# download the new metadata and "pay" for it by yum not having correct
# information.
#  It is esp. important, to have correct metadata, for distributions like
# Fedora which don't keep old packages around. If you don't like this checking
# interupting your command line usage, it's much better to have something
# manually check the metadata once an hour (yum-updatesd will do this).
# metadata_expire=90m

# PUT YOUR REPOS HERE OR IN separate files named file.repo
# in /etc/yum.repos.d
[root@localhost java]# jdkroupadd -g 601 verticadba
-bash: jdkroupadd: command not found
[root@localhost java]# groupadd -g 601 verticadba
[root@localhost java]# usermod -g verticadba evancao
[root@localhost java]# yum install gdb –y 
Loaded plugins: fastestmirror
base                                                                                                                                                                                         | 3.6 kB  00:00:00     
extras                                                                                                                                                                                       | 3.4 kB  00:00:00     
updates                                                                                                                                                                                      | 3.4 kB  00:00:00     
Loading mirror speeds from cached hostfile
 * base: mirrors.163.com
 * extras: mirrors.163.com
 * updates: mirrors.cn99.com
Resolving Dependencies
--> Running transaction check
---> Package gdb.x86_64 0:7.6.1-110.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================================================
 Package                                        Arch                                              Version                                                     Repository                                       Size
====================================================================================================================================================================================================================
Installing:
 gdb                                            x86_64                                            7.6.1-110.el7                                               base                                            2.4 M

Transaction Summary
====================================================================================================================================================================================================================
Install  1 Package

Total download size: 2.4 M
Installed size: 7.0 M
Is this ok [y/d/N]: y
Downloading packages:
gdb-7.6.1-110.el7.x86_64.rpm                                                                                                                                                                 | 2.4 MB  00:00:05     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : gdb-7.6.1-110.el7.x86_64                                                                                                                                                                         1/1 
  Verifying  : gdb-7.6.1-110.el7.x86_64                                                                                                                                                                         1/1 

Installed:
  gdb.x86_64 0:7.6.1-110.el7                                                                                                                                                                                        

Complete!
[root@localhost java]# yum install mcelog –y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.163.com
 * extras: mirrors.163.com
 * updates: mirrors.shu.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package mcelog.x86_64 3:144-8.94d853b2ea81.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================================================
 Package                                        Arch                                           Version                                                           Repository                                    Size
====================================================================================================================================================================================================================
Installing:
 mcelog                                         x86_64                                         3:144-8.94d853b2ea81.el7                                          base                                          78 k

Transaction Summary
====================================================================================================================================================================================================================
Install  1 Package

Total download size: 78 k
Installed size: 178 k
Is this ok [y/d/N]: y
Downloading packages:
mcelog-144-8.94d853b2ea81.el7.x86_64.rpm                                                                                                                                                     |  78 kB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : 3:mcelog-144-8.94d853b2ea81.el7.x86_64                                                                                                                                                           1/1 
  Verifying  : 3:mcelog-144-8.94d853b2ea81.el7.x86_64                                                                                                                                                           1/1 

Installed:
  mcelog.x86_64 3:144-8.94d853b2ea81.el7                                                                                                                                                                            

Complete!
[root@localhost java]# yum install sysstat –y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.163.com
 * extras: mirrors.163.com
 * updates: mirrors.shu.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package sysstat.x86_64 0:10.1.5-13.el7 will be installed
--> Processing Dependency: libsensors.so.4()(64bit) for package: sysstat-10.1.5-13.el7.x86_64
--> Running transaction check
---> Package lm_sensors-libs.x86_64 0:3.4.0-4.20160601gitf9185e5.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================================================
 Package                                             Arch                                       Version                                                              Repository                                Size
====================================================================================================================================================================================================================
Installing:
 sysstat                                             x86_64                                     10.1.5-13.el7                                                        base                                     310 k
Installing for dependencies:
 lm_sensors-libs                                     x86_64                                     3.4.0-4.20160601gitf9185e5.el7                                       base                                      41 k

Transaction Summary
====================================================================================================================================================================================================================
Install  1 Package (+1 Dependent package)

Total download size: 352 k
Installed size: 1.2 M
Is this ok [y/d/N]: y
Downloading packages:
(1/2): lm_sensors-libs-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm                                                                                                                             |  41 kB  00:00:00     
(2/2): sysstat-10.1.5-13.el7.x86_64.rpm                                                                                                                                                      | 310 kB  00:00:07     
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                49 kB/s | 352 kB  00:00:07     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : lm_sensors-libs-3.4.0-4.20160601gitf9185e5.el7.x86_64                                                                                                                                            1/2 
  Installing : sysstat-10.1.5-13.el7.x86_64                                                                                                                                                                     2/2 
  Verifying  : sysstat-10.1.5-13.el7.x86_64                                                                                                                                                                     1/2 
  Verifying  : lm_sensors-libs-3.4.0-4.20160601gitf9185e5.el7.x86_64                                                                                                                                            2/2 

Installed:
  sysstat.x86_64 0:10.1.5-13.el7                                                                                                                                                                                    

Dependency Installed:
  lm_sensors-libs.x86_64 0:3.4.0-4.20160601gitf9185e5.el7                                                                                                                                                           

Complete!
[root@localhost java]# yum install ntp –y 
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.163.com
 * extras: mirrors.163.com
 * updates: mirrors.shu.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package ntp.x86_64 0:4.2.6p5-28.el7.centos will be installed
--> Processing Dependency: ntpdate = 4.2.6p5-28.el7.centos for package: ntp-4.2.6p5-28.el7.centos.x86_64
--> Processing Dependency: libopts.so.25()(64bit) for package: ntp-4.2.6p5-28.el7.centos.x86_64
--> Running transaction check
---> Package autogen-libopts.x86_64 0:5.18-5.el7 will be installed
---> Package ntpdate.x86_64 0:4.2.6p5-28.el7.centos will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================================================
 Package                                               Arch                                         Version                                                        Repository                                  Size
====================================================================================================================================================================================================================
Installing:
 ntp                                                   x86_64                                       4.2.6p5-28.el7.centos                                          base                                       549 k
Installing for dependencies:
 autogen-libopts                                       x86_64                                       5.18-5.el7                                                     base                                        66 k
 ntpdate                                               x86_64                                       4.2.6p5-28.el7.centos                                          base                                        86 k

Transaction Summary
====================================================================================================================================================================================================================
Install  1 Package (+2 Dependent packages)

Total download size: 701 k
Installed size: 1.6 M
Is this ok [y/d/N]: y
Downloading packages:
(1/3): autogen-libopts-5.18-5.el7.x86_64.rpm                                                                                                                                                 |  66 kB  00:00:00     
(2/3): ntpdate-4.2.6p5-28.el7.centos.x86_64.rpm                                                                                                                                              |  86 kB  00:00:01     
(3/3): ntp-4.2.6p5-28.el7.centos.x86_64.rpm                                                                                                                                                  | 549 kB  00:00:06     
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                               112 kB/s | 701 kB  00:00:06     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : autogen-libopts-5.18-5.el7.x86_64                                                                                                                                                                1/3 
  Installing : ntpdate-4.2.6p5-28.el7.centos.x86_64                                                                                                                                                             2/3 
  Installing : ntp-4.2.6p5-28.el7.centos.x86_64                                                                                                                                                                 3/3 
  Verifying  : ntpdate-4.2.6p5-28.el7.centos.x86_64                                                                                                                                                             1/3 
  Verifying  : autogen-libopts-5.18-5.el7.x86_64                                                                                                                                                                2/3 
  Verifying  : ntp-4.2.6p5-28.el7.centos.x86_64                                                                                                                                                                 3/3 

Installed:
  ntp.x86_64 0:4.2.6p5-28.el7.centos                                                                                                                                                                                

Dependency Installed:
  autogen-libopts.x86_64 0:5.18-5.el7                                                                     ntpdate.x86_64 0:4.2.6p5-28.el7.centos                                                                    

Complete!
[root@localhost java]# yum install dialog -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.163.com
 * extras: mirrors.163.com
 * updates: mirrors.shu.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package dialog.x86_64 0:1.2-4.20130523.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================================================
 Package                                         Arch                                            Version                                                        Repository                                     Size
====================================================================================================================================================================================================================
Installing:
 dialog                                          x86_64                                          1.2-4.20130523.el7                                             base                                          208 k

Transaction Summary
====================================================================================================================================================================================================================
Install  1 Package

Total download size: 208 k
Installed size: 505 k
Downloading packages:
dialog-1.2-4.20130523.el7.x86_64.rpm                                                                                                                                                         | 208 kB  00:00:13     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : dialog-1.2-4.20130523.el7.x86_64                                                                                                                                                                 1/1 
  Verifying  : dialog-1.2-4.20130523.el7.x86_64                                                                                                                                                                 1/1 

Installed:
  dialog.x86_64 0:1.2-4.20130523.el7                                                                                                                                                                                

Complete!
[root@localhost java]# vim /etc/hosts 

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
127.0.0.1   vertica_server

[root@localhost java]# systemctl restart ntpd
[root@localhost java]# vim /etc/hosts 
[root@localhost java]# systemctl stop firewalld
[root@localhost java]# vim /etc/selinux/config


# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three two values:
#     targeted - Targeted processes are protected,
#     minimum - Modification of targeted policy. Only selected processes are protected. 
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted
[root@localhost java]# setenforce 0
[root@localhost java]# vim /etc/pam.d/su

#%PAM-1.0
auth            sufficient      pam_rootok.so
# Uncomment the following line to implicitly trust users in the "wheel" group.
#auth           sufficient      pam_wheel.so trust use_uid
# Uncomment the following line to require a user to be in the "wheel" group.
#auth           required        pam_wheel.so use_uid
auth            substack        system-auth
auth            include         postlogin
account         sufficient      pam_succeed_if.so uid = 0 use_uid quiet
account         include         system-auth
password        include         system-auth
session         include         system-auth
session         include         postlogin
session         optional        pam_xauth.so
session         required        pam_limits.so #加入这行

[root@localhost java]# cd /sys/block/
[root@localhost block]# ls
dm-0  dm-1  dm-2  sda  sr0
[root@localhost block]# echo deadline > /sys/block/sda/queue/scheduler 
[root@localhost block]# cat /sys/block/sda/queue/scheduler 
noop [deadline] cfq 
[root@localhost block]#  echo '/sbin/blockdev --setra 2048 /dev/sda' >> /etc/rc.local
[root@localhost block]# vim /etc/grub.conf
[root@localhost block]# cd /etc/gr
groff/     group      group-     grub2.cfg  grub.d/    
[root@localhost block]# vim /etc/grub.conf

transparent_hugepage=never

[root@localhost block]# echo always > /sys/kernel/mm/transparent_hugepage/enabled
[root@localhost block]# source /etc/profile
[root@localhost block]# vim  /home/evancao/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH


export.UTF-8      #添加
export TZ="Asia/Shanghai"    #添加


[root@localhost block]# su - evancao
[evancao@localhost ~]$ ls
[evancao@localhost ~]$ mkdir install
[evancao@localhost ~]$ ls
install
[evancao@localhost ~]$ pwd
/home/evancao
[evancao@localhost ~]$ cd install
[evancao@localhost install]$ ls
[evancao@localhost install]$ pwd
/home/evancao/install
[evancao@localhost install]$ ls
dialog-1.1-9.20080819.1.el6.x86_64.rpm  nmon  vertica-9.1.0-0.x86_64.RHEL6.rpm  vertica-console-9.1.0-1.x86_64.RHEL6.rpm
[evancao@localhost install]$ rpm  -Uvh /home/evancao/install/vertica-9.1.0-0.x86_64.RHEL6.rpm 
error: can't create transaction lock on /var/lib/rpm/.rpm.lock (Permission denied)
[evancao@localhost install]$ su - root
Password: 
Last login: Sat Oct 20 17:00:36 CST 2018 from 192.168.187.1 on pts/0
[root@localhost ~]# rpm  -Uvh /home/evancao/install/vertica-9.1.0-0.x86_64.RHEL6.rpm 
Preparing...                          ################################# [100%]
Updating / installing...
   1:vertica-9.1.0-0                  ################################# [100%]

Vertica Analytic Database V9.1.0-0 successfully installed on host localhost.localdomain

To complete your NEW installation and configure the cluster, run: 
 /opt/vertica/sbin/install_vertica

To complete your Vertica UPGRADE, run:
 /opt/vertica/sbin/update_vertica

---------------------------------------------------------------------------------- 
Important
---------------------------------------------------------------------------------- 
Before upgrading Vertica, you must backup your database.  After you restart your   
database after upgrading, you cannot revert to a previous Vertica software version.
---------------------------------------------------------------------------------- 

View the latest Vertica documentation at http://my.vertica.com/docs/
[root@localhost ~]# /opt/vertica/sbin/install_vertica -s vertica_server -r "/home/evancao/install/vertica-9.1.0-0.x86_64.RHEL6.rpm" -u evancao
Vertica Analytic Database 9.1.0-0 Installation Tool


>> Validating options...


Mapping hostnames in --hosts (-s) to addresses...
vertica_server                 => 127.0.0.1

>> Starting installation tasks.
>> Getting system information for cluster (this may take a while)...

Default shell on nodes:
127.0.0.1 /bin/bash

>> Validating software versions (rpm or deb)...


>> Beginning new cluster creation...

successfully backed up admintools.conf on 127.0.0.1 

>> Creating or validating DB Admin user/group...

Successful on hosts (1): 127.0.0.1
    Provided DB Admin account details: user = evancao, group = verticadba, home = /home/evancao
    Creating group... Group already exists
    Validating group... Okay
    Creating user... User already exists
    Validating user... Okay


>> Validating node and cluster prerequisites...

Prerequisites not fully met during local (OS) configuration for
verify-127.0.0.1.xml:
    WARN (S0112): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0112
        vm.swappiness is higher than recommended: your 30 > 1

System prerequisites failed.  Threshold = WARN
Hint: Fix above failures or use --failure-threshold

Installation FAILED with errors.

****
AdminTools and your existing Vertica databases may be unavailable.
Investigate the above warnings/errors and re-run installation.
****
[root@localhost ~]# echo 1 > /proc/sys/vm/swappiness
[root@localhost ~]# cat /proc/sys/vm/swappiness
1
[root@localhost ~]# /opt/vertica/sbin/install_vertica -s vertica_server -r "/home/evancao/install/vertica-9.1.0-0.x86_64.RHEL6.rpm" -u evancao
Vertica Analytic Database 9.1.0-0 Installation Tool


>> Validating options...


Mapping hostnames in --hosts (-s) to addresses...
vertica_server                 => 127.0.0.1

>> Starting installation tasks.
>> Getting system information for cluster (this may take a while)...

Default shell on nodes:
127.0.0.1 /bin/bash

>> Validating software versions (rpm or deb)...


>> Beginning new cluster creation...

successfully backed up admintools.conf on 127.0.0.1 

>> Creating or validating DB Admin user/group...

Successful on hosts (1): 127.0.0.1
    Provided DB Admin account details: user = evancao, group = verticadba, home = /home/evancao
    Creating group... Group already exists
    Validating group... Okay
    Creating user... User already exists
    Validating user... Okay


>> Validating node and cluster prerequisites...

System prerequisites passed.  Threshold = WARN


>> Establishing DB Admin SSH connectivity...

Installing/Repairing SSH keys for evancao


>> Setting up each node and modifying cluster...

Creating Vertica Data Directory...

Updating agent...
Creating node node0001 definition for host 127.0.0.1
... Done

>> Sending new cluster configuration to all nodes...

Starting agent...

>> Completing installation...

Running upgrade logic
No spread upgrade required: /opt/vertica/config/vspread.conf not found on any node
Installation complete.

Please evaluate your hardware using Vertica's validation tools:
    https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=VALSCRIPT

To create a database:
  1. Logout and login as evancao. (see note below)
  2. Run /opt/vertica/bin/adminTools as evancao
  3. Select Create Database from the Configuration Menu

  Note: Installation may have made configuration changes to evancao
  that do not take effect until the next session (logout and login).

To add or remove hosts, select Cluster Management from the Advanced Menu.
[root@localhost ~]# rpm -Uvh /home/evancao/install/vertica-console-9.1.0-1.x86_64.RHEL6.rpm 
Preparing...                          ################################# [100%]
[preinstall] Starting installation....
Updating / installing...
   1:vertica-console-9.1.0-1          ################################# [100%]
[postinstall] copy vertica-consoled
[postinstall] configure the daemon service
Cleaning up temp folder...
Starting the vertica management console....
Vertica Console: 2018-10-20 17:50:52.850:INFO:cv.Startup:Attempting to load properties from /opt/vconsole/config/console.properties
2018-10-20 17:50:52.851:INFO:cv.Startup:Starting Server...
2018-10-20 17:50:52.870:WARN:oejs.AbstractConnector:Acceptors should be <=2*availableProcessors: SslSelectChannelConnector@0.0.0.0:5450 STOPPED
2018-10-20 17:50:52.900:INFO:cv.Startup:starting monitor thread
2018-10-20 17:50:52.904:INFO:oejs.Server:jetty-7.x.y-SNAPSHOT
2018-10-20 17:50:52.930:INFO:oejw.WebInfConfiguration:Extract jar:file:/opt/vconsole/lib/webui.war!/ to /opt/vconsole/temp/webapp
2018-10-20 17:50:58.737:INFO:/webui:Set web app root system property: 'webapp.root' = [/opt/vconsole/temp/webapp]
2018-10-20 17:50:58.762:INFO:/webui:Initializing log4j from [classpath:log4j.xml]
2018-10-20 17:50:58.777:INFO:/webui:Initializing Spring root WebApplicationContext
---- Upgrading /opt/vconsole/config/console.properties ----


************************************************************************************************************

Please open the Vertica Management Console at https://localhost.localdomain:5450/webui

************************************************************************************************************


2018-10-20 17:51:18.253:INFO:oejsh.ContextHandler:started o.e.j.w.WebAppContext{/webui,file:/opt/vconsole/temp/webapp/},file:/opt/vconsole/lib/webui.war
2018-10-20 17:51:18.300:INFO:/webui:Initializing Spring FrameworkServlet 'appServlet'
2018-10-20 17:51:20.023:INFO:oejdp.ScanningAppProvider:Deployment monitor /opt/vconsole/webapps at interval 2
2018-10-20 17:51:20.054:INFO:oejhs.SslContextFactory:Enabled Protocols [SSLv2Hello, TLSv1, TLSv1.1, TLSv1.2] of [SSLv2Hello, SSLv3, TLSv1, TLSv1.1, TLSv1.2]
2018-10-20 17:51:20.071:INFO:oejs.AbstractConnector:Started SslSelectChannelConnector@0.0.0.0:5450 STARTING
start OK
[postinstall] Changing permissions of /opt/vconsole        [  OK  ]


[evancao@localhost ~]$ /opt/vertica/bin/admintools

# 中间设置没有截图

Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

Vertica_TEST=> CREATE USER vertica IDENTIFIED BY 'vertica';
ROLLBACK 4923:  That password is not acceptable
DETAIL:  The password may not be the same as the user name
Vertica_TEST=> CREATE USER vertica IDENTIFIED BY 'vertica123';
CREATE USER
Vertica_TEST=> CREATE SCHEMA ms;
CREATE SCHEMA
Vertica_TEST=> GRANT ALL ON schema ms TO vertica;
GRANT PRIVILEGE
Vertica_TEST=>\q


[evancao@localhost ~]$ systemctl start vertica-consoled
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to manage system services or units.
Authenticating as: evancao
Password: 
==== AUTHENTICATION COMPLETE ===
Job for vertica-consoled.service failed because the control process exited with error code. See "systemctl status vertica-consoled.service" and "journalctl -xe" for details.
[evancao@localhost ~]$ su - root
Password: 
Last login: Sat Oct 20 17:44:54 CST 2018 on pts/0
[root@localhost ~]# systemctl enable firewalld
[root@localhost ~]# sudo firewall-cmd --permanent --add-port=5450/tcp
FirewallD is not running
[root@localhost ~]# systemctl start firewalld
[root@localhost ~]# sudo firewall-cmd --permanent --add-port=5450/tcp
success
[root@localhost ~]# sudo firewall-cmd --permanent --add-port=5433/tcp
success
[root@localhost ~]# sudo firewall-cmd --reload
success
[root@localhost ~]# sudo firewall-cmd --list-all
public (active)
  target: default
  icmp-block-inversion: no
  interfaces: ens33
  sources: 
  services: ssh dhcpv6-client
  ports: 5450/tcp 5433/tcp
  protocols: 
  masquerade: no
  forward-ports: 
  source-ports: 
  icmp-blocks: 
  rich rules: 

[root@localhost ~]#


发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

Powered By Z-BlogPHP 1.5.2 Zero

粤ICP备18035038号