Issue:
Using unix variables in an Oracle sql script with sqlplus.

Solution:
Use the following parameters to pass the sql to sqlplus:
$SQLDIR/sqlplus -silent $USER/$PASSWORD $SCRIPTNAME.sql PARAM

Important is the @ before the $SCRIPTNAME. The last parameter PARAM can be used in sqlplus with &INT where INT is the number of the parameter (in this case 1=> &1).
Also important is the SQL which you parse into sqlplus in this case: Put a quit on the last line to prevent sqlplus from not exiting in batchmode, for example if it is run from the cron deamon.


  |  permalink  |  

---

Issue:
Oracle SQL Developer and other graphic userinterfaces use database properties to determine how to update or delete a row in a database. This can lead to mystery record locks which can not be traces.
No lock can be found in V$LOCK, no abnormal sessions can be found in V$SESSION.
Typical oracle where statement looks like:
WHERE ROWID = 'ABCDE+ABCDEFGHIJKL' AND ORA_ROWSCN = '123456'

Solution:
Type your own update statement instead of the SQL Developer generated one, and see if that works. If so, it is a problem with SQL Developer, else search on.

  |  permalink  |  

---

Issue

The SET ECHO OFF command in sqlplus does not produce the required result. In other words: You are still seeing SQL code in your logfiles or spoolfiles.

Solution

There is a sqlplus parameter which is also of influence. This parameter is: silent. If you call sqlplus with -silent, the SQL code will not show anymore.
  |  permalink  |  

---

Issue:

There is a possibitiy that at least the pathway module replaces an & to many with &.

Solution:

The ampReplace function in the includes/mambo.php does not take single & with spaces around it in account. To counter that, add a str_replace for this single &:
function ...
$text = str_replace( '& ', '*--*', $text );
...
$text = str_replace( '*--*', '& ', $text );
...

Leading to the total function as displayed below:

/**
* Replaces & with & for xhtml compliance
*
* Needed to handle unicode conflicts due to unicode conflicts
*/
function ampReplace( $text ) {
$text = str_replace( '& ', '*--*', $text );
$text = str_replace( '&#', '*-*', $text );
$text = str_replace( '&', '&', $text );
$text = str_replace( '*-*', '&#', $text );
$text = str_replace( '*--*', '& ', $text );

return $text;
}

  |  permalink  |  

---

The issue

Printing and exporting a diagram from dia 0.94 under SuSE 10 results in diagrams where some of the fonts are smaller than they should be.

The solution

This bug is a bug in dia 0.94. Update to dia 0.95 should do the trick to solve this problem.

Dia for windows (the 0.95 version tested) has some new issues with the font, causing diagrams to fall apart if you are nog carefull.
The simple solution there is, to save the file with dia 0.94 as uncompressed dia file. Edit that file with vi or notepad to change the font size of all 0.8 size fonts to 0.6, 1.0 to 0.8, and probably a bit more depending on your diagram. After that you can open the file in dia 0.95 with very little compatibility issues.

P.S. First preview your file in 0.95. It is possible that this is a Microsoft Windows issue.
  |  permalink  |  

---

The issue

KMail has a range of options to insert old e-mail from other applications, but none for its own e-mail. This piece explains how to import KMail e-mails into KMail.

KMail is able to handle to mail storage types:
- maildir
- mbox
Maildir is the standard selection, and the one which is missed in the import filters of KMail.
The filter of KMail for some reason excludes its own e-mails from the import. This can be solved by renaming the e-mails to the same name but then with a .txt extention.

Rename script
This script renames the files to a .txt extention. Run this in your KMail maildir folder:

#!/bin/bash
files=$(ls -1)
for x in $files
do
mv $x $x.txt
done

The steps to import the e-mail:

The import functionalities can be found under tools, import messages. Since maildir are plain text messages, you want to use the import plain text e-mails option.
The next step is to select the folder where you stored the backup of your KMail. Every folder has 3 sub folders:
- cur
- new
- tmp
The last step is to press next.
The result is that the e-mails are loaded into the folder PLAIN-cur.


  |  permalink  |  

