Information Technology Blog

Find a disk serial number on a VMware vSphere ESXi HP Proliant host

2016-06-02T15:42:00.000+02:00

I had an issue on a hard drive on my HP Proliant.

You must have installed your ESXi with the special HP distribution (available on VMware website)

STEP 1

On your vSphere client, log in your server (directly the ESXi host, not the vSphere appliance).
Click on your host, configuration, go to security profile
Select the SSH service, Options, Start.
You can find other ways to enable SSH here, or using search engines.
Don't forget to disable SSH after your operation.

STEP 2

To find informations and SN about the disks, we will use hpssacli.
You can find further informations about this command here and here.

Username : root
Password: your current root password

cd /opt/hp/hpssacli/bin/
In order to show controler informations
./hpssacli ctrl all show detail
Smart Array P420i in Slot 0 (Embedded)
   Bus Interface: PCI
   Slot: 0
   Serial Number: 001438027FEFE60
   Cache Serial Number: PBKUA0BRH5K3HN
   RAID 6 (ADG) Status: Enabled
   Controller Status: OK
   Hardware Revision: B
   Firmware Version: 4.68
   Rebuild Priority: Medium
   Expand Priority: Medium
   Surface Scan Delay: 15 secs
   Surface Scan Mode: Idle
   Queue Depth: Automatic
   Monitor and Performance Delay: 60 min
   Elevator Sort: Enabled
   Degraded Performance Optimization: Disabled
   Inconsistency Repair Policy: Disabled
   Wait for Cache Room: Disabled
   Surface Analysis Inconsistency Notification: Disabled
   Post Prompt Timeout: 0 secs
   Cache Board Present: True
   Cache Status: OK
   Cache Ratio: 25% Read / 75% Write
   Drive Write Cache: Disabled
   Total Cache Size: 512 MB
   Total Cache Memory Available: 304 MB
   No-Battery Write Cache: Disabled
   Cache Backup Power Source: Capacitors
   Battery/Capacitor Count: 1
   Battery/Capacitor Status: OK
   SATA NCQ Supported: True
   Spare Activation Mode: Activate on physical drive failure (default)
   Controller Temperature (C): 64
   Number of Ports: 2 Internal only
   Encryption Supported: False
   Driver Name: HP HPSA
   Driver Version: 5.5.0
   Driver Supports HP SSD Smart Path: False
To find defective disk (use the right slot, 2nd line on the last command)
./hpssacli ctrl slot=0 pd all show status
   physicaldrive 1I:1:1 (port 1I:box 1:bay 1, 600 GB): OK
   physicaldrive 1I:1:2 (port 1I:box 1:bay 2, 600 GB): Failed
   physicaldrive 1I:1:3 (port 1I:box 1:bay 3, 600 GB): OK
   physicaldrive 1I:1:4 (port 1I:box 1:bay 4, 600 GB): OK
   physicaldrive 2I:1:5 (port 2I:box 1:bay 5, 600 GB): OK
   physicaldrive 2I:1:6 (port 2I:box 1:bay 6, 600 GB): OK
