HTNet - A Notepad of Tech, Business, Science and Self Improvement

I wanted to play around with PostgreSQL on the test server at work today, and found the slackpack over at LinuxPackages. I was very pleased that I wouldn’t have to compile PostgreSQL from source, as such complex apps will take more time than I would like to invest.

Anyway, once I’ve installed the package, and initialised the database, I decided to give phpPgAdmin a whirl on my freshly baked PostgreSQL installation, but when I try to use it I get an error message telling me that I have not compiled proper database support into my PHP installation.

Bargh, I checked out my phpinfo(); and sure enough, Slackware‘s package was not built with the --with-pgsql option.

Most of my googling results metion that the only solution is to recompile PHP from scratch, including the --with-pgsql flag. Hmm, I’d really hate to replace my original PHP installation which was done in the “proper” way, ie. via the available slackpack. Who know what the hell I can possibly misconfigure and break!

Anyway, here’s how I got my PostgreSQL to work with the default Slackware PHP installation:

1. Download the PHP source code (be sure to use the PHP version that’s the same with your installation).
2. Unpack the archive and go to the source directory (well, duh!).
3. Run ./configure ---with-pgsql=shared,/usr (I know it’s too short, but just trust me on this, OK).
4. Run make.
5. Don’t run make install or checkinstall (if you’re using checkinstall, that is) like you usually would.
6. Just copy <php source dir>/modules/pgsql.so to /usr/lib/php/extensions.
7. As root, edit your /etc/apache/php.ini file and look for a line saying extension=mysql.so
8. Under this line type in: extension=pgsql.so and save the file.
9. Restart your apache service by running /etc/rc.d/rc.httpd restart (again, as root) to activate PostgreSQL support in PHP.

Hope this helps other Slackers as well as Linux users in general.

Yep, massive updates. Slackware users are advised to grab the latest packages of these apps:

• KOffice
• lynx
• curl
• wget
• apache
• imapd
• PHP
• elm

Details are as follows;

Read the rest of Slackware Security Updates: KOffice, lynx, curl, wget, apache, imapd, PHP and elm »

There’re new OpenSSL packages for all recent versions of the Slackware Linux distro. Details of this update are as follows:

New OpenSSL packages are available for Slackware 8.1, 9.0, 9.1, 10.0, 10.1, 10.2, and -current to fix a security issue. Under certain conditions, an attacker acting as a “man in the middle” may force a client and server to fall back to the less-secure SSL 2.0 protocol.

More details about this issue may be found here:

http://www.openssl.org/news/secadv_20051011.txt
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2005-2969

Updated packages can be downloaded from the Slackware Package Browser or using automated package management tools like Swaret or slapt-get.

There’s an update to the xine-lib package for Slackware. If you use it, please update to this new version (1.0.3a). A question that strikes me when reading this notification is, “What the hell are the odds that this vuln can actually be implemented in real-life?”

Read the rest of Slackware Security Update: xine-lib »

Slackware users rejoice! The long awaited Slackware 10.2 has been released. The official announcement can be read here. You might also want to check out the changelog.

You can get Slackware Linux 10.2 from The Slackware Store (official boxed set), BitTorrent or mirror sites (ISOs).