View source for Coral: start server utilities

__NOTOC__
<div id="top" style="margin:0;padding: 0px 0px 0px 5px; color: #000; background-color: #FFFFEB; border: 1px solid darkslateblue;"><span id="top" style="margin:0;padding: 0px;font-size:12px">'''''Coral'' :'''&nbsp; [[Coral: start quick start|Quick Start]] | [[Coral: start quick start detail|Quick Start - More Detail]] | [[Coral: start user configuration|User Configuration]] | [[Coral: start run as program|Run as a program]] | [[Coral: start run as service|Run as a service]] | [[Coral: start server utilities|Server Utilities]] | [[Coral: start multi servers|Multi-Servers]]</span></div>

{|style="margin-top:5px;"
|-valign="top"
|
<span style="margin-bottom:5px;font-size:25px;color: #31799F;">Server Utilities</span>

Both UniController menus (started by run as program or run as a service) have a menu section titled Server Utilities which provides useful features, such as single button access to PHPMyAdmin and server configuration.

{|
|-valign="top"
|
{|
|-
|[[#B1 - MySQL Console|B1 - MySQL Console]]              ||&nbsp;||[[#B7 - View www|B7 - View www]]
|-
|[[#B2 - Server Status|B2 - Server Status]]              ||&nbsp;||[[#B8 - View ssl|B8 - View ssl]]
|-
|[[#B3 - Apache Syntax Check|B3 - Apache Syntax Check]]  ||&nbsp;||[[#B9 - View phpInfo|B9 - View phpInfo]]
|-
|[[#B4 - Server Configuration|B4 - Server Configuration]]||&nbsp;||[[#B10 - phpMyAdmin|B10 - phpMyAdmin]]
|-
|[[#B5 - Multi Servers|B5 - Multi Servers]]              ||&nbsp;||[[#B11 - Server Documentation|B11 - Server Documentation]]
|-
|[[#B6 - Select Language|B6 - Select Language]]          ||&nbsp;||[[#B12 - About|B12 - About]]
|}
|
[[Image:Coral_start_menu_options.gif]]
|}

|
{| cellpadding="0" cellspacing="0" style="margin-left:6px;margin-bottom:5px;padding-left:6px;padding-right:6px;font-size:11px;background-color: #FFFFEB;border: 1px solid darkslateblue;"
|-
|colspan="2" style="font-weight:bold;"| UniServer&nbsp;8-Coral
|-
|&nbsp;||[[Coral: Introduction|Home]]
|-
|<span style="font-size: 14px;">»</span>||[[Coral: start quick start|Quick Start]]
|-
|&nbsp;||[[Coral: general intro|General]]
|-
|&nbsp;||[[Coral: apache intro|Apache]]
|-
|&nbsp;||[[Coral: mysql intro|MySQL]]
|-
|&nbsp;||[[Coral: php intro|PHP]]
|-
|&nbsp;||[[Coral: msmtp intro|MSMTP]]
|-
|&nbsp;||[[Coral: cron intro|CRON]]
|-
|&nbsp;||[[Coral: dtdns intro|DtDNS]]
|-
|&nbsp;||[[Coral: dbbackup intro|Db Backup]]
|-
|&nbsp;||[[Coral: perl intro|Perl]]
|-
|&nbsp;||[[Coral: index main|Main Index]]
|}
|}

==B1 - MySQL Console==

The '''MySQL console''' button opens a command window and changes the working directory to the MySQL binary folder. From here you can login to the MySQL server and open a MySQL prompt.

Logging into the server requires a user name and password. The defaults are root and root (root user account). At the first opportunity you should have changed this password! If you have forgotten the root user password, it is retrievable in one of two ways.

* Open file UniServer\coral_con\'''config_tracker.ini''' and look for section '''[MYSQL]''' line '''password =''' .
* Or from UniController: '''Server Configuration''' (B4) > '''MySQL''' > '''Change Password''' - The password is displayed in the bottom left. Do not make any changes; just close the window.

'''Login to MySQL console'''

* At the command prompt, enter: '''mysql –uroot –proot'''
* Quit MySQL monitor by typing: '''exit'''

For more details, see [[Coral: mysql console|MySQL Console]]

'''''[[#top | Top]]'''''
==B2 - Server Status==
Clicking the '''Server Status''' menu button opens a pop-up that displays a list of current server parameters.

{|
|-valign="top"
|
'''General Status'''

* Internet accessibility is indicated by the first two items. See [[Coral: start quick start detail|Quick start details]] for more.
* Newer UniServer version. A server '''version displayed''' means that version is newer and available for download. '''Current''' displayed your server is up to date. '''Unavailable''' indicates, unable to contact the web-server or there was an error.
* Cron is a built in scheduler. It runs pre-defined scripts periodically. By default, it is not running; you can either start it manually or install and run it as a service.
* PHP configuration file (php.ini) shows as either Production or Development. The default is that it is a copy of Production.

'''Apache Server & MySQL Server'''

* Displays ports as set in the configuration file.
* Executable file name changes (digit change) when you run multi-servers (default as shown).
* Service name changes (digit change) when you run multi-servers (default as shown).
* Displays server run status.
* Displays server install status: either as program, service or free to install.

'''Port Status'''

* Displays the current port status.
* Free – No processes are using this port.
* In use by this server – The current server instance is using this port.
* In use by another server - Another process is using the port.
|
[[Image:Coral_start_server_status.gif]]
|}

'''''[[#top | Top]]'''''
==B3 - Apache Syntax Check==
The '''Apache Syntax Check''' button initiates a syntax check on Apache's configuration files. The results are displayed in a pop-up message box. Any errors found require correction before the Apache server will start. The check is equivalent to the following manual procedure:

# Start > All Programs > Accessories > Command Prompt - Opens a command window
# In the command window type: '''cd C:\UniServer\usr\local\apache2\bin'''
# In the command window type: '''httpd1.exe -t'''

'''Note 1:''' The path to the Apache binary in step 2 may be different depending on where you installed The Uniform Server

'''Note 2:''' If you previously ran multi-servers, the Apache binary httpd1.exe in step 3 will have a different digit. 

'''''[[#top | Top]]'''''
==B4 - Server Configuration==
{|
|-valign="top"
|
Clicking the '''Server Configuration''' button opens a pop-up displaying the server configuration menu.

* Clicking each menu heading opens a sub-menu.
* Each sub-menu runs either a configuration menu or opens the default text editor to display or to edit the configuration file.

'''Note:'''

Configuration menu headings are reflected in documentation top left menu. Documentation menu also opens sub-menu items corresponding to configuration items.
|
[[Image:Coral_start_server_configuration.gif]]
|}

'''''[[#top | Top]]'''''
==B5 - Multi Servers==
{|
|-valign="top"
|
'''Multi-servers''' enables you to run more than one copy of The Uniform Server (Apache and MySQL) on the same PC. To achieve this, the executables and services are renamed and the ports the servers run on are changed.


Values under the '''old''' column are the current server values. After clicking “Run Move Servers” these values are overwritten in their corresponding configurations files with the values shown in the '''new''' column.


Changes are reflected in the tray icon, which is numbered 1 to 9. This number generally corresponds to the digit appended to executable and service names. For server sets past 9 the tray icon will not use a digit.


'''Note 1:''' Each server requires its own separate directory. For example, Server set 1 and Server set 2 may have the following directories: C:\UniServer1 and C:\UniServer2.<br />
'''Note 2:''' Normally you run this menu on a newly extracted copy of The Uniform Server, change the directory name, and then add any applications using appropriate configuration parameters.


Thre is more information at [[Coral: start multi servers|Multi-Servers Detail]].
|
[[Image:Coral_start_multi_servers.gif]]
|}

'''''[[#top | Top]]'''''
==B6 - Select Language==
This drop down menu displays the currently supported languages.

Language files are contained in folder UniServer\uni_con\lang. This folder is scanned for all language files (with the exception of the active language file, lang.vbs). The names are then listed in the dropdown menu. Selecting a language overwrites the lang.vbs file with the appropriate language.

A language file name has a corresponding folder name in the documentation folder UniServer\docs. Any references to document pages are automatically switched to the appropriate language folder.

'''Note:''' You are welcome to submit a language file for inclusion in the next release. Use file UniServer\uni_con\lang\English.vbs as a template. 

'''''[[#top | Top]]'''''
==B7 - View www==
This is a user definable button. The default action is to open an html page in the default browser, which then redirects to an index page served by Apache.

* UniServer\tmp\redirect.html - Location and name of redirect file dynamically updated.
* url=<nowiki>http://localhost:80/index.ph</nowiki>p" - Redirected to this page on server

[[Coral:_start_user_configuration#Change www page|How to reassign the button and page]]

'''''[[#top | Top]]'''''
==B8 - View ssl==

This is a user definable button. The default action is to open an html page in the default browser, which then redirects to an index page served by Apache.

* UniServer\tmp\redirect.html - Location and name of redirect file dynamically updated.
* url=<nowiki>https://localhost:443/index.php</nowiki>" - Redirected to this page on server

[[Coral: start user configuration#Change ssl page|How to reassign the button and page]]

'''''[[#top | Top]]'''''
==B9 - View phpInfo==
This menu button opens an html page in the default browser, which redirects to a page served by Apache. This in turn runs the PHP function phpinfo() displaying a wealth of information relating to PHP. The page provides very detailed information, and a menu splits this into smaller sections, making it easier to read.

* UniServer\tmp\redirect.html - Location and name of redirect file dynamically updated.
* url=<nowiki>http://localhost:80/us_extra/phpinfo.php</nowiki>" - Redirected to this page on server

PHP Info Menu

* Configuration - Displays PHP Core configuration.
* Enviroment - PHP current environment
* Modules - List all modules
* Extensions - Overview and details (includes functions) for all loaded extensions.
* Variables - List all currently available PHP variables.
* General - Intro information

'''''[[#top | Top]]'''''
==B10 - phpMyAdmin==
phpMyAdmin is a MySQL admininstration tool written in PHP. It allows you to perform tasks such as creating, modifying or deleting databases. You can execute SQL statements and manage users and their permissions.

The '''phpMyAdmin menu''' button opens an html page in the default browser, which redirects to the phpMyAdmin index page served by Apache.

* UniServer\tmp\redirect.html - Location and name of the dynamically updated redirect file.
* url=<nowiki>http://localhost:80/us_phpmyadmin/index.php</nowiki>" - Target of redirection on the server

'''phpMyAdmin Access'''<br />
By default phpMyAdmin is accessible only to localhost. To allow access for external users (Intranet and Internet), refer to the phpMyAdmin Access page for details.

'''''[[#top | Top]]'''''
==B11 - Server Documentation==
The Server Documentation button opens the index.html page from which the pages you are reading can be accessed. It follows the structure of the UniController menu. The top level describes commonly used functionality while sub-menus detail the next level of functionality and provide more detailed information. It is self-contained, requiring no external references. This notwithstanding, there is quite a bit of additional information available at The Uniform Server's Wiki site wiki.uniformserver.com

'''''[[#top | Top]]'''''
==B12 - About==
About provides an overview of "UniController", in particular why it was implemented in VbScript and HTAs. In addition to providing support for different languages, a user can easily tailor and modify the menu structure to meet their differing requirements.


----

[[Category: Uniform Server 8-Coral]]