How to check IBM x3650 RAID configuration in window server?

How to check whether the RAID configuration in IBM x3650 M4 is correct in Window Server 2012? I have done my RAID configuration using IBM Server Guide 9.4 and now i want to check the setting in IS which is Window Server 2012. There is a tools call MegaRAID Storage Manager which is able to download from IBM website. You need to install the tool in your OS and you can check the RAID setting using this tool.

How to know IBM X3650 M4 IMM IP Address?

Most of the article stated that IMM default IP is 192.168.70.125 but it's not in my case. I try to figure out the IP because i want to access to IMM2 web interface to install key for Features On Demand (fod). In order to get the IP, i have downloded IBM Advanced Settings Utility (ASU) and unzip it into my C drive. Use command prompt to local ASU.exe or ASU64.exe.

type command asu64 show

It will shows many information but the first information will be displayed in the IP Address. You can to check on it quickly before it jump to the end. By the way, my IMM IP is 169.254.95.118.

'powershell' is not recognized as an internal or external command, operable program, or batch file.

Try to install/enable GUI in windows server 2012 but first thing we need to do is use powershell. When i try to use this powershell command, it shows error message

'powershell' is not recognized as an internal or external command, operable program, or batch file.

What we can do is execute command below one by one

dism.exe /online /enable-feature /featurename:MicrosoftWindowsPowerShellRoot
dism.exe /online /enable-feature /featurename:MicrosoftWindowsPowerShell /all

and remember to restart the server before continue.

Error: Failed to retrieve directory listing

I'm trying to connect to my hosting site using filezilla and hit error


Command: LIST
Response: 150 Opening BINARY mode data connection.
Error: Could not read from transfer socket: ECONNRESET - Connection reset by peer
Response: 550
Error: Failed to retrieve directory listing

This is a big trouble for me because cannot update/upload my latest file into the server.

Finally found that the problem can be solved by change the transfer mode to passive in the Site Manager.

Now can upload the file like normal.

Enable TCP/IP Protocol and set Login mode to Mixed mode in C#

Try to enable Microsoft SQL Server 2008 TCP/IP Protocol and set the Login mode to Mixed mode using C# without involve registry. Come across information below http://stackoverflow.com/questions/2266697/changing-sql-server-settings-programmatically

The information is really helpful but when try it in SQL Server 2008 using the C# source code given, it's not working very well. Then try to do some testing and finally it's work. I've added a line srv.Settings.Alter();



private static bool SetServerProperties()
    {
        #region standardize Connection String
        string tempCatalog = "master";
        string temp = @"Data Source=" + dataSource + ";Initial Catalog=" + tempCatalog + ";Integrated Security=True;MultipleActiveResultSets=True";
        #endregion

        SqlConnection sqlconnection = new SqlConnection(temp);
        SqlCommand cmd = new SqlCommand("select @@ServerName", sqlconnection);
        sqlconnection.Open();
        string serverName = "";
        try
        {
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
                serverName = dr[0].ToString();
        }
        catch
        {
            MessageBox.Show("Failed to Set SQL Server Properties for remote connections.");
        }

        Server srv = new Server(serverName);
        srv.ConnectionContext.Connect();
        srv.Settings.LoginMode = ServerLoginMode.Mixed;
srv.Settings.Alter(); 

        ManagedComputer mc = new ManagedComputer();

        try
        {
            Service Mysvc = mc.Services["MSSQL$" + serverName.Split('\\')[1]];

            if (Mysvc.ServiceState == ServiceState.Running)
            {
                Mysvc.Stop();
                Mysvc.Alter();

                while (!(string.Format("{0}", Mysvc.ServiceState) == "Stopped"))
                {
                    Mysvc.Refresh();
                }
            }

            ServerProtocol srvprcl = mc.ServerInstances[0].ServerProtocols[2];
            srvprcl.IsEnabled = true;
            srvprcl.Alter();


            Mysvc.Start();
            Mysvc.Alter();

            while (!(string.Format("{0}", Mysvc.ServiceState) == "Running"))
            {
                Mysvc.Refresh();
            }
            return true;
        }
        catch
        {
            MessageBox.Show("TCP/IP connectin could not be enabled.");
            return false;
        }
    }


Thanks to http://stackoverflow.com/users/1635051/reza-ameri

EC2: Access to PHP (Apache) in windows server

My Amazon EC2 is running in Windows 2008 Server R2 with IIS. I can access to aspx pages via Elastic IP http://xxx.xxx.xxx.xxx easily without any problem.

Now i want to have my php application with Apache running in the same server with same IP but port http://xxx.xxx.xxx.xxx:81 to display in the web

There are mainly 3 important steps

