Monitoring Pervasive PSQL with Nagios

Nagios 3.2.3 monitoring Pervasive PSQL running on Windows 2003 Server

To monitor Pervasive you have to monitor the following 3 executables:
The reason I monitor these executables instead of the service name is because the service name contains 2 brackets and Nagios refuse to monitor them.

Service names:
Pervasive PSQL Relational Engine - Pervasive.SQL(relational)
Pervasive PSQL Transactional Engine - Pervasive.SQL(transactional)


To monitor Pervasive you have to monitor the following 3 executables:

	Pervasive PSQL					NTDBSMGR.EXE
	Pervasive PSQL Relational Engine					w3sqlmgr.exe
	Pervasive PSQL Relational Engine Transactional					ntbtrv.exe

DHCP Mac Filtering on Windows 2008 R2

http://technet.microsoft.com/en-us/library/dd759190.aspx

Nagios -v verify configuration

/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

FREENAS 7.2 and FREENAS 8.0

After swearing continuously for 3 days I thought I'd share my experience about FreeNAS 7.2 and 8.0. Saying this·...I have to add that FreeNAS wasn't actually build to be a NAS connected to AD.


FREENAS 8.0


Negative points:

* Don't support AD on WIN 2008, don't give you access to the logs as it did in 7.2 (Diagnostics)
* Is an absolute mission to get AD setup and working (if you lucky)
* Is still hung-up about NETBIOS as in version 7.2
* Shutdown button on website
* Everything including SSH, AD is disabled and need to be explicitly enabled via "Services"
* Pity its build on FreeBSD
* CIFS & Windows Shares now 2 different things
* Website layout a bit confusing at first
* Total revamp from 7.2 to 8.0
* No upgrade option AT ALL from 7.2 to 8.0
* Do not use ZFS when connecting to AD

Positive points
* Nice website layout
* You can enable console messages under Settings
* Support VLAN's
* Support Windows Shares, UNIX, CIFS
* Access website without the :80 port indicator
* System - Reporting is nice

AD Debug Logs
Connect via SSH
Run /usr/local/bin/freenas-debug -a
cat /var/tmp/freenas-debug.txt


/usr/local/bin/freenas-debug ?


Logs folders
Console Logs  /var/log/messages/console.log
Machine related logs /var/log/messages


When SSH'ing into the box make sure you've ticked "root" user login under the SSH settings.
When SSH'ing use root and the "Website password" to login.


FreeNAS 8.0

FREENAS 7.2


Positive points
* Access to allot of the system logs from website (fantastic!)
* Much more usable & stable than 8.0


Negative Points
* Require reboot after most changes


After the setup:
* Make a note of the disk setup before you close the window!
* Add the disk  & DO NOT FORMAT
* Add a mount point
* Add a share
* Join AD
* Reboot
* Map the share on your AD, add folders, remove the second Everyone user from the share (The Everyone user that don't have any rights)
* Make sure the share is browsable
* Access the website ie http:10.0.0.99:80




AD Setup
When setting up AD you HAVE To do the following:
* Realize NetBIOS is very important to FreeNAS as this is what it use to connect to AD & network
* Enable the following 
*** EA
*** Dos Attributes
* Add the Server host name as a user on AD
* don't play around with the "net ad join" command as this will mess up AD completely


FreeNAS 7.2

Remotely & Secretly auditing a PC (without user intervention)

Entering WMIC as domain administrator

1. From Start -- Run "runas /domain\user cmd"
2. You'll be shown a new command prompt window - now you are ready to use the WMIC   
3. "Windows Command Line Interface" 

Pulling installed software, name and versions from Remote PC's

1. To list software installed on a remote machine use the following syntax

wmic /node"PCNAME"  product get name, version, vendor >c:\somename.csv

Or you can pipe to .txt file for easier import into xls.

You will be shown the list of software installed on a PC & their versions: ie: and this will be piped to your c drive




 Remote audit with a pipe out to c:\


The output file










http://isc.sans.edu/diary.html?storyid=1229

Ubuntu 10.04 - add a persistent route

route add [-net|-host] netmask gw dev X

Example

route add -net 10.10.10.0 netmask 255.255.255.0 gw 192.168.1.1 dev eth0
route add -host 10.10.1.1 netmask 255.255.255.0 gw 192.168.1.1 dev eth0

Avaya Site Manager 5.0 - setup using Wine on Ubuntu 10.04

• Install Wine
• Install Winetricks
• Install Avaya Site Manager
• Open Winetricks

-- Click on "select a default wine prefix"
---- Click on "Install a windows .dll or component"
------- Select msdac32

If you don't install msdac32 you'll get this error:


marnast@ict-marna:~/.wine/dosdevices/c:/Program Files/Avaya/Site Administration/bin$ wine ASA.exe
fixme:atl:AtlModuleInit SEMI-STUB (0x100100b8 0x1000d1b0 0x10000000)
err:module:attach_process_dlls "odbc32.dll" failed to initialize, aborting
err:module:LdrInitializeThunk Main exe initialization for L"C:\\Program Files\\Avaya\\Site Administration\\bin\\ASA.exe" failed, status c0000005
marnast@ict-marna:~/.wine/dosdevices/c:/Program Files/Avaya/Site Administration/bin$ wine ASA.exefixme:atl:AtlModuleInit SEMI-STUB (0x100100b8 0x1000d1b0 0x10000000)
fixme:win:LockWindowUpdate (0x10200), partial stub!
fixme:win:LockWindowUpdate ((nil)), partial stub!
fixme:shell:MLSetMLHInstance (0x71590000,0x7ed40000) stub
fixme:shell:MLClearMLHInstance (0x71590000)stub
fixme:commdlg:ChooseFontW : unimplemented flag (ignored)
fixme:shell:MLSetMLHInstance (0x71590000,0x7ed40000) stub
fixme:shell:MLClearMLHInstance (0x71590000)stub