[Tuto] Online Services (Audi Connect, Google Earth & Trafic Online) en WIFI

[miazza]

Hello Windstar.

I see you have reached a good point anyway.

I have a RNS850 without SIM.

I just received my TPLink MR3020 router.

 

Could you make a summary of what you have done so far and possibly attach any script you have used or modified ?

 

I am not very expert in linux but possibly I can test them on my car.

[windstar]

merci frankiegom

 

@NOY

 

Si j'ose appliquer ces scripts:

je fais d'abord le "read" qui fait une copie de ma base de donnée

ensuite le "write" qui copie une "DataPST.db" modifiée contenant la modification pour Google Earth sur mon RNS850?

 

Est ce que je peu revenir en arrière et comment si jamais il y a un soucis avec ces scripts?

Je veux bien sur éviter de briquer mon RN850. :oops:

[windstar]

I have a RNS850 without SIM.

I just received my TPLink MR3020 router.

 

Could you make a summary of what you have done so far and possibly attach any script you have used or modified ?

 

D’après ce que j'ai compris dans ton cas avec ta configuration sans SIM avec le router extérieur il suffit de suivre le tuto d'ici a la lettre et ça devrait marcher.

[frankiegom]

Miazza,

just like windstar said, in your case if the RNS850 really works just like the MMI 3GP then the scripts should just work.

But be careful when you configure the router, as there is an error in the english part, at page 34, for the DHCP server configuration, the extra default GW parameter should be 3,192.168.1.254 instead of 3,192.168.1.254 (the french version is correct).

 

Also, as to the router firmware, ROOter has gone a loooong way since last year and MW 3.10 or 3.18 is no longer the recommended version, especially for a moving vehicle as the latest version (Golden Orb, or GO) has much improved disconnection detection and reconnection procedure, modem support et many other things...

 

Find it here

 

Configuration will be much the same, but the default interface layout has been changed. You can change it to the older interface in the systems menu.

[windstar]

In the meantime I executed the "read" script on my RNS850.

The DataPST.db size is highly different from the one the "write" script should put on the RNS850

mine 45.056 Bytes the one from the script 38.912 Bytes

 

Is there a tool to compare and edit these kind of *.db files ?

[frankiegom]

