Database Users

diff between android and debian

This might be a little odd, i'm on my vaication and i'm trying to learn a bit of linux! it's a very long vaication though
The thing is, i don't have internet where i am (accept 2g on my x10) and i don't have a computer (again, accept my x10)
So i'm reading this book "Linux Fundamentals" and i noticed some of the commands are not supported in android, i'm using better terminal and i'm rooted to r2 023.
The commands that are missing for eg. are ls -i so i can't see the inodes, cal for calendar, man for manual etc...
Is there some other way to access those commands or do they just don't exist on android?
The most problems i've been having is with the grep command. It seems to work because it gives me an explination of how to use it but when i try something loke this:
grep "this" demo_file - i get nothing and i should be getting:
this line is the 1st lower case line in this file Two lines above this line is empty
Am i doing something wrong or i just won't work whatever i try?
Sorry for being such a noob, i'm trying tho thanks

come on, no one?
EDIT: Can a mod please move this to the dev pages? Thanks

You might have more luck re posting this in the development pages..
Sent from my x10 using XDA and swype.

New Sense Launcher -Alchemy

Do you know that game from the market alchemy when you combine 2 things and you get a new one(ex:Fire + Water = Steam). While experimenting with various sense bar(launcher) themes I've discovered if you flash 2 different ones right after another(no reboot between them) you get a completely new one.
Cool isn't it?
I will try to extract the framework and put it on an update.zip. I love to see your opinions on this one

TheRedDrake said:
Do you know that game from the market alchemy when you combine 2 things and you get a new one(ex:Fire + Water = Steam). While experimenting with various sense bar(launcher) themes I've discovered if you flash 2 different ones right after another(no reboot between them) you get a completely new one.
Cool isn't it?
I will upload some screenshots(have to reflash to make them ) and post the recipies..right now I've discovered two..more will come. I love to see your opinions on this one
Click to expand...
Click to collapse
Haha, I'm waiting eagerly for the screens

Updateidn't work! I need help from a dev with this.
Got it to work again putting the screenshots

zHk3R said:
Haha, I'm waiting eagerly for the screens
Click to expand...
Click to collapse
You got them

IMO it looks better than the Sense dock does.
What themes did you flash?

I discovered that D&D Rosie must be flashed also in the process it won't work without it. I don't know how to extract the framework from an installed rom. Any help would be nice.

looks pretty nice but can you tell me if its possible to have app draw button in the centre where the phone is and have phone on left and contacts on right?

If you want Themes based on this go here: http://forum.xda-developers.com/showthread.php?t=789252

Ronaldo_9 said:
looks pretty nice but can you tell me if its possible to have app draw button in the centre where the phone is and have phone on left and contacts on right?
Click to expand...
Click to collapse
I'l take a look into that but since we are talking about sense it is very hard to change the functions

TheRedDrake said:
I discovered that D&D Rosie must be flashed also in the process it won't work without it. I don't know how to extract the framework from an installed rom. Any help would be nice.
Click to expand...
Click to collapse
To extract a framework-res.apk from an installed ROM you're going to have to use adb. I'm sure you know how to use adb since you're able to flash zips through recovery, but in case you don't know the exact commands i'll tell you what they are.
So you'll want to start up command prompt or whatever program you use to run commands through adb. Then start up adb through these commands:
1. So first put in the command, "cd\" and replace the letter "c" with whatever drive you put androidsdk on.
2. After that put in "cd AndroidSDK\tools\". If you put the filepaths differently on your computer from what I have, which is on the c drive, AndroidSDK folder, then the tools folder, feel free to change it to whatever you have it set up as. Keep in mind that it has to be exactly as what it says in your directory or it won't work. This means spelling and capitalization really counts here.
3. Next put in the command, "adb devices" and your device number should pop up if not then there is something wrong, but I'm assuming it'll pop up since you got your phone rooted.
4. Anyways after that you'll want to put in the remount command, "adb remount" which allows your phone's system apps or other lower level things to be written over and such.
5. Following that step you'll want to pull the apk with this command, excluding the quotation marks, "adb pull /system/framework/framework-res.apk". The exact filepath might be a little different on your phone but you can check easily with a file manager program that has access to those directories such as Root Explorer.
6. Finally after you've done all of that you should find the extracted framework-res.apk in the folder tools folder of the AndroidSDK folder.
If you already know the commands to do so then you can just disregard this. If not then I hope this helps you out.

