Bug 256738 - lang/php74-mysqli: Fails to connect to DB via mysqli through "localhost"
Summary: lang/php74-mysqli: Fails to connect to DB via mysqli through "localhost"
Status: Closed Feedback Timeout
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: amd64 Any
: --- Affects Only Me
Assignee: Torsten Zuehlsdorff
URL:
Keywords: needs-qa
Depends on:
Blocks:
 
Reported: 2021-06-20 22:15 UTC by Brendhan Horne
Modified: 2022-02-23 18:52 UTC (History)
2 users (show)

See Also:
bugzilla: maintainer-feedback? (tz)


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Brendhan Horne 2021-06-20 22:15:34 UTC
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.
Comment 1 Kubilay Kocak freebsd_committer freebsd_triage 2021-06-21 01:42:48 UTC
@Reporter Could you please provide:

 - pkg version -v output (as an attachment)
Comment 2 Brendhan Horne 2021-06-23 18:14:17 UTC
root# pkg version -v
ImageMagick7-7.0.10.24_2           >   succeeds port (port has 7.0.10.24)
apache24-2.4.48                    >   succeeds port (port has 2.4.46)
apr-1.7.0.1.6.1_1                  =   up-to-date with port
avahi-app-0.8                      >   succeeds port (port has 0.7_3)
bash-5.1.4_1                       >   succeeds port (port has 5.0.18_3)
boost-libs-1.72.0_4                >   succeeds port (port has 1.72.0_2)
ca_root_nss-3.63                   >   succeeds port (port has 3.57)
cairo-1.16.0_1,3                   =   up-to-date with port
cups-2.3.3op2                      >   succeeds port (port has 2.3.3_1)
curl-7.76.0                        >   succeeds port (port has 7.72.0)
db5-5.3.28_7                       =   up-to-date with port
dbus-1.12.20_3                     >   succeeds port (port has 1.12.20)
dbus-glib-0.110                    =   up-to-date with port
dejavu-2.37_1                      =   up-to-date with port
encodings-1.0.5,1                  =   up-to-date with port
expat-2.4.1                        >   succeeds port (port has 2.2.8)
fftw3-3.3.9                        >   succeeds port (port has 3.3.8_6)
font-bh-ttf-1.0.3_4                =   up-to-date with port
font-misc-ethiopic-1.0.4           =   up-to-date with port
font-misc-meltho-1.0.3_4           =   up-to-date with port
fontconfig-2.13.93,1               >   succeeds port (port has 2.13.92_2,1)
freetype2-2.10.4                   >   succeeds port (port has 2.10.2_1)
fribidi-1.0.10                     =   up-to-date with port
galera26-26.4.6_1                  >   succeeds port (port has 26.4.5)
gdbm-1.19                          >   succeeds port (port has 1.18.1_1)
gdk-pixbuf2-2.40.0                 =   up-to-date with port
gettext-runtime-0.21               =   up-to-date with port
ghostscript9-agpl-base-9.52_15     >   succeeds port (port has 9.52_9)
ghostscript9-agpl-x11-9.52         =   up-to-date with port
giflib-5.2.1                       =   up-to-date with port
glib-2.66.7_1,1                    >   succeeds port (port has 2.66.0_1,1)
gmp-6.2.1                          >   succeeds port (port has 6.2.0)
gnome_subr-1.0                     =   up-to-date with port
gnutls-3.6.15                      =   up-to-date with port
graphite2-1.3.14                   =   up-to-date with port
gsfonts-8.11_8                     =   up-to-date with port
harfbuzz-2.8.0                     >   succeeds port (port has 2.7.2_1)
icu-68.2,1                         >   succeeds port (port has 67.1,1)
indexinfo-0.3.1                    =   up-to-date with port
jansson-2.13.1                     =   up-to-date with port
jbig2dec-0.19                      =   up-to-date with port
jbigkit-2.1_1                      =   up-to-date with port
jpeg-turbo-2.0.6                   >   succeeds port (port has 2.0.4)
lcms2-2.12                         >   succeeds port (port has 2.11_1)
libICE-1.0.10,1                    =   up-to-date with port
libSM-1.2.3,1                      =   up-to-date with port
libX11-1.7.1,1                     >   succeeds port (port has 1.6.12,1)
libXau-1.0.9                       =   up-to-date with port
libXdamage-1.1.5                   =   up-to-date with port
libXdmcp-1.1.3                     =   up-to-date with port
libXext-1.3.4,1                    =   up-to-date with port
libXfixes-5.0.3_2                  =   up-to-date with port
libXft-2.3.3                       =   up-to-date with port
libXrandr-1.5.2                    =   up-to-date with port
libXrender-0.9.10_2                =   up-to-date with port
libXt-1.2.1,1                      >   succeeds port (port has 1.2.0,1)
libXxf86vm-1.1.4_3                 =   up-to-date with port
libargon2-20190702                 =   up-to-date with port
libdaemon-0.14_1                   =   up-to-date with port
libdrm-2.4.104,1                   >   succeeds port (port has 2.4.102,1)
libedit-3.1.20210216,1             >   succeeds port (port has 3.1.20191231,1)
libepoll-shim-0.0.20210322         >   succeeds port (port has 0.0.20200602)
libevent-2.1.12                    =   up-to-date with port
libffi-3.3_1                       =   up-to-date with port
libfontenc-1.1.4                   =   up-to-date with port
libgd-2.3.1,1                      >   succeeds port (port has 2.3.0,1)
libgsf-1.14.47_1                   =   up-to-date with port
libiconv-1.16                      =   up-to-date with port
libidn-1.35                        =   up-to-date with port
libidn2-2.3.0_1                    =   up-to-date with port
liblqr-1-0.4.2                     =   up-to-date with port
libltdl-2.4.6                      =   up-to-date with port
liblz4-1.9.3,1                     >   succeeds port (port has 1.9.2_1,1)
libnghttp2-1.43.0                  >   succeeds port (port has 1.41.0)
libpaper-1.1.24.4                  =   up-to-date with port
libpciaccess-0.16                  =   up-to-date with port
libpthread-stubs-0.4               =   up-to-date with port
libraqm-0.6.0                      =   up-to-date with port
libraw-0.20.2                      >   succeeds port (port has 0.19.5)
librsvg2-rust-2.50.3_2             >   succeeds port (port has 2.50.0)
libsodium-1.0.18                   =   up-to-date with port
libssh-0.9.5                       =   up-to-date with port
libtasn1-4.16.0_1                  >   succeeds port (port has 4.16.0)
libunistring-0.9.10_1              =   up-to-date with port
libunwind-20201110                 >   succeeds port (port has 20200331_1)
libwmf-0.2.12                      >   succeeds port (port has 0.2.8.4_15)
libxcb-1.14_1                      =   up-to-date with port
libxml2-2.9.10_4                   >   succeeds port (port has 2.9.10_1)
libxshmfence-1.3                   =   up-to-date with port
libzip-1.7.3                       >   succeeds port (port has 1.5.2)
mariadb105-client-10.5.10          >   succeeds port (port has 10.5.5)
mariadb105-server-10.5.10          >   succeeds port (port has 10.5.5)
mesa-libs-20.2.3                   >   succeeds port (port has 19.0.8_3)
mkfontscale-1.2.1                  =   up-to-date with port
mod_php74-7.4.20                   >   succeeds port (port has 7.4.10)
msgpack-3.3.0                      =   up-to-date with port
nettle-3.7.2_1                     >   succeeds port (port has 3.6)
oniguruma-6.9.6                    >   succeeds port (port has 6.9.5.r1_1)
openjpeg-2.4.0                     >   succeeds port (port has 2.3.1)
p11-kit-0.23.22_1                  >   succeeds port (port has 0.23.21)
pango-1.42.4_5                     =   up-to-date with port
pciids-20210223                    >   succeeds port (port has 20200819)
pcre-8.44                          =   up-to-date with port
pcre2-10.37                        >   succeeds port (port has 10.35)
perl5-5.32.1_1                     >   succeeds port (port has 5.32.0)
php74-7.4.20                       >   succeeds port (port has 7.4.10)
php74-bz2-7.4.20                   >   succeeds port (port has 7.4.10)
php74-ctype-7.4.20                 >   succeeds port (port has 7.4.10)
php74-curl-7.4.20                  >   succeeds port (port has 7.4.10)
php74-filter-7.4.20                >   succeeds port (port has 7.4.10)
php74-gd-7.4.20                    >   succeeds port (port has 7.4.10)
php74-json-7.4.20                  >   succeeds port (port has 7.4.10)
php74-mbstring-7.4.20              >   succeeds port (port has 7.4.10)
php74-mysqli-7.4.20                >   succeeds port (port has 7.4.10)
php74-openssl-7.4.20               >   succeeds port (port has 7.4.10)
php74-session-7.4.20               >   succeeds port (port has 7.4.10)
php74-xml-7.4.20                   >   succeeds port (port has 7.4.10)
php74-zip-7.4.20                   >   succeeds port (port has 7.4.10)
php74-zlib-7.4.20                  >   succeeds port (port has 7.4.10)
phpMyAdmin-php74-4.9.7             >   succeeds port (port has 4.9.5)
pixman-0.40.0_1                    =   up-to-date with port
pkg-1.16.3                         >   succeeds port (port has 1.15.6)
pkgconf-1.7.4,1                    >   succeeds port (port has 1.7.3,1)
png-1.6.37_1                       >   succeeds port (port has 1.6.37)
poppler-data-0.4.10                >   succeeds port (port has 0.4.9_5)
pure-ftpd-1.0.49_1                 =   up-to-date with port
python37-3.7.10                    >   succeeds port (port has 3.7.9)
readline-8.1.0                     >   succeeds port (port has 8.0.4)
rsync-3.2.3                        =   up-to-date with port
shared-mime-info-2.0               =   up-to-date with port
tiff-4.2.0                         >   succeeds port (port has 4.1.0)
tmate-2.4.0_1                      >   succeeds port (port has 2.4.0)
tpm-emulator-0.7.4_2               =   up-to-date with port
trousers-0.3.14_3                  =   up-to-date with port
unixODBC-2.3.9                     >   succeeds port (port has 2.3.7)
wayland-1.19.0_1                   >   succeeds port (port has 1.18.0_4)
webp-1.2.0                         >   succeeds port (port has 1.1.0)
xorg-fonts-truetype-7.7_1          =   up-to-date with port
xorgproto-2020.1                   =   up-to-date with port
xxhash-0.8.0                       =   up-to-date with port
zstd-1.4.8                         >   succeeds port (port has 1.4.5_1)
root#
Comment 3 Torsten Zuehlsdorff freebsd_committer freebsd_triage 2021-06-23 21:45:07 UTC
Did you use pkg install for installing the ports or did you build them? Did you have a different configuration? What is the reason that you are using so old versions?

