Better openerp-server init.d script, for ennhanced Monit/d behavior

simple

December 6, 2012

Linux

No Comment

This script was taken from the default distributions openerp-server init.d script and mainly modified for improved Monit/d behavior. The main problem was that sometimes the openerp-server could not be reliable shutdown – as a result a manual kill had been necessary. This should be now addressed with the following script: #!/bin/sh ### BEGIN INIT INFO […]

Read More

Postgres: Copy a database

simple

November 17, 2012

Databases, Postgres

No Comment

For backup and development reasons a copy of a postgres database on the same system is often used. This is not a big problem and can be done directly as a SQL statement: CREATE DATABASE newDBname WITH TEMPLATE originalDBname OWNER dbuser; in your favorite console (psql, pgadmin, etc). There is one thing to remember, if […]

Read More

Eclipse: convert upper case text to lower case and viceversa with a simple shortcut

simple

November 7, 2012

Development, Java

No Comment

This is just a quick post to share these 2 little shortcuts to convert text from lower case to uppercase and vice-versa in Eclipse. Lower case: CTRL+SHIFT+Y (CMD+SHIFT+Y on Mac OS X) Upper case: CTRL+SHIFT+X (CMD+SHIFT+X on Mac OS X) Camel case: Anyone knows a shortcut? You can select one or more characters to convert.

Read More

OpenERP: Connect Kettle to OpenERP

[1] http://kettle.pentaho.com [2] http://ci.pentaho.com/view/Data%20Integration/job/Kettle/ [3] http://apps.openerp.com/addon/1833?filter=%7B%22order_by%22%3A+%22click_counter+desc%22%2C+%22author%22%3A+78%7D&page=0 [4] http://erpmoldeo.wordpress.com/2011/02/10/openerp-kettle-and-terminatooor/ [5] http://www.akretion.com/en/products-and-services/openerp-kettle-bi-connector-terminatooor [6] http://forums.pentaho.com/showthread.php?98831-Asking-OpenERP-module-for-pentaho-data-integration-(Kettle)

Read More

Glassfish: Running in an java.lang.NoSuchMethodError Exception, when porting a Glassfish2 project

Using the default installation with the standard domain “domain1” of a fresh Glassfish3 installation, I deployed an old Entprise project. The project worked perfectly with Glassfish2, but on Glassfish3 I did ran into an java.lang.NoSuchMethodError: [#|2012-08-07T15:38:25.983+0200|SEVERE|glassfish3.1.2|javax.enterprise.system.core.com.sun.enterprise.v3.server|_ThreadID=20;_ThreadName=Thread-2;|org.apache.commons.collections.MapUtils.putAll(Ljava/util/Map;[Ljava/lang/Object;)Ljava/util/Map;at org.glassfish.apf.AnnotationInfo@cb88c8 java.lang.IllegalStateException: org.apache.commons.collections.MapUtils.putAll(Ljava/util/Map;[Ljava/lang/Object;)Ljava/util/Map;at org.glassfish.apf.AnnotationInfo@cb88c8 at com.sun.enterprise.deployment.archivist.Archivist.readAnnotations(Archivist.java:487) at com.sun.enterprise.deployment.archivist.Archivist.readAnnotations(Archivist.java:429) at com.sun.enterprise.deployment.archivist.Archivist.readRestDeploymentDescriptors(Archivist.java:405) at com.sun.enterprise.deployment.archivist.Archivist.readDeploymentDescriptors(Archivist.java:380) at com.sun.enterprise.deployment.archivist.Archivist.open(Archivist.java:243) at com.sun.enterprise.deployment.archivist.Archivist.open(Archivist.java:252) at com.sun.enterprise.deployment.archivist.ApplicationArchivist.readModulesDescriptors(ApplicationArchivist.java:657) at […]

Read More

Magento: Adding a list of categories as a single category block to Magento

Magento is missing per default a categories block, so you have to code it on your own. For this knowledge of the language php or better 😉 might be required. First we need to change the layout in the file of your magenta installation (assuming that we use the Theme WEBBLAZER): /app/design/frontend/default/WEBBLAZER/layout/catalog.xml add the following […]

Read More

Oracle: Timeout idle or dead sessions

Lately in a project we had a lot of problems with idle database sessions. It turns out that the DBA did not configure any timeout for the oracle database for idle or dead sessions. This is done with the PMON process, and via SQL*Net, by the sqlnet_expire_time parameter. SQL*Net In your sqlnet.ora file add the […]

Read More

Magento: Configure Magento with ISPConfig

Some configuration settings between ISPConfig and Magento overlap, so it was necessary to fine-tune these settings. Also make sure that you use suPHP and try to prevent mod_php, which is faster but has some problems. You can simply copy them and add them to your „Apache Directives“ in the ISPConfig, but do not forget to […]

Read More

Postgres: Remote copy a database between two machines using ssh

Sometimes it might be useful to copy a postgres database between two systems. This is not a big hazel and can be done with a simple one-liner (Port 22): pg_dump -C dbname | bzip2 | ssh remoteuser@remotehost.de "bunzip2 | psql dbname" and even if your ssh connection uses a different port (1234) you are good […]

Read More

GIT: Updating the current branch in a non-bare repository is denied…

simple

February 23, 2012

Development

No Comment

Sometimes there are days when you just forget to configure your git repository on the server and that are the days when you run in awkward errors like that: By default, updating the current branch in a non-bare repository is denied, because it will make the index and work tree inconsistent… The fix for this […]

Read More