Installing Zend Server Ce

when trying to install zend server ce i got the following result:

sudo aptitude install zend-ce
The following NEW packages will be installed:
  apache2-mpm-prefork{a} apache2-utils{a} apache2.2-bin{a} apache2.2-common{a} libaio1{a}
  libapache2-mod-php5-zend-ce{a} libapr1{a} libaprutil1{a} libaprutil1-dbd-sqlite3{a}
  libaprutil1-ldap{a} libframework1-zend-ce{a} libicu36{a} libmcrypt4{a} libmhash2{a}
  liboci-zend{a} libpng3{a} libpq4{ab} libsqlite0{a} lighttpd-zend-ce{a}
  php-bcmath-zend-ce{a} php-bz2-zend-ce{a} php-calendar-zend-ce{a} php-ctype-zend-ce{a}
  php-curl-zend-ce{a} php-data-cache-zend-ce{a} php-debugger-zend-ce{a} php-dev-zend-ce{a}
  php-exif-zend-ce{a} php-fcgi-zend-ce{a} php-ftp-zend-ce{a} php-gd-zend-ce{a}
  php-gettext-zend-ce{a} php-imap-zend-ce{ab} php-intl-zend-ce{a} php-json-zend-ce{a}
  php-ldap-zend-ce{a} php-mbstring-zend-ce{a} php-mcrypt-zend-ce{a} php-mhash-zend-ce{a}
  php-mime-magic-zend-ce{a} php-mysql-zend-ce{ab} php-mysqli-zend-ce{ab}
  php-oci8-zend-ce{a} php-optimizer-plus-zend-ce{a} php-pdo-mysql-zend-ce{ab}
  php-pdo-oci-zend-ce{a} php-pdo-pgsql-zend-ce{a} php-pgsql-zend-ce{a} php-posix-zend-ce{a}
  php-soap-zend-ce{a} php-sockets-zend-ce{a} php-sqlite-zend-ce{a} php-tidy-zend-ce{a}
  php-tokenizer-zend-ce{a} php-xmlreader-zend-ce{a} php-xmlwriter-zend-ce{a}
  php-xsl-zend-ce{a} php-zem-zend-ce{a} php-zendutils-zend-ce{a} php-zip-zend-ce{a}
  php5-common-extensions-zend-ce{a} sqlite{a} zend-base-ce{a} zend-ce zend-ce-doc{a}
  zend-extensions-ce{a} zend-framework-ce{a} zend-gui-ce{a}
0 packages upgraded, 68 newly installed, 0 to remove and 9 not upgraded.
Need to get 55.1MB of archives. After unpacking 209MB will be used.
The following packages have unmet dependencies:
  php-pdo-mysql-zend-ce: Depends: libmysqlclient15off (>= 5.0.27-1) which is a virtual package.
  php-mysql-zend-ce: Depends: libmysqlclient15off (>= 5.0.27-1) which is a virtual package.
  libpq4: Depends: libkrb53 (>= 1.4.2) which is a virtual package.
  php-imap-zend-ce: Depends: libkrb53 (>= 1.4.2) which is a virtual package.
  php-mysqli-zend-ce: Depends: libmysqlclient15off (>= 5.0.27-1) which is a virtual package.
The following actions will resolve these dependencies:
     Keep the following packages at their current version:
1)     libpq4 [Not Installed]
2)     php-imap-zend-ce [Not Installed]
3)     php-mysql-zend-ce [Not Installed]
4)     php-mysqli-zend-ce [Not Installed]
5)     php-pdo-mysql-zend-ce [Not Installed]
6)     php-pdo-pgsql-zend-ce [Not Installed]
7)     php-pgsql-zend-ce [Not Installed]
8)     php5-common-extensions-zend-ce [Not Installed]
9)     zend-ce [Not Installed]                            
Accept this solution? [Y/n/q/?] q
Abandoning all efforts to resolve these dependencies.

meaning that the packages libmysqlclient15off and libkrb53 where missing …
finding the solutions on the web ( and i had to do the following to make zend server ce install:

get the specific package and install libmysqlclient15off manually

sudo dpkg -i libmysqlclient15off_5.1.30really5.0.83-0ubuntu3_amd64.deb

install equivs for later usage

sudo aptitude install equivs

create a file named libkrb53_fake.txt and enter the following in the txt-file

Package: libkrb53
Version: 1.6.dfsg.2+fake1
Depends: libkrb5-3, libgssapi-krb5-2, libk5crypto3, libkrb5support0

then build the package with equivs and install it

sudo equivs-build libkrb53_fake.txt
sudo dpkg -i libkrb53_1.6.dfsg.2+fake1_all.deb

after that the zend server could be installed successfully

sudo aptitude install zend-c

Change The Clock Date Applet In The Taskbar To Show A Custom Format

i did not like the default date time format

to make it more readable like so

i enabled all options in the general tab of the clocks preferences

started up gnome configuration editor by running


there navigated to


and changed the key format to


and entered the following into the key custom_format

%Y-%m-%d %H:%M:%S

Trackpoint Horizontal And Vertical Scrolling

first thing after installation was getting the trackpoint scroll button working
therefore created the file .xsessionrc in the home-directory with the following content

xinput set-int-prop "TPPS/2 IBM TrackPoint" "Evdev Wheel Emulation" 8 1
xinput set-int-prop "TPPS/2 IBM TrackPoint" "Evdev Wheel Emulation Button" 8 2
xinput set-int-prop "TPPS/2 IBM TrackPoint" "Evdev Wheel Emulation Timeout" 8 200
xinput set-int-prop "TPPS/2 IBM TrackPoint" "Evdev Wheel Emulation Axes" 8 6 7 4 5
xinput set-int-prop "TPPS/2 IBM TrackPoint" "Evdev Middle Button Emulation" 8 1
xinput set-int-prop "TPPS/2 IBM TrackPoint" "Evdev Middle Button Timeout" 8 50

after logging off and on again the trackpoint scolling works …