I learned this already, thanks any way. What do you think about the theme?
Sent from my HTC Desire using Tapatalk

TheRedDrake said:
...What do you think about the theme?...
Click to expand...
Click to collapse
Clock digits are too big and look quite disproportionate on the face of that screen and also relative to the clock hands
The launcher bar looks quite cheap and poor (no colour, gradient, gloss, blend of any kind)
Nice effort but definitely not for me, I think. The MT4G launcher mod is the best launcher mod at the moment I think. Maybe also take a look at the SenseHD themes/skins and you'll see some great polished looking launchers there which may help improve your concept...

Facebook pictures in 3rd Party Apps. (Requires Root)

I know this has been addressed before, but I never saw a fix for it in the Droid X world. Basically, since version 1.3 of the Facebook app and Android 2.x, your contact pictures would not show up in 3rd party apps such as Dialer One, Launcher Pro widgets, and some messaging apps. This is a facebook thing, not Android.
In any case, I've used SyncMyPix for some time, but was tired of having to go manually update the pictures and what not, so I returned to my old home in the Eris forums and did some searching. Zanfur, one of the great devs over there worked out a more permanent fix at the database level. You can see the original thread HERE.
Unfortunately, this doesn't work with Blur, so I had to do a little screwing around with the code to get it to go. I take absolutely zero credit for this. All I did was write a batch file that works with our Blur-enabled phones.
Basically, the script will remove the permissions restrictions on existing contacts and add a trigger to automatically remove them whenever a new contact is added, synced, etc.
WARNING: As of yet, I have had no issues with this, however, you ARE fooling with a database that you SHOULDN'T be playing in. Therefore, make a NAND backup before doing this. I take no responsibility if you screw up your phone.
You must have the Android SDK installed and working for this to work. If you don't have that up and running already, you probably shouldn't be doing this.
Instructions:
1) Unzip the file to the \tools directory of the SDK
2) Open a command prompt and navigate to your tools folder. *see note
3) Type "facebookfix" without the quotes. Note: This will reboot your phone!
4) Wait for your phone to reboot, and enjoy your facebooky goodness.
*Alternatively, you can just doubleclick "facebookfix.bat", but when someone is doing things to my phone, I like to see what's going on.
Another warning: If you are running a ROM without BlurContacts, this will not work. I doubt it will break anything, but it will most likely error out.

Do you happen to have a solution for the opposite?
I hate how FB dominates my phone. I absolutely love an option to choose between the FB photo and a custom photo like I had on my WinMo phone (Touch Pro 2).
It's a Catch 22 with FB. I love having status updates when I get a call and picture updates, but I also don't like how some pictures it misses a face and I see the persons torso... or worse yet a picture of their pets instead of them.

EtherBoo said:
Do you happen to have a solution for the opposite?
I hate how FB dominates my phone. I absolutely love an option to choose between the FB photo and a custom photo like I had on my WinMo phone (Touch Pro 2).
It's a Catch 22 with FB. I love having status updates when I get a call and picture updates, but I also don't like how some pictures it misses a face and I see the persons torso... or worse yet a picture of their pets instead of them.
Click to expand...
Click to collapse
Just open the contact and manually set a picture. It will always override the FB pics.

Only does for other applications, but not for the address book and / or the phone app.

