CentOS实操

2015-06-30 11:58 wuji1626 阅读(1014) 评论(0) 收藏举报

1 Root密码：zwh587587

普通用户：zhangwh 密码：*******

2 安装Oracle

1）安装依赖包

yum install libaio mksh unixODBC unixODBC-devel libstdc++ libstdc++-devel libgcc

运行结果：

binutils-2.20.51.0.2-5.28.el6.x86_64

package compat-libstdc++-33 is not installed

elfutils-libelf-0.152-1.el6.x86_64

elfutils-libelf-devel-0.152-1.el6.x86_64

gcc-4.4.6-3.el6.x86_64

gcc-c++-4.4.6-3.el6.x86_64

glibc-2.12-1.47.el6.x86_64

glibc-common-2.12-1.47.el6.x86_64

glibc-devel-2.12-1.47.el6.x86_64

libaio-0.3.107-10.el6.x86_64

package libaio-devel is not installed

libgcc-4.4.6-3.el6.x86_64

libstdc++-4.4.6-3.el6.x86_64

libstdc++-devel-4.4.6-3.el6.x86_64

make-3.81-19.el6.x86_64

sysstat-9.0.4-18.el6.x86_64

package vixie-cron is not installed

package unixODBC is not installed

package unixODBC-devel is not installed

glibc-headers-2.12-1.47.el6.x86_64

2）创建Oracle用户和组

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba -d /home/oracle oracle

passwd oracle //更改用户密码，密码：orapass

mkdir -p /home/oracle

chown -R oracle:oinstall /home/oracle

chmod -R 775 /home/oracle

3）修改系统配置 vi /etc/sysctl.conf

# Controls the maximum shared segment size, in bytes

kernel.shmmax = 2147483648

# Controls the maximum number of shared memory segments, in pages

kernel.shmall = 2097152

kernel.shmmni=4096

kernel.sem=250 32000 100 128

net.core.rmem_default=4194304

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max = 262144

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

让内核生效：sysctl -p

4）为oracle用户设置shell限制

vi /etc/security/limits.conf

添加：

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

5）修改 /etc/profile

vi /etc/profile
#添加以下内容：
if [ $USER = "oracle" ]; then
   if [ $SHELL = "/bin/ksh" ]; then
      ulimit -p 16384
      ulimit -n 65536
   else
      ulimit -u 16384 -n 65536
   fi
fi

6）修改 /etc/csh.login

vi /etc/csh.login
#添加以下内容:
if ( $USER == "oracle" ) then
limit maxproc 16384
limit deors 65536
endif

7）vi /etc/pam.d/login 中，如果没有以下代码添加上以下代码：

session required /lib/security/pam_limits.so

session required pam_limits.so

8）选择开启还是关闭SELINUX的工作模式

vi /etc/selinux/config

设置SELINUX为disabled

SELINUX=disabled

9）修改系统发行版本，因为Oracle并没有推出CentOS系统版本

vi /etc/redhat-release

将CentOS release 6.2 (Final) 改成 Red Hat Enterprise Linux AS release 5 (Taroon)

10）将用户su成oracle

修改.bash_profile ，该文件即为oracle用户的环境变量 vi .bash_profile

追加以下内容

ORACLE_BASE=/home/oracle/app; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/oracle; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID

PATH=$ORACLE_HOME/bin:$PATH; export PATH

使更改生效：

source .bash_profile

11）退出oracle用户切换到root

xhost + 确保窗口正常显示

12）到database目录下执行 ./runInstaller 进入安装画面

数据库安装地址：

【注】当出现： No protocol specified Exception in thread "main" java.lang.NoClass错误时，很可能是 .bash_profile环境变量没有设置正确造成

调整环境变量后，重新尝试./runInstaller

数据库所有用户SYS、SYSTEM、SYSMAN、DBSNMP密码均为：zwh587587LD

3 安装Telnet

1）首先判断是否已经有telnet服务

rpm –qa |grep telnet

2）在安装光盘中，Package目录下

·在安装telnet服务之前需要安装 xinetd，输入root密码后即可安装成功

·在光盘中安装telnet-server和telnet软件

3）以root身份登录，修改配置文件

·vi /etc/xinetd.d/telnet 中

        service telnet
        {
           ...
           disable       = yes
        }

将disable设为no

