主机软件博客 – 第 16 页 – 提供IDC行业和cPanel/WHMCS/DirectAdmin/Onapp等文章和教程

DirectAdmin Linux 站群管理插件 – 批量建自动MYSQL数据库

2013年1月25日
by 主机软件

DirectAdmin Linux 站群管理插件 – 批量建自动MYSQL数据库

因为最近越来越多的客户
使用Linux系统的服务器做站群
咨询有无更简便的方式实现批量建网站和建数据库
所以我们开发了一些小的插件
提供给用户使用

实现功能
批量建数据库
使用内部API方式
提供给DA用户层的用户生成DA用户指定的开始和结束ID的数据库名称
可以一次性建立100 或者1000个数据库.

数据库格式为
数据库名称= 用户名_数字随机数据库用户随机数据库密码

使用教程与截图
Step 1
首先登录DA 如果是Admin 请点击用户层
然后点击底部的批量建数据库

Step 2
输入参数
比如需要建立30个数据库
输入开始 1 结束 30
或者开始 30 结束 60
注意不要重复,重复会生成错误

Step3
接着开始生成数据库
返回数据库信息
生成100个数据库耗时10秒上下速度很快

注意保存下这个文本信息
因为安全原因仅显示数据库名称比如 1
数据库名称应该是 admin_1 用户也一样
因为文本文件容易被误传考虑到可能被人利用
所以仅显示名称和密码不熟悉的人不会知道你的用户名

Step4
然后点击 Home图标返回主页
点击 MYSQL数据库
可以看到已经建立成功的数据库列表

批量建 MYSQL数据库插件下载
注意:
仅提供给购买我们DirectAdmin授权的老客户使用
可以联系我们获得,未免费公开发布

源码编译方式安装NGINX　PHP [笔记]

源码编译方式安装NGINX　PHP

echo "[dag]" > /etc/yum.repos.d/dag.repo
echo "name=Dag RPM Repository for Red Hat Enterprise Linux" >> /etc/yum.repos.d/dag.repo
echo "baseurl=http://apt.sw.be/redhat/el\$releasever/en/\$basearch/dag" >> /etc/yum.repos.d/dag.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/dag.repo
echo "enabled=1" >> /etc/yum.repos.d/dag.repo

echo "[dag]" > /etc/yum.repos.d/dag.repo

echo "name=Dag RPM Repository for Red Hat Enterprise Linux" >> /etc/yum.repos.d/dag.repo

echo "baseurl=http://apt.sw.be/redhat/el\$releasever/en/\$basearch/dag" >> /etc/yum.repos.d/dag.repo

echo "gpgcheck=0" >> /etc/yum.repos.d/dag.repo

echo "enabled=1" >> /etc/yum.repos.d/dag.repo

安装基础环境以及依赖包

yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers
yum install subversion -y

yum install mcrypt libmcrypt libmcrypt-devel mhash mhash-devel pcre pcre-devel

yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers

yum install subversion -y

yum install mcrypt libmcrypt libmcrypt-devel mhash mhash-devel pcre pcre-devel

下载安装包

http://de.php.net/get/php-5.3.16.tar.gz/from/us.php.net/mirror
http://no2.php.net/get/php-5.4.6.tar.gz/from/us.php.net/mirror
tar xvfz php-5.4.6.tar.gz  //  tar -jxvf php-5.4.6.tar.bz2
cd php*
./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysqld --with-openssl --enable-fpm --enable-sockets --enable-sysvshm  --with-mysqli=/usr/local/mysqld/bin/mysql_config --enable-mbstring --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib-dir --with-libxml-dir=/usr --enable-xml  --with-mhash --with-mcrypt  --with-config-file-path=/usr/local/php/etc --with-config-file-scan-dir=/usr/local/php/etc --with-bz2 --with-curl 
make
make install
cp php.ini-production /usr/local/php/etc/php.ini

cp sapi/fpm/init.d.php-fpm /etc/rc.d/init.d/php-fpm
chmod +x /etc/rc.d/init.d/php-fpm   
cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf 
vim /usr/local/php/etc/php-fpm.conf  
pid = run/php-fpm.pid  
pm.max_children = 50   最多多少子进程  
pm.start_servers = 5   刚开始启动多少进程  
pm.min_spare_servers = 2  最少多少空闲进程  
pm.max_spare_servers = 8  最多多少空闲进程  

service php-fpm start 

http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.14.tar.gz


