Helmi Ble'be'

gearman php problem on jaunty

2009-10-28T17:52:00.001+08:00

Get this error on my ubuntu jaunty, works perfectly on hardy. I don't have the solution (hope expert out there post solution in comment)

helmi@gandalf:/tmp> php reverse_client.php 
Sending job
ALERT - canary mismatch on efree() - heap overflow detected (attacker 'REMOTE_ADDR not set', file '/tmp/reverse_client.php', line 10)

How I install:

helmi@gandalf:~/Packages/php> sudo pecl install gearman-0.6.0

some info:

helmi@gandalf:~/Packages/php/gearman-0.6.0> phpize
Configuring for:
PHP Api Version:         20041225
Zend Module Api No:      20060613
Zend Extension Api No:   220060519
helmi@gandalf:~/Packages/php/gearman-0.6.0> echo '<?php phpinfo();' | php| head 
phpinfo()
PHP Version => 5.2.6-3ubuntu4.2

System => Linux gandalf 2.6.28-15-server #52-Ubuntu SMP Wed Sep 9 11:50:50 UTC 2009 i686
Build Date => Aug 21 2009 19:12:00
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /etc/php5/cli
Loaded Configuration File => /etc/php5/cli/php.ini
Scan this dir for additional .ini files => /etc/php5/cli/conf.d

helmi@gandalf:~/Packages/php/gearman-0.6.0> gearmand -V
gearmand 0.10 - https://launchpad.net/gearmand

Fix IE6 png transparency

2009-10-16T21:41:00.000+08:00

Don't know who use IE6 these days (already 2009 lah), but one of my friend need to fix his website. So here the css (modified from a google result)

<!--[if lt IE 7]>
<style>
img {
  position: relative;
  behavior: expression((this.runtimeStyle.behavior="none")&&(this.pngSet?this.pngSet=true:(this.nodeName == "IMG" && this.src.toLowerCase().indexOf('.png')>-1?(this.runtimeStyle.backgroundImage = "none",
  this.runtimeStyle.filter = "progid:DXImageTransform.Microsoft.AlphaImageLoader(src='" + this.src + "', sizingMethod='image')",
  this.src = "http://imgur.com/ZOqET.gif"):(this.origBg = this.origBg? this.origBg :this.currentStyle.backgroundImage.toString().replace('url("','').replace('")',''),                                                                                                                                                     
  this.runtimeStyle.filter = "progid:DXImageTransform.Microsoft.AlphaImageLoader(src='" + this.origBg + "', sizingMethod='crop')",
  this.runtimeStyle.backgroundImage = "none")),this.pngSet=true));
}
</style>
<![endif]-->

Inconsistent PHP - I'm sick of it

2009-10-09T11:10:00.002+08:00

PHP is inconsistent, sick of it. $needle or $haystack? Which one first? List of php function that inconsistent needle/haystack

helmi@gandalf:/usr/share/doc/php-doc/html> grep -l needle *| grep ^function | sed 's/^function.//'| sed 's/.html$//'| sed 's/-/_/'
array_search
grapheme_stripos
grapheme_stristr
grapheme_strpos
grapheme_strripos
grapheme_strrpos
grapheme_strstr
iconv_strpos
iconv_strrpos
in_array
mb_stripos
mb_stristr
mb_strpos
mb_strrchr
mb_strrichr
mb_strripos
mb_strrpos
mb_strstr
mb_substr-count
stripos
str_ireplace
stristr
strpos
strrchr
str_replace
strripos
strrpos
strstr
substr_count

So I refer to php manual everytime use these functions, grrr. For vim, i override key binding for 'K' (:help K) - "Run a program to lookup the keyword under the cursor". In .vimrc

autocmd FileType php set keywordprg=~/bin/php_doc

and my ~/bin/php_doc


#!/bin/sh                               
FN=`echo $1 | sed 's/_/-/g'`
echo ********************** $FN **********************

echo $FN
w3m file:///usr/share/doc/php-doc/html/function.$FN.html

OpenStreetMap data for Malaysia = impressive progress!