·vi /etc/pam.d/remote

将auth required pam_securetty.so行注释掉

·配置防火墙端口

查看防火墙状态 /etc/init.d/iptables status

可以直接关闭防火墙 /etc/init.d/iptables stop

·重启telnet服务

service xinetd restart

·开启23端口：

vi /etc/sysconfig/iptables

在COMMIT之前添加：

-A INPUT -p tcp --dport 23 -j ACCEPT

然后保存

或者执行：

/sbin/iptables -I INPUT -p tcp --dport 22 -j ACCEPT

/etc/rc.d/init.d/iptables save

重启防火墙

·telnet服务

·在CentOS光盘中的Package中选择进行安装：

telnet-0.17-47.el6.x86_64.rpm

telnet-server-0.17-47.el6.x86_64.rpm

·以root权限执行ntsysv命令，在弹出窗口中直接勾选telnet

·激活telnet服务，只需重启xinetd服务

service xinetd restart

在安装telnet时，rpm -ivh telnet-server-0.17-35.i386.rpm

warning: telnet-server-0.17-35.i386.rpm: Header V3 DSA signature: NOKEY,4f2a6fd2
error: Failed dependencies:
xinetd is needed by telnet-server-0.17-35.i386

解决方法：

1、先安装xinetd包

rpm -ivh xinetd-2.3.14-10.el5.x86_64.rpm
此rpm包在光盘介质中可以找到。

2、再安装telnet包

rpm -ivh telnet-server-0.17-35.i386.rpm

3、启动xinetd服务

service xinetd start

总之，需要先安装xinetd包即可。

4. 现在可以安装我们需要的rpm包了

rpm -ivh telnet-server-0.17-35.i386.rpm

4 FTP服务

1）yum install vsftpd

2）重启vsftpd：

service vsftpd restart

3）添加用户

·修改vi /etc/vsftpd/vsftpd.conf

#chroot_list_enable=YES

# (default follows)

#chroot_list_file=/etc/vsftpd/chroot_list

改为：

chroot_list_enable=YES

# (default follows)

chroot_list_file=/tmp/ftpuser

·增加用户ftpuser，指向目录/tmp/ftpuser,禁止登录SSH权限。

useradd -d /tmp/ftpuser -g ftp -s /sbin/nologin ftpuser

·修改ftpuser密码

passwd ftpuser

·输入新密码：zwh587587

·编辑文件chroot_list:

vi /etc/vsftpd/chroot_list 内容为ftp用户名,每个用户占一行

·重新启动vsftpd service vsftpd restart

【问题解决】[右] PASS (hidden)

[右] 500 OOPS: cannot change directory:/tmp/ftpuser

a）首先通过getsebool -a | grep ftp 查看ftp的配置：

allow_ftpd_anon_write --> off

allow_ftpd_full_access --> off

allow_ftpd_use_cifs --> off

allow_ftpd_use_nfs --> off

ftp_home_dir --> off

ftpd_connect_db --> off

httpd_enable_ftp_server --> off

tftp_anon_write --> off

[root@bogon tmp]# setsebool -P ftp_home_dir on

[root@bogon tmp]# getsebool -a | grep ftp

allow_ftpd_anon_write --> off

allow_ftpd_full_access --> off

allow_ftpd_use_cifs --> off

allow_ftpd_use_nfs --> off

ftp_home_dir --> on

ftpd_connect_db --> off

httpd_enable_ftp_server --> off

tftp_anon_write --> off

b）其中ftp_home_dir --> off

通过命令setsebool -P ftp_home_dir on，将ftp_home_dir设置为on

[root@bogon tmp]# getsebool -a | grep ftp

allow_ftpd_anon_write --> off

allow_ftpd_full_access --> off

allow_ftpd_use_cifs --> off

allow_ftpd_use_nfs --> off

ftp_home_dir --> on

ftpd_connect_db --> off

httpd_enable_ftp_server --> off

tftp_anon_write --> off

c）再通过ftp客户端即可访问

5 安装JDK

1）下载

http://www.oracle.com/technetwork/cn/java/javase/downloads/jdk7-downloads-1880260-zhs.html

2）解压并拷贝至/opt目录下

tar -zxvf jdk-7u15-linux-x64.tar.gz

mv jdk1.7.0_15/ /opt

3）修改环境变量：

vi /etc/profile