---

USB devices tend to be extremely slow under SuSE 10 due to syncing the disk after every write. The USB driver can be told not to do this, resulting in a faster response from your USB devices.

According to /usr/share/doc/release-notes/RELEASE-NOTES.en.rtf you can mount hot plug devices without sync.

Create a file under /usr/share/hal/fdi/policy/20thirdparty with the name: 90-storage-nosync.fdi
Put the following contents in the file:

<?xml version="1.0" encoding="ISO-8859-1"?>
<deviceinfo version="0.2">
<device>
<!-- disable sync for mount -->
<match key="block.is_volume" bool="true">
<match key="volume.fsusage" string="filesystem">
<match key="@info.parent:storage.bus" string="usb">
<merge key="volume.policy.mount_option.sync" type="bool">false</merge>
</match>
</match>
</match>
</device>
</deviceinfo>

One reminder: The data will not be synchronized anymore, so umount before unplugging the device!
  |  permalink  |  

---

The sis900 ethernet controller is full GPL and in wide use. The issue was setting a media type on a 10Mbit network full duplex, where autonegotiation came back with half duplex.
By turning off the auto-negotiation, the duplex modes stays, else it will not be set.

To set full duplex, use the ethtool with the following settings:
ethtool -s eth0 speed 10 duplex full autoneg off

Querying the interface with ethtool eth0 gives:
Settings for eth0:
Supported ports: [ TP MII ]
Supported link modes: 10baseT/Half 10baseT/Full
100baseT/Half 100baseT/Full
Supports auto-negotiation: Yes
Advertised link modes: 10baseT/Half 10baseT/Full
100baseT/Half 100baseT/Full
Advertised auto-negotiation: Yes
Speed: 10Mb/s
Duplex: Half
Port: MII
PHYAD: 1
Transceiver: internal
Auto-negotiation: on
Current message level: 0x000000c5 (197)
Link detected: yes


  |  permalink  |  

---

Introduction

The LaCie ethernet disk mini 300GB is a linux based device. The early versions of this device with firmware lower than firmware 2.0, are not capable of handling more than one share, which with a networked device is far from optimal. To be able to handle more than one share, this manual has been written. Lacie was also contacted by a Lacie user about this issue, and he also got a response saying that they were already addressing the issue in firmware 2.0. By downloading the firmware, you can add your shares the easy way. If you want to do more, you can use this article to know ahead what you will run into hacking your lacie drive.


Linux based, so what about GPL

Sources can be downloaded from the LaCie website. They use a kernel tailored to there own, and several applications, among which samba and busybox.

Where is the configuration stored

Lacie stores the configuration on the device its harddisk. This makes the task at hand a lot easier. To start with, the partitions can be backupped up easily so in case of trouble they can be restored.
The main system boots from the extended partition in the ethernet disk:
fdisk output:
/dev/hda5 82 Linux swap / Solaris
/dev/hda6 83 Linux // probably /boot, contains the kernel
/dev/hda7 83 Linux // busybox & other applications, also a /etc with basic settings, overridden by /dev/hda8
/dev/hda8 83 Linux // The settings the system uses

The changes

At this moment all what is needed is to edit /etc/samba/smb.conf to an acceptable multiple shares layout. It is handy when you already made the users by using the webinterface, so you only have to address the shares itself. The samba config directs to /home for the standard share. You could keep that for yourself, and add subdirectories in /home (once mounted) to use with samba.

How to apply the changes

Disassemble the ethernetdisk mini by unscrewing the two screws at the back (voids your 2 year warranty!!). Take out the disk and mount it in your pc running linux.
Make backups from /dev/hdX6,7 & 8 with dd.
Mount /dev/hdX8 and edit the smb.conf file to your liking.
Shutdown, reassemble the ethernet disk and start it.
Do not use ethernetdisk mini configurationtools anymore. They will overwrite your new config!

