2018-04-27, 08:22

Feb 27, 2012 — Notify Users module, ver. 0.5 released — user can choose between sending single message (...) »

2013-01-28, 08:32

19 студзеня 2013 у Гродне трагічна загінуў паэт, журналіст і мой сябар (...) »

2009-10-14, 07:19

The site Litaratura.org is devoted to Belarusian literary works and translations. (...) »

2009-01-12, 20:46

Late November 2008 marked the 20th anniversary of the official founding of the Belarusian (...) »

Registered User Area Log into This Site
Show Credits... Credits
Worthwhile Services
Refresh My Local Time (GMT+1)... Apr 27, 2018 — 08:22
  • Russian Federation (2)
    United States (5)
  • Today (102)
  • Yesterday (451)
~ / Public Domain Software / Overcoming Defective MySQL 5.0.51 on Slackware 12.0 (+some more) $_
Overcoming Defective MySQL 5.0.51 on Slackware 12.0 (+some more)
Click To View A Full Size Image...
2009-04-11, 19:02

MySQL 5.0.51 database server is the only version stated as not being recommended for use with the MODx application framework. Unfortunately, this version of the server is the latest stable release designed for the Slackware 12.0 operating system. After upgrading MySQL to 5.0.51, users with MODx-based sites are experiencing unpredictable behavior of their CMS. This issue was discussed extensively on this forum — a practical solution is to refrain from obtaining the upgrade. I was following the development of this scenario for many months, hoping that someday I’ll be able to upgrade the entire OS (along with an improved MySQL server application)…

But that day did not arrive — each month brought new projects, developments, databases and web applications, supplanting my ambitious project of upgrading the entire system.

Recently, I came to the conclusion that under the circumstances, such an upgrade is pointless — I simply cannot afford to experiment with a system, while its resources are being shared by many users/customers. However, I decided to put some effort into fine-tuning system components (the main reason we love Linux is its built-in ability to produce new versions of software using the source code).

Compiling software by issuing the standard sequence:

Code

./configure
make
make install

results in building a private copy of the application under „/usr/local” folder and is regarded as somewhat messy in terms of style. A better way is to build a standard (distributive) package that may subsequently be used to upgrade the old version. My efforts yielded three crucial (from a web developer’s point of view) packages for Slackware 12.0:

httpd-2.2.11-i486-1_slack12.0.tgz

mysqld-5.0.77-i486-1_slack12.0.tgz

php-5.2.9-i486-1_slack12.0.tgz

All packages can be installed by issuing Slackware’s standard command (within root’s console):

Code

upgradepkg <new-package-name>

Of course, it is a good idea to stop the server applications prior to the upgrade...

Code

rc.httpd stop
rc.mysqld stop

... and reboot the system after the upgrade is complete — in order to have all newly-installed libraries properly started.

Some additional remarks regarding the PHP package. I’ve compiled it after MySQL’s upgrade, so PHP’s extension „mysqli” is based on the new 5.0.77 libraries. I’ve also added two extra extensions to the PHP build: „mcrypt” (I was annoyed by phpMyAdmin constantly issuing a „cannot load mcrypt extention, please check your PHP configuration” message) and „mssql” (an interface layer for the MSSQL database). These extentions are NOT activated by default – in order to use them, you need to add the following to your php.ini (in the extension section):

Code

extension=mcrypt.so
extension=mssql.so

(This text was originally written for MODx Community Forum.)

Download This Attachment... Apache HTTP Server ver. 2.2.20 — Slackware 12.0 Package
Last modified: 2011-08-31, 00:00 — Size: 1,98 MB — Users: 66 — Downloads: 202
Download This Attachment... Apache HTTP Server ver. 2.2.21 — Slackware 12.0 Package
Last modified: 2011-09-16, 00:00 — Size: 1,98 MB — Users: 69 — Downloads: 217
Download This Attachment... MySQL Database Server ver. 5.0.91 — Slackware 12.0 Package
Last modified: 2010-05-20, 00:00 — Size: 16,98 MB — Users: 46 — Downloads: 104
Download This Attachment... MySQL Database Server ver. 5.0.92 — Slackware 12.0 Package
Last modified: 2011-06-21, 00:00 — Size: 17,08 MB — Users: 31 — Downloads: 83
Download This Attachment... PHP ver. 5.2.17 — (compiled against MySQL 5.0.91) — Slackware 12.0 Package
Last modified: 2011-01-08, 00:00 — Size: 7,77 MB — Users: 33 — Downloads: 108
Download This Attachment... PHP ver. 5.2.17 — (compiled against MySQL 5.0.92) — Slackware 12.0 Package
Last modified: 2011-06-21, 00:00 — Size: 7,77 MB — Users: 32 — Downloads: 106
Click to show a form...Click to hide the form... Write a comment
  • Required fields are marked with *.
  • Comments are published after the approval of the site owner, who is a human rather than a wind-fast computer program so please be patient.

* Code:
 
Get another image...Enter this code into the appropriate field of the form while submitting an e-mail or a comment. If you have trouble with reading it, generate another...