Aamp-amicygnix

  This is my final release of the AmiCygnix version of the AAMP package.

  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 server "Apache" with compiled in support for the scripting language
  "PHP" and the database server "MySQL".

  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/home_page/index.php) 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.

  Important: This package requires an AmiCygnix environment. If you don't want
             to install the base package (amicygnix-base.lha), which needs about
             170 MB of diskspace, you can install a minimalistic AmiCygnix env-
             ironment called "AmiCygnix-Micro". It needs only about 11 MB and is
             included in this archive. The installer script will install this
             environment, if it cannot find an already installed AmiCygnix
             package.


New in this release
-------------------

  * Apache CGI module is working now.

  * The MySQL frontend "mySQLcontrol" uses now the "pthreads.library" instead
    of the old "threads.library".

  * All binaries are linked with the latest AmiCygnix utility library.

  * Added several examples for PHP and CGI
    (drawer "Cygnix:Software/httpd-2.2.11/htdocs/examples"). Can be opened in
    your browser with "http://localhost/examples".

  * Several bugfixes.


Content
-------

  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)
         - 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)
         - so_module (internal - only for linking external modules statically)
         - php5_module (linked using so module)

         Additional modules (not required for the bounty):

         - headers_module (internal)
         - rewrite_module (internal)
         - ssl_module (internal)

    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 "Cygnix:CygnixPPC/share/man/man1" and
       "Cygnix:CygnixPPC/share/man/man8" and can be viewed with "Next"
       (available on Aminet) and xman, if you've installed the AmiCygnix Base
       package.

    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
    "Cygnix:Software/httpd-2.2.11".

  * 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
       - "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 "Cygnix:CygnixPPC/share/man/man1" and
       "Cygnix:CygnixPPC/share/man/man8" and can be viewed with "Next"
       (available on Aminet) and xman, if you've installed the AmiCygnix Base
       package.

    MySQL is a project of the MySQL team at Sun Microsystems, Inc.
    It is dual-licensed, see "COPYING" and "EXCEPTIONS-CLIENT" in
    "Cygnix/Software/mysql-5.1.35".

  * 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
      - pcre
      - pdf
      - PDO
      - pdo_mysql
      - pdo_sqlite
      - posix
      - ps
      - Reflection
      - session
      - SimpleXML
      - soap
      - SPL
      - SQLite
      - standard
      - tidy
      - tokenizer
      - xml
      - xmlreader
      - xmlwriter
      - xsl
      - zip
      - zlib

      Additional extensions (not required for the bounty):

      - openssl
      - sysvmsg
      - sysvsem
      - sysvshm

    The Unix man file is located in "Cygnix:CygnixPPC/share/man/man1" and can
    be viewed with "Next" (available on Aminet) and xman, if you've installed
    the AmiCygnix Base package.

    PHP is a project of the PHP group and is licensed under the "PHP License,
    version 3.01". See "LICENSE" in "Cygnix:Software/php-5.2".

  * 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).


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 "Cygnix:Software/AAMP-1.1".

  * You can start the script "Start_AAMP.bat" in "Cygnix:Software/AAMP-1.1".
    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".

  * If the AmiCygnix desktop is running, you can choose "Apache 2 HTTP server"
    in the submenu "network" of the panel menu to launch and stop Apache.

    To start and stop the MySQL server, choose "MySQL database server" in the
    same location.


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
  "Cygnix:CygnixPPC/share/info" 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.


Important files and directories
-------------------------------

  * The default location of the Apache documents is:
    "Cygnix:Software/httpd-2.2.11/htdocs".

    Can be changed with "myApacheStarter".

  * The configuration files of the Apache HTTP server are located in:
    "Cygnix:Software/httpd-2.2.11/conf".

  * The default location of the MySQL databases is:
    "Cygnix:CygnixPPC/var/mysql-data".

  * The MySQL configuration file "my.cnf" is located in:
    "Cygnix:CygnixPPC/etc".

  * The PHP configuration file "php.ini" is located in:
    "Cygnix:CygnixPPC/lib".


FAQ
---

  * How can I enable InnoDB tables?

    Open the file "Cygnix:CygnixPPC/etc/my.cnf" with NotePad and comment out
    the line "skip-innodb" and relauch the MySQL server. Comments do start with
    a "#".

  * How can I change the language of the MySQL messages?

    First have a look at the directory "Cygnix:CygnixPPC/share/mysql" to see
    the supported languages. Then open the file "Cygnix:CygnixPPC/etc/my.cnf"
    with NotePad and set the option "language" to your needs.


Problems
--------

  Serious problems:

    None known.

  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 is only a problem for users, who want to use the special functionality
    of this kind of tables: Transactions, row-level locking and foreign keys.
    Basically InnoDB tables are working, but because you cannot make a clear
    shutdown, all InnoDB tables are checked on server startup.

    I had no further problem with InnoDB so far, but you use it on your own
    risk! I recommend to use MyISAM tables.


Bug reports
-----------

  Please send bug reports to "eds()rz-online.de" or post them to the bug tracker
  on OS4-depot.


Installation
------------

  1. Doubleclick on the "Install" icon in the unpacked AmiCygnix package.
     Everything will be installed automatically. Please follow the
     instructions of the installer script.

     Please do not install by hand!!

     If you have not installed the AmiCygnix Base package, you can install
     a small basic AmiCygnix package called "AmiCygnix Micro", which only
     needs about 11 MB on you harddisk.
     It is included in this package and will be installed by the installer
     script if necessary!

  2. Create the necessary network user and groups:

     Before you start AAMP for the first time, please add this to your network
     configuration:

     To "Sys:Devs/Internet/users":

      NAME=daemon UID=1002 GID=46 DIR=/Cygnix/Home/root SHELL=noshell
      NAME=mysql UID=1003 GID=47 DIR=/Cygnix/Home/root SHELL=noshell

     And to "Sys:Devs/Internet/groups":

      NAME=daemon ID=46 USERS=daemon
      NAME=mysql ID=47 USERS=mysql


     The IDs must be adapted to your settings. They must be unique!


Donations
---------

If you like to support my work, you can make a donation by using paypal:

 http://www.schwan-clan.de/amiga/Donate.html

Thanks!


Thanks to...
------------

  ... all, who donated to the AAMP bounty!
  ... Michael Christoph, who wrote the nice GUI tools!
  ... Mario Locati for beta testing!