第二次调试 OpenIPMP并初步成功的记录

      2010-07-22   18:00:44  rene

       因为是新手，所以耐住性子，删除上一次的VMware Ubuntu虚拟机文件，重新开始。

VMware6.5+Ubuntu10.04 安装：

从同事那里要来VMware和Ubuntu10.04安装文件，然后空出F盘空间，尽量最大化。
==========================================
首先是新建虚拟机(Ctrl+N)
-> 选择自定义安装(Custom(advanced))，接着选择 Workstation6.5
-> 选择稍后安装 I will install the operating system later
-> 选择Linux Ubuntu
-> 设置虚拟机名: Ubuntu ,安装目录F:/Ubuntu
选择 处理器个数为 One，设定内存为 512M，选择网络连接为 NAT, 适配器为LSI Logic，Disk为Create a new virtual disk,虚拟盘类型位SCSI，最大盘容量为38G，并分离成2GB大小，名称为Ubuntu.vmdk
->完成会提示一个DHCP相关的界面，此时我关闭Ubuntu裸机。

为什么选择NAT，是因为"本地连接 状态"->"支持"中“地址类型：通过DHCP指派”
===========================================

3.在启动这个虚拟机之前还要配置。首先当然和装Windows类似，设定从光驱启动，因此在启动方式里面选择光驱，然后把下载的Ubuntu Linux镜像选中，这样一会开机就是从光盘启动了。网络设置，我的Windows XP本身是处在局域网内DHCP分配的，其实这里用Host-only还是NAT都行，我两个都试过最后都有上网。如果选择是Host-only，那么以后Linux中用到的网络连接是VMnet1,如果是NAT，则用到VMnet8。不管选择的是哪个，都必须在Windows下的本地连接中做如下设置，记住，是"本地连接"。右键－属性－高级，然后将“Internet连接共享”勾上，在下面的"家庭网络连接"中根据你选择的类型进行选择。即Host-only对应VMnet1,NAT对应VMnet8。然后确定，这里会弹出一个警告说你的IP会被强制改为192.168.0.1什么的，不要管它，确定。最后配置给这个虚拟机分配的内存，因为我Windows下有768MB的内存，所以我就分配给它300MB先用。OK，到此基本设置完毕。
-----------------------------------------
如果你是家庭adsl的用户（使用DHCP上网），那么就选择“使用网络地址翻译（NAT）”，这样只要宿主机可以上网，虚拟机不用特殊设置（Ubuntu默认开启DHCP服务）就可以共享宿主机的网络。我的网络环境就是adsl，自然选它；
===========================================然后Power On，选择简体中文，安装Ubuntu，设置键盘USA，姓名为rene，登录名rene，密码rene0769，计算机名称为rene-Ubuntu，再一路安装到底。
安装完成后会提示重启，重启到后面会提示对话框，选择YES，然后双击编辑VMware窗口的右下角光驱图标，把连接从“使用ISO镜像”改为“使用物理驱动器”，确定后点进虚拟机窗口，按回车继续重启
=========================================== 

 j2sdk_1.4.2_10安装：

http://java.sun.com/products/archive/index.html
java.sun.com/products/archive/j2se/1.4.2_10/index.html
bin档案就是安装档案，j2se就是j2sdk和j2re合并称呼，在该网页下面分别下载
j2sdk-1_4_2_10-linux-i586.bin
j2re-1_4_2_10-linux-i586.bin

