Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:45465 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 90726 invoked from network); 3 Sep 2009 12:11:08 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 3 Sep 2009 12:11:08 -0000 Authentication-Results: pb1.pair.com header.from=rquadling@googlemail.com; sender-id=pass; domainkeys=bad Authentication-Results: pb1.pair.com smtp.mail=rquadling@googlemail.com; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain googlemail.com designates 209.85.218.226 as permitted sender) DomainKey-Status: bad X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 X-PHP-List-Original-Sender: rquadling@googlemail.com X-Host-Fingerprint: 209.85.218.226 mail-bw0-f226.google.com Received: from [209.85.218.226] ([209.85.218.226:49867] helo=mail-bw0-f226.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 71/21-19451-A52BF9A4 for ; Thu, 03 Sep 2009 08:11:07 -0400 Received: by bwz26 with SMTP id 26so1411754bwz.23 for ; Thu, 03 Sep 2009 05:11:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:mime-version:received:reply-to:in-reply-to :references:from:date:message-id:subject:to:cc:content-type :content-transfer-encoding; bh=PeBe3RdZbqbR2dqUl7NIu8xjdzGGz2COFZ2cWoJnJ9o=; b=IRkhMYkJ59APwviHKEeUiHDI7NIEnr3MvcViNkEKWbRu9fGoXQ6/exijJ9RLagvGY8 I61OdC6TMHY8+3oxAI56ksxz9h1w80KT93cZTnhXQ0nr5S5YkWkLf8FCswWAPQDe/ACS Im72sCVyigdPH/pWzAfa+QxWpmKg4axamMaC4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=mime-version:reply-to:in-reply-to:references:from:date:message-id :subject:to:cc:content-type:content-transfer-encoding; b=VwYH2wGKTXJwyfWq1KMXSjy1/by8l1ewlBvuChfUDwdYhI17NDJ7bWSmDoawZJg77V +Fl1YLVQsOMGMhF5r28Qu69oyXXReK0lCdwVFDpKceeJwKE+ILvFKZJcxjScaH5g6ezD RgfeHhS+pyt9QU9fG5teOK0y0w1Peiujs7pDI= MIME-Version: 1.0 Received: by 10.223.15.86 with SMTP id j22mr3871377faa.47.1251979863061; Thu, 03 Sep 2009 05:11:03 -0700 (PDT) Reply-To: RQuadling@googlemail.com In-Reply-To: <4A9FB14F.6090608@iki.fi> References: <10845a340909030410i6be64e8aod5bc491a333f69d6@mail.gmail.com> <4A9FB14F.6090608@iki.fi> Date: Thu, 3 Sep 2009 13:10:43 +0100 Message-ID: <10845a340909030510v176000b7me6a0e62cfdf82ab2@mail.gmail.com> To: jani.taskinen@iki.fi Cc: PHP internals , internals-win@lists.php.net Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Subject: Re: [PHP-DEV] Timezone for php_error_log. From: rquadling@googlemail.com (Richard Quadling) 2009/9/3 Jani Taskinen : > Errors output from MINIT can not and will not ever have any other timezon= e > than what is the system's timezone. > > If you're reporting a bug, please do it at http://bugs.php.net/. > > Anyways the code in sqlsrv is pretty horrible. I'd cleanup that mess firs= t. > Unless of course you can reproduce same under something else than windows > and with any other extensions. > > --Jani > > On 09/03/2009 02:10 PM, Richard Quadling wrote: >> >> Hi. >> >> I've been playing with the MS SQL Server driver >> (https://sqlsrvphp.svn.codeplex.com/svn). >> >> Using this code (editing it to work with the default WinResrc.h rather >> than the winres.h it is currently asking for) ... >> >> AND ... >> >> turning on the logging via the ini file (as I was playing I just >> wanted to see what was logged) ... >> >> sqlsrv.LogSeverity =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=3D -1 >> sqlsrv.LogSubsystems =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=3D -1 >> sqlsrv.WarningsReturnAsErrors =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =3D On >> >> The log file shows entries like ... >> >> [03-Sep-2009 11:55:11] PHP Warning: =C2=A0PHP Startup: Unable to load >> dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating system >> cannot run %1. >> =C2=A0in Unknown on line 0 >> [03-Sep-2009 11:55:11] PHP_MINIT_FUNCTION for php_sqlsrv: entering >> [03-Sep-2009 10:55:11] sqlsrv: entering rinit >> [03-Sep-2009 10:55:11] sqlsrv.WarningsReturnAsErrors =3D On >> [03-Sep-2009 10:55:11] sqlsrv.LogSeverity =3D 255 >> [03-Sep-2009 10:55:11] sqlsrv.LogSubsystems =3D 255 >> [03-Sep-2009 10:55:11] sqlsrv: entering rshutdown >> >> In changing /* $Id: main.c 286478 2009-07-29 00:17:10Z stas $ */ ... >> >> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0error_time_str =3D php_format_date("d-M-Y H:i:s", 11, >> error_time, >> php_during_module_startup() TSRMLS_CC); >> >> to >> >> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0error_time_str =3D php_format_date("d-M-Y H:i:s e", >> 13, error_time, >> php_during_module_startup() TSRMLS_CC); >> >> the log file now looks like ... >> >> [03-Sep-2009 11:55:11 Europe/London] PHP Warning: =C2=A0PHP Startup: Una= ble >> to load dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating >> system cannot run %1. >> =C2=A0in Unknown on line 0[03-Sep-2009 11:55:11 Europe/London] >> PHP_MINIT_FUNCTION for php_sqlsrv: entering >> [03-Sep-2009 10:55:11 UTC] sqlsrv: entering rinit >> [03-Sep-2009 10:55:11 UTC] sqlsrv.WarningsReturnAsErrors =3D On >> [03-Sep-2009 10:55:11 UTC] sqlsrv.LogSeverity =3D 255 >> [03-Sep-2009 10:55:11 UTC] sqlsrv.LogSubsystems =3D 255 >> [03-Sep-2009 10:55:11 UTC] sqlsrv: entering rshutdown >> >> I'm not too sure what's going on. I think it has something to do with >> php_during_module_startup(), but I can't work out when the response to >> this function will ever change as it returns a static int value. >> >> The above logs were created using date.timezone=3DEurope/London and call= ing >> ... >> >> php -m >> >> >> >> This gets a little odder when I use ... >> >> php -d date.timezone=3DEurope/Berlin -m >> >> The output is now ... >> >> [03-Sep-2009 12:05:40 Europe/London] PHP Warning: =C2=A0PHP Startup: Una= ble >> to load dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating >> system cannot run %1. >> =C2=A0in Unknown on line 0 >> [03-Sep-2009 13:05:41 Europe/Berlin] PHP_MINIT_FUNCTION for php_sqlsrv: >> entering >> [03-Sep-2009 11:05:41 UTC] sqlsrv: entering rinit >> [03-Sep-2009 11:05:41 UTC] sqlsrv.WarningsReturnAsErrors =3D On >> [03-Sep-2009 11:05:41 UTC] sqlsrv.LogSeverity =3D 255 >> [03-Sep-2009 11:05:41 UTC] sqlsrv.LogSubsystems =3D 255 >> [03-Sep-2009 11:05:41 UTC] sqlsrv: entering rshutdown >> >> >> Don't worry about the specifics of the curl error - this isn't my issue. >> >> >> I would suggest that the datetime extension needs to be loaded before >> the curl library request as I assume this will get the timezone I've >> supplied (Europe/Berlin). >> >> I'm just not sure about the sqlsrv timezone though at all. Why isn't >> this Europe/something rather than UTC? >> >> >> Regards, >> >> Richard. >> >> >> > > What I was looking for was some feedback. As you say, MINIT is system timezone only. That's fine. --=20 ----- Richard Quadling "Standing on the shoulders of some very clever giants!" EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213474= 731 ZOPA : http://uk.zopa.com/member/RQuadling