Bug #81182 [NEW]: Could not create a MySQLi connection
From: list at understudy dot net
Operating system: FreeBSD 12.2
PHP version: 7.4.20
Package: MySQLi related
Bug Type: Bug
Bug description:Could not create a MySQLi connection
Description:
------------
Specs on system:
FBSD 12.2
PHP 7.4.20
MariaDB 10.5.10
Coppermine 1.6.10
phpmyadmin 4.9.7
Error from coppermine when trying to connect to database on install step
6
Could not create a MySQLi connection, please check the MySQLi details
entered
Database error: No such file or directory
Through CLI DB is confirmed and working.
Tests on CLI and with port 3306 on localhost and 127.0.0.1 show ok.
Test also preformed with phpmyadmin which gave similar errors in their
setup.
Issue: failure to connect to DB via mysqli through "localhost"
Possible solution implemented:
edit the following file:
/usr/local/etc/php/ext-20-mysqli.ini
add the following lines:
pdo_mysql.default_socket="/var/run/mysql/mysql.sock"
mysqli.default_socket="/var/run/mysql/mysql.sock"
This solution may only work for FBSD. It is uncertain if this solution
will work with Linux or Windows or if they are having this issue.
Test script:
---------------
NA
Expected result:
----------------
I would like to see if the ext-20-mysqli.ini needs to be modified in the
ports/pkg for FBSD or if this is an issue that may pertain to other OS
systems out there.
--
Edit bug report at https://bugs.php.net/bug.php?id=81182&edit=1
--
Fix committed: https://bugs.php.net/fix.php?id=81182&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=81182&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=81182&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=81182&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=81182&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=81182&r=support
Expected behavior: https://bugs.php.net/fix.php?id=81182&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=81182&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=81182&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=81182&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=81182&r=phptooold
Daylight Savings: https://bugs.php.net/fix.php?id=81182&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=81182&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=81182&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=81182&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=81182&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=81182&r=mysqlcfg
Thread (3 messages)
- list at understudy dot net