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...) |
mNo edit summary |
||
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 == | ||
Line 15: | Line 15: | ||
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. | 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 | 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 28: | Line 28: | ||
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.) | 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.) | ||
{|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]] | |||
|} | |||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
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||451KB||1MB||2.2.9|| || ||8081|| | ||
|-align="center" style="background:#ffffff" | |-align="center" style="background:#ffffff" | ||
|align="left"|[[Mini Servers: Apache 2.2.9 Service| | |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: | |align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication|Server 3]]||Portable||475KB||1.17MB||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: | |align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL| Server 4]]||Portable||1MB||2.89MB||2.2.9|| || ||8084/444||align="left"|As server 1c 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||1MKB||2.87MB||2.2.9|| || ||8085||align="left"|As server 1d 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| | |align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Server 6]]||Portable||2.02MB||5.87MB||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| | |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 | |align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support|Server 8]]||Portable||2.47MB||7.93MB||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 Service| | |align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Server 9]]||Portable||953KB||2.54MB||2.2.9|| ||5.10||8089|| | ||
|-align="center" style="background:#ffffff" | |||
|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="left"|[[Mini Servers: MySQL 5.0.51b Portable|Server 11]]||Portable||1.85MB||10.2MB|| || || ||3311||align="left"|MySQL 5.0.51b Server running on port 3311 | |||
|-align="center" style="background:#ffffff" | |||
|align="left"|[[Mini Servers: MySQL 5.0.51b Service|Server 12]]||Service||1.85MB||10.2MB|| || || ||3312||align="left"|MySQL 5.0.51b 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.38MB|| || || ||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 | |||
|} | |} | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server | == 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. | 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. | ||
# [[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 95: | ||
# [[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. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== 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 109: | ||
# [[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. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
# [[Mini Servers: | == Server 3 - Apache core 2.2.9 - htaccess, authentication and mod-rewrite== | ||
# [[Mini Servers: | 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. | ||
# [[Mini Servers: | |||
# [[Mini Servers: | 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: | |||
# [[Mini Servers: | |||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication|Introduction:]] Intro | ||
# [[Mini Servers: | # [[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: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication#How to enable htaccess|How to enable htaccess:]] and protect from Internet access | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication#How to add authentication|How to add authentication:]] Modules required to enable basic authentication | ||
# [[Mini Servers: | # [[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. | |||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server | == 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. | |||
# [[Mini Servers: | 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: | |||
# [[Mini Servers: | 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: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL |Introduction:]] Intro | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Folder structure|Folder structure:]] Split the root folders | ||
# [[Mini Servers: | # [[Mini Servers: Apache 2.2.9 Portable - Authentication SSL#Configuration file structure|Configuration file structure:]] Uses two configuration files | ||
# [[Mini Servers: | # [[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: | # [[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 | |||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server | == Server 5 - Apache core 2.2.9 - authentication and mod-rewrite SSL Standalone== | ||
This server is | 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.. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== 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 180: | ||
# [[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. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== 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 207: | ||
# [[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. | ||
'''''[[#top | Top]]''''' | |||
== 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. | |||
# [[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. | |||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server | |||
A basic portable production server with the added power of Perl. | == 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 240: | ||
# [[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. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Server | |||
== 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 256: | ||
# [[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. | ||
'''''[[#top | Top]]''''' | |||
== Server 11 - MySQL 5.0.51b 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.51b Portable|Introduction:]] Intro | |||
# [[Mini Servers: MySQL 5.0.51b Portable#Specification|Specification:]] Short server specification. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#Support files|Support files:]] - How to download, unpack server and test. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#DOS (CMD) Prompt|DOS (CMD) Prompt:]] How to open and use a command window. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#PHP|PHP:]] Test script to connect to this server and create a database. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#Change server default port|Change server default port:]] How to change default port 3308. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands. | |||
# [[Mini Servers: MySQL 5.0.51b Portable#Summary|Summary]] Leading onto mini-server 12. | |||
'''''[[#top | Top]]''''' | |||
== Server 12 - MySQL 5.0.51b 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.51b Service|Introduction:]] Intro | |||
# [[Mini Servers: MySQL 5.0.51b Service#Specification|Specification:]] Short server specification. | |||
# [[Mini Servers: MySQL 5.0.51b Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute. | |||
# [[Mini Servers: MySQL 5.0.51b Service#install.bat|install.bat:]] Installs the server as a service. | |||
# [[Mini Servers: MySQL 5.0.51b Service#uninstall.bat |uninstall.bat:]] Uninstalls the service. | |||
# [[Mini Servers: MySQL 5.0.51b Service#console.bat|console.bat:]] Opens a command window to run MySQL clients. | |||
# [[Mini Servers: MySQL 5.0.51b Service#Support files|Support files:]] - How to download, unpack server and test. | |||
# [[Mini Servers: MySQL 5.0.51b Service#Test|Test:]] Quick test guide. | |||
# [[Mini Servers: MySQL 5.0.51b Service#Change drive letter and or folder|Change drive letter and or folder:]] How to move the server. | |||
# [[Mini Servers: MySQL 5.0.51b Service#Change server default port|Change server default port:]] How to change default port 3308. | |||
# [[Mini Servers: MySQL 5.0.51b Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server. | |||
# [[Mini Servers: MySQL 5.0.51b Service#Change Root password|Change Root password:]] How to change root password. | |||
# [[Mini Servers: MySQL 5.0.51b Service#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands. | |||
# [[Mini Servers: MySQL 5.0.51b Service#Summary|Summary]] Leading onto mini-server 13. | |||
'''''[[#top | Top]]''''' | |||
== 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. | |||
'''''[[#top | Top]]''''' | |||
== 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. | |||
'''''[[#top | Top]]''''' | |||
== 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. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
Line 211: | Line 353: | ||
| [[Image:uc_small_logo.gif]] || [[User:Ric|Ric]] | | [[Image:uc_small_logo.gif]] || [[User:Ric|Ric]] | ||
|} | |} | ||
[[Category: UniCenter]] | [[Category: UniCenter]] |
Revision as of 14:18, 17 August 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 | 451KB | 1MB | 2.2.9 | 8081 | |||
Server 2 | Service | 402KB | 821KB | 2.2.9 | 8082 | |||
Server 3 | Portable | 475KB | 1.17MB | 2.2.9 | 8083 | Includes htaccess, authentication and mod-rewrite | ||
Server 4 | Portable | 1MB | 2.89MB | 2.2.9 | 8084/444 | As server 1c with added protection of SSL | ||
Server 5 | Portable | 1MKB | 2.87MB | 2.2.9 | 8085 | As server 1d SSL Standalone no main server on port 8084 | ||
Server 6 | Portable | 2.02MB | 5.87MB | 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.47MB | 7.93MB | 2.2.9 | 5.2.6 | 8088 | Includes Guest Book, PHP Mini SQL Admin and MySQL support enabled. | |
Server 9 | Portable | 953KB | 2.54MB | 2.2.9 | 5.10 | 8089 | ||
Server 10 | Service | 904MB | 2.36MB | 2.2.9 | 5.10 | 8090 | ||
Server 11 | Portable | 1.85MB | 10.2MB | 3311 | MySQL 5.0.51b Server running on port 3311 | |||
Server 12 | Service | 1.85MB | 10.2MB | 3312 | MySQL 5.0.51b Server running on port 3312 | |||
Server 13 | Portable | 1.46MB | 6.38MB | 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.51b 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.51b 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 |