System Requirements
This Validator is available as a SOAP service. Our PHP server must have XML, PCRE,
and PEAR support. We need some PEAR modules too. 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
Entering SQL Commands
[ 204 ]
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 also have to 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 by the following:
$cfg['SQLValidator']['username'] = '';
$cfg['SQLValidator']['password'] = '';
If the company has provided us with an account, we can instead use that account
information here.
Validator Results
There are two kinds of reports returned by the Validator: one if the query conforms
to the standard, and another if it does not.
Pages:
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199