yashsingh1/xdaforums huggingface dataset:
[Android Auto General] Jen94:
badabing2003

1. Not needed to close database - the instructions say to reboot device, terminal closes automatically

2. Really, simply drop trigger? Try it.

A small remark: to drop a trigger, you need to know its name. There are only a limited number of ways to do this.

This is a query: SELECT name FROM sqlite_master WHERE type = "trigger";

Does it matter what it is called in the sqlite_master system database? No, everything except the sql there is informational.

And sql is executed when the database is connected, just creating the triggers. But no one will parse the sql query.

So, we change the type of trigger to, for example, trygger - and that's all, it will not able to find it. How do you now define the name that you want to drop?

Of course, sqlite_master is read-only ...

But the HEX editor fixes this misunderstanding without any problems. - NOT ACTUAL

updated:

It turned out that need to know better sqlite)

To edit sqlite_master with familiar tools, just run

PRAGMA writable_schema = ON;

UPDATE sqlite_master SET type="trygger", name="aftor_delete" WHERE name="after_delete";

Then reboot device! And then

SELECT name FROM sqlite_master WHERE type="trigger";

Returns empty, but

SELECT name FROM sqlite_master WHERE type="trygger";

... is a small secret :)

Also you can modify trigger name in this table, and even if someone found it, it cannot drop.
[Android Auto General] mains75:
Thanks, I had the same problem, i fixed with your method.

After, when I insert the flags using adb method, I had some flag error or something. Anyway, I tried today and mirroring works perfect! :good:
[Android Auto General] badabing2003:
Thanks [MENTION=9536392]Jen94[/MENTION] for the tricks, but I still believe that it is a cat and mouse game, don't get me wrong, I wish they leave this alone, but knowing Google, they probably won't.

Yes, we can rename the trigger to trygger, but we can't really hide it from a determined programmer, just like they can't from you and the community.

See this query for example, it will expose trygger.

SELECT * FROM sqlite_master WHERE type NOT IN('table','index');

For #1 above, agreed, reboot would be sufficient, I missed that.

On another note, why did you suggest to remove Unknown Sources and set it to release mode?

Is it to be as close to stock / vanila (name it whatever) as possible and avoid past changes that could get in the way?

In my case, It wouldn't work unless I set to Developer Mode and checked Unknown Sources.

Thanks for your insights and contributions.

Cheers.

BB
[Android Auto General] Jen94:
OK, there is an entry for this query:

type = trygger

name = aftor_delete

sql = create trigger after_delete begin ...

Thus, the correct name for the drop can be obtained only by parsing the sql query.

While I doubt that someone will do so.

Sql may be...

CREATE TRIGGER """oh lala AFTER DELETE ON demo "" BEGIN SELECT * FROM demo; END;""" AFTER DELETE
ON demo
BEGIN
SELECT * FROM demo;
END;

About unknown sources I don't know now.
[Android Auto General] qllkevuoi:
one user came in this discussion and in this other thread, just to say that the unlockers worked with last version of GPS and AA if the user selected those option in the developer menu.

but in my many attempts I realized that, after having enabled the developer menu in AA, is better if I simply don't make any choice between the app modes; and just to be honest.. if I set release mode, AA begins to switch automatically through all tabs (something like a .. preview/slideshow)... not so useful in my opinion.

in the end, talking about the choice if "to check or not to check (..this is the question :laugh:)" unknown sources .. I really don't know. I understand that it makes more sense if you check this option, but I think it makes no difference: in my case I left unchecked

.. and with this combination (I mean this "unchecked/not-choosen setting") simply all does work in the right way. It's all I need; It's all I need to know.
[Android Auto General] KroenenPrime:
I have some troubles from 2-3 days now and I'm working "too much" to find a fix atm.

I can see on the car AA Mirror, AA Mirror Plus & CarStream.

CarStream is working great despite I can't read my videos.

When I select AA Mirror or AA Mirror Plus, most of the time it goes on blackscreen and nothing else then back to Android Auto.

Sometimes it makes my phone bug and I'm forced to reboot or hard reboot because it just froze.

And when it works, most of time I can't use my touchscreen and I'm forced to use my phone to navigate.

