Re: 3 day nightmare

[PJ <af.gourmet@xxxxxxxxxxxx>]

Notes below:

Daniel Brown wrote:
>     Wow, Peej.... frustration sure makes for jumbled emails, eh?
> Let's try to take this one step at a time, and we'll get you going....
>
> On Thu, Dec 18, 2008 at 11:49, PJ <af.gourmet@xxxxxxxxxxxx> wrote:
>   
> > info.php does not show mysql but it does show the pgsql and gd2 extensions.
> >     
# /usr/local/bin/php -r 'phpinfo();' does not show mysql - same as with 
web info.php
>     Are you sure it's using the same php.ini file you're editing?
> Check in your phpinfo() (probably your info.php file) and make sure
> you're editing the same file that's showing there.  Also, *every time*
> you make changes to php.ini, you have to restart Apache (or whatever
> HTTP server you're using) so that PHP is reloaded with the changes.
>
>   
I copied the default php.ini-dist file to php.ini and then adjusted to 
point to the /usr/local/etc/php directory for the extensions.ini file 
that contains all the .so scripts- and indeed all the scripts are there.

also entered extension=mysql.so; extension=pgsql.so and extension=gd2.so 
and left the rest as default

I played with this stuff so much it's coming out of my eyes.... not only 
did I find that mysqld would not start as instructed in the mysql 
documentation (copy mysql-server to /usr/local/etc/rc.d as 
mysql-server.sh ---- only the rc.conf entry enable_mysql=YES worked; but 
also I found that even rebooting did not correct the mysql.so module 
problem.... pgsql and gd2 are quite evident in the info.php web page.

this seems to be the configure command according to info.php :

'./configure' '--with-layout=GNU' 
'--with-config-file-scan-dir=/usr/local/etc/php' '--disable-all' 
'--enable-libxml' '--with-libxml-dir=/usr/local' 
'--with-pcre-regex=/usr/local' '--enable-reflection' '--program-prefix=' 
'--enable-fastcgi' '--with-apxs2=/usr/local/sbin/apxs' 
'--with-regex=php' '--with-zend-vm=CALL' '--disable-ipv6' 
'--prefix=/usr/local' '--mandir=/usr/local/man' 
'--infodir=/usr/local/info/' '--build=i386-portbld-freebsd7.0'

Now, I notice this '--with-config-file-scan-dir=/usr/local/etc/php'  ;  
the php.ini file is in /usr/local/etc and not in php ;;;;;;; 
'--with-config-file-scan-dir=/usr/local/etc/php' is the location of 
extensions.ini

info.php does point to /usr/local/etc   !!!

Where does this come from, I wonder - could there be an older 
configuration file floating about somewhere in the guts of FreeBSD?

This is from php5 Makefile:
(my **** --- are these ok?)
...snip
CONFIGURE_ARGS=    \
       --with-layout=GNU \
       --with-config-file-scan-dir=${PREFIX}/etc/php \  ****
       --disable-all \
       --enable-libxml \
       --with-libxml-dir=${LOCALBASE} \
       --with-pcre-regex=${LOCALBASE} \
       --enable-reflection \
       --program-prefix=""
snip...snip
OPTIONS=    CLI "Build CLI version" on \
       CGI "Build CGI version" on \
       APACHE "Build Apache module" off \   ****
       DEBUG "Enable debug" off \
       SUHOSIN "Enable Suhosin protection system (not for jails)" on \
       MULTIBYTE "Enable zend multibyte support" off \
       IPV6 "Enable ipv6 support" on \
       MAILHEAD "Enable mail header patch" off \
       REDIRECT "Enable force-cgi-redirect support (CGI only)" off \
       DISCARD "Enable discard-path support (CGI only)" off \
       FASTCGI "Enable fastcgi support (CGI only)" on \
       PATHINFO "Enable path-info-check support (CGI only)" on
snip...

????
> > After installing phpMyAdmin there is no phpadmin database in MySql and I
> > cannot connect to phpadmin - error - Cannot access mysql module, check
> > php configuration.
> >     
>
>     There will be no phpMyAdmin database.  The phpMyAdmin script is a
> frontend to manage your MySQL databases, but doesn't create its own
> database.  However, installation of that software is beyond the scope
> of this list, and doesn't seem to be your primary problem anyway.
>
>   
> > I tried to clean out theFBSD server files of almost all files and
> > directories related to MySql, php5, phpmyadmin and then reinstalled
> > MySql50, php5, phpmyadmin as well as php5-mysql, php5-gd and php5-pgsql.
> > Both php5-mysql and php5-pgsql installed the required modules in the
> > extensions.ini directory - but the mysql module is not recognized by
> > info.php.
> >     
>
>     Once again, verify that you're changing the same php.ini file in
> the same location as what phpinfo() reports, and restart Apache when
> you make changes.
>
>   
I'M JUST GETTING MORE AND MORE CONFUSED AND REALLY DISAPPOINTED AT THE 
SEEMING COMPLEXITY OF ALL THIS.
:-(.