这两天单位要部一个环境.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
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 ~]#