Just a handy change

Since you do not want to disassemble your PC and lacie every time you want to change something, it might be handy to included /dev/hda7 & 8 in your samba configuration file with special permissions. This way you can update the smaba configuration with a text editor and the new config will than be available after reboot.

Further research for adding more features

The CPU in the lacie is a Freescale MPC5200. Some programs need to be compiled for this CPU, based on powerPC architecture, see "Work to be done".

Work to be done

- Add telnet or ssh (preferred ssh), possibly by just downloading a powerPC distro (for example yellow dog linux), and copy the libraries & programs to the lacie.
- Discover what username/password storage is used to have the shared login
- Maybe update the userinterface.
- Maybe put a little bit of pressure on lacie to update their software to accomodate multiple shares, add telnet, and tell which processor architecture is used so nice additions can be made.
(Help is welcome, answers will be posted here ASAP)
  |  permalink  |  

---

Symptom

The javamail implementation you are using, is giving the following exception:
javax.mail.SendFailedException: Sending failed;
nested exception is:
class javax.mail.MessagingException: 501 Syntax: HELO hostname

This error is slightly vague in origin, since java api descriptions fail to list most common exception causes. In this case it is the mail server responding on a single HELO command without a hostname. Since it wants to have a hostname, however fake it can be, it responds with 501 Syntax: HELO hostname. JavaMail just echos that response in the exception.

Solution

Send the hostname in the HELO command. Usually when you set up a common javamail, the InitialContext & session contain the necessary properties. Apperently the property mail.smtp.localhost is not set. To see the current properties, get the properties of the session: java.util.Properties props=session.getProperties(); and print them: System.out.println("my properties: "+props.toString());
You will see that the key mail.smtp.localhost is missing.
The correct solution to solve this, is to update the resource parameters of your mail/Session, for example in tomcat's server.xml:

<Resource name="mail/Session" auth="Container" type="javax.mail.Session"/>
<ResourceParams name="mail/Session">
<parameter>
<name>mail.hipersonik.com</name>
<value>localhost</value>
</parameter>
<parameter>
<name>mail.smtp.localhost</name>
<value>localhost</value>
</parameter>
</ResourceParams>

An alternative solution for when the previous solution is not available to you:
Add the key with the following code:
Properties props=session.getProperties();
String key= "mail.smtp.localhost";
String prop= props.getProperty(key);
if (prop== null) props.put(key, "localhost");
This way sending by using the localhost is possible. It also works for other hosts, so you can select any mailserver you want (as long as you are allowed to use it).


  |  permalink  |  related link  |  

---

Symptom

While using java 1.5, the following is allowed:
Integer number1=1;
Integer number2=1;

if(number1==number2) System.out.println("number1 is number2");
else System.out.println("number1 is not number2");

This fails.

Solution

It is not allowed in the java standard to compare two objects. You are actually comparing the object identifiers instead of the object values. Use the intValue or the compareTo methods to do the correct comparisson.
  |  permalink  |  

---

Sometimes there are multiple jobs to be killed. This bash script is handy for that purpose:
TOBEKILLED=your unique identifying name of the program
for PROCESS in `ps aux | grep $TOBEKILLED | grep -v grep | awk '{print $2}'`
do
kill -9 $PROCESS
done
  |  permalink  |  

---

Symptom

There are several exceptions in the style of "key not found exception" while there are references to the message resource file in the struts-config.xml or web.xml from tomcat.

Solution

The advice is to use the struts-config file only setup and not to include the message resource as an init parameter in the web.xml file.
To include the message resource files put the following in the struts-config.xml:
<message-resources
null="false"
parameter="your.preferred.package.ApplicationResources" />
The file in this should be named: ApplicationResources.properties, or with the language extention to it: ApplicationResources_es.properties.
The resource file has to be included in your build by adjusting ant or any other tool you are using.

  |  permalink  |  

---

