Uncategorized

Pentaho: Installation

Posted on

Complete Pentaho Installation on Ubuntu, Part 2 http://jaapjansma.nl/2016/05/11/installing-pentaho-6-1-community-edition-on-ubuntu/#comment-36   After installation and reboot of the server, it needs to be manually restarted executing the following command: To start postgresql you need to be logged in as user: pentaho   Then change to super user and start the server. /home/pentaho/Pentaho/ctlscript.sh start   /home/pentaho/Pentaho/server/pentaho-server/start-pentaho.sh   Additionally, to access […]

Apache

Apache: Change Default Not Found Image

Posted on

This is globally controlled by apache, or locally controlled by your .htaccess file (which basically changes the local apache configurations on local folders). Just add the following code to your .haccess file and¬†adjust as per your requirements   RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_URI} \.(gif|jpg|jpeg|png)$ RewriteRule .* /var/www/html/malla-supply/img/p/en.jpg [L]   To do it Programatically […]

PostgreSQL

PgSQL: Cannot Alter Character Length because of Dependant Views

Posted on

  SQL error: ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view rv_warehouseprice depends on column “sku” In statement: ALTER TABLE “adempiere”.”m_product” ALTER COLUMN “sku” TYPE character varying(50) I’ve read some documentation and the only apparent solution is to delete all the related views and then […]