2009-10-02T20:53:00.005+08:00

Version 17 Apr 09

Version 24 Sept 09

OpenStreetMap data for Malaysia = impressive progress!
Quite a lot of new road added at Kuala Lumpur for 5 months work.
Map above viewed using udig.
Google Map Maker is available for Malaysia, but don't think it easy for offline usage/internal use (hint:shapefile).

Which location column more trusted?

2009-08-28T12:21:00.003+08:00

You have database from your client with fields state, district (description of locations), and the_geom (latitude/longitude) column. Example of the db


| state    | district | the_geom                                 |
| Selangor | Petaling | POINT(101.497838106615 3.27468487066054) |

Anyone doing GIS should know that, the state, district fields is duplicate with the_geom since once we know the latitude/longitude we will know the state, district.
The problem is the_geom is not within Selangor, Petaling. Then when do group by st_intersects, the value is wrong since the_geom is refer to other place!

So, need to decide, which location column more trusted?
The latitude/longitude or description of locations.

Mapnik need to know postgis column type

2009-06-26T00:15:00.003+08:00

Mapnik need to know postgis column type to render properly. This mapnik xml for style not working for me.


 <Style name="jalan_casing2">
    <Rule>
      <Filter>[jenis] = 'lebuhraya'</Filter>
      <MaxScaleDenominator>&maxscale_zoom7;</MaxScaleDenominator>
      <MinScaleDenominator>&minscale_zoom7;</MinScaleDenominator>
      <LineSymbolizer>
        <CssParameter name="stroke">#808080</CssParameter>
        <CssParameter name="stroke-width">6</CssParameter>
        <CssParameter name="stroke-linejoin">round</CssParameter>
        <CssParameter name="stroke-linecap">round</CssParameter>
      </LineSymbolizer>
    </Rule>
  </Style>
  <Layer name="jalan_lebuhraya" srs="+proj=latlong +datum=WGS84" status="on">
    <StyleName>jalan_casing2</StyleName>
    <StyleName>jalan_fill</StyleName>
    <StyleName>jalan_text</StyleName>
    <Datasource>
      <Parameter name="type">postgis</Parameter>
      <Parameter name="password"></Parameter>
      <Parameter name="host">localhost</Parameter>
      <Parameter name="port">5432</Parameter>
      <Parameter name="user">helmi</Parameter>
      <Parameter name="dbname">road</Parameter>
      <Parameter name="table">(select * no_jalan, 'lebuhraya' as jenis, the_geom from jalanraya.lebuhraya) as jalan</Parameter>
      <Parameter name="estimate_extent">false</Parameter>
      <Parameter name="extent">-180,-90,180,89.99</Parameter>
    </Datasource>
  </Layer>

My workaround (only tested on Ubuntu Jaunty) is cast the new column as varchar.


(select * no_jalan, 'lebuhraya'::varchar as jenis, the_geom from jalanraya.lebuhraya) as jalan

Mapnik is better than MapGuide when rendering road labels

OptimizeRenderingWithPostGIS

MapGuide 2.1beta

2009-05-27T16:14:00.004+08:00

Eager to try beta version, here I log the problem I face and how I solve.

Error msg:


httpd.exe: Syntax error on line 127 of C:/Program Files/OSGeo/MapGuide/Web/Apache2/conf/httpd.conf: Cannot load ../Php/MgHttpHandler.dll into server: The specified procedure could not be found.

Fix by move directive 'MgHttpHandler.dll' up


LoadFile ../Php/php5ts.dll
LoadFile ../Php/ACE.dll
LoadFile ../Php/MgHttpHandler.dll # put this directive here, the first one and restart apache service
LoadFile ../Php/MgFoundation.dll
LoadFile ../Php/MgGeometry.dll
LoadFile ../Php/MgMapGuideCommon.dll
LoadFile ../Php/MgMdfModel.dll
LoadFile ../Php/MgMdfParser.dll
LoadFile ../Php/MgPlatformBase.dll
LoadFile ../Php/MgWebApp.dll