EtherBoo said:
Only does for other applications, but not for the address book and / or the phone app.
Click to expand...
Click to collapse
I wrote a little SQL script that will set your contacts to only read pictures from google, but obviously you would need to manually sync up your photos from SyncMyPix or the like. You should still get all your status updates and what-not.
Just hook up to adb and copy and paste these one at a time.
Code:
adb pull /data/data/com.motorola.blur.providers.contacts/databases/contacts2.db
sqlite3 contacts2.db "UPDATE blur_sources SET picture_source=0 WHERE gams_account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE'); UPDATE blur_sources SET picture_source=1 WHERE gams_account_type in ('com.google');"
adb push contacts2.db /data/data/com.motorola.blur.providers.contacts/databases/contacts2.db
adb shell "chmod 777 /data/data/com.motorola.blur.providers.contacts/databases/contacts2.db"
adb reboot
Should you decide this isn't what you want, you can run it again reversing picture_source=. Should put you back to normal.

erishasnobattery said:
I wrote a little SQL script that will set your contacts to only read pictures from google, but obviously you would need to manually sync up your photos from SyncMyPix or the like. You should still get all your status updates and what-not.
Just hook up to adb and copy and paste these one at a time.
Code:
adb pull /data/data/com.motorola.blur.providers.contacts/databases/contacts2.db
sqlite3 contacts2.db "UPDATE blur_sources SET picture_source=0 WHERE gams_account_type in ('com.motorola.blur.service.bsutils.MOTHER_USER_CREDS_TYPE'); UPDATE blur_sources SET picture_source=1 WHERE gams_account_type in ('com.google');"
adb push contacts2.db /data/data/com.motorola.blur.providers.contacts/databases/contacts2.db
adb shell "chmod 777 /data/data/com.motorola.blur.providers.contacts/databases/contacts2.db"
adb reboot
Should you decide this isn't what you want, you can run it again reversing picture_source=. Should put you back to normal.
Click to expand...
Click to collapse
Sweet!
You mean copy each line by itself?
A friend told me I could also do this via a terminal app (can't install Android SDK on work laptop, and I'll be out of town until next week).

Yeah, just run one line at a time.
I've tried this like 100 different ways in terminal emulator, but something with permissions seems to be preventing me from editing the database in place, hence pulling it off the phone, modifying it, and sticking it back.

Auto-rotate screen (colaberative 6 axis, G-Sensor, Accelerometer, Gyrometer) fix

First off let me say thanks to the many members that posted pieces of this fix for various Samsung phones.
The sole purpose of this post is to condense the info I found spread out across multiple threads when trying to resolve this issue myself. Hopefully making it easier for future users that may have the same problem I did. Which is why I have the various sensor names in the subject.
If your phone is having problems auto-rotating, or does not rotate at all in any app (like mine did). These steps should get you working again. This will be overkill in some cases but I like to cover all my bases when something is not working to begin with.
Note: This assumes you are running Android 2.2 (if you are not, you will not be able to perform the last step, but your phone should still work properly without it). Your phone will need to be rooted with busybox and you will need a terminal emulator app installed. I have attached the "Android Terminal Emulator" apk just in case you don't have or know what that is.
open your terminal type su press enter
type cd /data/system press enter
type rm ms3c_yamaha.cfg press enter
type cd /system/bin press enter
type ./sensorcalibutil_yamaha press enter
secure your phone on a flat level surface and gently press the enter key on your keyboard
type exit press enter
type exit press enter
Close your terminal and go to menu -> Display -> Horizantal calibration
turn your phone upside down with the bottom edge over hanging the table you used as a flat surface so that you can just barely see the calibration button when you are looking under the phone. Gently press the calibration button.
All done, you should be in working order!

Nice post! But the Epic does not require all of these steps that other phones might.(assuming your using Terminal Emulator)
Once within terminal, type
"su"
then you only need to type
"sensorcalibutil_yamaha" and press enter. Then follow the steps on the screen.
As far as hanging the bottom edge over the table goes, it's not necessary. The Epic is level on both ends because the camera protrudes at the other.

A couple of weeks ago, i had the problem where sensorcalibutil... in terminal emulator (and adb etc) was failing when trying to execute. Deleting the file above did fix this. So, maybe update the op to only try that if it fails. Thx for putting this together juise
Sent from my SPH-D700 using Tapatalk

