yashsingh1/xdaforums huggingface dataset:
[Android Auto General] furious2000:
aamirror problem

I have a problem with using aamirror (rooted samsung galaxy s9 with supersu). I have installed aamirror and aaunlock and it works perfect in the last months.

I also use the actual version of aa from the Google playstore. So all was fine :)

since this week it doesnt work. when I start aa in my car and click to the symbol on the right, there is no option to start aamirror. I deinstalled all programs (aamirror, aa and aaunlock) and tried it again - but it doesnt work. Same problem. I saw that aamirror hasn't super su rights - but there was no option (no asking) to give supersu right to the app aamirror - has anyone an idea to fix the problem ?
[Android Auto General] KroenenPrime:
If you don't see anymore on your car AA Mirror it's probably because yoour Google Play Services got updated and now blocks it.

Since Google is working "hard" to prevent mirroring like this, the new method using triggering is the solution at the moment.
[Android Auto General] paolocorpo:
You have two options:

AAutoAppEnabler 1.1 of manudroid19

Or

Jen94's procedure

Both are on this thread:

https://r.tapatalk.com/shareLink?ur...share_tid=3853009&share_fid=3793&share_type=t

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] KroenenPrime:
I'm starting just at this point to provide some help for the next steps.

Video here : https://youtu.be/7hrPy29ESO4

Steps you see in the video :

Open Termux

Type : su

Type : sqlite3 /data/data/com.google.android.gms/databases/phenotype.db

Copy & Paste : AA Mirror version - AA Mirror Plus version - CarStream version - AA Mirror & AA Mirror Plus version - AA Mirror & AA Mirror Plus & CarStream version

Be aware that you can't take 2 versions, you must chose one or make your own if you need to.

Type : DELETE FROM Flags WHERE name="app_white_list";

Type : SELECT * FROM Flags WHERE name="app_white_list";

Close Termux

ENJOY !

Note : if you want to change your version, you must type this before 1.3. step :

DROP TRIGGER after_delete;

If you got some issues, get back to the original post from Jen94 which is more complete.

EDIT : I don't know how to embeed the video and don't have time to look for if I can, if someone know pm me, thank you !
[Android Auto General] 9h05t:
i gave aamirror Plus a try and it crashes and cause the phone to reboot everytime i escape from it.

I can select and enter mirror mode with it, but the moment i exit by tapping on the 'O' button of AA to exit mirror mode, it just crashes and causes the phone to reboot.

Moving back to aamirror for now.

Not sure whats the diff between the two also.
[Android Auto General] paolocorpo:
I tried several days ago as mirror plus when I was searching a way to reduce the issue related to the loosing of screen resolution of phone after the unplug

Well ..

... For sure and for many reasons I prefer aa_mirror

So my suggestion is: forgot it and let use as_mirror

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] furious2000:
Auto Enabler doesnt work also - I installed the app and read aamirror and go on apply and unlock - the restart the device - but when I start AA in my car - there is also no chance to select aa mirror ? where is my fault ?
[Android Auto General] paolocorpo:
After tapped on apply do you receive back a pop-up that invite you to reboot ?

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] furious2000:
Yes there was: Done, reboot on screen - and after reboot, it doesnt work - not shown in AA ... ?

---------- Post added at 03:53 PM ---------- Previous post was at 03:48 PM ----------

I downloaded aamirror plus, but there ist the same problem, can't select it in aa in my car .... ??
[Android Auto General] paolocorpo:
Which AA and GPS version are you using ??

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] furious2000:
Where can I check the GPS Version ?

AA is the actual from Play Store ...
[Android Auto General] paolocorpo:
Tap for a long time on icon and chose info

At the bottom of that page we see the version

Anyway ... Very probably it would be the last

At now I can only RI suggest you to use the Jen94's procedure

I can't ensure the success ... But it could be enough

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] furious2000:
You mean the post I see in #1241?
[Android Auto General] paolocorpo:
No

I mean the post of Jen94 that you find here post #110

https://r.tapatalk.com/shareLink?ur...share_tid=3853009&share_fid=3793&share_type=t

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] KroenenPrime:
Yup :good:

+ Original post is here : https://xdaforums.com/showpost.php?p=78289872&postcount=110
[Android Auto General] furious2000:
Ok, I will try it later - sounds complicated - how long will it take ?
[Android Auto General] paolocorpo:
Using a txt file to facilitate the paste and copy process ... 1/2 minutes

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] KroenenPrime:
Check the video I made if you got some troubles, but yes, 3 to 5 mins max to do it for the first time.
[Android Auto General] scarface77:
Dear Paolocorpo

i want use the Jen94's procedure but the only one think that is not clear for me is when i have to select "release mode" in AA: Do you kwnon the italian traslation of "Release mode"? Is it "Utente" or "Commercio al Dettaglio": I ask it to you because i know that you already asked my same question in one of this thread but i don't find the answer. Thank you so much for your help in advance
[Android Auto General] paolocorpo:
Dear,

It is translated in italian language Utente

Good luck

If you need help ... I am here

paolo
[Android Auto General] ammarhd:
@ KroenenPrime

Can you paste the link to the video please
[Android Auto General] paolocorpo:
Here for the video guide

https://youtu.be/7hrPy29ESO4
[Android Auto General] scarface77:
Thank you Paolo

only the last question: I have done all the procedure but i don't know how to close termux…..
[Android Auto General] paolocorpo:
I am using an alternative terminal emulator ... But don't worry about it

You can close it using the recent opened apps menu ... Or you can leave it opened ;)

The relevant thing is that every command has received back one (or more):

sqlite>

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] qllkevuoi:
today AA updated on my phone to version 3.8.xxx and when I tried to start AA mirror I didn't find in the listed apps on AA in my car head unit.

so, a few minutes ago I've re-done the jen94's procedure and I'm going to try again.

I'll report my results, for those who haven't tried yet this method
[Android Auto General] paolocorpo:
Have you tried with emulator too ?

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] qllkevuoi:
just with previous version and it worked fine both on emulator and on car.

now I tried again on car but aa mirror is not listed. in this moment I can't try on pc

I think I have to cancel the trigger and remake all the procedure from the beginning...
[Android Auto General] paolocorpo:
I think so ... So bad :(

As you know I blocked the update with Titanium

I know ... It could create a bad functionality for some Google Apps but so far ... All sound good ;)

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] GPSSlovakia:
is it possible to automate this process or create some batch file with all commands? or make it "one click" ?

thanx

see my attachment - something like this could work or this is no way ?
[Android Auto General] filnirv:
+1
[Android Auto General] ahhl:
Can the OP stick the solution to first thread. this thread is already 1200++ long. any request for help will make the solution lost as the thread become longer and longer
[Android Auto General] 9h05t:
If someone messed up while trying to apply Jen method, does he need to do something to reset or just simply tepeat the steps again?
[Android Auto General] steo_cha:
You can check some errors ... For example a space between two words... Otherwise try to rewrite the procedure.

I have AA 3.8.584564

GPS 14.7.99

It's all OK.

I've had the procedure with carscream, aa mirror, AAMirror plus, obd2aa, Performance monitor for vag.

Inviato dal mio STF-L09 utilizzando Tapatalk
[Android Auto General] paolocorpo:
Just a follow up ...

Please let refer to my previous post here

REPORT

DAY 0 - I applied the Jen94's procedure with success ( I have not received back any kind of message of error)

DAY 0 - Immediately later I tried to start AA on my emulator of car's head unit (let see attached picture) (it is a very simple application provided into Android Studio package created for the developers in order to test AA app when they have not a car availbale); no issue

All 3 apps of my personal white list where there (AA_mirror 1.0, AA_mirror Plus 1.0.1a and CarStream 2.0

DAY 1 - Retested with emulator; no issue

DAY 1 - I have tested with infotainment car's system > all OK

DAY 2 - Retested with emulator; no issue :)

DAY 2 - I have tested with infotainment car's system > no issue :)

DAY 3 - Retested with emulator; no issue :)

DAY 3 - I have tested with infotainment car's system > no issue :)

Well done [MENTION=9536392]Jen94[/MENTION]
[Android Auto General] steo_cha:
Me too.

Very good.

I try also with Desktop Head Unit.

Inviato dal mio STF-L09 utilizzando Tapatalk
[Android Auto General] paolocorpo:
Ciao,

can you give more details about Performance monitor for vag ?

Which feature, where download, name of package

Thanks

Paolo
[Android Auto General] cioce:
[MENTION=5056724]paolocorpo[/MENTION] please read the dedicated topic https://xdaforums.com/android-auto/...erformance-monitor-vag-cars-progress-t3741626

