zaterdag 20 juli 2013

Installing Observium Monitoring Tool

Hi all, today another new blog from my side. My colleague Rob has a nice monitoring tool called Observium. So i thought lets check this out and lets install this on a brand new Debian server.

Photo-main

Observium was started true a kickstarter project.
http://www.kickstarter.com/projects/588464062/observium-alerting

A small introduction about Observium.

"

Introduction

Observium is an Open Source, auto-discovering network monitoring platform written in PHP which supports a wide range of devices and operating systems. We collect data and status via SNMP and an optional Agent and present the information in a useful-to-engineers manner.
To keep things simple to manage, we try to discover everything that can be graphed or monitored on a device automatically. You usually don't know you need to graph something until after the event or outage! We even try to automatically discover neighboring devices seen via CDP and LLDP tables or OSPF neighbor tables. 
We believe that one of the key purposes of an NMS is to help engineers understand their networks. One of the very first features implemented was the ability to visualize a device's place in the network based on the devices it connected directly to, and the devices its interfaces share sub-nets with. 

"

Ok now a little tutorial on how to install this brilliant package.
Install the following packages:
aptitude install libapache2-mod-php5 php5-cli php5-mysql php5-gd php5-snmp \
php-pear snmp graphviz subversion mysql-server mysql-client rrdtool \
fping imagemagick whois mtr-tiny nmap ipmitool
  

Create and copy the following directories and files
$ mkdir /opt/observium/
$ cd /opt/observium/
$ cp config.php.default config.php
$ mkdir graphs rrd
$ chown www-data.www-data graphs rrd
$ mkdir /opt/observium/logs
  

  
CREATE DATABASE observium;
GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost'
IDENTIFIED BY '<observium db yourpassword>';
  
  

We need to create some Mysql database lines by following up the commands bellow
  
$ mysql -uroot -p
Enter password: <mysql root password>
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 238145

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE observium;
Query OK, 1 row affected (0.10 sec)

mysql> GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY 'observium';
Query OK, 0 rows affected (0.06 sec)
  
  

Now we need to add the config.php
cd/opt/observium/ nano config.php

### Database config
$config['db_host'] = "localhost";
$config['db_user'] = "observium";
$config['db_pass'] = "observium";
$config['db_name'] = "observium";

  

Ok now we need to add a virtual host to our apache
$ sudo vim /etc/apache2/sites-enabled/010-observium

<VirtualHost *:80>
       ServerName  observium.yourdomain.com
       DocumentRoot /opt/observium/html
       <Directory />
               Options FollowSymLinks
               AllowOverride None
       
       ErrorLog /var/log/apache2/error.log
       LogLevel warn
       CustomLog /var/log/apache2/access.log combined
       
</VirtualHost>
  
  

$ a2enmod rewrite
Enabling module rewrite.
Run '/etc/init.d/apache2 restart' to activate new configuration!

$ a2ensite observium
Enabling site observium.
Run '/etc/init.d/apache2 reload' to activate new configuration!

$ service apache2 restart
  

  
$ ./adduser.php
Add User Tool
Usage: ./adduser.php <username> <password> <level 1-10> [email]

$ ./adduser.php admin adminpass1 10 

$ ./adduser.php admin1 adminpass2 1 


The only thing left is to add a new record in your hostfile.

192.168.0.20 observium.yourdomain.com

When you have don this you can access the web page true IE by typing observium.yourdomain.com


Good luck installing :)

P.S
Make sure you have a router with SNMP.








vrijdag 12 juli 2013

Starting a basic (next-next-finish) SQL server installation for Sharepoint 2010

First of all you should install the following applications:

-Server 2008R2
-SQL 2008 R2
-Filterpack 2.0 64bit
-MSchart
-SYNC Setup
-Windows6.1 KB974405-X64

You also need to add the role IIS and add the feature .NET Framework 3.5.

So now we can start installing SQL server 2008 R2.

Step 1. Run Setup.exe from the SQL Server 2008 R2 install CD 
Step 2. Click on Installation on the left hand column
Step 3. Click on New SQL Server stand-alone or add features to an existing installation

Step 4. Click on Show Details and make sure that all the setup support rules have passed and then click OK
image
Step 5. Give in your Licence key
Step 6. Tick I accept the license terms and click Next
image
Step 7. Click Install
image
Step 8. Click Next
image
Step 9. Select the components you want to install and click Next
image
Step 10. Configure the Instance name and details and click Next
image
Step 11. Review the disk space requirements and click Next
image
Step 12. Configured the Service accounts that you want to use and click Next
image
Step 13. Add a SQL Server Administrator and Click Next
image
Make sure you Give in the right collation for SharePoint 2010: Server Collation SQL_Latin1_General_CP1_CI_AS 

