1. basic installation of postgresql server (contrib is needed for adminpack)
sudo apt-get install postgresql
2. Install pdadmin GUI
apt-get install pgadmin3
3. Reset the password for the ‘postgres’ admin account for the server:
$ sudo su postgres -c psql template1 template1=# ALTER USER postgres WITH PASSWORD 'password'; template1=# \q
4. Change the password for the unix user ‘postgres’:
$ sudo passwd -d postgres $ sudo su postgres -c passwd
5. install adminpack
$ sudo apt-get install postgresql-contrib
$ sudo su postgres -c psql < /usr/share/postgresql/8.4/contrib/adminpack.sql
If BI Publisher is not a choice and you also prefer not to use the Apache FOP solution shipped with Oracle APEX (OC4J), you can use another XSL-FO Processing engine which is Apache Cocoon and Apache Tomcat.
Carl Backstrom describes the setup process on his blog:
http://carlback.blogspot.com/2007/03/apex-cocoon-pdf-and-more.html
For Ubuntu this post on the Ubuntu forums is helpful:
http://ubuntuforums.org/showthread.php?t=1004742
Printing large reports
Printing large reports requires some extra settings
Tomcat has by default a limit on POST size. That prevent you from downloading large PDF files.
On Ubuntu: open /etc/tomcat5.5/server.xml
sudo nano /etc/tomcat5.5/server.xml
Find line maxSpareThreads=”75″ and add after that add the following to a new line
maxPostSize="0"
Also you need to increase JAVA memory
continue reading…
Access files on your Windows operating system (host) from Ubuntu (Virtualbox).
Guest Additions installed?
First make sure the Guest Additions are installed. If not, from the VirtualBox’s menu go to Devices > Install Guest Additions. A virtual CD will be mounted. As root run the program VBoxLinuxAdditions.run. When the program completes reboot your VirtualBox.
Define a shared folder
With Guest Additions installed you go ahead and define the shared folder(s). From the VirtualBox’s menu go to Devices > Shared Folders. In the dialog that shows up you can specify which folder from your Windows system you want to share with your Ubuntu OS. You will have to specify a Folder Name for each folder you add. Make sure to memorize that name since it will be required later on.
Create a mountpoint
To mount the shared folder, first you have to create a mounpoint. This is a directory in your Ubuntu OS which will reflect the shared folder from Windows – for example:
# sudo mkdir /media/windows-share
With your mountpoint created you can now mount the shared folder, like this:
Mount shared folder
# sudo mount -t vboxsf shared-folder-name /media/windows-share
Where shared-folder-name will be the name you assigned for this folder when you were adding it in the shared folders list.
You could use the /etc/init.d/rc.local script to execute the last command on startup to have the shared folders automatically mounted every time you start your Ubuntu VirtualBox.
rss feed