July 31, 2016

iDempiere: Problem Accesing Web Service Security

Go to ad_role on the Database and SET isaccessadvanced = Y
July 31, 2016

PostgreSQL: Disable Triggers

ALTER TABLE tblname DISABLE TRIGGER ALL;
July 29, 2016

iDempiere: Change the Database Name

Edit the Following: root@ubuntu:~# vim /opt/idempiere-server/idempiere.properties
July 28, 2016

iDempiere: Add All Roles to Admin

It’s a pain to add all the roles to the Admin Role (I had to re-create this role because I messed up the original role and […]
July 28, 2016

iDempiere: Cleaning Demo Data

The following tables use space on my database and for the use I have for the system I will not use them (I don’t need accounting […]
July 28, 2016

PostgreSQL: Find biggest tables on your database

Excecute the following command on phpPgAdmin on the SQL Tab.   SELECT table_name, pg_size_pretty(table_size) AS table_size, pg_size_pretty(indexes_size) AS indexes_size, pg_size_pretty(total_size) AS total_size FROM ( SELECT table_name, […]
July 28, 2016

PostgreSQL: Restore DB from SQL

#Upload the backup .sql file to the server #Execute the following command. root@ubuntu:~# psql -Uadempiere idempiere < /opt/idempiere-server/DBImport/DB3.sql
July 27, 2016

PostgreSQL: Connect to Database from CLI Ubuntu

sudo -u postgres psql postgres  
July 27, 2016

iDempiere: Configuring Webservices

First if services are enabled: http://host:port/osgi/system/console/bundles   See Available WebServices http://host:port/ADInterface/services