Step 14. Click Next
image
Step 15. Click on Show Details and review the install rules and then click Next
image
Step 16. Do a final review of the install and click Install
image

Step 17. Click Next
image
Click 18. Click Close
image
Now you really need to install Service Pack 1

Step 19. Click Next
image
Step 20. Click I accept the license terms and then click Next
image
Step 21. Review the features that are going to be upgraded and click Next
image
Step 22. Click Next
image
Step 23. Click Update
image
Step 24. Click Next
image
Step 25. Click Close

For configurations tips and tricks check my SQL optimization blog

woensdag 10 juli 2013

Configuring Debian DNS server Advanced.


1. bind9 nameserver installation

Unless you prefer to install bind from a source code the installation is rather simple. On a Debian or Ubuntu Linux server you can install a bind nameserver with a following command:
apt-get install bind9 dnsutils
CentOS or Fedora alternative:
yum install bind dnsutils
Here we go good luck.

2. Creating a DNS zone file

At this stage we will need to create a file for a domain jeromic.nl  Navigate to /etc/bind/ directory execute following sequence of commands to navigate to etc/bind/zones/master/ if you dont have it create it like below
cd /etc/bind
mkdir -p zones/master
cd zones/master/
/etc/bind/zones/master directory will contain a zone file for a jeromic.nl domain. If you prefer to use another directory to hold this file you are free to do so. The following zone file db.jeromic.nlwill hold a DNS record to assist a nameserver resolve a fully qualified domain name to an IP address. Create and save db.jeromic.nl with a following content: you can create a site by typing cd /etc/bind/zones/master/ nano. Then put it the command below with you own domain. and save it as db.domain.extension.
;
; BIND data file for jeromic.nl

;
$TTL    3h
@       IN      SOA     ns1.jeromic.nl. admin.jeromic.nl. (
                          1        ; Serial
                          3h       ; Refresh after 3 hours
                          1h       ; Retry after 1 hour
                          1w       ; Expire after 1 week
                          1h )     ; Negative caching TTL of 1 day
;
@       IN      NS      ns1.jeromic.nl.
@       IN      NS      ns2.jeromic.nl.



jeromic.nl.    IN      A       192.168.0.10
ns1                     IN      A       192.168.0.10
blog.jeromic.nl         IN      CNAME   superitconsultant.blogspot.nl.

Here is just a quick overview of the records:
  • SOA Record: nameserver authoritative for a zone jeromic.nl is ns1.jeromic.nl and admin.jeromic.nl is an email address of a person responsible for this DNS zone.
  • NS Records: two nameservers for a jeromic.nl zone are ns[1,2].jeromic.nl
  • MX ( Mail Exchange): jeromic.nl mail exachange record. Number 10 means a preference for discarting a records A : A simply means address inanother words in jeromic.nl zone a ns1 would ahve a A ( address ) 192.168.0.10.
  • CNAME Record ( Canonical Name record ): restart the query using the canonical name instead of the original name

3. address-to-name mappings

At this stage the bind DNS server can resolve an IP address mapped to a jeromic.nl host. What we should do now is the teach our nameserver the other way around, which is, to resolve a host from an IP address. For this we are going to need yet another file and that is db.192.168.0 with a following content:
PTR
;
; BIND reverse data file for 0.168.192.in-addr.arpa
;
$TTL    604800
0.168.192.in-addr.arpa.      IN      SOA     ns1.jeromic.nl. admin.jeromic.nl. (
                          1         ; Serial
                          3h       ; Refresh after 3 hours
                          1h       ; Retry after 1 hour
                          1w       ; Expire after 1 week
                          1h )     ; Negative caching TTL of 1 day
;
0.168.192.in-addr.arpa.       IN      NS      ns1.jeromic.nl.
0.168.192.in-addr.arpa.       IN      NS      ns2.jeromic.nl.

10.0.168.192.in-addr.arpa.   IN      PTR     jeromic.nl.
  • PTR: a NDS record used for a mapping of an IP address to a host name.

4. Updating a BIND Configuration File

At this point we should have two files ready:
  • /etc/bind/zones/master/db.jeromic.nl
  • /etc/bind/zones/master/db.192.168.0
