Figure 7-35
Manage mySQL Server
This section is used to manage MySQL. MySQL, is a database application used by web developers to make websites with dynamic content. The features shown below in Figure 7-36 are the only management functions needed in the SMT/cpanel. This provides the ability to start, stop and restart the MySQL “daemon” or service. Please note that this is not a utility for mSQL.
Figure 7-36
Will be added shortly.
To start the daemon or service, simply click the “Start/Restart MySQL Server” link. The output (See Figure 7-37) will show that the service started successfully.
Figure 7-37
Will be added shortly.
Check Perl Scripts for Common Errors
This feature helps check perl scripts for simple errors. The error checking is done by a program in the SMT/cpanel. See Figure 7-36 for an example. This program will test 4 areas:
TEST 1: script and permissions
This test ensures that the file exists in the location specified on the virtual server, and that the permissions and ownership are properly set. For example, if the perl script that a user is checking is found to be 644, or not executable, it will correct the permissions and change the script to 755, which is executable permissions.
TEST 2: script file format
This test ensures that the file was uploaded in ASCII (pronounced “asky”) mode and not binary mode. It will strip out any unwanted characters that sometimes can’t be seen on a Windows operating system.
TEST 3: check perl path
This test checks the path at the top of the perl script and ensures that it is set to the location where the perl binary is located on the virtual server. The path to perl, or the first line in any perl script should always be one of the following two lines.
#!/usr/bin/perl
#!/bin/perl
TEST 4: perl syntax
This test reviews the basic syntax of the perl script. It may find simple errors, and correct them or point them out; however, this is a cursory review of the syntax, and will not evaluate logic errors. Scripts that are found freely on the Internet should work out of the box with some simple configuration changes. This test should inform the user whether the syntax for those changes is correct.
If the script passes all the tests but still won’t run, it could be one of the following areas.
Make sure it can find any files or external programs it needs
Make sure any included perl programs also check out
Make sure you are writing a "Content-type:" line at the beginning of the script’s output
Figure 7-38
Reset WWW Log Files
This feature will reset or “zero out” all web server logs in the logs directory for the top level domain name. The files that are reset are as follows:
/www/logs/access_log
/www/logs/error_log
To reset the log files, simply click on the button as shown in Figure 7-37.
NOTE: This feature does NOT reset log files for virtual host domains on the server. Log files for each virtual host will need to be zero’ed out by FTP, telnet or other scripting means.
| 