两个安装步骤相同，只描述一个
shell>> sudo -i
shell>> cd  /usr/lib/
shell>> ls -a
shell>> mkdir jvm
shell>> cd jvm
shell>> mkdir SunJDK
shell>> cp /home/rene/下载/j2sdk-1_4_2_10-linux-i586.bin  /usr/lib/jvm/SunJDK
shell>> chmod +x j2sdk-1_4_2_10-linux-i586.bin
shell>> ./j2sdk-1_4_2_10-linux-i586.bin
=====================================
一路按住enter，后来输入yes，发生了问题：
Do you agree to the above license terms? [yes or no]
yes
Unpacking...
tail: cannot open `+511' for reading: No such file or directory
Checksumming...
1
The download file appears to be corrupted. Please refer
to the Troubleshooting section of the Installation
Instructions on the download page for more information.
Please do not attempt to install this archive file.
=======================================================
shell>> export _POSIX2_VERSION=199209
shell>> ./j2sdk-1_4_2_10-linux-i586.bin
安装完成

 

 MySQL 4.1.24安装

 
**********************************************************
因为：
“checking for termcap functions library... configure: error: No curses/termcap library found”
所以要下载ncurses安装包
apt-cache search ncurses
apt-get install libncurses5-dev
**********************************************************
因为：
“../depcomp: line 571: exec: g++: 未找到
make[1]: *** [my_new.o] 错误 127”
所以要下载g++，但是Ubuntu包下载策略不清楚，怕后面诸多链接设置，直接使用“新立得”安装好了

附录：
     sudo apt-get install g++
g++默认一般就是"二进制文件/usr/bin下,库/usr/lib下,头文件/usr/include下"
建议如果你手工编译安装,安装在/usr/local下
如果有需要做符号链接对应到/usr/lib /usr/bin /usr/lib下
**********************************************************
因为：
“make[2]: *** [install-benchSCRIPTS] Error 1”
所以，删除原先复制到/usr/local目录中的安装包和解压缩文件夹，直接在/rene/down中解压缩安装。

rm /usr/local/mysql        -->消除快捷方式
rm  -rf /usr/local/mysql   -->删除目录及内部文件
附录：

安装MySQL时出错：make[2]: *** [install-benchSCRIPTS..
如果只是sql-bench的问题，可以在configure的时候加上--without-bench参数，不过我觉得是
“将产生mysql-3.23.32目录移到/usr/local/mysql
mv mysql-3.23.32 /usr/local/mysql ”
这里的问题，不用移动这个目录，直接在这个目录下make和make install就可以了，安装的时候会自动生成/usr/local/mysql目录的，我估计是因为sql-bench目录已经存在在/usr/local/mysql下了，所以在安装的时候回出现问题
**********************************************************
因为要添加SQL开机启动，所以要安装sysv-rc-conf，设置mysql为等级3和5，是一般的缺省设置。

 

增添一个登陆用户和组
shell> groupadd mysql
shell> useradd -g mysql mysql
**********************************************************
从下列网站下载安装源码包MySQL4.1，官网只有5.0以上的。
http://linux.softpedia.com/progDownload/MySQL-download-2323.html
http://mirror.provenscaling.com/mysql/community/source/4.1
**********************************************************
shell> sudo -i                                    # 切换到root用户
shell> cd  /home/rene/down                        # 进入mysql-4.1.24.tar.gz目录
shell> ls -a
shell> gunzip < mysql-4.1.24.tar.gz | tar -xvf -  # 解压缩
shell> ls -a
shell> cd mysql-4.1.24
shell> chmod +x configure                         # 配置和编译给configure分配可执行文件,configure命令本身会生成make所需要的makefile
shell> ./configure --prefix=/usr/local/mysql --with-charset=gbk --with-extra-charsets=all
            --with-named-curses-libs=/usr/lib/libncurses.so.5 
shell> make
shell> make install                               # 安装所有东西

# 如果你想安装选项文件，使用当前存在的‘support-files’ 文件夹下的作为模板
shell> cd support-fils
shell> ls -a
shell> cd ..
shell>
shell> cp support-files/my-medium.cnf /etc/my.cnf

# 如果想mysqld每次开机自动启动的话
shell> cp -r support-files/mysql.server /etc/init.d/mysql
shell> cd /etc
shell> ls -a
shell> cd init.d
shell> ls -a
shell> chmod +x mysql
shell> sysv-rc-conf           #找到mysql，选中3和5，按q退出。

#进入安装目录
shell> cd /usr/local/mysql
shell> ls -a

#如果你以前没有安装过MySQL，你必须创建一个MySQL准许的表，注意这是后来加的，当时没有执行这个命令
#进行数据库的初始化，如果没有出现问题则数据库安装完毕。
shell> bin/mysql_install_db --user=mysql

# 将程序的所有权限给‘root’ ，并且把数据目录的所有权给可以运行‘mysqld’的用户。假设MySQL的安装目# 录是（‘/usr/local/mysql’），命令如下所示：
shell> chown -R root  .    # 改当前目录的捅有者为root。注意，最后有个 . 啊，表示当前目录 
shell> chown -R mysql var  # 把数据目录拥护权给‘mysql’用户
shell> chgrp -R mysql .    # 把组的权限给'mysql'组
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> chown -R root  .
shell> chown -R mysql var

#按照下面的命令测试并运行你的MySQL了：
shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &
         [1] 17208
         root@rene-Ubuntu:/usr/local/mysql#nohup:ignoring input and redirecting stderr to stdout
         starting mysqld daemon with databases from /usr/local/mysql/var
shell> service mysql start
         /ect/init.d/mysql: 73: source: not found
         starting MySQL
         ect/init.d/mysql: 256: log_success_msg: not found

# 在一切正常后，要做的第一件事情是更改管理员的密码。你可以运行mysqladmin
#（请注意，此命令不一定在你的path中，所以最好是转到此命令的目录中直接执行）：
shell> cd bin
shell> ./mysqladmin -u root password rene0769

#12.运行其他用户访问本机：
shell> ./mysql -u root -p mysql
         Welcome to the MySQL monitor. Commands end with ; or /g.
         Your MySQL connection id is 2 to server version: 1.1.24-log
         Type 'help;' or'/h'for help . Type '/c' to clear the buffer
         mysql> update user set host='' where host='localhost' and user='root';
         ERROR 1046(3D000): No database selected
         mysql> exit
         Bye

#修改mysql数据库端口号
shell> vi /etc/my.cnf  #端口号3306,按“:q!”强制退出vi

#重启应用
shell> service mysql restart
/etc/init.d/mysql: 73: source: not found
/etc/init.d/mysql: 73: source: not found
Shutting down MySQL
...STOPPING server from pid file /usr/local/mysql/var/rene-Ubuntu.pid
100175 20:59:30  mysql ended

/etc/init.d/mysql: 256: log_success_msg: not found
/etc/init.d/mysql: 73: source: not found
Starting MySQL
/etc/init.d/mysql: 256: log_success_msg: not found
[1]+  Done    /usr/local/mysql/bin/mysqld_safe --user=mysql (wd: /usr/local/mysql)
(wd now: /usr/local/mysql/bin)

 

jboss 4.0.2 安装

google  "jboss 4.0.2" 找到SourceForge的下载网站
http://blog.chinaunix.net/u2/68079/showart_692355.html 下载资料
http://topic.csdn.net/t/20050903/20/4247974.html

http://sourceforge.net/projects/jboss/files/JBoss/JBoss-4.0.2/jboss-4.0.2.zip/download

shell>sudo -i
shell>cd /home/rene/down
shell>ls -a
shell> gunzip < mysql-4.0.2.tar.gz | tar -xvf -

gzip:stdin: unexpected end of file
tar: 归档文件中异常的 EOF
tar: 归档文件中异常的 EOF
tar: 错误不可恢复：现在退出
shell> rm -rf ./jboss-4.0.2
重新下载

shell> gunzip < mysql-4.0.2.tar.gz | tar -xvf -
shell> ls -a
shell> mv ./mysql-4.0.2   /usr
安装完成

 openIPMP2安装：

 

    这一步不算完成，应该包含mysql完整配置过程以及创建用户、数据库和数据库表完整过程，JBoss完整配置过程，jdbc安装以及JBoss与MySQL数据库连接过程，特别是后面jboss相关内容，还需要深入查找资料和配置。

 

 安装前，应该首先安装好J2SE，再安装MySQL，最后安装JBoss。
----------------------------------------------------------
需要注意的是，j2SE使用的是bin档案，在哪里执行就安装在哪里，所以必须复制到 /usr/lib/jvm/SunJDK目录下；
              MySQL下载的是源码编译安装的tar.gz文件，在down目录下运行 ./config --prefix=/usr/local/mysql [其它选项]和make编译后运行make install，就会在/usr/local/创建mysql。
----------------------------------------------------------
设置完PATH，需要reboot重启操作系统再继续安装。
必须集中在一个地方修改Path，建议是/etc/environment,而非/etc/profile和.bashrc文件
----------------------------------------------------------
设置完环境变量，JBoss与MySLQ还必须进行连接才是完整的JAVA环境。
==============================================================

# 前面三个都是直接安装，没有进行环境变量设置过，这里还是查看一下

shell> echo $PATH

# ===============================================================
# /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
# 设置J2SE/MySQL/JBoss的环境变量，直接设置在environment里面，其它不动了。
# ===============================================================

shell> sudo -i
shell> gedit /etc/profile

# ===============================================================
# /etc/environment用的少，系统环境设置，开机时运行一次，很关键，还是不用了。
# /etc/profile    用得多，用户环境设置，那个账户登录时执行一次，影响小一些。
# .bashrc         多有提及，它是在shell启动时启动，每次打开控制台每次调用它。
# 各个环境变量设置文件对比时，最关键的还是要明确该文件执行时间和顺序，如此区分各自功能。
# 为了统一处理，就只设置profile了，设置完成后要重启重新登录，至于source /etc/profile不用了。
# 在 profile文件末尾，umask 022之前加入：
# ===============================================================
# set java environment
# export JAVA_HOME="/usr/lib/jvm/SunJDK/j2sdk1.4.2_10"
# export CLASSPATH=".:$JAVA_HOME/lib:$JAVA_HOME/jre/lib"
# export PATH="$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH"
# set JBoss environment
# export JBOSS_HOME="/usr/jboss-4.0.2"
# export PATH="$PATH:$JBOSS_HOME/bin:$JAVA_HOME/jre/bin"
# ===============================================================
# umask 022一行，保持原文不管它，保存关闭。
# ===============================================================

shell> reboot

# ===============================================================
# 忘记设置mysql了，登录后，重新在控制台中设置。
# 设置后，再直接开启SQL，不用再进入/usr/locla/mysql/bin目录。
# ===============================================================

shell> sudo -i

# ===============================================================
# 紧随上次设置语句之后，umask 022 之前输入，再关闭：
# ===============================================================
# set MySQL environment
# export PATH="$PATH:/usr/local/mysql/bin"
# ===============================================================

shell> reboot

# ===============================================================
# 下一步应该是将JBoss与MySQL连接起来
# ===============================================================

shell> sudo -i
shell> which java

# ===============================================================
#     /usr/lib/jvm/SunJDK/j2sdk1.4.2_10/bin/java
# ===============================================================

shell> which mysql

# ===============================================================
#     /usr/local/mysql/bin/mysql
# ===============================================================

shell> which jboss #没反应
shell> Java version

# ===============================================================
# java version "1.4.2_10"
# Java(TM) 2 Runtime Environment,Standard Edition (build 1.4.2_10-b03)
# Java HotSpot(TM) Client VM(build 1.4.2_10-b03, mixed mode)
# ===============================================================

shell> jboss  -version 

# ===============================================================
# jboss: command not found
# ===============================================================

shell> mysql -version

# ===============================================================
# ERROR 2002(HY000): can't connect to local MySQL server through socket 'tmp/mysql.sock' (2)
# 由上可知道已经安装了java和MySQL，首先先启动MySQL，再想办法配置JBoss到MySQL数据库的连接
# ===============================================================

shell> /etc/init.d/mysqld status

# ===============================================================
#  -bash: /etc/init.d/mysqld：没有那个文件或目录
# ===============================================================

shell> cd /etc
shell> ls -a        # 发现了init.d，没发现rc.d，以前版本老提它，这里都分散了
shell> cd  /init.d
shell> ls -a        # 发现mysql，没发现mysqld
shell> /etc/init.d/mysql status

# ===============================================================
# /etc/init.d/mysql:  73: source: not found
# Usage: /etc/init.d/mysql  start|stop|restart|reload
# ===============================================================

shell> ps -A|grep mysql     #没有反应
shell> ps -aux|grep mysql

# ===============================================================
# warning: bad ps syntax,perhaps a bogus '-a'? See http://procps.sf.net/faq.html
# root  1453  0.0  0.1   3444 800 pts/0  S+  16:15  0:00  grep mysql
# ===============================================================
# 没有列出，mysql进程，就是没有了，那么设置的开机自启动也就没有用到。
# 算了，先把mysql改成mysqld的名称，后面肯定有许多要这个名字的地方。
# 然后考虑配置数据库，开关数据库，/etc/my.cnf配置等需要的时候再逐个修改。
# ===============================================================

shell> mv ./mysql   ./mysqld
shell> ls -a                         # 发现了mysqld
shell> echo  $PATH                   # 发现包含 /usr/local/mysql/bin，以及j2sdk1.4.2_10和jboss-4.0.2路径
shell> gedit ./my.cnf                # 查看比对了资料，但是没有做修改
shell> cp ./my.cnf  ./my.cnf-backup  # 后面必然要修改，先备份一个
shell> cd ..

# ===============================================================
# 直接进入到"初始化数据库  启动服务器  使用客户端访问数据库、关闭数据库"
# ===============================================================

shell> ./mysql_install_db  --user=mysql

# ===============================================================
# -bash: ./mysql_install_db : 没有那个文件或目录
#
# 不爽，每次要输入/usr/local/mysql，建立变量 MYSQL_HOME_OWN
# 在etc/profile中添加：
# export MYSQL_HOME_OWN="/usr/local/mysql"
# ===============================================================

shell> reboot
shell> sudo -i
shell> cd $MYSQL_HOME_OWN
shell> ./scripts/mysql_install_db --user=mysql

# ===============================================================
# -bash: ./scripts/mysql_install_db: 没有那个文件或目录
# ===============================================================

shell> ls -a

# ===============================================================
# . .. bin include info lib libexec man mysql-test share sql-bench var
# ===============================================================
# 没有目录，存在var，看来是不用再做数据库初始化的工作了，那么进入启动：
# ./mysqld_safe  --defaults -file=/etc/my.cnf &
# ./mysqld_safe  --user=mysql &     <& 表示在同一个控制台继续操作，否则重新开启窗口>
# ---------------------------------
# cp support-files/my-huge.cnf /opt/mysql/var/my.cnf
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# cd /etc/rc.d/init.d/my
# chmod 755 mysqld
# /etc/rc.d/init.d/mysqld   start
# 这里说的大中小就是my-huge.cnf/my-large.cnf/my-medium.cnf/my-small.cnf，我选用的是my-medium.cnf
# ===============================================================
# 用whereis mysql 查看一下吧，如果装好了又启动了的话在 /usr/bin下一定会有mysql这个文件。
# 用ntsysv进入这个菜单直接选择这个服务就可以在开机时就启动了。
# ===============================================================

shell> cd  /etc/init.d
shell> ls -a             # 确认 mysqld 存在
shell> chmod 755 mysqld  # 给 mysqld 加上可执行的权限
shell> reboot

shell> sudo -i
shell> whereis mysql

# ===============================================================
# mysql: /usr/local/mysql
# ===============================================================

shell> cd /usr/bin
shell> ls -a  #  /usr/bin里面确实没有发现有mysql
shell> ./mysqld_safe  --defaults -file=/etc/my.cnf &
shell> etc/init.d/mysqld start

# ===============================================================
# etc/init.d/mysqld:  73:  source: not found
# Starting MySQL
# etc/init.d/mysqld:  256:  log_success_msg: not found 
# ===============================================================

shell> etc/init.d/mysqld stop

# ===============================================================
# etc/init.d/mysqld:  73:  source: not found
# Shutting down MySQL
# etc/init.d/mysqld:  256:  log_success_msg: not found 
# ===============================================================
# 服务器的开和关可以实现了，下一步应该是用客户端登陆,再登陆看看
# ===============================================================

shell> etc/init.d/mysqld start

# ===============================================================
# etc/init.d/mysqld:  73:  source: not found
# Starting MySQL
# etc/init.d/mysqld:  256:  log_success_msg: not found 
# ===============================================================

shell> cd /usr/bin
shell> ls -a    # /usr/bin仍然没有mysql
shell> cd ~     # 回到root目录
shell> etc/init.d/mysqld stop

# ===============================================================
# etc/init.d/mysqld:  73:  source: not found
# Shutting down MySQL
# etc/init.d/mysqld:  256:  log_success_msg: not found 
# ===============================================================

shell> ./mysqld_safe --defaults -file=/etc/my.cnf &

# ===============================================================
# [1519]
# root@rene_Ubuntu:~#-bash: ./mysqld_safe: 没有那个文件或目录
# 回车
# [1]+ Exit 127             ./mysqld_safe --defaults -file=/etc/my.cnf &
# ===============================================================

shell> ./mysqld_safe  --user=mysql &

# ===============================================================
# [1522]
# root@rene_Ubuntu:~#-bash: ./mysqld_safe: 没有那个文件或目录
# 回车
# [1]+ Exit 127             ./mysqld_safe  --user=mysql
# ===============================================================

shell> cd /usr/local/mysql/bin
shell> ls -a   # 在目录内发现了 mysqld_safe项目
shell> ./mysqld_safe --user=mysql

# ===============================================================
# nohup: ignoring input and redirecting stderr to stdout
# Starting mysqld daemon with databases from /usr/local/mysql/var
# 回车
# exit
# ===============================================================
# exit后没有反应，任何输入的字符都显示在控制台。google一下无果，重启好了
# ===============================================================

shell> reboot

shell> sudo -i

# ===============================================================
# 安装应该是成功了，my.cnf主要是启动和访问控制，那么先修改一下权限
# ===============================================================

shell> chown  -R  root  .    #设定root能访问/usr/local/mysql
shell> chown  -R  mysql  var    #设定mysql用户能访问/usr/local/mysql/var ,里面存的是mysql的数据库文件
shell> chown  -R  mysql  var/.    #设定mysql用户能访问/usr/local/mysql/var下的所有文件
shell> chown  -R  mysql  var/mysql/.  #设定mysql用户能访问/usr/local/mysql/var/mysql下的所有文件
shell> chgrp  -R  mysql  .    #设定mysql组能够访问/usr/local/mysql
shell> Chown -R root /usr/local/mysql
shell> chgrp  -R  mysql  /usr/local/mysql
shell> chown  -R  root  /usr/local/mysql/bin
shell> chgrp  -R  mysql  /usr/local/mysql/bin
shell> chown  -R  root  /usr/local/mysql/var
shell> chgrp  -R  mysql  /usr/local/mysql/var
shell> chmod  777   /usr/local/mysql/var
shell> chown  -R  root  /usr/local/mysql/var/mysql
shell> chgrp  -R  mysql  /usr/local/mysql/var/mysql
shell> chmod  777   /usr/local/mysql/var/mysql
shell> chown  -R  root  /usr/local/mysql/var/mysql/*
shell> chgrp  -R  mysql  /usr/local/mysql/var/mysql/*
shell> chmod  777   /usr/local/mysql/var/mysql/*
shell> chmod  777   /usr/local/mysql/lib/mysql/libmysqlclient.a
shell> /usr/local/mysql/bin/mysqld_safe  --user=mysql &

# ===============================================================
# [1] 1412
# root@rene-Ubuntu:/usr/local/mysql/#nohup: ignoring input and redirecting stderr to stdout
# Starting mysqld daemon with databases fro /usr/local/mysql/var
# ===============================================================
# 成功了，光标退回到控制台语句了
* root@rene-Ubuntu: /usr/local/mysql # 光标闪烁
# ===============================================================

shell> cd /usr/bin
shell> ls -a  # /usr/bin中仍然没有mysql
shell> cd /usr/local/mysql/bin
shell> ls -a # 发现 mysql,据说可以连接管理mysql
shell> ./mysql

# ===============================================================
# ERROR 1045 (28000): Access denied for user 'root'@'localhost'(using password: NO)
# 访问被拒绝，Google该错误相关办法，执行之
# ===============================================================

shell> mysql -u root -p

# ===============================================================
# Enter password:
# Welcome to the MySQL monitor. Commonds end with ; or /g.
# Your MySQL connection id is 2 to server vision: 4.1.24-log
#
# Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
# ===============================================================
# 看来首先是要启动mysql server即
# /usr/local/mysql/bin/mysqld_safe  --user=mysql &
# 然后再进入mysql管理工具，即
# mysql -u root -p
# 另外那一个试用了，但是退出管理端
# ./mysqld_safe  --defaults -file=/etc/my.cnf &
# ===============================================================
# mysql> /h
# ... ...
# mysql> /c
# mysql> quit
# Bye
# ===============================================================
# 通过 java -version 验证jdk安装成功
# 通过 /usr/local/mysql/bin/mysqld_safe  --user=mysql & 验证MySQL安装成功
# 下面是验证JBoss安装成功，且要和MySQL成功对接
# ===============================================================
# 需要建立数据库 weblogic
# ==============================us=================================
shell> /usr/local/mysql/bin# ./mysql -u  root -p

# ===============================================================
# Enter password:
# Welcome to the MySQL monitor. Commonds end with ; or /g.
# Your MySQL connection id is 3 to server vision: 4.1.24-log
#
# Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql > create database weblogic;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
'create database weblogic' at line 2
mysql > /h
... ...
mysql > help create;
Many help items for your request exist.
To make a more specific requeset,please type 'help <item>',
where <item> is one of the following
topics:
   CREATE DATABASE
   CREATE FUNCTION
   CREATE INDEX
   CREATE TABLE
   SHOW   CREATE DATABASE
   SHOW   CREATE INDEX
   SPATIAL
mysql > help CREATE DATABASE
Name:    'CREATE DATABASE'
Description:
Syntax:
CREATE DATABASE [IF NOT EXISTS] db_name
    [create_specfication ...]

create_specfication:
     [DEFAULT] CHARACTER SET [=] charset_name
  |  [DEFAULT] COLLATE   [=]  collation_name

CREATE DATABASE creates a database with the given name. To use this
statement, you need the CREATE privilege for the database.

URL: http://dev.mysql.com/doc/refman/4.1/en/create-database.html

mysql > CREATE DATABASE weblogic;
Query OK, 1 row affected (0.04 sec)

mysql > help alter
... ...

mysql > ALTER DATABASE weblogic COLLATE utf8_bin;
Query OK, 1 row affected (0.00 sec)

mysql > help grant
... ...
mysql > GRANT ALL ON weblogic.* TO weblogic@'%'  IDENTIFIED BY "weblogic";
Query OK, 0 rows affected (0.02 sec)

mysql > quit
Bye
# ===============================================================

shell> /usr/local/mysql/bin/mysql weblogic -u weblogic -p

# ===============================================================
# Enter password: rene0769
# ERROR 1045 (28000): Access denied for user 'weblogic'@'localhost'(using password: YES)
# ===============================================================
# 怎么改都没有用处，重新查找MySQL操作，reboot
# ===============================================================

shell> reboot

shell> sudo -i
shell> cd /usr/local/mysql/bin
shell> /usr/local/mysql/bin# ./mysqld_safe  --user=mysql &
# ===============================================================
# root@rene-Ubuntu:/usr/local/mysql/#nohup: ignoring input and redirecting stderr to stdout
# Starting mysqld daemon with databases fro /usr/local/mysql/var
# ===============================================================

shell> /usr/local/mysql/bin# mysql -u root -p
# ===============================================================
# Enter password:
# Welcome to the MySQL monitor. Commonds end with ; or /g.
# Your MySQL connection id is 3 to server vision: 4.1.24-log
#
# Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
mysql> SHOW DATABASES;   # 使用SHOW语句找出在服务器上当前存在什么数据库：
+----------+
| Database |
+----------+
| mysql    |
| test     |
| weblogic |
+----------+
3 row in set (0.00 sec)

# 创建一个数据库abccs
# mysql> CREATE DATABASE weblogic;
# 注意不同操作系统对大小写的敏感。

mysql> USE weblogic
Database changed  
# 此时你已经进入你刚才所建立的数据库weblogic

mysql> SHOW TABLES;

Empty set (0.00 sec)
# 说明刚才建立的数据库中还没有数据库表。下面来创建一个数据库表mytable:

mysql> SHOW update;
... ...
mysql> UPDATE user SET password='weblogic'where user='weblogic'
ERROR 1146 (42S02): Table 'weblogic.user' doesn't exist

看样子，需要看看用户是不是存在的，重新建立一个同名的好了
mysql> help insert;
... ...
mysql> INSERT INTO weblogic.user(Host,User,Password) VALUES("localhost","weblogic",PASSWORD("rene0769"));
ERROR 1146 (42S02): Table 'weblogic.user' doesn't exist

mysql> SELECT DISTINCT(user) FROM mysql.user
+----------+
| user     |
+----------+
| weblogic |
|          |
| root     |
+----------+
3 rows in set (0.00 sec)

mysql> SELECT host,user FROM mysql.user
+--------------+----------+
| host         | user     |
+--------------+----------+
| %            | weblogic |
| localhost    |          |
| localhost    | root     |
| rene-Ubuntu  |          |
| rene-Ubuntu  | root     |
+--------------+----------+
5 rows in set (0.00 sec)

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| test     |
| weblogic |
+----------+
3 rows in set (0.00 sec)

mysql> SELECT host,user FROM weblogic.user
ERROR 1146 (42S02): Table 'weblogic.user' doesn't exist

mysql> SELECT host,user FROM test.user
ERROR 1146 (42S02): Table 'test.user' doesn't exist

mysql> use mysql
Database changed

mysql> delete from user where user="weblogic" and host="%"
Query OK, 1 row affected (0.01 sec)

mysql> SELECT user FROM mysql.user
+----------+
| user     |
+----------+
|          |
| root     |
|          |
| root     |
+----------+
4 rows in set (0.00 sec)

shell> use weblogic
No connection. Trying to reconnect...
connection id: 2
Current database:  *** NONE ***

Database changed

mysql> quit
Bye
# ===============================================================
# 查资料，grant创建的用户必须匹配"user@'%'"，只能用-h输入地址，因此返回到root操作
# ===============================================================

shell> ifconfig
# ===============================================================
# eth0      Link encap:以太网  硬件地址 00:0c:29:84:1b:2c
#           inet 地址:192.168.162.144  广播:192.168.162.255  掩码:255.255.255.0
#           inet6 地址: fe80::20c:29ff:fe84:1b2c/64 Scope:Link
#           UP BROADCAST RUNNING MULTICAST  MTU:1500  跃点数:1
#           接收数据包:714 错误:0 丢弃:0 过载:0 帧数:0
#           发送数据包:191 错误:0 丢弃:0 过载:0 载波:0
#           碰撞:0 发送队列长度:1000
#           接收字节:93502 (93.5 KB)  发送字节:36479 (36.4 KB)
#           中断:19 基本地址:0x2000
#
# lo        Link encap:本地回环
#           inet 地址:127.0.0.1  Mask:255.0.0.0
#           inet6 地址: ::1/128 Scope:Host
#           UP LOOPBACK RUNNING  MTU:16436  跃点数:1
#           接收数据包:8 错误:0 丢弃:0 过载:0 帧数:0
#           发送数据包:8 错误:0 丢弃:0 过载:0 载波:0
#           碰撞:0 发送队列长度:0
#           接收字节:480 (480.0 B)  发送字节:480 (480.0 B)
# ===============================================================

shell> /usr/local/mysql/bin# mysql -u root -p
# ===============================================================
# Enter password: rene0769
# Welcome to the MySQL monitor. ... ...
#
# mysql > SHOW DATABASES;
# ... ...
# mysql > USE weblogic
# ... ...
# mysql > grant all on weblogic.* to weblogic@'%' identified by 'weblogic'
# Query OK, 0 rows affected (0.00 sec)
# mysql > quit
# Bye
# ===============================================================

shell> /usr/local/mysql/bin# mysql weblogic -u weblogic -p
# ===============================================================
# Enter password: weblogic
# ERROR 1045 (28000): Access denied for user 'weblogic'@'localhost'(using password: YES)
# ===============================================================

shell> /usr/local/mysql/bin# mysql weblogic -h 192.168.162.144 -u weblogic -p
# ===============================================================
# Enter password: weblogic
# Welcome to the MySQL monitor. Commands end with ; or /g.
# Your MySQL connection id is 5 to server version: 4.1.24-log
#
# Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
# mysql> quit
# Bye
# ===============================================================
# JDBC的问题先放一放，是个连接接口选择的问题，目前来看，jdk+mysql+jboss初步形成，
# 但是需要一些工具如jdbc和一些配置才能形成完整的java环境，看看OpenIPMP情况。
# ===============================================================

 

 

shell> echo $PATH
# ===============================================================
# /usr/lib/jvm/SunJDK/j2sdk1.4.2_10/bin :
# /usr/lib/jvm/SunJDK/j2sdk1.4.2_10/jre/bin :
# /usr/local/sbin :
# /usr/local/bin :
# /usr/sbin :
# /usr/bin :
# sbin :
# bin :
# /usr/games :
# /usr/jboss-4.0.2/bin:
# /usr/lib/jvm/SunJDK/j2sdk1.4.2_10/jre/bin :
# /usr/local/mysql/bin    说明书交代，要包含这个路径
# ===============================================================

shell> cd /home/rene/down
shell> ls -a  #看到openipmp_v202.zip
shell> unzip -t  openipmp_v202.zip #检查压缩包是否完整
... ...
shell> unzip -n  openipmp_v202.zip #解压，不覆盖原有文件
... ...
shell> ls -a #发现openipmp2文件夹
... ...
shell> cd openipmp2
shell> ls -a
... ...

shell> cd src
shell> ls -a
... ...

shell> cd Demo
shell> ls -a
... ...

shell> cp ./data  ./data-backup
cp: 略过目录： "./data"

shell> cp -r ./data  ./data-backup #只有增加-r才不会略过
shell> ls -a
# . .. data data-backup mpeg4ip
# 错了，本意是修改data所以备份，实际上修改admin_OMADRM.sh

shell> cd ..
shell> ls -a
. .. client Demo DRMPlugin LICENSE.txt server
shell> cd ./server/OMADRMWS
shell> ls -a #找到admin_OMADRM.sh
shell> cp -r ./admin_OMADRM.sh  ./admin_OMADRM-backup
shell> ls -a #找到admin_OMADRM-backup，但错了
shell> mv admin_OMADRM-backup  admin_OMADRM.sh-backup
shell> gedit admin_OMADRM.sh #将其中的”$CURR_DIR/../../Demo/data/”改为 “/tmp/”，保存退出
shell> cd ..  #退出OMADRMWS
shell> cd ..  #退出server
shell> ls -a
. .. client Demo DRMPlugin LICENSE.txt server
shell> cp ./Demo/data/*   /tmp
shell> cd ./server/ejbca
shell> ls -a  #找到 deployJBoss4x.sh
shell> cp -r  ./deployJBoss4x.sh   ./deployJBoss4x.sh-backup
shell> ls -a  #发现deployJBoss4x.sh-backup
shell> gedit deployJBoss4x.sh  #  16行  if (( $1 == keystore ))   改为  if [ "$1" = "keystore" ]
shell> cd .. #退出ejbca，进入server目录
shell> ls -a
. .. ant ejbca install.bat install.sh OMADRMWS osms osmsWSProxy uninstall.bat uninstall.sh
shell> ./uninstall.sh
-bash: ./uninstall.sh: 权限不够
shell> sudo -i
shell> gedit /etc/profile #加入openIPMP_SERVER_HOME="/home/rene/down/openipmp2/src/server"
shell> reboot

 

shell> sudo -i
shell> ./mysqld_safe --user=mysql &
#==============================================================
# [1] 1338
# root@rene-Ununtu:~# -bash: ./mysqld_safe: 没有那个文件或目录
#
# [1]+ Exit 127 ./mysqld_safe --user=mysql
#==============================================================

shell> gedit /etc/profile  # 发现MYSQL_HOME_OWN="/usr/local/mysql"
shell> $MYSQL_HOME_OWN/bin/mysqld_safe --user=mysql &
[1] 1418
root@rene-Ubuntu:~#nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /usr/local/mysql/var
回车

shell> mysql weblogic -h 192.168.162.144 -u weblogic -p
Enter password: weblogic
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.162.144' (113)

shell> $MYSQL_HOME_OWN/bin/mysql weblogic -h 192.168.162.144 -u weblogic -p
Enter password: weblogic
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.162.144' (113)

shell> ifconfig
... ...
    inet 地址:192.168.162.145  广播:192.168.162.255  掩码:255.255.255.0
... ...

shell> mysql weblogic -h 192.168.162.145 -u weblogic -p
# Enter password: weblogic
# Welcome to the MySQL monitor. Commonds end with ; or /g.
# Your MySQL connection id is 3 to server vision: 4.1.24-log
#
# Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
#
# mysql> quit
# Bye
 
shell> cd $openIPMP_SERVER_HOME
shell> ls -a 
.   ant    install.bat  OMADRMWS  osmsWSProxy    uninstall.sh
..  ejbca  install.sh   osms      uninstall.bat

shell> ./uninstall.sh
-bash: ./uninstall.sh: 权限不够

shell> chmod +x uninstall.sh
shell> chmod +x install.sh
shell> ./uninstall.sh
Uninstalling openIPMP server
Please enter mysql user name:
root
Please enter mysql user password:
rene0769
... ...
openIPMP server unistall COMPLETED
shell> ./install
Installing openIPMP server
Please enter mysql user name:
root
Please enter mysql user password:
rene0769
... ...

BUILD SUCCESSFUL
Total time: 2 seconds
Deploying osmsWSProxy to JBoss
osms installation completed
openIPMP server installation COMPLETED

shell> $JBOSS_HOME/bin
shell> ls -a
.             deployer.sh           run.bat   shutdown.bat  twiddle.jar
..            jboss_init_redhat.sh  run.conf  shutdown.jar  twiddle.sh
classpath.sh  jboss_init_suse.sh    run.jar   shutdown.sh
deployer.bat  lib                   run.sh    twiddle.bat

shell> ./run.sh

java.lang.NullPointerException
     at java.lang.String.concat(Sting.java: 1503)   空指针错误，应该是mysql数据库不完整造成的用户名等提取错误
... ...
17:08:13,714 INFO [Server] JBoss(MX microKernel)[4.0.2 (build: CVSTag=JBoss_4_0_2
data=200505022023)] Started in 38s:51ms

打开火狐输入：http://localhost8080/openipmp/jsp，确实进入了openipmp服务器