Database Info

[TIP] Using repo over a HTTP proxy with NTLM authenticatoin.

Download ntlmaps v0.9 from here..
Extract to any convenient directory.
Start a terminal, navigate to that directory then configure server.cfg and enter the following information where indicated using your favorite text editor:
Domain name
User name
Password
Proxy IP address
Proxy port (default 8080)
NOTE! Your password will be stored in clear-text, so ensure that you secure this file appropriately!
Save, then start the server by executing
Code:
python main.py
NOTE: Do not close the window!
Afterwards, set the system proxy to http://127.0.0.1, port 5865 by clicking System, then Preferences, then Network Proxy. Test by browsing to any website; if it asks for credentials, the configuration file is not correct.
Init the repo like normal (see instructions at http://source.android.com for details).
Configure the manifest XML file to pull the repo over HTTP, not over port 9436. (It's highly likely that your proxy has all ports except 80 and 443 blocked, hence why this change is needed.) You can do this by doing the following:
In the terminal, browse to the folder where the repo was initialized.
then
Code:
cd .repo
Open manifest.xml in your favorite text editor and change "git://android.git.kernel.org... to "http://android.git.kernel.org...". Save, then close.
Attempt to sync the repository. It should work now.
Hope this helps!

Extracting SMS' from a Android 2.3.7 phone backup using Windows tools

I wanted to search for a SMS message from a backup of an old phone. After browsing the fora and the web for ways to do it, I did the following.
NOTICE: The following steps were applied on an Android 2.3.7 / CyanogenMod 7.1.0.1 ROM backup.
I had a complete phone backup done with ClockworkMod recovery ROM v5.0.2 which I presume used NANDroid, so the following steps might work as well on such backups.
The backup files were originally written to \clockworkmod\backup\<DATE>.<TIME> directory on the phone's SD card. There I had a data.yaffs2.img file which is an YAFFS (Yet Another Flash File System) image file with all the \data directory contents, so using yaffey I opened the .img file and extracted
/data/com.android.providers.telephony/databases/mmssms.db
I had some trouble getting mmssms.db opened with several SQLite browser GUIs but was able to use the sqlite3.exe command bundled with SQLiteman to extract the SMS' using the following commands:
Code:
c:\temp\Sqliteman>sqlite3.exe c:\temp\mmssms.db
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .headers on
sqlite> .mode csv
sqlite> .output sms.csv
sqlite> .databases
addr pdu threads
android_metadata pending_msgs words
attachments rate words_content
canonical_addresses raw words_segdir
drm sms words_segments
part sr_pending
sqlite> SELECT * FROM sms;
sqlite> .quit
This way I created sms.csv, a comma seperated value file with the list of SMS'.
Using Excel 2010 I imported the information from the csv file by selecting the the 'Data' tab on ribbon and clicking on the 'From text' button on the 'Get External
Data' group. Then I browsed for the sms.csv file and opened it selecting the following options:
Original data type: Delimited
File origin: 65001 : Unicode (UTF-8)
Delimiter: Comma
(deselected the Tab delimiter)
Selecting each column in turn and changing the 'Column data format' to Text
This way I was able to search for an old sms messages, since that was all I wanted to do, I didn't mind having messages broken into more then one spreadsheet line.
Hope this helps someone else. Cheers.
Links:
SQLiteman - http://sqliteman.com/
yaffey (Yet Another Flash File (System) Editor YEAH!) - http://www.xda-developers.com/android/yaffey-for-all-your-yaffs2-needs/

[How to] XMLGenerator.jar + batch script v2.0

I created this script to help me create redirection xml's using @nhnt11's XMLGenerator.jar found here. I may as well share it with people who use it.
You need
XMLGenerator.bat (link below).
Bulk rename utility Link.
Windows to run the .bat
Java in your environment variables path. How to
Usage of XMLGenerator.jar:
I'll break down how XMLGenerator.jar works by using the following command. If your not intersted then just scroll down.
java -jar XMLGenerator.jar framework_res -f Resources android.xml
framework res is the package/apk name added to your images to differentiate them from other images with the same name, example- "btn_check_on". This is found in the AndroidManifest.xml. You can use any name you want as long as it is consistent throughout. I'm using framework_res.
-f. This tells XMLGenerator to add redirection tags to the output.xml.
Resources is the directory containing your images/xmls to be used in the redirection.xml.
android.xml is the output name of the redirection list. Again you can name this what you choose but i advise sticking to the package name using "_" instead of "."
Running the above command would output an xml containing a list of resources from the "Resources" folder and remove the "framework_res" tag from the first drawable instance for correct redirection.
Correct output:
Code:
<item name="drawable/ab_bottom_solid_dark_holo">@drawable/framework_res_ab_bottom_solid_dark_holo</item>
Incorrect output:
Code:
<item name="drawable/framework_res_ab_bottom_solid_dark_holo">@drawable/framework_res_ab_bottom_solid_dark_holo</item>
Using the script:
The options presented in the script are:
1) Set package name.
2) Set xml output name.
3) Create redirection xml.
5) Quick create redirection xml. You can ignore options 1+2 but the output.xml will contain the package name at the first drawable instance and have to be removed manually.
9) About
0) Exit
Creating a correct output.xml
Extract the zip.
Place your resources to be redirected into the "Resources" folder with package/apk tags prefixed (replace the period " ." with an underscore " _ ").
Run the bat.
Choose option 1. Enter your package name.
Choose option 2. Enter your xml output name.
Choose option 3.You will be presented with a redirection xml to be added/modified for use with Theme engine and XTheme.
Add to created package.xml "redirections.xml"
Feel free to make improvement suggestions or leave feedback.
Credits:
@Daneshm90 and @Stericson for samples of various scripts.
@nhnt11 for XMLGenerator.jar.
The zip includes .bat, resources folder and XMLGenerator.jar
Tested and running perfect on my Windows 7 machine.
Changelog:
27/06/2013-
Fixed typo when using the package name as xml name in option 2.
08/06/2013-
Added quick create option.
Added "-f" to create command for complete xml.
Cleaned up some synatx.