yum install subversion -y
cd php-5.3.x
svn co http://svn.php.net/repository/php/php-src/trunk/sapi/fpm sapi/fpm
./buildconf --force
./configure --enable-fpm ...your other configure options, etc...
make && make install


http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.27.tar.gz/from/http://cdn.mysql.com/
/usr/sbin/groupadd -r mysql
/usr/sbin/useradd -g mysql mysql

useradd -g mysql -r -s /sbin/nologin

tar zxvf mysql-5.5.27.tar.gz
cd mysql-*/
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysqld -DINSTALL_DATADIR=/usr/local/mysqld/database  -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1
make
make install

./configure --prefix=/usr/local/mysqld/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=partition,innobase,myisammrg

make && make install

chmod +w /usr/local/mysqld
chown -R mysql:mysql /usr/local/mysqld
scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysqld/data

default-storage-engine=MyISAM


export PATH=/usr/local/mysqld/bin/:$PATH  
echo '/usr/local/mysqld/lib/' > /etc/ld.so.conf  
ldconfig  
bin/mysqladmin -u root password '111000'

http://de.php.net/get/php-5.3.16.tar.gz/from/us.php.net/mirror

http://no2.php.net/get/php-5.4.6.tar.gz/from/us.php.net/mirror

tar xvfz php-5.4.6.tar.gz // tar -jxvf php-5.4.6.tar.bz2

cd php*

./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysqld --with-openssl --enable-fpm --enable-sockets --enable-sysvshm --with-mysqli=/usr/local/mysqld/bin/mysql_config --enable-mbstring --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib-dir --with-libxml-dir=/usr --enable-xml --with-mhash --with-mcrypt --with-config-file-path=/usr/local/php/etc --with-config-file-scan-dir=/usr/local/php/etc --with-bz2 --with-curl

make

make install

cp php.ini-production /usr/local/php/etc/php.ini

cp sapi/fpm/init.d.php-fpm /etc/rc.d/init.d/php-fpm

chmod +x /etc/rc.d/init.d/php-fpm

cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf

vim /usr/local/php/etc/php-fpm.conf

pid = run/php-fpm.pid

pm.max_children = 50 最多多少子进程

pm.start_servers = 5 刚开始启动多少进程

pm.min_spare_servers = 2 最少多少空闲进程

pm.max_spare_servers = 8 最多多少空闲进程

service php-fpm start

http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.14.tar.gz

yum install subversion -y

cd php-5.3.x

svn co http://svn.php.net/repository/php/php-src/trunk/sapi/fpm sapi/fpm

./buildconf --force

./configure --enable-fpm ...your other configure options, etc...

make && make install

http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.27.tar.gz/from/http://cdn.mysql.com/

/usr/sbin/groupadd -r mysql

/usr/sbin/useradd -g mysql mysql

useradd -g mysql -r -s /sbin/nologin

tar zxvf mysql-5.5.27.tar.gz

cd mysql-*/

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysqld -DINSTALL_DATADIR=/usr/local/mysqld/database -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1

make

make install

./configure --prefix=/usr/local/mysqld/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=partition,innobase,myisammrg

make && make install

chmod +w /usr/local/mysqld

chown -R mysql:mysql /usr/local/mysqld

scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysqld/data

default-storage-engine=MyISAM

export PATH=/usr/local/mysqld/bin/:$PATH

echo '/usr/local/mysqld/lib/' > /etc/ld.so.conf

ldconfig

bin/mysqladmin -u root password '111000'

NGINX 安装

wget -c http://nginx.org/download/nginx-1.2.3.tar.gz
groupadd -r nginx  
useradd -r -g nginx -s /sbin/nologin -M nginx 

tar xf nginx-*.tar.gz
cd nginx-* 
./configure --prefix=/usr/local/nginx --sbin-path=/usr/local/nginx/sbin/nginx --conf-path=/usr/local/nginx/etc/nginx.conf --error-log-path=/var/log/nginx/error.log --http-log-path=/var/log/nginx/access.log --pid-path=/var/run/nginx/nginx.pid --lock-path=/var/lock/nginx.lock --user=nginx --group=nginx --with-http_ssl_module --with-http_flv_module --with-http_stub_status_module --with-http_gzip_static_module --http-client-body-temp-path=/var/tmp/nginx/client/ --http-proxy-temp-path=/var/tmp/nginx/proxy/  --http-fastcgi-temp-path=/var/tmp/nginx/fcgi/ --http-uwsgi-temp-path=/var/tmp/nginx/uwsgi --http-scgi-temp-path=/var/tmp/nginx/scgi --with-pcre 
make && make install

