I probably need to roll back a bit further, but I already have the current hg
cone of php-src on the main repo here, so I've cloned a PHP5.3 and PHP5.4 from
it to work on from my SUSE11.3 machine. This is a gash development machine so I
can screw up the PHP to my harts content ;)
Added autoconf2.13 to get ./buildconf running, and I'm in the 5.3 copy but I'm
getting
'suspicious cache-id, must contain cv to be cached'
against the pdo drivers including php_firebird which is exactly where I want to
work.
Do I need to download all of this from SVN or am I simply missing something? A
quick check seems to point to the cv being a PHP5.4 change?
--
Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
Hello, Lester, try to start from scratch by running ./vcsclean first,
often it helps to solve all cache issues from previous builds.
2011/9/9 Lester Caine lester@lsces.co.uk:
I probably need to roll back a bit further, but I already have the current
hg cone of php-src on the main repo here, so I've cloned a PHP5.3 and PHP5.4
from it to work on from my SUSE11.3 machine. This is a gash development
machine so I can screw up the PHP to my harts content ;)Added autoconf2.13 to get ./buildconf running, and I'm in the 5.3 copy but
I'm getting
'suspicious cache-id, must contain cv to be cached'
against the pdo drivers including php_firebird which is exactly where I want
to work.Do I need to download all of this from SVN or am I simply missing something?
A quick check seems to point to the cv being a PHP5.4 change?--
Lester Caine - G8HFLContact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php--
--
Regards,
Shein Alexey
Alexey Shein wrote:
Hello, Lester, try to start from scratch by running ./vcsclean first,
often it helps to solve all cache issues from previous builds.
No go ...
'Can't figure out your VCS, not cleaning.'
This is a clone from the hg.php.net mirror, so there should not be any SVN or
other build stuff present.
But it does look like I'm seeing a 'leak' from the PHP5.4 version as that is
running ./buildconf clean ... just need to add the PHP_AUTOCONF= into each copy
so I can switch between builds easily.
I'll play with the 5.4 build at the moment, the tests are identical across all
three branches anyway.
--
Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
Alexey Shein wrote:
Hello, Lester, try to start from scratch by running ./vcsclean first,
often it helps to solve all cache issues from previous builds.No go ...
'Can't figure out your VCS, not cleaning.'
the vcsclean script only support cvs, svn and git currently.
basically it just deletes the ignored files present, so if the hg
knows about the ignored files (I think the svn:ignore properties were
migrated to git, so they should be available), then you should be able
to see those files with
hg status -i
delete those files, and try ./buildconf again, or you can also try
./buildconf --force
--
Ferenc Kovács
@Tyr43l - http://tyrael.hu
Lester Caine wrote:
I'll play with the 5.4 build at the moment, the tests are identical across all
three branches anyway.
OK I've posted a bug report https://bugs.php.net/bug.php?id=55659 - very painful
process to get through and I'm sure I'll forget all the mistakes before my next
post :(
This fixes the 003 and 006 errors in ext/interbase/tests
Also listed is 007, but this is working fine on all the machines here, although
008 is time dependent and can fail if other activity is slowing down the
database connection.
--
Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
Hello, Lester, I've managed to setup pdo_firebird, here's the process
for the ubuntu if you're interested:
- setup firebird superclassic:
$ sudo apt-get install firebird2.5-superclassic firebird2.5-dev
firebird2.5-examples
superclassic is the server itself, dev package contains headers to
compile pdo stuff, examples contains example db, i used it to run
tests in it.
Set up credentials for the server (see the link lower).
Get employee.fdb as written here
http://www.firebirdsql.org/manual/ubusetup.html to a some known and
writable path by your user (which tests will be run on).
- compile php with following flags, you'll need interbase too (some
tests in pdo_firebird/tests need it)
./configure --disable-all --enable-pdo --with-pdo-firebird --with-interbase
make - Run tests with environment variables that can be found in
ext/pdo_firebird/tests/common.phpt, I ran it like this:
$ PDO_FIREBIRD_TEST_DSN='firebird:dbname=/var/lib/firebird/2.5/data/employee.fdb'
PDO_FIREBIRD_TEST_USER='SYSDBA' PDO_FIREBIRD_TEST_PASS='masterkey'
TEST_PHP_EXECUTABLE=auto php -n ./run-tests.php ext/pdo_firebird
Tests run very slowly and mostly (if not all) fail. You will get
something like this:
conf@laptop ~/php-src/trunk $
PDO_FIREBIRD_TEST_DSN='firebird:dbname=/var/lib/firebird/2.5/data/employee.fdb'
PDO_FIREBIRD_TEST_USER='SYSDBA' PDO_FIREBIRD_TEST_PASS='masterkey'
./run-tests.php ext/pdo_firebird
=====================================================================
PHP : /home/conf/php-src/trunk/sapi/cli/php
PHP_SAPI
: cli
PHP_VERSION
: 5.5.0-dev
ZEND_VERSION: 2.4.0
PHP_OS
: Linux - Linux laptop 2.6.38-11-generic #48-Ubuntu SMP
Fri Jul 29 19:02:55 UTC 2011 x86_64
INI actual : /home/conf/php-src/trunk
More .INIs :
PHP : /home/conf/php-src/trunk/sapi/cgi/php-cgi
PHP_SAPI
: cgi-fcgi
PHP_VERSION
: 5.5.0-dev
ZEND_VERSION: 2.4.0
PHP_OS
: Linux - Linux laptop 2.6.38-11-generic #48-Ubuntu SMP
Fri Jul 29 19:02:55 UTC 2011 x86_64
INI actual : /home/conf/php-src/trunk
More .INIs :
CWD : /home/conf/php-src/trunk
Extra dirs :
VALGRIND : Not used
Running selected tests.
---> ext/pdo/tests (FIREBIRD [ext/pdo_firebird/tests/common.phpt]) begin
PASS FIREBIRD Bug #47769 (Strange extends PDO)
[ext/pdo_firebird/tests/bug47769.phpt]
FAIL FIREBIRD PDO Common: Bug #34630 (inserting streams as LOBs)
[ext/pdo_firebird/tests/bug_34630.phpt]
PASS FIREBIRD PDO Common: Bug #34687 (query doesn't return error
information) [ext/pdo_firebird/tests/bug_34687.phpt]
FAIL FIREBIRD PDO Common: Bug #35671 (binding by name breakage)
[ext/pdo_firebird/tests/bug_35671.phpt]
PASS FIREBIRD PDO Common: Bug #36428 (Incorrect error message for
PDO::fetchAll()) [ext/pdo_firebird/tests/bug_36428.phpt]
FAIL FIREBIRD PDO Common: Bug #36798 (Error parsing named parameters
with queries containing high-ascii chars)
[ext/pdo_firebird/tests/bug_36798.phpt]
FAIL FIREBIRD PDO Common: Bug #38253 (PDO produces segfault with
default fetch mode) [ext/pdo_firebird/tests/bug_38253.phpt]
FAIL FIREBIRD PDO Common: Bug #38394 (Prepared statement error stops
subsequent statements) [ext/pdo_firebird/tests/bug_38394.phpt]
FAIL FIREBIRD PDO Common: Bug #39398 (Booleans are not automatically
translated to integers) [ext/pdo_firebird/tests/bug_39398.phpt]
FAIL FIREBIRD PDO Common: Bug #39656 (Crash when calling fetch() on a
PDO statment object after closeCursor())
[ext/pdo_firebird/tests/bug_39656.phpt]
FAIL FIREBIRD PDO Common: Bug #40285 (The prepare parser goes into an
infinite loop on ': or ":) [ext/pdo_firebird/tests/bug_40285.phpt]
FAIL FIREBIRD PDO Common: Bug #42917 (PDO::FETCH_KEY_PAIR doesn't work
with setFetchMode) [ext/pdo_firebird/tests/bug_42917.phpt]
FAIL FIREBIRD PDO Common: Bug #43130 (Bound parameters cannot have -
in their name) [ext/pdo_firebird/tests/bug_43130.phpt]
FAIL FIREBIRD PDO Common: Bug #43139 (PDO ignore
ATTR_DEFAULT_FETCH_MODE in some cases with fetchAll())
[ext/pdo_firebird/tests/bug_43139.phpt]
PASS FIREBIRD PDO Common: Bug #43663 (__call on classes derived from
PDO) [ext/pdo_firebird/tests/bug_43663.phpt]
PASS FIREBIRD Bug #44159 (Crash:
$pdo->setAttribute(PDO::STATEMENT_ATTR_CLASS, NULL))
[ext/pdo_firebird/tests/bug_44159.phpt]
FAIL FIREBIRD PDO Common: Bug #44173 (PDO->query() parameter
parsing/checking needs an update)
[ext/pdo_firebird/tests/bug_44173.phpt]
FAIL FIREBIRD PDO Common: Bug #44409 (PDO::FETCH_SERIALIZE calls
__construct()) [ext/pdo_firebird/tests/bug_44409.phpt]
SKIP FIREBIRD PDO Common: Bug #44861 (scrollable cursor don't work
with pgsql) [ext/pdo_firebird/tests/bug_44861.phpt] reason: Scrollable
cursors not supported
FAIL FIREBIRD PDO Common: Bug #50458 (PDO::FETCH_FUNC fails with
Closures) [ext/pdo_firebird/tests/bug_50458.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_ASSOC
[ext/pdo_firebird/tests/pdo_001.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_NUM [ext/pdo_firebird/tests/pdo_002.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_BOTH [ext/pdo_firebird/tests/pdo_003.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_OBJ [ext/pdo_firebird/tests/pdo_004.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_CLASS
[ext/pdo_firebird/tests/pdo_005.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_GROUP
[ext/pdo_firebird/tests/pdo_006.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_UNIQUE
[ext/pdo_firebird/tests/pdo_007.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_UNIQUE conflict
[ext/pdo_firebird/tests/pdo_008.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_CLASSTYPE
[ext/pdo_firebird/tests/pdo_009.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_CLASSTYPE and GROUP/UNIQUE
[ext/pdo_firebird/tests/pdo_010.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_FUNC and statement overloading
[ext/pdo_firebird/tests/pdo_011.phpt]
FAIL FIREBIRD PDO Common: PDOStatement::setFetchMode
[ext/pdo_firebird/tests/pdo_012.phpt]
FAIL FIREBIRD PDO Common: PDOStatement iterator
[ext/pdo_firebird/tests/pdo_013.phpt]
FAIL FIREBIRD PDO Common: PDOStatement SPL iterator
[ext/pdo_firebird/tests/pdo_014.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_COLUMN
[ext/pdo_firebird/tests/pdo_015.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_BOUND
[ext/pdo_firebird/tests/pdo_016.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_BOUND w/o :
[ext/pdo_firebird/tests/pdo_016a.phpt]
FAIL FIREBIRD PDO Common: transactions [ext/pdo_firebird/tests/pdo_017.phpt]
FAIL FIREBIRD PDO Common: serializing [ext/pdo_firebird/tests/pdo_018.phpt]
FAIL FIREBIRD PDO Common: fetch() and while()
[ext/pdo_firebird/tests/pdo_019.phpt]
FAIL FIREBIRD PDO Common: PDOStatement::columnCount
[ext/pdo_firebird/tests/pdo_020.phpt]
FAIL FIREBIRD PDO Common: PDOStatement::execute with parameters
[ext/pdo_firebird/tests/pdo_021.phpt]
SKIP FIREBIRD PDO Common: PDOStatement::getColumnMeta
[ext/pdo_firebird/tests/pdo_022.phpt] reason: this feature is not yet
finalized, no test makes sense
FAIL FIREBIRD PDO Common: extending PDO [ext/pdo_firebird/tests/pdo_023.phpt]
FAIL FIREBIRD PDO Common: assert that bindParam does not modify
parameter [ext/pdo_firebird/tests/pdo_024.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_INTO [ext/pdo_firebird/tests/pdo_025.phpt]
FAIL FIREBIRD PDO Common: extending PDO (2)
[ext/pdo_firebird/tests/pdo_026.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_LAZY [ext/pdo_firebird/tests/pdo_027.phpt]
FAIL FIREBIRD PDO Common: bindValue [ext/pdo_firebird/tests/pdo_028.phpt]
FAIL FIREBIRD PDO Common: extending PDO (3)
[ext/pdo_firebird/tests/pdo_029.phpt]
FAIL FIREBIRD PDO Common: extending PDO (4)
[ext/pdo_firebird/tests/pdo_030.phpt]
FAIL FIREBIRD PDO Common: PDOStatement SPL iterator
[ext/pdo_firebird/tests/pdo_031.phpt]
FAIL FIREBIRD PDO Common: PDO::ATTR_CASE [ext/pdo_firebird/tests/pdo_032.phpt]
FAIL FIREBIRD PDO Common: PDO::quote() [ext/pdo_firebird/tests/pdo_033.phpt]
FAIL FIREBIRD PDO Common: PDO::FETCH_KEY_PAIR fetch mode test
[ext/pdo_firebird/tests/pdo_034.phpt]
PASS FIREBIRD PDO Common: PDORow + get_parent_class()
[ext/pdo_firebird/tests/pdo_035.phpt]
PASS FIREBIRD Testing PDORow and PDOStatement instances with
Reflection [ext/pdo_firebird/tests/pdo_036.phpt]
PASS FIREBIRD Crash when calling a method of a class that inherits
PDOStatement [ext/pdo_firebird/tests/pdo_037.phpt]
PASS FIREBIRD Trying instantiate a PDORow object manually
[ext/pdo_firebird/tests/pdorow.phpt]
FAIL FIREBIRD PDO Common: PECL Bug #5217 (serialize/unserialze safety)
[ext/pdo_firebird/tests/pecl_bug_5217.phpt]
FAIL FIREBIRD PDO Common: PECL Bug #5772 (PDO::FETCH_FUNC breaks on
mixed case func name) [ext/pdo_firebird/tests/pecl_bug_5772.phpt]
FAIL FIREBIRD PDO Common: PECL Bug #5809
(PDOStatement::execute(array()) changes param)
[ext/pdo_firebird/tests/pecl_bug_5809.phpt]
---> ext/pdo/tests (FIREBIRD [ext/pdo_firebird/tests/common.phpt]) done
PASS PDO_Firebird: connect/disconnect [ext/pdo_firebird/tests/connect.phpt]
PASS PDO_Firebird: DDL/transactions [ext/pdo_firebird/tests/ddl.phpt]
PASS PDO_Firebird: prepare/execute/binding
[ext/pdo_firebird/tests/execute.phpt]
FAIL PDO_Firebird: rowCount [ext/pdo_firebird/tests/rowCount.phpt]
Number of tests : 66 64
Tests skipped : 2 ( 3.0%) --------
Tests warned : 0 ( 0.0%) ( 0.0%)
Tests failed : 52 ( 78.8%) ( 81.2%)
Expected fail : 0 ( 0.0%) ( 0.0%)
Tests passed : 12 ( 18.2%) ( 18.8%)
Time taken : 5778 seconds
Good luck!
P.S. If you want to see test results on my machine, drop me a letter.
2011/9/10 Lester Caine lester@lsces.co.uk:
Lester Caine wrote:
I'll play with the 5.4 build at the moment, the tests are identical across
all
three branches anyway.OK I've posted a bug report https://bugs.php.net/bug.php?id=55659 - very
painful process to get through and I'm sure I'll forget all the mistakes
before my next post :(This fixes the 003 and 006 errors in ext/interbase/tests
Also listed is 007, but this is working fine on all the machines here,
although 008 is time dependent and can fail if other activity is slowing
down the database connection.--
Lester Caine - G8HFLContact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php--
--
Regards,
Shein Alexey
Alexey Shein wrote:
Tests run very slowly and mostly (if not all) fail. You will get
something like this:
Forgot to add - the failure is the connection finally timing out ... which is
set to rather a long period :(
--
Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
( Forgot the address ;) )
Alexey Shein wrote:
Hello, Lester, I've managed to setup pdo_firebird, here's the process
for the ubuntu if you're interested:
Alexey ... I've got the pdo stuff working on SUSE, but there is something basic
wrong with the way the pdo tests work.
I have the first few pdo_0xx tests working fine as stand alone tests, and even
some of the bug entries work fine when run in isolation. The problem is coming
from the earlier tests putting the connection into a stuck state - and I suspect
that it's the default way pdo handles transactions. Or simply waiting for the
previous test to roll back before trying to recreate and use the same table
again. Ideally one would not continually open and close the same connection.
My next step is to remove all the tests from the pdo/tests directory and put
them back one by one until I hit the problem, but the main problem with many of
the tests is that they are testing database specific 'problems' rather than ONLY
testing for features that are designed to work cross database. Nothing database
specific should be in the generic tests, and there is probably several days work
to build firebird versions of the oracle blob tests, restoring tests which are
disabled because pgsql or mysql don't support them and things like that.
I certainly don't have time to undertake that exercise, so I just want to
identify the problems so we can add specific skips to thouse tests for pdo_firebird.
--
Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php