Flickr Photostream

Lets have a look  at my Flickr photostream. I’m in the beginner level of photography: http://www.flickr.com/photos/kiri-wt/

Harley: Riemen gerissen

Auf der B34 zwischen Laufenburg und Luttingen ist mir der Riemen gerissen am Töff. Gott seid Dank konnte ich zur ehemaligen Kulturfabrik runterrollen, den Bock abstellen und abends dann via Auto+Anhänger die HD abholen … KM-Stand 30.400

Neuer Job in Zürich: Unic AG

 Seit 1.11.2011 arbeite ich bei der Unic AG als Applikation Architect. Der absolute Traumjob. Meine Hauptaufgabe ist die Programmierung und Erstellung von Typo3 Extension mit Hilfe von Extbase und Fluid. Das bedeutet, dass ich wohl bald dieses Blog umstelle auf Typo3.

Die Unic sucht ständig neue Mitarbeiter, schaut doch mal hier: Offene Stellen, bezieht euch bei der Bewerbung auf mich

PHP new configuration

./configure --prefix=/usr/local/php6 --with-apxs2=/usr/local/httpd/bin/apxs --disable-cli --disable-cgi --with-config-file-path=/etc/php6 --disable-ipv6 --disable-short-tags --with-openssl=/usr --with-pcre-regex --with-zlib --enable-bcmath --with-bz2 --enable-calendar --with-curl --with-libxml-dir --enable-exif --enable-filter --enable-ftp --with-openssl-dir=/usr --with-gd --with-png-dir=/usr/local --with-jpeg-dir=/usr --with-freetype-dir=/usr/local --enable-gd-native-ttf --with-gettext --with-mhash --enable-intl --with-mcrypt --with-mssql=/usr/local --with-mysql=/usr/bin/mysql_config --with-zlib-dir=/usr --with-mysqli=mysqlnd --with-pdo-dblib --with-pdo-mysql=mysqlnd --with-mm --enable-shmop --with-libxml-dir=/usr --enable-soap --with-libxml-dir=/usr --enable-sqlite-utf8 --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-wddx --with-xsl=/usr/local --enable-zip --with-pear --enable-static --with-iconv --enable-dbase --enable-pcntl --with-pdo_sqlite --with-pspell --enable-sockets --with-icu-dir=/usr/local --with-libmemcached-dir=/usr/local && make

Installed: http://memcached.org/ on FreeBSD and the Debian Box and installed http://libmemcached.org/libMemcached.html only on the FreeBSD Box

http://www.lullabot.com/articles/how-install-memcache-debian-etch

With this compilation PHP-trunk results in a segmentation fault when calling a phpinfo() script from a browser….

Now I’m trying it with php5.3-dev … works