·在文件最后追加：

JAVA_HOME=/opt/jdk1.7.0_15

PATH=$JAVA_HOME/bin:$PATH

CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar

export JAVA_HOME

export PATH

export CLASSPATH

·检验jdk是否配置成功：

java -version

java version "1.7.0_15"

Java(TM) SE Runtime Environment (build 1.7.0_15-b03)

Java HotSpot(TM) 64-Bit Server VM (build 23.7-b01, mixed mode)

·令profile生效：source /etc/profile

6 Maven准备

1）下载Maven：http://mirror.bit.edu.cn/apache/maven/maven-3/3.1.1/binaries/apache-maven-3.1.1-bin.zip

2）配置环境变量

vi /etc/profie

export MAVEN_HOME=/opt/maven3.1.1

export PATH=$PATH:$MAVEN_HOME/bin

3）检验maven配置：

mvn -version

Apache Maven 3.1.1 (0728685237757ffbf44136acec0402957f723d9a; 2013-09-17 08:22:22-0700)

Maven home: /opt/maven3.1.1

Java version: 1.7.0_15, vendor: Oracle Corporation

Java home: /opt/jdk1.7.0_15/jre

Default locale: en_US, platform encoding: UTF-8

OS name: "linux", version: "2.6.32-220.el6.x86_64", arch: "amd64", fami

7 Python2.7安装

1）通过ftp将下载的Python-2.7.3.tar.bz2上传至/tmp/ftpuser目录下

2）拷贝到/opt目录下：mv Python-2.7.3.tar.bz2 /opt

3）解压：tar -jxvf Python-2.7.3.tar.bz2

4）到解压后的目录下：cd Python-2.7.3

5）编译：

□./configure

□make

□make install

6）查看Python的版本号：python -V

8 查看系统中的用户：cut -d : -f 1 /etc/passwd

9 Linux 开机提示kernel panic - not syncing: Attempted to kill init!

主要由于修改Selinux的错误造成的，需要重装系统

10 修改计算机名

vi /etc/sysconfig/network

修改hostname=你要改的名字

11 安装DB2 Express

1）解压DB2

tar zxvf db2_v101_linuxx64_expc.tar.gz

2）安装

cd expc

./db2_install

WARNING:

The 32 bit library file libstdc++.so.6 is not found on the system.

32-bit applications may be affected.

Default directory for installation of products - /opt/ibm/db2/V9.7

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

Do you want to choose a different directory to install [yes/no] ?

WARNING:

The 32 bit library file libstdc++.so.6 is not found on the system.

32-bit applications may be affected.

DB2 installation is being initialized.

Total number of tasks to be performed: 36

Total estimated time for all tasks to be performed: 1302

Task #1 start

Description: Checking license agreement acceptance

Estimated time 1 second(s)

Task #1 end

Task #2 start

Description: Base Client Support for installation with root privileges

Estimated time 3 second(s)

Task #2 end

Task #3 start

Description: Product Messages - English

Estimated time 12 second(s)

Task #3 end

Task #4 start

Description: Base client support

Estimated time 176 second(s)

Task #4 end

Task #5 start

Description: Java Runtime Support

Estimated time 109 second(s)

Task #5 end

Task #6 start

Description: Java Help (HTML) - English

Estimated time 7 second(s)

Task #6 end

Task #7 start

Description: Base server support for installation with root privileges

Estimated time 7 second(s)

Task #7 end

Task #8 start

Description: Integrated Flash Copy Support

Estimated time 53 second(s)

Task #8 end

Task #9 start

Description: Global Secure ToolKit

Estimated time 29 second(s)

Task #9 end

Task #10 start

Description: Java support

Estimated time 11 second(s)

Task #10 end

Task #11 start

Description: SQL procedures

Estimated time 3 second(s)

Task #11 end

Task #12 start

Description: ICU Utilities

Estimated time 46 second(s)

Task #12 end

Task #13 start

Description: Java Common files

Estimated time 20 second(s)

Task #13 end

Task #14 start

Description: Base server support

Estimated time 230 second(s)

Task #14 end

Task #15 start

Description: Control Center Help (HTML) - English

Estimated time 13 second(s)

Task #15 end

Task #16 start

Description: Communication support - TCP/IP

Estimated time 3 second(s)

Task #16 end

Task #17 start

