Common pitfalls OpenACS, tcl & pgsql

Sep 292011

tcl: Continue line using backslash

1) Make sure there’s no backspace after the backslash !
2) No breaks allowed within function call

This won’t work: 

                [im_do_row [array get bgcolor] $ctr $curr_owner_id \
                                $owner_name \
                                $days \
                                [array get user_days] \
                                [array get user_absences] \
                                $holydays \
                                $today_date \
                                [array get user_ab_descr] \
                                $workflow_key \
                           ]

OpenACS: Watch packages

  • AOLServer restart sets back watches
  • CVS settings (watch) could lead to additional dirs Base/Baseserv containing a second version of lib files

pgsql

# select project_id from im_projects where parent_id = NULL;
 project_id
------------
(0 rows)

# select project_id from im_projects where parent_id IS NULL;
 project_id
------------
      35116
      35417
(2 rows)

OS Integration Tools

Dec 292008

http://www.infoworld.com/article/08/12/02/49TC-jitterbit-talend_1.html

compares TALEND with JITTERBIT

How to run a sql script manually

May 052008

For all those who are not all to familiar with console commands and linux in general, here some articles and comments that should help you to to perform basic administration and maintenance work.

Running a sql command

In some rare cases update scripts in former version did not execute correctly when triggered by the OpenACS package manager. Here some instructions in case you have never dealt with basic DB/console stuff. I assume you are running ]po[ in a VM in a WINDOWS environment.

1) Get PUTTY (http://www.chiark.greenend.org.uk/~sgtatham/putty/). PUTTY gives you console access to the linux Operating System (OS) ]po[ is running on.

2) Start the Firefox browser in your VM, the ]po[ home page should come up and indicate on the left side the IP address of the VM.

3) Start PUTTY and make a connection to the VM. Default user is root, default password is also root.

4) After successful login you should get a user prompt. In order to execute a DB command you would need to login as user 'projop'. Run the following command

su - projop

executing 

whoami

should return projop which tells you that you are no logged in as user projop

5) To run sql commands execute

psql

The command prompt should have changed now to projop=> so that you can execute sql statements. Please make sure that you are running this command also as user projop. Commands can be multi-line and need always need to finish with a semicolon. Use q to leave the DB and return to the linux prompt.

Sometimes you are asked to execute complete update scripts. This can be done from the linux prompt. Update scripts are usually located in /web/projop/packages/[PACKAGE_NAME]/sql/postgresql/upgrade/[SCRIPT_NAME]

To execute an entire update script please run
psql -f [SCRIPT_NAME], e.g. psql -f upgrade-3.3.1.0.0-3.3.1.1.0.sql

Start putty from your local WIN machine and make a connection to your VM image.