SQL Reporting Services - You Own It So Why Not Use It?
Many senior level executives and IT Professionals are not aware of an extremely powerful report writer that is already part of their database SQL Server installation and it’s free!
This report writer has come a long way from its initial SQL 2000 debut. With the newest release under SQL 2008, SQL Reporting Services or SSRS as its’ known, delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.
SQL Server Reporting Services combines a single, complete reporting platform with a scalable and extensible architecture to meet a wide variety of reporting needs, including:
o Enterprise reporting. Enterprises can use Reporting Services for their operational reporting or business intelligence applications. Using Reporting Services, corporate IT staff can design a variety of reports and deploy them to individuals throughout the enterprise.
o Ad-hoc reporting. SQL Reporting Services includes Report Builder 2.0, a new ad-hoc reporting tool that enables business users to create their own reports and explore corporate data. Report Builder incorporates a user-friendly business query model that enables users to build reports without deep technical understanding of the underlying data sources.
o Automated Subscriptions. Users can create reports and have the system automatically run the reports at specific times along with distribution of those reports via multiple methods such as email in different formats including CSV, PDF and Excel.
o Embedded reporting. Organizations can access predefined or ad-hoc reports from third-party applications that use Reporting Services and use these reports as-is, customize them, or create new ones for specific business needs.
o Web-based reporting for internal users and customers. Organizations can deploy interactive Web-based reports to deliver information to customers or partners over extranets or the Internet. SSRS isolates report consumers from the complexity of the underlying data sources, while providing personalization and interactivity.
Whether you want to outsource or do it yourself, NGL has onboard staff experts that can help your organization configure, train personnel, and write sophisticated reports that leverage your existing database investment!
Thursday, August 4, 2011
Advanced Matrix Reporting Techniques
SQL Reporting Services - You Own It So Why Not Use It?
Many senior level executives and IT Professionals are not aware of an extremely powerful report writer that is already part of their database SQL Server installation and it’s free!
This report writer has come a long way from its initial SQL 2000 debut. With the newest release under SQL 2008, SQL Reporting Services or SSRS as its’ known, delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.
SQL Server Reporting Services combines a single, complete reporting platform with a scalable and extensible architecture to meet a wide variety of reporting needs, including:
o Enterprise reporting. Enterprises can use Reporting Services for their operational reporting or business intelligence applications. Using Reporting Services, corporate IT staff can design a variety of reports and deploy them to individuals throughout the enterprise.
o Ad-hoc reporting. SQL Reporting Services includes Report Builder 2.0, a new ad-hoc reporting tool that enables business users to create their own reports and explore corporate data. Report Builder incorporates a user-friendly business query model that enables users to build reports without deep technical understanding of the underlying data sources.
o Automated Subscriptions. Users can create reports and have the system automatically run the reports at specific times along with distribution of those reports via multiple methods such as email in different formats including CSV, PDF and Excel.
o Embedded reporting. Organizations can access predefined or ad-hoc reports from third-party applications that use Reporting Services and use these reports as-is, customize them, or create new ones for specific business needs.
o Web-based reporting for internal users and customers. Organizations can deploy interactive Web-based reports to deliver information to customers or partners over extranets or the Internet. SSRS isolates report consumers from the complexity of the underlying data sources, while providing personalization and interactivity.
Whether you want to outsource or do it yourself, NGL has onboard staff experts that can help your organization configure, train personnel, and write sophisticated reports that leverage your existing database investment!
Many senior level executives and IT Professionals are not aware of an extremely powerful report writer that is already part of their database SQL Server installation and it’s free!
This report writer has come a long way from its initial SQL 2000 debut. With the newest release under SQL 2008, SQL Reporting Services or SSRS as its’ known, delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.
SQL Server Reporting Services combines a single, complete reporting platform with a scalable and extensible architecture to meet a wide variety of reporting needs, including:
o Enterprise reporting. Enterprises can use Reporting Services for their operational reporting or business intelligence applications. Using Reporting Services, corporate IT staff can design a variety of reports and deploy them to individuals throughout the enterprise.
o Ad-hoc reporting. SQL Reporting Services includes Report Builder 2.0, a new ad-hoc reporting tool that enables business users to create their own reports and explore corporate data. Report Builder incorporates a user-friendly business query model that enables users to build reports without deep technical understanding of the underlying data sources.
o Automated Subscriptions. Users can create reports and have the system automatically run the reports at specific times along with distribution of those reports via multiple methods such as email in different formats including CSV, PDF and Excel.
o Embedded reporting. Organizations can access predefined or ad-hoc reports from third-party applications that use Reporting Services and use these reports as-is, customize them, or create new ones for specific business needs.
o Web-based reporting for internal users and customers. Organizations can deploy interactive Web-based reports to deliver information to customers or partners over extranets or the Internet. SSRS isolates report consumers from the complexity of the underlying data sources, while providing personalization and interactivity.
Whether you want to outsource or do it yourself, NGL has onboard staff experts that can help your organization configure, train personnel, and write sophisticated reports that leverage your existing database investment!
Thursday, March 31, 2011
How to Run Mac OS X in VirtualBox on Windows
How to Run Mac OS X in VirtualBox on Windows
How to Run Mac OS X in VirtualBox on Windows
Bobby Patton — If you're on Windows, need to use OS X, but don't want to buy or build a new computer, reader Bobby Patton shows us how to run Snow Leopard in a virtual machine on Windows with just a few tweaks.
We've shown you how to install Snow Leopard in VMWare, but if you haven't purchased VMWare, you can now do it using previously mentioned, free program VirtualBox. Apart from VirtualBox, you'll also need an OSX86 ISO. The group Hazard has put out a good patched Snow Leopard installer that should do fine (just search for it on Google). Of course, if you feel bad about downloading the ISO of Snow Leopard, you could always go buy a copy to feel a bit better, karmically.
After you have them both, install Virtualbox. Open up Virtualbox and click on New at the top left.
At the Create New Virtual Machine window, click Next.
At this window type OSX as the name and it will automatically change the system and version. The next window will let you choose your RAM amount:
If you can spare it, crank it up as far as you can go, but 1024MB should be sufficient.
This is where you'll make your hard disk. 20GB should be enough so what it comes down to is dynamic or static. Dynamic will expand on use and Static will be a fixed 20GB no matter how much data is actually in it. Dynamic is better for not taking up your hard drive but static should give you better performance. I normally use dynamic. Click next unless you want to change it from dynamic or if you want to increase the disk size or file location.
It will show a summary of your settings. Click Finish, then click Settings at the top. At this window click on System in the left pane and uncheck Enable EFI.
Now click on the Storage button on the left. From there click on Empty under the OSX.vdi, then click the folder with the green arrow on the right (next to "CD/DVD Device").
At this window click the Add button at the top. Then find and add the OSX86 ISO you downloaded earlier. Then highlight it and click Select at the bottom. Then click OK, and hit the Start button on the left side of the main VirtualBox window.
As it starts up, click inside the window and hit F8. Then at the boot: prompt type –v so you can see what exactly went wrong if something does go wrong. All the services will run and eventually you should come to the language screen. Choose your language then click next. If you are unable to move your mouse around then hit Right-Ctrl + I. Click Continue and Agree. Next, start up Disk Utility by going to Utilities in the menu bar.
At this screen highlight 20GB VBOX HARDDISK. Then click the Erase tab, name it what you want in the name box and click the Erase button on the bottom right of the window. It shouldn't take long. Then click Disk Utility in your menu bar and quit it. Now you're back at the installer. Highlight the drive that is now showing up and click Continue.
The next window is important. Click the Customize button on the bottom left.
AMD Users check:
Any Updates included at the top.
Drop down Kernels and choose Legacy kernel.
AMD option below System support.
Intel Users check:
Any Updates included at the top.
Drop down bootloaders and check the newest Chameleon.
Drop down Kernels and choose Legacy kernel.
Then click Done and hit the Install button. To speed up the process you can click Skip when the disc check pops up.
As soon as it says "installation finished" and starts counting down to restart, press the right Ctrl key. Click on Devices at the top of the VirtualBox window, hit CD/DVD Devices and click Unmount CD/DVD Device. Then go to Machine > Reset and click Reset at the prompt. Next you'll see the Chameleon loader and then OS X will begin to boot.
After it boots you will see the setup screens for OS X! You're good to go. The only hiccup I've found is that it can only be virtualized with one core. It could be the OSX disc I was using or it might not be. And I have yet to find the right kext that will allow audio to work and the resolution is limited also. But other than that you'll have a fully functioning OSX virtualized!
Update: I'd like to post some answers to the resolution and audio. I should have looked around before posting this but I just didn't have the time. So anyways heres what you can do:
To fix the resolution issue, open Finder and go to the OS X drive on the left. Open the folder called Extras. Right Click on the file com.Apple.Boot.plist and open it with TextEdit. Under the first insert this:
Graphics Mode
1280x1024x32
or another compatible resolution. Select "Save As" at the top and save it to the desktop, unchecking the check under Unicode and then save it as com.apple.boot.plist. After that drag and drop it into the extras folder and overwrite the original file, entering your password when prompted.
Instructions for the sound issue can be found here.
Don't install system updates. If you want updates you'll have to install another iso distribution with the updates on it. If you install the updates directly from apple it messes with the custom kexts and chameleon. Just a forewarning.
And for those of you getting boot issues try choosing a different version of Chameleon or a different kernel. Sometimes that seems to help. And If your getting one of the USB errors then try disabling USB in the VirtualBox settings and see if that helps.
OSX in Virtual Box (Hackintoshed VM) [Tek411]
How to Run Mac OS X in VirtualBox on Windows
Bobby Patton — If you're on Windows, need to use OS X, but don't want to buy or build a new computer, reader Bobby Patton shows us how to run Snow Leopard in a virtual machine on Windows with just a few tweaks.
We've shown you how to install Snow Leopard in VMWare, but if you haven't purchased VMWare, you can now do it using previously mentioned, free program VirtualBox. Apart from VirtualBox, you'll also need an OSX86 ISO. The group Hazard has put out a good patched Snow Leopard installer that should do fine (just search for it on Google). Of course, if you feel bad about downloading the ISO of Snow Leopard, you could always go buy a copy to feel a bit better, karmically.
After you have them both, install Virtualbox. Open up Virtualbox and click on New at the top left.
At the Create New Virtual Machine window, click Next.
At this window type OSX as the name and it will automatically change the system and version. The next window will let you choose your RAM amount:
If you can spare it, crank it up as far as you can go, but 1024MB should be sufficient.
This is where you'll make your hard disk. 20GB should be enough so what it comes down to is dynamic or static. Dynamic will expand on use and Static will be a fixed 20GB no matter how much data is actually in it. Dynamic is better for not taking up your hard drive but static should give you better performance. I normally use dynamic. Click next unless you want to change it from dynamic or if you want to increase the disk size or file location.
It will show a summary of your settings. Click Finish, then click Settings at the top. At this window click on System in the left pane and uncheck Enable EFI.
Now click on the Storage button on the left. From there click on Empty under the OSX.vdi, then click the folder with the green arrow on the right (next to "CD/DVD Device").
At this window click the Add button at the top. Then find and add the OSX86 ISO you downloaded earlier. Then highlight it and click Select at the bottom. Then click OK, and hit the Start button on the left side of the main VirtualBox window.
As it starts up, click inside the window and hit F8. Then at the boot: prompt type –v so you can see what exactly went wrong if something does go wrong. All the services will run and eventually you should come to the language screen. Choose your language then click next. If you are unable to move your mouse around then hit Right-Ctrl + I. Click Continue and Agree. Next, start up Disk Utility by going to Utilities in the menu bar.
At this screen highlight 20GB VBOX HARDDISK. Then click the Erase tab, name it what you want in the name box and click the Erase button on the bottom right of the window. It shouldn't take long. Then click Disk Utility in your menu bar and quit it. Now you're back at the installer. Highlight the drive that is now showing up and click Continue.
The next window is important. Click the Customize button on the bottom left.
AMD Users check:
Any Updates included at the top.
Drop down Kernels and choose Legacy kernel.
AMD option below System support.
Intel Users check:
Any Updates included at the top.
Drop down bootloaders and check the newest Chameleon.
Drop down Kernels and choose Legacy kernel.
Then click Done and hit the Install button. To speed up the process you can click Skip when the disc check pops up.
As soon as it says "installation finished" and starts counting down to restart, press the right Ctrl key. Click on Devices at the top of the VirtualBox window, hit CD/DVD Devices and click Unmount CD/DVD Device. Then go to Machine > Reset and click Reset at the prompt. Next you'll see the Chameleon loader and then OS X will begin to boot.
After it boots you will see the setup screens for OS X! You're good to go. The only hiccup I've found is that it can only be virtualized with one core. It could be the OSX disc I was using or it might not be. And I have yet to find the right kext that will allow audio to work and the resolution is limited also. But other than that you'll have a fully functioning OSX virtualized!
Update: I'd like to post some answers to the resolution and audio. I should have looked around before posting this but I just didn't have the time. So anyways heres what you can do:
To fix the resolution issue, open Finder and go to the OS X drive on the left. Open the folder called Extras. Right Click on the file com.Apple.Boot.plist and open it with TextEdit. Under the first insert this:
Graphics Mode
1280x1024x32
or another compatible resolution. Select "Save As" at the top and save it to the desktop, unchecking the check under Unicode and then save it as com.apple.boot.plist. After that drag and drop it into the extras folder and overwrite the original file, entering your password when prompted.
Instructions for the sound issue can be found here.
Don't install system updates. If you want updates you'll have to install another iso distribution with the updates on it. If you install the updates directly from apple it messes with the custom kexts and chameleon. Just a forewarning.
And for those of you getting boot issues try choosing a different version of Chameleon or a different kernel. Sometimes that seems to help. And If your getting one of the USB errors then try disabling USB in the VirtualBox settings and see if that helps.
OSX in Virtual Box (Hackintoshed VM) [Tek411]
Jailbreak 4.3.1 - PwnageTool Jailbreak [How to] - Jailbreak 4.2.1 - 4.3 - 4.3.1 - Unlock Jailbreak iMac iPhone 4 - 3GS - 3G - iPod - iPad
Jailbreak 4.3.1 - PwnageTool Jailbreak [How to] - Jailbreak 4.2.1 - 4.3 - 4.3.1 - Unlock Jailbreak iMac iPhone 4 - 3GS - 3G - iPod - iPad
iOS 4.3.1 has been successfully jailbroken on iPhone, iPod touch and iPad. But you have to know that it's a tethered jailbreak for now which means that you will have to boot it into jailbroken state every time you reboot. You can follow the step by step guide below to jailbreak iOS 4.3.2 on iPhone 4 using combination of PwnageTool 4.2, Universal Ramdisk Fixer and tetheredboot utility.
Here’s what you will need:
PwnageTool 4.2
iOS 4.3.1 firmware
iTunes 10.2.1
Mac OS X
PwnageTool bundle for iOS 4.3.1
Universal Ramdisk Fixer
tetheredboot utility
Note:
There is no unlock for the new baseband on iOS 4.3.1. If your iPhone relies on a carrier unlock, DO NOT update to stock iOS 4.3.1.
iPad 2 users on iOS 4.3 should stay away from iOS 4.3.1 until further confirmation.
Cydia is fully working on iOS 4.3.1
It is a semi-tethered jailbreak.
Your baseband will not be upgraded during restore process.
Modifying PwnageTool
Step 1: Download PwnageTool bundle for your version of iOS device. Extract the .zip folder, in there you will find a .bundle file, for this guide, we are using iPhone 4 bundle iPhone3,1_4.3.1_8G4.bundle. Move this file to your desktop.
Step 2: Download PwnageTool 4.2 and copy it to /Applications directory. Right click, and then click on “Show Package Contents” as shown in the screenshot below.
Step 3: Navigate to Contents/Resources/FirmwareBundles/ and paste iPhone3,1_4.3.1_8G4.bundle file in this location.
Creating Custom Ramdisk for iOS 4.3.1 Custom Firmware
Step 4: Download Universal Ramdisk Maker and simply install it as shown in the screenshots below. This is important because Ramdisk in the current version of PwnageTool is broken. This Universal Ramdisk Maker basically patches it correctly for iOS 4.3.1 firmware.
Building iOS 4.3.1 Custom Firmware
Step 5: Download iOS 4.3.1 firmware. Move this file to your desktop.
Step 6: Start PwnageTool in “Expert mode” and select your device:
Step 7: Browse for iOS 4.3.1 firmware for your device as shown in the screenshot below:
Step 8: Now select “Build” to start creating custom 4.3.1 firmware file:
Step 9: PwnageTool will now create the custom .ipsw file for your iPhone which will be jailbroken.
Step 10: Now follow the following steps to enter DFU mode using PwnageTool:
Hold Power and Home buttons for 10 seconds
Now release the Power button but continue holding the Home button for 10 more seconds
You device should now be in DFU mode
Restore iOS 4.3.1 Custom Firmware Using iTunes
Step 11: Start iTunes, click on your iOS device icon from the sidebar in iTunes. Now press and hold left “alt” (option) button on Mac, or Left “Shift” button if you are on Windows on the keyboard and then click on “Restore” (Not “Update” or “Check for Update”) button in the iTunes and then release this button.
This will make iTunes prompt you to select the location for your custom firmware 4.3.1 file. Select the required custom .ipsw file that you created above, and click on “Open”.
Step 12: Now sit back and enjoy as iTunes does the rest for you. This will involve a series of automated steps. Be patient at this stage and don’t do anything silly. Just wait while iTunes installs the new firmware 4.3.1 on your iOS device. Your iOS device screen at this point will be showing a progress bar indicating installation progress. After the installation is done, your iOS device will be jailbroken on iOS 4.3.1.
Booting in Tethered Mode
Last but not the least, since there is no untethered jailbreak for iOS 4.3.1 yet, we will have to boot it into a tethered jailbroken state. To do this, we will make use of a utility named “tetheredboot” as shown in the steps below.
Step 13: Download tetheredboot.zip utility for Mac OS X and extract the .zip file.
Step 14: First, we will need two files from the custom iOS 4.3.1 firmware namely: kernelcache.release.n90 and iBSS.n90ap.RELEASE.dfu. To do this, make a copy of your custom iOS 4.3.1 file that you created above, change the extension of this file from .ipsw to .zip, and then extract this .zip file.
Now copy kernelcache.release.n90 file, and then copy iBSS.n90ap.RELEASE.dfu files which are found under /Firmware/dfu/.
Move all these files, and tetheredboot utility to a new folder named “tetheredboot” on the desktop as shown in the screenshot below.
Step 15: Turn off your iOS device, and start Terminal on OS X and run the following commands:
sudo -s
enter your administrator password, then:
/Users/TaimurAsad/Downloads/tetheredboot/tetheredboot
/Users/TaimurAsad/Downloads/tetheredboot/iBSS.n90ap.RELEASE.dfu
/Users/TaimurAsad/Downloads/tetheredboot/kernelcache.release.n90
You will have to of course replace “TaimurAsad” with the name of the directory on your computer.
now press enter.
You should now see some code running in the Terminal window, at some point, it will ask you to enter DFU mode. Now follow the following steps to enter DFU mode:
Hold Power and Home buttons for 10 seconds
Now release the Power button but continue holding the Home button for 10 more seconds
You device should now be in DFU mode
Now wait for your device to boot, Terminal at this point will be showing “Exiting libpois0n” message. After a short while, your iPhone, iPad or iPod touch will be booted in a jailbroken tethered mode !
iOS 4.3.1 has been successfully jailbroken on iPhone, iPod touch and iPad. But you have to know that it's a tethered jailbreak for now which means that you will have to boot it into jailbroken state every time you reboot. You can follow the step by step guide below to jailbreak iOS 4.3.2 on iPhone 4 using combination of PwnageTool 4.2, Universal Ramdisk Fixer and tetheredboot utility.
Here’s what you will need:
PwnageTool 4.2
iOS 4.3.1 firmware
iTunes 10.2.1
Mac OS X
PwnageTool bundle for iOS 4.3.1
Universal Ramdisk Fixer
tetheredboot utility
Note:
There is no unlock for the new baseband on iOS 4.3.1. If your iPhone relies on a carrier unlock, DO NOT update to stock iOS 4.3.1.
iPad 2 users on iOS 4.3 should stay away from iOS 4.3.1 until further confirmation.
Cydia is fully working on iOS 4.3.1
It is a semi-tethered jailbreak.
Your baseband will not be upgraded during restore process.
Modifying PwnageTool
Step 1: Download PwnageTool bundle for your version of iOS device. Extract the .zip folder, in there you will find a .bundle file, for this guide, we are using iPhone 4 bundle iPhone3,1_4.3.1_8G4.bundle. Move this file to your desktop.
Step 2: Download PwnageTool 4.2 and copy it to /Applications directory. Right click, and then click on “Show Package Contents” as shown in the screenshot below.
Step 3: Navigate to Contents/Resources/FirmwareBundles/ and paste iPhone3,1_4.3.1_8G4.bundle file in this location.
Creating Custom Ramdisk for iOS 4.3.1 Custom Firmware
Step 4: Download Universal Ramdisk Maker and simply install it as shown in the screenshots below. This is important because Ramdisk in the current version of PwnageTool is broken. This Universal Ramdisk Maker basically patches it correctly for iOS 4.3.1 firmware.
Building iOS 4.3.1 Custom Firmware
Step 5: Download iOS 4.3.1 firmware. Move this file to your desktop.
Step 6: Start PwnageTool in “Expert mode” and select your device:
Step 7: Browse for iOS 4.3.1 firmware for your device as shown in the screenshot below:
Step 8: Now select “Build” to start creating custom 4.3.1 firmware file:
Step 9: PwnageTool will now create the custom .ipsw file for your iPhone which will be jailbroken.
Step 10: Now follow the following steps to enter DFU mode using PwnageTool:
Hold Power and Home buttons for 10 seconds
Now release the Power button but continue holding the Home button for 10 more seconds
You device should now be in DFU mode
Restore iOS 4.3.1 Custom Firmware Using iTunes
Step 11: Start iTunes, click on your iOS device icon from the sidebar in iTunes. Now press and hold left “alt” (option) button on Mac, or Left “Shift” button if you are on Windows on the keyboard and then click on “Restore” (Not “Update” or “Check for Update”) button in the iTunes and then release this button.
This will make iTunes prompt you to select the location for your custom firmware 4.3.1 file. Select the required custom .ipsw file that you created above, and click on “Open”.
Step 12: Now sit back and enjoy as iTunes does the rest for you. This will involve a series of automated steps. Be patient at this stage and don’t do anything silly. Just wait while iTunes installs the new firmware 4.3.1 on your iOS device. Your iOS device screen at this point will be showing a progress bar indicating installation progress. After the installation is done, your iOS device will be jailbroken on iOS 4.3.1.
Booting in Tethered Mode
Last but not the least, since there is no untethered jailbreak for iOS 4.3.1 yet, we will have to boot it into a tethered jailbroken state. To do this, we will make use of a utility named “tetheredboot” as shown in the steps below.
Step 13: Download tetheredboot.zip utility for Mac OS X and extract the .zip file.
Step 14: First, we will need two files from the custom iOS 4.3.1 firmware namely: kernelcache.release.n90 and iBSS.n90ap.RELEASE.dfu. To do this, make a copy of your custom iOS 4.3.1 file that you created above, change the extension of this file from .ipsw to .zip, and then extract this .zip file.
Now copy kernelcache.release.n90 file, and then copy iBSS.n90ap.RELEASE.dfu files which are found under /Firmware/dfu/.
Move all these files, and tetheredboot utility to a new folder named “tetheredboot” on the desktop as shown in the screenshot below.
Step 15: Turn off your iOS device, and start Terminal on OS X and run the following commands:
sudo -s
enter your administrator password, then:
/Users/TaimurAsad/Downloads/tetheredboot/tetheredboot
/Users/TaimurAsad/Downloads/tetheredboot/iBSS.n90ap.RELEASE.dfu
/Users/TaimurAsad/Downloads/tetheredboot/kernelcache.release.n90
You will have to of course replace “TaimurAsad” with the name of the directory on your computer.
now press enter.
You should now see some code running in the Terminal window, at some point, it will ask you to enter DFU mode. Now follow the following steps to enter DFU mode:
Hold Power and Home buttons for 10 seconds
Now release the Power button but continue holding the Home button for 10 more seconds
You device should now be in DFU mode
Now wait for your device to boot, Terminal at this point will be showing “Exiting libpois0n” message. After a short while, your iPhone, iPad or iPod touch will be booted in a jailbroken tethered mode !
Tuesday, March 29, 2011
downgrade iphone
Downgrade iOS 4.3.1 to 4.3 - 4.2.1 - 4.1 [How to]
SATURDAY, MARCH 26, 2011
Apple has released the final version of the iOS 4.3.1, not be released to fix some bugs of version 4.3 Many people now updated their devices while other, more hesitant to jailbreak or interested, they preferred to wait. In this post we will offer you the guide to downgrade from firmware 4.3.1 to firmware 4.3 or earlier, Just You Have to follow The steps below for all owners of iPhone 4 or iPhone 3GS upgraded to iOS 4.3.(Just stay Tuned for more downgrade Guides Facebook & Twitter )
You Will Need This
Firmware 4.3 (or earlier) saved on your computer, preferably on the desktop.
iPhone 3GS / 4 updated to firmware 4.3.1
iTunes 10.2.1
OS Windows or Mac OS X.
Certificates SHSH firmware 4.3, or earlier, saved
Before you must have amended appropriately on the host file. Here's how:
Windows Users
Open Notepad with administrator and click the right button and selecting the icon, then "Open as administrator".
Position yourself in the path C: / WINDOWS/system32/drivers/etc
Add this string to finder the file: 74.208.105.171 gs.apple.com
Close and save the changes
Mac Users
Using the Finder, navigate to the location / etc
Open the file "hosts" and enter the following string at the end of the document: 74.208.105.171 gs.apple.com
When you Finished making the changes, save the document to your desktop.
Now copy the new file in this directory Host (saved on desktop) overwriting the original
How To Guide
Step 1 :Connect your device to your computer and put it in DFU mode.
Connect your iOS device to your computer.
Turn it off.
Start iTunes.
Hold Power and Home buttons together for 10 seconds or so.
Release Power button but keep holding the Home button until your computer recognizes a new USB device.
iTunes will now recognize your iPhone, iPad or iPod touch.
Note: Your iPhone, iPad or iPod touch screen at this time should be blank (black in color), if not, then you are most likely in Recovery Mode, not DFU mode.
Step 2 :Once the iPhone is in DFU mode and will be detected by iTunes, click "Ok" and then select the firmware 4.3 to restore the iPhone software. To do this you must press and hold down the ALT key (Mac) and SHIFT (Windows) and then click on the Restore item. The reset takes about 10 to 15 minutes.
Step 3 :At the end of the process, iTunes may return an Error (1011, 1013, 1015). It is quite normal. Continue ignoring the error as the firmware 4.3 will also been installed on your device but you come into the so-called Recovery Mode Loop. You get out in various ways, including:
Using the latest version of RecBoot, available only for Mac;
Using the latest version of TinyUmbrella, available for (Windows / Mac)..
If you choose to use RecBoot you simply connect your iPhone to your computer, open programs and select "Exit Recovery Mode". The device will reboot and you have restored iOS 4.3 on your device. If you are using TinyUmbrella, you click on "Exit Recovery" at the top of the tab for the device connected to your computer.
If you have done all the steps correctly, the downgrade is complete and you have installed the firmware you want.
Remember to remove the string you just added to the Hosts file, otherwise you can not install future software upgrades.
Your iPhone will now reboot normally. You have now successfully downgraded iOS 4.3.1 to iOS 4.3, 4.2.1, 4.1 firmware. You can follow the normal guides to jailbreak. If you have downgraded your device to iOS 4.3, you can use either sn0wbreeze (for Windows) or PwnageTool (for Mac). iOS 4.2.1 or iOS 4.1
users can use :
Sn0wbreez Jailbreak 4.3 [How to]
GreenPois0n Jailbreak 4.2.1 [Win]
GreenPois0n Jailbreak 4.2.1 [Mac]
PwnageTool Jailbreak 4.2.1 [Mac]
Redsn0w Jailbreak 4.2.1 [Win]
Redsn0w Jailbreak 4.2.1 [Mac]
Sn0wbreez Jailbreak 4.2.1 [win]
Sn0wbreez Jailbreak 4.1 [Win]
Limera1n Jailbreak 4.1 [Mac]
Limera1n Jailbreak 4.1 [Win]
SATURDAY, MARCH 26, 2011
Apple has released the final version of the iOS 4.3.1, not be released to fix some bugs of version 4.3 Many people now updated their devices while other, more hesitant to jailbreak or interested, they preferred to wait. In this post we will offer you the guide to downgrade from firmware 4.3.1 to firmware 4.3 or earlier, Just You Have to follow The steps below for all owners of iPhone 4 or iPhone 3GS upgraded to iOS 4.3.(Just stay Tuned for more downgrade Guides Facebook & Twitter )
You Will Need This
Firmware 4.3 (or earlier) saved on your computer, preferably on the desktop.
iPhone 3GS / 4 updated to firmware 4.3.1
iTunes 10.2.1
OS Windows or Mac OS X.
Certificates SHSH firmware 4.3, or earlier, saved
Before you must have amended appropriately on the host file. Here's how:
Windows Users
Open Notepad with administrator and click the right button and selecting the icon, then "Open as administrator".
Position yourself in the path C: / WINDOWS/system32/drivers/etc
Add this string to finder the file: 74.208.105.171 gs.apple.com
Close and save the changes
Mac Users
Using the Finder, navigate to the location / etc
Open the file "hosts" and enter the following string at the end of the document: 74.208.105.171 gs.apple.com
When you Finished making the changes, save the document to your desktop.
Now copy the new file in this directory Host (saved on desktop) overwriting the original
How To Guide
Step 1 :Connect your device to your computer and put it in DFU mode.
Connect your iOS device to your computer.
Turn it off.
Start iTunes.
Hold Power and Home buttons together for 10 seconds or so.
Release Power button but keep holding the Home button until your computer recognizes a new USB device.
iTunes will now recognize your iPhone, iPad or iPod touch.
Note: Your iPhone, iPad or iPod touch screen at this time should be blank (black in color), if not, then you are most likely in Recovery Mode, not DFU mode.
Step 2 :Once the iPhone is in DFU mode and will be detected by iTunes, click "Ok" and then select the firmware 4.3 to restore the iPhone software. To do this you must press and hold down the ALT key (Mac) and SHIFT (Windows) and then click on the Restore item. The reset takes about 10 to 15 minutes.
Step 3 :At the end of the process, iTunes may return an Error (1011, 1013, 1015). It is quite normal. Continue ignoring the error as the firmware 4.3 will also been installed on your device but you come into the so-called Recovery Mode Loop. You get out in various ways, including:
Using the latest version of RecBoot, available only for Mac;
Using the latest version of TinyUmbrella, available for (Windows / Mac)..
If you choose to use RecBoot you simply connect your iPhone to your computer, open programs and select "Exit Recovery Mode". The device will reboot and you have restored iOS 4.3 on your device. If you are using TinyUmbrella, you click on "Exit Recovery" at the top of the tab for the device connected to your computer.
If you have done all the steps correctly, the downgrade is complete and you have installed the firmware you want.
Remember to remove the string you just added to the Hosts file, otherwise you can not install future software upgrades.
Your iPhone will now reboot normally. You have now successfully downgraded iOS 4.3.1 to iOS 4.3, 4.2.1, 4.1 firmware. You can follow the normal guides to jailbreak. If you have downgraded your device to iOS 4.3, you can use either sn0wbreeze (for Windows) or PwnageTool (for Mac). iOS 4.2.1 or iOS 4.1
users can use :
Sn0wbreez Jailbreak 4.3 [How to]
GreenPois0n Jailbreak 4.2.1 [Win]
GreenPois0n Jailbreak 4.2.1 [Mac]
PwnageTool Jailbreak 4.2.1 [Mac]
Redsn0w Jailbreak 4.2.1 [Win]
Redsn0w Jailbreak 4.2.1 [Mac]
Sn0wbreez Jailbreak 4.2.1 [win]
Sn0wbreez Jailbreak 4.1 [Win]
Limera1n Jailbreak 4.1 [Mac]
Limera1n Jailbreak 4.1 [Win]
Friday, February 18, 2011
iphone 4 強化功能及美化iphone資料 - iPhone - 香港討論區 Uwants.com
iphone 4 強化功能及美化iphone資料 - iPhone - 香港討論區 Uwants.com: "iphone 4 強化功能及美化iphone資料"
iphone 4 強化功能及美化iphone資料
[隱藏]
小弟近日有時間, 想將自己部jb咗嘅iphone整靚d, 將功能強化, 於是在各討論區留攬, 發現好多有心師兄將自己嘅心得同其他人分享, 真係難能可貴, 但亦發現有好多朋友, 完全唔爬文, 唔睇其他有心人嘅post, 當自己有問題時就開post發問, 咁樣其實好難會有高人睇到而又會幫你解決, 最主要係自己去研究用嘗試, 我自己都試過白蘋果兩次, 回復咗再黎過, 再加上有心師兄嘅指點, 先可以了解自己部iphone.
經過兩星期爬文, 小弟有d資料及來源同大家分享, 希望幫到一d唔知點搵資料嘅朋友. 有錯嘅地方, 希望大家指點同原諒, 而有用嘅就希望幫到一班想強化, 美化自己部iphone嘅朋友, 不喜勿插.
而下面的資料希望新手按裝時要一樣一樣試, 因為未必可以全部相容, 如裝完一樣之後發覺大家不相容, 就要選擇其中一樣. 本人的iphone由空白開始, 可以按裝下面的所有, 但我不知你iphone內是否有其他不能相容的程式, 因此建議一樣一樣裝, 勿貪!!
最後我亦建議各位切勿胡亂更改iphone內本身system的程式, 因本人試過改字體而白蘋果, 切記!!
JB後的程序
1. add sources
入cydia - manage - sources - 左上角edit - 右上角add, 然後加以下sources:
apt178.com iphone.org.hk/apt
www.sinfuliphonerepo.com
cydia.xsellize.com
H7v.org
app.weiphone.com/cydia
2. 入cydia search以下程式強化iphone功能 (轉自uwants 及 大腳點滴)
sbsetting + winterboard (美化iphone)
installious + appsync os4 (免費安裝apps)
20 sec lockscreen (將lockscreen時間延長20秒, 用處是當你有個靚lockscreen, 都想停留長d時間比人睇)
3g unrestrictor or my3g (將3g信號當wifi信號)
activator + multicleaner(以手勢或快捷方式呼叫程式, 或關閉程式)
badges (可以修改將桌面icon的badges, badges即係平時你有miss call, 係電話個icon上面會有個1字果個泡泡)
barrel (可以設定番頁效果)
call controller(可以設定接聽電話模式, 例如shake to answer)
callme (可以制造快捷撥號icon於桌面)
iconoclasm (可以設定icon數量於桌面, 例如5x5, 5x4, 5x2, 用處是可以配合一些主題, 不會蔗擋到主題的背景圖片)
cy delete (可以於桌面直接delete從cydia dl 的icon)
cyntact (在contact內可以顯示來電相片)
deepend (3d桌面背景)
facebreak (可於3g信號下打facetime)
fakecarrier (修改營運商名字)
fakeclockup加快開apps速度
five icon dock + infinidock (將dock icon加至五個並無限申延)
flashlight (電筒)
gridlock (可於桌面任意撼放icon, 用處是可以配合一些主題, 不會蔗擋到主題的背景圖片)
ibluetooth (用bluetooth傅送文件)
iphone delivery (訊息回執, 不過自己試過唔得)
liveclock (讓桌面時鐘動起來, 但當配合某些主題時, 時鐘未必會動)
lockscreen clock hide (隱藏鎖屏畫面的時鐘, 可以配合某些主題使用)
multiicon mover (一些過移動大量icon)
phonecloser (打完電話收線後, 不會停留在keyboard畫面)
pull to refresh e-mail (在e-mail的程式中, 向下一拉去refresh e-mail)
recent calllog delete (可獨立delete通話記錄)
sbphotodial (same as callme)
slantedlock (天氣主題)
status bar battery icon hide (隱藏status bar的小電池, 只顯示%)
volumn booster 4.0 (加大音量)
weather icon + libstatusbar (讓天氣圖示顯示天氣及氣溫, 配合libstatus可在status bar上顯示溫度或天氣圖像或兩樣都顯示)
yourtube 2 (可dl youtube短片並可儲存入電話內於ipod播放)
vWallpaper (有來video ringtone, video wallpaper, 配合以下教學, 可自己設定來電的video ringtone是那一首music video)
3. 另外還有其他cydia apps可參考其他ching及網站的post (來自uwants 及 大腳點滴 及 discuss)
http://mobile.uwants.com/viewthread.php?tid=11305506&extra=page%3D13
http://maciku.blogspot.com/2011/01/iphone-cydia-1227-jb-iphone-jb-cydia.html http://mobile.discuss.com.hk/viewthread.php?tid=8473446&extra=page%3D1
4. 國內iphone教學網 (來自joyiphone)
http://bbs.joyiphone.net/index.aspx
5. 修改iphone路徑
系統源 http://iphone.tgbus.com/zt/iphonezt/mod.html (基本上不建議修改)
backup源 http://tool.joyiphone.net/iOS/Index.aspx (如修改後想用回本身iphone自帶的系統文件可在此找)
6. 其他ching的教學, 方便大家尋找 (來自uwants)
安全美化theme教學
http://mobile.uwants.com/viewthread.php?tid=10974898&extra=page%3D1
7. dl icon 及 theme的網
free icon dl http://www.softicons.com/free-icons?start=984
theme dl site http://www.mobile2.tw/ http://www.shouji123.com/
http://5ubox.com/html/iphone_theme/list_14_2.html
http://www.mbtheme.com/Iphone_theme/
http://macthemes2.net/forum/viewforum.php?id=24
8. 查詢天氣代碼
http://www.accuweather.com/nwo/default.aspx?aspxerrorpath=/nwo/Default.aspx
http://www.weather.com/
9. 自制來電vedio ringtone (來自joyiphone)
http://bbs.joyiphone.net/showtopic-3145.aspx
video converter http://www.leawo.cn/
来电MV存放路径： \private\var\mobile\Media\Skrew\vRingtones
iphone 4 強化功能及美化iphone資料
[隱藏]
小弟近日有時間, 想將自己部jb咗嘅iphone整靚d, 將功能強化, 於是在各討論區留攬, 發現好多有心師兄將自己嘅心得同其他人分享, 真係難能可貴, 但亦發現有好多朋友, 完全唔爬文, 唔睇其他有心人嘅post, 當自己有問題時就開post發問, 咁樣其實好難會有高人睇到而又會幫你解決, 最主要係自己去研究用嘗試, 我自己都試過白蘋果兩次, 回復咗再黎過, 再加上有心師兄嘅指點, 先可以了解自己部iphone.
經過兩星期爬文, 小弟有d資料及來源同大家分享, 希望幫到一d唔知點搵資料嘅朋友. 有錯嘅地方, 希望大家指點同原諒, 而有用嘅就希望幫到一班想強化, 美化自己部iphone嘅朋友, 不喜勿插.
而下面的資料希望新手按裝時要一樣一樣試, 因為未必可以全部相容, 如裝完一樣之後發覺大家不相容, 就要選擇其中一樣. 本人的iphone由空白開始, 可以按裝下面的所有, 但我不知你iphone內是否有其他不能相容的程式, 因此建議一樣一樣裝, 勿貪!!
最後我亦建議各位切勿胡亂更改iphone內本身system的程式, 因本人試過改字體而白蘋果, 切記!!
JB後的程序
1. add sources
入cydia - manage - sources - 左上角edit - 右上角add, 然後加以下sources:
apt178.com iphone.org.hk/apt
www.sinfuliphonerepo.com
cydia.xsellize.com
H7v.org
app.weiphone.com/cydia
2. 入cydia search以下程式強化iphone功能 (轉自uwants 及 大腳點滴)
sbsetting + winterboard (美化iphone)
installious + appsync os4 (免費安裝apps)
20 sec lockscreen (將lockscreen時間延長20秒, 用處是當你有個靚lockscreen, 都想停留長d時間比人睇)
3g unrestrictor or my3g (將3g信號當wifi信號)
activator + multicleaner(以手勢或快捷方式呼叫程式, 或關閉程式)
badges (可以修改將桌面icon的badges, badges即係平時你有miss call, 係電話個icon上面會有個1字果個泡泡)
barrel (可以設定番頁效果)
call controller(可以設定接聽電話模式, 例如shake to answer)
callme (可以制造快捷撥號icon於桌面)
iconoclasm (可以設定icon數量於桌面, 例如5x5, 5x4, 5x2, 用處是可以配合一些主題, 不會蔗擋到主題的背景圖片)
cy delete (可以於桌面直接delete從cydia dl 的icon)
cyntact (在contact內可以顯示來電相片)
deepend (3d桌面背景)
facebreak (可於3g信號下打facetime)
fakecarrier (修改營運商名字)
fakeclockup加快開apps速度
five icon dock + infinidock (將dock icon加至五個並無限申延)
flashlight (電筒)
gridlock (可於桌面任意撼放icon, 用處是可以配合一些主題, 不會蔗擋到主題的背景圖片)
ibluetooth (用bluetooth傅送文件)
iphone delivery (訊息回執, 不過自己試過唔得)
liveclock (讓桌面時鐘動起來, 但當配合某些主題時, 時鐘未必會動)
lockscreen clock hide (隱藏鎖屏畫面的時鐘, 可以配合某些主題使用)
multiicon mover (一些過移動大量icon)
phonecloser (打完電話收線後, 不會停留在keyboard畫面)
pull to refresh e-mail (在e-mail的程式中, 向下一拉去refresh e-mail)
recent calllog delete (可獨立delete通話記錄)
sbphotodial (same as callme)
slantedlock (天氣主題)
status bar battery icon hide (隱藏status bar的小電池, 只顯示%)
volumn booster 4.0 (加大音量)
weather icon + libstatusbar (讓天氣圖示顯示天氣及氣溫, 配合libstatus可在status bar上顯示溫度或天氣圖像或兩樣都顯示)
yourtube 2 (可dl youtube短片並可儲存入電話內於ipod播放)
vWallpaper (有來video ringtone, video wallpaper, 配合以下教學, 可自己設定來電的video ringtone是那一首music video)
3. 另外還有其他cydia apps可參考其他ching及網站的post (來自uwants 及 大腳點滴 及 discuss)
http://mobile.uwants.com/viewthread.php?tid=11305506&extra=page%3D13
http://maciku.blogspot.com/2011/01/iphone-cydia-1227-jb-iphone-jb-cydia.html http://mobile.discuss.com.hk/viewthread.php?tid=8473446&extra=page%3D1
4. 國內iphone教學網 (來自joyiphone)
http://bbs.joyiphone.net/index.aspx
5. 修改iphone路徑
系統源 http://iphone.tgbus.com/zt/iphonezt/mod.html (基本上不建議修改)
backup源 http://tool.joyiphone.net/iOS/Index.aspx (如修改後想用回本身iphone自帶的系統文件可在此找)
6. 其他ching的教學, 方便大家尋找 (來自uwants)
安全美化theme教學
http://mobile.uwants.com/viewthread.php?tid=10974898&extra=page%3D1
7. dl icon 及 theme的網
free icon dl http://www.softicons.com/free-icons?start=984
theme dl site http://www.mobile2.tw/ http://www.shouji123.com/
http://5ubox.com/html/iphone_theme/list_14_2.html
http://www.mbtheme.com/Iphone_theme/
http://macthemes2.net/forum/viewforum.php?id=24
8. 查詢天氣代碼
http://www.accuweather.com/nwo/default.aspx?aspxerrorpath=/nwo/Default.aspx
http://www.weather.com/
9. 自制來電vedio ringtone (來自joyiphone)
http://bbs.joyiphone.net/showtopic-3145.aspx
video converter http://www.leawo.cn/
来电MV存放路径： \private\var\mobile\Media\Skrew\vRingtones
Subscribe to:
Posts (Atom)