Description: Control Center

Estimated time 41 second(s)

Task #17 end

Task #18 start

Description: DB2 data source support

Estimated time 6 second(s)

Task #18 end

Task #19 start

Description: DB2 LDAP support

Estimated time 4 second(s)

Task #19 end

Task #20 start

Description: DB2 Instance Setup wizard

Estimated time 8 second(s)

Task #20 end

Task #21 start

Description: Base application development tools

Estimated time 33 second(s)

Task #21 end

Task #22 start

Description: DB2 Update Service

Estimated time 4 second(s)

Task #22 end

Task #23 start

Description: First Steps

Estimated time 3 second(s)

Task #23 end

Task #24 start

Description: Product Signature for DB2 Express-C

Estimated time 3 second(s)

Task #24 end

Task #25 start

Description: Sample database source

Estimated time 4 second(s)

Task #25 end

Task #26 start

Description: DB2 Text Search

Estimated time 198 second(s)

Task #26 end

Task #27 start

Description: Setting DB2 library path

Estimated time 180 second(s)

Task #27 end

Task #28 start

Description: Executing control tasks

Estimated time 20 second(s)

Task #28 end

Task #29 start

Description: Updating global registry

Estimated time 20 second(s)

Task #29 end

Task #30 start

Description: Starting DB2 Fault Monitor

Estimated time 10 second(s)

Task #30 end

Task #31 start

Description: Updating the db2ls link

Estimated time 1 second(s)

Task #31 end

Task #32 start

Description: Registering DB2 licenses

Estimated time 5 second(s)

Task #32 end

Task #33 start

Description: Setting default global profile registry variables

Estimated time 1 second(s)

Task #33 end

Task #34 start

Description: Initializing instance list

Estimated time 5 second(s)

Task #34 end

Task #35 start

Description: Registering DB2 Update Service

Estimated time 30 second(s)

Task #35 end

Task #36 start

Description: Updating global profile registry

Estimated time 3 second(s)

Task #36 end

The execution completed successfully.

For more information see the DB2 installation log at

3）配置DB2

#创建用户组和用户

groupadd -g 2000 db2iadm1

useradd -m -g db2iadm1 -d /home/db2inst1 db2inst1

公司：useradd -m -g db2iadm1 -d /home/saic_bzk saic_bzk

passwd db2inst1

公司：passwd saic_bzk

>zwh587587

公司：>saic_bzk

#创建实例

/opt/ibm/db2/V9.7/instance/db2icrt -a server -u db2inst1 db2inst1

公司：/opt/ibm/db2/V9.7/instance/db2icrt -a server -u saic_bzk saic_bzk

DBI1070I Program db2icrt completed successfully.

#可选择加入IBM DB2产品许可证

#允许SMS多页分配

/opt/ibm/db2/V9.7/cfg/db2ln

#添加DB2端口

在文件 /etc/services 加入下面一行

db2inst 50000/tcp

#DB2 配置

su db2inst1

以下命令都由db2inst1执行：

$ db2set DB2_EXTENDED_OPTIMIZATION=ON
$ db2set DB2_DISABLE_FLUSH_LOG=ON
$ db2set AUTOSTART=YES
$ db2set DB2_STRIPED_CONTAINERS=ON
$ db2set DB2_HASH_JOIN=Y
$ db2set DB2COMM=tcpip
$ db2set DB2_PARALLEL_IO=*
$ db2set DB2CODEPAGE=819 #Update dbm cfg
#TCP/IP Service name
$ db2 update dbm cfg using SVCENAME db2inst

公司：db2 update dbm cfg using SVCENAME saic_bzk
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

$ db2 update dbm cfg using INDEXREC ACCESS
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

#运行DB2
必须先运行DB2才能创建数据库，否则报如下错误
SQL1032N No start database manager command was issued. SQLSTATE=57019
$ db2start
SQL1063N DB2START processing was successful.

#创建库

$ db2 "CREATE DATABASE DCDDB1 ALIAS DCDDB1 USING CODESET UTF-8 TERRITORY US"

公司：db2 "CREATE DATABASE SAIC ALIAS SAIC USING CODESET UTF-8 TERRITORY US"
DB20000I The CREATE DATABASE command completed successfully.

$ db2 connect to DCDDB1

公司：db2 connect to SAIC

