Archive for the ‘Uncategorized’ Category

SSH Tricks In Exim To Remove Email Queue

Saturday, January 5th, 2013

SSH Tricks In Exim To Remove Email Queue
[1] Removing Bad Mail

for i in `exiqgrep -i -f nobody`; do exim -Mrm $i; done >> Removes Nobody Mail

for i in `exiqgrep -i -o 259200`; do exim -Mrm $i; done >> Removes Mail Older than 3 Days

for i in `exiqgrep -i -f “^<>$”`; do exim -Mrm $i; done >> Removes Mail with Weird Characters (Spam)

[2] Delete Mail by a Domain

for i in `exiqgrep -i -f domain.com`; do exim -Mrm $i; done

[3] Delete Mail for a Domain

for i in `exiqgrep -i -r domain.com`; do exim -Mrm $i; done

[4] Remove Whole Mail Queue

for i in `exiqgrep -i -f `; do exim -Mrm $i; done

[5] Run Mail Queue

runq -qqff&

XAMPP 使用Shell命令导入MYSQL数据库

Sunday, December 16th, 2012

1、开始——运行:执行cmd命令,打开windows命令窗口;

2、首先在命令窗口执行:d:命令,切换进D:\>

3、进入mysql的bin目录,执行命令行:cd D:\xampp\mysql\bin

4、输入MYSQL用户名和密码:
D:\xampp\mysql\bin>mysql -u root -p
Enter password: *******

5、使用use命令打开准备导入数据的操作数据库,如:
mysql> use jiebanxing.com

6、使用source命令导入sql文件,如:
mysql> set names utf8;
mysql>source d:\go2pad.com.sql

现在立即更新cpanel

Thursday, December 13th, 2012

/scripts/upcp –force

PHPMyAdmin 如何导入大SQL文件

Wednesday, December 12th, 2012

如果是只能phpmyadmin,打开phpMyAdmin目录下的配置文件:config.inc.php

请注意其中的这两个参数:

$cfg[‘UploadDir’] =’A’;
$cfg[‘SaveDir’] =’B’;

在phpMyAdmin目录下自行建立文件夹A和B来对应UploadDir(导入目录)和SaveDir(导出目录)。
(more…)

Fatal! Perl must be installed before proceeding!

Saturday, December 1st, 2012

cpanel安装时出现这个错误
Fatal! Perl must be installed before proceeding!
可以先
yum install perl
然后再重新安装就可以了

Joomla!安装环境要求

Sunday, November 25th, 2012

PHP v. 5.2+
MySQL 5.04+
Apache 1.3

更详细的要求可以查看这里
http://www.joomla.org/technical-requirements.html

Centos系统sendmail发送邮件很慢的解决方法

Saturday, November 17th, 2012

安装sendmail服务器的很简单,只需输入以下命令即可:

yum install sendmail

这个时候依然无法发邮件,还得修改一下php.ini的配置,调用sendmail功能

第一步:输入 vi /usr/local/php/etc/php.ini

第二步:找到有关sendmail_path的那一行,按i键,然后就可以修改代码了,

第三步:去掉行首注释(分号;),并改成:sendmail_path = /usr/sbin/sendmail -t –i
(more…)

Linux Crontab 安装使用详细说明

Saturday, November 17th, 2012

crontab命 令常见于Unix和Linux的操作系统之中,用于设置周期性被执行的指令。该命令从标准输入设备读取指令,并将其存放于“crontab”文件中,以供 之后读取和执行。通常,crontab储存的指令被守护进程激活。crond 常常在后台运行,每一分钟检查是否有预定的作业需要执行。这类作业一般称为cron jobs。

一、安装

[root@CentOS ~]# yum -y install vixie-cron
[root@CentOS ~]# yum -y install crontabs

说明:
vixie-cron 软件包是 cron 的主程序;
crontabs 软件包是用来安装、卸装、或列举用来驱动 cron 守护进程的表格的程序。 (more…)

Magento的运行环境最低需求配置

Tuesday, August 7th, 2012

Linux, Windows, 或其他 UNIX兼容操作系统 (不推荐在正式商用环境中使用windows)
Apache Web Server (1.x or 2.x),Nginx,litespeed
PHP 5.2.0 以上, 并且包含下列扩展(Extensions/Addons):
PDO/MySQL
MySQLi
mcrypt
mhash
simplexml
DOM
curl
gd
soap
MySQL 4.1.20 或更新版本
Sendmail兼容的 Mail Transfer Agent (MTA)
如果没有MTA,Magento将直接连接一个 SMTP server
下面为检测文件
http://www.magentochina.org/magento-check.zip

Disk Space Usage里面Others Folder占用异常检查

Thursday, August 2nd, 2012

This usage could be anywhere on the system outside of the user’s home directory. I suggest running the following commands to obtain the location of all files owned by this user:

Code:

# id username
# find / -uid UIDNUMBER > /root/username.output

Replace the first command with the actual username of the account. This will output the account’s UID. You can then replace “UIDNUMBER” in the second command with the actual UID of the account. The results will be output to /root/username.output which you can view after the command finishes.

查找属于用户的文件
find /home -user username
find / -user username