Updated script and added a usage tutorial to OP.

Pls help extract the ms zune bootloader.

Let me start off with saying I'm sorry if this is the wrong place for this tread. I'm not entirely sure where a question like this would fit. Due to my low post count I can't post on any of the development sub forums.
On to the question:
I'm working on attempting to reverse engineer the ms zune's ( how many people remember what that is ) boot loader. I've having an issue extracting the boot loader files from it's windows ce container.
I've been following the link (due to my low post count it seems I can't post outside links ) which shows how to extract the other containers.
The zune calls it's boot loader zboot.bin and when I follow the instructions I get an error message from cvrtbin.exe stating "missing address option". The thing is I am including the address but because the image starts at 0x0 the program either ignores that line or decides that that address is invalid.
Before I reverse cvrtbin to force it to accept a 0x0 address, I want to ask 1) is there a reason why the program believes that 0x0 is somehow an invalid start address and 2) is there a program that will extract a windows ce container that doesn't check to see for os files? I was able to find another program osnbtool that also error-ed out but also stated it found no os files.
Thank you!
Edit Since I can't post outside links here is the text version of the instructions
Open a command prompt and cd to the directory containing your firmware image files. Do not use PowerShell - doing so will result in unexplained spurious corruption of the dumped files (e.g. incorrect executable headers).
Run \path\to\viewbin <imagename>.bin to display header information from the image.
Run \path\to\cvrtbin -r -a <start> -w 32 -l <length> <imagename>.bin using the start and length values produced by viewbin.exe, as shown in the screenshot below. These values are different for each firmware image, and will differ from the example here.
Create a directory to house the dumped files
Run \path\to\dumprom -d <dir> -v -5 <imagename>.nb0 to dump the contents of the firmware image
The directory you created should now contain all the files from the image you just dumped, suitable for analysis with anything that supports Windows CE ARM binaries (dumpbin, IDA, etc.).

How To Guide How to enable naitive call recording on any A53(root required)

Hello and welcome, today Ill teach you, how to enable naitive call recording on any rooted samsung A53
so requirements for this
.java needs to be installed on the pc
. rooted samsung A53 (obviously)
. a root file explorer of your choice, I personally recommend Solid explorer
. the the latest jar from https://github.com/fei-ke/OmcTextDecoder/releases
Preparing
on your phone, go to about phone>software information and look at what the Software provider software version says (i e in my case it would be EU)
after that go ahead and go to A)optics/configs/carriers/your csc code/conf/system/ OR B) optics/configs/carriers/single/your csc code/
and copy that csc file over to your phone.
after that download that jar file and put it in a folder somewhere, then drag that csc file from the phone into that folder.
now right klick in that folder and choose open in terminal.
in terminal paste this
java -jar omc-decoder.jar -i cscfeature.xml -o cscfeature_decoded.xml
now delete the orignal cscfeatures file, and then open the decoded one with notepad, and go to where it says feature set at the werey end of that line, hit enter then paste this
<CscFeature_VoiceCall_ConfigRecording>RecordingAllowed</CscFeature_VoiceCall_ConfigRecording>
(note if you have diffirent country codes within your, cscfeatures.xml u must scroll down till u see your country code i e mine is under SE!!)
now klick save. and close notepad
now open the terminal again, if you closed it, just right klick and choose open in terminal.
then paste this
java -jar omc-decoder.jar -e -i cscfeature_decoded.xml -o cscfeature.xml
now u have an encrypted cscfeatures.xml, with call recording enabled, move it back to the phone, once back at the phone goahead and delete the stock cscfeatures.xml, then copy and paste the new freshly modified one, where the stock file used to be.
now reboot the phone, then go to the phone app, settings, and confirm that the call recording tab is under bixby calls.