http://n2.nabble.com/MGOS-2.0.0-Beta-2-loadfile-error-td1816710.html

No nginx gzip on jaunty

2009-05-26T17:29:00.001+08:00

https://bugs.launchpad.net/ubuntu/+source/nginx/+bug/346010

schema.table to "schema"."table"

2009-05-13T15:39:00.003+08:00

PHP


<?php
$st = 'schema.table';
print join('.', array_map(create_function('$a', 'return \'"\'.$a.\'"\';'), explode('.', $st)));

Selected 3 of 3 Lines; 11 of 11 Words; 124 of 124 Bytes

Python


st = 'schema.table'
print '.'.join('"'+i+'"' for i in st.split('.'))

Selected 2 of 2 Lines; 9 of 9 Words; 69 of 69 Bytes

Python=PHP/2

Trac error - database disk image is malformed

2009-05-05T17:38:00.002+08:00

One of my trac page got the error message "database disk image is malformed"

"underlying Trac DB is in serious trouble, may corrupted" - Ticket #6347

How I fix:

sqlite3 trac.db .dump | sqlite3 trac2.db
cp trac.db trac.broken.db
cp trac2.db trac.db

Find files, php5 way

2009-05-04T18:26:00.005+08:00

Find files, implemented using iterator.


class RegexFilter extends FilterIterator {
    protected $regex;

    public function __construct(Iterator $it, $regex) {
        parent::__construct($it);
        $this->regex = $regex;
    }

    public function accept() {
        return preg_match($this->regex, $this->current());
    }
}

function find_files($path, $pattern, $include_dir=FALSE) {
  $objects = new RecursiveDirectoryIterator($path);
  $objects = new RecursiveIteratorIterator($objects, RecursiveIteratorIterator::SELF_FIRST);
  $objects = new RegexFilter($objects, $pattern);
  return $objects;
}

Example usage:


$files = find_files('/tmp', '/.py$/');
foreach ($files as $file) {
  echo $file;
}

Previously using php 4:


function find_files4($path, $pattern, $callback=null) {                                                                                               
    $path = rtrim(str_replace("\\", "/", $path), '/') . '/';
    $matches = Array();
    $entries = Array();
    $dir = dir($path);
    while (false !== ($entry = $dir->read())) {
        $entries[] = $entry;
    }
    $dir->close();
    $files = array();
    foreach ($entries as $entry) {
        $fullname = $path . $entry;
        if ($entry != '.' && $entry != '..' && is_dir($fullname)) {
            $this->find_files($fullname, $pattern, $callback);
        } else if (is_file($fullname) && preg_match($pattern, $entry)) {
            if (!$callback) {
                $files[] = $fullname;
            } else {
                call_user_func($callback, $fullname);
            }
        }
    }
    if (!$callback) {
        return $files;
    }
}

import data from csv into postgresql

2009-05-04T12:03:00.003+08:00

We can use sql command, COPY. But programmer still need to create the table before copy the data. Simple python script to help


#!/usr/bin/python
fn = '/home/helmi/world.csv'
columns = file(fn).readline()
print 'create table world (%s text);' % " text,".join(columns.split(','))
print "copy world from '%s' with csv header;" % fn

then

python csv2psql.py | psql mydb

Validate KML

2009-03-06T16:14:00.008+08:00

I implement dynamic KML data using PHP + Postgis for a pet project. The problem is, Google Earth don't tell you the error when our kml file have problem, such as invalid KML. It just not appear in 'My Places' or 'Temporary Places'. So, I keep wondering whether I open correct link, or php not working, etc.

Previously how I debug is by check apache log or postgresql log. But just found the 'macho' way - by command line:


