I need to know HOW to flip 1 bit in a database.
I am trying to tether my Pandigital Supernova to my Samsung Apollo's GPS and have hit a roadblock. The Supernova does not support mock locations out of the box. It seems I need to set ro.allow.mock.location=1 in default.prop and build.prop and MOCK_LOCATION to TRUE in settings.db. The 1st 2 were easy using the text editor in ROM Toolbox but I have no clue how to edit a database. The tools suggester were aShell and aSQLiteManager which I installed but honestly have no idea how to use. Can someone recommend a n00b-friendly way of doing this? I feel like I've just been told "To improve your gas mileage simply install a manual transmission."
I know this is probably resolved by now but this might help somebody else.
Must be root. Use ES File Manager from market. Go into settings and make sure you have it set to browse as root, go up to root, and mount system rw. Then back all the way up to root of the filesystem. If you are seeing folders like "etc" and "system" then you are there. From here use ES's search function and search for "all files" and put settings.db as the file name. When it comes up, note the directory and copy it to your sd card. Download SQLite Manager from market and open the copied settings.db with it. From here just look around and use the "Update Row" context action to edit the entries. When you back out it automatically saves. Copy the settings.db back into your internal memory wherever you found it at. Overwrite when prompted. Reboot. Win.
Related
I am trying the get my Viewsonic G Tablet up and running.
As of now, I have it rooted. I'm using AndRootFile to TRY to move files to various System folders, to install them.
Problem 1)The files I need are in a Folder called G Tablet on my SDCard1 (internal storage, not actually an SD Card). Though AndRootFile sees every other file and folder in the SDCard folder, it doesn't see G Tablet. Every other file manager does, but AndRootFile doesn't. That is odd, of course.
Problem 2)This is where my noobism really comes out. Even though AnfRootFile claims to be a bit of a one stop shop file system explorer (allowing copying and moving of files), I do not no how to actually copy a file. I press and hold and get no pop-up menu. There is no "move," copy," or "edit" feature when hitting the menu tab. The small selection of features that pop up with the menu tab are unlabeled, but after trial and error to figure out what they actually do, not a single one actually allows any type of management of files or folders, except to make a folder R/W -- not that I can actually DO anything with that information since I cant move anything around.
HELP!!
Nevermind. I'm dumb.
I still do not know why it did see my G Tablet folder, but I made a new folder and copied the need file to it. As for the moving... I just missed that tool in the toolbar.
[A] Why AndRootFile can't see G Tablet folder
This got me stuck for a while too. It's the space in the folder name that's the problem.
Just rename the folder from "G Tablet" to "G-Tablet" and it will work just fine.
I have also been messing around with this program. I see how to change it to R/W, but I don't see a way to change it back to R/O. Is there a need to do this, or am I just missing something? Thanks for any help you can provide.
Not able to copy to system/app
I am trying to install g/Market, gmail and maps on my viewsonic gtablet by following this link
http://forum.xda-developers.com/showthread.php?t=827209
i installed the AndRootFile and trying to copy files from sdcard to system/etc/permission and system/app but it is not able to copy.
It shows the error that this is read only area and not able copy.
Please guide me how am i able to go ahead to fix it.
Thanks so much.
I recently rooted my Inspire and loaded CM7.2 RC1 and I was just trying to increase my download speeds by editing the build.prop file. I'm using explorer v1.1 to get to the system folder and then editing the build.prop file using the text editor. When in explorer it says r/w and I can actually edit the file and save it but it never seems to actually save the changes even though it says it did. I tried using mount/system(rw/ro) to ensure that it was actually mounted but I am getting the same result. Any suggestions would be appreciated!
ES file explorer
Hi, I use the es file explorer, when you open it up hit "menu" scroll to bottom and make sure both root settings boxes are checked, then restart app. You should be good to go.
I recommend ROM Toolbox. It has a root file explorer and many other tools which come in handy on a rooted phone.
[QUOTE from Another Thread]
Using SQLite
1.open settings storage (com.motorola.android.providers.settings)
2.open settings.db
3.settings
4.search for dun_apn_changeable and dun_enable
5.Change both of their values to 1
---------------
I have an Atrix 2 running 2.3.6 rooted. (Rooted with SuperOneClick)
I want to enable the Wifi Hotspot feature, I have read several threads on this group, but I do not understand if I download SQlite on my pc and run it or my phone.
I downloaded the program on my phone, but when I open it all I get is a black screen with a box in the upper left corner with a magnifying glass in it, below that I see this "/data/data/com.xuecs.sqlitemanager/databases/defaultdb" The instructions I have read make absolutely no sense to me, the first step says "open settings storage" There is no way to open any thing as far as I can tell. I'm kind of lost here....Can someone help me out?
I want to update to ICS, I get an error, it downloads the file, resets the phone, when the android screen comes up the insallation bar goes about a third of the way then it stops and then it reboots, once its up and running it says "update failed" I have opened SuperOneClick and hit the unroot button, it says it was sucessful and it removes the Superuser app but the ICS OTA update still does not work. ANY SUGGESTIONS?
More detailed instructions for enabling wifi tether can be found at the following link, and I'm also pasting them here in full for anyone else curious. Note that this was the procedure for enabling everything on ICS. I'm not sure whether anything is different on Gingerbread.
http://forum.xda-developers.com/showpost.php?p=32347835&postcount=4
Things you will need:
ES File Explorer (free from play store)
aSQLiteManager (free from play store)
1. Launch ES File Explorer and within its settings, grant it full root permissions (near the bottom of settings, go in and check all four checkboxes).
2. From ES File Explorer navigate upward out of your SD card and onto the root of your device, then go into Data/Data/com.motorola.android.providers.settings/databases
3. Copy the "settings.db" file found there over to your SD card
4. Using aSQLiteManager select "Open Database" and pick that settings.db file on your SD card.
5. Select "settings" from the four tables you are presented with
6. Select "Data" from the top button menu
7. You'll see a long list of crap. Hit PgDn until you see line 113 "entitlement_check". Hit Edit and change the value from 1 to 0.
8. While you're here, also go to lines 117 and 118 that start with "dun" and change them both from 0 to 1. This is not necessary for Webtop but will enable wifi hotspot tethering.
9. Exit aSQLiteManager, go back into ES File Explorer and this time copy the modified "settings.db" back into the previous/original folder from Step 2, overwriting the old file.
10. Exit ES File Explorer, reboot your device and Webtop should work as expected.
paleozord said:
More detailed instructions for enabling wifi tether can be found at the following link, and I'm also pasting them here in full for anyone else curious. Note that this was the procedure for enabling everything on ICS. I'm not sure whether anything is different on Gingerbread.
http://forum.xda-developers.com/showpost.php?p=32347835&postcount=4
Things you will need:
ES File Explorer (free from play store)
aSQLiteManager (free from play store)
1. Launch ES File Explorer and within its settings, grant it full root permissions (near the bottom of settings, go in and check all four checkboxes).
2. From ES File Explorer navigate upward out of your SD card and onto the root of your device, then go into Data/Data/com.motorola.android.providers.settings/databases
3. Copy the "settings.db" file found there over to your SD card
4. Using aSQLiteManager select "Open Database" and pick that settings.db file on your SD card.
5. Select "settings" from the four tables you are presented with
6. Select "Data" from the top button menu
7. You'll see a long list of crap. Hit PgDn until you see line 113 "entitlement_check". Hit Edit and change the value from 1 to 0.
8. While you're here, also go to lines 117 and 118 that start with "dun" and change them both from 0 to 1. This is not necessary for Webtop but will enable wifi hotspot tethering.
9. Exit aSQLiteManager, go back into ES File Explorer and this time copy the modified "settings.db" back into the previous/original folder from Step 2, overwriting the old file.
10. Exit ES File Explorer, reboot your device and Webtop should work as expected.
Click to expand...
Click to collapse
I figured out what I was doing wrong, I didnt have the File Explorer at first..lol Once I did take care of things and rebooted the phone I kept getting errors that said "The process com.motorola.service.main has stopped unexpectedly" I hit force close and cancel both but the error would keep popping up at random times, plus other errors would pop up random apps running in the background would stop unexpectedly. Then the power button would not lock the screen anymore....The tethering worked though! I ended up doing a factory reset because the errors popped up so often the phone was useless.
I did not touch anything else but Line 150 which was the Entitlement Check line so I have no idea what went wrong.
One other thing, I would like to uprgade to ICS but since my phone is rooted I can't do it OTA, is there a way to manually do it? I remember when I upgraded to 2.3.6 I just put a file on the SD card and installed it, can I do that with ICS 4.0?
I recently Wiped my Phone completely and decided to Re-Flash Viper 1.2.1.
I noticed a problem prior to re-installing but thought nothing of if since it wasn't crucial at the time.
In Root explorer, I am able to delete [i normally delete boot animations] system files but not add where I need to add. Example, I wanted to add a ringtone to my system/media/ringtones folder. I normally [for the last six years] could just copy and paste such files using a root file manager.
However, when I any these files to for example /system/customize/resource/ it doesnt add it. BUT IT DOES rename the file and save it under a dif folder.
Example. Tried copying-copy to-moving to "androidtwirp.mp3" from sdcard to /system/media/notifications and a message pops up saying"notificationsandroidtwirp.mp3 successfully copied-moved to" and it saves notificationsandroidtwirp.mp3 to /system/media/ and it stays there. retrying from that location only results in "notificationsnotificationsandroidtwirp.mp3".
So not only does it rename the file but it saves it in the wrong location. I am at a loss for word. I tried the basics to tryand fix this but i cant seem to hit it on the head.
Thanks!
Edit: Not updating Super SU app, file explorer seems to have worked. Will attempt to duplicate problem to see what actually caused.it.
FOUND IT!
Updating my ES File explorer broke my system writing ability. DO NOT UPDATE is because when you do...
Any file you move, copy/paste to the system will not work properly.
This first happened when I tried to copy and paste a boot animation after I updated ES root explorer. It would rename whatever file i was trying to paste/move/copy over and save it under a sub folder.
example.
copying a ringtone [i.e. androidtwirp.mp3] from SDCard to System folder, the path is /system/media/audio/ringtones/ and it would rename it "ringtonesandroidtwirp.mp3" and save it under /system/media/audio/.
So basically not only was it renamed [which i didnt want it to be] but it would save it to the folder before the actual folder i needed it to be in, plus it would corrupt the file deeming it useless.
moving "ringtonesandroidtwirp.mp3" into the correct folder would only result in "ringtonesringtonesandroidtwirp.mp3"
this happened across the board with all files being moved around
The ES File Explorer version 1.2.1 comes with works flawlessly so don't update it.
I uninstalled ES [also any folders in SDcard related to it] and downloaded JRummy's root explorer and everything is back to normal except i have to reboot the phone to see files [like ringtones and notifications] that i added to the system.
I think it has something to do with our devices having an unlocked bootloaader, but still S-ON. There's S-OFF in the Dev section now if you really need to write to the system folder a lot.
I came from the Vibrant so I know what you're going through
Yeah, im on a low hboot so s-off might not be in my plans since I can practically flash what I want but it was ES file explorer, when I updated the apk the root permissions broke when writting to the system. I emailed the dev and they said they'd have it fixed on the next update.
echo en Android
ATTENTION! Back up your original apk file BEFORE the mod as you WILL need it AFTER the mod is done..
Ok guys, so i decided to play NFS Most Wanted on my new device (LG L Fino) so i installed from market and started the app.. Ok BUT as many of you i was facing the "Not enough memory on device,clear up some memory to proceed" message. So i got angry and decided to see if there is a workaround of the problem. Well generally the problem itself is that my device (like many others) uses ONE memory chip which is split into TWO 2GB parts, the first is system only, and the second is user- accessible, BUT 1,2GB of that "user space" is flooded by system junk and bloatware etc etc.. So all you have left in the so-called Emulated SD is actually some 0.8 gigabyte which is not sufficient in any way, when you want to install NFS Nost Wanted, because when you start the app first time it asks you to download some 2055mb's game data and says you have 0mb free on device, when the actuall gamedata size is only 670mb.. So i found this workaround and i decided to share right away.. Enough talking - lets get to business:
Prerequisites:
ROOT IS A MUST HAVE FOR THIS JOB
Install RAR app from rarlabs (search on google play)
Install ES File Explorer
Install NFS Most Wanted from google play
Make sure of having at least 700mb free on internal mem.
Lets start.
First open ES File explorer and turn Root Explorer "on"
Then navigate to root/data/app and find a file named " com.ea.games.nfs13_na-1.apk "
Now COPY that file to the root of your ext SD (for the sakes of easy navigation)
Next click and hold on the file till you have it marked then from the popup menu (right lower corner) choose "Open as" (not extract) then choose "ES Archive manager" and once inside, navigate to /assets/downloadcontent .
There you will find a file named: "config.properties"
Copy that to the root of you ext SD and open it with text editor.
what you need is to find the two lines that read
TOTAL_SPACE_MB=2055
# TOTAL_SPACE_MB_MIN=440
and edit them to look like this:
TOTAL_SPACE_MB=0205
# TOTAL_SPACE_MB_MIN=044
Now close the file and save the changes.
Next open the RAR app and navigate to the root of your ext SD then click and hold the edited text file till a menu pops up, select "Copy to buffer"
Then click and hold at the apk file, select "Open as archive" (NOT EXTRACT!) and again navigate through assets/downloadcontent, then click and hold on a random file and from the popup menu select Paste, it should ask you if you want to overwrite, choose YES and close RAR.
Final step is to open ES File Explorer again, navigate to root of ext SD, COPY the now edited APK then navigate to root and /data/app and PASTE. Select YES to overwrite file.
Now click and hold the apk one last time, and from the popup menu (lower right corner) choose "Properties"
Right next to "Permissions" there should be a button named "Change" go ahead and push the button. Now you have to fix those permissions, you should see 9 checkboxes. CHECK the three ones that are underneath "Read" and check ONLY the topmost thats underneath "Write". ALL OTHER HAVE TO BE UNCHECKED!
it should now look like this:
.......................Read.........Write.........Execute
Owner:........(*)...............(*)...................( )
.
Group:.........(*)................( )...................( )
.
Others:........(*)................( )...................( )
Click Ok, close ES File explorer, run game, download 650mb gamedata and have fun (optional is when you download gamedata to use app like GL to SD)
if you mess up the process, start over-rinse-repeat
I hope i helped someone and if yes please feel free to hit thanks button ( no it doesn't bite)
Greetings from Bulgaria
Edit: I found out a bug and i don't know if it's only with my copy of the game after modding or if everyone of you who tried this has it. So...
THE BUG is that after i modified the already installed apk in order to download data, i happened to restart my device and when it booted it seemed like my copy of the game somehow "partially uninstalled" itself.. After a little digging i found out that it actually did uninstall itself, BUT only the apk - that meaning the data and savegame ARE still there..
THE SOLUTION is before doing the above mentioned walktrought you have to backup you Original apk first (using the backup app tool of ES File Explorer) and after that you have to reboot your device, install the original apk (it will tell you that this update has nothing new in it, thus not requiring any new permissions - install anyway) and you're good to go with a stable installed game..
BUG 2: after all done right, it happens that my copy of GL to SD app is not showing the most wanted in "linked apps" section and neither it is showing it in the "Move data" list.. Don't you worry, the game is still "in there" even when it does not show up on the lists, click the "mount" button and play as normal - it is working..
If there is some trouble i will be glad to help, just write a reply here and i will check my thread regularly.
Have a nice time guys... (Aaandd girls)
xD thanks a ton man, this helped me