Re: [PHP-DEV] Timezone for php_error_log.

[email protected] (Richard Quadling)
Newsgroups php.internals,php.internals.win
Message-ID <[email protected]>
2009/9/3 Jani Taskinen <[email protected]>:
> Errors output from MINIT can not and will not ever have any other timezone
> 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 first.
> 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                            = -1
>> sqlsrv.LogSubsystems                          = -1
>> sqlsrv.WarningsReturnAsErrors                 = On
>>
>> The log file shows entries like ...
>>
>> [03-Sep-2009 11:55:11] PHP Warning:  PHP Startup: Unable to load
>> dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating system
>> cannot run %1.
>>  in 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 = On
>> [03-Sep-2009 10:55:11] sqlsrv.LogSeverity = 255
>> [03-Sep-2009 10:55:11] sqlsrv.LogSubsystems = 255
>> [03-Sep-2009 10:55:11] sqlsrv: entering rshutdown
>>
>> In changing /* $Id: main.c 286478 2009-07-29 00:17:10Z stas $ */ ...
>>
>>                        error_time_str = php_format_date("d-M-Y H:i:s", 11,
>> error_time,
>> php_during_module_startup() TSRMLS_CC);
>>
>> to
>>
>>                        error_time_str = 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:  PHP Startup: Unable
>> to load dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating
>> system cannot run %1.
>>  in 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 = On
>> [03-Sep-2009 10:55:11 UTC] sqlsrv.LogSeverity = 255
>> [03-Sep-2009 10:55:11 UTC] sqlsrv.LogSubsystems = 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=Europe/London and calling
>> ...
>>
>> php -m
>>
>>
>>
>> This gets a little odder when I use ...
>>
>> php -d date.timezone=Europe/Berlin -m
>>
>> The output is now ...
>>
>> [03-Sep-2009 12:05:40 Europe/London] PHP Warning:  PHP Startup: Unable
>> to load dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating
>> system cannot run %1.
>>  in 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 = On
>> [03-Sep-2009 11:05:41 UTC] sqlsrv.LogSeverity = 255
>> [03-Sep-2009 11:05:41 UTC] sqlsrv.LogSubsystems = 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.

-- 
-----
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=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.