wget -c http://nginx.org/download/nginx-1.2.3.tar.gz

groupadd -r nginx

useradd -r -g nginx -s /sbin/nologin -M nginx

tar xf nginx-*.tar.gz

cd nginx-*

./configure --prefix=/usr/local/nginx --sbin-path=/usr/local/nginx/sbin/nginx --conf-path=/usr/local/nginx/etc/nginx.conf --error-log-path=/var/log/nginx/error.log --http-log-path=/var/log/nginx/access.log --pid-path=/var/run/nginx/nginx.pid --lock-path=/var/lock/nginx.lock --user=nginx --group=nginx --with-http_ssl_module --with-http_flv_module --with-http_stub_status_module --with-http_gzip_static_module --http-client-body-temp-path=/var/tmp/nginx/client/ --http-proxy-temp-path=/var/tmp/nginx/proxy/ --http-fastcgi-temp-path=/var/tmp/nginx/fcgi/ --http-uwsgi-temp-path=/var/tmp/nginx/uwsgi --http-scgi-temp-path=/var/tmp/nginx/scgi --with-pcre

make && make install

手工备份 Xen HVM VPS

2013年1月22日
by 主机软件

手工备份Xen HVM VPS

ssh登录服务器
运行 lvscan 扫描LV存储

[root@vs09 /]# lvscan
  ACTIVE            '/dev/vol/vm324_img' [20.00 GB] inherit
  ACTIVE            '/dev/vol/vm326_img' [25.00 GB] inherit
  ACTIVE            '/dev/vol/vm328_img' [20.00 GB] inherit
  ACTIVE            '/dev/vol/vm329_img' [20.00 GB] inherit
  ACTIVE            '/dev/vol/vm332_img' [20.00 GB] inherit
  ACTIVE            '/dev/vol/vm333_img' [20.00 GB] inherit
  ACTIVE            '/dev/vol/vm336_img' [20.00 GB] inherit
  ACTIVE            '/dev/vol/vm337_img' [20.00 GB] inherit

[root@vs09 /]# lvscan

ACTIVE '/dev/vol/vm324_img' [20.00 GB] inherit

ACTIVE '/dev/vol/vm326_img' [25.00 GB] inherit

ACTIVE '/dev/vol/vm328_img' [20.00 GB] inherit

ACTIVE '/dev/vol/vm329_img' [20.00 GB] inherit

ACTIVE '/dev/vol/vm332_img' [20.00 GB] inherit

ACTIVE '/dev/vol/vm333_img' [20.00 GB] inherit

ACTIVE '/dev/vol/vm336_img' [20.00 GB] inherit

ACTIVE '/dev/vol/vm337_img' [20.00 GB] inherit

建立Snapshot/快照

[root@vs09 /]# 
lvcreate -s -L 10G -n vm324_img-snap /dev/vol/vm324_img 
  Logical volume "vm324_img-snap" created

[root@vs09 /]#

lvcreate -s -L 10G -n vm324_img-snap /dev/vol/vm324_img

Logical volume "vm324_img-snap" created

参数意思
-s = 快照模式
-L *G/M = 快照大小
-n xxx = 快照名称
/dev/vol/vm324_img 原镜像

重建分区表 (如果不需要挂载检查数据不需要重建)

kpartx -av /dev/vol/vm324_img-snap 
add map vm324_img-snap1 : 0 62910477 linear /dev/vol/vm324_img-snap 63

1 2	kpartx -av /dev/vol/vm324_img-snap add map vm324_img-snap1 : 0 62910477 linear /dev/vol/vm324_img-snap 63

挂载NTFS文件系统获得硬盘数据

mount -t ntfs /dev/mapper/vm324_img-snap1 /mnt -o force

The disk contains an unclean file system (0, 0).
The file system wasn't safely closed on Windows. Fixing.

mount -t ntfs /dev/mapper/vm324_img-snap1 /mnt -o force

The disk contains an unclean file system (0, 0).

The file system wasn't safely closed on Windows. Fixing.

可以查看数据

