Whatsapp sending messages via sqlite3 INCLUDE (root) - Android Q&A, Help & Troubleshooting

If you have root access on your devices it's easy to connect to the sqlite3 databases from Whatsapp. (/data/data/com.whatsapp/databases)
So there's no problem reading any message or contact details with the ADB shell and some simple SQL SELECT statements.
BUT!
Is there any posibility to send messages for example with SQL INCLUDE?
If you're searching the web you can find people using Tasker to do that, but how can you do it directly from the shell?
(I want do build an open-source application to send and receive whatsapp messages easily with the PC)

Related

[Q] Can i send SMS over Android Terminal (shell)

Can i send sms over Android Terminal, not use any applications on side of Android, like ShellSms?
Check out this link; http://stackoverflow.com/questions/4043490/how-to-send-an-sms-from-a-shell

[Q] SSH port forwarding stopped working

I have been using Connectbot to forward a local port (higher than 1024) to a remote mail server, on my Android phone, and it has worked well. After I rooted my Nook Tablet, I used the same settings as on my phone and it worked, but today it no longer works. I can connect to the remote SSH server but Connectbot is not forwarding the ports. I suspect it is a problem with permissions. Is there a way to fix the permissions for Connectbot so it can forward ports?
Another possible problem is that my Nook does not (it seems) know what 'localhost' means. I even tried 127.0.0.1 in a terminal and the terminal could not find it. This might be the actual problem causing port forwarding to fail, but it was working earlier and just stopped working.
BTW the same setup still works on the phone so I know the remote host is not the issue.
OK for fix permissions you could try the option for that in CWM recovery if you have it installed. You could change permissions by using root explorer or ES file explorer apps too but im not sure which files you should fix, but you can try giving more permissions to the Connectbot app and change owner to root aswell if you dont know how to do it check this how to made by me.
About the localhost address adfree app that i use to get rid of advertisings use 127.0.0.1 ip to install hosts, make sure you have installed busybox that means open busybox app and verify that you have busybox 19.x.x installed, if not then install it.
~ Veronica
I will check but I am almost certain I have Busybox installed. I went to a cafe and my setup works, it just does not work at the library where they do NOT block port 443 and I am able to do port forwarding at the library on Linux (OpenSSH) and also Windows (with Proxifier).
I think it might be a DNS problem which can be addressed within ConnectBot, and this setup was working last week at the library. I will check the things you mentioned in your reply. Thanks
BTW, it does not appear to be permissions related, since I am able to do port forwarding on ConnectBot when at an open access point (no credentialed login required).
[SOLVED]
Thanks for your help. I installed the "Hosts" host file editor and then added the localhost to it. I suspect that the ROM Toobox app might have removed the localhost when it added 3 addresses to the hosts file (at my request). When I used the hosts file editor to add "localhost", it removed those additions made by the ROM Toolbox. I will have to look into this and make sure that when I add entries, the old entries do not disappear.
ConnectBot is now forwarding ports again at the library, after this fix.

[Q] Access gsm modem from terminal

