Re: REMINDER: All Official php.net Mirrors MUST Add SQLite Support
| From: | ComunidadHosting | Date: | Tue, 17 Nov 2009 10:09:10 +0000 |
| Subject: | Re: REMINDER: All Official php.net Mirrors MUST Add SQLite Support | ||
| References: | 1 | Groups: | php.mirrors |
| Request: | Send a blank email to php-mirrors+get-37799@lists.php.net to get a copy of this message | ||
Hi Nuno,
You can verify from the weekly report with subject "[mirrors] Status information".
Also, Daniel recently sent a message to this mailing list describing the procedure to check for
this, and I will quote him:
---
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.
---
Warm regards,
Jaime
--
Administrativo
ComunidadHosting : Web hosting en tu idioma
-----Mensaje original-----
De: "Nuno Vieira - nfsi telecom" <nuno.vieira@nfsi.pt>
Enviado: Martes, 17 noviembre, 2009 9:38am
Para: "Daniel Brown" <danbrown@php.net>
CC: "PHP Mirrors List" <php-mirrors@lists.php.net>
Asunto: Re: REMINDER: All Official php.net Mirrors MUST Add SQLite Support
Hello Daniel,
How can we, as a mirror, verify if we are compliant with this rule ?
We've added sqlite support on php5, but we would love to know if everything if properly set.
regards,
---
Nuno Vieira
nfsi telecom, lda.
[Email] nuno.vieira@nfsi.pt
[Phone] +351 21 114 2315
[Phone] +351 21 142 2300
[Mobile] +351 91 925 5561
[Fax] +351 21 114 2301
[Web] http://www.nfsi.pt/
----- "Daniel Brown" <danbrown@php.net> wrote:
> ALL:
>
> Please review the following message originally sent on 9 November,
> 2009:
>
> http://news.php.net/php.mirrors/37780
>
> Please note that failure to comply with this or any policy may
> result in suspension or termination of participation in the official
> mirrors program.
>
> Thank you very much for everyone's great work and generosity.
> The
> PHP community is better as a direct result of what each one of you
> are
> doing. Keep it up!
>
> --
> </Daniel P. Brown>
> daniel.brown@parasane.net || danbrown@php.net
> http://www.parasane.net/ ||
> http://www.pilotpig..net/