ça a l'air d'être du mysql (ouvert à l'instant avec le plugin SQLite manager pour Firefox, donc j'imagine que n'importe quel outil de comparaison mysql conviendrait (voir avec ton moteur de recherche préféré)... ;)

[playaz]

ça a l'air d'être du mysql (ouvert à l'instant avec le plugin SQLite manager pour Firefox, donc j'imagine que n'importe quel outil de comparaison mysql conviendrait (voir avec ton moteur de recherche préféré)... ;)

oui oui sa en es ;)

[NOY]

merci frankiegom

 

@NOY

 

Si j'ose appliquer ces scripts:

je fais d'abord le "read" qui fait une copie de ma base de donnée

ensuite le "write" qui copie une "DataPST.db" modifiée contenant la modification pour Google Earth sur mon RNS850?

 

Est ce que je peu revenir en arrière et comment si jamais il y a un soucis avec ces scripts?

Je veux bien sur éviter de briquer mon RN850. :oops:

The script write.rar copy their DataPST.db, so you can put things back.

I'm using SQLite Expert Professional for editing DataPST.db.

[NOY]

Miazza,

just like windstar said, in your case if the RNS850 really works just like the MMI 3GP then the scripts should just work.

But be careful when you configure the router, as there is an error in the english part, at page 34, for the DHCP server configuration, the extra default GW parameter should be 3,192.168.1.254 instead of 3,192.168.1.254 (the french version is correct).

 

Also, as to the router firmware, ROOter has gone a loooong way since last year and MW 3.10 or 3.18 is no longer the recommended version, especially for a moving vehicle as the latest version (Golden Orb, or GO) has much improved disconnection detection and reconnection procedure, modem support et many other things...

 

Find it here

 

Configuration will be much the same, but the default interface layout has been changed. You can change it to the older interface in the systems menu.

I have noticed a bug about the gateway.

IP wifi router should be 192.168.2.1, respectively, and dhcp be 3,192.168.2.1

If you leave the value as a guide to 192.168.1.254 and 3,192.168.1.254 then rns not want to receive gateway - something does not work, a bug.

[windstar]

The script write.rar copy their DataPST.db, so you can put things back.

I'm using SQLite Expert Professional for editing DataPST.db.

 

Ok, compris.

Mais pourquoi la grande différence en taille?

voir: https://1drv.ms/f/s!Aokd5aBZH-tBhBY1KYGjxnHrllks

[NOY]

 

Ok, compris.

Mais pourquoi la grande différence en taille?

voir: https://1drv.ms/f/s!Aokd5aBZH-tBhBY1KYGjxnHrllks

DataPST.db saved a list of radio stations (you have more saved radio stations), language settings, adaption channels (VCDS 255 channels) and your vin.

[frankiegom]

I have noticed a bug about the gateway.

IP wifi router should be 192.168.2.1, respectively, and dhcp be 3,192.168.2.1

If you leave the value as a guide to 192.168.1.254 and 3,192.168.1.254 then rns not want to receive gateway - something does not work, a bug.

 

192.168.1.254 is the IP of the router on the WiFi interface, i.e the way to the Internet for SIMless MMI systems, and that is why it must be the default gateway on MMI 3GP systems.

 

If you need a different one on RNS850 while still using a router over WiFi interface for Internet access then there must be something very different in the RNS system to the MMI3GP.

 

If not, then can you explain how traffic directed to 192.168.2.1 gets routed to the Internet?

DataPST.db saved a list of radio stations (you have more saved radio stations), language settings, adaption channels (VCDS 255 channels) and your vin.

 

So it should be possible to extract differences and insert them in the DataPST.db you provided, right?

[NOY]

frankiegom,

IP mmi (rns) 192.168.1.1
It is logical that the gateway must be on the same subnet with mmi, ie 192.168.1.254
In my case touareg is not working, we tested it on 3 machines if reserve 3,192.168.1.254 rns the gateway does not receive from the router openwrt. But it is necessary to change the ip wifi openwrt router 192.168.1.254 to 192.168.2.1 on the team and for dhcp c 3,192.168.1.254 on 3,192.168.2.1 rns and receives this gateway, pings to sites are in rns appears internet.
Despite the fact that different subnet in rns has internet, checked on 3 machines without sim.

 

If you do not believe me, tomorrow I'll do a photo a green menu (diag v 2.01.) - Show ip settings.

Regarding DataPST.db so - a file from a working system with sim card, just does not work google street view. What is in DataPST.db responsible for Google services for Audi, maybe you know?

[frankiegom]

I believe you but still slightly confused and trying to get this right...

 

Our configuration with router IP 192.168.1.254 and router DHCP option 3,192.168.1.254 is OK for Audi MMI 3GP without SIM.

 

But on a Touareg RNS850,

you need to set router IP 192.168.2.1 and router DHCP option 3,192.168.2.1 to make it work?

or keep router IP 192.168.1.254 and change DHCP option 3,192.168.2.1?

 

Which one is it?

 

and do you still need installFairMode.sh or not?

 

thanks

[NOY]

frankiegom,

Need to set router IP wifi 192.168.2.1 and wifi router DHCP option 3,192.168.2.1 to make it work and installFairMode also.
Ip router default 172.16.1.254

Another check mark should be put in the settings wifi dhcp openwrt
Force DHCP on this network even if another server is detected.

rns 850=mmi3g+ no mmi3gp

[frankiegom]

Petit retour sur les essais que j'ai pu faire avec le FW 900 et notre modification...

Ma conclusion est que la modification est compatible avec le FW 900, il n'y a rien qui en entrave le fonctionnement.

Par contre, le passage au FW 900 alors que la modification est active remplace (je pense) un ou plusieurs des fichiers modifiés précédemment, en particulier le fichier de configuration du firewall.

Pour ceux qui ont déjà appliqué cette modification, je conseille de la désinstaller avant passage en FW 900 et de la réinstaller ensuite. Pour les autres, il faudra construire un script qui recopie les fichiers écrasés par la mise à jour (/etc/dhcp/pf.conf, et peut être /etc/dhcp/nws.cfg).

Donc c'est une bonne nouvelle! [;)]

Par contre il m'est arrivé quelque chose de curieux... Juste avant de passer au FW 900, en me balladant sur le site Audi, dans mon compte My Audi, pour la première fois j'ai trouvé l'option pour générer le code d'activation de MyAudi sur ma voiture. Dans la foulée, j'ai activé avec succès, et réussi à transferer des destinations créées sur google maps.

Mais depuis que je suis passé en FW 900, le menu My Audi dans les destinations en ligne n'est plus accessible dès qu'on installe le Fair Mode! J'ai réussi à le réactiver (installFairMode.sh copie un fichier qui désactive l'option, il suffisait donc de l'effacer) mais bien que l'activation avec le code fourni soit possible, le serveur ne répond pas!

Si quelqu'un a des idées sur ce qui pourrait provoquer ce problème, je suis intéressé...

[frankiegom]

frankiegom,

Need to set router IP wifi 192.168.2.1 and wifi router DHCP option 3,192.168.2.1 to make it work and installFairMode also.

Ip router default 172.16.1.254

All clear now, thanks!

So, for Miazza, you need to take this into account and change the router WiFi configuration accordingly.

 

It would be interesting to find out whether that works on the MMI 3GP as well (192.168.2.0/24 is used in the 3GP as well)... Maybe if I have some spare time in the summer I can give it a try...

 

Another check mark should be put in the settings wifi dhcp openwrt

Force DHCP on this network even if another server is detected.

It seems to depend on the router used. When hsd92 made the scripts and the documentation, he did not need this on his router, but on mine I had to check the box.

I guess the doc will need to be upgraded at some point.

 

rns 850=mmi3g+ no mmi3gp

No, 3GP is 3GPlus aka 3G+. ;)

