David Ghedini

Linux, Java, Oracle, and PostgreSQL

David Ghedini

Monday Jun 12, 2017

Nominatim Server Script

We've had a lot of positive feedback from our OpenTileServer script.

With some prompting from users, we have added a script for Nominatim.

Nominatim is search engine for OpenStreetMap data.

You can get the information, as well as the script at OpenNameSearch.org

The script also includes an auto-updater and their is a reload script as well for loading multiple PBFs.

Thanks to the good folks at Geofabrik for providing OpenStreetMap extracts to the public.

Please post any issue at https://github.com/AcuGIS/OpenNameSearch

Bookmark and Share

Wednesday Mar 15, 2017

Tomcat Module for Webmin

It's always good to see I'm still getting new comments on my Tomcat 7 post from back in 2011(!).

Yesterday, we released our Tomcat Module for Webmin

The module works like any other Webmin module and allows you to install and manage Apache Tomcat from within Webmin.

The module provides a GUI for you to Stop, Start, and Restart Tomcat, Deploy and Un-Deploy WAR files, as well as edit the main configuration files.

The easiest way to install it is to simply go to Webmin->Webmin Configuration->Webmin Modules

In the 'From ftp or http URL', enter:


Refresh the main page and you should see "Apache Tomcat" under "Servers" in Webmin menu.

Click the "Install Now" button to install Tomcat and Java.

Below are Some Screen Shots

Tomcat Module:

Tomcat Module WAR Manager:

Tomcat Module Configuration Editor:

If you prefer to use GIT, you can follow below:

$ git clone https://github.com/AcuGIS/Tomcat-Webmin-Module
$ mv Tomcat-Webmin-Module tomcat
$ tar -cvzf tomcat.wbm.gz /tomcat

Distro Notes


Tested on Ubuntu 12, 14, 15, and 16


Tested on CentOS 6x64 and 7x64

haveged helps Tomcat start much faster.

yum install epel-release
yum install haveged
chkconfig haveged on

Tested on Debian 7 and 8


tomcat_env doesn't work, because tomcat service(/usr/local/etc/rc.d/tomcat8) is not sourcing the setenv.sh file. Work around is to set tomcat7_java_opts= in service file.


Install tomcat packages manually and then install module, because Webmin doesn't support pacman. Go to Existing Tomcat Installations below.

pacman --noconfirm -S tomcat8 tomcat-native jre8-openjdk

Install tomcat packages manually and then install module. Go to Existing Tomcat Installations below.

zypper -n install tomcat tomcat-webapps tomcat-admin-webapps

Installing on Existing Tomcat Installations

You can also use the module to manage an existing installation as well.

1. Install via Webmin->Webmin Configuration->Webmin Modules
2. Under Server > Apache Tomcat click on the configuration icon in the top left corner.
3. Update the configuration paths to your existing Tomcat paths.
4. You should now be able to use all functionality.

Please post any issue here or at https://github.com/AcuGIS/Tomcat-Webmin-Module

Happy Tomcat'ing :)

Bookmark and Share

Saturday Jan 30, 2016

PostgreSQL 9.5 Script for Debian Jessie (8.3)

Adding on to the CentOS PostgreSQL 9.5 scripts below, I've added a version for Debian Jessie (8.3).

Please read the README and use only on a clean install!


As with the CentOS scripts, it adds some basic security steps:

  • Creates a minimally privilaged user (pgadmin - change to whatever you like)
  • Disables root log in
  • Sets the SSH port to 3838 (change to whatever you like).
  • Sets root, postgres, admin, and ssl pass to 32 chars
  • Installs IP tables (if you want to use firwalld, comment the appropriate lines as noted).
  • Configures Webmin for managing PostgreSQL
  • Installs a self-signed SSL for PostgreSQL
  • Updates pga_hba.conf to MD5 and SSL
  • Updates postgresql.conf for SSL and remote connections.

Once completed, it will display the new passwords for pgadmin, root, postgres, and ssl as well as write them to an auth.txt file

: Example Output at End of Script
Passwords saved in /root/auth.txt
pg pass: DqVnavTlCXcSKfHprgUtjF-20rpfsKui
ssl pass: yxaQJCXgudTw19XEOMPdZzNd5n6rwVOG
pgadmin pass: A0RUHtPfSFC82mHeDP_ixrRavk7itgkE
root pass: RvZDHkZv-AeQS-ce0Mcnif7GxmmJ-zxN

Bookmark and Share

Main Menu

Built With



Tag Cloud

Hosted by:




petiole Cloud