[db2inst1@master ~]$ db2 connect to DCDDB1

Database Connection Information

Database server = DB2/LINUXX8664 9.7.0

SQL authorization ID = DB2INST1

Local database alias = DCDDB1

$ db2 "CREATE table mytable ( col1 INTEGER NOT NULL, col2 VARCHAR(40), col3 DECIMAL(9,2))"
DB20000I The SQL command completed successfully.

$ db2 "SELECT * FROM mytable FETCH FIRST 10 ROWS ONLY"

COL1 COL2 COL3

----------- ---------------------------------------- -----------

0 record(s) selected.

停止服务

$db2stop force

DB2企业版：

1）解压：tar zxvf db2_v101_linuxx64_expc.tar.gz

2）cd server/

3）./db2_install

4）选择默认安装路径

Default directory for installation of products - /opt/ibm/db2/V9.7

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

Do you want to choose a different directory to install [yes/no] ?

5）选择安装产品：ESE企业服务器版

供选择的选项：

AESE ：高级企业服务器版(Advanced enterprise server edition)

ESE ：ESE:企业服务器版(enterprise server edition)

CONSV :CONSV:连接服务器版( connect server edition)

WSE :WSE: 工作组服务器版(workgroup server edition)

EXP EXP:易捷版(express edition)

PE :PE:个人版(personal edition)

CLIENT：CLIENT:数据库服务器客户机

RTCL ：RTCL:数据库服务器运行时客户机( runtime client)

6）安装过程中报错，据说不影响使用

A minor error occurred while installing "DB2 Enterprise Server Edition " on

this computer. Some features may not function correctly.

Resolving the problem

This DBI1130E error message is related to the Tivoli Systems Automation (TSA) and this is not a component that affects core DB2 functionality, as it deals with some of the more advanced High Availability features of DB2. In essence, it handles DB2's fail-over from one machine to another. If the TSA component is not going to be used, the error message can be safely ignored.

由于不使用Tivoli组件，因此暂时忽略

7）配置DB2

#创建用户组和用户

groupadd -g 2000 db2iadm1

useradd -m -g db2iadm1 -d /home/db2inst1 db2inst1

公司：useradd -m -g db2iadm1 -d /home/saic_bzk saic_bzk

passwd db2inst1

公司：passwd saic_bzk

>zwh587587

公司：>saic_bzk

#创建实例

/opt/ibm/db2/V9.7/instance/db2icrt -a server -u db2inst1 db2inst1

公司：/opt/ibm/db2/V9.7/instance/db2icrt -a server -u saic_bzk saic_bzk

/opt/ibm/db2/V9.7/instance/db2icrt -a server -p 50000 -u saic_bzk saic_bzk

DBI1070I Program db2icrt completed successfully.

#可选择加入IBM DB2产品许可证

/opt/ibm/db2/V9.7/adm/db2licm -a /tmp/db2ese_c_97.lic

LIC1402I License added successfully.

LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V9.7/license/en_US.iso88591"

#允许SMS多页分配

/opt/ibm/db2/V9.7/cfg/db2ln

#添加DB2端口

在文件 /etc/services 加入下面一行

db2inst 50000/tcp

公司：saic_bzk 50000/tcp

#DB2 配置

su db2inst1

公司：su saic_bzk

以下命令都由db2inst1执行：

#Update dbm cfg
#TCP/IP Service name
$ db2 update dbm cfg using SVCENAME db2inst

公司：db2 update dbm cfg using SVCENAME saic_bzk
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

$ db2 update dbm cfg using INDEXREC ACCESS
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

#创建库

$ db2 "CREATE DATABASE DCDDB1 ALIAS DCDDB1 USING CODESET UTF-8 TERRITORY US"

公司：db2 "CREATE DATABASE S_SAIC ALIAS S_SAIC USING CODESET UTF-8 TERRITORY US"
DB20000I The CREATE DATABASE command completed successfully.

$ db2 connect to DCDDB1

公司：db2 connect to SAIC

[db2inst1@master ~]$ db2 connect to DCDDB1

Database Connection Information

Database server = DB2/LINUXX8664 9.7.0

SQL authorization ID = DB2INST1

Local database alias = DCDDB1

$ db2 "CREATE table mytable ( col1 INTEGER NOT NULL, col2 VARCHAR(40), col3 DECIMAL(9,2))"
DB20000I The SQL command completed successfully.

