Coral: start server utilities

From The Uniform Server Wiki
Jump to navigation Jump to search

Server Utilities

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.

B1 - MySQL Console   B7 - View www
B2 - Server Status   B8 - View ssl
B3 - Apache Syntax Check   B9 - View phpInfo
B4 - Server Configuration   B10 - phpMyAdmin
B5 - Multi Servers   B11 - Server Documentation
B6 - Select Language   B12 - About

UniServer 8-Coral
  Home
» Quick Start
  General
  Apache
  MySQL
  PHP
  MSMTP
  CRON
  DtDNS
  Db Backup
  Perl
  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 MySQL Console

Top

B2 - Server Status

Clicking the Server Status menu button opens a pop-up that displays a list of current server parameters.

General Status

  • Internet accessibility is indicated by the first two items. See 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.

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:

  1. Start > All Programs > Accessories > Command Prompt - Opens a command window
  2. In the command window type: cd C:\UniServer\usr\local\apache2\bin
  3. 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

B4 - Server Configuration

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.

Top

B5 - Multi Servers

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.
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 Multi-Servers Detail.

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

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=http://localhost:80/index.php" - Redirected to this page on server

How to reassign the button and page

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=https://localhost:443/index.php" - Redirected to this page on server

How to reassign the button and page

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=http://localhost:80/us_extra/phpinfo.php" - 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

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=http://localhost:80/us_phpmyadmin/index.php" - Target of redirection on the server

phpMyAdmin Access
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

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

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.