[frankiegom]

If you do not believe me, tomorrow I'll do a photo a green menu (diag v 2.01.) - Show ip settings.

 

Despite the fact that different subnet in rns has internet, checked on 3 machines without sim.

 

As I said, I believe you because I have no experience of the RNS850 in VW cars, but I am interested by the green menu screenshots. It can help understand the difference with Audi systems, and maybe even find new tricks... :)

 

What is in DataPST.db responsible for Google services for Audi, maybe you know?

 

Missed that question earlier...

 

In the Audi, there is not need to play with VCDS (or database) to enable Google Earth, everything can be done in the Green Menu.

The database script is only there to enable Green Menu and Traffic Online without VCDS.

 

[Thierry-13]

True but online traffic has been disabled server-side at Audi's HQ for MMI 3G+ not having built-in SIM ....

[frankiegom]

Yes, sadly.

[windstar]

Par curiosité j'ai installé SQLite Expert Professional

Ensuite j'ai comparé les DataPST de NOY et la mienne au niveau des tb_intvalues.

Beaucoup des valeurs sont differentes.

 

J'ai bien trouvé "pst_key 4117" qui chez moi avait "pst_value 0" et dans le script de NOY etait a "1"

J'ai donc modifié cette valeur dans ma DataPST.db de "0" a "1" et mit cette DataPST dans le script "write"

 

 

Ensuite le script "write" sur mon RNS850 et malheureusement apres reboot toujours pas de "Google Earth" bouton toujours gris.

 

La seule différence est que maintenant au démarrage il me dit que ma licence trafic en ligne est périmée.

 

Il semble donc que 4117 ne soit pas la seule valeur a modifier.

 

Toutes suggestions sont les bienvenues.

[miazza]

Miazza,

just like windstar said, in your case if the RNS850 really works just like the MMI 3GP then the scripts should just work.

But be careful when you configure the router, as there is an error in the english part, at page 34, for the DHCP server configuration, the extra default GW parameter should be 3,192.168.1.254 instead of 3,192.168.1.254 (the french version is correct).

 

Also, as to the router firmware, ROOter has gone a loooong way since last year and MW 3.10 or 3.18 is no longer the recommended version, especially for a moving vehicle as the latest version (Golden Orb, or GO) has much improved disconnection detection and reconnection procedure, modem support et many other things...

 

Find it here

 

Configuration will be much the same, but the default interface layout has been changed. You can change it to the older interface in the systems menu.

Hi all.

Sorry for not being present in the discussion.

