You are not logged in.

#1 2012-04-14 14:18:05

jk121960
Member
From: Palos Hills, Illinois
Registered: 2011-12-09
Posts: 254

[closed]mysqli is missing

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 root@zenlinux


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)


Arch Awesome, Ranger & Vim the coding triple threat.

Offline

#2 2012-04-14 14:37:26

Gcool
Member
Registered: 2011-08-16
Posts: 1,456

Re: [closed]mysqli is missing

Would it be possible to post the full output of phpinfo() and your php.ini file?


Burninate!

Offline

#3 2012-04-14 15:04:42

jk121960
Member
From: Palos Hills, Illinois
Registered: 2011-12-09
Posts: 254

Re: [closed]mysqli is missing

Gcool wrote:

Would it be possible to post the full output of phpinfo() and your php.ini file?

Thanks here is phpinfo http://pastebin.com/2TXKHaBC

and here is php.ini http://pastebin.com/bB9ns3aX

thanks again,

--jerry


Arch Awesome, Ranger & Vim the coding triple threat.

Offline

#4 2012-04-14 15:57:44

Gcool
Member
Registered: 2011-08-16
Posts: 1,456

Re: [closed]mysqli is missing

Your config looks fine.

Could you check if the mysqli extension is actually present on your system (and has the correct permissions). It should be located in /usr/lib/php/modules/mysqli.so


Burninate!

Offline

#5 2012-04-14 16:03:21

jk121960
Member
From: Palos Hills, Illinois
Registered: 2011-12-09
Posts: 254

Re: [closed]mysqli is missing

Gcool wrote:

Your config looks fine.

Could you check if the mysqli extension is actually present on your system (and has the correct permissions). It should be located in /usr/lib/php/modules/mysqli.so

[jerry@zenlinux ~]$ ls -la /usr/lib/php/modules/m*
-rwxr-xr-x 1 root root  47944 Feb  6 13:20 /usr/lib/php/modules/mcrypt.so
-rwxr-xr-x 1 root root 128592 Feb  6 13:20 /usr/lib/php/modules/mysqli.so
-rwxr-xr-x 1 root root  47768 Feb  6 13:20 /usr/lib/php/modules/mysql.so

Here ya go and thanks again. At least I am somewhat sure I am not going insane.

--jerry


Arch Awesome, Ranger & Vim the coding triple threat.

Offline

#6 2012-04-14 16:23:32

JokerBoy
Member
From: România
Registered: 2009-09-24
Posts: 641

Re: [closed]mysqli is missing

did you run "sudo rc.d restart httpd"?

Offline

#7 2012-04-14 16:24:54

jk121960
Member
From: Palos Hills, Illinois
Registered: 2011-12-09
Posts: 254

Re: [closed]mysqli is missing

JokerBoy wrote:

did you run "sudo rc.d restart httpd"?

Till I was blue in the face, reinstalled everything also.

thanks for your post

--jerry


Arch Awesome, Ranger & Vim the coding triple threat.

Offline

#8 2012-04-14 16:31:27

Gcool
Member
Registered: 2011-08-16
Posts: 1,456

Re: [closed]mysqli is missing

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)?


Burninate!

Offline

#9 2012-04-14 16:39:35

jk121960
Member
From: Palos Hills, Illinois
Registered: 2011-12-09
Posts: 254

Re: [closed]mysqli is missing

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

[root@zenlinux ~]# 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


Arch Awesome, Ranger & Vim the coding triple threat.

Offline

#10 2012-04-20 16:30:16

jk121960
Member
From: Palos Hills, Illinois
Registered: 2011-12-09
Posts: 254

Re: [closed]mysqli is missing

I ended up reinstalling.


Arch Awesome, Ranger & Vim the coding triple threat.

Offline

Board footer

Powered by FluxBB