sudo apt-get install xmlstarlet
helmi@gandalf:/tmp> xmlstarlet val -e --xsd http://code.google.com/apis/kml/schema/kml21.xsd tree.kml 
tree.kml - valid
# for offline xsd
helmi@gandalf:/tmp> wget -c  http://code.google.com/apis/kml/schema/kml21.xsd
helmi@gandalf:/tmp> xmlstarlet val -e --xsd kml21.xsd tree.kml 
tree.kml - valid
# without option -e, don't know status when xsd file not found
helmi@gandalf:/tmp> xmlstarlet val --xsd invalid_kml21.xsd tree.kml 
# better version
helmi@gandalf:/tmp> xmlstarlet val -e --xsd invalid_kml21.xsd tree.kml 
I/O warning : failed to load external entity "invalid_kml21.xsd"
Schemas parser error : Failed to locate the main schema resource at 'invalid_kml21.xsd'.
# of course you can validate kml generated by php
helmi@gandalf:/tmp> xmlstarlet val -e --xsd kml21.xsd http://localhost/~helmi/tree_kml/trees.php
http://localhost/~helmi/tree_kml/trees.php - valid

Google Earth gotchas:
* when click url http://localhost/~helmi/tree_kml/trees.php (this php return header with KML mimetype properly), and open with Google Earth, it not appear at 'Temporary Places'. One workaround, use apache url rewrite to redirect trees.kml to trees.php
not really gotcha, hint: header('Content-Disposition: attachment; filename="test_file.kml"');


RewriteEngine on
RewriteBase /~helmi/tree_kml/
RewriteRule trees\.kml$ trees.php [NC] # note that without option R

Now, use http://localhost/~helmi/tree_kml/trees.kml to display in GE properly

Vim smart syntax highlighting

2008-11-29T23:50:00.002+08:00

Smart because it syntax highlighting sql in php heredoc. gedit and nano don't support this. I don't know about other editor.
I used font size 16 all the time, big font eh ;-)

Disable scrollkeeper on Ubuntu

2008-11-24T01:08:00.005+08:00

"proses ini hampir memakan 90% cpu dan memory, dan seringkali menyebabkan sistem menjadi hang" -- happen to me today and not at right time.

To disable:


sudo mv /usr/bin/scrollkeeper-update /usr/bin/scrollkeeper-update.real
sudo ln -s /bin/true /usr/bin/scrollkeeper-update
sudo find /var/lib/scrollkeeper/ -name \*.xml -type f -exec rm -f '{}' \;
sudo dpkg-divert --local --divert /usr/bin/scrollkeeper-update.real --add /usr/bin/scrollkeeper-update

Refs:
* http://blog.its.ac.id/kholis/2008/11/01/scrollkeeper-di-ubuntu/
* http://mapopa.blogspot.com/2008/09/disable-scrollkeeper-on-ubuntu-is-good.html

Google Maps driving direction to Machang, Malaysia

2008-10-31T09:41:00.002+08:00

Google Maps driving direction back again as today, 31 Oct 2008. It not official, I guessed (since not mentioned in Google LatLong). So, I give it a try from Kuala Lumpur to Machang

From Misc

The routing is accurate and fast (compared to Garmin Que+malsingmaps which lead me to Ipoh instead of Gua Musang before reach Machang). But the direction is not detail enough, see the instruction no 24 in screenshot below. "Continue on 8 -- 307 km" but from the map, the blue road show that you have turn right at Pekan Gua Musang.

From Misc

You should try 'Print' function, look useful. Hey, this driving direction also works on Google Maps on my Windows Mobile, Dopod M700. On mobile version, you have feature 'My Location' and integration with GPS works for me.

Cannot wait to see Malaysian Street View :-)

1.0 is greater than 0.9.x [ies4linux]

2008-10-16T04:21:00.002+08:00

helmi@gandalf:~/Packages/ubuntu/ies4linux-2.99.0.1$ ./ies4linux
IEs4Linux 2 is developed to be used with recent Wine versions (0.9.x). It seems that you are using an old version. It's recommended that you update your wine to the latest version (Go to: winehq.com).

and when

helmi@gandalf:~/Packages/ubuntu/ies4linux-2.99.0.1$ wine --version
wine-1.0

what?? I't wrong warning dude. 1.0 > 0.9.x

IE innerHTML - "Unknown runtime error"

2008-09-19T12:56:00.004+08:00

