Archive for October, 2008

Add an auto incriment field to an OpenOffice 2.4 & 3.1 document on Ubuntu 8.04, 8.10, 9.04, 9.10

October 27, 2008

Ubuntu 8.04 includes OpenOffice 2.4. It is however missing some packages we need. Here is how to install the package we need:

1. System -> Administration -> Sysnaptic Package Manager

2. Settings -> Repositories

3. Select the Updates tab and check “Recommended updates (hardy updates)”

4. Edit -> Reload Package Information

5. Edit -> Search

6. Search for “”

7. Click on the package and select “Mark for Installation”

8. Click “Mark” when prompted for marking additional required changes

9. Edit -> Apply Marked Changes

10. When changes have successfully been applied click Close.

11. File -> Quit

Before following directions at the linked address users should be aware that Word Processor in Ubuntu is the same as 2.x Writer.

12. Applications -> Office -> Spreadsheet

13. In cell A1 enter 1001 or whatever number you would like to start the range with

14. Move the cursor to the right corner of the cell, you will get a cross

15. Hold down the mouse and drag the cursor down until you have enough numbers

16. File -> Save As

17. Enter a file name and select ODF Spreadsheet

18. Open or create a document that you would like to insert the auto-incrementing number

19. Insert -> Fields -> Other

20. Select the Database tab

21. Select Mail merge fields

22. Click Browse…

23. Select the ODF spreadsheet file you just created and saved

24. Click on the + sign for the new database that was added

25. Click on the sheet

26. Click on the number

27. Click Insert

28. File -> Print

29. Answer yes to “Your document contains address database fields. Do you want to print a form letter?”

30. Click ok

31. Click ok for the mail merge

32. Select the printer and click ok, or select print to file to test it (you can then open the file you created and see the auto incrimented numbers in your document)

recording /dev/dsp radio streams in ogg vorbis

October 5, 2008

The following will record audio from the input on the sound card and save it in ogg vorbis format in increments of 1 hour /w a time stamp as the file name.

while [ 0 ]
filename=`date +”20%y%m%d-%H%M”`

#record 1 hour of audio
arecord -d 3600 -vv -c 1 -f S16_LE -r24000 “$filename.wav”

#convert to ogg vorbis
oggenc -q5 “$filename.wav” &

#remove wav file
(sleep 5;rm “$filename.wav”)&

Jbilling on Debian Etch /w Java JRE 1.6 update

October 2, 2008

These directions are missing a critical peace of information. While the Jbilling does work if these directions are followed not all information is contained here to get every feature working. For instance a pdf download feature returns an error. If you intend to use this feature you may need to gather further information. I decided not to use Jbilling due to lack of documentation on resolving this issue. It also did not seem to be the best choice for my situation.

Update Debian Etch’s Java version from 1.5 to 1.6 or newer

And add the line to /etc/apt/sources.list

deb etch-backports main contrib non-free

Then install it with

sudo aptitude update
sudo aptitude -t etch-backports install sun-java6-jdk

And select the new java version:

sudo update-alternatives –config java

Install unzip

sudo apt-get install unzip

Download and unzip Jbilling



Configure Jbilling

sudo apt-get nano

nano server/default/conf/

Change the port from 80 to 8111 to prevent conflict with Apache

nano jbilling/server/default/deploy/jbossweb-tomcat50.sar/server.xml

Startup JBoss

chmod +x bin/



default user name: ‘admin’

default password: ‘123qwe’

company id: ‘1’