The memory expansion of an asus notebook of the a2 series (a2500H) is not in the compartment on the bottom of the laptop which they mention in the manual. It is actually under the keyboard of the system. The compartment on the bottom contains a set of copper heatpipes and a passive CPU cooler. It is protected by a void warranty sticker on one of the screws.

So to avoid any problems with warranty:
To get to the correct compartment, take of the bezel above the keyboard by pushing it to the left, it it will not go easy! Break a nail or two, but it is possible. UPDATE: There is a small hole in the bezel, in which a pin can be pushed. By pushing in a pin, you unlock the bezel, and the removal will go easier!
Now you can lift the keyboard by shifting it up a few milimeter and than flip it over. In the middle is a compartment protected by a cover with two screws. Open the compartment, insert the memory and place the keyboard and bezel back at its location.


  |  permalink  |  

---

Symptom

In the catalina.out logfile from tomcat there is an exception:
ERROR org.apache.commons.digester.Digester[main] - End event threw exception
java.lang.reflect.InvocationTargetException
etc....

For the rest everything works fine.

Solution

Copy the log4j jar file to the /WEB-INF/lib location and reboot tomcat. The error is gone.

  |  permalink  |  

---

Struts with nested iterators

There are lots of examples on the internet concerning struts with the nested tag library. The following examples concenr less used ways of displaying nested data by using 100% struts compatible methods.

The data

The data to be displayed consists out of sets of data from which the main data is a single list of names, and the second set is a list of telephone numbers per name:

Jan: 123456789 122345678 122233344
John: 155522234 123354556 132311244

This data is to be displayed in such a way that it is readable to a user, in html. In this case: The name, with underneath the telephonenumbers:
jan
123456789
122345678
122233344

To be able to do this, the data will be organized in its own data storage class per name, after which this is data storage class is stored in a Collection.

The data storage class

Bean code

JSP code

Extra: multiple lists to be accessed

Suppose the data with the telephone numbers also has an address associated to it:
jan
123456789 home
122345678 office
122233344 mobile
And you want to display this data.
To do this, the data is all stored in the storage class, and the jsp is altered in the following way:


The changes to the storage class:

Conclusion
  |  permalink  |  

---

Symptom

In jsp with struts you are trying to iterate over a Collection, but the servlet does not recognize it as such.

Solution

Use a collection instead of the type you are using now. logic:iterate works over:
- Hashtable or other maps without accessing the nested elements.
- Collections: AbstractCollection, AbstractList, AbstractSet, ArrayList, HashSet, LinkedHashSet, LinkedList, TreeSet, Vector with access to the nested elements, so a Vector with Vectors stored within etc.

Sample code:

JAVA:

public ActionForward execute(..)
{
Vector test=new Vector();
Vector test2=new Vector();
test.add("test1");
test.add("test2");
test.add("test3");
test.add("test4");
test2.add(test);
test2.add(test);
request.setAttribute("test",test2);
return mapping.findForward("success");
}

JSP:
<logic:present name="test".
<logic:iterate id="myTest" name="test">
Element value: <bean:write name="myTest" /><br/>
<nested:root name="myTest">
<nested:iterate id="myTestInner" name="myTest">
Inner element value: <bean:write name="myTestInner" /><br/>
</nested:iterate>
</nested:root>
</logic:iterate>
</logic:present>
  |  permalink  |  related link  |  

---

Symptom

SuSE 10 (or openSuSE 10) recognized the prism54 chipset card, or other prism based card without problems, but still will not work.
ifconfig ethX up gives a response in /var/log/messages:
prism54: request_firmware() failed
eth1: could not upload firmware

Solution

openSuSE does not provide the firmware from the CD set. Run the online update and add the firmware in the software selection overview. Now the firmware is present and the card can finish its initialisation.
  |  permalink  |  

---

Symptom

The quote and the double quote do not show until you press <SPACE>

Solution

