How to Configure Splunk to use a Web Proxy Server

A Splunk server I installed was configured such that it could only communicate with hosts within the corporate network so it did not have direct internet access. This posed a problem when trying to use the “Browse Splunkbase” option in the Splunk administrator web interface. I also could not use the “iplocation” data-processing command.

This was the suggestion I got from Splunk Support which didn’t work for me for some reason. I am including it here for reference for someone where this solution may work for them:

You can set the environment variable HTTP_PROXY in the session shell.
You can set it in your /etc/bashrc or /etc/profile.

# Proxy Settings
http_proxy=http://proxy.domain.com:8080
https_proxy=https://proxy.domain.com:8080

I also found something in the forums:
http://www.splunk.com/support/forum:SplunkGeneral/2531

The Splunk install I was running was version 3.4.9 which was on a CentOS 5 server. The Splunk installation was configured to autostart on boot. I ended up getting this to work by editing the /etc/init.d/splunk startup script file by adding the following to it:

# Proxy settings
HTTP_PROXY="http://proxy.domain.com:8080"
export HTTP_PROXY

Change “proxy.domain.com:8080” to be the proxy server address and port for the proxy server that you want to use. So with the above lines added to my /etc/init.d/splunk file, the top portion of the file looked like this:

#!/bin/sh
#
# /etc/init.d/splunk
# init script for Splunk.
# generated by 'splunk enable boot-start'.
#
# chkconfig: 2345 90 60
# description: Splunk indexer service
#
SPLUNK_HOME="/opt/splunk"
RETVAL=0
# Proxy settings
HTTP_PROXY="http://proxy.domain.com:8080"
export HTTP_PROXY

I put the setting into effect by restarting my Splunk service with the command: /sbin/service splunk restart

Splunk Logo

How to Get Trixbox Working Behind a NAT Firewall

trixbox is a line of Asterisk-based IP-PBX products designed to meet the needs of companies from 2 to 500 employees. trixbox is available in a free open source Community Edition. If you are experimenting with trixbox at home, then you are probably in the situation where you have trixbox running on your home network which is behind a Firewall that uses NAT. Here is how to get your trixbox intall communicating outside of your home network:

  1. Be sure the LAN/Private address is statically assigned to the Trixbox server.
  2. Forward the following ports on your firewall to your Trixbox server IP:
    • UDP Port 5060 is for SIP communication.
    • UDP Port 5060-5082 range, SIP communications.
    • TCP Port 5060 is for SIP but thought to be rarely used.
    • UDP Port 10000 – 20000 is for RTP – the media stream, voice/video channel.
  3. You must also edit the sip_nat.conf file. Go to Trixbox home page, then select administrator mode. Select from PBX -> Config File Editor, click on sip_nat.conf and insert the following lines:
    • If you have a static external IP address:
      • Externip = your_external_ip_address
      • localnet = internal.network.address_of_your machine/255.255.255.0
    • If you have a dynanic IP external IP address, use a dynamic IP address hosting service like DynDNS.org:
      • externhost = home.mydomain.com
      • externrefresh = 5 (which means lookup hostname every 5 minutes to refresh ip adress)
      • localnet = internal.network.address_of_your machine/255.255.255.0

Then click on update and then “Re-Read Configs”. Or just restart the Trixbox machine.

trixbox_logo

How to Backup and Restore a MySQL Database Using mysqldump

How to Backup a MySQL Database With mysqldump

mysqldump -u userNameWithPrivileges -p databaseName > outputFileName.sql

How to Restore a mysqldump Backup

mysql -u userNameWithPrivileges -p database < outputFileName.sql

* Replace “userNameWithPrivileges” with the username of a MySQL account that can read/write to the database being backed up / restored.

MySQL logo