Bug#1028477: php-odbc: regression - login failed with php 8.2, works under 8.1
Severity: control -1 normal
Hi,
stupid mailer on the phone sent this as HTML, resending as plain text:
> have you actually read the upgrade guide?
>
> https://www.php.net/manual/en/migration82.incompatible.php
I believe it's not a bug, but rather result of the change described in the
migration guide.
Ondrej
> --
> Ondřej Surý (He/Him)
>
>> On 11. 1. 2023, at 18:06, Joe Nahmias wrote:
>>
>> Package: php8.2-odbc
>> Version: 8.2.1-1
>> Severity: grave
>> X-Debbugs-Cc: j...@nahmias.net
>>
>> Hello,
>>
>> There seems to be a regression with php8.2-odbc, compared to php8.1-odbc:
>>
>> $ cat /tmp/test-php_odbc.php
>> > // setup database connection
>> $u = getenv('DB_USERNAME');
>> $p = getenv('DB_PASSWORD');
>> $server = getenv('DB_HOSTNAME');
>> $dsn = "DRIVER=FreeTDS;Server=$server;Port=1433";
>> $pdo = new \PDO("odbc:$dsn", $u, $p);
>> $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
>> print("Connected!\n");
>>
>> $ php8.1 /tmp/test-php_odbc.php
>> Connected!
>>
>> $ php8.2 /tmp/test-php_odbc.php
>> PHP Fatal error: Uncaught PDOException: SQLSTATE[42000] SQLDriverConnect:
>> 18456 [FreeTDS][SQL Server]Login failed for user 'kbUnitTests'. in
>> /tmp/test-php_odbc.php:7
>> Stack trace:
>> #0 /tmp/test-php_odbc.php(7): PDO->__construct()
>> #1 {main}
>> thrown in /tmp/test-php_odbc.php on line 7
>>
>> $ dpkg -l php\* | grep ^i
>> ii php-common 2:92+nmu1all Common files for PHP
>> packages
>> ii php8.1-cli 8.1.12-1+b1 amd64command-line interpreter
>> for the PHP scripting language
>> ii php8.1-common 8.1.12-1+b1 amd64documentation, examples and
>> common module for PHP
>> ii php8.1-odbc8.1.12-1+b1 amd64ODBC module for PHP
>> ii php8.1-opcache 8.1.12-1+b1 amd64Zend OpCache module for PHP
>> ii php8.1-readline8.1.12-1+b1 amd64readline module for PHP
>> ii php8.2-cli 8.2.1-1 amd64command-line interpreter
>> for the PHP scripting language
>> ii php8.2-common 8.2.1-1 amd64documentation, examples and
>> common module for PHP
>> ii php8.2-odbc8.2.1-1 amd64ODBC module for PHP
>> ii php8.2-opcache 8.2.1-1 amd64Zend OpCache module for PHP
>> ii php8.2-readline8.2.1-1 amd64readline module for PHP
>>
>> Please let me know if you need any additional information!
>> --Joe
>>
Bug#1028477: php-odbc: regression - login failed with php 8.2, works under 8.1
Control: severity -1 normalHi,have you actually read the upgrade guide?Backward Incompatible Changes - Manualphp.net--Ondřej Surý (He/Him)On 11. 1. 2023, at 18:06, Joe Nahmias wrote:Package: php8.2-odbcVersion: 8.2.1-1Severity: graveX-Debbugs-Cc: j...@nahmias.netHello,There seems to be a regression with php8.2-odbc, compared to php8.1-odbc:$ cat /tmp/test-php_odbc.php// setup database connection$u = getenv('DB_USERNAME');$p = getenv('DB_PASSWORD');$server = getenv('DB_HOSTNAME');$dsn = "DRIVER=FreeTDS;Server=$server;Port=1433";$pdo = new \PDO("odbc:$dsn", $u, $p);$pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);print("Connected!\n");$ php8.1 /tmp/test-php_odbc.phpConnected!$ php8.2 /tmp/test-php_odbc.phpPHP Fatal error: Uncaught PDOException: SQLSTATE[42000] SQLDriverConnect: 18456 [FreeTDS][SQL Server]Login failed for user 'kbUnitTests'. in /tmp/test-php_odbc.php:7Stack trace:#0 /tmp/test-php_odbc.php(7): PDO->__construct()#1 {main} thrown in /tmp/test-php_odbc.php on line 7$ dpkg -l php\* | grep ^iii php-common 2:92+nmu1 all Common files for PHP packagesii php8.1-cli 8.1.12-1+b1 amd64 command-line interpreter for the PHP scripting languageii php8.1-common 8.1.12-1+b1 amd64 documentation, examples and common module for PHPii php8.1-odbc 8.1.12-1+b1 amd64 ODBC module for PHPii php8.1-opcache 8.1.12-1+b1 amd64 Zend OpCache module for PHPii php8.1-readline 8.1.12-1+b1 amd64 readline module for PHPii php8.2-cli 8.2.1-1 amd64 command-line interpreter for the PHP scripting languageii php8.2-common 8.2.1-1 amd64 documentation, examples and common module for PHPii php8.2-odbc 8.2.1-1 amd64 ODBC module for PHPii php8.2-opcache 8.2.1-1 amd64 Zend OpCache module for PHPii php8.2-readline 8.2.1-1 amd64 readline module for PHPPlease let me know if you need any additional information!--Joe
Bug#1028477: php-odbc: regression - login failed with php 8.2, works under 8.1
Package: php8.2-odbc
Version: 8.2.1-1
Severity: grave
X-Debbugs-Cc: j...@nahmias.net
Hello,
There seems to be a regression with php8.2-odbc, compared to php8.1-odbc:
$ cat /tmp/test-php_odbc.php
setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
print("Connected!\n");
$ php8.1 /tmp/test-php_odbc.php
Connected!
$ php8.2 /tmp/test-php_odbc.php
PHP Fatal error: Uncaught PDOException: SQLSTATE[42000] SQLDriverConnect:
18456 [FreeTDS][SQL Server]Login failed for user 'kbUnitTests'. in
/tmp/test-php_odbc.php:7
Stack trace:
#0 /tmp/test-php_odbc.php(7): PDO->__construct()
#1 {main}
thrown in /tmp/test-php_odbc.php on line 7
$ dpkg -l php\* | grep ^i
ii php-common 2:92+nmu1all Common files for PHP packages
ii php8.1-cli 8.1.12-1+b1 amd64command-line interpreter for
the PHP scripting language
ii php8.1-common 8.1.12-1+b1 amd64documentation, examples and
common module for PHP
ii php8.1-odbc8.1.12-1+b1 amd64ODBC module for PHP
ii php8.1-opcache 8.1.12-1+b1 amd64Zend OpCache module for PHP
ii php8.1-readline8.1.12-1+b1 amd64readline module for PHP
ii php8.2-cli 8.2.1-1 amd64command-line interpreter for
the PHP scripting language
ii php8.2-common 8.2.1-1 amd64documentation, examples and
common module for PHP
ii php8.2-odbc8.2.1-1 amd64ODBC module for PHP
ii php8.2-opcache 8.2.1-1 amd64Zend OpCache module for PHP
ii php8.2-readline8.2.1-1 amd64readline module for PHP
Please let me know if you need any additional information!
--Joe
