Re: ATTENTION: All PHP (php.net) Mirror Maintainers
| From: | Daniel Brown | Date: | Mon, 09 Nov 2009 20:11:45 +0000 |
| Subject: | Re: ATTENTION: All PHP (php.net) Mirror Maintainers | ||
| References: | 1 2 | Groups: | php.mirrors |
| Request: | Send a blank email to php-mirrors+get-37782@lists.php.net to get a copy of this message | ||
On Mon, Nov 9, 2009 at 14:28, Stream Service <info@streamservice.nl> wrote:
> Hello Daniel,
>
> Is it possible for us (or anyone else) to see if a particular mirror has
> SQLite enabled? I know that there is a page with the PHP version, but I
> don't know if there is a page with if SQLite is installed (and if yes what
> version).
>
> Information would be very welcome.
Absolutely, Mark.
All mirrors - including yours - broadcast some basic information
that our team and network of monitoring systems poll regularly to get
some quick information on the mirror. You can view it on yours by
going to http://nl.php.net/mirror-info . All mirrors
host the info at
/mirror-info , so another example would be
http://ca.php.net/mirror-info .
The information is presented as follows:
MIRROR | PHP_VER | LAST_UPDATE | SQLITE_VER | STATS |
DEFAULT_LANG | NOALIAS | RSYNC_OK
These fields are described as:
MIRROR The full URL to the current mirror.
PHP_VER The version of PHP being used to serve
the mirror content.
LAST_UPDATE Unix epoch timestamp of the last successful
rsync update.
SQLITE_VER A calculation based upon the information
provided in the next paragraph to denote SQLite version(s) available.
STATS Boolean status of the availability of
statistics software on the mirror.
DEFAULT_LANG The default language of the mirror.
NOALIAS An alias check (set statically to
'noalias' by mirror-info).
RSYNC_OK Boolean status of success for most recent
rsync attempt.
Specifically to your question, the SQLITE_VER field explained....
In a function named get_available_sqlites() - which you can view
yourself in your mirror's include/site.inc file - a simple calculation
is performed based upon information the server returns to the mirror
information status routines. For each condition met as the check is
performed, a corresponding integer is added to a total. The
corresponding numbers indicate:
1 SQLite
2 SQLite v3
4 PDO SQLite
8 PDO SQLite2
The combination of the above integers is very similar to the
calculation one would use to set *nix/Linux permissions using the
chmod command. Whereas read+write+execute in chmod is 7 (1 + 2 +
4), a mirror having SQLite, PDO SQLite, and PDO SQLite2 (but not
SQLite v3) would display 13 for it's SQLITE_VER field, because of the
corresponding integer addition calculation (1 + 4 + 8). If a mirror
displays 0 for the field, SQLite is either not installed, not enabled,
not accessible by PHP, or otherwise failing to operate correctly.
Conversely, the highest number (at present) that will be reported is
15, which indicates that the mirror has all four corresponding
versions available.
Using the information above, you can check against your own
mirror, Mark, and see that your system matches against an example I
provided in the above paragraph as well. Checking other mirrors and
calculating the SQLITE_VER field response against the table above will
tell you exactly what SQLite version(s), if any, a mirror has
available.
--
</Daniel P. Brown>
daniel.brown@parasane.net || danbrown@php.net
http://www.parasane.net/ || http://www.pilotpig.net/