A new version of the Article Button plugin for Joomla 2.5 can be found here.

IT-Blog

Empty calendar in Icedove/Thunderbird

I use Icedove (Thunderbird) since years, and think it's really a good piece of software, in my opinion it's much better than Outlook, I was using for several years too. After splitting up my data into "OS" and "real data", I also moved the .icedove folder from my home directory by symlink to my data-harddisk. Mails worked fine, but lightning would display any evens, you also could not even create any new calendar, events. After I while I saw the following error in the error-console:

Error: Components.classes['@mozilla.org/calendar/datetime;1'] is undefined
Source File: chrome://calendar/content/calUtils.js
Line: 78 
Solutioin: my data-harddisk was mounted by fstab with rw/user (for whatever reason I did this once...), I changed it to defaults what is equal to "rw,suid,dev,exec,auto,nouser,async on my current Debian Wheezy. After rebooting, everything works fine. I really would appreciate if anybody can explain me why this was the solution to my problem.

Gnome extension work for Debian Wheezy

Finally it seems to be possible to use the gnome-extension-site with Debian Wheezy. I gave some a try and it's incredible how you can enrich and customize your desktop environment for your personal taste. I begin to love Gnome 3 more every day I work with it!

Printer problems in Gnome

I setup my Laptop with Gnome3 and was suprised that the printer was not automatically added, I know for sure that it was added automatically with earlier version... Guess that has nothing to do with gnome itself, sometimes there is some other kind of trouble. My Printer is a old multi-functional Canon (scan/print/fax) MP780 the scanning with simplescan (standard program from Gnome3) works pretty well. If you look for drivers in the Inet, there is just commercial software, like Turboprint. I tried it but had some issues after a while, and don't really want a kind os software suite just for printing... I looked further and noticed that there are free drivers called gutenprint, already available in Debian. Basically the steps you need to configure the printer were

 apt-get install cups cups-driver-gutenprint
  • go to configuration page (local on port 631) http://localhost:631
  • choose option from “Adding Printers and Classes”

preseeding in Debian wheezy

I have two servers with KVM running, on both I use preseeding to install the guests. It's amazing to watch a guest install automatically by using virt-install and passing some parameters on command line. Basically you need to pass further preseeding parameters in a file. When converting this script to wheezy I ran into a problem. In squeeze, the parameter that defines the disk was named vda (why vda??? however) in wheezy its sda now (more like its in every debian install). Means I had to change the config parameter from

d-i partman-auto/disk string /dev/vda
to
d-i partman-auto/disk string /dev/sda

build thunderbird 7.x on Debian wheezy

Still not finished with my Gnome-Desktop, what I can say that there are some great features that I really missed on Windows for years, however I want to use my Thunderbird and Windows parallel and decided to use dual-boot with the same thunderbird-profile-directory. Wheezy still has a 3.x icedove (=thunderbird) client, and my Windows installation already has a 7.0.1, so I needed a new client, and could not find any distribution out there. Means I was forced to build it by myself. There were two guides that helped my with that topic the one was from Mozilla, the other one for an Ubuntu-build. Here is my step-by-step guide:

get sourcecode

get sourcecode from mozilla, in this case for building 7.0.1

wget ftp://ftp.mozilla.org/pub/mozilla.org/thunderbird/releases/7.0.1/source/thunderbird-7.0.1.source.tar.bz2

unpack file

tar -vxfj thunderbird-7.0.1.source.tar.bz2

change to direcotry

cd comm-releases

get build-backages

apt-get install build-essential libasound2-dev libcurl4-openssl-dev libnotify-dev libxt-dev libiw-dev mesa-common-dev autoconf2.13 yasm

and dependencies from the icedove (debian version of thunderbird) package

apt-get build-dep icedove

create .mozconfig file

This file controls what is built and is specific for the mozilla project. In the first line I let the build put the new files in a new directory “thunderbird-7.0.1”

mk_add_options MOZ_OBJDIR=@TOPSRCDIR@/thunderbird-7.0.1
ac_add_options --enable-application=mail
mk_add_options MOZ_CO_PROJECT=mail
ac_add_options --enable-optimize
ac_add_options --enable-calendar
ac_add_options --disable-crashreporter

Here I disabled the crashreporter, because you run into a problem with deprecated headers on wheezy, a known bug of the mozilla build.

workaround for bug with 3.0 kernel

A workaround for another open bug with the mozilla build, on 3.0 kernels, just needed if you really are on a 3.0 kernel.

cd mozilla/security/coreconf
cp Linux2.6.mk Linux3.0.mk

start the build

make -f client.mk

after the build finished change to the build-directory

cd thunderbird-7.0.1

create the deb-package

make -j4

there is already a metapackage “thunderbird” on debian so we need to give it another name checkinstall also asks you for some stuff for naming and describing the package

checkinstall -D --install=no --pkgname=´thunderbird-fairtec´ --pkgversion=´7.0.1´

install the package

dpkg -i thunderbird-fairtec_7.0.1-1_amd64.deb
!If there is interest in the pre-built file, let me know, I will take a look if we can find a suitable hosting solution for that!

