Mini Servers: Introduction: Difference between revisions
(New page: {{Uc nav mini servers}} '''Mini Series''' stretched limo |left'''No!''' Not a range of classic cars but a range of mini servers based on Uniform Server's arch...) |
(Punctuation and grammatical changes; changed categories.) |
||
(7 intermediate revisions by 3 users not shown) | |||
Line 8: | Line 8: | ||
'''''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. | '''''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. | ||
Uniform Server for whatever reason reminded me of a stretched limo thought I would chop it up into three minis! | 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 == | == 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 | Apache is a battle-hardened server the new version (2.2.9) and 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 | 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 is easily configurable. I never like to use something I neither trust or understand hence I hack The Uniform Server to meet these needs. | ||
Uniform Server’s basic architecture and Apache | The 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. | ||
{|width="100%" | {|width="100%" | ||
|-align="center" | |-align="center" | ||
Line 25: | Line 25: | ||
[[Image:Uc_mini_3a.gif|Apache 2.2.9 Perl 5.10]] | [[Image:Uc_mini_3a.gif|Apache 2.2.9 Perl 5.10]] | ||
|} | |} | ||
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. | 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 The Uniform Server's current version. Transferring from a mini server will not be difficult, but since they are based on 3.5-Apollo’s architecture, some changes will need to be made. | |||
{|align="center" | |||
|-align="center" | |||
|width="200"| | |||
[[Image:Uc_mini_1d.gif|Apache 2.2.9 SSL enabled]] | |||
|width="150"| | |||
'''''Two special editions have been added extending server range'''.'' | |||
|width="200"| | |||
[[Image:Uc_mini_4a.gif|MySQL Server]][[Image:Uc_mini_14.gif|MySQL Server]] | |||
|} | |||
=== Table showing full range of mini servers === | === Table showing full range of mini servers === | ||
Line 41: | Line 51: | ||
!PHP | !PHP | ||
!PERL | !PERL | ||
!Port | |||
!Comments | !Comments | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 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="left"|[[Mini Servers: Apache 2.2.9 Service|Server 2]]||Service||402KB||821KB||2.2.9|| || ||8082|| | |||
|-align="center" style="background:#ffffff" | |||
|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 | |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: | |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: | |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: | |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| | |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 | |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 | |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: | |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="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="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="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 | |||
|} | |} | ||
== 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. | |||
== Server | |||
A very basic portable production server for serving web pages (htm and html). Includes a basic web site. | |||
# [[Mini Servers: Apache 2.2.9 Portable|Introduction:]] Intro and security | # [[Mini Servers: Apache 2.2.9 Portable|Introduction:]] Intro and security | ||
Line 74: | Line 93: | ||
# [[Mini Servers: Apache 2.2.9 Portable#Support files|Support files:]] - How to download, unpack server and test. | # [[Mini Servers: Apache 2.2.9 Portable#Support files|Support files:]] - How to download, unpack server and test. | ||
# [[Mini Servers: Apache 2.2.9 Portable#Your web site|Your Web Site:]] Where to put your web site. | # [[Mini Servers: Apache 2.2.9 Portable#Your web site|Your Web Site:]] Where to put your web site. | ||
# [[Mini Servers: Apache 2.2.9 Portable#Summary|Summary:]] Leading onto | # [[Mini Servers: Apache 2.2.9 Portable#Summary|Summary:]] Leading onto mini server 2. | ||
== Server | == 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. | |||
# [[Mini Servers: Apache 2.2.9 Service|Introduction:]] Intro and surgery performed | # [[Mini Servers: Apache 2.2.9 Service|Introduction:]] Intro and surgery performed | ||
Line 87: | Line 106: | ||
# [[Mini Servers: Apache 2.2.9 Service#Support files|Support files:]] - How to download, unpack server and test. | # [[Mini Servers: Apache 2.2.9 Service#Support files|Support files:]] - How to download, unpack server and test. | ||
# [[Mini Servers: Apache 2.2.9 Service#Your web site |Your Web Site:]] Where to put your web site. | # [[Mini Servers: Apache 2.2.9 Service#Your web site |Your Web Site:]] Where to put your web site. | ||
# [[Mini Servers: Apache 2.2.9 Service#Summary|Summary:]] Leading onto | # [[Mini Servers: Apache 2.2.9 Service#Summary|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. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication|Introduction:]] Intro | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#Moving the Server|Moving the Server:]] How to change port to 8080 and virtual drive to z | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#How to enable htaccess|How to enable htaccess:]] and protect from Internet access | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#How to add authentication|How to add authentication:]] Modules required to enable basic authentication | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#Add password folder|:Add password folder]] and file to save name/password pairs. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#How to add mod rewrite|How to add mod rewrite:]] Extremly easy to add mod rewrite. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#Mini server httpd.conf|Mini server httpd.conf:]] Complete configuration file. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#Support files|Support files:]] Download this server. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#Secure1|Secure1:]] How to protect single pages with a name and password. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#Secure2|Secure2:]] How to protect individual folders with a name and password. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication#Summary|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. | |||
This server | |||
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. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL |Introduction:]] Intro | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Folder structure|Folder structure:]] Split the root folders | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Configuration file structure|Configuration file structure:]] Uses two configuration files | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#How to add SSL|How to add SSL:]] Enable SSL in main configuration file | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#ssl.conf|:ssl.conf]] Enable htaccess in SSL config. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Complete configuration files|Complete configuration files:]]Shows both configuration files used. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Support files|Support files:]] Download this server. | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Generate new server Certificate and key|Generate new server Certificate and key:]] Must create new certificate and key | |||
# [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Summary|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. | |||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone|Introduction:]] Intro | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone#Changes made to server 4|Changes made to server 4:]] Overview of changes | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone#Complete configuration file|Complete configuration file:]] New configuration file | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone#Summary of changes|Summary of changes:]] Dtail of chanfes by section. | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone#Support files|Support files:]] Download this server. | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone#Generate new server Certificate and key|Generate new server Certificate and key:]] Must create new certificate and key | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone#Conclusion|Conclusion:]] End of mini server 1 series.. | ||
== Server | == Server 6 - Apache 2.2.9 & PHP 5.2.6 == | ||
A basic portable production server with the added power of PHP. | 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. | ||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Introduction:]] Intro and security | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Introduction:]] Intro and security | ||
Line 146: | Line 173: | ||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Support files|Support files:]] - How to download, unpack server and test. | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Support files|Support files:]] - How to download, unpack server and test. | ||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Your web site|Your Web Site:]] Where to put your web site. | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Your web site|Your Web Site:]] Where to put your web site. | ||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Summary|Summary:]] Leading onto server | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Summary|Summary:]] Leading onto mini server 6 guest book. | ||
== Server | == Mini Server 6 Guest book == | ||
This mini server includes a quest book (version 1.7.2) downloaded from the DigiOz web site. | This mini server includes a quest book (version 1.7.2) downloaded from the DigiOz web site. | ||
# [[Mini Servers: | # [[Mini Servers: Guest book|Introduction:]] Intro to guest book | ||
# [[Mini Servers: | # [[Mini Servers: Guest book#Server configuration problem |Server configuration problem:]] Guest book highlights a server problem. | ||
# [[Mini Servers: | # [[Mini Servers: Guest book#File extensions|File extensions:]] - Shows why you should always a php file extensions. | ||
# [[Mini Servers: | # [[Mini Servers: Guest book#Defensive programming|Defensive programming:]] - Never trust user data! | ||
# [[Mini Servers: | # [[Mini Servers: Guest book#Automated posts|Automated posts:]] Kill the automated post with a captua | ||
# [[Mini Servers: | # [[Mini Servers: Guest book#Summary|Summary:]] Leading onto mini server 7 run as a service. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server | |||
== 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. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|Introduction:]] Intro and surgery performed | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|Introduction:]] Intro and surgery performed | ||
Line 172: | Line 200: | ||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Support files |Support files:]] - How to download, unpack server and test. | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Support files |Support files:]] - How to download, unpack server and test. | ||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Your web site|Your Web Site:]] Where to put your web site. | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Your web site|Your Web Site:]] Where to put your web site. | ||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Summary|Summary:]] Leading onto server | # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Summary|Summary:]] Leading onto mini server 8 MySQL support enabled. | ||
'''''[[# | |||
== Server | == Server 8 - Apache 2.2.9 & PHP 5.2.6 MySQL support enabled== | ||
A basic portable production server with the added power of Perl. | 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. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support|Introduction:]] Intro and security | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Specification|Specification:]] Increased specification. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#PHP MySQL Support|PHP MySQL Support:]] - How to enable MySQL support. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#libmysql.dll Errors|libmysql.dll Errors:]] - How to make sure Apache finds libmysql.dll | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Problem|Problem:]] Reasons why libmysql.dll can not be found | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Solution|Solution:]] Force Apache to load file. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#PHP Mini SQL Admin |PHP Mini SQL Admin:]] A neat little script that complements the server. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Support files|Support files:]] - How to download, unpack server and test. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Your web site|Your Web Site:]] Where to put your web site. | |||
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Summary|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. | |||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Introduction:]] Intro and security | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Introduction:]] Intro and security | ||
Line 186: | Line 231: | ||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Your web site|Your Web Site:]] Where to put your web site. | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Your web site|Your Web Site:]] Where to put your web site. | ||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Problems - shebang|Shebang problem:]] Make sure you are using the correct one | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Problems - shebang|Shebang problem:]] Make sure you are using the correct one | ||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Summary|Summary:]] Leading onto server | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Summary|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. | |||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service|Introduction:]] Intro | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Service|Introduction:]] Intro | ||
Line 199: | Line 247: | ||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Your web site|Your Web Site:]] Where to put your web site. | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Your web site|Your Web Site:]] Where to put your web site. | ||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Problems - shebang|Shebang problem:]] Make sure you are using the correct one | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Problems - shebang|Shebang problem:]] Make sure you are using the correct one | ||
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Summary|Summary:]] Leading onto | # [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Summary|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. | |||
# [[Mini Servers: MySQL 5.0.67 Portable|Introduction:]] Intro | |||
# [[Mini Servers: MySQL 5.0.67 Portable#Specification|Specification:]] Short server specification. | |||
# [[Mini Servers: MySQL 5.0.67 Portable#Support files|Support files:]] - How to download, unpack server and test. | |||
# [[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.67 Portable#PHP|PHP:]] Test script to connect to this server and create a database. | |||
# [[Mini Servers: MySQL 5.0.67 Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection. | |||
# [[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.67 Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | |||
# [[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.67 Portable#Summary|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. | |||
# [[Mini Servers: MySQL 5.0.67 Service|Introduction:]] Intro | |||
# [[Mini Servers: MySQL 5.0.67 Service#Specification|Specification:]] Short server specification. | |||
# [[Mini Servers: MySQL 5.0.67 Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute. | |||
# [[Mini Servers: MySQL 5.0.67 Service#install.bat|install.bat:]] Installs the server as a service. | |||
# [[Mini Servers: MySQL 5.0.67 Service#uninstall.bat |uninstall.bat:]] Uninstalls the service. | |||
# [[Mini Servers: MySQL 5.0.67 Service#console.bat|console.bat:]] Opens a command window to run MySQL clients. | |||
# [[Mini Servers: MySQL 5.0.67 Service#Support files|Support files:]] - How to download, unpack server and test. | |||
# [[Mini Servers: MySQL 5.0.67 Service#Test|Test:]] Quick test guide. | |||
# [[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.67 Service#Change server default port|Change server default port:]] How to change default port 3308. | |||
# [[Mini Servers: MySQL 5.0.67 Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | |||
# [[Mini Servers: MySQL 5.0.67 Service#Change Root password|Change Root password:]] How to change root password. | |||
# [[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.67 Service#Summary|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. | |||
# [[Mini Servers: MySQL 4.1.22 Portable|Introduction:]] Intro | |||
# [[Mini Servers: MySQL 4.1.22 Portable#Specification|Specification:]] Short server specification. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#Support files|Support files:]] - How to download, unpack server and test. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#DOS (CMD) Prompt|DOS (CMD) Prompt:]] How to open and use a command window. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#PHP|PHP:]] Test script to connect to this server and create a database. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#Change server default port|Change server default port:]] How to change default port 3308. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands. | |||
# [[Mini Servers: MySQL 4.1.22 Portable#Summary|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. | |||
# [[Mini Servers: MySQL 4.1.22 Service|Introduction:]] Intro | |||
# [[Mini Servers: MySQL 4.1.22 Service#Specification|Specification:]] Short server specification. | |||
# [[Mini Servers: MySQL 4.1.22 Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute. | |||
# [[Mini Servers: MySQL 4.1.22 Service#install.bat|install.bat:]] Installs the server as a service. | |||
# [[Mini Servers: MySQL 4.1.22 Service#uninstall.bat |uninstall.bat:]] Uninstalls the service. | |||
# [[Mini Servers: MySQL 4.1.22 Service#console.bat|console.bat:]] Opens a command window to run MySQL clients. | |||
# [[Mini Servers: MySQL 4.1.22 Service#Support files|Support files:]] - How to download, unpack server and test. | |||
# [[Mini Servers: MySQL 4.1.22 Service#Test|Test:]] Quick test guide. | |||
# [[Mini Servers: MySQL 4.1.22 Service#Change drive letter and or folder|Change drive letter and or folder:]] How to move the server. | |||
# [[Mini Servers: MySQL 4.1.22 Service#Change server default port|Change server default port:]] How to change default port 3308. | |||
# [[Mini Servers: MySQL 4.1.22 Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | |||
# [[Mini Servers: MySQL 4.1.22 Service#Change Root password|Change Root password:]] How to change root password. | |||
# [[Mini Servers: MySQL 4.1.22 Service#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands. | |||
# [[Mini Servers: MySQL 4.1.22 Service#Summary|Summary]] End of series. | |||
== Summary == | == 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. | Each mini server is complete including an example of the type of web site it can support. The [[Mini Servers: Apache 2.2.9 Portable|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. | ||
---- | ---- | ||
Line 212: | Line 341: | ||
|} | |} | ||
[[Category: Mini Servers]] | [[Category: Mini Servers]] | ||
Latest revision as of 12:31, 16 July 2011
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) and 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 is easily configurable. I never like to use something I neither trust or understand hence I hack The Uniform Server to meet these needs.
The 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 The Uniform Server's current version. Transferring from a mini server will not be difficult, but since they are based on 3.5-Apollo’s architecture, some changes will need to be made.
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 |