Re: [PHP-DEV] Timezone for php_error_log.

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.
>
>
>