Archive for the ‘技术’ Category

这次更新还是针对 张宴的  http://blog.s135.com/nginx_php_v6/12/1/ 。具体的步骤请参考http://blog.s135.com/nginx_php_v6/12/1/ ,我这里只是提出针对php版本上的特殊的地方。

mysql ,nginx 的安装基本没有什么变化。php已经升级到最新版了,5.3.2 ,最大的变化在php-fpm ,更改了安装方式,和启动方式。

这里也只是说下我遇到的问题,

checking for lemon… no

configure: warning: lemon versions supported for regeneration of \

libsqlite parsers: 1.0 (found: none).

这个原因是因为sqlite选项的问题,解决方法是自己编译一个lemon。

wget http://www.sqlite.org/cvstrac/getfile/sqlite/tool/lemon.c

gcc -o lemon lemon.c

mv lemon /usr/local/bin

——————————————————————————————–

char *… configure: error: cannot compute sizeof (char *), 77

这个问题是因为编译php的时候加入了  –disable-rpath  这个选项在php5.2 的时候就有问题,不知道为什么张宴没有去掉。 等解答。

——————————————————————————————-

php-fpm 目前正在更新,到php5.4 据说就能集成到内核了,估计就没有现在这么麻烦了。

官方的方法是:

cd php-5.3.x
svn co http://svn.php.net/repository/php/php-src/branches/PHP_5_3/sapi/fpm sapi/fpm
./buildconf --force
./configure --enable-fpm
make && make install

———————————————————————————
貌似这个svn提供的版本有问题,会出现
sapi/fpm/fpm/fpm_main.o:In function ‘main’:/software/php-5.3.2/sapi/fpm/fpm/fpm_main.c:1668:undefined reference to ‘php_output_end_all’/software/php-5.3.2/sapi/fpm/fpm/fpm_main.c:1669:undefined reference to ‘php_output_deactivate’sapi/fpm/fpm/fpm_main.o:In function ‘zif_fastcgi_finish_request’:/software/php-5.3.2/sapi/fpm/fpm/fpm_main.c:1496:undefined reference to ‘php_output_end_all’collect2:ld returned 1 exit statusmake:***[sapi/fpm/php-fpm] Error 1

解决方法是:
把svn换到
svn co http://svn.php.net/repository/php/php-src/branches/PHP_5_3/sapi/fpm sapi/fpm;

———————————————————————————

记着加入–enable-fpm 编译参数。

安装后,php-fpm 位于/usr/local/webserver/php/sbin/php-fpm

配置文件位于/usr/local/webserver/php/etc/php-fpm.conf

需要说明的是配置文件内容变了,原来张宴的不对了。
我共享下我的,我是菜鸟,弄的不好,大家将就吧,反正能运行。
/usr/local/webserver/php/etc/php-fpm.conf
;;;;;;;;;;;;;;;;;;;;;
; FPM Configuration ;
;;;;;;;;;;;;;;;;;;;;;
 
; All relative paths in this configuration file are relative to PHP's install
; prefix.
 
