Database Users

[Q] Last question about database

I have currently developed 90% of my app, and i need help at the last part.
I want to thange the default database path to another user spezified path.
i get an error when i try this:
Code:
String myPath = "/data/data/com.android.providers.settings/databases/settings";
SQLiteDatabase myDB = SQLiteDatabase.openDatabase(myPath, null,SQLiteDatabase.OPEN_READWRITE);
The Debug monitor shows:
Code:
FATAL EXCEPTION: main
android.database.sqlite.SQLiteException: unable to open database file
i hope someone here can help me

It can't open it because it's not there.
You need to create the DB in that "settings" subdirectory. Or you can just use adb shell and copy the DB to .../settings.

the database exists, found with root explorer
when i want to acces the database with:
SQLiteDatabase myDB = set.this.openOrCreateDatabase("/data/data/com.android.providers.settings/databases/settings.db", MODE_PRIVATE, null);
it says, unable to open file, that means that the database not exists, but there is one, please, thats the last part, i need help

ilendemli said:
Code:
String myPath = "/data/data/com.android.providers.settings/databases/settings";
SQLiteDatabase myDB = SQLiteDatabase.openDatabase(myPath, null,SQLiteDatabase.OPEN_READWRITE);
Click to expand...
Click to collapse
Didn't you forget the ".db" at the end of /data/data/com.android.providers.settings/databases/settings ?

tryed with db and without db, the same problem:
Code:
SQLiteDatabase myDB = set.this.openOrCreateDatabase("/data/data/com.android.providers.settings/databases/settings.db", MODE_PRIVATE, null);

