Uderc programming article aggregator sites

[closed]mysqli is missing

Tags:
Answers: Have 10 answers
Advertisement
Hi, I have searched google and the forums and tried the different solutions and nothing seems to fix it. I have been through the Arch LAMP top to bottom twice. phpmyadmin shows this when run:
The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
Webmin shows the php.ini as found and you can edit it from there.
the Mysql extensions are uncommented in /etc/php/php.ini.
When I run phpinfo.php it doesn't show the mysql extensions as begin loaded.
I also installed MySql Administrator it connects fine
I can reach MySql and interact with it from the cli no problem
MySql Query Browser also interacts fine.
MySql-Workbench however cannot connect.
Adminer also can't connect (web based)
below is config.inc.php
<?php
* Generated configuration file
* Generated by: phpMyAdmin 3.5.0 setup script
* Date: Fri, 13 Apr 2012 17:16:18 -0500
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['ssl'] = true;
/* End of servers configuration */
$cfg['blowfish_secret'] = '4f8897d907e694.55991079';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['ShowPhpInfo'] = true;
?>
below is httpd.conf
# Do not add a slash at the end of the directory path. If you point
# ServerRoot at a non-local disk, be sure to point the LockFile directive
# at a local disk. If you wish to share the same ServerRoot for multiple
# httpd daemons, you will need to change at least LockFile and PidFile.
ServerRoot "/etc/httpd"
Listen 80
LoadModule authn_file_module modules/mod_authn_file.so
LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_anon_module modules/mod_authn_anon.so
LoadModule authn_dbd_module modules/mod_authn_dbd.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_owner_module modules/mod_authz_owner.so
LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule file_cache_module modules/mod_file_cache.so
LoadModule cache_module modules/mod_cache.so
LoadModule disk_cache_module modules/mod_disk_cache.so
LoadModule mem_cache_module modules/mod_mem_cache.so
LoadModule dbd_module modules/mod_dbd.so
LoadModule dumpio_module modules/mod_dumpio.so
LoadModule reqtimeout_module modules/mod_reqtimeout.so
LoadModule ext_filter_module modules/mod_ext_filter.so
LoadModule include_module modules/mod_include.so
LoadModule filter_module modules/mod_filter.so
LoadModule substitute_module modules/mod_substitute.so
LoadModule deflate_module modules/mod_deflate.so
LoadModule ldap_module modules/mod_ldap.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule log_forensic_module modules/mod_log_forensic.so
LoadModule logio_module modules/mod_logio.so
LoadModule env_module modules/mod_env.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule expires_module modules/mod_expires.so
LoadModule headers_module modules/mod_headers.so
LoadModule ident_module modules/mod_ident.so
LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule unique_id_module modules/mod_unique_id.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule version_module modules/mod_version.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_scgi_module modules/mod_proxy_scgi.so
LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
LoadModule ssl_module modules/mod_ssl.so
LoadModule mime_module modules/mod_mime.so
LoadModule dav_module modules/mod_dav.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule asis_module modules/mod_asis.so
LoadModule info_module modules/mod_info.so
LoadModule suexec_module modules/mod_suexec.so
LoadModule cgi_module modules/mod_cgi.so
LoadModule cgid_module modules/mod_cgid.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule vhost_alias_module modules/mod_vhost_alias.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule imagemap_module modules/mod_imagemap.so
LoadModule actions_module modules/mod_actions.so
LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule php5_module modules/libphp5.so
AddHandler php5-script php
<IfModule !mpm_netware_module>
<IfModule !mpm_winnt_module>
User http
Group http
</IfModule>
</IfModule>
ServerAdmin [email protected]
DocumentRoot "/srv/http"
<Directory />
Options FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
</Directory>
<Directory "/srv/http">
Options Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<IfModule dir_module>
DirectoryIndex index.php index.html
</IfModule>
<FilesMatch "^\.ht">
Order allow,deny
Deny from all
Satisfy All
</FilesMatch>
ErrorLog "/var/log/httpd/error_log"
LogLevel warn
<IfModule log_config_module>
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common
<IfModule logio_module>
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
</IfModule>
CustomLog "/var/log/httpd/access_log" common
</IfModule>
<IfModule alias_module>
ScriptAlias /cgi-bin/ "/srv/http/cgi-bin/"
</IfModule>
<IfModule cgid_module>
</IfModule>
<Directory "/srv/http/cgi-bin">
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>
DefaultType text/plain
<IfModule mime_module>
TypesConfig conf/mime.types
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
</IfModule>
MIMEMagicFile conf/magic
# Multi-language error messages
Include conf/extra/httpd-multilang-errordoc.conf
# Fancy directory listings
Include conf/extra/httpd-autoindex.conf
Include conf/extra/httpd-default.conf
Include conf/extra/httpd-ssl.conf
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>
Include conf/extra/php5_module.conf
Include conf/extra/httpd-phpmyadmin.conf
Include conf/extra/httpd-adminer.conf
Here is the list from phpinfo
core prefork http_core mod_so mod_authn_file mod_authn_dbm mod_authn_anon mod_authn_dbd mod_authn_default mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_dbm mod_authz_owner mod_authnz_ldap mod_authz_default mod_auth_basic mod_auth_digest mod_file_cache mod_cache mod_disk_cache mod_mem_cache mod_dbd mod_dumpio mod_reqtimeout mod_ext_filter mod_include mod_filter mod_substitute mod_deflate util_ldap mod_log_config mod_log_forensic mod_logio mod_env mod_mime_magic mod_cern_meta mod_expires mod_headers mod_ident mod_usertrack mod_setenvif mod_version mod_proxy mod_proxy_connect mod_proxy_ftp mod_proxy_http mod_proxy_scgi mod_proxy_ajp mod_proxy_balancer mod_ssl mod_mime mod_dav mod_status mod_autoindex mod_asis mod_info mod_suexec mod_cgi mod_cgid mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_imagemap mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_php5
Hopefully you will see something out of place,
thanks in advance for your help,
--jerry
Last edited by jk121960 (2012-04-20 16:29:56)
Advertisement
The best answer: Gcool wrote:
I just did a quick install on an Arch test machine here to try and replicate your issue. Needless to say, everything is working fine here.
The only small difference I'm noticing is the following:
Your phpinfo:
Configuration File (php.ini) Path /etc/php
Loaded Configuration File /php.ini
My phpinfo:
Configuration File (php.ini) Path /etc/php
Loaded Configuration File /etc/php/php.ini
Do you by any chance have multiple php installs present on your system (and hence multiple php.ini files)?
No just the one but to make sure I grepped pacman.log to see if there was an upgrade and got
[[email protected] ~]# cat /var/log/pacman.log | grep php
[2011-12-18 20:57] ==> Please refer to http://wiki.archlinux.org/index.php/Nfs
[2011-12-18 20:57] ==> http://wiki.archlinux.org/index.php/NFSv4
[2011-12-19 05:31] >>> See the wiki at http://wiki.archlinux.org/index.php/PulseAudio for details
[2011-12-19 05:31] * see https://wiki.archlinux.org/index.php/LibreOffice
[2012-03-27 12:22] Running 'pacman -S extra/php-apache'
[2012-03-27 12:22] installed php (5.3.10-4)
[2012-03-27 12:22] installed php-apache (5.3.10-4)
[2012-04-11 15:46] Running 'pacman -U /tmp/yaourt-tmp-root/PKGDEST.79g/eclipse-phpeclipse-1.2.3-1-any.pkg.tar.xz'
[2012-04-11 15:46] installed eclipse-phpeclipse (1.2.3-1)
[2012-04-12 19:46] Running 'pacman -S community/phpmyadmin'
[2012-04-12 19:46] Check http://wiki.archlinux.org/index.php/Phpmyadmin for details.
[2012-04-12 19:46] installed phpmyadmin (3.5.0-1)
[2012-04-13 13:39] Running 'pacman -S extra/php-mcrypt'
[2012-04-13 13:39] installed php-mcrypt (5.3.10-4)
[2012-04-13 18:27] Running 'pacman -S extra/php-apache extra/php extra/mysql extra/apache'
[2012-04-13 18:27] upgraded php (5.3.10-4 -> 5.3.10-4)
[2012-04-13 18:27] upgraded php-apache (5.3.10-4 -> 5.3.10-4)
The reference near the bottom was a re-install when I was running out of options, both versions are the same.
thanks
--jerry