I have no idea why it's working sometime and sometimes not. I try to reboot my phone but can't see something changing after the reboot.

I just found that it works more often when I choose on the car AA Mirror and the phone is lock than if I have unlock before choose the app.

I figured out another problem I got about the display which was changing alone when using the AA Mirror's app. Since I changed the immersive option, I don't have anymore this display bug.

Do you have any ideas ? And btw still trying to find someone which can help me with MBUX system. ;)
[Android Auto General] qllkevuoi:
I fell in a similar situation. solved by uninstalling aa mirror plus, giving aa mirror all permissions/authorizations (in app settings of my phone) and launching AA mirror on phone before starting it from the head unit.

all came back to work properly

this was necessary only once. now I can simply launch aa mirror on car head unit

for the other issue.. what do you mean with "the display was changing alone"? if you mean that AA switches between its tabs (phone, navigation, etc), then you have set 'release mode' in the developer menu.. am I right?

if so, simply change the app mode of AA to another one
[Android Auto General] KroenenPrime:
Thank you for the tip, I will give a try tomorrow.

The size of the whole display, screenshot : here

Meaning the font, app icons and everything, like switching from 1080p to 4K.

But like I said, since I unchecked the immersive mode, it looks like I fixed it.
[Android Auto General] qllkevuoi:
I Think "full immersive" concerns to top/notification bar, While the option that changes your resolution and dpi is “adjust ratio on focus": I often have the same problem.. it seems that the "restore ratio on focus lost" doesn't change back the screen to its default aspect.

to solve it, just reboot the phone, or open a terminal emulator and type (at the end of each line, press enter on your phone keyboard):

su
wm size reset && wm density reset

if you have the app android terminal emulator (developer jack palevich .. you find for free on play store), you can add a widget on your homescreen that launch terminal emulator with a pre-assigned command: the widget name of Android terminal emulator is "term shortcut": just add one widget on your homescreen and, in the window that opens and you must configure, add this command to "arguments" line:

su -c "wm size reset && wm density reset" && exit

just tap on the icon when you need to restore default aspect of your display: it will ask you to grant root privileges.. you will see on your top/notification bar that a session of terminal emulator started... to work properly, all you have to do is to tap on the notification to switch to this terminal session .. then, in a pair of seconds, the command will reset your display to your default aspect then you can just close terminal emulator.

