LinuxWebLog.com - Tips, Tricks, Resources and Guides for Linux Users ;-P

php with mysqlnd support

sandip — Sat, 13 Mar 2010 07:11:58 +0000

You can now get the latest PHP with mysqlnd (MySQL Native Driver) support via remis' yum repository as mentioned in PHP-5.3,-zts-and-mysqlnd. The blog mentions that this is enabld in php-zts. However, no php-pecl extension are available and neither are some of the extensions thread safe. So I went about rebuilding php package from source for mysqlnd support.

Download the source php rpm from http://rpms.famillecollet.com/SRPMS/ . Note, I have used php-5.3.2 which is the latest as of this writing.
Install and apply the below diff patch to the spec file via `patch -p0 < {new_patch_file}` where "new_patch_file" has the below contents:
--- php-5.3.2-remi.spec.orig 2010-03-11 23:07:04.000000000 -0600 +++ php-5.3.2-remi.spec 2010-03-11 23:36:03.000000000 -0600 @@ -24,6 +24,7 @@ %global phpversion 5.3.2 # Optional components; pass "--with mssql" etc to rpmbuild. +%define with_mysqlnd %{?_with_mysqlnd:1}%{!?_with_mysqlnd:0} %define with_oci8 %{?_with_oci8:1}%{!?_with_oci8:0} %define with_ibase %{?_with_ibase:1}%{!?_with_ibase:0} %if %{?rhel}%{?fedora} > 4 @@ -677,6 +678,11 @@ %if %{?fedora}%{?rhel:99} >= 10 --with-system-tzdata \ %endif +%if %{with_mysqlnd} + --with-mysql=shared,mysqlnd \ + --with-mysqli=shared,mysqlnd \ + --with-pdo-mysql=shared,mysqlnd \ +%endif $* if test $? != 0; then tail -500 config.log @@ -704,8 +710,13 @@ --enable-dba=shared --with-db4=%{_prefix} \ --with-xmlrpc=shared \ --with-ldap=shared --with-ldap-sasl \ +%if %{with_mysqlnd} + --with-mysql=shared,mysqlnd \ + --with-mysqli=shared,mysqlnd \ +%else --with-mysql=shared,%{_prefix} \ --with-mysqli=shared,%{_bindir}/mysql_config \ +%endif %ifarch x86_64 %{?_with_oci8:--with-oci8=shared,instantclient,%{_libdir}/oracle/%{oraclever}/client64/lib,%{oraclever}} \ %else @@ -725,7 +736,11 @@ --enable-fastcgi \ --enable-pdo=shared \ --with-pdo-odbc=shared,unixODBC,%{_prefix} \ +%if %{with_mysqlnd} + --with-pdo-mysql=shared,mysqlnd \ +%else --with-pdo-mysql=shared,%{_prefix} \ +%endif --with-pdo-pgsql=shared,%{_prefix} \ --with-pdo-sqlite=shared,%{_prefix} \ --with-pdo-dblib=shared,%{_prefix} \ @@ -756,6 +771,16 @@ --with-recode=shared,%{_prefix} popd +%if %{with_mysqlnd} +without_shared="--without-gd \ + --disable-dom --disable-dba --without-unixODBC \ + --disable-xmlreader --disable-xmlwriter \ + --without-sqlite \ + --disable-phar --disable-fileinfo \ + --disable-json --without-pspell --disable-wddx \ + --without-curl --disable-posix \ + --disable-sysvmsg --disable-sysvshm --disable-sysvsem" +%else without_shared="--without-mysql --without-gd \ --disable-dom --disable-dba --without-unixODBC \ --disable-pdo --disable-xmlreader --disable-xmlwriter \ @@ -764,6 +789,7 @@ --disable-json --without-pspell --disable-wddx \ --without-curl --disable-posix \ --disable-sysvmsg --disable-sysvshm --disable-sysvsem" +%endif # Build Apache module, and the CLI SAPI, /usr/bin/php pushd build-apache

Package with:

rpmbuild -bb --with mysqlnd --define "rhel 5" SPECS/php-5.3.2-remi.spec

To install via yum, change to the directory where rpms are located and recreate the repodata via:

createrepo .
Note: you may need to install some of the missing dependent devel packages. I used a combination of base, epel and remi repository to install the dependencies.

FBReader - e-book reader for Linux desktops

david23 — Mon, 08 Mar 2010 08:40:28 +0000

FBReader is an e-book reader. It currently works on the Sharp Zaurus, Siemens Simpad with Opensimpad ROM, Nokia
Internet Tablet (Maemo platform), Archos PMA430, Motorola E680i/A780/A1200 smartphones, PepperPad 3, Asus Eee PC, IRex iLiad, UMPC, and desktop computers running Linux, Windows XP/Vista, or FreeBSD. It supports several e-book formats: epub, plucker, palmdoc, zTXT, HTML, CHM, fb2, TCR (psion text), OEB, OpenReader, RTF, non-DRM'ed Mobipocket, and plain text.