Figured out that you have to install memcache for typo3 and not memcached ;-(

Uncaught TYPO3 Exception Class does not exist
ReflectionException thrown in file ....typo3_src-4.4.4/t3lib/class.t3lib_div.php in line 5250.

Damn it! –> http://bugs.typo3.org/view.php?id=15923

Ok, now it works

Schweizer Rocksänger stirbt nach Unfall mit Harley

Schock! Steve Lee von der Schweizer Band Gotthard ist bei einem dramatischen Unfall ums Leben gekommen! Ich selber bin noch vor eineinhalb Wochen dort hergefahren! Von Regen keine Spur …

http://www.spiegel.de/panorama/leute/0,1518,721658,00.html

In tiefer Trauer Hier kann man sich in das Kondolenzbuch eintragen:

http://www.stevelee.ch

http://www.gotthard.com

FaceBook uses incorrect SSL Certificate for its domain: “GTE CyberTrust Global Root”

Accessing https://www.facebook.com/ results in a SSL error: This Connection is Untrusted.

Issuer of the Cert:
CN = GTE CyberTrust Global Root
OU = “GTE CyberTrust Solutions, Inc.”
O = GTE Corporation
C = US

Go fix it! I have to remove a friend ….

[update]: Now 09/23/2010 at 1:15pm I’m getting this error:
Service Unavailable - DNS failure
The server is temporarily unable to service your request. Please try again later.

Has Facebook been hacked?

PHP6 trunk installation on FreeBSD 8.1

On http://snaps.php.net/ you can already download the really latest dev version of php. So I decided to use the PHP 5.3.99-dev aka PHP6.

The installation as Apache modules works this way:

./configure --prefix=/usr/local/php6 --with-apxs2=/usr/local/httpd/bin/apxs --disable-cli --disable-cgi --with-config-file-path=/etc/php6 --disable-ipv6 --disable-short-tags --with-openssl=/usr --with-pcre-regex --with-zlib --enable-bcmath --with-bz2 --enable-calendar --with-curl --with-libxml-dir --enable-exif --disable-filter --enable-ftp --with-openssl-dir=/usr --with-gd --with-png-dir=/usr --with-jpeg-dir=/usr --with-freetype-dir=/usr/local --enable-gd-native-ttf --with-gettext --with-mhash --enable-intl --with-mcrypt --with-mssql=/usr/local --with-mysql --with-zlib-dir=/usr --with-mysqli --with-pdo-dblib --with-pdo-mysql --with-mm --enable-shmop --with-libxml-dir=/usr --enable-soap --with-libxml-dir=/usr --enable-sqlite-utf8 --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-wddx --with-xmlrpc=/usr/local --with-xsl=/usr/local --enable-zip --with-pear --enable-maintainer-zts --with-tsrm-pthreads --enable-static --with-icu-dir=/usr/local

Make sure you have installed ICU (http://site.icu-project.org/) or (/usr/ports/devel/icu4) or otherwise you’ll get this error:

“configure: error: Unable to detect ICU prefix or no failed. Please verify ICU install prefix and make sure icu-config works.”

libmm also needed: http://www.ossp.org/pkg/lib/mm/

Now running “make” and result:

In file included from /home/sources/php-trunk-201009180230/ext/mysqli/php_mysqli_structs.h:63,
from /home/sources/php-trunk-201009180230/ext/mysqli/mysqli.c:33:
/usr/local/include/mysql/my_global.h:626:25: error: my_compiler.h: No such file or directory
In file included from /home/sources/php-trunk-201009180230/ext/mysqli/mysqli.c:34:
/home/sources/php-trunk-201009180230/ext/mysqli/mysqli_priv.h:312:27: warning: no newline at end of file
*** Error code 1

My installed mysql version in /usr/local: mysql-5.1.50
Seems to be a very new bug, need to update mysql. Getting Snapshot from http://labs.mysql.com/ the source file: mysql-5.1.52-snapshot20100914.tar.gz

Remember I have the mysql server in the Debian box and need here just the client:
./configure --prefix=/usr/local --enable-shared --enable-static --enable-assembler --with-zlib-dir=/usr --without-debug --with-ssl=/usr --without-docs --without-server && make && make install


Now running configure and make on PHP again:
./configure --prefix=/usr/local/php6 --with-apxs2=/usr/local/httpd/bin/apxs --disable-cli --disable-cgi --with-config-file-path=/etc/php6 --disable-ipv6 --disable-short-tags --with-openssl=/usr --with-pcre-regex --with-zlib --enable-bcmath --with-bz2 --enable-calendar --with-curl --with-libxml-dir --enable-exif --disable-filter --enable-ftp --with-openssl-dir=/usr --with-gd --with-png-dir=/usr --with-jpeg-dir=/usr --with-freetype-dir=/usr/local --enable-gd-native-ttf --with-gettext --with-mhash --enable-intl --with-mcrypt --with-mssql=/usr/local --with-mysql=/usr/bin/mysql_config --with-zlib-dir=/usr --with-mysqli=mysqlnd --with-pdo-dblib --with-pdo-mysql=mysqlnd --with-mm --enable-shmop --with-libxml-dir=/usr --enable-soap --with-libxml-dir=/usr --enable-sqlite-utf8 --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-wddx --with-xmlrpc=/usr/local --with-xsl=/usr/local --enable-zip --with-pear --enable-maintainer-zts --with-tsrm-pthreads --enable-static --with-icu-dir=/usr/local

Result:

/home/sources/php-trunk-201009180230/ext/session/mod_mm.c:37:3: error: #error mm is not thread-safe
*** Error code 1

Ok, recompiling Apache: http://php.net/manual/en/install.unix.apache2.php this may take a while …

This is Apache 2.2 configure:

./configure --prefix=/usr/local/httpd --with-z=/usr --with-ssl=/usr --enable-ssl --enable-rewrite=shared --disable-userdir --enable-vhost-alias=shared --enable-dir=shared --enable-http --enable-static-ab --enable-authn-dbd=shared --datadir=/home/www --with-included-apr --enable-autoindex=shared --disable-include --enable-deflate=shared --enable-info=shared --enable-log-config --with-mpm=prefork --enable-so

and removed –enable-maintainer-zts –with-tsrm-pthreads from PHP configure.

Result:

/usr/bin/ld: cannot find -lxmlrpc
*** Error code 1
Ok, reinstallation of libiconv, expat and libxml … *arg*

../src/.libs/libxmlrpc-epi.so: undefined reference to `libiconv_open'
../src/.libs/libxmlrpc-epi.so: undefined reference to `libiconv_close'
../src/.libs/libxmlrpc-epi.so: undefined reference to `libiconv'
*** Error code 1

Stop in /home/sources/xmlrpc/sample.
*** Error code 1

Won’t work … I have to remove xmlrpc and figure out why this error happen…. I’ve read something of reinstallation of glibc … that’s strange.
Build complete.
Don't forget to run 'make test'. (Only when compiled with cli/cgi)


Installed and integrated php into Apache.

Here we are:

Final PHP6 configure command:
./configure --prefix=/usr/local/php6 --with-apxs2=/usr/local/httpd/bin/apxs --disable-cli --disable-cgi --with-config-file-path=/etc/php6 --disable-ipv6 --disable-short-tags --with-openssl=/usr --with-pcre-regex --with-zlib --enable-bcmath --with-bz2 --enable-calendar --with-curl --with-libxml-dir --enable-exif --disable-filter --enable-ftp --with-openssl-dir=/usr --with-gd --with-png-dir=/usr --with-jpeg-dir=/usr --with-freetype-dir=/usr/local --enable-gd-native-ttf --with-gettext --with-mhash --enable-intl --with-mcrypt --with-mssql=/usr/local --with-mysql=/usr/bin/mysql_config --with-zlib-dir=/usr --with-mysqli=mysqlnd --with-pdo-dblib --with-pdo-mysql=mysqlnd --with-mm --enable-shmop --with-libxml-dir=/usr --enable-soap --with-libxml-dir=/usr --enable-sqlite-utf8 --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-wddx --with-xsl=/usr/local --enable-zip --with-pear --enable-static --with-iconv --enable-dbase --enable-pcntl --with-pdo_sqlite --with-pspell --enable-sockets --with-icu-dir=/usr/local && make

Apache/2.2.16 (Unix) PHP/5.3.99-dev mod_ssl/2.2.16 OpenSSL/1.0.0a

Install Apache httpd on FreeBSD

Download the Apache httpd-2.2.16 Source from this site.


./configure --prefix=/usr/local/httpd --with-z=/usr --with-ssl=/usr --enable-ssl --enable-rewrite=shared --disable-userdir --enable-vhost-alias=shared --enable-dir=shared --enable-http --enable-static-ab --enable-authn-dbd=shared --datadir=/home/www --with-included-apr --enable-autoindex=shared --disable-include --enable-deflate=shared --enable-info=shared --enable-log-config --with-mpm=worker

Using the worker MPM everyting that you install for apache has to be thread safe.
–enable-info and –enable-autoindex has to be set to –disable-info and –disable-autoindex in a production environment.

When I compile / configure PHP and want to get it running with the worker MPM, you have to –enable-experimental-zts Zend Thread Safety libraries.

How to create a Certificate with openssl:
Choose here a strong password:
# openssl genrsa -des3 -out server.key 1024
Now we make the Certificate Signing Request (CSR) from generated key:
In the section “Common Name” enter here your Fully Qualified Domain Name (FQDN), like www.example456676.net
# openssl req -new -key server.key -out server.csr
The certificate is ready to be signed. We self-sign now the certificate, but you could pay money and have it signed by Verisign or Thawte.
# openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt
For apache2 we need the correct chmod
# chmod 0400 server.*

Disable password at startup
openssl rsa -in server.key -out server.key.nopass

TBC

Ordered a SEO and the Marketing Book at Amazon

“Marketing Metrics: The Definitive Guide to Measuring Marketing Performance (2nd Edition)”
Paul W. Farris; Hardcover; Amazon Website

“Search Engine Optimization: Your visual blueprint for effective Internet marketing”
Kristopher B. Jones; Paperback; Amazon Website

MySQL Reinstallation on Debian with Sphinx Storage

I’ve decided to install MySQL Server on the Debian System. MySQL with SSL. Porpose: Just to see MySQL with SSL working. Connection will be done from the FreeBSD System. I also installed the Sphinx storage engine which provides fulltext search

This is the new MySQL configure:

export CHOST="x86_64-pc-linux-gnu"
export CFLAGS="-march=k8 -O3 -pipe -mno-tls-direct-seg-refs -fomit-frame-pointer -fno-exceptions"
export CXXFLAGS="${CFLAGS} -felide-constructors -fno-rtti"

tar xzf sphinx-1.10-beta.tar.gz
debsql:/home/sources/mysql-5.1.50# cp -ra ../sphinx-*/mysqlse storage/sphinx
debsql:# apt-get install automake
debsql:# apt-get install libtool
# autorun.sh is important to be executed otherwise configure won't recognize the sphinx engine
debsql:# /home/sources/mysql-5.1.50/BUILD/autorun.sh

./configure --prefix=/sql --localstatedir=/sql/data --build=x86_64-pc-linux-gnu --enable-shared --enable-assembler --with-mysqld-user=mysql --with-server-suffix=VBoxKiri --with-zlib-dir=/usr --without-debug --with-plugins=myisam,myisammrg,blackhole,heap,innobase --without-docs --with-unix-socket-path=/tmp/mysql.sock --disable-local-infile --with-ssl=/usr --with-big-tables --with-tcp-port=63306 --with-machine-type --with-system-type --with-atomic-ops=smp --with-pic --with-readline --with-charset=utf8 --with-extra-charsets=utf8,latin1,ascii && make && make install

Sphinx 1.10-beta and Sphinx 0.9.9 gives me strange and very very weird compilation errors due to openssl
After removing the ssl switch from configure the compilation and installation works fine.
But SSL is more important for me. So I remove sphinx and build it the normal way as they suggest on their website.

I wonder how –with-atomic-ops=smp will work because this means that atomic operations are calculated on two or more processor: SMP.

my.cnf looks now like this:


[mysqld]
port = 63306
socket = /tmp/mysql.sock
tmpdir = /sql/tmp
skip-external-locking
key_buffer_size = 512M
max_allowed_packet = 2M
table_open_cache = 256
sort_buffer_size = 16M
net_buffer_length = 32K
read_buffer_size = 2M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 16M
default-storage-engine=innodb
collation_server=utf8_unicode_ci
character_set_server=utf8
skip-character-set-client-handshake
# Point the following paths to different dedicated disks
tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /sql/data/
innodb_data_file_path = ibdata1:100M:autoextend
innodb_log_group_home_dir = /sql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 4M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 256M
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
...
...
...

That’s it.