This package provides a developer environment to create your web projects
on your Amiga. Just like the well known LAMP package for Linux, it includes
the HTTP (web) server "Apache" with compiled in support for the scripting
language "PHP" and the database server "MySQL".
In this version the dependencies to AmiCygnix are removed. Also the structure
of the directories and files is easier to understand.
But it is not only interesting for web developers. Now you can run web app-
lications locally on your Amiga, for example the database administration tool
"phpMyAdmin" (http://www.phpmyadmin.net) or the picture database "Coppermine"
(http://coppermine-gallery.net) - just to mention a few.
With the included interpreter for "PHP" you can also create your own tools.
"PHP" is easy to understand and with it's extensions it is very powerful.
Finally the database server "MySQL" gives you the oportunity to manage your
data and share it with other users. External applications (e.g. IODBC) can use
it as a database backend.
Content
-------
1. Included packages
* Apache 2.2.11 (http://httpd.apache.org)
* MySQL 5.1.35 (http://www.mysql.com)
* PHP 5.2.10 (http://php.net)
* Additional tools
* myApacheStarter 2.00
* mySQLcontrol 1.00
2. How to launch and stop
3. Documenation
4. Important files and directories
5. Activating the MySQL storage engine InnoDB
6. Tested web applications
7. Problems
8. Bug reports
9. Installation
10. Thanks to...
1. Included packages
--------------------
This package contains several software packages and programs:
* Apache 2.2.11 (http://httpd.apache.org)
1. The Apache HTTP Server Project is an effort to develop and maintain an
open-source HTTP server for modern operating systems including UNIX and
Windows NT. The goal of this project is to provide a secure, efficient
and extensible server that provides HTTP services in sync with the
current HTTP standards.
Apache has been the most popular web server on the Internet since
April 1996.
These modules are compiled into the Apache binary:
- core_module (internal)
- authn_file_module (internal)
- authn_default_module (internal)
- authz_host_module (internal)
- authz_groupfile_module (internal)
- authz_user_module (internal)
- authz_default_module (internal)
- auth_basic_module (internal)
- include_module (internal)
- filter_module (internal)
- log_config_module (internal)
- env_module (internal)
- setenvif_module (internal)
- ssl_module (internal - additional to the bounty requirements)
- mpm_prefork_module (internal)
- http_module (internal)
- mime_module (internal)
- status_module (internal)
- autoindex_module (internal)
- asis_module (internal)
- info_module (internal)
- cgi_module (internal)
- negotiation_module (internal)
- dir_module (internal)
- imagemap_module (internal)
- actions_module (internal)
- userdir_module (internal)
- alias_module (internal)
- rewrite_module (internal - additional to the bounty requirements)
- headers_module (internal - additional to the bounty requirements)
- so_module (internal - only for linking external modules statically)
- php5_module (linked using so module)
2. These tools are included:
- ab
- apachectl (Unix shell script)
- checkgid
- dbmmanage (Perl script)
- htcacheclean
- htdbm
- htdigest
- htpasswd
- httxt2dbm
- logresolve
- rotatelogs
The Unix man files are located in "AAMP:Common/share/man/man1" and
"AAMP:Common/share/man/man8" and can be viewed with "Next"
(available on Aminet).
The Apache HTTP server is a project of the Apache Software Foundation and
is licensed under the Apache License, Version 2.0. See "LICENSE" in
"AAMP:Apache".
* MySQL 5.1.35 (http://www.mysql.com)
MySQL is a relational database management system (RDBMS) which has more than
6 million installations. MySQL stands for "My Structured Query Language".
The program runs as a server providing multi-user access to a number of
databases.
1. Supported storage engines:
- "EXAMPLE": Example storage engine
- "InnoDB": Supports transactions, row-level locking, and foreign
keys.
Is deactivated by default. For more information have a
look at section "Activating the MySQL storage engine
InnoDB".
- "MyISAM": Default engine as of MySQL 3.23 with great performance
- "BLACKHOLE": /dev/null storage engine (anything you write to it
disappears)
- "CSV": CSV storage engine
- "MEMORY": Hash based, stored in memory, useful for temporary tables
- "MRG_MYISAM": Collection of identical MyISAM tables
- "ARCHIVE": Archive storage engine
- "FEDERATED": Federated MySQL storage engine
2. Included tools:
- mysql
- mysql_client_test
- mysql_convert_table_format (Perl script)
- mysql_find_rows (Perl script)
- mysql_fix_extensions (Perl script)
- mysql_fix_privilege_tables (Unix shell script)
- mysql_install_db (Unix shell script)
- mysql_secure_installation (Unix shell script)
- mysql_setpermission (Perl script)
- mysql_tzinfo_to_sql
- mysql_upgrade
- mysql_waitpid
- mysql_zap (Perl script)
- mysqlaccess (Perl script)
- mysqladmin
- mysqlbinlog
- mysqlbug (Unix shell script)
- mysqlcheck
- mysqld_multi (Perl script)
- mysqld_safe (Unix shell script)
- mysqldump
- mysqldumpslow (Perl script)
- mysqlhotcopy (Perl script)
- mysqlimport
- mysqlshow
- mysqlslap
- mysqltest
- myisam_ftdump
- myisamchk
- myisamlog
- myisampack
- my_print_defaults
- msql2mysql
- innockecksum
- perror
- replace
- resolve_stack_dump
- resolveip
The Unix man files are located in "AAMP:Common/share/man/man1" and
"AAMP:Common/share/man/man8" and can be viewed with "Next"
(available on Aminet).
MySQL is a project of the MySQL team at Sun Microsystems, Inc.
It is dual-licensed, see "COPYING" and "EXCEPTIONS-CLIENT" in
"AAMP:MySQL".
* PHP 5.2.10 (http://php.net)
PHP is a scripting language. A commandline interpreter called "php" is
included. It is also compiled into the Apache HTTP server binary as an
Apache module.
These extensions are included:
- bcmath
- bz2
- calendar
- ctype
- curl
- date
- dbase
- dom
- exif
- filter
- ftp
- gd
- gettext
- hash
- iconv
- json
- libxml
- mbstring
- mcrypt
- mhash
- mysql
- mysqli
- openssl (additional to the bounty requirements)
- pcre
- pdf
- PDO
- pdo_mysql
- pdo_sqlite
- posix
- ps
- Reflection
- session
- SimpleXML
- soap
- SPL
- SQLite
- standard
- sysvmsg (additional to the bounty requirements)
- sysvsem (additional to the bounty requirements)
- sysvshm (additional to the bounty requirements)
- tidy
- tokenizer
- xml
- xmlreader
- xmlwriter
- xsl
- zip
- zlib
The Unix man file is located in "AAMP:Common/share/man/man1" and can
be viewed with "Next" (available on Aminet).
PHP is a project of the PHP group and is licensed under the "PHP License,
version 3.01". See "LICENSE" in "AAMP:PHP".
* Additional tools:
From the used libraries:
- curl (from curl-7.19.7)
- iconv (from libiconv-1.9.2)
- openssl (from openssl-1.0.0d)
- tidy (from tidy 26.10.2005)
Misc:
- sh (from abc-shell 53.1, author: Henning Nielsen Lund)
- shutdown_http (stops Apache server processes, author: E. Schwan)
- shutdown_mysql (stops MySQL server processes, author: E. Schwan)
- xlaunch (special utility for launching programs, author:
E. Schwan)
* myApacheStarter 2.00
A tool with Reaction GUI to manage some important settings of the Apache
HTTP server and to launch and stop the server.
Hint: This version of myApacheStarter can handle this Apache implementation
and also the old version 1.3.33 available on OS4-depot.
Written by Michael Christoph (http://www.meicky-soft.de).
* mySQLcontrol 1.00
A tool to manage MySQL databases (similar to phpMyAdmin) and to launch and
stop the MySQL server.
Written by Michael Christoph (http://www.meicky-soft.de).
2. How to launch and stop
-------------------------
There are several ways to launch and stop the above servers:
* While installation you will be asked, if the servers should be launched at
the system startup. So there is no need to launch them manually.
Before you switch of your Amiga, you should stop the servers by launching
the script "Stop_AAMP.bat" in "AAMP:".
* You can start the script "Start_AAMP.bat" in "AAMP:". Like above, you
should stop the servers by launching the script "Stop_AAMP.bat".
* You can start and stop the servers with the tools "myApacheStarter" and
"mySQLcontrol".
3. Documenation
---------------
If you want to know more about Apache, type "http://localhost/manual" into
the address line of your webbrowser. The Apache HTTP server must be active.
I suggest to use the OWB webbrowser.
There is only a few documentation about MySQL included in this package. In
"AAMP:MySQL" you can find the Unix info file "mysql.info", which can be viewed
with the tool "Next" available on the Aminet.
I suggest to install the MySQL manager "phpMyAdmin-3.2.1" (or later), which
has a nice online help.
For informations about PHP, open the webpage "http://www.php.net/manual" in
your browser.
4. Important files and directories
----------------------------------
* The default location of the Apache documents is:
"AAMP:Apache/htdocs".
Can be changed with "myApacheStarter".
* The configuration files of the Apache HTTP server are located in:
"AAMP:Apache/conf".
* The default location of the MySQL databases is:
"AAMP:MySQL/Databases".
* The MySQL configuration file "my.cnf" is located in:
"AAMP:Common/etc".
* The PHP configuration file "php.ini" is located in:
"AAMP:Common/lib".
5. Activating the MySQL storage engine InnoDB
---------------------------------------------
InnoDB is deactivated by default. If you want to activate this engine, open
the file "AAMP:Common/etc/my.cnf" in an editor, add a sharp symbol (#) before
"skip_innodb" and save it again.
After a relaunch of the server, the server automatically creates some files.
The integrity of these files will be checked on every start of the MySQL
server. This is because the server cannot make a clear shutdown, when InnoDB
is activated (See also section "Problems").
6. Tested web applications
--------------------------
application homepage status
* 4images 1.7.9 http://www.4homepages.de working
* coppermine 1.5.12 http://coppermine-gallery.net working
* gallery3 http://codex.gallery2.org/Gallery3 working
* ide.php 1.5.3 http://www.ekenberg.se/php/ide working
* Joomla http://www.joomla.org working
* Mambo 3.6.5 http://mambo-foundation.org working
* MyBB http://www.mybb.com working
* oscommerce 2.3.1 http://www.oscommerce.com working
* phpBB3 http://www.phpbb.com working
* phpMyAdmin 3.3.9.2 http://www.phpmyadmin.net working
* phpwcms r412 http://www.phpwcms.de working
* Showit 2.1.07 working
* wordpress 3.1 http://wordpress-deutschland.org working
* xoops 2.5.0b http://www.xoops.org has problems
7. Problems
-----------
Serious problems:
* Unfortunately the Apache mod_ssl module is not working. It is not usable
at the moment. This will hopefully be fixed in a next release.
Minor problems:
* The web server does not support subprocesses. As this package is not meant
for productive use, this is not really a problem. Development and using
local web applications is no problem.
* The MySQL server cannot be stopped, when InnoDB tables are enabled. This
type of table is only useful, if you want to use the server for productive
jobs - same as above. You can work with InnoDB tables, I did not have any
problem. But they are always checked on server startup, because of the
unfinished shutdown. On the other hand, I don't see any reason to use this
kind of tables.
* It is possible, that the MySQL server cannot be stopped, after a first
request was processed. It should not cause serious problems.
8. Bug reports
--------------
Please send bug reports to "eds()rz-online.de" or post them to the bug tracker
on OS4-depot.
9. Installation
---------------
Doubleclick on the "Install" icon in the unpacked AAMP package.
Everything will be installed automatically. Please follow the
instructions of the installer script.
While installation two external packages will also be installed. This is:
* SystemV_IPC (sysvipc.library) from Peter Bengtsson
* http-handler from Chris Young. Offers the DOS drivers "HTTP:" and "HTTPS:".
Both packages are provided in the "Contrib" drawer.
Please do not install by hand!!
10. Thanks to...
----------------
... all, who donated to the AAMP bounty! Especially I want to mention
Philippe Ferrucci, but I also want to thank:
- Mario Locati
- Marko Seppänen
- Olivier Claes
- Jamie Sayer
- Mathias Parnaudeau
- Troels Ersking
- Martin Rebentisch
- Andreas Schmidt
- Simon Sharratt
... Michael Christoph, who wrote the administration tool!
... Mario Locati (beta-test)
... Hans de Ruiter (help with SSL module)
... Henning Nielsen Lund (author of abc-Shell)
... Peter Bengtsson (author of sysvipc.library)
... Chris Young (author of http-handler)
| |