; Include one or more files. If glob(3) exists, it is used to include a bunch of
; files from a glob(3) pattern. This directive can be used everywhere in the
; file.
;include=/usr/local/webserver/php/etc/fpm.d/*.conf
 
;;;;;;;;;;;;;;;;;;
; Global Options ;
;;;;;;;;;;;;;;;;;;
 
[global]
; Pid file
; Default Value: none
pid = /usr/local/webserver/php/var/run/php-fpm.pid
 
; Error log file
; Default Value: /usr/local/webserver/php/var/log/php-fpm.log
error_log = /usr/local/webserver/php/var/log/php-fpm.log
 
; Log level
; Possible Values: alert, error, warning, notice, debug
; Default Value: notice
;log_level = notice
 
; If this number of child processes exit with SIGSEGV or SIGBUS within the time
; interval set by emergency_restart_interval then FPM will restart. A value
; of '0' means 'Off'.
; Default Value: 0
;emergency_restart_threshold = 0
 
; Interval of time used by emergency_restart_interval to determine when
; a graceful restart will be initiated.  This can be useful to work around
; accidental corruptions in an accelerator's shared memory.
; Available Units: s(econds), m(inutes), h(ours), or d(ays)
; Default Unit: seconds
; Default Value: 0
;emergency_restart_interval = 0
 
; Time limit for child processes to wait for a reaction on signals from master.
; Available units: s(econds), m(inutes), h(ours), or d(ays)
; Default Unit: seconds
; Default Value: 0
;process_control_timeout = 0
 
; Send FPM to background. Set to 'no' to keep FPM in foreground for debugging.
; Default Value: yes
;daemonize = yes
 
;;;;;;;;;;;;;;;;;;;;
; Pool Definitions ;
;;;;;;;;;;;;;;;;;;;;
 
; Multiple pools of child processes may be started with different listening
; ports and different management options.  The name of the pool will be
; used in logs and stats. There is no limitation on the number of pools which
; FPM can handle. Your system will tell you anyway :)
 
; Start a new pool named 'www'.
[www]
 
; The address on which to accept FastCGI requests.
; Valid syntaxes are:
;   'ip.add.re.ss:port'    - to listen on a TCP socket to a specific address on
;                            a specific port;
;   'port'                 - to listen on a TCP socket to all addresses on a
;                            specific port;
;   '/path/to/unix/socket' - to listen on a unix socket.
; Note: This value is mandatory.
listen = 127.0.0.1:9000
 
; Set listen(2) backlog. A value of '-1' means unlimited.
; Default Value: -1
;listen.backlog = -1
 
; List of ipv4 addresses of FastCGI clients which are allowed to connect.
; Equivalent to the FCGI_WEB_SERVER_ADDRS environment variable in the original
; PHP FCGI (5.2.2+). Makes sense only with a tcp listening socket. Each address
; must be separated by a comma. If this value is left blank, connections will be
; accepted from any ip address.
; Default Value: any
listen.allowed_clients = 127.0.0.1
 
; Set permissions for unix socket, if one is used. In Linux, read/write
; permissions must be set in order to allow connections from a web server. Many
; BSD-derived systems allow connections regardless of permissions.
; Default Values: user and group are set as the running user
;                 mode is set to 0666
;listen.owner = nobody
;listen.group = nobody
;listen.mode = 0666
 
; Unix user/group of processes
; Note: The user is mandatory. If the group is not set, the default user's group
;       will be used.
user = nobody
group = nobody
 
; Choose how the process manager will control the number of child processes.
; Possible Values:
;   static  - a fixed number (pm.max_children) of child processes;
;   dynamic - the number of child processes are set dynamically based on the
;             following directives:
;             pm.max_children      - the maximum number of children that can
;                                    be alive at the same time.
;             pm.start_servers     - the number of children created on startup.
;             pm.min_spare_servers - the minimum number of children in 'idle'
;                                    state (waiting to process). If the number
;                                    of 'idle' processes is less than this
;                                    number then some children will be created.
;             pm.max_spare_servers - the maximum number of children in 'idle'
;                                    state (waiting to process). If the number
;                                    of 'idle' processes is greater than this
;                                    number then some children will be killed.
; Note: This value is mandatory.
pm = dynamic
 
; The number of child processes to be created when pm is set to 'static' and the
; maximum number of child processes to be created when pm is set to 'dynamic'.
; This value sets the limit on the number of simultaneous requests that will be
; served. Equivalent to the ApacheMaxClients directive with mpm_prefork.
; Equivalent to the PHP_FCGI_CHILDREN environment variable in the original PHP
; CGI.
; Note: Used when pm is set to either 'static' or 'dynamic'
; Note: This value is mandatory.
pm.max_children = 50
 
; The number of child processes created on startup.
; Note: Used only when pm is set to 'dynamic'
; Default Value: min_spare_servers + (max_spare_servers - min_spare_servers) / 2
pm.start_servers = 20
 
; The desired minimum number of idle server processes.
; Note: Used only when pm is set to 'dynamic'
; Note: Mandatory when pm is set to 'dynamic'
pm.min_spare_servers = 5
 
; The desired maximum number of idle server processes.
; Note: Used only when pm is set to 'dynamic'
; Note: Mandatory when pm is set to 'dynamic'
pm.max_spare_servers = 35
 
; The number of requests each child process should execute before respawning.
; This can be useful to work around memory leaks in 3rd party libraries. For
; endless request processing specify '0'. Equivalent to PHP_FCGI_MAX_REQUESTS.
; Default Value: 0
pm.max_requests = 500
 
; The URI to view the FPM status page. If this value is not set, no URI will be
; recognized as a status page. By default, the status page shows the following
; information:
;   accepted conn    - the number of request accepted by the pool;
;   pool             - the name of the pool;
;   process manager  - static or dynamic;
;   idle processes   - the number of idle processes;
;   active processes - the number of active processes;
;   total processes  - the number of idle + active processes.
; The values of 'idle processes', 'active processes' and 'total processes' are
; updated each second. The value of 'accepted conn' is updated in real time.
; Example output:
;   accepted conn:   12073
;   pool:             www
;   process manager:  static
;   idle processes:   35
;   active processes: 65
;   total processes:  100
; By default the status page output is formatted as text/plain. Passing either
; 'html' or 'json' as a query string will return the corresponding output
; syntax. Example:
;   http://www.foo.bar/status
;   http://www.foo.bar/status?json
;   http://www.foo.bar/status?html
; Note: The value must start with a leading slash (/). The value can be
;       anything, but it may not be a good idea to use the .php extension or it
;       may conflict with a real PHP file.
; Default Value: not set
;pm.status_path = /status
 
; The ping URI to call the monitoring page of FPM. If this value is not set, no
; URI will be recognized as a ping page. This could be used to test from outside
; that FPM is alive and responding, or to
; - create a graph of FPM availability (rrd or such);
; - remove a server from a group if it is not responding (load balancing);
; - trigger alerts for the operating team (24/7).
; Note: The value must start with a leading slash (/). The value can be
;       anything, but it may not be a good idea to use the .php extension or it
;       may conflict with a real PHP file.
; Default Value: not set
;ping.path = /ping
 
; This directive may be used to customize the response of a ping request. The
; response is formatted as text/plain with a 200 response code.
; Default Value: pong
;ping.response = pong
 
; The timeout for serving a single request after which the worker process will
; be killed. This option should be used when the 'max_execution_time' ini option
; does not stop script execution for some reason. A value of '0' means 'off'.
; Available units: s(econds)(default), m(inutes), h(ours), or d(ays)
; Default Value: 0
;request_terminate_timeout = 0
 
; The timeout for serving a single request after which a PHP backtrace will be
; dumped to the 'slowlog' file. A value of '0s' means 'off'.
; Available units: s(econds)(default), m(inutes), h(ours), or d(ays)
; Default Value: 0
;request_slowlog_timeout = 0
 
; The log file for slow requests
; Default Value: /usr/local/webserver/php/var/log/php-fpm.log.slow
;slowlog = /usr/local/webserver/php/var/log/php-fpm.log.slow
 
; Set open file descriptor rlimit.
; Default Value: system defined value
;rlimit_files = 1024
 
; Set max core size rlimit.
; Possible Values: 'unlimited' or an integer greater or equal to 0
; Default Value: system defined value
;rlimit_core = 0
 
; Chroot to this directory at the start. This value must be defined as an
; absolute path. When this value is not set, chroot is not used.
; Note: chrooting is a great security feature and should be used whenever
;       possible. However, all PHP paths will be relative to the chroot
;       (error_log, sessions.save_path, ...).
; Default Value: not set
;chroot = 
 
; Chdir to this directory at the start. This value must be an absolute path.
; Default Value: current directory or / when chroot
;chdir = /var/www
 
; Redirect worker stdout and stderr into main error log. If not set, stdout and
; stderr will be redirected to /dev/null according to FastCGI specs.
; Default Value: no
;catch_workers_output = yes
 
; Pass environment variables like LD_LIBRARY_PATH. All $VARIABLEs are taken from
; the current environment.
; Default Value: clean env
;env[HOSTNAME] = $HOSTNAME
;env[PATH] = /usr/local/bin:/usr/bin:/bin
;env[TMP] = /tmp
;env[TMPDIR] = /tmp
;env[TEMP] = /tmp
 
; Additional php.ini defines, specific to this pool of workers. These settings
; overwrite the values previously defined in the php.ini. The directives are the
; same as the PHP SAPI:
;   php_value/php_flag             - you can set classic ini defines which can
;                                    be overwritten from PHP call 'ini_set'.
;   php_admin_value/php_admin_flag - these directives won't be overwritten by
;                                     PHP call 'ini_set'
; For php_*flag, valid values are on, off, 1, 0, true, false, yes or no.
 
; Defining 'extension' will load the corresponding shared extension from
; extension_dir. Defining 'disable_functions' or 'disable_classes' will not
; overwrite previously defined php.ini values, but will append the new value
; instead.
 
; Default Value: nothing is defined by default except the values in php.ini and
;                specified at startup with the -d argument
;php_admin_value[sendmail_path] = /usr/sbin/sendmail -t -i -f www@my.domain.com
;php_flag[display_errors] = off
;php_admin_value[error_log] = /var/log/fpm-php.www.log
;php_admin_flag[log_errors] = on
;php_admin_value[memory_limit] = 32M
<pre>修改好后运行 /usr/local/webserver/php/sbin/php-fpm -c /usr/local/webserver/php/etc/php-fpm.conf
 
其他和张宴说的差不多 。
有什么问题欢迎交流啊

http://fw.qq.com/ipaddress

ip查询,地址库很重要,话说腾讯的IP地址库还是比较准确的,每个QQ用户发现自己匹配的地理位置信息不准确都可以提交更正的

全部调用

  1. <script type=text/javascript src=http://fw.qq.com/ipaddress></script>
  2. <script type=text/javascript>
  3. document.write(IPData.join(’ ‘));
  4. </script>

复制代码

效果:xxx.xxx.xxx.xxx  某某省 某某市
只调用地理位置

  1. <script type=text/javascript src=http://fw.qq.com/ipaddress></script>
  2. <script type=text/javascript>
  3. document.write(IPData[2]);document.write(IPData[3]);
  4. </script>

复制代码

效果:某某省 某某市

另外我更换了页面导航,估计是js有点问题,还得修改下。

超级简单

GRANT ALL PRIVILEGES ON wp.* TO ‘iyaya’@'127.0.0.1′ IDENTIFIED BY ‘mypass’;

http://blog.s135.com/nginx_php_v5/

针对以上文章做一些补充。

适应于php5.3 、php5.3.1
1.许多软件的安装如果不是很了解,建议还是使用yum install 来安装。

2.eaccelerator 如果你是和php-5.3以上版本配合,请下载最新版

3.mysql 切记使用 mysql 用户初始化数据库,就是执行/usr/local/webserver/mysql/bin/mysql_install_db –basedir=/usr/local/webserver/mysql –datadir=/data0/mysql/3306/data –user=mysql

4.my.cnf可以从你下载的源里拷贝一个。在support-files 目录下

5.php-fpm 新版已经改变了,需要先安装最新版的libevent,autoconf 使用2.13版。如果使用yum 安装,会生成autoconf213 而不是autoconf,自己ln 下。

6.php 编译参数–disable-rpath 一定要去除,否则会遇到PHP报错:char *… configure: error: cannot compute sizeof (char *), 77 。至于原因,我也没搞明白。

这些参数5.3.1 不再需要了

–enable-discard-path
–enable-fastcgi
–enable-fpm
–enable-force-cgi-redirect
7.cp php.ini-production 这里可以拷贝产品配置和开发配置 cp php.ini-development

8.新版的php-fpm 配置文件在/etc/php-fpm 命令在/etc/ini.d/php-fpm 需要注意的是这个默认启动文件需要修改下里边的pid ,修改为你指定的就可以了。

9.最后可以使用yum install vsftpd 安装个ftp。

大约就这些了,其他的没有了。
10.需要查yum 包的安装位置请使用 rpm -ql 包名  比如 查autoconf213 rpm -ql autoconf213

11.libevent php-fpm 需要  >1.4.11 的版本,yum 安装的是旧版本,需要手动编译啊。

12.cyrus-sasl-ldap 这个东西,可能也需要,其实大部分用不到,不知道为什么php5.31 需要。 另需要安装cyrus-sasl-devel 开发包

中国移动:
134、135、136、137、138、139、150、158、159、157(TD-SCDMA专属号段)、187、188
中国联通:
130、131、132、156、185、186
中国电信:
133、153、180、189

最近这两天,光折腾excel 了,还有word 表格,似乎办公室的工作就是做表格,说几个我用到的方法。

1:挑选出excel表格中重复的姓名

最简单的方法是排序,把相同的姓名排到一块。需要注意的是要选择所有的数据,这样不会因为排序某一列,导致其他数据不一致。另外一些新手(我也犯了同样的错误)会出现不能排序,原因是不能选择表头。

2:另外计算列最好用公式,这样修改数据后会自动更改。

3:word 表格

word表格还是最简单的,使用的时候,最好手动设置高度,宽度,这样不会造成表格的混乱,新手喜欢手动拖动,耗时,费力。

4:下一步学习,如果让word ,excel自动执行操作。知道的童鞋告诉我声,先谢谢了。

that5上看到个不错的网站,说明,多浏览别人网站是有益身心的。

地址是:

http://internetsupervision.com/scripts/urlcheck/check.aspx?checkurl=ehome.com.ru

把后边的ehome.com.ru 换成你的网址就可以了。

我网站的全球浏览速度。遗憾的是发现澳大利亚不能访问。

用了firefox3.5后,感觉爽啊,那速度,那体验。

用了卡巴2010 ,没感觉,还行吧。

安装firebug 后,发现个奇怪的现象,firebug 一直显示重启后安装,重启n次也没有安装,不知是什么问题。分析了下,大约是插件冲突。

观察了半天,发现卡巴2010 自动装的Kaspersky URL Advisor ,是不是这个,禁用后,不行,又自动启动。干脆卸载。重启后,firebug 可以了。

解决了,就是禁用卡巴的插件,以后钓鱼网站就不好发现了。

8.5 更新

包含 7 8 9 key 和激活码.

下载地址:

http://cn.ziddu.com/download/364860/key.rar.html

封一个,换一个。2010 的激活码

3SU15-S4AES-P5XRQ-87AKV

3T6XS-GY8U1-W1JTR-9XAE1

3TK3J-6T1TN-X3XGP-HUZRN

3TZV1-Z5F9W-DXBWX-Q1KDA

以上激活码没有啥用,主要作用是用于打开授权文件输入窗口。

具体看这里http://bbs.kpchina.net/thread-121572-1-1.html

2009.7.30 更新,卡巴2010key。失效

http://cn.ziddu.com/download/361779/KAV9-2010.05.03-034C715D.rar.html