The keyboard settings of you SuSE system are in international. The pressing of the quote or double qoute followed by a character like the o will give you a certain internationally used character. Most users find this behaviour annoying. Solve it by using YaST2, hardware, keyboard settings and set the keyboard from intl to basic. Now the keyboard behaves normal again
  |  permalink  |  

---

Symptom

Under openSuSE 10.0 the numeric keypad fails completely and the mouse fails on some widgets under KDE. The logfiles showed a missing modules.dep file and some other severe errors.
The system used is a 1.6Ghz Pentium 4 Dell dimension 4300.

Solution

Since this only has been observed after a system has been booted after install and after some sig 11 errors, the failure is most likely hardware-software interaction related, and is probably caused by the incorrect loading of some modules. The way out is to reboot the system. After that the errors are gone, and are not reproducable.
  |  permalink  |  

---

Back Next

Links
Home
Contact Me
Stats
Hypersonic database used in OpenOffice and JBoss.
linux.org news and linux updates
Slashdot news for nerds, stuff that matters
The linux kernel site
Java.sun.com

---

Login

---

Archives

«	June 2010					»
Sun	Mon	Tue	Wed	Thu	Fri	Sat
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30
09/06/2010

---

Categories
Faq
General applicable solutions
Java
Linux
  Slackware
  SuSE
SQL
  MySQL
  Oracle
  Microsoft SQL Server
News
php
  Joomla
Little tree
  Sequoiadendron giganteum
    Grow from seed

---

Search:

 

---

Most Recent Comments
Bjorn Bergli
Monday, March 12, 2007, 01:16 PM
Ethernet mini 250GB Diskimage
Monday, March 12, 2007, 12:29 PM

Bjorn Bergli
Monday, January 29, 2007, 02:48 PM
I originally bought my two ethernet...

Mikael Holber
Tuesday, January 9, 2007, 11:48 AM
I followed Jims notes a while ago. I...

Admar
Thursday, December 7, 2006, 12:11 PM
Nice article. Unfortunately, I...

Jim Studt
Thursday, June 1, 2006, 07:26 AM
I went through the exercise and added...

info
Wednesday, January 18, 2006, 03:07 PM
The bezel does slide back into place...

Cody
Wednesday, January 18, 2006, 03:01 PM
If I push the bezel above the keyboard...

---

Most Recent Entries
Microsoft SQL Server Management Studio is slow while starting
HTTP access_log crashes Oracle Enterprise Manager Grid Control
Backup fails
SQL Server temp db fills disk
Database mirroring ENCRYPTION=ENABLED
ABN Amro Tradebox using linux
Bring standby database online
Configuring a user for SSIS
Fast recover of a dataguard
RMAN backup does not respond for long period
Oracle Universal installer not starting
SQL Server does not show all options in the maintenance cleanup plan
Archiver hung error in log while Oracle is not in archive log mode
Oracle chooses full table scan over index while cost is equal
Dataguard fails with divide by zero exception
make fails with stubs32.h not found on 64bit suse 10.3
Layout for view is not found
Starting JRockit Mission Control
Howto create a custom button
Call to JTable object results in blank screen
Adding a view results in error 500
Bea gives error that weblogicWLStore is owned by other thread
Bea Weblogic 9.2 does not start after upgrade
Weblogic jar installer in console mode reports to little disk space
Joomla failes component installation with SQL error
Bea weblogic installation are jar files instead of binary
Bea Weblogic JMS fails to show in JNDI tree in cluster setup
Internet explorer does not show a div
dbms_output.put_line not visible in sqlplus
Using oracle plsql exceptions
EditFailedException in Bea Weblogic 9.1
How to grow a Sequoia from seed
Problem creating new groups in Joomla
Oracle 11g installer fails
proxy: No protocol handler was valid for the URL
java.lang.NoClassDefFoundError: javax/mail/Authenticator
Problem installing PEAR
QMail delivers message many times after mailbox migration
Qmail bounces messages after mailbox migration
Bea weblogic logrotate fails

---

- Page Generated in 0.6215 seconds