Sunday, November 20, 2011

Fix for windows/system32/config/system missing or corrupt

Boot from windows xp cd & select R for recovery concel on the first option then use


chkdsk /r


when this will be finished then Reboot the system System will be able to boot.


if its not working repeat the same procedure once again.

Thursday, November 17, 2011

Some Duplicates in Mysql

 

Some useful tips for Duplicates in Mysql
To findout the duplicate entries(Name) in a table
SELECT Name, count(id) as cnt FROM list GROUP BY Name HAVING cnt > 1

While insert operation if we got the primary key already exist then we can update the row as
Insert into list (Name,address) values('xxx','yyy') on duplicate update Name='xxx'

Tuesday, November 8, 2011

Create a Push Notification certificate in iPhone Developer Program Portal

To generate a certificate on a Mac OS X:


    1. Log-in to the iPhone Developer Program Portal

    2. Choose App IDs from the menu on the right (or click here)

    3. Create an App ID without a wildcard. For example 3L223ZX9Y3.com.armiento.test

    4. Click the Configure link next to this App ID and then click on the button to start the wizard to generate a new Development Push SSL Certificate (Apple Documentation: Creating the SSL Certificate and Keys)

    5. Download this certificate and double click on aps_developer_identity.cer to import it into your Keychain

    6. Launch Keychain Assistant (located in Application, Utilities or search for it with Spotlight) and click on My Certificates on the left

    7. Expand Apple Development Push Services and select Apple Development Push Services AND your private key (just under Apple Development Push Services)

    8. Right-click and choose "Export 2 elements..." and save as server_certificates_bundle_sandbox.p12 (don't type a password).

    9. Open Terminal and change directory to location used to save server_certificates_bundle_sandbox.p12 and convert the PKCS12 certificate bundle into PEM format using this command (press enter when asked for Import Password):



 
openssl pkcs12 -in server_certificates_bundle_sandbox.p12 -out server_certificates_bundle_sandbox.pem -nodes -clcerts

Now you can use this PEM file as your certificate in ApnsPHP!

“NTLDR is missing” problem in Windows XP.

NTLDR is the boot loader for Windows NT operating systems including
Windows XP.It runs from primary hard drive to load the OS selected from
the startup menu with the help of boot sector in a file.

Components important to load OS:
NTLDR: contains boot loader
boot.ini : system file which stores list of Operating Systems
to be shown at start up .
ntdetect.com: detects basic hardware required to start the operating system.
ntoskrnl.exe/ntkrnlpa.exe : stores kernal image of Windows NT systems &
responsible for various system services such as hardware virtualisation process and memory management, etc.

Here’s how u can get back into your Windows XP.
1. Insert the Windows XP bootable CD into the computer.
2. When prompted to press any key to boot from the CD, press any key.
3. Once in the Windows XP setup menu press the “R” key to repair Windows.
4. Log into your Windows installation by pressing the “1″ key and pressing enter.
5. You will then be prompted for your administrator password, enter that password(Usually it is
password,if not set)
6. Copy the below two files to the root directory of the primary hard disk.
The CD-ROM drive letter may be different on your computer.
Here it is “e.”

copy e:\i386\ntldr c:\
copy e:\i386\ntdetect.com c:\


7. Once both of these files have been successfully copied, remove the CD from the computer and reboot.