Hello, I'm trying to access the GSM modem from terminal (my aim is to have Arch Linux as basic OS and forget about Android, that means dial, send/receive sms etc.)
so, which is the right device? (/dev/ttyGSx doesn't work)
how can i send commands to it?
also, is there any "dialer" for linux??

[Q] adb Pull/ Push and Text msg/ Phone log

I have recently performed an adb pull to my PC using both the InstalledApps and SystemApps commands. I have hundreds of files now on my PC in these separate folders. This removed my phone log and text messages completely from my old phone.
I want to now adb push them onto my newer phone. Any backup software is meant to backup data BEFORE removing which I didn't know at the time.
What files or process would I perform to copy phone log and text messages to my newer phone?
I found the location of the database on the phone.
/data/data/com.android.providers.telephony/databases/mmssms.db
Buuuuump

Debloat after Pie, now apps get stuck on "installing"

Debloated after getting the Pie update, and I'm having issues installing apps. Doesn't matter if it's the Play Store, Galaxy Store, or any other method, they just hang on "installing" forever. Problem goes away if I go into the settings>apps>reset app preferences, but this of course re-enables everything and I have to setup a lot of my apps again. I know I basically need to go through my list one by one and figure out what is causing this, but was hoping since I won't have time to do that for a few days, if I posted my list here someone might be able to pinpoint the problem. I had these (and more) disabled while on Oreo, so I'm not sure what the issue is. Any help is appreciated!
Apps I disabled:
ANT + DUT (com.dsi.ant.sample.acquirechannels)
ANT Radio service (com.dsi.ant.service.socket)
ANT+ HAL service (com.dsi.ant.server)
ANT+ Plugins Service (com.dsi.ant.plugins.antplus)
Bixby Service (com.samsung.android.bixby.service)
Call (com.samsung.android.incallui)
com.sec.phone
Device Security (com.samsung.android.sm.devicesecurity)
Email (com.samsung.android.email.provider)
Excel (com.microsoft.office.excel)
Galaxy Essentials Widget (com.sec.android.widgetapp.samsungapps)
Gallery (com.sec.android.gallery3d)
Gmail (com.google.android.gm)
Hangouts (com.google.android.talk)
Kids Home (com.sec.android.app.kidshome)
Kids Home Installer (com.samsung.android.kidsinstaller)
Maps (com.google.android.apps.maps)
OneDrive (com.microsoft.skydrive)
OneNote (com.microsoft.office.onenote)
PENUP (com.sec.penup)
Phone (com.android.server.telecom)
Phone (com.android.phone)
PowerPoint (com.microsoft.office.powerpoint)
Recolor (com.sumoing.recolor)
Samsung Flow (com.samsung.android.galaxycontinuity)
Skype (com.skype.raider)
SmartThings (com.samsung.android.easysetup)
SmartThings (com.samsung.android.beaconmanager)
SmartThings (com.samsung.android.ststub)
Texture (com.nim.discovery)
Wearable Manager Installer (com.samsung.android.app.watchmanagerstub)
What's New (com.samsung.android.app.social)
Word (com.microsoft.office.word)
Got some time this morning and figured it out. Turns out you can't disable Device Security with the Pie update or things get screwy. I've got that disabled on my Note10+ and I believe it was disabled on my Note9, but on the Tab S3 it's a no-no it seems.
So don't disable Device Security (com.samsung.android.sm.devicesecurity) and you should be fine.
Can you share the steps to disable all these apps? I only have a Chrome OS and Linux computer.
Sent from my SM-T820 using Tapatalk
I'm not sure how to do it with those OS's exactly as I don't have a linux machine and haven't tried this on my chromebook. But I do know it's possible, you use terminal I believe. I use command prompt on windows (from within the platform tools folder of the android SDK). Don't even need that installed, I actually just have the platform tools folder on a flash drive I run my bat files from usually.
Contained in my bat files though are my commands to disable apps, enable apps, clear data, change screen resolutions, or whatever I'm doing.
Make sure your device has USB debugging turned on in developer settings. Then the command I use to make sure it's connected after plugged in and the drivers install is "adb devices" without the quotes. Should come back with a number that's unique to your device. If that checks out, you can do all the other stuff.
To disable an app I use these three commands per app, it's two extra steps compared to most people, but it clears out the data for the apps before disabling them.
adb shell pm enable --user 0 "app package name here"
adb shell pm clear "apk package name here"
adb shell pm disable-user --user 0 "package name here"
No quotes of course. And just repeat those lines for each app you want to disable. Grab the package names using the app Apk Analyzer by Martin Styk.
Hope this helps, if not feel free to ask and I can always boot up linux from a USB or try it out on ChromeOS.
One more thing I'll add is that you may want to leave gallery3d enabled if you use certain s-pen gestures like smart select.
elcidroyale said:
Can you share the steps to disable all these apps? I only have a Chrome OS and Linux computer.
Sent from my SM-T820 using Tapatalk
Click to expand...
Click to collapse
You need to have adb and fastboot installed on your Linux machine. Most distributions should have this packages within their repositories. So you can use your packetmanager.
whoosename said:
You need to have adb and fastboot installed on your Linux machine. Most distributions should have this packages within their repositories. So you can use your packetmanager.
Click to expand...
Click to collapse
I actually used Package Disabler Pro app and disabled everything you did and more easily!

Categories

Resources