Timezone for php_error_log. View as Markdown

2009/9/3 Jani Taskinen jani.taskinen@iki.fi:

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

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