OSS Solutions

When trying to encode new hours in one's timesheet in OpenERP, the following error might appear:

ERROR:  null value in column "journal_id" violates not-null constraint insert into "account_analytic_line" (id,perm_id,"user_id","account_id","general_account_id","product_uom_id","journal_id","name","to_invoice","amount","unit_amount","date","product_id",create_uid,create_date) values (4,NULL,'4','6','634','4',NULL,'Analysis of AIM development project',NULL,-40.000000,2.000000,'2008-08-14','1',4,now())

The error code is not clear, but the problem in this case comes from t

I have updated the OpenERP wiki again to add documentation about the possible problems happening when trying to create new databases.

[digg=http://digg.com/software/Evolution_mail_plugin_to_reply_using_templates_accepted] Following-up on my latest article about this plugin (where you can find links to download its early version), it seems that the plugin had been awaited for a long time.

I have recently improved the installation guide for OpenERP 4 on Ubuntu (8.04). Previously, this documentation was available on the old OpenERP wiki, but it has been lost to the public during an upgrade of the website.

This article was first written in September 2004 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/168).

For the moment, no official XAMS binary package exist. You have then to play a bit with the Subversion repository. So, update or export your xams-0.0.x and xams-0.0.x-debian repositories. Done?

This article was first written in August 2004 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/167).

GRE tunnels between Cisco and Linux (2.4 and up) routers are possible. Given the following two routers, each one gateway for its network:

linux

Public IP: 82.72.101.226 Private network: 192.168.4.0/24 IP on that private network: 192.168.4.4

cisco

Public IP: 123.45.67.8 Private network: 192.168.10.0/24 IP on that private network: 192.168.10.4 See IP

This article was first written in August 2004 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/166).

Setting an IP in IP or GRE tunnel using iproute between two Linux routers is relatively easy. Given the following two routers, each one gateway for its network:

routerA

Public IP: 87.65.43.21 Private network: 192.168.4.0/24 IP on that private network: 192.168.4.4

routerB

Public IP: 123.45.67.8 Private network: 192.168.10.0/24 IP on that private network: 192.168.10.4 To setup routerA, will issue the following commands o

This article was first written in August 2004 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/163).

Quagga is able to publish routing information to SNMP. When setting up Quagga [1] with NET-SNMP (previously know as UCD-SNMP), you may fall into the problem of Quagga logging a lot of error messages to syslog or to its own logfile. Let us analyse and fix this kind of error messages in your syslog files:

Aug 30 07:41:40 myhost snmpd[969]: refused smux peer: oid SNMPv2-SMI::enterprises.3317.1.2.1, descr quagga-0.96.5
Aug 30 07:41:46 myhost snmpd[969]: 

This article was first written in August 2004 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/162).

Quagga and Zebra are Free routing softwares. Quagga is a fork of Zebra. They both still work similarly, and share of course the same configuration file format. It may probably allow you to replace Cisco routers or interoperate with them as the configuration is very similar to Cisco's CLI.

This article was first written in August 2004 for the BeezNest technical
website (http://glasnost.beeznest.org/articles/161).

pkg-get is somewhat a rewrite of the apt-get of to Sun's Solaris. It is a script that uses wget and the pkg suite [1] of tools from Solaris to install, upgrade, and uninstall free software easily on Solaris. The list of packages available is already impressive: http://www.blastwave.org/packages.php. To