All we need to do now is to insert both zone file names into a bind's configuration file named.conf.local. To do that add following lines into this file:
zone "jeromic.nl" {
       type master;
       file "/etc/bind/zones/master/db.jeromic.nl";
};

zone "0.168.192.in-addr.arpa" {
       type master;
       file "/etc/bind/zones/master/db.192.168.0";
};
Last thing before we go ahead to check a configuration is to add and IP address af a stable DNS server to a named.conf.options file. This IP address is used in case that a local DNS server do not know the answer the a name resolution query. In IP address of a DNS server in many cases is provided by your Internet provider. Alternatively if you are google fan use 8.8.8.8.
Replace a following blog of text withing a named.conf.options file:
       // forwarders {
       //      0.0.0.0;
       // };
with new stable DNS server IP address
        forwarders {
              8.8.4.4;
         };
Ok now you are finished. You can check DNS by doing a NSlookup
root@debian:~# nslookup
> 192.168.0.10
Server:         192.168.0.10
Address:        192.168.0.10#53

** server can't find 10.0.168.192.in-addr.arpa.: NXDOMAIN
> blog.jeromic.nl
Server:         192.168.0.10
Address:        192.168.0.10#53

Name:   blog.jeromic.nl
Address: private ip
Thank and please leave a message or comment :)

dinsdag 9 juli 2013

Site Redirection in Debian

Hi all, I finally managed to redirect a site in Debian great thanks to my brilliant colleague Rob Maas (Check out his blog http://www.progob.nl/robmaaseu/ ).

First of all we tried to forward this site to my local domain within Debian. We did this thru the zone file in Bind9.

$TTL    604800
@       IN      SOA     NS1.domain.nldomain.thuis.domain.nl. (
                2013070901              ; Serial
                         604800         ; Refresh
                          86400         ; Retry
                        2419200         ; Expire
                         604800 )       ; Negative Cache TTL
;
;Nameservers
;
Jeromic.nl      IN      NS      NS1.domain.nl

@       IN      NS      domain.nl.
@       IN      A       127.0.0.1
@       IN      AAAA    ::1

;
;Reverse Proxy
*                       IN      A       [my private ip]

;
;Alias
blog.jeromic.nl         IN      CNAME   superitconsultant.blogspot.nl

Only that didn't work. so Rob gave me another option to do this in apache.

cd /etc/apache2/sites-enabled/ nano 014-blog

After this we add the following in our Virtual host file.

<VirtualHost *:80>
       ServerName blog.domain.nl

       CustomLog       /var/log/apache2/blog_access.log combined
       ErrorLog        /var/log/apache2/blog_error.log

       Redirect / http://http://superitconsultant.blogspot.nl/

</VirtualHost>

After this we restarted the service

service apache2 restart

And the redirection is working properly

All thanks go to Rob Maas.

Thanks and please leave a comment

maandag 8 juli 2013

List of all Sharepoint Service applications with descriptions

Hi, today i'm working on a sheet with all the descriptions of all SharePoint Services which are integrated or a option for Sharepoint 2010. The plan is to get lots of SMART information. and put all of these on a letter format paper. With this information we can create our own cheat sheet.


ServiceDescription
Access Services
Makes users capable to view access databases inside of the web browser
Application Registry Service
Makes users capable to work with business data 
Business Data Catalog
Makes it possible to Embed a business application into SharePoint 2010
Excel Services
Makes users capable to view excel sheets inside of the web browser
Lotus Notes Connector
Makes users capable to Find Lotus Domino/Notes data
Managed Metadata Service
This will make sure that Teams and departments can create their own hierarchy keyword and social tags. So the can publish this thru the whole organisation
People
Makes it possible to import profiles from AD which will contain the information for MY site. Besides this you are able to search to people 
PerformancePoint Services
Gives the opportunities for PerformancePoint Services.
Search Service Application
Makes search queries and indexing possible inside content.
Secure Store Service
Makes it possible to secure data and save these with restrictions
State Service
Makes it possible to determine a status of a service or component. So when the will been load balanced these will not get lost
Subscription Service
This service will be used in Multi-Tenant Mode (hosting)
Usage and Health data collection 
Collects status data from the SharePoint farm
User Profile Service 
Offers profile services. 
Visio Graphics Service
Makes it possible to Show Visio diagrams in the web browser, and refine these dynamically
Web Analytics Web Service
Makes it possible to create analytics reports of the site. (how many users, how many page views etc) 
Word Conversion Service Application
Makes it possible to convert large numbers of documents.

Additional Services:


Service
Description
Office Web Applications
Offers the opportunity to provide several office applications in the webbrowser. the next applications will be provided Word 2010, Excel 2010, PowerPoint 2010 en OneNote 2010.
FAST Search Server
FAST Search for SharePoint 2010 is an advanced search in SharePoint 2010
Microsoft Project Server 2010
Project Server 2010 is the follow up for Project Server 2007 and Project Portfolio Server 2007. this offers a complete package for Enterprise Project Management (EPM) and Project Portfolio Management (PPM) processes.

If you have any other option or suggestion, or maybe i forgot something please let me know.

Regarding the home server Lab i'm running into some trouble. I need to redirect a site in my Linux Debian DNS so i added the cname to my zone only this doesn't work for now. 
This evening i will continue configuring my home Domain Controller. And possibly i will start with building up the first server for Sharepoint.

Please leave a comment.

vrijdag 5 juli 2013

Configuring a home domain controller in Server 2008 R2 on Hyper-V

Hi all, Today i have configured a domain controller. I did this so i can create my own SharePoint Farm at home.
Later this blog i will tell you how to configure a domain controller in Server 2008 R2. Beside this i am looking for a mini Android PC to put in my TV so if anyone has any recommendations please let me know.

OK lets go to the Configuration of A domain controller. (You need to have server 2008 R2 installed)


  1. First of all open up the Network Adapter settings and assign a static IP address to the IPv4 configuration from the block of static IP addresses that you have set aside.
  2. If you need to enter a default gateway, configure the default gateway as the IP address of your router (usually something like 192.168.0.1)
  3. If you need to enter a Primary DNS server, you can enter the IP address of your router as well (such as 192.168.0.1) or take in my case the ip of my Debian DNS.
  4. Once you have entered your settings, click OK to save all of your network adapter settings.
  5. If you have customized or disabled any Windows Services, you will need to ensure that the appropriate Windows services are enabled and started:
    1. Remote Procedure Call (RPC) Service
    2. Remote Registry Service
    3. Also make sure that Remote desktop services is activated.
  6. Now, at the run command, you can run dcpromo, or you can press the link at the end of the wizard
  7. This should now initiate the process to install the Active Directory binaries on your machine as well as launch the Active Directory configuration wizard. 
  8. While configuring Active Directory through the configuration wizard, you will be prompted for setting up a new forest or using an existing forest.  Since you don't have an existing domain infrastructure in place, you will want to create a new forest.  In terms of forest compatibility, I would recommend either configuring the compatibility to either Windows Server 2008 or Windows Server 2008 R2 compatibility mode.
  9. [Skip this if you have a Debian DNS] After proceeding through several other configuration steps, you will be prompted to configure DNS on the server.  You can allow the domain controller to be configured as its own DNS Server.  This will effectively modify the network adapter settings to include 127.0.0.1 as the Primary DNS Server IP Address

If there were no hiccups in the configuration wizard process, you should be done with successfully configuring a domain controller within your virtual machine. :)