[root@vs09 /]# ll /mnt
total 2096889
-rwxrwxrwx 1 root root          0 Sep  6 17:41 AUTOEXEC.BAT
-rwxrwxrwx 1 root root        208 Sep  6 18:18 boot.ini
-rwxrwxrwx 1 root root          0 Sep  6 17:41 CONFIG.SYS
drwxrwxrwx 1 root root       4096 Sep  6 19:26 Documents and Settings
drwxrwxrwx 1 root root    1294336 Sep  6 21:57 I386
-rwxrwxrwx 1 root root          0 Sep  6 17:41 IO.SYS
-rwxrwxrwx 1 root root          0 Sep  6 17:41 MSDOS.SYS
-rwxrwxrwx 1 root root      94720 Feb 17  2007 msizap.exe
-rwxrwxrwx 1 root root      47772 Mar 22  2006 NTDETECT.COM
-rwxrwxrwx 1 root root     297072 Sep  6 21:02 ntldr
-rwxrwxrwx 1 root root 2145386496 Oct  5 16:29 pagefile.sys
drwxrwxrwx 1 root root       4096 Sep  7 00:55 Program Files
drwxrwxrwx 1 root root          0 Sep  6 19:25 System Volume Information
drwxrwxrwx 1 root root      77824 Sep  6 17:08 WINDOWS
drwxrwxrwx 1 root root          0 Sep  6 17:44 wmpub

[root@vs09 /]# ll /mnt

total 2096889

-rwxrwxrwx 1 root root 0 Sep 6 17:41 AUTOEXEC.BAT

-rwxrwxrwx 1 root root 208 Sep 6 18:18 boot.ini

-rwxrwxrwx 1 root root 0 Sep 6 17:41 CONFIG.SYS

drwxrwxrwx 1 root root 4096 Sep 6 19:26 Documents and Settings

drwxrwxrwx 1 root root 1294336 Sep 6 21:57 I386

-rwxrwxrwx 1 root root 0 Sep 6 17:41 IO.SYS

-rwxrwxrwx 1 root root 0 Sep 6 17:41 MSDOS.SYS

-rwxrwxrwx 1 root root 94720 Feb 17 2007 msizap.exe

-rwxrwxrwx 1 root root 47772 Mar 22 2006 NTDETECT.COM

-rwxrwxrwx 1 root root 297072 Sep 6 21:02 ntldr

-rwxrwxrwx 1 root root 2145386496 Oct 5 16:29 pagefile.sys

drwxrwxrwx 1 root root 4096 Sep 7 00:55 Program Files

drwxrwxrwx 1 root root 0 Sep 6 19:25 System Volume Information

drwxrwxrwx 1 root root 77824 Sep 6 17:08 WINDOWS

drwxrwxrwx 1 root root 0 Sep 6 17:44 wmpub

卸载挂载的设备

umount /mnt
partx -d /dev/vol/vm324_img-snap 
lvremove /dev/vol/vm324_img-snap 
Do you really want to remove active logical volume vm324_img-snap? [y/n]: y
输入y 
  Logical volume "vm324_img-snap" successfully removed

umount /mnt

partx -d /dev/vol/vm324_img-snap

lvremove /dev/vol/vm324_img-snap

Do you really want to remove active logical volume vm324_img-snap? [y/n]: y

输入y

Logical volume "vm324_img-snap" successfully removed

即可完成

WHMCS 安装教程

2013年1月22日
by 主机软件

WHMCS 安装教程

1. 下载
在官方或者我们的客户中心下载whmcs最新版安装包

2. 上传
使用flashfxp等软件登录服务器的FTP
如果没请使用lftp等下载安装

将download / templates_c 等文件夹设置为777属性
如果使用控制面板以fastcgi模式运行php
则不需要设置 cli模式需要设置

3. 解析域名
把你需要使用的域名
解析到服务器ip
并且可访问

4. 访问域名 (图1)
比如 http://xxxx.ushezu.com/install/install.php
点击 i agree (我同意)

System Requirements Checks

» PHP Version ………. Passed
» MySQL ………. Passed
» CURL ………. Passed

Permissions Checks

» Configuration File ………. Passed
» Attachments Folder Permissions ………. Passed
» Downloads Folder Permissions ………. Passed
» Templates Folder Permissions ………. Passed
全部为passed 即可安装
如果不是请修复后点击 re check 重新检查
点击 continue 继续安装

License Key = 授权key
您购买后获得的key
输入即可

varnish Cache 配置

2013年1月22日
by 主机软件

yum方式安装

rpm --nosignature -i http://repo.varnish-cache.org/redhat/el5/noarch/varnish-release-2.1-2.noarch.rpm
yum install varnish

1 2	rpm --nosignature -i http://repo.varnish-cache.org/redhat/el5/noarch/varnish-release-2.1-2.noarch.rpm yum install varnish

vcl.conf

backend main { 
       set backend.host = "192.168.0.5"; 
       set backend.port = "80"; 
}

acl purge {
       "localhost";
       "127.0.0.1";
       "192.168.1.0"/24;
}