I am not able to reproduce this bug at the moment.
Comment 4 Brendhan Horne 2021-06-29 18:37:10 UTC
(In reply to Torsten Zuehlsdorff from comment #3)
I did use pkg install. It was a fresh install these ports are what I was getting from the pkg installer. 

I will see if I can get more information. Thank you for looking into this. 

Sincerely,
Brendhan
Comment 5 Brendhan Horne 2021-06-29 18:39:13 UTC
root@nexus:~ # freebsd-update fetch install
Looking up update.FreeBSD.org mirrors... 2 mirrors found.
Fetching metadata signature for 12.2-RELEASE from update1.freebsd.org... done.
Fetching metadata index... done.
Inspecting system... done.
Preparing to download files... done.

No updates needed to update system to 12.2-RELEASE-p8.
No updates are available to install.
root@nexus:~ # pkg update
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
root@nexus:~ # pkg upgrade
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking for upgrades (1 candidates): 100%
Processing candidates (1 candidates): 100%
Checking integrity... done (0 conflicting)
Your packages are up to date.
root@nexus:~ #
Comment 6 Torsten Zuehlsdorff freebsd_committer freebsd_triage 2021-08-18 06:02:05 UTC
Current PHP 7.4 Version is 7.4.22

Can you please state what "php -v" is giving you. Because I still can't reproduce the error.