$ db2 "SELECT * FROM mytable FETCH FIRST 10 ROWS ONLY"

COL1 COL2 COL3

----------- ---------------------------------------- -----------

0 record(s) selected.

Database server = DB2/LINUXX8664 9.7.7

SQL authorization ID = DB2INST1

Local database alias = SAIC

停止服务

$db2stop force

查看db2 50000端口是否开启：

netstat -an |grep 50000

删除实例：

1.使用root用户登录，进入到DB2安装目录

[root@localhost instance]# pwd

/opt/ibm/db2/V9.7/instance

2.执行db2idrop命令删除
[root@localhost instance]# ./db2idrop db2inst1

./db2idrop saic_bzk

DBI1070I Program db2idrop completed successfully.

db2ilist ---列出主机所有实例

db2icrt instanceName ---创建实例名为instanceName的实例

db2idrop instanceName ---删除实例名为instanceName的实例

■创建das用户：

groupadd -g 903 db2agrp

useradd -g db2agrp -u 803 -d /home/db2das -m -s /bin/sh db2das

passwd db2das

在/opt/ibm/db2/V9.7/instance路径下建立：./dascrt -u db2das

cd /opt/ibm/db2/V9.7/das/bin

./db2admin start

■TRS配置DB2数据源

以saic_bzk用户

./db2 CATALOG TCPIP NODE db2inst REMOTE 192.168.196.224 SERVER 50001

./db2 CATALOG DB SAIC AT NODE db2inst

./db2 TERMINATE

查看

./db2 list node directory

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = DB2INST

Comment =

Directory entry type = LOCAL

Protocol = TCPIP

Hostname = 192.168.196.224

Service name = 50001

连接：

./db2

connect to saic user db2inst1 using db2inst1

将一下配置写到TRS的startup.sh中：

export DB2DIR= /opt/ibm/db2/V9.7

export DB2INSTANCE=db2inst1

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/ibm/db2/V9.7/lib64

重启网关服务

./db2 catalog tcpip node db2inst remote 192.168.196.226 server 50000

./db2 catalog db S_SAIC at node db2inst

./db2 terminate

./db2 catalog tcpip node db2inst remote 192.168.196.224 server 50001

./db2 catalog db SAIC at node db2inst

./db2 terminate

删除db2连接：

./db2 uncatalog node db2inst

12 安装MySQL数据库

□yum安装MySQL

1）查看服务器上的mysql数据库的可用版本：yum list | grep mysql

[root@bogon /]# yum list | grep mysql

http://centos.ustc.edu.cn/centos/6.5/os/x86_64/repodata/617a880b84a87969e04bfeebb1b96d5f441da42ee931d374fa6b6d57decd821e-primary.sqlite.bz2: [Errno 14] PYCURL ERROR 7 - "couldn't connect to host"

Trying other mirror.

mysql-libs.x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5

apr-util-mysql.x86_64 1.3.9-3.el6_0.1 base

bacula-director-mysql.x86_64 5.0.0-12.el6 base

bacula-storage-mysql.x86_64 5.0.0-12.el6 base

dovecot-mysql.x86_64 1:2.0.9-7.el6 base

freeradius-mysql.x86_64 2.1.12-4.el6_3 base

libdbi-dbd-mysql.x86_64 0.8.3-5.1.el6 base

mod_auth_mysql.x86_64 1:3.0.0-11.el6_0.1 base

mysql.x86_64 5.1.73-3.el6_5 updates

mysql-bench.x86_64 5.1.73-3.el6_5 updates

mysql-connector-java.noarch 1:5.1.17-6.el6 base

mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 base

mysql-devel.i686 5.1.73-3.el6_5 updates

mysql-devel.x86_64 5.1.73-3.el6_5 updates

mysql-embedded.i686 5.1.73-3.el6_5 updates

mysql-embedded.x86_64 5.1.73-3.el6_5 updates

mysql-embedded-devel.i686 5.1.73-3.el6_5 updates

mysql-embedded-devel.x86_64 5.1.73-3.el6_5 updates

mysql-libs.i686 5.1.73-3.el6_5 updates

mysql-libs.x86_64 5.1.73-3.el6_5 updates

mysql-server.x86_64 5.1.73-3.el6_5 updates

