Mini Servers: Introduction: Difference between revisions
mNo edit summary |
|||
Line 54: | Line 54: | ||
!Comments | !Comments | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Portable|Server 1]]||Portable|| | |align="left"|[[Mini Servers: Apache 2.2.9 Portable|Server 1]]||Portable||416KB||870KB||2.2.9|| || ||8081|| | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Service|Server 2]]||Service||402KB||821KB||2.2.9|| || ||8082|| | |align="left"|[[Mini Servers: Apache 2.2.9 Service|Server 2]]||Service||402KB||821KB||2.2.9|| || ||8082|| | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication|Server 3]]||Portable|| | |align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication|Server 3]]||Portable||441KB||1.22MB||2.2.9|| || ||8083||align="left"|Includes htaccess, authentication and mod-rewrite | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL| Server 4]]||Portable|| | |align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL| Server 4]]||Portable||995KB||3.02MB||2.2.9|| || ||8084/444||align="left"|As server 3 with added protection of SSL | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone|Server 5]]||Portable|| | |align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone|Server 5]]||Portable||995KB||2.99MB||2.2.9|| || ||8085||align="left"|As server 4 SSL Standalone no main server on port 8084 | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Server 6]]||Portable||2. | |align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Server 6]]||Portable||2.01MB||6.29MB||2.2.9||5.2.6|| ||8086||align="left"|Includes Guest Book | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|Server 7]]||Service||2.27MB||6.59MB||2.2.9||5.2.6|| ||8087||align="left"|Includes Guest Book | |align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|Server 7]]||Service||2.27MB||6.59MB||2.2.9||5.2.6|| ||8087||align="left"|Includes Guest Book | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support|Server 8]]||Portable||2. | |align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support|Server 8]]||Portable||2.44MB||8.24MB||2.2.9||5.2.6|| ||8088||align="left"|Includes Guest Book, PHP Mini SQL Admin and MySQL support enabled. | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Server 9]]||Portable|| | |align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Server 9]]||Portable||918KB||2.66MB||2.2.9|| ||5.10||8089|| | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Service|Server | |align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Service|Server 10]]||Service||904MB||2.36MB||2.2.9|| ||5.10||8090|| | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: MySQL 5.0. | |align="left"|[[Mini Servers: MySQL 5.0.67 Portable|Server 11]]||Portable||1.87MB||10.4MB|| || || ||3311||align="left"|MySQL 5.0.67 Server running on port 3311 | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: MySQL 5.0. | |align="left"|[[Mini Servers: MySQL 5.0.67 Service|Server 12]]||Service||1.85MB||10.2MB|| || || ||3312||align="left"|MySQL 5.0.67 Server running on port 3312 | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: MySQL 4.1.22 Portable|Server 13]]||Portable||1.46MB||6. | |align="left"|[[Mini Servers: MySQL 4.1.22 Portable|Server 13]]||Portable||1.46MB||6.57MB|| || || ||3313||align="left"|MySQL 4.1.22 Server running on port 3313 | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: MySQL 4.1.22 Service|Server 14]]||Service||1.46MB||6.37MB|| || || ||3314||align="left"|MySQL 4.1.22 Server running on port 3314 | |align="left"|[[Mini Servers: MySQL 4.1.22 Service|Server 14]]||Service||1.46MB||6.37MB|| || || ||3314||align="left"|MySQL 4.1.22 Server running on port 3314 | ||
Line 260: | Line 260: | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server 11 - MySQL 5.0. | == Server 11 - MySQL 5.0.67 Portable == | ||
A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use. | A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use. | ||
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. | Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable|Introduction:]] Intro | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#Specification|Specification:]] Short server specification. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#Support files|Support files:]] - How to download, unpack server and test. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#DOS (CMD) Prompt|DOS (CMD) Prompt:]] How to open and use a command window. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#PHP|PHP:]] Test script to connect to this server and create a database. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#Change server default port|Change server default port:]] How to change default port 3308. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Portable#Summary|Summary]] Leading onto mini-server 12. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server 12 - MySQL 5.0. | == Server 12 - MySQL 5.0.67 Service == | ||
A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Easily configured port, change default 3312 to any other port not in use. | A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Easily configured port, change default 3312 to any other port not in use. | ||
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. | Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service|Introduction:]] Intro | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Specification|Specification:]] Short server specification. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#install.bat|install.bat:]] Installs the server as a service. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#uninstall.bat |uninstall.bat:]] Uninstalls the service. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#console.bat|console.bat:]] Opens a command window to run MySQL clients. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Support files|Support files:]] - How to download, unpack server and test. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Test|Test:]] Quick test guide. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Change drive letter and or folder|Change drive letter and or folder:]] How to move the server. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Change server default port|Change server default port:]] How to change default port 3308. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Change Root password|Change Root password:]] How to change root password. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands. | ||
# [[Mini Servers: MySQL 5.0. | # [[Mini Servers: MySQL 5.0.67 Service#Summary|Summary]] Leading onto mini-server 13. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server 13 - MySQL 4.1.22 Portable == | == Server 13 - MySQL 4.1.22 Portable == | ||
This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider. | This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider. |
Revision as of 18:00, 23 September 2008
Mini Servers: Introduction | Support | Server 1 - Portable | Server 2 - Service | Server 3 - Portable Authentication | Server 4 - Portable Authen. SSL | Server 5 - SSL Standalone | Browsers dislike self-signed certificates | Server 6 - PHP 5.2.6 Portable | Server 7 - PHP 5.2.6 Service | Server 8 - MySQL Support | Guest Book | Server 9 - Perl 5.2.6 Portable | Server 10 - Perl 5.2.6 Service | Server 11 - MySQL 5.0.67 Portable | Server 12 - MySQL 5.0.67 Service | Server 13 - MySQL 4.1.22 Portable | Server 14 - MySQL 4.1.22 Service | phpMyAdmin - Mini support | MySQL - General problems |
Mini Servers: Compact but fully functional. |
Mini Series
No! Not a range of classic cars but a range of mini servers based on Uniform Server's architecture. These mini power units are usable in either a portable mode or may be installed to provide a service.
The eight-cylinder Apache 2.2.9 core powers all models. Models come in three formats; basic straight Apache, turbo charged options either Perl 5.10 or the popular PHP 5.2.6.
Note The turbo chargers are a limited edition and slightly under powered, as is the main Apache engine. However these are upgradeable by visiting each manufacture to obtain their latest full production version, these are highly tuned providing maximum raw power.
The mini sever series was sparked off because Uniform Server for whatever reason reminded me of a stretched limo, thought I would chop it up into three minis! Ever taken anything apart only to find after reassembly several parts left over hence the fourth mini server series.
Mini Servers
Apache is a battle-hardened server the new version (2.2.9) bristles with all manner of goodies. Its main features are stability, performance and security some would say at the expense of complexity. In this series I hope to dispel this myth of complexity, what makes Apache so versatile is its wide range of extensions (modules) providing numerous features. This modular approach allows you to tailor the server to your own requirements.
Everyone seems to want bigger better servers with all those bells and whistles occasionally all I want is a small compact test server that performs one specific task and easily configurable. I never like to use something I neither trust or understand hence hack Uniform Server to meet these needs.
Uniform Server’s basic architecture and Apache core make for truly ace compact portable servers. Instead of throwing these away I thought it worthwhile to document and publish them hence this mini server series. In the series I emphasise the need for security don’t take security for granted search the Internet for professional advice and implement.
What use are they? Well these are not toys; first in the series is a small production server for serving basic HTML pages. Minor changes to this basic server allow you to explore and learn server side languages such as Perl and PHP. In keeping with my minimalist philosophy they use only core language elements. Don’t be deceived by this approach they are small powerhouses capable of producing some impressive web sites.
If you do require full language capability use Uniform Server 3.5-Apollo, transferring from a mini server will not be difficult since they are based on 3.5-Apollo’s architecture. (These servers were tested on Windows XP Home only.)
Two special editions have been added extending server range. |
Table showing full range of mini servers
Name | Type | Compressed | Uncompressed | Apache | PHP | PERL | Port | Comments |
---|---|---|---|---|---|---|---|---|
Server 1 | Portable | 416KB | 870KB | 2.2.9 | 8081 | |||
Server 2 | Service | 402KB | 821KB | 2.2.9 | 8082 | |||
Server 3 | Portable | 441KB | 1.22MB | 2.2.9 | 8083 | Includes htaccess, authentication and mod-rewrite | ||
Server 4 | Portable | 995KB | 3.02MB | 2.2.9 | 8084/444 | As server 3 with added protection of SSL | ||
Server 5 | Portable | 995KB | 2.99MB | 2.2.9 | 8085 | As server 4 SSL Standalone no main server on port 8084 | ||
Server 6 | Portable | 2.01MB | 6.29MB | 2.2.9 | 5.2.6 | 8086 | Includes Guest Book | |
Server 7 | Service | 2.27MB | 6.59MB | 2.2.9 | 5.2.6 | 8087 | Includes Guest Book | |
Server 8 | Portable | 2.44MB | 8.24MB | 2.2.9 | 5.2.6 | 8088 | Includes Guest Book, PHP Mini SQL Admin and MySQL support enabled. | |
Server 9 | Portable | 918KB | 2.66MB | 2.2.9 | 5.10 | 8089 | ||
Server 10 | Service | 904MB | 2.36MB | 2.2.9 | 5.10 | 8090 | ||
Server 11 | Portable | 1.87MB | 10.4MB | 3311 | MySQL 5.0.67 Server running on port 3311 | |||
Server 12 | Service | 1.85MB | 10.2MB | 3312 | MySQL 5.0.67 Server running on port 3312 | |||
Server 13 | Portable | 1.46MB | 6.57MB | 3313 | MySQL 4.1.22 Server running on port 3313 | |||
Server 14 | Service | 1.46MB | 6.37MB | 3314 | MySQL 4.1.22 Server running on port 3314 |
Server 1 - Apache core 2.2.9 - Portable
A very basic portable production server for serving web pages (htm and html). Includes a basic web site. Designed to allow multiple servers running on same PC, these require a separate virtual drive automatically created.
- Introduction: Intro and security
- Specification: Four lines! Yep that basic.
- Modules: List all Apache modules used for the server.
- Apache configuration file: - Reduced file to make it clean and understandable.
- Access control: - This access control block defines the server security. Important
- Support files: - How to download, unpack server and test.
- Your Web Site: Where to put your web site.
- Summary: Leading onto mini server 2.
Server 2 - Apache core 2.2.9 - Service
A very basic production server running as a service for serving web pages (htm and html) includes a basic web site. Designed to allow multiple servers running as a service on same PC, will require a separate folder for each server easy to set-up and configure.
- Introduction: Intro and surgery performed
- Specification: Single line change.
- Changes: Outlines what changes are required.
- Apache configuration file: - Highlighted changes in bold.
- Batch files: - Install and Uninstall server as a service.
- Support files: - How to download, unpack server and test.
- Your Web Site: Where to put your web site.
- Summary: Leading onto mini server 3.
Server 3 - Apache core 2.2.9 - htaccess, authentication and mod-rewrite
A very small portable production server for serving web pages (htm and html) includes a basic web site. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
This server has the following enabled, htaccess, basic authentication and mod rewrite. Mod rewrite included enhancing basic authentication. Included are two examples of authentication, protection of single private pages and protection of private folders. A name and password are required to access individual protected areas.
- Introduction: Intro
- Moving the Server: How to change port to 8080 and virtual drive to z
- How to enable htaccess: and protect from Internet access
- How to add authentication: Modules required to enable basic authentication
- :Add password folder and file to save name/password pairs.
- How to add mod rewrite: Extremly easy to add mod rewrite.
- Mini server httpd.conf: Complete configuration file.
- Support files: Download this server.
- Secure1: How to protect single pages with a name and password.
- Secure2: How to protect individual folders with a name and password.
- Summary: Leading onto an SSL enabled mini server 4.
Server 4 - Apache core 2.2.9 - htaccess, authentication and mod-rewrite SSL
A very small portable production server for serving web pages (htm and html) includes a basic web site. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
This server has the following enabled, htaccess, basic authentication and mod rewrite. Mod rewrite included enhancing basic authentication. Included are two examples of authentication, protection of single private pages and protection of private folders. A name and password are required to access individual protected areas.
Increased security is achieved by encrypting name/password pairs and data using SSL. Creating a new server key and certificate is achieved by running a single file making the whole process extremely easy. This server is ideal for a personal secure server.
- Introduction: Intro
- Folder structure: Split the root folders
- Configuration file structure: Uses two configuration files
- How to add SSL: Enable SSL in main configuration file
- :ssl.conf Enable htaccess in SSL config.
- Complete configuration files:Shows both configuration files used.
- Support files: Download this server.
- Generate new server Certificate and key: Must create new certificate and key
- Summary: Leading onto mini server 5
Server 5 - Apache core 2.2.9 - authentication and mod-rewrite SSL Standalone
This very small portable production server is a stand-alone SSL server for serving web pages (htm and html) includes a basic web site. It does not have an insecure server section. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
This server has the following enabled, htaccess, basic authentication and mod rewrite. Mod rewrite included enhancing basic authentication. Included are two examples of authentication, protection of single private pages and protection of private folders. A name and password are required to access individual protected areas.
Increased security is achieved by encrypting name/password pairs and data using SSL. Creating a new server key and certificate is achieved by running a single file making the whole process extremely easy. This server is ideal for a personal secure server.
- Introduction: Intro
- Changes made to server 4: Overview of changes
- Complete configuration file: New configuration file
- Summary of changes: Dtail of chanfes by section.
- Support files: Download this server.
- Generate new server Certificate and key: Must create new certificate and key
- Conclusion: End of mini server 1 series..
Server 6 - Apache 2.2.9 & PHP 5.2.6
A basic portable production server with the added power of PHP allowing dynamic web pages in addition to static htm and html pages. Includes a basic web site and Guest book. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
- Introduction: Intro and security
- Specification: Four lines! Yep that basic.
- Apache configuration file: - Minor changes required to server 1 config file.
- PHP Core: - How to download PHP and extract the core components.
- PHP configuration: Modifications required to php.ini file
- Security: Reduce public visibility and disable system functions.
- Support files: - How to download, unpack server and test.
- Your Web Site: Where to put your web site.
- Summary: Leading onto mini server 6 guest book.
Mini Server 6 Guest book
This mini server includes a quest book (version 1.7.2) downloaded from the DigiOz web site.
- Introduction: Intro to guest book
- Server configuration problem: Guest book highlights a server problem.
- File extensions: - Shows why you should always a php file extensions.
- Defensive programming: - Never trust user data!
- Automated posts: Kill the automated post with a captua
- Summary: Leading onto mini server 7 run as a service.
Server 7 - Apache 2.2.9 & PHP 5.2.6
A basic production server running as a service with the added power of PHP allowing dynamic web pages in addition to static htm and html pages. Includes a basic web site and Guest book. Designed to allow multiple servers running on same PC, will require a separate folder for each server easy to set-up and configure.
- Introduction: Intro and surgery performed
- Specification: Single line change.
- Changes: Outlines what changes are required.
- Apache configuration file: - Highlighted changes in bold.
- PHP configuration file: Highlighted changes in bold.
- Batch files: - Install and Uninstall server as a service.
- Support files: - How to download, unpack server and test.
- Your Web Site: Where to put your web site.
- Summary: Leading onto mini server 8 MySQL support enabled.
Server 8 - Apache 2.2.9 & PHP 5.2.6 MySQL support enabled
A basic portable production server with the added power of PHP allowing dynamic web pages in addition to static htm and html pages. Includes a basic web site and Guest book. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
MySQL support is enabled further enhancing this server’s capability. A neat little script PHP Mini SQL Admin is included allowing you to access a MySQL server.
- Introduction: Intro and security
- Specification: Increased specification.
- PHP MySQL Support: - How to enable MySQL support.
- libmysql.dll Errors: - How to make sure Apache finds libmysql.dll
- Problem: Reasons why libmysql.dll can not be found
- Solution: Force Apache to load file.
- PHP Mini SQL Admin: A neat little script that complements the server.
- Support files: - How to download, unpack server and test.
- Your Web Site: Where to put your web site.
- Summary: Leading onto mini server 9.
Server 9 - Apache 2.2.9 & Perl 5.10
A basic portable production server with the added power of Perl allowing dynamic web pages in addition to static htm and html pages. Includes a basic web site and a demonstration of server side includes, random quotes and image display. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
- Introduction: Intro and security
- Specification: Five lines! Yep that basic.
- Apache configuration file: - Minor changes required to server 1 config file.
- Perl Core: - How to download Perl and extract the core components.
- Security: Reduce public visibility and disable system functions.
- Support files: - How to download, unpack server and test.
- Your Web Site: Where to put your web site.
- Shebang problem: Make sure you are using the correct one
- Summary: Leading onto mini server 10 run as service.
Server 10 - Apache 2.2.9 & Perl 5.10
A basic production server running as a service with the added power of Perl allowing dynamic web pages in addition to static htm and html pages.
Includes a basic web site and a demonstration of server side includes, random quotes and image display. Designed to allow multiple servers running on same PC, will require a separate folder for each server easy to set-up and configure.
- Introduction: Intro
- Specification: Single line change.
- Apache configuration file: - Highlighted changes in bold.
- Batch files: - Install and Uninstall server as a service.
- Support files: - How to download, unpack server and test.
- Your Web Site: Where to put your web site.
- Shebang problem: Make sure you are using the correct one
- Summary: Leading onto server 11 MySQL portable.
Server 11 - MySQL 5.0.67 Portable
A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients mysqladmin and mysql. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use.
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.
- Introduction: Intro
- Specification: Short server specification.
- Support files: - How to download, unpack server and test.
- DOS (CMD) Prompt: How to open and use a command window.
- PHP: Test script to connect to this server and create a database.
- Change Virtual Drive: How to override auto detection.
- Change server default port: How to change default port 3308.
- MySQL - Admin: MySQL client to configure server.
- MySQL - Client program: MySQL client allows you to enter SQL commands.
- Summary Leading onto mini-server 12.
Server 12 - MySQL 5.0.67 Service
A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients mysqladmin and mysql. Easily configured port, change default 3312 to any other port not in use.
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.
- Introduction: Intro
- Specification: Short server specification.
- Configuring MySQL: Change paths to absolute.
- install.bat: Installs the server as a service.
- uninstall.bat: Uninstalls the service.
- console.bat: Opens a command window to run MySQL clients.
- Support files: - How to download, unpack server and test.
- Test: Quick test guide.
- Change drive letter and or folder: How to move the server.
- Change server default port: How to change default port 3308.
- MySQL - Admin: MySQL client to configure server.
- Change Root password: How to change root password.
- MySQL - Client program: MySQL client allows you to enter SQL commands.
- Summary Leading onto mini-server 13.
Server 13 - MySQL 4.1.22 Portable
This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider.
A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients mysqladmin and mysql. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use.
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.
- Introduction: Intro
- Specification: Short server specification.
- Support files: - How to download, unpack server and test.
- DOS (CMD) Prompt: How to open and use a command window.
- PHP: Test script to connect to this server and create a database.
- Change Virtual Drive: How to override auto detection.
- Change server default port: How to change default port 3308.
- MySQL - Admin: MySQL client to configure server.
- MySQL - Client program: MySQL client allows you to enter SQL commands.
- Summary Leading onto mini-server 12.
Server 14 - MySQL 4.1.22 Service
This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider.
A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients mysqladmin and mysql. Easily configured port, change default 3312 to any other port not in use.
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.
- Introduction: Intro
- Specification: Short server specification.
- Configuring MySQL: Change paths to absolute.
- install.bat: Installs the server as a service.
- uninstall.bat: Uninstalls the service.
- console.bat: Opens a command window to run MySQL clients.
- Support files: - How to download, unpack server and test.
- Test: Quick test guide.
- Change drive letter and or folder: How to move the server.
- Change server default port: How to change default port 3308.
- MySQL - Admin: MySQL client to configure server.
- Change Root password: How to change root password.
- MySQL - Client program: MySQL client allows you to enter SQL commands.
- Summary End of series.
Summary
Each mini server is complete including an example of the type of web site it can support. The first in the series is probably about as secure as anyone can make a server on Windows! Well enjoy I hope you can find a use for one of these or just use the full version of Uniform Server.
Ric |