If you have any comments please leave them.



donderdag 4 juli 2013

Replacing memory of Synology 412+ with 2gb

Hi all, today i bought myself a Kingston 2gb ddr3 1066 so-dimm. Which fits in my NAS a Synology 412+ according to some forums.
Sometimes when i watch a movie in 1080p and SABNZB is downloading and extracting the NAS is running to its max. for this reason i bought another memory.

When i want to replace the memory some things need to be done first.

This is the NAS where Talking about
When we took it all appart it looks likes this


First of al we need to take of the front cover and the Hard drives. Remember the which drive was in which bay. This wil spare you a lot of errors and difficulties.


The second step is to remove the screws which are surrounded bye red circles


When we have done that you need to press the back with the logo so the little lips fall over the metal bar inside of the NAS.


When the lips are over the bar you are able to slide out the interior of the NAS. Be very careful that you don't damage anything


When the NAS and the outside are apart you need to get the screws loose which are withing the red circles.



you can now remove the brackets of the hard drives.
When you have done that it will look like the picture below


When you have done this you need to remove the remaining screws on the top plat which is on top of the motherboard. After this you are able to spin the motherboard and you can change the memory on the Motherboard.


If you need any advise or help with this please leave me a comment. Ok when you have done this you can put everything back together and don't forget to put all the screws back in place again :).

After you put the NAS back together you can connect you NAS again and you can test if everything is working again.

Good luck.