mysql-test.x86_64 5.1.73-3.el6_5 updates

php-mysql.x86_64 5.3.3-27.el6_5 updates

qt-mysql.i686 1:4.6.2-28.el6_5 updates

qt-mysql.x86_64 1:4.6.2-28.el6_5 updates

rsyslog-mysql.x86_64 5.8.10-8.el6 base

2）下载mysql相关的客户端：yum install -y mysql-server mysql mysql-deve

3）查看mysql的版本:rpm -qi mysql-server

[root@bogon /]# rpm -qi mysql-server

Name : mysql-server Relocations: (not relocatable)

Version : 5.1.73 Vendor: CentOS

Release : 3.el6_5 Build Date: Wed 12 Feb 2014 11:42:39 AM PST

Install Date: Sun 13 Apr 2014 02:04:27 AM PDT Build Host: c6b9.bsys.dev.centos.org

Group : Applications/Databases Source RPM: mysql-5.1.73-3.el6_5.src.rpm

Size : 25882723 License: GPLv2 with exceptions

Signature : RSA/SHA1, Wed 12 Feb 2014 11:48:08 AM PST, Key ID 0946fca2c105b9de

Packager : CentOS BuildSystem <http://bugs.centos.org>

URL : http://www.mysql.com

Summary : The MySQL server and related files

Description :

MySQL is a multi-user, multi-threaded SQL database server. MySQL is a

client/server implementation consisting of a server daemon (mysqld)

and many different client programs and libraries. This package contains

the MySQL server and some accompanying files and directories.

4）初始化与配置mysql数据库

service mysqld start

[root@bogon /]# service mysqld start

Initializing MySQL database: Installing MySQL system tables...

Filling help tables...

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h bogon password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default. This is

strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

[ OK ]

Starting mysqld: [ OK ]

5）设置mysql的root密码：

/usr/bin/mysqladmin -u root password 'new-password'　　// 为root账号设置密码

登录mysql：mysql -u root -p 密码：new-password

以root用户登录mysql，

use mysql;

update user set password='password' where user='root';　　

6）永久关闭防火墙 chkconfig --level 35 iptables off

7）在使用Navicat连接mysql数据库时经常出现 : 2003:Can't connect to MySQL server on 'localhost'10060错误

采用SSH通道进行连接：

方法2：

连接数据库的时候显示Can't connect to MySQL server (10060)，基本可以按照以下思路进行排查：

1. 网络不通。检查能不能ping通。

2. 防火墙设置。

防火墙是否放过mysql的进程，是否屏蔽了mysql的3306端口。

3. mysql的账户设置。

mysql账户是否不允许远程连接。如果无法连接可以尝试以下方法：

　mysql -u root -p //登录MySQL
   mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;   //任何远程主机都可以访问数据库
   mysql> FLUSH PRIVILEGES; //需要输入次命令使修改生效
   mysql> EXIT //退出

也可以通过修改表来实现远程：

mysql -u root -p

   mysql> use mysql;
   mysql> update user set host = '%' where user = 'root';
   mysql> select host, user from user;

9）修改mysql的root密码：

# /etc/init.d/mysql stop

# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

# mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD('password') where USER='root';

mysql> FLUSH PRIVILEGES;

# /etc/init.d/mysql restart

# mysql -uroot -p

Enter password: <输入新设的密码newpassword>

mysql>

13 设置固定IP

编辑网卡：

vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE="eth0"

BOOTPROTO="static"

IPADDR=192.168.0.141

NETMASK=255.255.255.0

NETWORK=192.168.0.0

GATEWAY=192.168.0.2

HWADDR="00:0C:29:03:4A:E1"

IPV6INIT="no"

ONBOOT="yes"

TYPE="Ethernet"

重启网卡服务：

service network restart

重启网卡报错：Error: Connection activation failed: Device not managed by NetworkManager

1 chkconfig NetworkManager off

2 chkconfig network on
3 service NetworkManager stop
4 service network start

ps aux |grep NetworkManager

root 3193 0.0 0.0 103236 844 pts/0 S+ 18:26 0:00 grep NetworkManager

说明NetworkManager未启动，使用service NetworkManager start启动

DEVICE="eth0"

BOOTPROTO=none

IPADDR=192.168.119.141

NETMASK=255.255.255.0

NETWORK=192.168.119.0