What does the Debug monitor shows when you do openOrCreateDatabase ? (can't be "unable to open database", if it were it would create it)

I am catching the Exception and showing the error as toast message,
at the debugger there is this error:
Database: sqlite3_open_v2("/data/data/com.android.providers.settings/settings.db", &handle, 6, NULL) failed

According to this link :http://www.sqlite.org/c3ref/open.html, you should be able to execute sqlite3_errmsg to have a description of the error.
But I have to admit that I don't know if you can do that easily with the SDK :/ I don't really know how it handles errors in this case (cause "failed" isn't really speaking to me ^^)
Edit : Hey, I just spotted something ! You missed your shot in writing the path to settings.db !
You wrote : /data/data/com.android.providers.settings/settings.db
It is : /data/data/com.android.providers.settings/databases/settings.db

I tryed it.. annd.... the same error..
if i try:
Code:
SQLiteDatabase myDB = set.this.openOrCreateDatabase("/data/data/com.android.providers.settings/databases/settings.db", MODE_PRIVATE, null);
it should normally create a new database at the dir.
when i type /data/data/.file/settings.db
there will be created the database, but at com.android.providers.settings/databases/ or all other com.* folders, it haves no permission.. :/

Try to add WRITE_SECURE_SETTINGS permission to your manifest then. Perhaps it will unlock it

Code:
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE"/>
<uses-permission android:name="android.permission.ACCESS_WIFI_STATE" />
<uses-permission android:name="android.permission.CHANGE_WIFI_STATE" />
<uses-permission android:name="android.permission.WRITE_SETTINGS" />
<uses-permission android:name="android.permission.WRITE_SECURE_SETTINGS"/>
alot of permissions xD i will try it
€: nope, no permission.

Well, I think I've reached my limit ^^
I'll go with the "If you don't have and can't have the permission to touch it, then don't" and try to find an API that do the things you want.
BTW, can you explain what you want to do with this DB ?

i want to change "wifi_http_proxy" and "wifi_http_port"

Are you sure that these fields even exist ?
I can find http_proxy, but no wifi_http_proxy nor wifi_http_port :/

which android do you have? 2.1? or 2.2?

2.2, but I'm using the official SDK website as a reference (and Google, obviously ^^)

can you change proxy settings manually?
Virtual Device:
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
My Phone:

Yes, I have the same screen as yours (2nd one).

hmm.. have you ever tryed to change the settings? try it to change, and then open the database /data/data/com.android.providers.settings/databases/settings.db -> system and then look for "wifi_http_proxy" and "wifi_http_port"

I'll try it once I get home. I'm at work now, and they locked the possibility to connect something with USB :/
I'll tell you what I'll see.

[Tutorial]How to remove title of the Power Menu

Tools needed :
My KIT for SMALI files (using options for each step )
Notepad++( Hexadecimal editor for *.xml )
_______________ Power Menu modded ______________
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
Open my zip kit ( recomended in a Theming Folder for example with apkmanager and all files you would like to mod )
What you get :
Baksmali
Baksmali ( executable Jar File )
Command.exe ( Shell file )
Notepad text with the two commands for decompile and compile already made for you ( just copy and paste into command.exe )
Smali
Smali ( executable Jar File )
1.Pull out android.policy.jar ( located in /framework from the rom you are running.
2.Place it in the file where you unzip my Smali kit.
Example : C:\SMALI\android.policy.jar
3. You need to decompile android.policy.jar :
Open the cmd ready for you in the kit and paste
Code:
java -jar baksmali.jar -x android.policy.jar -o classout
(classout folder can be renamed to whatever you want, doesnt matter until you dont forget to change the name too in the second command)
4. Make the modifications you want for smali files, in this case : Open Global.Actions.smali with Notepad++
located in \\classout\com\android\internal\policy\impl\
5. CTRL+F to search the line "settitle"
Just over it, you should see a line looking like
Code:
const v2, 0x1040120
change to :
Code:
const v2, 0x1040017
6. Compile again android.policy.jar :
Open the cmd ready for you in the kit and paste
Code:
java -Xmx512M -jar smali.jar classout -o classes.dex
7. Copy and paste the file classes.dex into android.policy.jar _ you will overwrite the old "classes.dex"
8. Replace your modded android.policy.jar and flash it _ Enjoy your new Power Menu
Thanks to Rafalense

thanks a lot ..was looking for this one too ... you my friend are truly awesome

Thread closed at OP request.

[APP] [4.0.3+] App Backup (Simple backup app) [update 7/26]

Hello XDA :victory:
I just finished making a simple yet useful backup app for Android 4.0.3+ (Root needed)
It can:
Make a Nandroid backup of the following partitions: /data, /cache, /android-secure, /sd-ext, /system
Copy all user installed APK's into the sdcard
Simple, yes, but somewhat useful
Screenshot:
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
Change log:
7/26
-Option to make a full Nandroid backup
-Changed some GUI
To install:
1. Install this APK.
2. copy this file AND this file to system/bin and set permissions as 655, or run this in adb:
1. "adb push xdevilium_onandroid_data_backup system/bin"
2. "adb push xdevilium_onandroid_backup system/bin"
3. "adb shell chmod 655 system/bin/xdevilium_onandroid_data_backup"
4. "adb shell chmod 655 system/bin/xdevilium_onandroid_backup"
Credits: The creator of "onandroid" script (sorry, i forgot the username )

I see that you are using an old version of Online Nandroid. I would really appreciate if you could keep it upto date.
Btw, great attempt at an app.

ameer1234567890 said:
I see that you are using an old version of Online Nandroid. I would really appreciate if you could keep it upto date.
Btw, great attempt at an app.
Click to expand...
Click to collapse
I can't, sorry, I lost the source code and I'm working on Newgen and XDA ROM HUB now

Is it similar to the "App2zip"?
Two issue, i can download apk file but i can't download other 2 files, i receive a text web page.
Eg:-
echo "##########################################"
echo "XRH Nadroid Data Backup"
echo "* This tool backups /data partition."
echo "* It is fully compatible with nandroid."
echo "* Based on 'onandroid' By Ameer Dawood"
echo "##########################################"
echo ""
# Define constants
path="/sdcard/clockworkmod/backup"
safety=7
name="none"
tz="u"
req_power=10
sdcard_temp_mount="/mnt/sdcard4nandroid"
logfile=/data/local/tmp/onandroid.log
# Logging function
mkdir -p /data/local/tmp
[ -f $logfile ] && busybox rm $logfile
logmsg(){
message="$*"
dtime=`busybox date +%T`
echo -e "$dtime $message"
echo "$dtime $message" >>$logfile
if [ "`busybox which log`" != "" ]; then
log -p i -t onandroid "$message"
fi
}
# Process arguments
if [ $# -gt 0 ]; then
if [ $1 == "--help" ]; then
# Display usage instructions
clear
echo ""
echo "Usage: xrh_backup_script [OPTIONS] [NAME]"
echo ""
Click to expand...
Click to collapse

android addicts said:
Is it similar to the "App2zip"?
Two issue, i can download apk file but i can't download other 2 files, i receive a text web page.
Eg:-
Click to expand...
Click to collapse
Right click, save page as

I'm having trouble getting this to work. Is there anyway you can all the install steps into the app for me
Sent from my SCH-I800 using Tapatalk 2

[Q] Storage space running out - but what's using it?

I realize there's plenty of threads with more or less the exact same topic. But I haven't found an answer in any of them that helps my situation.
Alright here's the deal:
I'm getting the "Storage space running out"-notification. And apps are starting to FC.. My phone is a i9505 and I'm currently running Carbon. But this was a problem with CM 10.2 too.
Here's what confuses me:
Code:
[email protected]:/data # busybox df -m
Filesystem 1M-blocks Used Available Use% Mounted on
...
/dev/block/platform/msm_sdcc.1/by-name/userdata
9351 9300 50 99% /data
...
/dev/fuse 9351 9300 50 99% /mnt/shell/emulated
...
/dev/block/vold/179:33
30688 25851 4837 84% /storage/sdcard1
Those should be the interesting bits (I'm showing off my 32GB external card here as well). Right, so I'm using 99%, or 9300MB.
Now here's how I check what's taking up the space:
Code:
[email protected]:/ # du -d1 -m /data
1 /data/dontpanic
3404 /data/media
1 /data/misc
1 /data/local
252 /data/data
1 /data/app-private
176 /data/app-asec
203 /data/app-lib
939 /data/app
1 /data/property
1 /data/ssh
1 /data/radio
321 /data/dalvik-cache
1 /data/resource-cache
1 /data/lost+found
1 /data/drm
1 /data/mediadrm
1 /data/security
4 /data/system
1 /data/wpstiles
1 /data/wiper
1 /data/shared
1 /data/fota
1 /data/time
1 /data/bluetooth
1 /data/audio
1 /data/.ssh
1 /data/tombstones
1 /data/nfc
1 /data/user
6 /data/qcks
1 /data/backup
1 /data/anr
5302 /data
du sums it up for us: 5302MB on /data
DiskUsage is showing me "System data" is taking up the space, but it doesn't tell me what or where:
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
I've checked solutions mentioned in related threads (all over the internets):
* The "/datadata" issue - I don't have this directory
* The "lost + found" - It's 1MB as you can see
* The "/data/log" issue - I don't have this directory
So what am I missing?

Well wouldn't you know. After a reboot the usage is down and df reports the same as du. I'm still confused as to what took up the space though.. I even got Java exceptions (from DiskUsage) saying the disk was full.

48Mbps N 5Ghz / 35Mbps N 2.4Ghz

Hi everybody!
Wanna see what speeds other tablets get...
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
A simple tweak to your nvram_net.txt file can boost your lowly download speeds.
I tweaked mine to the max for my tablet, so make a backup copy before copying and pasting my complete mod to the nvram_net file.
########
# Kona Rev0.1 2012.10.29-TSSI
#
manfid=0x2d0
prodid=0x05de
vendid=0x14e4
devid=0x4380
boardtype=0x05de
boardrev=0x1205
boardnum=22
macaddr=00:90:4c:c5:12:38
sromrev=3
#boardflags: 5GHz FEM: has ext 5GHz PA + LNA
# 2.4GHz FEM: has ext 2.4GHz PA + SP3T
# 2.4GHz FEM: SP3T switch share with BT
# keep original 0x200
boardflags=0x10081a01
xtalfreq=37400
nocrc=1
ag0=0
aa2g=1
aa5g=1
ccode=ALL
pa0itssit=0x20
cckPwrOffset=3
cckdigfilttype=24
elna_off_gain_idx_2g=32
xtalmode=0x20,0x4,0
tssitime=1
#
# support A band ext PA
rfreg033=0x1f
#
# 11b ACR Performance
aci_detect_en_2g=1
#
# rssi params for 2.4GHz
rssismf2g=0xf
rssismc2g=0x8
rssisav2g=0x1
#
# rssi params for 5GHz
rssismf5g=0xf
rssismc5g=0x7
rssisav5g=0x1
#
extpagain2g=2
extpagain5g=2
rxpo2g=0
rxpo5g=0
#
maxp2ga0=73
maxp5gla0=52
maxp5ga0=62
maxp5gha0=72
#
tssifloor2g=34
tssifloor5gl=33
tssifloor5gm=33
tssifloor5gh=33
#
#PA parameters for 2.4GHz-10/29 R01 TSSI
pa0b0=0x141E
pa0b1=0xFD89
pa0b2=0xFF57
#
#PA parameters for lower a-band-10/29 R01 TSSI
pa1lob0=0x1A12
pa1lob1=0xFCE0
pa1lob2=0xFF53
#
#PA parameters for midband-10/29 R01 TSSI
pa1b0=0x1B2F
pa1b1=0xFCBB
pa1b2=0xFF4E
#
#PA paramasdeters for high band-10/29 R01 TSSI
pa1hib0=0x1BDC
pa1hib1=0xFCA3
pa1hib2=0xFF4B
#
# 2GTxPwr Backoff
ofdm2gpo=0x33333333
mcs2gpo0=0x6666
mcs2gpo1=0x6666
#
# 5GTxPwr Backoff
ofdm5gpo=0x33333333
ofdm5glpo=0x33333333
ofdm5ghpo=0x33333333
mcs5gpo0=0x4444
mcs5gpo1=0x4444
mcs5glpo0=0x4444
mcs5glpo1=0x4444
mcs5ghpo0=0x4444
mcs5ghpo1=0x4444
#
# 5GTxPwr HT40 Backoff
mcs5gpo2=0x6666
mcs5gpo3=0x6666
mcs5glpo2=0x6666
mcs5glpo3=0x6666
mcs5ghpo2=0x6666
mcs5ghpo3=0x6666
#
PwrOffset40mhz5g=-1
#
ofdmdigfilttype=3
ofdmdigfilttype2g=3
ofdmdigfilttype5g=3
ofdm40digfilttype=5
#
# Parameters for DAC2x mode and ALPF bypass
loidacmode5g=1
dacrate2xen=1
dacrate2g=160
dacrate5g=160
dacpu.fab.4=1
txalpfbyp2g=1
txalpfbyp=1
txalpfpu=1
#
#Murata 2G & 5G FEM switch control table
swctrlmap_2g=0x00400040,0x06060606,0x02020202,0x10302,0x1ff
swctrlmap_5g=0x08080808,0x30303030,0x10101010,0x10302,0x2f8
#
elna_off_gain_idx_2g=32
gain=32
triso2g.fab.4=8
triso2g=8
triso5g=7
muxenab=0x10
aci_detect_en_2g=1
#
#EPA_or_PAD_lpbck5g=1
lpbckmode5g=1
txiqlopapu5g=0
txiqlopapu2g=0
dlorange_lowlimit=5
loflag=1
#
# For 2GHz Tx EVM/SM
bphyscale=17
pacalidx2g=65
pagc2g=0x10
gmgc2g=224
rfreg033=0x19
rfreg033_cck=0x1d
#
iqcalidx5g=50
### dlocalidx5g => (iqlocalidx5g => 20) index steps
iqlocalidx5g=45
dlocalidx5g=65
#
gain_settle_dly_2g=4
noise_cal_po_2g=-1
noise_cal_high_gain_2g=73
noise_cal_nf_substract_val_2g=346
gain_settle_dly_5g=4
noise_cal_po_5g=-1
noise_cal_po_40_5g=-1
noise_cal_high_gain_5g=73
noise_cal_nf_substract_val_5g=346
#
# BT / WIFI coex parameter
btc_params6=9
btc_params8=10000
btc_params33=3
btc_params61=2
btc_params80=0
btc_params95=53
#
il0macaddr=00:90:4c:c5:12:38
wl0id=0x431b
pagc2g=0x10

Reason for changes
I was going for fastest speeds and found them to be spotty with speed stability.
Here are my final results with 5 Ghz on top and 2.4 Ghz on bottom.