To get more informations on all disk, including the serial number
./hpssacli ctrl slot=0 pd all show detail
Smart Array P420i in Slot 0 (Embedded)

   array A

      physicaldrive 1I:1:1
         Port: 1I
         Box: 1
         Bay: 1
         Status: OK
         Drive Type: Data Drive
         Interface Type: SAS
         Size: 600 GB
         Native Block Size: 512
         Rotational Speed: 10500
         Firmware Revision: HPD3
         Serial Number: S0M1L5M9000XXXX
         Model: HP      EG0600FCVBK
         Current Temperature (C): 38
         Maximum Temperature (C): 49
         PHY Count: 2
         PHY Transfer Rate: 6.0Gbps, Unknown
         Drive Authentication Status: OK
         Carrier Application Version: 11
         Carrier Bootloader Version: 6

      physicaldrive 1I:1:2
         Port: 1I
         Box: 1
         Bay: 2
         Status: Failed
         Last Failure Reason: Mark bad failed
         Drive Type: Data Drive
         Interface Type: SAS
         Size: 600 GB
         Native Block Size: 512
         Rotational Speed: 10500
         Firmware Revision: HPD3
         Serial Number: S0M1L5M9000XXXX
         Model: HP      EG0600FCVBK
         Maximum Temperature (C): 53
         PHY Count: 2
         PHY Transfer Rate: 6.0Gbps, Unknown
         Drive Authentication Status: Not Applicable

      physicaldrive 1I:1:3
         Port: 1I
         Box: 1
         Bay: 3
         Status: OK
         Drive Type: Data Drive
         Interface Type: SAS
         Size: 600 GB
         Native Block Size: 512
         Rotational Speed: 10500
         Firmware Revision: HPD3
         Serial Number: S0M1L5M9000XXXX
         Model: HP      EG0600FCVBK
         Current Temperature (C): 42
         Maximum Temperature (C): 53
         PHY Count: 2
         PHY Transfer Rate: 6.0Gbps, Unknown
         Drive Authentication Status: OK
         Carrier Application Version: 11
         Carrier Bootloader Version: 6

      physicaldrive 1I:1:4
         Port: 1I
         Box: 1
         Bay: 4
         Status: OK
         Drive Type: Data Drive
         Interface Type: SAS
         Size: 600 GB
         Native Block Size: 512
         Rotational Speed: 10500
         Firmware Revision: HPD3
         Serial Number: S0M1L5M9000XXXX
         Model: HP      EG0600FCVBK
         Current Temperature (C): 43
         Maximum Temperature (C): 52
         PHY Count: 2
         PHY Transfer Rate: 6.0Gbps, Unknown
         Drive Authentication Status: OK
         Carrier Application Version: 11
         Carrier Bootloader Version: 6

      physicaldrive 2I:1:5
         Port: 2I
         Box: 1
         Bay: 5
         Status: OK
         Drive Type: Data Drive
         Interface Type: SAS
         Size: 600 GB
         Native Block Size: 512
         Rotational Speed: 10500
         Firmware Revision: HPD3
         Serial Number: S0M1L5M9000XXXX
         Model: HP      EG0600FCVBK
         Current Temperature (C): 43
         Maximum Temperature (C): 52
         PHY Count: 2
         PHY Transfer Rate: 6.0Gbps, Unknown
         Drive Authentication Status: OK
         Carrier Application Version: 11
         Carrier Bootloader Version: 6

      physicaldrive 2I:1:6
         Port: 2I
         Box: 1
         Bay: 6
         Status: OK
         Drive Type: Data Drive
         Interface Type: SAS
         Size: 600 GB
         Native Block Size: 512
         Rotational Speed: 10500
         Firmware Revision: HPD3
         Serial Number: S0M1L5M9000XXXX
         Model: HP      EG0600FCVBK
         Current Temperature (C): 39
         Maximum Temperature (C): 47
         PHY Count: 2
         PHY Transfer Rate: 6.0Gbps, Unknown
         Drive Authentication Status: OK
         Carrier Application Version: 11
         Carrier Bootloader Version: 6
Once you've changed the disk, you can check the rebuild status using this command:
./hpssacli ctrl slot=0 ld 1 show
Smart Array P420i in Slot 0 (Embedded)

   array A

      Logical Drive: 1
         Size: 2.7 TB
         Fault Tolerance: 5
         Heads: 255
         Sectors Per Track: 32
         Cylinders: 65535
         Strip Size: 256 KB
         Full Stripe Size: 1280 KB
         Status: Recovering, 29% complete
         Caching: Enabled
         Parity Initialization Status: Initialization Completed
         Unique Identifier: 600508B1001CF21E96713374CEBAD21D
         Logical Drive Label: A23BA9B5001438027FEFE6027CA
         Drive Type: Data
         LD Acceleration Method: Controller Cache

Other commands in the documentations mentioned below.

Comments welcome!

MSSQL 2008 on windows 2012 Server doesn't start, error 0x80070534 and Event ID : 17058

2015-04-14T23:31:00.001+02:00

First symptom : the service doesn't start.
I quick look in the event log :
Event ID : 17058

initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

I checked the security of my folders (where the instance is installed), no problem.

What is important at this point, is that I just promoted my server as a domain controller. Beginning of my problem.

Second symptom : changing the service account fails with error 0x80070534
I went in my SQL Configuration editor in order to change the service account information.

0x80070534 No mapping between account names and security IDs was done.

Impossible to change credentials.
I also tried ti change the account directly in the windows Service MMC, no way to start the service as local account or even Administrator.

The following article gave the final clue : http://serverfault.com/questions/24484/sql-server-2005-on-2008-dc-cannot-change-service-user

After a few googling, it cames that my problem is a windows SID problem. After promoting my server, some SID changed, and my server was unable start using the old credentials.

To solve this problem, go to
Regedit
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLxxx.Instance\Setup
locate SQLGroup String. It contains the SID which has changed.
locate AGTGroup String. It contains the correct SID.

Just copy the content of the AGTGroup string in the SQLGroup string.
AGTGroup = S-1-5-21-3474037693-4059913137-208468936-1004
SQLGroup = S-1-5-21-3474037693-4059913137-208468936-1003

