Topic: SME 5.6u2 (s/g) - updating PHP to 4.3.2-2db

[Robert Harlow]

Sirs

Does this break MySQL in some way?

A required new facility specifies a higher version of gd. The recommendation was to update PHP. Searching the SME forums revealed that Dan Brown's guidance was to use -2db as it shouldn't consequently break PEAR and/or WebMail. Found a 'Dan' mirror that included those -2db files and went ahead as below. There were the following dependency errors:

[root@nas600 php]# rpm -Uvh *.rpm
error: failed dependencies:
        unixODBC is needed by php-odbc-4.3.2-2db
        libodbc.so.1   is needed by php-odbc-4.3.2-2db
        postgresql is needed by php-pgsql-4.3.2-2db
        libpq.so.2   is needed by php-pgsql-4.3.2-2db

Wasn't entirely certain that I actually needed odbc and pgsql stuff so I disabled the two files that related to odbc and pgsql, as below:

[root@nas600 php]# dir
descript.ion                  php-manual-4.3.2-2db.i386.rpm
mod.php.html                  php-mysql-4.3.2-2db.i386.rpm
php-4.3.2-2db.i386.rpm        php-odbc-4.3.2-2db.i386.rpm.disabled
php-devel-4.3.2-2db.i386.rpm  php-pgsql-4.3.2-2db.i386.rpm.disabled
php-imap-4.3.2-2db.i386.rpm   php-snmp-4.3.2-2db.i386.rpm
php-ldap-4.3.2-2db.i386.rpm

However I do need mysql both for a legacy forum and also for this new facility, so continued as follows:

[root@nas600 php]# rpm -Uvh *.rpm
Preparing...                ########################################### [100%]
   1:php                    warning: /etc/php.ini created as /etc/php.ini.rpmnew
########################################### [ 14%]
   2:php-devel              ########################################### [ 28%]
   3:php-imap               ########################################### [ 42%]
   4:php-ldap               ########################################### [ 57%]
   5:php-manual             ########################################### [ 71%]
   6:php-mysql              ########################################### [ 85%]
   7:php-snmp               ########################################### [100%]

As you can see, all appeared to go well. Now I have no MySQL, so my legacy forum does not work. On a lesser vein WebMail doesn't work but that's not terribly important here, though it would be nice if it did work properly;~/ My POP3 email still seems to be running, for which I am greatly relieved, though that's only testing to myself from myself!

phpMyAdmin isn't very happy either. By using an well worn route to invoke it, the following is shown:
cannot load MySQL extension,
please check PHP Configuration.
Documentation

So, on the face of it, PHP seems to be broken. The SME server-manager's addon that is called update-system has a currently installed options viewing panel. That shows a bunch of PHP lines now nicely up to 4.3.2-2db. It also shows a bunch of MySQL lines still at the version of 3.23.49-3 at which they were before I tried updating PHP.

Is there something I need to do to get MySQL back on the job?

Or is it just necessary to reboot the server?

best wishes, Robert

[Dan Brown]

Try this:

/sbin/e-smith/expand-template /etc/php.ini
/etc/rc.d/init.d/httpd-e-smith restart

create /home/e-smith/files/primary/html/test.php, containing only this line:



Browse to http://yourserver/test.php.  Does it indicate mysql support?

[Robert Harlow]

...but am I glad to hear from your Dan:-)
Your advice followed to the letter.
Just a blank white page resulted from running the test.php file.
Just in case this mattered...
/etc/php.ini contained a line... display_errors = Off
...I adjusted it read but there was no difference while running test.php file. I PuTTY'd back in and again ran your httpd restart line. Browsing to test.php file now reports...
Parse error: parse error, unexpected T_STRING in /home/e-smith/files/primary/html/test.php on line 1

I am hoping that that is what you were expecting or at least half expecting.

BTW my attempt to launch the existing phpMyAdmin stuff is now successful. The first thing it reports is PHP 4.3.2. so that must be good news. Is there something in all the stuff that it lists that can help you?

best wishes, Robert

[Robert Harlow]

Dan, my effusive thanks for your timely assistance:-)

Whatever it is that my above posts represents, the bottom line is that my legacy PHP based text-forum (Phorum) is now working as well as it ever did.

With a bit of elementary messing about I have now got its replacement graphics-forum (phpwebalbum) up and running with what amounts to an utterly unbelievable ease!

OK it's only to a basic, out of the box, level. However it IS in, up and running, and I can now get down to some serious tweaking, customising, and back to creativity instead of wall-to-wall head scratching;~/  Relief! Time for a coffee. If you want to see what it was all about, the gallery site is 'appropriate' to my login email address.

best wishes, Robert

[Steve]

Help! Not i have done this right. I download all the 2db files and installed using rpm -Uvh --nodeps *.rpm

I have broken mysql

This is the only ref to mysql in the php test info

'./configure' 'i386-redhat-linux' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-gd' '--with-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl' '--with-png' '--with-regex=system' '--with-ttf' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--with-apxs=/usr/sbin/apxs'

[Robert Harlow]

I followed Dan's help earlier in this thread and I got MySQL back working. My difficulty with the php test info was that the primary area had (still has in fact) higher permissions than those on the iBays. Notwithstanding I have 'everything' PHP-related running nicely... if that helps you out any. My new phpwebalbum is running very well and its use of the PHP-native gd2 is impressively effective.

Broken (but I don't care overly) - imap and webmail.

It may be associated with the PHP upgrade but mod_gzip seems to be up the pole as well.

best wishes, Robert

[Dan Brown]

Why on earth did you use --nodeps?  It shouldn't be necessary for installing anything, and it certainly isn't required for installing any of my RPMs that I'm aware of (and if it is, I'd like to know about it, as it means something's probably broken).  In any case, do you have any references to mysql in /etc/php.ini?

[Steve]

Because i got the same failed depandancies as Robert reported and also whilst trying to cobble enough info together to attempt this i had seen a suggestion to try nodeps.

I ran the mysql rpm seperately and that seems to have done the trick for phpwebsite 9.2.1  then old php script sites where producing a blank page. Removing a disused ibays seem to have set these sites into running order again.

[Robert Harlow]

I physically disabled only those failed dependencies reported and documented above, I did not disable rpms error-checking altogether by (mis)using the --nodeps switch!!

best wishes, Robert

[Steve]

Robert,

I see that now. Thanks.