sub vcl_recv {
       if (req.request == "PURGE") {
               if (!client.ip ~ purge) {
                       error 405 "Not allowed.";
               }
               lookup;
       }

       if (req.http.host ~ "^blog.s135.com") {
               set req.backend = main; 
               if (req.request != "GET" && req.request != "HEAD") {
                       pipe;
               }
               else {
                       lookup;
               }
       }
       else {
               error 404 "Cache Server"; 
               lookup;
       }
}

sub vcl_hit {
       if (req.request == "PURGE") {
               set obj.ttl = 0s;
               error 200 "Purged.";
       }
}

sub vcl_miss {
       if (req.request == "PURGE") {
               error 404 "Not in cache.";
       }
}

sub vcl_fetch {
       if (req.request == "GET" && req.url ~ "\.(txt|js)$") {
               set obj.ttl = 3600s;
       }
       else {
               set obj.ttl = 30d;
       }
}

backend main {

set backend.host = "192.168.0.5";

set backend.port = "80";

}

acl purge {

"localhost";

"127.0.0.1";

"192.168.1.0"/24;

}

sub vcl_recv {

if (req.request == "PURGE") {

if (!client.ip ~ purge) {

error 405 "Not allowed.";

}

lookup;

}

if (req.http.host ~ "^blog.s135.com") {

set req.backend = main;

if (req.request != "GET" && req.request != "HEAD") {

pipe;

}

else {

lookup;

}

else {

error 404 "Cache Server";

lookup;

}

sub vcl_hit {

if (req.request == "PURGE") {

set obj.ttl = 0s;

error 200 "Purged.";

}

sub vcl_miss {

if (req.request == "PURGE") {

error 404 "Not in cache.";

}

sub vcl_fetch {

if (req.request == "GET" && req.url ~ "\.(txt|js)$") {

set obj.ttl = 3600s;

}

else {

set obj.ttl = 30d;

}

这里，我对这段配置文件解释一下：
　　(1)、Varnish通过反向代理请求后端IP为192.168.0.5，端口为80的web服务器；
　　(2)、Varnish允许localhost、127.0.0.1、192.168.0.***三个来源IP通过PURGE方法清除缓存；
　　(3)、Varnish对域名为blog.s135.com的请求进行处理，非blog.s135.com域名的请求则返回“Zhang Yan Cache Server”；
　　(4)、Varnish对HTTP协议中的GET、HEAD请求进行缓存，对POST请求透过，让其直接访问后端Web服务器。之所以这样配置，是因为POST请求一般是发送数据给服务器的，需要服务器接收、处理，所以不缓存；
　　(5)、Varnish对以.txt和.js结尾的URL缓存时间设置1小时，对其他的URL缓存时间设置为30天。

　　5、启动Varnish

ulimit -SHn 51200
/usr/local/varnish/sbin/varnishd -n /var/vcache -f /usr/local/varnish/vcl.conf -a 0.0.0.0:80 -s file,/var/vcache/varnish_cache.data,1G -g www -u www -w 30000,51200,10 -T 127.0.0.1:3500 -p client_http11=on


ulimit -SHn 51200
/usr/local/varnish/sbin/varnishd -n /var/vcache -f /usr/local/varnish/vcl.conf -a 0.0.0.0:80 -s file,/var/vcache/varnish_cache.data,1G -g www -u www -w 30000,51200,10 -T 127.0.0.1:3500 -p client_http11=on
/usr/local/varnish/bin/varnishncsa -n /var/vcache -w /var/logs/youvideo.log &


/usr/local/varnish/bin/varnishadm -T 127.0.0.1:3500 help

ulimit -SHn 51200

/usr/local/varnish/sbin/varnishd -n /var/vcache -f /usr/local/varnish/vcl.conf -a 0.0.0.0:80 -s file,/var/vcache/varnish_cache.data,1G -g www -u www -w 30000,51200,10 -T 127.0.0.1:3500 -p client_http11=on

ulimit -SHn 51200

/usr/local/varnish/bin/varnishncsa -n /var/vcache -w /var/logs/youvideo.log &

/usr/local/varnish/bin/varnishadm -T 127.0.0.1:3500 help

引用
Available commands:
ping [timestamp]
status
start
stop
stats
vcl.load
vcl.inline
vcl.use
vcl.discard
vcl.list
vcl.show
param.show [-l] []
param.set
help [command]
url.purge
dump.pool

1 2 3 … 13 14 15 16 17 18 19 … 31 32 33

Posts navigation