Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:44572
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain m.gmane.org designates 80.91.229.2 as permitted sender)
To: internals@lists.php.net
Date:  Wed, 01 Jul 2009 18:39:36 +0200
Lines: 157
Message-ID: <h2g3g1$e1q$1@ger.gmane.org>
Mime-Version:  1.0
Content-Type:  multipart/mixed;
 boundary="------------010403050401020809090608"
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
Sender: news <news@ger.gmane.org>
Subject:  [5.3] Howto build mysql, mysqli and pdo_mysql with libmysql on Windows
From: carsten_sttgt@gmx.de (Carsten Wiedmann)

--------------010403050401020809090608
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

Hi all,

anybody knows, how to build especially pdo_mysql with libmysql on Windows
(I've managed to build mysql and  mysqli with a change in the config.w32 files)?

My configure string is something like:
| cscript /nologo configure.js --disable-all \
|                              ... \
|                              --without-mysqlnd \
|                              --with-mysql=shared \
|                              --with-mysqli=shared \
|                              --with-pdo-mysql=shared

The build stops with errors in mysql_statement.c, like:
| mysql_statement.c(52) : error C2039: 'stmt'

mysql and mysqli are working fine. All three extensions are working and
build with mysqlnd.

However, how can I connect to a named pipe with mysqlnd. All my scripts are
using the usual hostname = ".". But that's not working with a mysqlnd build.


Another question:

With a default PHP 5.3 installation, I just changed:
| log_errors = On
| error_log = php_errors.log

(date.timezone is still not defined.) Now, if I do a "php -i" in the shell I
have this repeating message in a loop (and a lot of entries in the defined log):
> Warning: Unknown: It is not safe to rely on the system's timezone
> settings. You are *required* to use the date.timezone setting or the
> date_default_timezone_set () function. In case you used any of those
> methods and you are still getting this warning, you most likely
> misspelled the timezone identifier. We selected 'Europe/Paris' for
> '2.0/DST' instead in Unknown on line 0

If I do a phpinfo with the Apache module, my Apache hangs up. I have the
same error messages (in a loop), If I just do a "php -r 'errror;'" in the shell.


BTW:
Why is this a "warning", if I don't set the timezone in "php.ini"?
--> The reason for the timezone applet in my Windows configuration is, to
setup the timezone for all applications at one place.

Well, it's nice that I can change my server timezone for one app (like PHP)
in the config file. But this should only be necessary if I'm knowing what
I'm doing and in really rare cases. (e.g. MySQL is still using my Win server
timezone for time calculations)

Regards,
Carsten




--------------010403050401020809090608
Content-Type: text/plain;
 name="mysql_error.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="mysql_error.txt"

mysqli_warning.c
        rc /n /fo .\Release_TS\php_mysqli.dll.res /d FILE_DESCRIPTION="\"MySQLi\
"" /d FILE_NAME="\"php_mysqli.dll\"" /d URL="\"http://www.php.net\"" /d INTERNAL
_NAME="\"MYSQLI extension\"" /d THANKS_GUYS="\"Thanks to Zak Greant, Georg Richt
er, Andrey Hristov, Ulf Wendel\"" win32\build\template.rc
   Bibliothek .\Release_TS\php_mysqli.lib und Objekt .\Release_TS\php_mysqli.exp
 wird erstellt
EXT mysqli build complete
   Bibliothek .\Release_TS\php_pdo.lib und Objekt .\Release_TS\php_pdo.exp wird
erstellt
EXT pdo build complete
   Bibliothek .\Release_TS\php_pdo_mssql.lib und Objekt .\Release_TS\php_pdo_mss
ql.exp wird erstellt
EXT pdo_mssql build complete
   Bibliothek .\Release_TS\php_pdo_firebird.lib und Objekt .\Release_TS\php_pdo_
firebird.exp wird erstellt
EXT pdo_firebird build complete
mysql_driver.c
mysql_statement.c
ext\pdo_mysql\mysql_statement.c(40) : warning C4005: 'pdo_mysql_stmt_execute_pre
pared' : Makro-Neudefinition
        ext\pdo_mysql\mysql_statement.c(0) : Siehe vorherige Definition von 'pdo
_mysql_stmt_execute_prepared'
ext\pdo_mysql\mysql_statement.c(52) : error C2039: 'stmt' : Ist kein Element von
 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(70) : error C2039: 'params' : Ist kein Element v
on 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(71) : error C2039: 'params' : Ist kein Element v
on 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(71) : error C2198: '_efree' : Nicht genuegend Pa
rameter uebergeben
ext\pdo_mysql\mysql_statement.c(73) : error C2039: 'in_null' : Ist kein Element
von 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(74) : error C2039: 'in_null' : Ist kein Element
von 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(74) : error C2198: '_efree' : Nicht genuegend Pa
rameter uebergeben
ext\pdo_mysql\mysql_statement.c(76) : error C2039: 'in_length' : Ist kein Elemen
t von 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(77) : error C2039: 'in_length' : Ist kein Elemen
t von 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(77) : error C2198: '_efree' : Nicht genuegend Pa
rameter uebergeben
ext\pdo_mysql\mysql_statement.c(127) : error C2039: 'stmt' : Ist kein Element vo
n 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(127) : error C2198: 'mysql_stmt_affected_rows' :
 Nicht genuegend Parameter uebergeben
ext\pdo_mysql\mysql_statement.c(295) : error C2039: 'stmt' : Ist kein Element vo
n 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(678) : error C2039: 'stmt' : Ist kein Element vo
n 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(727) : error C2039: 'stmt' : Ist kein Element vo
n 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(831) : error C2039: 'stmt' : Ist kein Element vo
n 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
ext\pdo_mysql\mysql_statement.c(898) : error C2039: 'stmt' : Ist kein Element vo
n 'pdo_mysql_stmt'
        ext\pdo_mysql\php_pdo_mysql_int.h(114) : Siehe Deklaration von 'pdo_mysq
l_stmt'
NMAKE : fatal error U1077: '"cl.exe"' : Rueckgabe-Code '0x2'
Stop.

--------------010403050401020809090608--