I am abroad and for the time baing I can only study ... no access to my Touareg :(.

I have checked the link for Router OpenWRT FW but it is not clear which is the latest: For 3020 it seems V1: ofmodemsandmen.com/download/GoldenOrb/mr3020-v1-GO2016-04-01.zip. Correct ?

 

I will correct the pdf by hands in order to include all the suggestion in the latest posts.

 

Thanks.

[NOY]

windstar,
you should try to use my DataPST.db and see whether the active google earth, so we have chores. You can always return back to your DataPST.db via write the script.

We must push install fair mode in the green menu.

And what firmware version you have and maps ?

[frankiegom]

I have checked the link for Router OpenWRT FW but it is not clear which is the latest: For 3020 it seems V1: ofmodemsandmen.com/download/GoldenOrb/mr3020-v1-GO2016-04-01.zip. Correct ?

 

You have to check the label on the router. It will tell you what HW version it is. Then you can pick the corresponding firmware.

[windstar]

@NOY: as written before K0821 and 6.22.3

 

I uninstalled fair mode before applying the modifications of the DataPST.db

 

I will try first reinstalling fair mode in the green menu and if doesnt help I will try the DataPST.db from You.

[windstar]

Pas de chance :nixweiss:

 

D'abord j'ai reinstalle "fair mode" dans le green menu -> bouton Google Earth toujours gris

 

Ensuite j'ai installé la DataPST.db de NOY:

1. Langage du système maintenant Anglais et ne peut être changé

2. Toutes les stations radio sont effacées

3. Google Earth peut choisi maintenant mais apres quelques secondes de chargement: "No available Data for Google Earth"

 

[NOY]

Yes, sadly.

Regarding tmc online, I'm not saying that this is not possible, I have it worked until 30.05.2016 and i used audi values, and was blocked audi server.

For tmc online requires a value

32783 in adaption channel 69 (vcds) or the value of 32783 to 40960 tb_intvalues file ​​DataPST.db

And the correct values ​​in tb_stringvalues ​​DataPST.db file

 

pst_is pst_namespace pst_key pst_value

6 676990753 72057594037862401 11111111111111111111111111111111 * Audi * DE

7 676990753 72057594037862402 11111111111111111111111111111111

 

72057594037862401 72057594037862402 values ​​and need to be taken from those who DataPST.db tmc online works.

72057594037862401 is coded vin

72057594037862402?

 

See my DataPST.db in write.rar

I used the values ​​and 72057594037862401 and 72057594037862402 audi of up to 3 years and I have worked tmc online 1 month.

[NOY]

Pas de chance :nixweiss:

 

D'abord j'ai reinstalle "fair mode" dans le green menu -> bouton Google Earth toujours gris

 

Ensuite j'ai installé la DataPST.db de NOY:

1. Langage du système maintenant Anglais et ne peut être changé

2. Toutes les stations radio sont effacées

3. Google Earth peut choisi maintenant mais apres quelques secondes de chargement: "No available Data for Google Earth"

 

new-DataPST-engl.png

Try install fair mode again and restart rns

Yes, language is English and you will see my list of radio stations.

Other settings green menu should be in the MMI-3GP-odiconnect-v1.0.pdf

 

Next, you should try to press the green menu

googleearth install gemmi persistent, then restart rns.

 

Do the following photo of green menu and show me.

googleearth Get info gemmi

diagnose/coding/internal_modules_1+2

diagnose/settings/tel_settings

[NOY]

Hi all.

Sorry for not being present in the discussion.

I am abroad and for the time baing I can only study ... no access to my Touareg :(.

I have checked the link for Router OpenWRT FW but it is not clear which is the latest: For 3020 it seems V1: ofmodemsandmen.com/download/GoldenOrb/mr3020-v1-GO2016-04-01.zip. Correct ?

 

I will correct the pdf by hands in order to include all the suggestion in the latest posts.

 

Thanks.

If you have router mr 3020 use this firmware openwrt - Peppy Snowdrop 2.3.2

http://acs-house.ru/files/firmware-mr3020-bp2-3-ps2-3-4gmodem/

or you can use GoldenOrb from ofmodemsandmen.com from 01.04.2016

[windstar]

Try install fair mode again and restart rns

Yes, language is English and you will see my list of radio stations.

Other settings green menu should be in the MMI-3GP-odiconnect-v1.0.pdf

 

Next, you should try to press the green menu

googleearth install gemmi persistent, then restart rns.

 

Do the following photo of green menu and show me.

googleearth Get info gemmi

diagnose/coding/internal_modules_1+2

diagnose/settings/tel_settings

 

Still no luck.

 

I have your DataPST.db installed and did exactly what You told me.

 

Here in the folder are the requested pictures.

 

https://1drv.ms/a/s!Aokd5aBZH-tBhCA15MRMXoRxjuJf

[NOY]

 

Still no luck.

 

I have your DataPST.db installed and did exactly what You told me.

 

Here in the folder are the requested pictures.

 

https://1drv.ms/a/s!Aokd5aBZH-tBhCA15MRMXoRxjuJf

 

I looked at your photos, everything is right gemmi component is installed, the settings green menu right.

Does have rns Internet, whether pings go to sites (diag v.2.01 - allows you to ping websites)

config Show IP Settings show these photos

 

If the Internet is in the exact rns to try again write.rar my script, and then press the button google earth.

[windstar]

 

Does have rns Internet, whether pings go to sites (diag v.2.01 - allows you to ping websites)

config Show IP Settings show these photos

 

If the Internet is in the exact rns to try again write.rar my script, and then press the button google earth.

 

What Do You mean with diag 2.01 is it a script to check internet connectivity of the RNS?

Or how should I check it exactly?

[NOY]

 

What Do You mean with diag 2.01 is it a script to check internet connectivity of the RNS?

Or how should I check it exactly?

In order to understand whether there is in rns 850 internet, I use a script (diag 2.01), it is in the cap threads. The script allows you to ping the sites of green menu rns.

config Show IP Settings

[windstar]

sorry what are the cap threads? can You guide me in the right direction to find it?

 

In the meantime some other pictures You asked for:

 

https://1drv.ms/a/s!Aokd5aBZH-tBhCwsukNTcYPO1HlN

[NOY]

sorry what are the cap threads? can You guide me in the right direction to find it?

 

In the meantime some other pictures You asked for:

 

https://1drv.ms/a/s!Aokd5aBZH-tBhCwsukNTcYPO1HlN

The first message of this topic, script is called

MMI-3GP-Diag-v2.01.zip

 

After seeing your photos, I can not figure out whether there is Internet via gsm.

[frankiegom]

Picture 8: no default gateway

[miazza]

Finally I could not resist and asked my brother to run the script:

 

20160620_075048 - step 1 start at 20160620_075048
20160620_075052 - step 2 Display picture start
20160620_075052 - step 3 Success mmelauncher.cfg backuped on mmi
20160620_075052 - step 4 Success mmelauncher.cfg backuped on SDCARD
20160620_075052 - step 5 Success mmelauncher.cfg deleted
20160620_075052 - step 6 Success new mmelauncher.cfg copied from SDCARD to mmi
20160620_075053 - step 7 Success mme-becker.sh copied from SDCARD to mmi
20160620_075053 - step 8 Success mode changed mme-becker.sh to make it executable
20160620_075053 - step 9 Success resolv.conf copied from SDCARD to mmi
20160620_075053 - step 11 Success nws.cfg backuped on MMI
20160620_075053 - step 12 Success nws.cfg backuped on SDCARD
20160620_075053 - step 13 Success nws.cfg deleted
20160620_075053 - step 14 Success new nws.cfg copied from SDCARD to mmi
20160620_075053 - step 15 Success pf.conf backuped on MMI
20160620_075053 - step 16 Success pf.conf backuped on SDCARD
20160620_075053 - step 17 Success pf.conf deleted
20160620_075053 - step 18 Success new pf.conf copied from SDCARD to mmi
20160620_075056 - step 19 Success new sqlite.xml copied from SDCARD to mmi
20160620_075056 - step 20 Success Launch installFairMode.sh script
20160620_075107 - step 21 Success Display picture Done
20160620_075107 - step 22 Success Installation terminated

In the sqlite.xml I have seen the followings:

1) KEY:45056 value 1 --> What is this for ? What was default value ?

2) KEY 40960 value 32783 --> What is this for ? What was default value ?