vag = volkswagen group cars, if you don't have a volkswagen/audi/skoda/ecc you can't use that app.
[Android Auto General] paolocorpo:
Thanks !

No, I have not (FORD ECOSPORT)

It is OK

Grazie

Paolo
[Android Auto General] steo_cha:
Performance monitor for vag cars take some data from the control car.

For ex. Speed, rpm speed of engine, outside temperature...

With this you must not have the obd2 reader.

You can download it from github.com

Inviato dal mio STF-L09 utilizzando Tapatalk
[Android Auto General] paolocorpo:
Now It is clear to me

But unfortunately I have not a vag car :)

Thanks

Paolo
[Android Auto General] scarface77:
Me too!!!

Very well done [MENTION=9536392]Jen94[/MENTION]

My units are:

SYNC 3 (Ford Ecosport 2018 Stline- Dear Paolocorpo we have the same car!!!:fingers-crossed::fingers-crossed:)

GPS 14.5.74 (the last one)

AA 3.7.584044 (not the last)

My phone is a Oneplus 6

I tried with the last version of AA but for me with this version the Jen94's procedure don't go fine…

I already connected and disconnected many and many time my phone from Syn3 but every time aamirror is always on display when I connect my phone to Sync3 without have to reboot the phone and without have to unlock aamirror ( infact I had unistalled all type of unlock apps because now they are not needed anymore!!! )

Special Thanks to [MENTION=5056724]paolocorpo[/MENTION], [MENTION=9536392]Jen94[/MENTION] and for last ,but not the last, to [MENTION=9590189]KroenenPrime[/MENTION] :good::good::good::good:
[Android Auto General] paolocorpo:
Yep ... :)

We have the same car (my model is white with the black roof)

Coming to our topic ...

... my software are:

AA 3.7.584044 (I blocked update with Titanium Backup ... honestly I don't know if it is necessary or not ... reading your coment it seems yes but for sure I have read about others user that are running AA 3.8 wo issues ... I don't know ... Confused)

GPS 14.3.66 (090408-21342215) (I blocked update with Titanium Backup ... honestly I don't know if it is necessary or not ... reading your comments it seem that I could update it in safe mode ... a little bit confused)
[Android Auto General] ammarhd:
Hello All

I tried using Jen94's method but Im stuck at the step where you enter the command : sqlite3 /data/data/com.google.android.gms/databases/phenotype.db.

It gives me sqlite3 not found. I tried using root /system/xbin/sqlite3 or /system/bin/sqlite3 as Jen94 said but still not found.

My phone is already rooted. My phone is Huawei Mate 10 lite. I installed Sqlite3 and was granted root access by magisk ( under Superuser) and it game me successfully installed when I pressed the install button. When I ran the command in Termux and it still gives me Sqlite3 not found.

The only working way that Im currently using is by installing GPS 14.3.66 and having Titanium Backup block any google updates with the latest AA 3.8 running

I am a newbie to all of this. can anybody help me out here?

Thanks
[Android Auto General] steo_cha:
You can find sqlite3 file in /data/data/com.keramidas.TitaniumBackup/files.

Obviously you must installed titanium backup

Inviato dal mio STF-L09 utilizzando Tapatalk
[Android Auto General] ammarhd:
Nope, nothing there, the directory is empty, there is no Files directory also
[Android Auto General] paolocorpo:
Ciao

Very probably it is only a stupid question but ... Just to be sure ...

Have you anticipated the:

su

comand in order to give to Termux root privileges ??

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] ammarhd:
Yes, that command worked with no issues
[Android Auto General] paolocorpo:
I see ... Honestly speaking I have not other ideas

I am sorry ... My bad :(

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] ammarhd:
I did find the file sqlite3 under the directory \Internal storage\sqlitekanolat0, is this the file ?
[Android Auto General] paolocorpo:
After the installation of Sqlite3 for root (the Apk suggested by jen94) you have to open it and tap the INSTALL button

Soon later you have to use Termux with su and recalling the DB with sqlite3 /data/data/com.google.android.gms/databases/phenotype.db

Is this what you have done ?

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] ammarhd:
What do you mean by "recalling the DB with sqlite3 /data/data/com.google.android.gms/databases/phenotype.db" ?

If you mean to type it in Termux, then yes, thats what I did and got not found msg.
[Android Auto General] paolocorpo:
Yes I was meaning that