Enable Sound on Debian Wheezy for Dell Latitude 6500

Last week I setup dual boot on my Laptop for giving Gnome on Debian a try. Worked without any problems, except the sound, the driver was installed correctly, but still had no sound. After reading loads of docs I found the hint of using the Realtek Code-Software here. Here step-by-step what I needed to make it working:

get_build_packages

apt-get install linux-source linux-headers-3.0.0-1-all-amd64 build-essential

get file from realtek - choose your kernel

become root

su root

uncompress file (example!)

tar -vxjf LinuxPkg_5.17Beta.tar.bz2

change to new dir (example!)

cd realtek-linux-audiopack-5.17

do the installation and reboot

./install
reboot


RMAN-06026 and RMAN-06023 when restoring

Today I tried to restore a full backup of an old DB to a new database with

RESTORE DATABASE FROM TAG = 'LASTDEV'
what resulted in
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
After looking for the solution for hours I found out that there is a 5-year!!! old bug open that makes it impossible for RMAN to restore a backuppiece if it's read-only.
The BUG# is "5412531 - RMAN FAILS RESTORING READONLY BACKUPS: ORA-19870 ORA-19587 ORA-27091 ORA-27067"

history for SQL/PLUS and RMAN

I am using sqlplus and rman on linux a lot, and one very annoying thing is that there is no history (key-up) as it is on windows. Reason is that in sqlplus/rman is running in a dosbox and the dosbox has the "key-up-history" feature implemented automatically.

But also in Linux it's easy to achieve. The tool you need is "rlwrap". Just install it (example for Debian)

apt-get install rlwrap

and call sqlplus with "rlwrap sqlplus" or rman with "rlwrap rman".

Nothing more to make it run? No, nothing more!

Have fun!

UTL_MAIL with SMTP authentication

If you are using UTL_MAIL you will soon come to some limits of this package.

  •  it does not support SMTP authentication
  •  it does not support attachments (not provided here)

Last week I needed the authentication part for a project.
I decided to take something that's already stable ready to be used, and free.
It's Apache Commons Mail part. Basically these class makes handling in Java much easier than provided by SUN/ORACLE.
es, it's a Java-class. But Java is really easy to use in Oracle, you will see.

Basically you get the jar, say "loadjava myjar.jar", create a simple java-class in oracle, create a simple pl/sql wrapper.
This cooking recipe is on Linux, but except the unpacking it's almost the same on windows.
And don't forget to take the most current and stable jar-files!

get the mail.jar from here http://www.oracle.com/technetwork/java/javamail/index.html

get the commons-email-xxx.jar from here http://commons.apache.org/email/

unzip both in a directory on your database server and use following statements to load it into the database (REPLACE USER/PW!!!):

 

1
2
3
loadjava -u myuser/MYPW -resolve mail.jar
loadjava -u myuser/MYPW -resolve commons-email-xxx.jar
 

 

Now we need some Java and PL/SQL programming. I did the design so that it can be basically used instead of UTL_MAIL, means same parameter names and default-values.

Just some more parameters were added for using the authentication.
You can download the files from the download-sections here. Just install them with SQL/PLUS or whatever tool you like.

After compiling the programs into the databse give it a try. You need to set some permissions, so keep DBMS-Output enabled, in the output you find the statements that needs to be executed. It will look like similar to this:

1
2
3
dbms_java.grant_permission( 'yippie', 'SYS:java.lang.RuntimePermission', 'accessDeclaredMembers', '' );
dbms_java.grant_permission( 'XYA', 'SYS:java.util.PropertyPermission', '*', 'read,write' );
begin dbms_java.grant_permission( 'XYA', 'SYS:java.net.SocketPermission', '123...', 'connect,resolve' ); 

 

Ok for testing we need a testscript:

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
BEGIN

dbms_output.enable(10000);
dbms_java.set_output(1000000); std_mail.send(
sender => 'Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!',
recipients => 'Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!', subject => 'subjective', message => 'messagemessagemessage', smtphostname => 'mail.mytestdomain.com', smtpport => '587', smtpuser => 'myuser', smptpassword => 'mypw', useTls => false); END; /

That's it!

The programs here are released under the GNU/GPL2.

Have fun!

Feedback appreciated, please comment!

How to fix ORA-00600/ORA-07445

If you are running into a ORA-07445 or ORA-00600 error something you should fix immediately happened on your Database. You should do following things before opening a TAR on Metalink:

  • get the exact error-message including the things in the square brackets from the alert-log
  • logon to metalink and search for the document 153788.1 that's the Error-Lookup-Tool from Oracle for these errors and open that document
  • choose if it is a ORA-00600 or a ORA-07445 and enter the things in the first square brackets into the field "Error Code First Argument" and press "Lookup Error"

If you are lucky and find informations/patches (what pretty often happens -> good stuff Oracle) you can probably fix it by yourself. If not you have to open a Metalink-TAR.

clockworkmod "an error occured while downloading your recovery."