"Unknown runtime error" -- only in IE. Occur when click 'innerHTML WITH form tag'


<html>
<body>
  <form>
    <div id="replaceme"></div>
  </form>
  <div onclick="replace();return false;">innerHTML WITHOUT form tag</div><br/>
  <div onclick="replace2();return false;">innerHTML WITH form tag</div>
  <script>
    function replace() {
      document.getElementById('replaceme').innerHTML = 'REPLACED';
    }
    function replace2() {
      document.getElementById('replaceme').innerHTML = '<form>REPLACED form</form>';
    }
  </script>
</body>
</html>

innerHTML supposed to supported on all major browser, http://www.quirksmode.org/dom/innerhtml.html

Current solution, don't wrap the #replaceme div in form tag

"unable to resolve host" that matter

2008-08-30T05:23:00.010+08:00

The "unable to resolve host" is matter when I have problem installing mysql.

Whenever sudo in my hardy , I got "unable to resolve host" . No harm and my terminal works as usual, so just ignore it.

helmi@hix2:~> sudo -s
sudo: unable to resolve host hix2

Then, today wanna use mysql for my pet project.

helmi@hix2:~> sudo dpkg --configure mysql-server-5.0
sudo: unable to resolve host hix2
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.2) ...
* Stopping MySQL database server mysqld
...done.
Reloading AppArmor profiles Warning: found /etc/apparmor.d/force-complain/usr.sbin.named, forcing complain mode
: done.
* Starting MySQL database server mysqld
...fail!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0

Nothing in /var/log/mysql.err or /var/log/mysql.log , but something in /var/log/syslog

Aug 30 05:07:00 hix2 mysqld[2817]: 080830 5:07:00 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host'

Then "unable to resolve host" become matter now. Solution: add following line to /etc/hosts, then reconfigure mysql

127.0.1.1 hix2

Refs:

Connect winxp lappy to kubuntu using samba

2008-05-15T23:03:00.002+08:00

I want transfer files from my lappy to my kubuntu desktop FAST. I managed make my lappy talk to kubuntu via ssh (winscp), but not fast enough. Yeah, I know it caused by encrypt, bla bla ... I'm the only one who use LAN in my home, so who cares about security???

Anyway, since new to setup samba, I thought it just matter click Next, Next, ... and so on. Not that easy maa. After setup it in kubuntu, whenever I submit uname/passwd from windows xp, it keep popup the uname/passwd, without error msg. Spend hours RTFM, google , read article, ... then, manage to fix it. When troubleshoot, I reach to the:

C:\> net view \\bigboy
System error 5 has occurred.

Access is denied.

Then, it easier to fix when know cause of the problem. Just enable the 'encrypt password = yes'. I also added the samba user by smbpasswd

Why I hate innerHTML

2008-05-11T15:55:00.005+08:00

Why I hate innerHTML? Because IE suck! It doesn't work for select tag in IE. I have something like

<div>
<select id="foo"><option value="1">baz</option></select>
</div>

Javascript that doesn't work in IE:

document.getElementById("foo").innerHTML = '<option value="2">baz</option>';

Solution -- have to use DOM lah! Note that use innerHTML will destroy the tag events. My prefered solution:

document.getElementById("foo").options[0] = new Option("baz", 2);

Astute reader may ask, why not use dom method add() ? Again, because IE suck!

var x=document.getElementById("foo");
try
{
x.add(y,null); // standards compliant
}
catch(ex)
{
x.add(y); // IE only
}

http://www.w3schools.com/htmldom/met_select_add.asp

More love/hate on innerHTMl, http://www.wait-till-i.com/2006/04/18/innerhtml-vs-dom-pot-noodles-vs-real-cooking/

php popen whitespace bug in windows

2008-02-11T18:22:00.000+08:00

This popen path with whitespace bug, http://bugs.php.net/bug.php?id=40988&edit=1 make my day worse. Tired from long 9 hours journey from 'balik kampung', arrive at 3.30am and 8.30am go to office, huh. Then have to debug why the stupid php don't want execute the command.