it's more comfortable than rebooting or typing the command by yourself... I'm trying to find a way to close automatically terminal emulator without the need to interact with the app (the last command "exit" should have this intent but doesn't close the app automatically)... but for now, no success. in alternative, I plan to make a little apk to execute this simple command, but I'm not a programmer, I'm really a complete noob and don't know nothing of java stuff.. but I'm sure this target is not so hard to reach

regards
[Android Auto General] tomdot:
I'm getting this error (Android 9 Pie, AAmirror only)

"flags.version may not be NULL"
[Android Auto General] xls654:
find

SELECT version FROM Packages WHERE packageName="com.google.android.gms.car#car"

and replace with

SELECT max(version) FROM Packages WHERE packageName like "com.google.android.gms.car%"
[Android Auto General] Tiemichael:
Very likely the package version of your "com.google.android.gms.car" is 236 or 240, instead of 234 ...

So you have to use the alternatives given in Jen94-post https://xdaforums.com/showpost.php?p=78289872&postcount=110
[Android Auto General] tomdot:
Worked great! Thank you
[Android Auto General] Tiemichael:
I tried but no success ...

AAMirror (as well as UnLeashedAudioPlayer) don't show up

sqlite> SELECT * FROM Flags WHERE name="app_white_list";
com.google.android.gms.car#car|234|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car|230|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car|234|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car|230|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car_setup|234|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car_setup|230|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car|240|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car|240|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car_setup|240|0|0||app_white_list||||com.github.slashmax.aamirror, org.openauto.unleashedaudioplayer||1
sqlite> DELETE FROM Flags WHERE name="app_white_list";
Error: Flags.version may not be NULL

Any idea what I might do wrong?
[Android Auto General] Jen94:
Read the docs - that's a solution

Where is space in the docs? No space.
[Android Auto General] Tiemichael:
I tried to follow your 'alternative' instructions, but AAmirror is still not showing in the car.

sqlite>SELECT * FROM Flags WHERE name="app_white_list";
com.google.android.gms.car#car|234|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car|230|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car|234|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car|230|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car_setup|234|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car_setup|230|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car|240|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car|240|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
com.google.android.gms.car#car_setup|240|0|0||app_white_list||||com.github.slashmax.aamirror,org.openauto.unleashedaudioplayer||1
sqlite> DELETE FROM Flags WHERE name="app_white_list";
Error: Flags.version may not be NULL

Besides the 'Error: Flags.version may not be NULL" (see last line above) everything seems fine

(even if I remove org.openauto.unleashedaudioplayer, it does not work)

Thanks for your help!
[Android Auto General] Jen94:
1. DROP TRIGGER after_delete;

2. DELETE FROM Flags WHERE name="app_white_list";

3. Show me code FOR FLAGS and code FOR TRIGGERS that you use
[Android Auto General] KroenenPrime:
Hello,

Thanks for the info and I can confirm that even with the full immersive disabled I still can have the display bug. But didn't try your tip at the moment.

But I still have the bug about launching AA Mirror and nothing happens and I think I just figured out why. Since I go delete all datas from Android Auto app, it works first time without any problems.

I still need to do some tests and check what happens if I just delete the cache folder of the app.

I will probably try to learn some basics during 2019 about coding apps for android so I can understand better and find maybe some solutions for those problems.
[Android Auto General] qllkevuoi:
try the solution I wrote for the display bug

for AA Mirror problem, I think you have to wipe data and cache of AA, AA Mirror and Google play services, then retry all procedure from the beginning (AA developer menu, AA Mirror settings, Jen94 procedure). Just be sure to grant root permissions for AA mirror and allow all permission of that app.

then, try to connect again to your car.
[Android Auto General] Jen94:
Have you other triggers?

SELECT name FROM sqlite_master WHERE type="trigger";
[Android Auto General] Tiemichael:
sqlite> SELECT name FROM sqlite_master WHERE type="trigger";
anti_delete
after_delete

Thank you for your help!
[Android Auto General] furious2000:
What is to do to get tern in su mode - when I type su in termux, there comes no dialog from su ?

You can see in su logs that termux tried to get su rights but it is red # not green - I tried other terminal programs but is it not so easy to use copy paste ...
[Android Auto General] Tiemichael:
I am using adb, everything on a big screen with keyboard and mouse ...
[Android Auto General] KroenenPrime:
Rooted & does termux got root access ?
[Android Auto General] ruffruff:
is there a new version of aamirror? i installed aaunlock and aamirror from the github but the aamirror sometimes work and sometime i can't get access it at all...
[Android Auto General] furious2000:
Rooted and termux doesn’t get root access - u can see in SuperSU logs that termux try to get root access but it doesn’t work (in logs shown with red #) - delete and installed new - but nothing work
[Android Auto General] qllkevuoi:
when it doesn't work, try to launch AA mirror on your phone before launching on your car.. then, when it's running on your phone (display turned on), launch it on your infotainment system from AA menu

if instead AAmirror doesn't show up in AA, try to unlock permanently with the Jen94 procedure described in this discussion at post 110: https://xdaforums.com/android-auto/...p-android-auto-3rd-party-app-enabler-t3853009

you can do it trough AA phenotype patcher app developed by eselter: try versions 0.4 or 0.5 of that app. you'll find the apk at posts #294 and #317 of that thread.
[Android Auto General] ruffruff:
Thanks for the advice. I will try the AA Phenotype patcher app tonight. :)
[Android Auto General] qllkevuoi:
instead of doing all Jen94 procedure through command line in termux, try the new "AA phenotype patcher" app developed by eselter: this apk will do all procedure for you.

please read my post here

hope this helps you
[Android Auto General] KroenenPrime:
Hey,

Just tried and got some new infos.

So I wiped all datas from AA, AA Mirror & GPS + deleted the triggers and started from 0.

I got surprised that I couldn't use same code, got the error with flag.version so I switched and did all the procedure.

So first try was good but it froze my phone, I had to hard reboot it.

Then after trying to launch AA Mirror, it was just doing nothing except blackscreen then coming back to "android auto homescreen" (on the car).

So I tried like 3 times in a row and nothing.

I unplug

2seconds after, I can see "AA Mirror got root access" x3 times

My display screen got downsized 2 times (or maybe 3) so it was almost impossible to read

I plug back to try again AA Mirror on car : working now

It looks like something preventing AA Mirror to get the root access granted so it won't start.

So :

I rebooted my phone, plug-in to try : still not working.

Unplug, wipe Android Auto data, plug-in = working.

Unplug = my screen is downsized by the bug; waiting a bit; plug-in = working but I can't control my screen by the car this time.

I fixed the bug by the command you gave me but didn't take the time to retry. I think if I reboot my phone, I always need to wipe Android Auto's data to make it work.

So the big question is why. :rolleyes:
[Android Auto General] calichelozano:
hey, can you please tell me how to delete the triggers? it seems I screwed up and AA mirror won't show up. Thanks.
[Android Auto General] qllkevuoi:
ok. it seems something similar to what happened to me a pair of days ago (without doing nothing new.. :rolleyes:): I solved the issue of black screen of AAmirror in this way: firstly I connect the phone to the car; when I want to launch AA mirror, before launching AA on car infotainment head unit, I launch AA mirror on my phone and keep the display turned on; then I launch AA in car head unit; last step .. I launch AA mirror in the car head unit. obviously AA mirror had granted yet root permission and I allowed all other permissions requested by this app (you can do it also through apps settings in your phone)

however.. if this doesn't work for you, wipe data and cache of all AA related apps just as you did before.. then drop all previous triggers created; then grant root permission for AA mirror and allow all other permissions of that app; then, to create properly the right trigger, try AA phenotype patcher app developed by [MENTION=3165644]Eselter[/MENTION] .. (I didn't try it just because I did the Jen94 procedure before eselter created his apk.. but surely doing all that stuff trough an app is really more comfortable).

