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