GATEWAY=192.168.119.2

IPV6INIT="no"

ONBOOT="yes"

TYPE="Ethernet"

UUID="73be4e85-3306-43b6-bc7d-2e8418894a35"

HWADDR=00:0C:29:5E:9E:44

PREFIX=24

DNS1=192.168.119.2

DEFROUTE=yes

IPV4_FAILURE_FATAL=yes

NAME="System eth0"

LAST_CONNECT=1393937935

设置yum.conf中的代理

timout=120

proxy=http://192.168.1.130:8080

proxy_username=jincy

proxy_password=

service iptables stop

chkconfig iptables off

关闭selinux

/etc/selinux/config：SELINUX=disabled

setenforce 0

visudo

hadoop ALL=(ALL) NOPASSWD: ALL

14 安装Nginx

1)安装g++、gcc、openssl-devel、pcre-devel和zlib-devel软件
yum install gcc-c++
yum -y install zlib zlib-devel openssl openssl--devel pcre pcre-devel
yum -y install gcc automake autoconf libtool make
2)解压nginx
cp /tmp/nginx-1.2.9.tar.gz /usr/local/
tar -zxvf nginx-1.2.9.tar.gz
rm -rf nginx-1.2.9.tar.gz
cd /usr/local/nginx
./configure --prefix=/usr/local/nginx-1.2.9
make
make install

3)nginx启动
cd /usr/local/nginx-1.2.9/sbin
./nginx

【注】如果执行：mv nginx-1.2.9/ nginx
会出现：
[root@localhost nginx]# make install
make -f objs/Makefile install
make[1]: Entering directory `/usr/local/nginx'
test -d '/usr/local/nginx' || mkdir -p '/usr/local/nginx'
test -d '/usr/local/nginx/sbin' || mkdir -p '/usr/local/nginx/sbin'
test ! -f '/usr/local/nginx/sbin/nginx' || mv '/usr/local/nginx/sbin/nginx' '/usr/local/nginx/sbin/nginx.old'
cp objs/nginx '/usr/local/nginx/sbin/nginx'
test -d '/usr/local/nginx/conf' || mkdir -p '/usr/local/nginx/conf'
cp conf/koi-win '/usr/local/nginx/conf'
cp: "conf/koi-win" 与"/usr/local/nginx/conf/koi-win" 为同一文件
make[1]: *** [install] 错误 1
make[1]: Leaving directory `/usr/local/nginx'
make: *** [install] 错误 2

15 IP配置

编辑网卡：

vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE="eth0"

BOOTPROTO="static"

IPADDR=192.168.0.141

NETMASK=255.255.255.0

NETWORK=192.168.0.0

GATEWAY=192.168.0.2

HWADDR="00:0C:29:03:4A:E1"

IPV6INIT="no"

ONBOOT="yes"

TYPE="Ethernet"

重启网卡服务：

service network restart

重启网卡报错：Error: Connection activation failed: Device not managed by NetworkManager

1 chkconfig NetworkManager off

2 chkconfig network on
3 service NetworkManager stop
4 service network start

ps aux |grep NetworkManager

root 3193 0.0 0.0 103236 844 pts/0 S+ 18:26 0:00 grep NetworkManager

说明NetworkManager未启动，使用service NetworkManager start启动

DEVICE="eth0"

BOOTPROTO=none

IPADDR=192.168.119.141

NETMASK=255.255.255.0

NETWORK=192.168.119.0

GATEWAY=192.168.119.2

IPV6INIT="no"

ONBOOT="yes"

TYPE="Ethernet"

UUID="73be4e85-3306-43b6-bc7d-2e8418894a35"

HWADDR=00:0C:29:5E:9E:44

PREFIX=24

DNS1=192.168.119.2

DEFROUTE=yes

IPV4_FAILURE_FATAL=yes

NAME="System eth0"

LAST_CONNECT=1393937935

设置yum.conf中的代理

timout=120

proxy=http://192.168.1.130:8080

proxy_username=jincy

proxy_password=

service iptables stop

chkconfig iptables off

关闭selinux

/etc/selinux/config：SELINUX=disabled

setenforce 0

visudo

hadoop ALL=(ALL) NOPASSWD: ALL

来自为知笔记(Wiz)

刷新页面返回顶部

wuji1626

CentOS实操

About