then, after all these steps, reboot your phone and retry. I hope this helps you;)

---------- Post added at 09:25 AM ---------- Previous post was at 09:09 AM ----------

enter a terminal command app and give these commands:

su
sqlite3 /data/data/com.google.android.gms/databases/phenotype.db
DROP TRIGGER after_delete;

then exit terminal app and reboot the phone

I Think [MENTION=3165644]Eselter[/MENTION] had inserted the option to delete triggers in his app.. if so (I don't know), you can try to do it through his app (you can find by following the link I posted in my last posts in this thread)
[Android Auto General] Eselter:
Yep before insert new trigger and rows to DB my app delete everything (whitelist and trigger).
[Android Auto General] manutoxic:
I don't understand things now...

We have the tool 3rd party enabler, which I installed. I unlocked carstream and AA mirror

Now I saw that others use aa mirror plus ? Which one is working ? And what do we need that as phenotype APK for patching?

And do we need to uncheck unknown resources and set version release on Android auto ?
[Android Auto General] paolocorpo:
AA mirror is enough !

No reason at now to use aa mirror plus

And yes ... The new 0.5 enabler released by [MENTION=3165644]Eselter[/MENTION] is perfect to your target ;)

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] calichelozano:
Hi, I tried this and got this in return:

"enter sql statements terminated with a ";"

sqlite> error: no such trigger: after_delete

thanks.
[Android Auto General] qllkevuoi:
so, it seems that you deleted yet that trigger.

If you created just this, with that name (after_delete), then you reached your target
[Android Auto General] memo951:
Hi, I'm using a Samsung Galaxy Note 9, is wireless Android Auto available on the new Ford Focus 2019 with 8" SYNC 3?

This guy on YouTube says it's possible to use it wireless, do you really think it works without using the cable?

https://bit.ly/2EoF5mj
[Android Auto General] Sjhingan:
could someone please post a step by step procedure for using the Jen94 procedure to unlock AA? Thx
[Android Auto General] qllkevuoi:
hi, you can simply use the app developed by [MENTION=3165644]Eselter[/MENTION] "aa phenotype patcher".

