Databases Reference
In-Depth Information
A free external service, the
Mimer
SQL
Validator
, is available to us, thanks to Mimer
Information Technology AB. It validates our query according to the Core SQL-99 rules
and generates a report. The Validator is available directly from phpMyAdmin, and its
home page is located at
http://developer.mimer.com/validator/index.htm
.
For statistical purposes, this service anonymously stores on its server,
the queries it receives. When storing the queries, it replaces database,
table, and column names with generic names. Strings and numbers
that are part of the query are replaced with generic values so as to
protect the original information.
System requirements
This Validator is available as a SOAP service. Our PHP server must have XML,
PCRE, and SOAP support. SOAP support is offered by either a PHP extension or by
a PEAR module. If we choose the PEAR way, the following command (executed on
the server by the system administrator) installs the modules we need:
pear install Net_Socket Net_URL HTTP_Request Mail_Mime Net_DIME SOAP
If we have problems with this command due to some of the modules being in a
beta state, we can execute the following command, which installs SOAP and other
dependent modules:
pear -d preferred_state=beta install -a SOAP
Making the Validator available
Some parameters must be configured in
config.inc.php
. Setting
$cfg['SQLQuery']['Validate']
to
TRUE
enables the
Validate
SQL
link.
We should also enable the Validator itself (as other validators might be available
on future phpMyAdmin versions). This is done by setting
$cfg['SQLValidator']
['use']
to
TRUE
.
The Validator is accessed with an anonymous Validator account by default, as
configured using the following commands:
$cfg['SQLValidator']['username'] = '';
$cfg['SQLValidator']['password'] = '';
Instead, if Mimer Information Technology has provided us with an account, we can
use that account information here.
Search WWH ::
Custom Search