decalex said:
A couple of weeks ago, i had the problem where sensorcalibutil... in terminal emulator (and adb etc) was failing when trying to execute. Deleting the file above did fix this. So, maybe update the op to only try that if it fails. Thx for putting this together juise
Sent from my SPH-D700 using Tapatalk
Click to expand...
Click to collapse
Good point. I've never run into that issue myself, and I'm not sure what would cause it, but deleting that file would fix it.

Auto rotation.
Thanks for posting this. I was having this problem on my phone and now it's fixed!

Ahhh! This has finally fixed my auto-rotation issues! My phone has been unable to auto-rotate for months and now it works again. Thanks much!

mattallica76 said:
Nice post! But the Epic does not require all of these steps that other phones might.(assuming your using Terminal Emulator)
Once within terminal, type
"su"
then you only need to type
"sensorcalibutil_yamaha" and press enter. Then follow the steps on the screen.
As far as hanging the bottom edge over the table goes, it's not necessary. The Epic is level on both ends because the camera protrudes at the other.
Click to expand...
Click to collapse
Actually I needed to delete the cfg file with my Epic, so the need is there depending on the problem. This why I say in some cases this may be overkill, but it if you follow the instructions as posted no harm can come of completing all the steps I chose to list. As long as you don't have faulty hardware you should be back in business after completing them.
If my years with BSD/Linux have taught me anything, it's assume nothing! If you know *nix you'll notice that my commands assume nothing about the user environment. To me that is the safest way to provide instructions like these to users that may not be familiar with the OS.

Thank you for this consolidation... for noobies like me, searching all the forums can be a lil intimidating... this may be "overkill" like you said, but it sped up my auto-rotate like nobody's business. You get TWO thumbs up...

juise said:
Actually I needed to delete the cfg file with my Epic, so the need is there depending on the problem. This why I say in some cases this may be overkill, but it if you follow the instructions as posted no harm can come of completing all the steps I chose to list. As long as you don't have faulty hardware you should be back in business after completing them.
If my years with BSD/Linux have taught me anything, it's assume nothing! If you know *nix you'll notice that my commands assume nothing about the user environment. To me that is the safest way to provide instructions like these to users that may not be familiar with the OS.
Click to expand...
Click to collapse
Good philosophy. I'm just currious as to why that file would get corrupted in the first place. Unless folks are trying to restore data from a froyo Rom onto an eclair rom, this should not be happening. The file resides on the data partition which would have been wiped durring the install process, assuming it was done correctly. Ha, there I go assuming again.
Sent from my SPH-D700 using Tapatalk

meh i guess it works. didnt really do anything though.

Sooo... telnetd is on this phone?

I recently got a .lxterminal from my Atrix to my computer's X11/Xorg server. From there it was a matter of time.
/system/xbin/adduser whatever
/system/xbin/telnetd
on local machine...
telnet <atrix IP>
So we don't have ssh, but hell old school telnet works. Not sure what help this is or if anyone else has found this yet. So just throwing it out there. Makes it a hell of a lot easier to muck around ;-)
I guess the adduser / telnetd could be done from a terminal app as well...
Well.. I was able to add my user to the sudoers file using w! in vi, and create my .bashrc (sudo works). Also managed to "start" the webtop to my laptops's x11. By start I mean I get the webtop-wallpaper show up in my laptop's X11. My goal would be to get the webtop to be able to be viewable remotely. Why?... Why not? Pretty useless I guess, but whatever.

so i logged in using telnet as well, but how did you go about starting the x session to your laptops x11?

Moved to generas as not android dev.

aaaaaaaaaaaaaaaaagda

kriffer said:
so i logged in using telnet as well, but how did you go about starting the x session to your laptops x11?
Click to expand...
Click to collapse
It only showed the wallpaper, but here's what i did:
on computer, verify you have x11 forwarding set up. Depending you need to edit your hosts.allow, and maybe an X config to allow connections.
on computer
1. xhost <atrix IP>
on atrix connection
2. export DISPLAY=<computer IP>:0
3. sudo /osh/etc/alternatives/x-session-manager
or
sudo /osh/usr/bin/x-session-manager
that pops open the wallpaper, like i said. Doesn't seem to open the webtop completely

Any progress on this?

nope... I kinda left it for another time when I'm bored.