you can find the link here:

https://xdaforums.com/showpost.php?p=78402151&postcount=317
[Android Auto General] Sjhingan:
Any specific instructions i have to follow? is it self explanatory? thx!
[Android Auto General] paolocorpo:
Yes, it is
[Android Auto General] manutoxic:
Is there any possibility to start aa.mirror and lock the screen only of the smartphone and use it on my car because it needs more battery than he becomes from my car

Ita

C'è una possibilit
[Android Auto General] paolocorpo:
I am sorry but I have not understood ;)

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] manutoxic:
C'è una possibilit
[Android Auto General] scarface77:
Hi my friend, i'was going to read about AA Phenotype Patcher 0.5... Is it a new unlocker? and if it is, is it very stable when i connect and disconnet my phone like Jen94's procedure? Can you explane me about? Thank you in advance.
[Android Auto General] manutoxic:
It's stable.

It's working every time also if I do not start aa mirror before.
[Android Auto General] paolocorpo:
Dear,

If I have understood well you have already applied the Jen94's procedure

If I am not wrong ... You don't need use the AA Phenotype patcher because it uses the same procedure

Inviato dal mio Mi A1 utilizzando Tapatalk
[Android Auto General] scarface77:
Thank you so much for your answer

So if I understood well this patcher automatically do the same work of jen94's procedure…

I mean...I want understood if this patcher go to write automatically on Termux and so with this patcher I have to install on my phone also Termux and Sqlite, or I have only to install this patcher without install Termux and Sqlite…
[Android Auto General] paolocorpo:
You have not to install TERMUX and SQLITE but ... of course ... you have to install aa_mirror, Carstream, etc
[Android Auto General] mabadse:
Android Auto Phenotype Patcher

https://www.youtube.com/watch?v=I_0Ke8fnamU

Enviado desde mi POCOPHONE F1 mediante Tapatalk
[Android Auto General] paolocorpo:
Well done :)
[Android Auto General] KroenenPrime:
2 days test :

Day 1 : Plug-in - working fine but can't use my car touchscreen, forced to control from the phone, after use, unplug : no downsize problem.

Day 2 - Test 1 : Plug-in and everything going great, unplug : still no problem.

Day 2 - Test 2 : same as above, still doing great.

I'm sure that if I reboot my phone, it won't work again until I wipe AA datas.

But I'm wondering why between Day 1 and Day 2, the touchscreen is not working and then it is. Looks like AA Mirror isn't that stable. :rolleyes:

Anyways, looks good now, next step is getting into the car system.
[Android Auto General] eteles:
Hello you guys... I'm pretty noob on android auto... I have a rooted xiaomi mix 2s (latest MIUI Dev) and MirrorLink is not supported...

How can I get the mirror feature to work? I already tried it by myself... Installed latest Android auto, aa mirror and aa unlock... But even after unlocking aa mirror won't show on AA apps menu... I see only "Return to Volkswagen" option.
[Android Auto General] KroenenPrime:
Hello,

The AA Unlock you downloaded is not stable/working.

Try this one but "lock" again through the AA Unlock to restore defaults settings then : https://xdaforums.com/showpost.php?p=78402151&postcount=317
[Android Auto General] eteles:
Tried with Android Auto Third Party app enabler (it seems It uses the same unlock procedure as the app you recommended) and still no aa_mirror app listed... [MENTION=9590189]KroenenPrime[/MENTION]
[Android Auto General] KroenenPrime:
You muse use AA_Phenotype_Patcher_0.5.apk or Jen94's procedure that I made a video of, others are outdated/unstable to work. ;)
[Android Auto General] eteles:
Thanks man! It worked after I used aa_phenotype_patcher 0.5!! Really awesome! I just wished I could turn phone's screen off haha... But that really great!
[Android Auto General] KroenenPrime:
Great ! :good:

If you want to play some videos or youtube and have your screen off, you should use CarStream apk.

I am using AA Mirror and then VLC to watch videos and with VLC I just shut brightness to 1% so my phone still charging through the USB. ;)
[Android Auto General] eteles:
I will test that... Thanks again!