1. Change httpd.config (configuration file for apache)
   Find line with Listen xxx.xxx.xxx.xxx (or localhost) and change to Listen 0.0.0.0:81
   Find line with ServerName  xxx.xxx.xxx.xxx  (or localhost)  and change to ServerName  0.0.0.0:81
   Save the file and restart apache 
2. Go to windows firewall and add Port 81 in inbound rules
   
   
3. Add Port 81 to EC2 Security Group. Remember to apply the rule after added.
   
   

Done. It's work like charm!

Paper jam in HP LaserJet 3050 series (3052)

This is difficult. Normally when a paper stuck / jam in LaserJet 3050 series (my case is 3052), we can open the printer lid, take out the toner cartridge and pull the paper out. Close the lid and can print again. 

 

In case, i cannot see any paper jam/stuck after take out the toner cartridge but i know it's jam inside there. I've tried to turn off the printer for one minute and turn on again. I can hear the warming up sound is different from usual but when i try to check to see any paper stuck inside there, i can't find any. The paper is hidden inside some where. BIG ISSUE.

Finally, i found something. I followed the instruction below and try to clean the paper path.

It's work. The paper successfully pull out by the printer.

For those who not understand what is all-in-one control panel, please refer to photo below

 

This save my time and money with no need to send to repair.

This is the paper that cause me a lots of trouble.

How to block facebook apps / games request

It's very annoying that the friends send the same facebook app request again and again.This article shows how to block same facebook apps or facebook game request in future.

Click on App Center

In App Center, click on Requests

Click on "X" on the app that you wish to block

Click on Block xxxxxx

Done.

Check on video below to have better understanding.

The bulk load failed. The column is too long in the data file for row 1, column x. Verify that the field terminator and row terminator are specified correctly.

Hit error below when try to execute bulk insert script

Msg 4866, Level 16, State 1, Line 3
The bulk load failed. The column is too long in the data file for row 1, column 6. Verify that the field terminator and row terminator are specified correctly.
Msg 7399, Level 16, State 1, Line 3
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 3
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

(0 row(s) affected)

Script that hit error:

CREATE TABLE GeoIPCountryWhois2
(
[startIp] [nvarchar](50) NULL,
[endIp] [nvarchar](50) NULL,
[startIpNum] [nvarchar](50) NULL,
[endIpNum] [nvarchar](50) NULL,
[CountryCode] [nvarchar](50) NULL,
[Country] [nvarchar](150) NULL
) ON [PRIMARY]
GO


BULK INSERT GeoIPCountryWhois2
FROM 'C:\GeoIPCountryWhois.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '/n'

)
GO
--Check the content of the table.
SELECT *
FROM GeoIPCountryWhois2
GO

Fix:

CREATE TABLE GeoIPCountryWhois2
(
[startIp] [nvarchar](50) NULL,
[endIp] [nvarchar](50) NULL,
[startIpNum] [nvarchar](50) NULL,
[endIpNum] [nvarchar](50) NULL,
[CountryCode] [nvarchar](50) NULL,
[Country] [nvarchar](150) NULL
) ON [PRIMARY]
GO


BULK INSERT GeoIPCountryWhois2
FROM 'C:\GeoIPCountryWhois.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '0x0a'
)
GO
--Check the content of the table.
SELECT *
FROM GeoIPCountryWhois2
GO

Mars power bank 3000 mAh review

Recently bought a external battery charger for my Samsung mobile phone called Mars Power Bank 3000 mAh.

Since the instruction or manual behind the box written in Chinese, i will share this in English so that more people can understand how it's work.

The description is rather brief as below:

• Please read the instruction behind this box before using this.
• This product suitable to use in most smart phone and digital camera.
• Please recharge this product at least once if didn't use for a period of 3 months.
• During the charging process, you can feel slight heat which is normal.  
• Please make sure this product in dry condition. Please do not clear this product with chemical cleanser.

For: Fix for various mobile and devices

Capacity: 3000 mAh

Input: DC 5V -1000mAh (Max)

Output: DC 5V -1000 mAh (Max)

Mentioned in the box, this device support most of the mobile phone brand like Apple, Samsung, Nokia and etc. 

It's very flexible where user can change the adapter to suit the different needs.

Adapters that come with this external battery

For my case, i recharge this external charger with my USB adapter. 

How we know that it's fully charged? There is a LED light indicator. When you start to charge the power bank, the LED is in Red color. Once fully charged, it will turn to Blue. It will takes about 2-3 hours.

Once it's fully charge, you can use it to charge you smart phone and it should work like charm. It will takes 2-3 hours to get the handphone battery fully charge. I'm using Samsung Galaxy S2

Is it safe? Mentioned in the Box, it's certified by CE. I guess it's safe.