The important thing is tap on Install button

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] ammarhd:
Yes I tapped install and i got the msg asking me to grant root access to SQLIte and I granted it and then it said installed successfully
[Android Auto General] paolocorpo:
Ok

I have not other idea ... For now ;)

Good luck

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] furious2000:
Does it work ?

When I installed Termux and SQLite3 and copy the first string nothing happend in termux ...

---------- Post added at 08:14 PM ---------- Previous post was at 08:09 PM ----------

When I wrote su in termux I didn’t see that termux get su rights ??
[Android Auto General] steo_cha:
Yes

Inviato dal mio STF-L09 utilizzando Tapatalk
[Android Auto General] paolocorpo:
When I give command

SU

I receive back that Termux has got root permission (or something like that ...)

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] furious2000:
In the Video on YouTube you see typing SU and you got the Root permission- is there an issue ? I read about termux su issues or can I use an old version?
[Android Auto General] paolocorpo:
Honestly I am using a different but equivalent App

My process is

SU

And I got popup about root permission

It is this:

https://play.google.com/store/apps/details?id=jackpal.androidterm

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] Uksus17:
Why need this hemorrhoids with Termux? Everything easy(copy/paste commands) to do via ADB.

For example:

cd c:\ADB
adb shell
su
/system/xbin/sqlite3 /data/data/com.google.android.gms/databases/phenotype.db

[IMG="screen"]http://cs5-1.4pda.to/14587254.png[/IMG]

then: flags and triggers
[Android Auto General] KroenenPrime:
I think it's possible, you just need the knowledge to.

I never coded for smartphone at the moment but could be curious when I got time to learn.

Can you make a screenshot about what you do and what's happening so we can help you easier ? ;)
[Android Auto General] ammarhd:
Tried it your way, still the same error, sqlite3 not found
[Android Auto General] Uksus17:
Then you need to physically make sure that SQL is in the folder system/bin or system/xbin.

[IMG="PIc"]http://cs5-1.4pda.to/14587025.png[/IMG]
[Android Auto General] furious2000:
This works - now I have SU rights with this app - I don’t understand... how can I paste commands ? In termux it’s works in this app i can’t tap on the screen to paste commands ? Sorry for this question :)
[Android Auto General] ammarhd:
I think my problem is that SQLite is not installed properly, because I found system/bin, but sqlite3 is not there. Even though I installed it and it said its installed as per Jen94 comment.

Is there any way to install it correctly?
[Android Auto General] paolocorpo:
Well I am happy for you ;)

Sure you can copy and paste

I did a lot of times ... :)

Retry

Inviato dal mio Mi A1 utilizzando Tapatalk

---------- Post added at 09:51 PM ---------- Previous post was at 09:24 PM ----------

[/COLOR]To Italian folks

I have translated and only lightly modified the Jen94's procedure and shared it to my friends of Mi Community and Ford community

If you are interested you can find it here:

[GUIDA] [ROOT] [ANDROID AUTO]] Usare aa_mirror sullo schermo della propria auto http://c.mi.com/thread-1710840-1-0.html

Of course I have underlined and highlighted all the credits to [MENTION=9536392]Jen94[/MENTION] and to [MENTION=257855]Slashmax[/MENTION]

Ciao

Paolo

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] qllkevuoi:
so, I Think that simply you did not install properly sqlite3: did you try to find sqlite3 with a root file manager? if the result of your research leads you to nothing, than you have the answer to your question..

it's not so rare that the sqlite3 installation fails: for example I succeeded to install it just with a magisk module. it was the third attempt. before that, I tried to install through a flashable zip and also by installing an app on Google play store.

after the successful installation, I found the sqlite3 binary file under /system/xbin folder.. and just to be sure that the terminal emulator command could find it in the "PATH", I copied it in /system/bin too (I Think it's not necessary, but certainly is not harmful either)
[Android Auto General] ammarhd:
I finally solved the issue.

I was looking at the SD-card directory instead of the device that had the system files and found the SQlite was under the titaniumbackup directory. I read at another thread that I needed to copy that file to system/bin to get it working just like Jen94 originally said. Everything worked like a charm , so thanks everyone for your time and assistance.

Now I have another question, my phone just received a new update to the Android OS. Will all of this dissappear with the new version of the OS incase I updated or will I have to do this all over again after the update, or should I not update my OS?

Thanks
[Android Auto General] qllkevuoi:
in case you don't find AAmirror in the listed apps on AA after an update (os update, or AA or GPS), Jen94 in his post says to remake the step n. 2 of his procedure.

if this doesn't help (for me it didn't, after AA updated to version 3.8), try what I did --> https://xdaforums.com/showpost.php?p=78328105&postcount=184