3) KEY 4100 value 1 --> This I understood is for green manu activation and it worked well (after FW update green menu was gone)

 

For Activation Traffic Online do I have also to:

VCDS
5F Infotainment
Adaptation
Chanel 69
existing value plus 32768
?

[frankiegom]

Not sure what the first key is for, but the second one is for Traffic Online activation (15 + 32768), replaces the VCDS step.

 

You should now configure the router and then run the diagnostic script. It should tell you if the Internet connection works...

[frankiegom]

It would be interesting to find out whether that works on the MMI 3GP as well (192.168.2.0/24 is used in the 3GP as well)... Maybe if I have some spare time in the summer I can give it a try...

Had a quick test this morning (moving the router WiFi network from 192.168.1.254 to 192.168.2.1) and no joy at first.

Will check some more this evening if time allows before reverting to original configuration, but this seems to be another difference between Audi MMI 3GP and VW RNS850...

[frankiegom]

Regarding tmc online, I'm not saying that this is not possible, I have it worked until 30.05.2016 and i used audi values, and was blocked audi server.

For tmc online requires a value

32783 in adaption channel 69 (vcds) or the value of 32783 to 40960 tb_intvalues file ​​DataPST.db

And the correct values ​​in tb_stringvalues ​​DataPST.db file

 

pst_is pst_namespace pst_key pst_value

6 676990753 72057594037862401 11111111111111111111111111111111 * Audi * DE

7 676990753 72057594037862402 11111111111111111111111111111111

 

72057594037862401 72057594037862402 values ​​and need to be taken from those who DataPST.db tmc online works.

72057594037862401 is coded vin

72057594037862402?

 

See my DataPST.db in write.rar

I used the values ​​and 72057594037862401 and 72057594037862402 audi of up to 3 years and I have worked tmc online 1 month.

 

I had it working until July last year (car is from january 2012), so it was working, but there are reports of people with much more recent cars where Traffic Online is blocked at the server based on VIN.