JOB
Monster LAMP Pack lite ver.1108
內含套件有
OS: Gentoo 2.6.24.x
FS : reiserfs
pagkages : mysql (with senna), postfix , apache
pptp VPN (可連 Microsoft MPPE )
samba
# uname -a
Linux lab 2.6.24-gentoo-r7 #3 SMP PREEMPT Sat Jul 26 05:17:06 CST 2008 i686 Intel(R) Pentium(R) 4 CPU 3.00GHz GenuineIntel GNU/Linux
# apache2 -v
Server version: Apache/2.2.9 (Unix)
Server built: Jul 23 2008 21:55:39
# mysqladmin -uroot -p version
Server version 5.0.51a-log with senna search engine
# php –version
PHP 5.2.6-pl2-gentoo (cli) (built: Jul 23 2008 23:20:20)
mail-mta/postfix
2.4.6-r2
net-fs/samba
3.0.28a-r1
目前 PHP 的 USE
[code language=’sh’] USE=”apache2 berkdb cjk cli crypt curl gd gdbm hash iconv mysql mysqli ncurses nls pcre readline reflection session spell spl ssl truetype unicode xml zlib calendar ctype json simplexml soap ” emerge -av php [/code]
暫時不加 oci8-instant-client
ENHANCE / BUG TO FIX:
- /etc/make.conf 加 ACCEPT_KEYWORDS="~x86"
- emerge -av app-emulation/open-vm-tools
- …
Virtual appliance
看到 http://virtualappliances.net/ 這裡面立即提供了 5 總 ready to go 的 appliance , 只要 “抓下來 / 啟動 就立即可用” —> 這就是 virtual appliance 的精神 , 看了這頁頓時覺得 這些 appliance 真的對 developer 非常 friendy , 看看這頁
http://virtualappliances.net/documentation/readme/README.lamp.html
裝好立即有
- Apache HTTP Server
- PHP
- Perl
- Python
- ZendOptimizer (www.zend.com)
- MySQL
- phpMyAdmin
然後要開發就只要到它開放的 samba 目錄下寫程式即可 , 這點跟我包裝的 Monster LAMP Pack 精神是相同的.
Oracle 小筆記
— Create sequence
create sequence TEST_SQ
minvalue 1
maxvalue 9999999999
start with 21
increment by 1
cache 20;
select test_sq.nextval from dual
select test_sq.currval from dual
https://172.20.10.6:5500/em/console/logon/logon
https://172.20.10.6:5500/em/console/aboutApplication
sqlplus sysman/sysman
sqlplus sysman/oracle
sqlplus system@”(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DB1)))”
lsnrctl status
sqlplus /nolog
emctl status
emctl start dbconsole
emctl stop dbconsole
/etc/init.d/vmware-tools status
/etc/init.d/vmware-tools
lsnrctl start
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 – Production on Tue Sep 30 01:46:26 2008
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1267236 bytes
Variable Size 180357596 bytes
Database Buffers 130023424 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
conn / as sysdba
shutdown immediate
emctl start dbconsole
Oracle Enterprise Manager
https://localhost:5500/em/console/aboutApplication
sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 – Production on Wed Oct 1 18:50:04 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn scott/password@db1
opensolaris / Optimized Open Source Software Stack (Cool Stack)
看到一個有用的套件
for the Sun Solaris Operating System(TM)
http://cooltools.sunsource.net/coolstack/
Cool Stack includes several packages in the SVR4 package format, so you can install just the ones you need. Some of the applications in Cool Stack already ship with Solaris, but these are either older versions and/or not built with full optimization. Further, Cool Stack has been pre-configured to have the most popular applications (Apache, PHP, MySQL) to work seamlessly out of the box.
Deploying PHP From Cool Stack in Sun Java System Web Server
Configuring Cool Stack PHP With Web Server
Next, do the following:
1. Go to the Cool Stack PHP 5 installation location. Type:
cd /opt/coolstack/php5
In that directory is a script called setup-ws7-php.sh.
2. Run setup-ws7-php.sh. Type:
./setup-ws7-php.sh
This message is displayed:
Usage:
This script will configure Coolstack PHP with Sun Java System Web Server
7. Here, you will need to provide the top level location of your Web Server
7 installation and your Web Server 7 instance_name name to which this
script should configure to run PHP scripts.
Enter your Web Server installation location(/sun/webserver7):
3. Type the full path for your Web Server installation.
The script then prompts you to type a Web Server instance name. That name is the path to a directory in your installation location—one that contains all the configuration files for running your Web site. If you are using Web Server in Sun Java Enterprise System 5, your instances are under /var/opt/SUNWwbsvr7.
For the example in this article, cite the instance https-coolstack that you created previously. To enable a different instance for PHP, type that instance name. Your instance is then ready for PHP, which you can deploy with Cool Stack 1.2 PHP on Web Server.
Finally, do the following:
1. Start Web Server. Type:
/sun/webserver7/https-coolstack/bin/startserv
2. Create sample PHP files under /sun/webserver7/https-coolstack/docs.