little bit longer than remaking just the step n. 2, but it did work for me
[Android Auto General] badabing2003:
For anyone who gets the error, sqlite3 not found, don't bother with root installer for sqlite3, just go to magisk, search for sqlite and install the version from magisk, that works fine.

Which handles the case where /system/xbin is missing.

Alternately if you don't want to deal with small screen copy paste issues on termux, you can do it over adb shell.

You can also transfer the file phenotype.db to you PC, make the edits using a graphical sqlite3 tool and transfer it back.

All roads lead to Rome.
[Android Auto General] paolocorpo:
Can you describe more deeply the procedure with adb shell and with sqlite editors for PC ?

Thanks

Paolo

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] paolocorpo:
Just a follow up ...

Please let refer to my previous post here

REPORT

DAY 0 - I applied the Jen94's procedure with success ( I have not received back any kind of message of error)

DAY 0 - Immediately later I tried to start AA on my emulator of car's head unit (let see attached picture) (it is a very simple application provided into Android Studio package created for the developers in order to test AA app when they have not a car availbale); no issue

All 3 apps of my personal white list where there (AA_mirror 1.0, AA_mirror Plus 1.0.1a and CarStream 2.0

DAY 1 - Retested with emulator; no issue

DAY 1 - I have tested with infotainment car's system > all OK

DAY 2 - Retested with emulator; no issue :)

DAY 2 - I have tested with infotainment car's system > no issue :)

DAY 3 - Retested with emulator; no issue :)

DAY 3 - I have tested with infotainment car's system > no issue :)

DAY 4 - Retested with emulator; no issue :)

DAY 4 - I have tested with infotainment car's system > no issue :)

Well done [MENTION=9536392]Jen94[/MENTION]

I am going to stop report my test here ... hoping that all will go forward well :)
[Android Auto General] badabing2003:
For adb shell, the procedure is the same, but instead of using Termux, you use adb shell from the pc

The advantage is that you're working on a big screen instead of working on the phone.

But it's still command line as described by jen94

For the graphical method, you can do it all in UI and don't have to deal with command line tools, and don't have to install sqlite3 or termux on the phone.

You need a tool like Root Explorer or similar capable File Explorer to copy the file

/data/data/com.google.android.gms/databases/phenotype.db to /sdcard/Download or to /sdcard (done on the phone)

Then you plug the phone to your pc and copy the file to your PC

Make sure you make a backup of the original, that's good practice.

Install the program "DB Browser for SQLite" on the PC and open the copied phenotype.db file

Go to Execute SQL tab and paste the first query provided the Jen94

Hit the play button to run the query, and watch the errors, if there are no errors, then you can erase the contents in Execute SQL tab and paste the Trigger query data

Of course if you get errors, you follow similar instructions from Jen94, you run the second query

Basically you are doing exactly what Jen94 described, except you're using graphical tools for ease of use.

When everything is done, you have to hit Write Changes on top

The close Database and you're done with the db

Transfer the file back to your phone, wherever you had chosen /sdcard or sdcard/Download

then on the phone, copy it back to it's original location using root explorer.

I noticed that Jen94's guide, did not have anything about closing the db and quitting the sqlite3

It might not be an issue, but you usually should not leave things open

The command you have to type is -quit (yes there is a dash) while you have the sqlite3 prompt (this is only valid for the command line)

and then to close Termux, you just type exit

Like I said, nothing new here, all the credit goes to Jen94, the above is just using different tools to execute his scripts.

Although this is working for now, I doubt that it would last long, I know trigger is very clever way of re-writing what Google was wiping out, but nothing stops them now to wipe the trigger as well.

DROP TRIGGER after_delete;

Cat an mouse game.
[Android Auto General] paolocorpo:
Thanks a lot

I will take into debit consideration your suggestion

Regarding adb shell ...

... The phone must be in fastboot mode ?

And what about Sqlite3 ?

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] furious2000:
Is the a solution for the terminal program. My problem is I can't get termux into su modus and the other terminal editors can't copy the relevant strings to execute the commands ...