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.

[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

[OPEN-SOURCE PROJECT]Flash Gordon, an Edify to Bash parser/translator written in Java

What is Flash Gordon ?
Basically, Flash Gordon is an app which allows you to flash any flashable zip (except for Roms) without having a recovery installed.
You just point it to the zip you want to flash, (be it a kernel, a mod, gapps...) and it will interpret the updater-script of this package and install its content just like a recovery would.
How does it work ?
Here is what happens step by step :
You tap the "select a zip" button, select the built-in file explorer to select the zip you want to flash
Flash Gordon will first extract this zip, depending on its size it can take a little time
When you press the "Flash Now" button, Flash Gordon will locate the updater-script and start translating it into shell code, line by line
It will output the resulting translated bash script on your sdcard and execute it, thus installing the zip's content
The app creates a notification, just tap on it to reboot
In order to achieve those last 2 steps, I'm writing a full Edify to Bash parser and translator.
Here is the list of all the Edify commands this parser can currently process and what their respective bash translation is (in green), using examples:
(more will be added over time, this is really just a draft)
By no means am I a bash expert, so if you have suggestions for better bash equivalents of any edify commands please post them
Code:
package_extract_file("path/to/source/file.txt", "/path/to/destination/file.txt");
[COLOR="DarkGreen"]busybox cp -fp /path/to/source/file.txt /path/to/destination/file.txt[/COLOR]
package_extract_dir("/source/folder", "/destination/folder");
[COLOR="DarkGreen"]busybox cp -rfp /source/folder/* /destination/folder[/COLOR]
set_perm(0, 2000, 0755, "/file/or/folder");
[COLOR="DarkGreen"]chown 0:2000 /file/or/folder
chmod 0755 /file/or/folder[/COLOR]
set_perm_recursive(0, 2000, 0644, 0755, "/path/to/set/permissions/recursively);
[COLOR="DarkGreen"]chown 0:2000 /path/to/set/permissions/recursively
chown 0:2000 /path/to/set/permissions
chown 0:2000 /path/to/set
chown 0:2000 /path/to
chown 0:2000 /path
chmod 0644 /path/to/set/permissions/recursively
chmod 0755 /path/to/set/permissions
chmod 0755 /path/to/set
chmod 0755 /path/to
chmod 0755 /path[/COLOR]
delete("file/to/delete");
[COLOR="DarkGreen"]busybox rm -f /file/to/delete[/COLOR]
run_program("/script/to/run.sh");
[COLOR="DarkGreen"]sh /script/to/run.sh[/COLOR]
mount("ext4", "EMMC", "/dev/block/mmcblk0p9", "/system");
[COLOR="DarkGreen"]busybox mount -o rw,remount -t auto /system [I](will soon change to -t mmcblk0p9 or whichever mount point is in the updater-script)[/I][/COLOR]
unmount("/system");
[COLOR="DarkGreen"]busybox mount -o remount,ro /system[/COLOR]
symlink("busybox", "/system/xbin/[", "/system/xbin/[[",
"/system/xbin/adjtimex", "/system/xbin/arp", "/system/xbin/ash",
"/system/xbin/awk", "/system/xbin/base64", "/system/xbin/basename",
"/system/xbin/bbconfig", "/system/xbin/blkid", "/system/xbin/blockdev",
"/system/xbin/brctl", "/system/xbin/bunzip2", "/system/xbin/bzcat",
"/system/xbin/bzip2", "/system/xbin/cal", "/system/xbin/cat",
"/system/xbin/catv", "/system/xbin/chattr", "/system/xbin/chgrp",
"/system/xbin/chmod", "/system/xbin/chown", "/system/xbin/chroot",
"/system/xbin/clear", "/system/xbin/cmp", "/system/xbin/comm",
"/as/many/lines/as/you/want");
[COLOR="DarkGreen"]ln -s busybox /system/xbin/[ /system/xbin/[[
/system/xbin/adjtimex /system/xbin/arp /system/xbin/ash
/system/xbin/awk /system/xbin/base64 /system/xbin/basename
/system/xbin/bbconfig /system/xbin/blkid /system/xbin/blockdev
/system/xbin/brctl /system/xbin/bunzip2 /system/xbin/bzcat
/system/xbin/bzip2 /system/xbin/cal /system/xbin/cat
/system/xbin/catv /system/xbin/chattr /system/xbin/chgrp
/system/xbin/chmod /system/xbin/chown /system/xbin/chroot
/system/xbin/clear /system/xbin/cmp /system/xbin/comm
/as/many/lines/as/you/want
(not sure about this one, please correct me if I'm wrong, I could change to [I]ln -s argument/number/1 argument/number/2[/I] as many times as required if needed)[/COLOR]
write_raw_image("/tmp/boot.img", "mmcblk0p5");
[COLOR="DarkGreen"]dd if=/tmp/boot.img of=/dev/block/mmcblk0p5[/COLOR]
This is just a proof of concept for the moment, I'm aiming at adding all the possible Edify commands, and maybe do it backwards (Bash2Edify) in the future, too.
Screenshots
This is from the apk I use for debugging, so the UI is pretty barebones atm, it will quickly evolve to something more fancy and featureful
{
"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"
}
Contribute
Flash Gordon is fully Open-Source, and contributions are more than welcome!
You can check-out the full source code on my github at : https://github.com/Androguide/FlashGordon
This app depends on the following Open-Source libraries :
My fork of the CardsUI library by [URL="https://plus.google.com/101314917101345770417/posts"]Nadav Fima[/URL]
aFileChooser by Paul Burke
This project is at a very early stage of development, and I'm looking for help, especially if you're good at one of these things :
regex
java
bash
edify
Even if you're not, don't hesitate to jump in or ask questions about the code if you don't understand.
This is basically the "dev" thread, the general thread is here : http://forum.xda-developers.com/showthread.php?t=2250555

I guess this project died

Sprint G2 Wifi Tether - sorta working, need help

http://www.androidcoliseum.com/2013/03/how-to-enable-nexus-4-lte-tethering-on.html
This method worked when I input the commands via adb shell. The script didn't seem to take for some reason.
Code:
XanSama on XDA posted
If you log in to the phone via ADB and as root (either via "adb root" command, or via "su" from the shell) execute the commands listed here the tethering will work. Test it yourself.
If you want a persistent fix you have two options:
1) If you have a custom kernel installed, create a script in /system/etc/init.d that executes the commands from the post above (don't forget to set the permissions to executable!).
2) Install a program like Script Manager from the market, create a script using the commands from the post above, and tell it to execute the script at startup with root permissions.
Currently I'm running a rooted stock ROM with stock kernel, so I'm using Script Manager, and it's working perfectly.
Here's the script I'm using right now:
#!/system/bin/sh
iptables -A bw_FORWARD -i !lo+
iptables -A natctrl_FORWARD -j RETURN -i rmnet+ -o wlan0 -m state --state RELATED,ESTABLISHED
iptables -A natctrl_FORWARD -j DROP -i wlan0 -o rmnet+ -m state --state INVALID
iptables -A natctrl_FORWARD -j RETURN -i wlan0 -o rmnet+
iptables -A natctrl_FORWARD -j DROP
iptables -A natctrl_nat_POSTROUTING -t nat -o rmnet+ -j MASQUERADE
And now here's how I easily did it on my own. First thing you'll need is a script editor as XanSama said. I used the scripter that came inside Rom Toolbox pro.
{
"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"
}

Did you ever get it to work?

calvin269 said:
Did you ever get it to work?
Click to expand...
Click to collapse
WiFi tethering starts, however it won't broadcast the said. Actually quite common with this app.
Sent from my LG-LS980 using Tapatalk

WiFi tether works on Carbon ROM in the general section, Sprint testers 4.3.1 ROM grab Verizon's G2 PA Gaps 11/2

chris0160 said:
WiFi tether works on Carbon ROM in the general section, Sprint testers 4.3.1 ROM grab Verizon's G2 PA Gaps 11/2
Click to expand...
Click to collapse
Has anyone tried this?

snoopdog said:
Has anyone tried this?
Click to expand...
Click to collapse
Yes it works
Sent from my LG-LS980 using xda app-developers app

Anyone know of any progress on this?

Inactive sim card Redmi note 2 LTE (2gb ram)

Hi guys, I'm going crazy about how I can remove the notification that says "inactive sim card" on every reboot of the phone goes this notice. . (If active I get the matter of the famous messages on cost uk) I carry in note 2 LTE redmi rom DIOR v6 5/2/27 of xiaomi.eu thank you very much in advance.
{
"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"
}
Enviado desde mi GT-N7100 mediante Tapatalk

txeli32 said:
Hi guys, I'm going crazy about how I can remove the notification that says "inactive sim card" on every reboot of the phone goes this notice.
Click to expand...
Click to collapse
My solution is the following patch for /system/app/XiaomiServiceFramework.apk:
Code:
diff -urN XiaomiServiceFramework.orig/smali/com/xiaomi/activate/ActivateService.smali XiaomiServiceFramework/smali/com/xiaomi/activate/ActivateService.smali
--- XiaomiServiceFramework.orig/smali/com/xiaomi/activate/ActivateService.smali Thu Mar 26 00:44:20 2015
+++ XiaomiServiceFramework/smali/com/xiaomi/activate/ActivateService.smali Thu Mar 26 00:44:34 2015
@@ -1568,7 +1568,7 @@
invoke-static {v0, v1}, Landroid/util/Log;->v(Ljava/lang/String;Ljava/lang/String;)I
.line 1526
- invoke-static {p0}, Lcom/xiaomi/activate/ActivateHelper;->notifyUnactivatedSimCards(Landroid/content/Context;)V
+ #invoke-static {p0}, Lcom/xiaomi/activate/ActivateHelper;->notifyUnactivatedSimCards(Landroid/content/Context;)V
goto/16 :goto_0
Maybe there's some better way but this works just fine for me.

Aqq123 said:
My solution is the following patch for /system/app/XiaomiServiceFramework.apk:
Code:
diff -urN XiaomiServiceFramework.orig/smali/com/xiaomi/activate/ActivateService.smali XiaomiServiceFramework/smali/com/xiaomi/activate/ActivateService.smali
--- XiaomiServiceFramework.orig/smali/com/xiaomi/activate/ActivateService.smaliThu Mar 26 00:44:20 2015
+++ XiaomiServiceFramework/smali/com/xiaomi/activate/ActivateService.smaliThu Mar 26 00:44:34 2015
@@ -1568,7 +1568,7 @@
invoke-static {v0, v1}, Landroid/util/Log;->v(Ljava/lang/String;Ljava/lang/String;)I
.line 1526
- invoke-static {p0}, Lcom/xiaomi/activate/ActivateHelper;->notifyUnactivatedSimCards(Landroid/content/Context;)V
+ #invoke-static {p0}, Lcom/xiaomi/activate/ActivateHelper;->notifyUnactivatedSimCards(Landroid/content/Context;)V
goto/16 :goto_0
Maybe there's some better way but this works just fine for me.
Click to expand...
Click to collapse
hello, thank you very much for your help! I think it will help my "redmi note 2 (2gb ram) 4G LTE" correct? how this patch introduces you say? doing copy / paste in sistem / app?
thanks in advance. a greeting
. PD: I have a friend with "Xiaomi Mi note" with the same problem, you know if this method can be valid for too?
Enviado desde mi GT-N7100 mediante Tapatalk

or if you you indicate me where you got the information giving me a link to the solution I look at myself and not annoying most to you.
Enviado desde mi GT-N7100 mediante Tapatalk

txeli32 said:
or if you you indicate me where you got the information giving me a link to the solution I look at myself and not annoying most to you.
Click to expand...
Click to collapse
The patch is something I made, so there's no other link for it. To apply it, you'd do something like:
adb pull /system/app/XiaomiServiceFramework.apk
apktool2 d -r -t miui -o XiaomiServiceFramework XiaomiServiceFramework.apk
patch -p0 < system_app_XiaomiServiceFramework_DisableActivationNag.diff
apktool2 b -o XiaomiServiceFramework.patched.unsigned.unaligned.apk XiaomiServiceFramework
signapk XiaomiServiceFramework.patched.unsigned.unaligned.apk XiaomiServiceFramework.patched.unaligned.apk
zipalign 4 XiaomiServiceFramework.patched.unaligned.apk XiaomiServiceFramework.patched.apk
adb root
adb shell mount -o remount,rw /system
adb push XiaomiServiceFramework.patched.apk /system/app/XiaomiServiceFramework.apk
Note:
These are not exact instructions, you need to adjust them to your situation.
apktool2 is a wrapper for APK Tool 2.0.0-RC4, signapk is a wrapper for java -jar signapk.jar key.x509.pem key.pk8 $1 $2, patch is just the standard GNU Patch (or just edit the source manually), and you also need zipalign and of course adb.
I didn't actually do the replacement on a live system so I don't know if it works. If it doesn't, replace in recovery mode.
Careful: For some reason the forum inserts spaces in random places in the above text I pasted, you need to remove them yourself.
If this is the first time you're doing this, you also need to install the relevant frameworks:
adb pull /system/framework/framework-res.apk
adb pull /system/framework/framework-ext-res.apk
adb pull /system/app/MiuiFramework.apk
adb pull /system/app/miui.apk
apktool2 if -t miui framework-res.apk
apktool2 if -t miui framework-ext-res.apk
apktool2 if -t miui MiuiFramework.apk
apktool2 if -t miui miui.apk
You probably also need framework-miui-res.apk from MIUI Version 5 but since we're not decompiling resources here, you might be able to get away without it, so try it first. Otherwise get it from the file miui_HMNoteLTEGlobal_V6.3.5.0.KHIMIBL_b0278a67f6_4.4.zip, it's in /system/framework; extract it and install it with apktool2 if -t miui framework-miui-res.apk.
These are the generic instructions to make any such changes, so the good news is once you learn how to do it, it'll all feel very easy.