In order to be sure of the SID of the group, you can launch getsid.
This article may help you find the correct group SID : http://blogs.msdn.com/b/jorgepc/archive/2009/11/19/the-domain-group-cannot-be-validated-for-the-service-sql-server-sql-server-2005-cluster-setup-error.aspx
You can use this tool to get SQLGroup SID : https://technet.microsoft.com/en-us/sysinternals/bb897417.aspx

Hope this article will help you

Create a simple Drupal 7 module - Hello World page

2013-10-08T23:03:00.000+02:00

A Drupal module is made at least by 2 elements :

a .info file
an other file (.php, .inc ?)

To choose a name for you module, don't forget those basic rules :

no capital letter
no special character (excepted _ underscore)

Your first .info file

A .info is in fact a your_module_name.info file.
Let's make in your example a drupal_test module.

name (mandatory)

The name of your module (with capital letters and spaces this time, if you want)

name = Drupal Test Module

description (recommended)

description = A super duper test module !

core (mandatory)

core = 7.x

files[]

The location of your (php ?) files
files[] = inc/example.php

The whole .info file

name = Drupal Test Module description = Provides a really neat widget for your site's sidebar. core = 7.x files[] =inc/example.php

For Drupal 7, you can find all informations about .info files here:
https://drupal.org/node/542202

Now the example.php file

You can now edit your php file, located in /sites/all/modules/drupal_test/inc/example.php

We will make a simple "Hello World" test. We will

