deepseabug.blogspot.com
Deep Sea Bug: 四月 2008
http://deepseabug.blogspot.com/2008_04_01_archive.html
首先在SourceForge上下载mhash和mcrypt (mcrypt要下载Libmcrypt和mcrypt两个包). Tar zxvf mhash-0.9.9.tar.gz. Cd mhash-0.9.9. Tar zxvf libmcrypt-2.5.8.tar.gz. Cd libmcrypt-2.5.8. 直接configure报错:configure: error: "You need at least libmhash 0.8.15 to compile this program. http:/ mhash.sf.net/". 由于先前安装了mhash,多半是没有找到mhash的lib文件的路径,修改LD LIBRARY PATH:. Cd mcrypt-2.6.4. LD LIBRARY PATH=/usr/local/lib ./configure. Configure - with-mcrypt[=DIR] - with-mhash[=DIR]. 标签: Bug Server. 订阅: 帖子 (Atom). 9758;Bug‘s Link.
deepseabug.blogspot.com
Deep Sea Bug: 六月 2007
http://deepseabug.blogspot.com/2007_06_01_archive.html
一个PHPWind的论坛,登录mysql数据库报错:Didn't find any fields in table 'pw tmsgs'. 这个问题是由于客户端(client)没有正常关闭造成的(看来以后mysql服务死了后不能随便用Kill了,危险啊). Root# /data/app/mysql/bin/myisamchk - recover. Myisamchk: Disk is full writing '/data/app/mysql/data/bbs/pw tmsgs.TMD' (Errcode: 28). Make sure you have at least 2 times the amount of free disk space in your mysql data partition as the size of the table you are repairing. 一检查/data目录已经满了,汗,全被bbs的错误日志占满了,清空日志,重新执行命令,顺利通过。Web又访问正常了. Q (- quick) 快速修复,仅修复索引. 标签: Bug Database.
deepseabug.blogspot.com
Deep Sea Bug: 八月 2008
http://deepseabug.blogspot.com/2008_08_01_archive.html
自从Apache2.2出来后,apache开始支持proxy-ajp.大家知道Apache里的proxy模块,可以实现双向代理功能,功能非常强大。其实从连接器的实现原理上来说,用proxy模块来实现是非常自然的。proxy模块的功能无非就是把相关的请求发给特定的主机再返回结果。那连接器的功能需求就是要把所有对Servlet/JSP的请求都转给后台的Tomcat。 Jdk-1 5 0 09-linux-i586.bin. Apache-tomcat-5.5.26.tar.gz. Httpd-2.2.9.tar.gz. Jdk-1 5 0 09-linux-i586.bin. Ln -s /usr/local/jdk1.5.0 09 java. 修改/data/app/tomcat/bin/catalina.sh,在开始添加一行:. 修改/data/app/tomcat/bin/startup.sh和shutdown.sh,添加java环境变量:. Tar zxvf httpd-2.2.9.tar.gz. Cd httpd-2.2.9. BalancerMember ajp:/ localhost:1200...
deepseabug.blogspot.com
Deep Sea Bug: 三月 2008
http://deepseabug.blogspot.com/2008_03_01_archive.html
MySQL同步故障:" Slave SQL Running:No". 今天检查数据库发现一台MySQL Slave未和主机同步,查看Slave状态:. Mysql show slave status G. Slave IO Running: Yes. Slave SQL Running: No. Mysql show master status;. File Position Binlog Do DB Binlog Ignore DB. 1 row in set (0.00 sec). Mysql change master to. Master host='master ip',. Master log file='mysql-bin.000020',. Master log pos=135617781;. 1 row in set (0.00 sec). Mysql slave start;. 1 row in set (0.00 sec). Slave IO Running: Yes. Slave SQL Running: Yes. Seconds Behind Master: 0.
deepseabug.blogspot.com
Deep Sea Bug: 十二月 2007
http://deepseabug.blogspot.com/2007_12_01_archive.html
Oracle 9i在RH Linux AS4 x86 64上的Segmentation fault. 在RH Linux AS4 x86 amd64正常安装好Oracle 9i后使用tnsping,sqlplus等命令全部报segmentation fault. Subject: Segmentation Fault When Execute Sqlplus, Oracle, Lsnrctl After New/Patchset Install. Doc ID: Note:316746.1 Type: PROBLEM. Last Revision Date: 28-APR-2006 Status: MODERATED. This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. Usr/bin/...
deepseabug.blogspot.com
Deep Sea Bug: 使用DBLINK创建oracle数据库链接
http://deepseabug.blogspot.com/2008/03/dblinkoracle.html
SQL SELECT * FROM GLOBAL NAME;. SQL ALTER SYSTEM SET GLOBAL NAME=TRUE/FALSE;. I当数据库参数global name=false时,就不要求数据库链接名称跟远端数据库名称一样。 CREATE [PUBLIC] DATABASE LINK link. CONNECT TO username IDENTIFIED BY password. USING ‘connectstring’. Oracle3 sql select id,name from table1@oracle4;. 注意:创建数据库链接的帐号必须有CREATE DATABASE LINK或CREATE PUBLIC DATABASE LINK的系统权限,用来登录到远程数据库的帐号必须有CREATE SESSION权限。这两种权限都包含在CONNECT角色中(CREATE PUBLIC DATABASE LINK权限在DBA中)。 SQL select * from global name;. SQL conn / as sysdba.
deepseabug.blogspot.com
Deep Sea Bug: 整合Apache2.2和Tomcat5.5
http://deepseabug.blogspot.com/2008/08/apache22tomcat55.html
自从Apache2.2出来后,apache开始支持proxy-ajp.大家知道Apache里的proxy模块,可以实现双向代理功能,功能非常强大。其实从连接器的实现原理上来说,用proxy模块来实现是非常自然的。proxy模块的功能无非就是把相关的请求发给特定的主机再返回结果。那连接器的功能需求就是要把所有对Servlet/JSP的请求都转给后台的Tomcat。 Jdk-1 5 0 09-linux-i586.bin. Apache-tomcat-5.5.26.tar.gz. Httpd-2.2.9.tar.gz. Jdk-1 5 0 09-linux-i586.bin. Ln -s /usr/local/jdk1.5.0 09 java. 修改/data/app/tomcat/bin/catalina.sh,在开始添加一行:. 修改/data/app/tomcat/bin/startup.sh和shutdown.sh,添加java环境变量:. Tar zxvf httpd-2.2.9.tar.gz. Cd httpd-2.2.9. BalancerMember ajp:/ localhost:1200...
deepseabug.blogspot.com
Deep Sea Bug: MySQL同步故障:" Slave_SQL_Running:No"
http://deepseabug.blogspot.com/2008/03/mysql-slavesqlrunningno.html
MySQL同步故障:" Slave SQL Running:No". 今天检查数据库发现一台MySQL Slave未和主机同步,查看Slave状态:. Mysql show slave status G. Slave IO Running: Yes. Slave SQL Running: No. Mysql show master status;. File Position Binlog Do DB Binlog Ignore DB. 1 row in set (0.00 sec). Mysql change master to. Master host='master ip',. Master log file='mysql-bin.000020',. Master log pos=135617781;. 1 row in set (0.00 sec). Mysql slave start;. 1 row in set (0.00 sec). Slave IO Running: Yes. Slave SQL Running: Yes. Seconds Behind Master: 0.
deepseabug.blogspot.com
Deep Sea Bug: 二月 2008
http://deepseabug.blogspot.com/2008_02_01_archive.html
1在 运行 中 cmd后依次执行:. Regsvr32 /u softpub.dll. Regsvr32 /u wintrust.dll. Regsvr32 /u initpki.dll. Regsvr32 /u dssenh.dll. Regsvr32 /u rsaenh.dll. Regsvr32 /u gpkcsp.dll. Regsvr32 /u sccbase.dll. Regsvr32 /u slbcsp.dll. Regsvr32 /u mssip32.dll. Regsvr32 /u cryptdlg.dll. 3再次在“运行”中执行:. 标签: Bug Windows. 以前介绍了个用Your Freedom访问被GFW阻挡的网站(当然包括我们的Blogspot了),今天发现一个超简单的方法来直接访问Blogspot:修改hosts! 7214219.190 deepseabug.blogspot.com. 7214219.190 ddmmc.blogspot.com. The following lines are desirable for IPv6 capable hosts.