Original news source

Advance Linux Programming

sandip — Wed, 03 Mar 2010 21:37:40 +0000

Advanced Linux Programming is published under the Open Publication License, Version 1, no options exercised.

If you're a developer already experienced with programming for the GNU/Linux system, are experienced with another UNIX-like system and are interested in developing GNU/Linux software, or want to make the transition for a non-UNIX environment and are already familiar with the general principles of writing good software, this book is for you...

Original news source

Cinecutie - New Video editor and composer for Linux

david23 — Mon, 15 Feb 2010 10:19:01 +0000

After lot of time spent to learn the cinelerra code, I want to move an other step on the opensource contribute. I’m started from tangolerra project made by Franco Iacomella and after an hard job with svg I made my personal mochup
of Cinelerra called Cutiehd. But when I started to work on the mochup of Cinelerra 2.1cv I tryed to enable again
the support of font antialias (xft), write a draft of Utf-8 support, rewrite some parts of titler code and adapt
the svg plugin from the Cinelerrasv by “Simeon Völkel”.

Original news source

In place variable substitution with AWK

sandip — Thu, 04 Feb 2010 17:21:23 +0000

The content of the input file becomes stdin for rm and awk. rm ignores the input and removes the file, but its file descriptor remains open until both commands, rm and awk is complete. AWK process this "nameless" file and creates a new file:

  { rm $CSV_FILE && awk -F',' -v stid="$ST_ID" '$1 ~ stid {gsub(/&/,"",$7)}1' > $CSV_FILE; } < $CSV_FILE

"-v" sets the awk variable that is passed in via shell script variable.
"gsub" replaces with "" all occurrence of & in the 7th field. Use "sub" for single/first occurrence substitution or GNU Awk's gensub for more articulated substitutions.
"1" is a shortcut which means print the current record:

pecl runkit with php-5.2.x

sandip — Thu, 21 Jan 2010 21:11:57 +0000

As of writing, the current pecl runkit-0.9 package does not compile with PHP 5.2+ . Below is how I got the latest installed from svn trunk on CentOS-5.4 with php-5.2.9.

Install runkit:

svn co http://svn.php.net/repository/pecl/runkit/trunk/ cd trunk phpize ./configure make make install
Create "/etc/php.d/runkit.ini":

extension=runkit.so
Restart apache and validate with phpinfo.

Note: you would need php-pear and php-devel installed already.

Create Custom Ubuntu Live-CD With Remastersys in Karmic

david23 — Wed, 20 Jan 2010 11:27:39 +0000

Remastersys is a tool that can be used to do 2 things with an existing Klikit or Ubuntu or derivative installation.It can make a full system backup including personal data to a live cd or dvd that you can use anywhere and install. It can make a distributable copy you can share with friends. This will not have any of your personal user data in it.

Original news source

y2k10 bug in SpamAssassin

sandip — Tue, 19 Jan 2010 16:29:37 +0000

If running 3.2.x version of SpamAssassin... (check with `spamassassin -V`) there is a y2k10 bug in the FH_DATE_PAST_20XX rule, causing all mails getting an extra 3.4 points:

Reference: SA Bugzilla – Bug 6269

The fix mentioned is to update the rules using `sa-update` and restart spamd. The rules in the update directory at /var/lib/spamasassin will get updated.

With the fix applied you should no longer see FH_DATE_PAST_20XX in the logs.

For a manual fix, update /usr/share/spamassassin/72_active.cf and change:

header FH_DATE_PAST_20XX Date =~ /20[1-9][0-9]/ [if-unset: 2006]

to:

header FH_DATE_PAST_20XX Date =~ /20[2-9][0-9]/ [if-unset: 2006]

Related reading on sa-update: SpamAssassin RuleUpdates

Permanent SSH Tunnel Between Linux Servers

sandip — Sun, 17 Jan 2010 03:36:39 +0000

I recently had a need to create a permanent SSH tunnel between Linux servers. My need was to allow regular non-encrypted MySQL connections over an encrypted tunnel, but there could be many other uses as well. Google can identify plenty of resources regarding the fundamental SSH commands for port forwarding but I didn’t ever find a good resource for setting up a connection and ensuring that it remains active, which is what I hope to provide here...

Original news source

MySQL Persistent vs Non-Persistent Connections

sandip — Thu, 14 Jan 2010 23:38:22 +0000

This post will be about benchmarking of MySQL Persistent Connections vs Non-Persistent Connections -- what always seems to be a hot topic among PHPers about what connection type to use when connection to a MySQL database...

Original news source