make a menu link (make shortcut like http://www.mywebsite.com/drupal_test/mylink)
create a basic content (your "Hello World")

in your example.php module, create a drupal_test_menu() function.

function drupal_test_menu() {
    $items['drupal_test/mylink'] = array(
      'page callback' => 'drupal_test_hello_world',
    );
    return $items;
  }

This part redirects http://www.mywebsite.com/drupal_test/mylink to your website, and calls the

drupal_test_hello_world()function.

function drupal_test_hello_world() {
    return array(
      '#markup' => '<p>Hello world</p>', 
    );
  }

That's it !

If you have questions, i'll try to answer you. Do not hesitate to leave comments.

Drupal 7 - How to set permissions on your module using hook_permission() and user_access()

2013-06-10T13:38:00.001+02:00

You're developing a module and you need site administrator to handle with permissions.

There are two steps :

Make your permission string (such as "administer nodes" in the admin/people/permissions page)
Check if user has access to the defined string

Let's see how to do it.

We will use hook_permission() to add your own "string" in the permission management page.

function mymodulename_permission() {
  return array(
    'my own permission string' => array(
      'title' => t('Administer my module'),
      'description' => t('Perform administration tasks for my module.'),
    ),
  );
}

Now you can administer permissions for your module. Note that you can add many permissions strings in the array you return.
You can now find your permission string at this page : admin/people/permissions

When you're coding your page, you can user user_access() to check if the connected user has the given right.
```
$string = "my own permission string";
user_access($string)
```
the result is a boolean value. True if the user has access, False if not.
You can use user_access in the hook_menu() function. Here is an example :

function mymodulename_menu() { $items = array(); $items['mymodule-page-address'] = array(//this creates a URL that will call this form at "examples/form-example" 'title' => 'Menu link name', //page title 'description' => 'A form to mess around with.', 'page callback' => 'drupal_get_form', //this is the function that will be called when the page is accessed. for a form, use drupal_get_form 'page arguments' => array('my_callback_function'), //put the name of the form here 'access callback' => 'user_access', 'access arguments' => array('my own permission string'), ); return $items; }

Echange Certificate expires

2011-08-01T14:34:00.000+02:00

On SBS 2008, one year after the initial installation, your Exchange 2007 certificate will be expired.

Under Exchange Shell

Get-ExchangeCertificate | List

Locate the expired certificate and copy the footprint
Create a new certificate

New-ExchangeCertificate

Copy the new certificate thumbprint in order to activate it.

Enable-ExchangeCertificate -Thumbprint F7A8F1B443A0E7266C72CDE0603302C07B856076 -Service IIS

Then you can remove the old certificate.

Remove-ExchangeCertificate -Thumbprint 157700393E5D76615E855A773CFA08AB5842DFB0

After, you will need to install the new certificate to your computers. You can use GPO to do it.

How to fix Exchange 452 4.3.1 Insufficient system resources

2011-03-16T15:26:00.002+01:00

The first symptom : no incoming mails in your Exchange Organisation.
The first test to make : try to test your incoming SMTP service using telnet.
If you have the following result, you're reading the right post !

452 4.3.1 Insufficient system resources

If you have a quick look in your event log, you will find a 15002 event message, explaining you that your disk space is low. Here we are.
Different security levels are set in exchange, chained to different reactions : http://technet.microsoft.com/en-us/library/bb397220(EXCHG.80).aspx

Two ways to get out of this issue :

increase disk space
disable the Back Pressure Feature

For the first point, no lesson, just act as you are used to.
For the second point : Back Pressure Feature.
Differents triggers :

Disk space, memory, ...

Three levels :

Normal Action: The Exchange Server 2007 Server accepts new connections and messages.
Medium Action: The resources sre starting to be overused. Back pressure is applied to the server in a limited manner. Messages from senders in the authoritative domain can flow, but the server will reject new connections and messages from other sources.
High Action: A resource is being overused. All message flow will stop and the server will reject all new connections and messages.

To disable the Back Pressure Feature, you have to edit the file located in the bin folder of your exchange server : EdgeTransport.exe.config
Locate the EnableResourceMonitoring param and put the value to "false".
Restart the Exchange Transport Service using the exchange shell :

Restart-Service msExchangeTransport

Sources :

How to test SMTP server using telnet : here is the script

2011-03-16T15:06:00.000+01:00

telnet mail.mydomain.com 25
EHLO mydomain.com
MAIL FROM:chris@microsoft.com
RCPT TO:kate@mydomain.com NOTIFY=success,failure
DATA
Subject: Test depuis Contoso

This is a test message
.
QUIT

Source : http://technet.microsoft.com/fr-fr/library/bb123686.aspx
Simple version : http://exchange.mvps.org/smtp_frames.htm

How to deploy printers in Windows Server 2008 using GPO

2010-08-25T11:24:00.001+02:00

We will see how to deploy easily printers using GPO.

First of all, you have to install your printers on the server and share it.

Be carreful, if you are using a 64bits version (Windows Server 2008 R2 or SBS), you have to find the 64bits drivers.

Now you have to install the Print Services role on the server.

The role will be installed without restarting the server.

Deploy the printer.

To install printers to groups of users or computers by using Group Policy

Open the Administrative Tools folder, and then double-click Print Management.
In the Print Management tree, under the appropriate print server, click Printers.
In the results pane, right-click the printer you want to deploy, and then click Deploy with Group Policy.
In the Deploy with Group Policy dialog box, click Browse, and then choose a Group Policy object.
Click OK.
To assign the printer connection setting to the GPO, do one or both of the following:
As a per-user setting, select the The users that this GPO applies to (per user) check box.
As a per-machine setting, select the The computers that this GPO applies to (per machine) check box.
Click Add.
Repeat steps 3 to 6 to add the printer connection setting to another GPO.
Click OK.

Source :

http://technet.microsoft.com/en-us/library/cc722179(WS.10).aspx

How to transfer the 5 Active Directory roles from a server to an other

2010-08-23T14:45:00.021+02:00

The five roles

PDC emulator (one per domain): This role allows Windows Server to act as a Windows NT primary domain controller (PDC), and it provides replication support for Windows NT-based backup domain controllers (BDCs). In addition, this role assists with time and group policy synchronization.
Infrastructure master (one per domain): This role is responsible for updating the group-to-user references whenever the members of groups change or receive new names.
Relative ID (RID) master (one per domain): This role ensures that every object created has a unique identification number.
Schema master (one per forest): This role is responsible for maintaining and modifying the Active Directory schema.
Domain naming master (one per forest): This role is responsible for the addition and deletion of domains in a forest.

List actual roles

Schema owner server100.dpetri.net
Domain role owner server100.dpetri.net
PDC role server100.dpetri.net
RID pool manager server100.dpetri.net
Infrastructure owner server100.dpetri.net
The command completed successfully.
Diffrents ways to move the roles

Using NTDSUtil.exe :
ntdsutil
roles
connections
connect to server ServerName
quit
transfer infrastructure master
transfer naming master
transfer PDC
transfer RID master
transfer schema master
quit
Using GUI
See this article

Sources :

Familiarize yourself with Active Directory's five FSMO roles

Install Desktop and Laptop Option (DLO) on Backup Exec 2010

2010-08-23T12:14:00.002+02:00

First of all, you might have installed BE 2010 on your server.
Open ports in the firewall.
SMB communication / 135-139 TCP/UDP

SMB) communication without NETBIOS / 445 TCP/UDP

SQL / 1434 TCP/UDP

DLOAdminSvcu.exe (DLO admin service) / 3999 in listening mode TCP/UDP

Configure SQL Server to use Named Pipes

Once this done, you have to enable named pipes in your SQLServer instance.

Prepare the configuration for the clients

In BE, go to Tools, Desktop and Laptop Option

You will meet three wizards :

The first to create a profile. A profile allows you to define the directories you want to save on the differents client computers.
The second to define a storage place. You have to select a folder on your server. DLO will share it automatically
The third to map users or groups with a profile and a storage place. You can select either a group or a user.

Installation on clients

You can install the DLO agent manually or using GPO ou a startup script.

Manually : go to file://server/DLOAgent and launch setup.exe Don't launch the .msi file, it would not work, and you will be forced uninstall and reinstall using setup.exe
Install via GPO : run file://server/DLOAgent/setup.exe using usual command lines switches
Push manually on selected computers : using Tools -> Install Agents and Media Servers on Other Servers

Once installed on clients, you will find your users and computers in the DLO administration tool.

Can be usefull :

Before you install DLO

Put Exchange 2000 Organization in Native Mode

2010-08-17T16:34:00.000+02:00

How to put an Exchange 2000 server in Exchange 2000 Native Mode :

All your pre-exchange 2000 servers must be decommissionned before you can put your Exchange server in native mode.

Go to your Exchange Manager, right-click on your organization's name (first icon, top of the tree), and then set the organisation to Native Mode.

Updating Microsoft Exchange 2000

2010-08-17T16:11:00.011+02:00

This quick article will show you the easiest ways to update Microsoft Exchange 2000 :

From Microsoft Update
From Microsoft Web Site

Latest Service Packs :

Exchange 2000

Exchange 2000 Service Pack 3 (SP3) - Download | Fix list
Exchange 2000 Server post-Service Pack 3 update rollup - Download | More informations

Exchange 2003

Exchange 2003 Service Pack 1 (SP1) - Download | Fix list
Exchange 2003 Service Pack 2 (SP2) - Download | Fix list

Liste des ports à ouvrir pour Symantec Endpoint 11

2010-08-17T15:50:00.003+02:00

Voici la liste des ports à ouvrir pour permettre à Symantec EndPoitnt 11 de fonctionner :

Port Number	Port Type	Initiated by	Listening Process	Description
80, 8014	TCP	SEP Clients	svchost.exe (IIS)	Communication between the SEPM manager and SEP clients and Enforcers. (8014 in MR3 and later builds, 80 in older).
443	TCP	SEP Clients	svchost.exe (IIS)	Optional secured HTTPS communication between a SEPM manager and SEP clients and Enforcers.
1433	TCP	SEPM manager	sqlservr.exe	Communication between a SEPM manager and a Microsoft SQL Database Server if they reside on separate computers.
1812	UDP	Enforcer	w3wp.exe	RADIUS communication between a SEPM manager and Enforcers for authenticating unique ID information with the Enforcer.
2638	TCP	SEPM manager	dbsrv9.exe	Communication between the Embedded Database and the SEPM manager.
8443	TCP	Remote Java or web console	SemSvc.exe	HTTPS communication between a remote management console and the SEPM manager. All login information and administrative communication takes place using this secure port.
9090	TCP	Remote web console	SemSvc.exe	Initial HTTP communication between a remote management console and the SEPM manager (to display the login screen only).
8005	TCP	SEPM manager	SemSvc.exe	The SEPM manager listens on the Tomcat default port.
39999	UDP	Enforcer		Communication between the SEP Clients and the Enforcer. This is used to authenticate Clients by the Enforcer.
2967	TCP	SEP Clients	Smc.exe	The Group Update Provider (GUP) proxy functionality of SEP client listens on this port.

Migration Exchange 2000 vers Exchange 2007 (SBS2008)

2010-08-17T15:37:00.008+02:00

Pour ce premier article, je vais vous parler de la migration d'Exchange 2000 vers Exchange 2007 depuis Windows SBS 2008.

Voici les différentes étapes à réaliser :

Mettre à jour vos serveurs Exchange 2000 (possible via Windows Update)
Mettre l'organisation Exchange en mode Native
Augmenter le niveau fonctionnel du domaine Active Directory
Mettre à jour le schema Exchange pour accueil l'organisation 2007
Sur une serveur doté au moins de Windows Server 2003, lancez

setup.com /PrepareLegacyExchangePermissions
setup.com /PrepareSchema
setup.com /PrepareAD

Installer Exchange 2007

Installation Typique, dans Mail Flow Settings, choisir le serveur Exchange avec lequel vous souhaitez créer un groupe de routage,

Enfin, vous pourrez migrer vos boîtes aux lettres.