androidCurrently I reinstalled my Samsung Galaxy S (with insanity 6.3) and came across "an error occured while downloading your recovery." when trying to flash clockworkmod recovery. With installing a superuser version from the market and reinstalling clockworkmod my problem seems to be solved. There seems to be a bug in the superuser app I was using previously.

KVM - bad usb drive performance

kvm I recently installed a usb-harddisk on my server and mounted it on a guest with virt-manager. The performance was very bad, i had 50Kbyte when testing with hdparm.

I remounted it in virt-manager as IDE drive instead of USB-Drive and voila i had full performance again. It seems that the USB-drive mounting is a bit bugged.

Weitere Beiträge...

  1. KVM Kernel Based Virtual Machine vs. XEN
  2. Oracle 11g Installation on Debian Squeeze
  3. The type R is already defined
  4. HOWTO Sign Amazon Product API Requests
  5. Multiple Desktops in Windows 7
  6. java.security.AccessControlException: access denied
  7. FRM-13008 cannot find java bean
  8. SET_WINDOW_PROPERTY does not trigger WHEN-WINDOW-RESIZED
  9. subversion tortoisesvn with alternate ssh port
  10. developer suite 10g on vista and windows 7
  11. Securing the RBASH?
  12. sending bacula status mails with smtp authentication
  13. svnserve with slikSVN
  14. limit user rights - Jail Shell RBASH (Debian)
  15. limit user rights - Jail Shell RSSH (Debian)
  16. limit user rights - Jail Shell SFTP (Debian)
  17. limit user rights - Jail Shell SSH (Debian)
  18. Bacula "Network error with FD during Backup"
  19. port 9240 already in use
  20. XPlanner+ Permissions for security Manager
  21. XPlanner Plus
  22. Cannot configure CacheManager
  23. Tomcat on Debian
  24. Oracle Developer Patch 10.1.2.3
  25. Oracle Reports font subsetting
  26. Adding Fonts on Unix for Oracle Reports PDF
  27. Harddisk recovery tools free and not so free
  28. REP-1352 Font Issue
  29. Oracle Reports with barcode
  30. Enterprise-Manager + RMAN No RMAN found, Message file not found
  31. ORA-1017: invalid username/password when creating database link
  32. resolv.conf overwritten empty after reboot
  33. AmazonBestseller which products are cheap?
  34. 4gb seg fixup errors after upgrading from etch to lenny
  35. Oracle Bug ORA-07445: exception encountered
  36. C compiler cannot create executables.
  37. Oracle Java File permissions
  38. EM Manager "Compute dynamic property takes too long"
  39. where to download com_migrator
  40. PL/SQL Email-Validation
  41. Power Consumption of Dell Server
  42. Enterprise Manager and ORA-00018
  43. Io exception: The Network Adapter could ...
  44. Centos = Redhat Enterprise Linux
  45. Enterprise Manager notification not working
  46. the magic Oracle WITH-clause
  47. Error in invoking target - Oracle on Debian
  48. Oracle Installation on Debian for dummys II
  49. Oracle Installation on Debian for dummys I
  50. Oracle-Reports Asynchronous calls with SRW-API
  51. on-commit not working on materialized views
  52. using Materialized View
  53. How to determine the character-set in Oracle
  54. how to compile invalid sys-objects
  55. ORA-06553: PLS-320: the declaration of the type...
  56. Access Control with Context/Fine-Grained Access Control
  57. MDA Vario/Qtek 9100 Ersatzstift/Replacement Stylus
  58. Versioning of a table in Oracle
  59. datapump fails with ora-06502
  60. Where to find Opatch
  61. How to create a SPFILE from a PFILE
  62. How to use UTF8 in PDFs created by Oracle-Reports
  63. Oracle Failsafe and SPFILE
  64. phone-number check in constraint
  65. webutil wuc-024 (WUC-24)
  66. Failsafe ORA-00942 "View or Table does not exist" workaround
  67. direct access to the database without TNSNAME.ORA
  68. Failsafe ORA-00942 "View or Table does not exist"
  69. Connection to host failed. Bad SQL_SCRIPT at - line 227.
  70. Is Oracle Failsafe just for Databases?
  71. Do you know Oracle Failsafe???
  72. REP-56055: Exceed max connections allowed
  73. Troubles with OracleDataSource
  74. Enterprise Manager clone Database results in "insufficient disk space"
  75. How to distribute Oracle Reports Part II
  76. How to distribute Oracle Reports Part I
  77. No valid GPS-Signal on Acer N35
  78. How to use a terminal-file in webforms
  79. ORA-00257 ORA-16020 Archiver Stuck
  80. ORA-39002 ORA-39070 ORA-39087 with Datapump
  81. Installation Forms and Reports Service failed
  82. Simple Machine Forum
  83. Don't use timers in webforms - WHY NOT?
  84. The difference between PJC and Java Beans in Forms
  85. Forms and Reports Services Standalone
  86. ORA-00932: inconsistent datatypes
  87. Compare Database Performance
  88. Scott and Tiger
  89. Surprise Surprise Oracle Developer Suite 10gR2
  90. Working with Oracle Express Edition
  91. Oracle Express - an Oracle-Database that's for free