List:MySQL and PHP« Previous MessageNext Message »
From:Rick Olson Date:February 10 2007 10:31am
Subject:Re: extension compiled in and still Cannot load mysql extension
View as plain text  
Is your apache errorlog showing anything useful (or was the Cannot load 
mysql extension _from_ the errorlog?)?

--
Rick
http://www.sensual.jp



Noah wrote:
> so I am running FreeBSD 6.2
> and installing phpMyAdmin for the first time.
>
> even after recompiling php5 with the mysql extension phpMyAdmin still
> complains "Cannot load mysql extension"
>
> what else can I try?
>
> here are the server stats:
>
> ns1# pkg_info | grep php
> php5-5.2.1          PHP Scripting Language (Apache Module and CLI)
> php5-mysql-5.2.1    The mysql shared extension for php
> phpMyAdmin-2.9.2    A set of PHP-scripts to manage MySQL over the web
> ns1# pkg_info | grep mysql
> mysql-client-5.0.33 Multithreaded SQL database (client)
> mysql-server-5.0.33 Multithreaded SQL database (server)
> p5-DBD-mysql-4.001  MySQL driver for the Perl5 Database Interface (DBI)
> php5-mysql-5.2.1    The mysql shared extension for php
> ns1# grep mysql /usr/local/etc/php/extensions.ini
> extension=mysql.so
> ns1# pkg_info | grep apache
> apache-2.2.4        Version 2.2 of Apache web server with prefork MPM.
>
>
> and here is my apache httpd.conf
>
>
> ---s nip ----
>
> #
> # This is the main Apache HTTP server configuration file.  It contains 
> the
> # configuration directives that give the server its instructions.
> # See <URL:http://httpd.apache.org/docs/2.2> for detailed information.
> # In particular, see
> # <URL:http://httpd.apache.org/docs/2.2/mod/directives.html>
> # for a discussion of each configuration directive.
> #
> # Do NOT simply read the instructions in here without understanding
> # what they do.  They're here only as hints or reminders.  If you are 
> unsure
> # consult the online docs. You have been warned.
> #
> # Configuration and logfile names: If the filenames you specify for many
> # of the server's control files begin with "/" (or "drive:/" for 
> Win32), the
> # server will use that explicit path.  If the filenames do *not* begin
> # with "/", the value of ServerRoot is prepended -- so "logs/foo.log"
> # with ServerRoot set to "/usr/local/apache2" will be interpreted by the
> # server as "/usr/local/apache2/logs/foo.log".
>
> #
> # ServerRoot: The top of the directory tree under which the server's
> # configuration, error, and log files are kept.
> #
> # 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 "/usr/local/apache2"
>
> #
> # Listen: Allows you to bind Apache to specific IP addresses and/or
> # ports, instead of the default. See also the <VirtualHost>
> # directive.
> #
> # Change this to Listen on specific IP addresses as shown below to
> # prevent Apache from glomming onto all bound IP addresses.
> #
> #Listen 12.34.56.78:80
> Listen www.slops.globs.com:80
>
> #
> # Dynamic Shared Object (DSO) Support
> #
> # To be able to use the functionality of a module which was built as a
> DSO you
> # have to place corresponding `LoadModule' lines at this location so the
> # directives contained in it are actually available _before_ they are 
> used.
> # Statically compiled modules (those listed by `httpd -l') do not need
> # to be loaded here.
> #
> # Example:
> # LoadModule foo_module modules/mod_foo.so
> LoadModule php5_module        modules/libphp5.so
> LoadModule perl_module modules/mod_perl.so
> #LoadModule dav_svn_module     modules/mod_dav_svn.so
> #LoadModule authz_svn_module   modules/mod_authz_svn.so
> #
>
> <IfModule !mpm_netware_module>
> #
> # If you wish httpd to run as a different user or group, you must run
> # httpd as root initially and it will switch.
> #
> # User/Group: The name (or #number) of the user/group to run httpd as.
> # It is usually good practice to create a dedicated user and group for
> # running httpd, as with most system services.
> #
> User www
> Group www
> </IfModule>
>
> # 'Main' server configuration
> #
> # The directives in this section set up the values used by the 'main'
> # server, which responds to any requests that aren't handled by a
> # <VirtualHost> definition.  These values also provide defaults for
> # any <VirtualHost> containers you may define later in the file.
> #
> # All of these directives may appear inside <VirtualHost> containers,
> # in which case these default settings will be overridden for the
> # virtual host being defined.
> #
>
>
> #
> # ServerAdmin: Your address, where problems with the server should be
> # e-mailed.  This address appears on some server-generated pages, such
> # as error documents.  e.g. admin@stripped
> #
> ServerAdmin pro-swatch@stripped
>
> #
> # ServerName gives the name and port that the server uses to identify
> itself.
> # This can often be determined automatically, but we recommend you 
> specify
> # it explicitly to prevent problems during startup.
> #
> # If your host doesn't have a registered DNS name, enter its IP address
> here.
> #
> ServerName www.slops.globs.com:80
>
> #
> # DocumentRoot: The directory out of which you will serve your
> # documents. By default, all requests are taken from this directory, but
> # symbolic links and aliases may be used to point to other locations.
> #
> DocumentRoot "/usr/local/apache2/htdocs"
>
> #
> # Each directory to which Apache has access can be configured with 
> respect
> # to which services and features are allowed and/or disabled in that
> # directory (and its subdirectories).
> #
> # First, we configure the "default" to be a very restrictive set of
> # features.
> #
>
> <Directory />
> #    Options FollowSymLinks
> #    AllowOverride None
> #    Order deny,allow
> # #   Deny from all
>    Options Includes FollowSymLinks Indexes ExecCGI
>    AllowOverride All
> #    AllowOverride None
> #    Order deny,allow
> #    Deny from all
>    Order allow,deny
>    Allow from all
>    php_flag engine on
>    AddType application/x-httpd-php .php
>    AddType application/x-httpd-php-source .phps
> </Directory>
>
> <Directory "/usr/local/apache2/phpMyAdmin">
>    AllowOverride All
>    Options FollowSymLinks MultiViews Includes
>    Order deny,allow
>    Allow from all
> </Directory>
>
> <VirtualHost www.slops.globs.com>
>   ServerName www.slops.globs.com
>   Alias /rt3 /usr/local/rt3/share/html
>   Alias /myadmin /usr/local/apache2/phpMyAdmin
>   AddDefaultCharset UTF-8
>
>  AddType application/x-httpd-php .php
>
>   # this line applies to Apache2+mod_perl2 only
>   # Below line might be incorrect, I had to use:
>   #     PerlModule Apache2::compat
>   # mod_perl 2.0.1 from FC4 Linux
>
>   PerlModule Apache2 Apache::compat
>   PerlModule Apache::DBI
>   PerlRequire /usr/local/rt3/bin/webmux.pl
>
>   <Location /rt3>
>       SetHandler perl-script
>       PerlHandler RT::Mason
>   </Location>
> </VirtualHost>
>
>
> #
> # Note that from this point forward you must specifically allow
> # particular features to be enabled - so if something's not working as
> # you might expect, make sure that you have specifically enabled it
> # below.
> #
>
> #
> # This should be changed to whatever you set DocumentRoot to.
> #
> <Directory "/usr/local/apache2/htdocs">
>    #
>    # Possible values for the Options directive are "None", "All",
>    # or any combination of:
>    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI
> MultiViews
>    #
>    # Note that "MultiViews" must be named *explicitly* --- "Options All"
>    # doesn't give it to you.
>    #
>    # The Options directive is both complicated and important.  Please see
>    # http://httpd.apache.org/docs/2.2/mod/core.html#options
>    # for more information.
>    #
>    Options Indexes FollowSymLinks
>
>    #
>    # AllowOverride controls what directives may be placed in .htaccess
> files.
>    # It can be "All", "None", or any combination of the keywords:
>    #   Options FileInfo AuthConfig Limit
>    #
>    AllowOverride None
>
>    #
>    # Controls who can get stuff from this server.
>    #
>    Order allow,deny
>    Allow from all
>
> </Directory>
>
> #
> # DirectoryIndex: sets the file that Apache will serve if a directory
> # is requested.
> #
> <IfModule dir_module>
>    DirectoryIndex index.html index.php
> </IfModule>
>
> #
> # The following lines prevent .htaccess and .htpasswd files from being
> # viewed by Web clients.
> #
> <FilesMatch "^\.ht">
>    Order allow,deny
>    Deny from all
>    Satisfy All
> </FilesMatch>
>
> #
> # ErrorLog: The location of the error log file.
> # If you do not specify an ErrorLog directive within a <VirtualHost>
> # container, error messages relating to that virtual host will be
> # logged here.  If you *do* define an error logfile for a <VirtualHost>
> # container, that host's errors will be logged there and not here.
> #
> ErrorLog logs/error_log
>
> #
> # LogLevel: Control the number of messages logged to the error_log.
> # Possible values include: debug, info, notice, warn, error, crit,
> # alert, emerg.
> #
> LogLevel warn
>
> <IfModule log_config_module>
>    #
>    # The following directives define some format nicknames for use with
>    # a CustomLog directive (see below).
>    #
>    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>
>      # You need to enable mod_logio.c to use %I and %O
>      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\"
> \"%{User-Agent}i\" %I %O" combinedio
>    </IfModule>
>
>    #
>    # The location and format of the access logfile (Common Logfile 
> Format).
>    # If you do not define any access logfiles within a <VirtualHost>
>    # container, they will be logged here.  Contrariwise, if you *do*
>    # define per-<VirtualHost> access logfiles, transactions will be
>    # logged therein and *not* in this file.
>    #
>    CustomLog logs/access_log common
>
>    #
>    # If you prefer a logfile with access, agent, and referer information
>    # (Combined Logfile Format) you can use the following directive.
>    #
>    #CustomLog logs/access_log combined
> </IfModule>
>
> <IfModule alias_module>
>    #
>    # Redirect: Allows you to tell clients about documents that used to
>    # exist in your server's namespace, but do not anymore. The client
>    # will make a new request for the document at its new location.
>    # Example:
>    # Redirect permanent /foo http://www.example.com/bar
>
>    #
>    # Alias: Maps web paths into filesystem paths and is used to
>    # access content that does not live under the DocumentRoot.
>    # Example:
>    # Alias /webpath /full/filesystem/path
>    #
>    # If you include a trailing / on /webpath then the server will
>    # require it to be present in the URL.  You will also likely
>    # need to provide a <Directory> section to allow access to
>    # the filesystem path.
>    #
>    # ScriptAlias: This controls which directories contain server scripts.
>    # ScriptAliases are essentially the same as Aliases, except that
>    # documents in the target directory are treated as applications and
>    # run by the server when requested rather than as documents sent to 
> the
>    # client.  The same rules about trailing "/" apply to ScriptAlias
>    # directives as to Alias.
>    #
>    ScriptAlias /cgi-bin/ "/usr/local/apache2/cgi-bin/"
> </IfModule>
>
> <IfModule cgid_module>
>    #
>    # ScriptSock: On threaded servers, designate the path to the UNIX
>    # socket used to communicate with the CGI daemon of mod_cgid.
>    #
>    #Scriptsock logs/cgisock
> </IfModule>
>
>
> #
> # "/usr/local/apache2/cgi-bin" should be changed to whatever your
> ScriptAliased
> # CGI directory exists, if you have that configured.
> #
> <Directory "/usr/local/apache2/cgi-bin">
>    AllowOverride None
>    Options None
>    Order allow,deny
>    Allow from all
> </Directory>
>
> #
> # DefaultType: the default MIME type the server will use for a document
> # if it cannot otherwise determine one, such as from filename extensions.
> # If your server contains mostly text or HTML documents, "text/plain" is
> # a good value.  If most of your content is binary, such as applications
> # or images, you may want to use "application/octet-stream" instead to
> # keep browsers from trying to display binary files as though they are
> # text.
> #
> DefaultType text/plain
>
> <IfModule mime_module>
>    #
>    # TypesConfig points to the file containing the list of mappings from
>    # filename extension to MIME-type.
>    #
>    TypesConfig conf/mime.types
>
>    #
>    # AddType allows you to add to or override the MIME configuration
>    # file specified in TypesConfig for specific file types.
>    #
>    #AddType application/x-gzip .tgz
>    #
>    # AddEncoding allows you to have certain browsers uncompress
>    # information on the fly. Note: Not all browsers support this.
>    #
>    #AddEncoding x-compress .Z
>    #AddEncoding x-gzip .gz .tgz
>    #
>    # If the AddEncoding directives above are commented-out, then you
>    # probably should define those extensions to indicate media types:
>    #
>    AddType application/x-compress .Z
>    AddType application/x-gzip .gz .tgz
>
>    # PHP
>    AddType application/x-httpd-php .php .phtml
>
>    #
>    # AddHandler allows you to map certain file extensions to "handlers":
>    # actions unrelated to filetype. These can be either built into the
> server
>    # or added with the Action directive (see below)
>    #
>    # To use CGI scripts outside of ScriptAliased directories:
>    # (You will also need to add "ExecCGI" to the "Options" directive.)
>    #
>    #AddHandler cgi-script .cgi
>
>    # For type maps (negotiated resources):
>    #AddHandler type-map var
>
>    #
>    # Filters allow you to process content before it is sent to the 
> client.
>    #
>    # To parse .shtml files for server-side includes (SSI):
>    # (You will also need to add "Includes" to the "Options" directive.)
>    #
>    #AddType text/html .shtml
>    #AddOutputFilter INCLUDES .shtml
> </IfModule>
>
> #
> # The mod_mime_magic module allows the server to use various hints 
> from the
> # contents of the file itself to determine its type.  The MIMEMagicFile
> # directive tells the module where the hint definitions are located.
> #
> #MIMEMagicFile conf/magic
>
> #
> # Customizable error responses come in three flavors:
> # 1) plain text 2) local redirects 3) external redirects
> #
> # Some examples:
> #ErrorDocument 500 "The server made a boo boo."
> #ErrorDocument 404 /missing.html
> #ErrorDocument 404 "/cgi-bin/missing_handler.pl"
> #ErrorDocument 402 http://www.example.com/subscription_info.html
> #
>
> #
> # EnableMMAP and EnableSendfile: On systems that support it,
> # memory-mapping or the sendfile syscall is used to deliver
> # files.  This usually improves server performance, but must
> # be turned off when serving from networked-mounted
> # filesystems or if support for these functions is otherwise
> # broken on your system.
> #
> #EnableMMAP off
> #EnableSendfile off
>
> # Supplemental configuration
> #
> # The configuration files in the conf/extra/ directory can be
> # included to add extra features or to modify the default 
> configuration of
> # the server, or you may simply copy their contents here and change as
> # necessary.
>
> # Server-pool management (MPM specific)
> #Include conf/extra/httpd-mpm.conf
>
> # Multi-language error messages
> #Include conf/extra/httpd-multilang-errordoc.conf
>
> # Fancy directory listings
> #Include conf/extra/httpd-autoindex.conf
>
> # Language settings
> #Include conf/extra/httpd-languages.conf
>
> # User home directories
> Include conf/extra/httpd-userdir.conf
>
> # Real-time info on requests and configuration
> #Include conf/extra/httpd-info.conf
>
> # Virtual hosts
> #Include conf/extra/httpd-vhosts.conf
> # Local access to the Apache HTTP Server Manual
> #Include conf/extra/httpd-manual.conf
>
> # Distributed authoring and versioning (WebDAV)
> #Include conf/extra/httpd-dav.conf
>
> # Various default settings
> #Include conf/extra/httpd-default.conf
>
> # Secure (SSL/TLS) connections
> #Include conf/extra/httpd-ssl.conf
> #
> # Note: The following must must be present to support
> #       starting without SSL on platforms with no /dev/random equivalent
> #       but a statically compiled-in mod_ssl.
> #
> <IfModule ssl_module>
> SSLRandomSeed startup builtin
> SSLRandomSeed connect builtin
> </IfModule>
>
>
>
> --- snip ---
>
>
>
>
>
>

Thread
extension compiled in and still Cannot load mysql extensionNoah10 Feb
  • Re: extension compiled in and still Cannot load mysql extensionRick Olson10 Feb