I want use php to backup a postgis table. So

system('"C:\\Program Files\\PostgreSQL\\8.2\\bin\\pg_dump.exe" -t project_geom projectgis > '.$backup);

that, should straight forward, but the output is empty page. Then use popen to redirect the stdout and stderr, 2>&1 for debugging, I get this message

'C:\Program' is not recognized as an internal or external command, operable program or batch file.

Tried many technique to solve: escapeshellarg(), backslash to slash, all lowercase, etc, then afters spent hours debugging, it was the php problem, not my code. grrr.

BTW:
A 8.3 name (PROGRA~1) will still work on Windows, if it's not disabled
in the NTFS settings.

Traffic images on google map

2008-02-05T08:20:00.000+08:00

Simple map to show live traffic images.

Wake up early plus lazy to go to office :-( Rather than read reddit and google reader, this morning I decide to create simple map instead. Map for my town and click the marker for live traffic image, hah, deadly simple idea! Since lazy morning, I don't know any legal issue regarding the image, so "It's Easier to Ask Forgiveness Than Permission"

Turn VIM omni completion ON

2007-12-01T13:04:00.000+08:00

Turn omni completion feature by put this in vimrc.

autocmd FileType python set omnifunc=pythoncomplete#Complete
autocmd FileType javascript set omnifunc=javascriptcomplete#CompleteJS
autocmd FileType html set omnifunc=htmlcomplete#CompleteTags
autocmd FileType css set omnifunc=csscomplete#CompleteCSS
autocmd FileType xml set omnifunc=xmlcomplete#CompleteTags
autocmd FileType php set omnifunc=phpcomplete#CompletePHP
autocmd FileType c set omnifunc=ccomplete#Complete

Default vim turn off this feature. And here to set ctags

ctags -R -f ~/.vim/qttags /usr/include/qt3

:set tags +=~/.vim/qttags

Muslim prayer times by web scraping

2007-11-03T15:20:00.000+08:00

Here I'll show how to get Muslim pray times by web scraping. Web scraping is one of the methods to implement mashup.


<?php

$curl_handle=curl_init();
curl_setopt($curl_handle,CURLOPT_URL,'http://www.e-solat.gov.my/solat.php?kod=sgr03&lang=ENG');
curl_setopt($curl_handle,CURLOPT_CONNECTTIMEOUT,2);
curl_setopt($curl_handle,CURLOPT_RETURNTRANSFER,1);
$buffer = curl_exec($curl_handle);
curl_close($curl_handle);

if (empty($buffer)) {
    print '<a href="http://www.e-solat.gov.my/">Prayer Time</a>';
} else {
    $waktu_s = array('imsak', 'subuh', 'syuruk', 'zohor', 'asar', 'maghrib', 'isyak');
    $w = array();
    foreach ($waktu_s as $waktu) {
        $w[] = "<tr.*?>.*?<td.*?>.*?$waktu.*?<\/td>.*?<td.*?>.*?(?P<
$waktu>\d?\d:\d\d).*?<\/td>.*?<\/tr>";
    }
    $t = join(".*?", $w);
    $regex = "/<table.*?>.*?$t.*?<\/table>/si";
    $result = "";
    if (preg_match($regex, $buffer, $matches)) {
        $result = '<table border="1"><caption>Kuala Lumpur</caption>';
        $result .= '<thead><tr>';
        foreach ($waktu_s as $waktu) {
            $result .= "<th>".ucfirst($waktu)."</th>";
        }
        $result .= '</tr></thead>';
        $result .= '<tbody><tr>';
        foreach ($waktu_s as $waktu) {
            $result .= "<td>".$matches[$waktu]."</td>";
        }
        $result .= '</tr></tbody>';
        $result .= '</table>';
    }
    print $result;
}

?>

Example of output as below:

Kuala Lumpur
Imsak	Subuh	Syuruk	Zohor	Asar	Maghrib	Isyak
5:29	5:39	6:58	13:00	16:19	18:58	20:09

I'll leave to you as exercise to show the date of prayer times, GMT and qiblat direction.