Nov 20 2011

Twitter Weekly Updates for 2011-11-20

Powered by Twitter Tools

Nov 19 2011

To get postgresql running on ubuntu to listen for external connections I did this…

  1. From a terminal window run "sudo gedit" and type your password when prompted.  Gedit opens and you edit the conf files using it.
  2. Edit the file at /etc/postgresql/8.3/main/postgresql.conf and change listen_addresses='*'. This will enable TCPIP connections to the server.
  3. Edit the file at /etc/postgresql/8.3/main/pg_hba.conf and add the following line(s) host    all         all         192.168.0.0/16          trust
  4. This will allow tcpip connections (host) on any database (all) for any user (all) for CIDR-address 192.168.0 - any 16 high-level bits (192.168.0.0/16)  and authenticates anyone that can connect to the server-no pass (trust) See http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html for details
  5. Add any additional ip address ranges you need to that file
  6. From a new terminal window restart postgresql by typing the following command from a new terminal window... sudo /etc/init.d/postgresql-8.4 restart and type your password...if you setup the configuration correctly you should get an [OK] from the terminal.
I was also worried I would have to learn how to open up an ubuntu firewall but that was not needed. This article helped me... https://help.ubuntu.com/8.04/serverguide/C/postgresql.html Seth
Nov 17 2011

New post as http://t.co/q0Q9Y0…

New post as http://t.co/q0Q9Y0TS - : To extract all files from a Wise Installbuilder EXE do this... http://t.co/EGrmADOC #twittertools
Nov 17 2011

To extract all files from a Wise Installbuilder EXE do this…

I use Wise Installbuilder to deliver updates to software I write.  It is an old tool (no longer even available) but it works great for me. Today I began to wonder if there was a way to EXTRACT the files that are included with the setup EXE that wise creates. There is.  From the command line browse to the folder where you saved the EXE.  Type <EXENAME>.exe /X  . The /X tells the installer to extract the files.  It will show a dialog with all of the extractable file (displayed as the script VARIABLE NAME) and when you select one and click okay you can browse for a target folder and, voila, it is done. This is helpful to me because I embed SQL scripts into my updaters and if I ever want to see what I sent this does the trick. Seth