您的位置 首页 技术

CentOS64+Qt+Mysql+ftp+无密钥传输的装备

这两天单位要部一个环境.CentOS64+Qt+Mysql+ftp+无密钥传输的.有段日了没装系统了..呵呵..命令忘的都差不多了..记录一下.###########################

这两天单位要部一个环境.CentOS64+Qt+Mysql+ftp+无密钥传输的.

有段日了没装体系了..呵呵..

指令忘的都差不多了..记载一下.

############################################################################################

# 1. CentOS 装备yum源

############################################################################################

# 挂载两个ISO

将第一个盘的ISO1文件复制到ISO2中,进行挂载.

[base-centos]

name=CentOS

baseurl=file:///mnt/iso

gpgcheck=0

enabled=1

# 装置gcc,java

yum intall -y gcc*

yum intall -y java*

# 封闭防火墙

封闭:

chkconfig iptables off

selinuxenabled 0

############################################################################################

# 2. 装置MYSQL-5.1.66

############################################################################################

# 装备好yum源后,yum install -y mysql*

# 发动mysql

service mysqld start

mysql -h192.168.2.18 -uroot -p111

# 检查监听端口

netstat -tnlp |grep :3306

# 检查库

show databases;

# mysql的长途衔接

# 在[mysqld]的段中加上一句:skip-grant-tables

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-name-resolve

skip-grant-tables

意图是为了:

越过MySQL的拜访操控,任何人都能够在操控台以管理员的身份进入MySQL数据库。

需求留意的是在修正完暗码今后要把MySQL服务器停掉重新发动才会收效

重启mysql服务!

假如你想答应用户myuser从ip为192.168.1.3的主机衔接到mysql服务器,并运用mypassword作为暗码

GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’192.168.1.3’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;

############################################################################################

# 3. 编译装置Qt-4.5.2

############################################################################################

## Qt装置办法

解压装置包,并移动到 /user/locale/下面.

./configure -debug-and-release -fast -qt-sql-mysql -no-qt3support -no-webkit -no-opengl -no-openssl

# 装备成果

留意:Qt默许只支撑PNG图片,

假如有JPEG或其它格局,

需求去Qt的装置目录

plugins\imageformats

下复制图片插件>

Debug …………… no

Qt 3 compatibility .. no

QtDBus module ……. no

QtScriptTools module yes

QtXmlPatterns module yes

Phonon module ……. no

SVG module ………. yes

WebKit module ……. no

STL support ……… yes

PCH support ……… yes

MMX/3DNOW/SSE/SSE2.. yes/yes/yes/yes

Graphics System ….. default

IPv6 support …….. yes

IPv6 ifname support . yes

getaddrinfo support . yes

getifaddrs support .. yes

Accessibility ……. yes

NIS support ……… yes

CUPS support …….. no

Iconv support ……. yes

Glib support …….. no

GStreamer support … no

Large File support .. yes

GIF support ……… plugin

TIFF support …….. plugin (qt)

JPEG support …….. plugin (qt)

PNG support ……… yes (qt)

MNG support ……… plugin (qt)

zlib support …….. system

Session management .. yes

OpenGL support …… no

NAS sound support … no

XShape support …… yes

Xinerama support …. runtime

Xcursor support ….. runtime

Xfixes support …… runtime

Xrandr support …… runtime

Xrender support ….. yes

Xi support ………. runtime

MIT-SHM support ….. yes

FontConfig support .. yes

XKB Support ……… yes

immodule support …. yes

GTK theme support … no

MySQL support ……. qt

SQLite support …… plugin (qt)

OpenSSL support ….. no

## 编译装置

gmake gmake install

## 修正环境变量

能够将环境变量添加到 .bashrc 或 .bash_profile 或 /etc/bashrc 或 /etc/profile

它们的区别是:

1. /etc/profile:对一切用户收效,当用户第一次登录时,该文件被履行.

2. /etc/bashrc:对一切用户收效,为每一个运转bash shell的用户履行此文件

3. ~/.bash_profile:仅会对当时用户有用,当用户登录时,该文件只是履行一次

4. ~/.bashrc:仅会对当时用户有用,当登录时以及每次翻开新的shell时,该该文件被读取

QTDIR=/usr/local/qt-4.5.2

PATH=$QTDIR/bin:$PATH

LD_LIBRARY_PATH=$QTDIR/lib:$LD_LIBRARY_PATH

QMAKESPEC=$QTDIR/mkspecs/linux-g++-64

export QTDIR

export PATH

export LD_LIBRARY_PATH

export QMAKESPEC

## 检查Qt支撑的图片类型

能够运转下面的函数检查:QImageReader::supportedImageFormats

QList QImageReader::supportedImageFormats () [static]

Returns the list of image formats supported by QImageReader.

By default, Qt can read the following formats:

Format Description

BMP Windows Bitmap

GIF Graphic Interchange Format (optional)

JPG Joint Photographic Experts Group

JPEG Joint Photographic Experts Group

MNG Multiple-image Network Graphics

PNG Portable Network Graphics

PBM Portable Bitmap

PGM Portable Graymap

PPM Portable Pixmap

TIFF Tagged Image File Format

XBM X11 Bitmap

XPM X11 Pixmap

SVG Scalable Vector Graphics

TGA Targa Image Format

Reading and writing SVG files is supported through Qt’s SVG Module.

TGA support only extends to reading non-RLE compressed files. In particular calls to capabilities for the tga plugin returns only QImageIOPlugin::CanRead, not QImageIOPlugin::CanWrite.

To configure Qt with GIF support, pass -qt-gif to the configure script or check the appropriate option in the graphical installer.

Note that the QApplication instance must be created before this function is called.

See also setFormat(), QImageWriter::supportedImageFormats(), and QImageIOPlugin.

############################################################################################

# 4. 运用Qt衔接Mysql

############################################################################################

#include

#include

#include

#include

using namespace std;

int main(int argc, char *argv[])

{

QApplication app(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase(QMYSQL);

db.setHostName(localhost);

db.setDatabaseName(mydb);

db.setUserName(username);

db.setPassword(password);

db.open();

QSqlQuery query;

query.exec(create table hello(id bigint not null auto_increment,name varchar(255),age bigint,primary key (id)));

query.exec(insert into hello(name, age) values(‘xiaoxi’, 18));

query.exec(insert into hello(name, age) values(‘xiaonan’, 19));

query.exec(insert into hello(name, age) values(‘xiaobei’, 20));

query.exec(insert into hello(name, age) values(‘xiaodong’, 21));

QSqlQueryModel *model = new QSqlQueryModel;

model->setQuery(select * from hello);

model->setHeaderData(0, Qt::Horizontal, id);

model->setHeaderData(1, Qt::Horizontal, name);

model->setHeaderData(2, Qt::Horizontal, age);

QTableView *view = new QTableView;

view->setWindowTitle(QSqlQueryModel);

view->setModel(model);

view->show();

db.close();

return app.exec();

}

编译:

xhy@xhy-desktop:~$ qmake -project

xhy@xhy-desktop:~$ qmake

必定别忘了在工程的.pro文件里加上下面一行:

QT += sql

xhy@xhy-desktop:~$make

xhy@xhy-desktop:~$./mysql

############################################################################################

# 5. CentOS装备sftp

############################################################################################

sftp是ssh内含的协议,只需sshd服务器发动了,它就可用.

sftp root@192.168.2.18

>ls

>get …

>put …

假如sshd服务没有默许发动:

chkconfig sshd on

############################################################################################

# 6. CentOS装备无密钥传输

############################################################################################

# 举例说明:

[root@centos6-64 .ssh]# pwd

/root/.ssh

[root@centos6-64 .ssh]# ssh-keygen

Generating public/private rsa key pair.

Enter file in which to save the key (/root/.ssh/id_rsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /root/.ssh/id_rsa.

Your public key has been saved in /root/.ssh/id_rsa.pub.

The key fingerprint is:

d6:2a:df:0b:46:3d:22:da:5b:24:b2:da:78:01:f3:c4 root@centos6-64

The key’s randomart image is:

+–[ RSA 2048]—-+

| |

| |

| . |

| o E o |

| =. o S + |

| o= * o . |

| o.o = |

| +. * o |

| o.. . . o. |

+—————–+

[root@centos6-64 .ssh]# ls -lrt

total 16

-rw-r–r– 1 root root 394 Nov 18 16:18 known_hosts

-rw-r–r– 1 root root 394 Nov 18 22:32 authorized_keys

-rw-r–r– 1 root root 397 Nov 18 22:33 id_rsa.pub

-rw——- 1 root root 1675 Nov 18 22:33 id_rsa

[root@centos6-64 .ssh]# scp id_rsa.pub 192.168.2.16:~/.ssh/authorized_keys

root@192.168.2.16’s password:

id_rsa.pub 100% 397 0.4KB/s 00:00

[root@centos6-64 .ssh]# ssh 192.168.2.16

Last login: Mon Nov 18 22:16:16 2013 from 192.168.2.221

[root@red6-64 ~]#

声明:本文内容来自网络转载或用户投稿,文章版权归原作者和原出处所有。文中观点,不代表本站立场。若有侵权请联系本站删除(kf@86ic.com)https://www.86ic.net/xinpin/jishu/134351.html

为您推荐

联系我们

联系我们

在线咨询: QQ交谈

邮箱: kf@86ic.com

关注微信
微信扫一扫关注我们

微信扫一扫关注我们

返回顶部