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.

[REQUEST] find png

Hi dear, I'm looking for png image, you know where I can find them?
{
"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 apologize for my English, I use google traslator
thanks in advance.

those aren't images, you can change the colour of them in framework-res.apk\res\drawable\progress_horizontal.xml.
3x colour codes top/middle/bottom for the progress bar (@id/progress)

But how to modify this xlm?
Is closed
I so far I have never ever changed a xlm, I just changed png file.
I have no idea
Thanks for support

Decompile using apktool, make changes to xml using notepad, recompile using apktool. Done.

Decompiling an APK without having already used APKTool can be potentially frustrating.
If you are interested, these may help:
Tutorial Part 1: http://www.youtube.com/watch?v=YgWd0jsDtH0
Tutorial Part 2: http://www.youtube.com/watch?v=X1BWaQq1O0Q
Josh.

Ok, decomplile apk with apkmanager, open with notepad progress_horizzontal.xlm
This is the result:
if I want the color blue board, for example, this:
What value should I put??
This?? 00bcea
In which rows??
This is the content of my XML:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<layer-list
xmlns:android="http://schemas.android.com/apk/res/android">
<item android:id="@id/background">
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#ff525558" android:endColor="#ff525558" android:angle="270.0" android:centerY="0.8" android:centerColor="#ff0b0c0d" />
</shape>
</item>
<item android:id="@id/secondaryProgress">
<clip>
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#80b4ed2d" android:endColor="#a07daf18" android:angle="270.0" android:centerY="0.8" android:centerColor="#80649016" />
</shape>
</clip>
</item>
<item android:id="@id/progress">
<clip>
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#ffb4ed2d" android:endColor="#ff7daf18" android:angle="270.0" android:centerY="0.8" android:centerColor="#ff649016" />
</shape>
</clip>
</item>
</layer-list>
Little help?

Yep, that's all. Just make sure that there is a hash in front.
Josh

if you want the progress bar all one colour top to bottom.
the 'ff' at the start of the colour code is the transparency 'ff' being solid colour.
Code:
<?xml version="1.0" encoding="UTF-8"?>
<layer-list
xmlns:android="http://schemas.android.com/apk/res/android">
<item android:id="@id/background">
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#ff525558" android:endColor="#ff525558" android:angle="270.0" android:centerY="0.8" android:centerColor="#ff0b0c0d" />
</shape>
</item>
<item android:id="@id/secondaryProgress">
<clip>
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#80b4ed2d" android:endColor="#a07daf18" android:angle="270.0" android:centerY="0.8" android:centerColor="#80649016" />
</shape>
</clip>
</item>
<item android:id="@id/progress">
<clip>
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor=[COLOR="Red"]"#ff00bcea"[/COLOR] android:endColor=[COLOR="Red"]"#ff00bcea"[/COLOR] android:angle="270.0" android:centerY="0.8" android:centerColor=[COLOR="Red"]"#ff00bcea"[/COLOR] />
</shape>
</clip>
</item>
</layer-list>

Ok, I modified the XML, the result is pitiful:
I changed two values in order to test, the volume has gone crazy
In summary:
First line what color change?
second line?
third line??
This il my modify xlm:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<layer-list
xmlns:android="http://schemas.android.com/apk/res/android">
<item android:id="@id/background">
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#ff46e2f9" android:endColor="#ff525558" android:angle="270.0" android:centerY="0.8" android:centerColor="#ff01b0e9" />
</shape>
</item>
<item android:id="@id/secondaryProgress">
<clip>
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#8046e2f9" android:endColor="#a07daf18" android:angle="270.0" android:centerY="0.8" android:centerColor="#8001b0e9" />
</shape>
</clip>
</item>
<item android:id="@id/progress">
<clip>
<shape>
<corners android:radius="5.0dip" />
<gradient android:startColor="#ff46e2f9" android:endColor="#ff7daf18" android:angle="270.0" android:centerY="0.8" android:centerColor="#ff01b0e9" />
</shape>
</clip>
</item>
</layer-list>
I was wrong?

RoBy46 said:
Ok, I modified the XML, the result is pitiful:
I changed two values in order to test, the volume has gone crazy
In summary:
First line what color change?
second line?
third line??
I was wrong?
Click to expand...
Click to collapse
yes that looks pitiful
did you read the post i made where i changed the colours and highlighted them in red for you?
1st line = @id/background
2nd line = @id/secondaryProgress
3rd line = @id/progress
you want to change the 3 colours in the @id/progress line - top, bottom and middle colours all in the same line of code.

Problem with Broadcast Receiver of SMS messages

I'm finishing my application and got to test in various devices. I have tested into Galaxy SIII running 4.0.x and 4.1.x versions, and with some 2.3.3+ devices (I have heavily tested into 2.3.x devices, because on my mind, the bugs was to appear more into OLD devices).
My problem comes with Sony Xperia U. When I tested with 2.3.7 ROM, my application worked fine, but when I upgraded these devices (I have access to 2 xperia u devices), my application Broadcast Receiver of SMS isn't being triggered.
I have double checked my permissions and I repeat: It works in various others devices. After looking into logcat, I saw some messages:
Force stop package <mypackagename> and one line below:
Start proc com.sonyericsson.eventstream
{
"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"
}
There is some trick I'm missing? Also, I have decompiled some application that receives SMS, and they use the same permissions...
Here is my receivers and permissions:
Code:
<!-- Incoming SMS receiver -->
<receiver android:name="<mypackage>.ReceiverMessages" >
<intent-filter android:priority="2147483647" >
<action android:name="android.provider.Telephony.SMS_RECEIVED" />
</intent-filter>
</receiver>
<!-- Device boot receiver -->
<receiver android:name="<mypackage>.ReceiverAppBoot" >
<intent-filter>
<action android:name="android.intent.action.BOOT_COMPLETED" />
</intent-filter>
</receiver>
<!-- Shutdown request receiver -->
<receiver android:name="<mypackage>.ReceiverShutdown" >
<intent-filter>
<action android:name="android.intent.action.ACTION_SHUTDOWN" />
</intent-filter>
</receiver>
<!-- Outgoing call receiver -->
<receiver android:name="<mypackage>.ReceiverOutgoingCalls" >
<intent-filter android:priority="2147483647" >
<action android:name="android.intent.action.NEW_OUTGOING_CALL" />
</intent-filter>
</receiver>
<!-- Incoming call receiver -->
<receiver android:name="<mypackage>.ReceiverIncomingCalls" >
<intent-filter android:priority="2147483647" >
<action android:name="android.intent.action.PHONE_STATE" />
</intent-filter>
</receiver>
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_WIFI_STATE" />
<uses-permission android:name="android.permission.CHANGE_WIFI_STATE" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.CHANGE_NETWORK_STATE" />
<uses-permission android:name="android.permission.RECEIVE_SMS" />
<uses-permission android:name="android.permission.READ_SMS" />
<uses-permission android:name="android.permission.SEND_SMS" />
<uses-permission android:name="android.permission.WRITE_SMS" />
<uses-permission android:name="android.permission.MODIFY_AUDIO_SETTINGS" />
<uses-permission android:name="android.permission.READ_PHONE_STATE" />
<uses-permission android:name="android.permission.PROCESS_OUTGOING_CALLS" />
<uses-permission android:name="android.permission.READ_CONTACTS" />
<uses-permission android:name="android.permission.WRITE_CONTACTS" />
<uses-permission android:name="android.permission.READ_CALL_LOG" />
<uses-permission android:name="android.permission.WRITE_CALL_LOG" />
<uses-permission android:name="android.permission.CALL_PHONE" />
<uses-permission android:name="android.permission.ACCESS_COARSE_LOCATION" />
<uses-permission android:name="android.permission.ACCESS_FINE_LOCATION" />
<uses-permission android:name="android.permission.WRITE_SETTINGS" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.RECEIVE_BOOT_COMPLETED" />
<uses-permission android:name="android.permission.ACTION_SHUTDOWN" />
<uses-permission android:name="android.permission.WAKE_LOCK" />
<uses-permission android:name="com.android.vending.CHECK_LICENSE" />
Thanks.

[GUIDE][TUT]Remove useless alphabets from pin lockscreen

Simple Guide To make Pin Lockscreen from:
{
"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"
}
To​​
Requirements:
1. Knowledge of compiling/recompiling apk
2. Framework-res.apk of your phone
Steps:
1. De-compile framework-res.apk
2. After decompiling go to framework-res.apk\res\values folder and open arrays.xml
3. In arrays.xml find
Code:
<string-array name="lockscreen_num_pad_klondike">
It must be like this
Code:
<string-array name="lockscreen_num_pad_klondike">
<item></item>
<item></item>
<item>ABC</item>
<item>DEF</item>
<item>GHI</item>
<item>JKL</item>
<item>MNO</item>
<item>PQRS</item>
<item>TUV</item>
<item>WXYZ</item>
</string-array>
Simply remove all alphabets from it abc,def, so on
So that it look like this
View attachment 3098201
Save and close it.
4. In same folder open styles.xml and find
Code:
<style name="Widget.Button.NumPadKey" parent="@style/Widget.Button">
It must be something like this
Code:
<style name="Widget.Button.NumPadKey" parent="@style/Widget.Button">
<item name="textSize">34.0dip</item>
<item name="textStyle">normal</item>
<item name="textColor">#ffffffff</item>
[COLOR="Red"]<item name="gravity">left|center</item>[/COLOR]
<item name="background">?selectableItemBackground</item>
[COLOR="Red"]<item name="paddingLeft">20.0dip</item>[/COLOR]
<item name="paddingBottom">10.0dip</item>
<item name="singleLine">true</item>
<item name="fontFamily">sans-serif</item>
</style>
Simply change the red line with this
Code:
<item name="gravity">center</item>
Code:
<item name="paddingLeft">0.0dip</item>
Remeber 20.0dip we changed to 0.0dip will use it later. [maybe it is different in your case whatever it is just remember it]
So that the whole code looks like this
View attachment 3098219
We just made the keys 1,2,3 etc in center
5. Now go to framework-res.apk\res\layout folder and open keyguard_pin_view.xml
Find this line
Code:
<[COLOR="Red"]ImageButton androidprv:id="@id/key_enter"[/COLOR] androidprv:paddingRight="30.0dip" androidprv:layout_width="0.0px" androidprv:layout_height="fill_parent" androidprv:src="@drawable/sym_keyboard_return_holo" androidprv:layout_weight="1.0" androidprv:contentDescription="@string/keyboardview_keycode_enter"
style="@style/[COLOR="Red"]Widget.Button.NumPadKey[/COLOR]" />
Since we changed the style of Widget.Button.NumPadKey to fix it for enter key we will add this in the above line.
Remember the 20.0dip we changed its placed here if something else in your case put that
Code:
androidprv:paddingLeft="20.0dip"
Now new line will look like this
Code:
<ImageButton androidprv:id="@id/key_enter" [COLOR="Red"]androidprv:paddingLeft="20.0dip"[/COLOR] androidprv:paddingRight="30.0dip" androidprv:layout_width="0.0px" androidprv:layout_height="fill_parent" androidprv:src="@drawable/sym_keyboard_return_holo" androidprv:layout_weight="1.0" androidprv:contentDescription="@string/keyboardview_keycode_enter" style="@style/Widget.Button.NumPadKey" />
Since we made the keys in center then pin we enter is not above the 2 key so to make the pin in center find
Code:
<TextView androidprv:textAppearance="@style/TextAppearance.NumPadKey" androidprv:gravity="center" [COLOR="Red"]androidprv:id="@id/pinEntry"[/COLOR] androidprv:background="@null" androidprv:paddingLeft="40.0dip" androidprv:layout_width="0.0dip" androidprv:layout_height="fill_parent" androidprv:cursorVisible="false" androidprv:singleLine="true" androidprv:editable="true" androidprv:layout_weight="1.0" androidprv:imeOptions="actionDone|flagForceAscii" androidprv:layout_marginStart="@dimen/keyguard_lockscreen_pin_margin_left" />
Add this in the above line
Code:
androidprv:paddingLeft="40.0dip"
Just double of 20.0dip
Now changed line will look like this
Code:
<TextView androidprv:textAppearance="@style/TextAppearance.NumPadKey" androidprv:gravity="center" androidprv:id="@id/pinEntry" androidprv:background="@null" [COLOR="Red"]androidprv:paddingLeft="40.0dip"[/COLOR] androidprv:layout_width="0.0dip" androidprv:layout_height="fill_parent" androidprv:cursorVisible="false" androidprv:singleLine="true" androidprv:editable="true" androidprv:layout_weight="1.0" androidprv:imeOptions="actionDone|flagForceAscii" androidprv:layout_marginStart="@dimen/keyguard_lockscreen_pin_margin_left" />
6. Save and Recompile and replace framework-res.apk and enjoy clean beautiful lockscreen.
If you like It Hit Thanks Button

Heart Rate Sensor Problem

Hi guys, my heart rate monitor sensor is not working and the sensor doesn't even light up, which means it's not working AT ALL! And recently I even noticed Antutu and CPU-Z(Sensor Section) doesn't even detect it! (Screenshot below) What may be the cause of this?
Here is the logcat output of the BioSensor:
Code:
E/EnterpriseSharedDevicePolicy( 1132): isSharedDeviceEnabled
E/SensorService( 1132): Error activating sensor 18 (Operation not permitted)
E/SensorService( 1132): Error activating sensor 18 (Operation not permitted)
E/MaximBio( 1132): File Open Failed : /sys/class/sensors/hrm_sensor/led_current
E/MaximBio( 1132): File Open Failed : /sys/class/sensors/hrm_sensor/led_current2
E/MaximBio( 1132): File Open Failed : /sys/class/sensors/hrm_sensor/lib_ver
E/audio_hw_primary( 338): [MAXIM] setDSM_tx_Control()....dsm_enable : 0, dsm_opened : 1, adev->mode : 0
E/LocSvc_libulp( 1132): I/int ulp_msg_process_system_update(UlpSystemEvent): systemEvent:5
E/LocSvc_libulp( 1132): I/int ulp_msg_process_start_req(), at ulp state = 1
E/LocSvc_ApiV02( 1132): I/<--- void globalRespCb(locClientHandleType, uint32_t, locClientRespIndUnionType, void*) line 125 QMI_LOC_GET_BEST_AVAILABLE_POSITION_REQ_V02
E/LocSvc_libulp( 1132): I/int ulp_brain_process_zpp_position_report(loc_sess_status, LocPosTechMask, const UlpLocation*), report ZPP position to providers,report_position = 1
{
"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"
}

Was your heart rate monitor working before? Have you tried doing a hard factory reset to see if it will help?

DarkGuyver said:
Was your heart rate monitor working before? Have you tried doing a hard factory reset to see if it will help?
Click to expand...
Click to collapse
I didn't try the heart sensor before, never really gave it much thought...
Yes, I've tried to do a Hard Reset, I even flashed new firmware via Kies and made the Soft Reset (Take of the battery, press power btn for 1 min, yadayada) and it still doesn't work... I've uploaded a logcat check 1st post.

I'd take your phone to a Samsung Service Center and ask them to fix it for you. Or take it back to the retailer for repairs as it maybe faulty.

Btw did u get the solution b/c I have same problem