Author Topic: Database problem (Read 8027 times)

NickJackson · « **on:** October 07, 2009, 06:54:33 AM »

I've posted some questions on my 'Newbie' thread but I think I need one just for the database problem, which is my biggest problem at the moment.

I've run RB for 2 full days and now have 131 missing database entries, all but 2 of which are in GAS database. Most of the missing entries are UK/European airliners that were delivered during 2008 and 2009. A fair chunk of these are Easyjet's and Ryanair's that make up a lot of flights I see and track. My conclusion is that my database needs a refresh from the GAS one.

I've tried MyLog -> Tools -> Populate but that isn't fixing the problem. At the moment I'm manually filling in the blanks and I'd rather not add these manually into my AirNav database. At this rate, as I know there are still gaps in the Easyjet/Ryanair fleet, I'll probably have 300 or so entries to add taking into account all 2008/2009 deliveries.

Any help would be appreciated.

Nick

tarbat · « **Reply #1 on:** October 07, 2009, 07:21:11 AM »

Can you provide some of the ModeS codes to check if they're on the Airnav server database.

http://www.airnavsystems.com/cgi-bin/ANLV_SV/ANLV_SV_user.exe?usgetphoto=0&usverify_name=PGANRB000000&usversion=ANRB306&regsearch=&modes=nnnnnn

where nnnnnn is the ModeS hex code.

eg:
http://www.airnavsystems.com/cgi-bin/ANLV_SV/ANLV_SV_user.exe?usgetphoto=0&usverify_name=PGANRB000000&usversion=ANRB306&regsearch=&modes=40109F

NickJackson · « **Reply #2 on:** October 07, 2009, 07:49:29 AM »

Here's a few examples:-

4CA643   EI-DYA
405B65   G-EZDL
3965A5   F-GZNF
405A48   G-EUUZ
4B187A   HB-JHA
C0173F   C-FIUW

Can I check these myself or do you need to do it?

Thanks
Nick

Fenris · « **Reply #3 on:** October 07, 2009, 08:17:42 AM »

Quote from: NickJackson on October 07, 2009, 07:49:29 AM

Here's a few examples:-

4CA643   EI-DYA
405B65   G-EZDL
3965A5   F-GZNF
405A48   G-EUUZ
4B187A   HB-JHA
C0173F   C-FIUW

Can I check these myself or do you need to do it?

You can do it yourself, but I've just tried these 6 you provided and all of them return apparently correct information in my web browser.

Not sure what's happening with RB, if they are really missing then they should appear if you do an repopulate from the MyLog window but as you say above it didn't work this time.

tarbat · « **Reply #4 on:** October 07, 2009, 08:18:30 AM »

DaveReid · « **Reply #5 on:** October 07, 2009, 08:28:03 AM »

Quote from: tarbat on October 07, 2009, 07:21:11 AM

Can you provide some of the ModeS codes to check if they're on the Airnav server database.

http://www.airnavsystems.com/cgi-bin/ANLV_SV/ANLV_SV_user.exe?usgetphoto=0&usverify_name=PGANRB000000&usversion=ANRB306&regsearch=&modes=nnnnnn

where nnnnnn is the ModeS hex code.

I'm sure I remember AirNav threatening to excommunicate us if we used URLs like this to query their server directly :-)

Or at least saying that this wasn't supported, and couldn't always be guaranteed to work. Having said that, it's hard to see how it would stop working, since RadarBox itself uses the same mechanism to retrieve aircraft details.

However it's worth noting that the details that come back from querying the server aren't always consistent with what comes up on the RB screen - for example those two AFR and ACA 777-300ERs show in MyFlights as B773s whereas they are actually B77Ws.

tarbat · « **Reply #6 on:** October 07, 2009, 08:40:37 AM »

Quote from: DaveReid on October 07, 2009, 08:28:03 AM

However it's worth noting that the details that come back from querying the server aren't always consistent with what comes up on the RB screen - for example those two AFR and ACA 777-300ERs show in MyFlights as B773s whereas they are actually B77Ws.

I guess that would depend on what's already saved in your Navdata database. At least the first of the AFR 777s is a B77W in my Radarbox.

NickJackson · « **Reply #7 on:** October 07, 2009, 12:36:20 PM »

I have no idea how to allow anrb.exe to the Internet but I'll poke around on my system to see where that facility my be. Control Panel I assume.

As for weather reports, I haven't seen any but I'm still new to the software and I may not have that facility 'on'. I'll investigate.

tarbat · « **Reply #8 on:** October 07, 2009, 12:45:00 PM »

Quote from: NickJackson on October 07, 2009, 12:36:20 PM

I have no idea how to allow anrb.exe to the Internet but I'll poke around on my system to see where that facility my be. Control Panel I assume.

What firewall software do you have installed? That's where you need to allow access for anrb.exe.

To test a weather report, put EGPE in the Airport box in the toolbar, and press the "Get Weather" button next to it. That will prove whether anrb can access the internet or not.

NickJackson · « **Reply #9 on:** October 07, 2009, 12:51:32 PM »

I did get the weather for EGPE okay. I'm not clued up on the system setup by I think it will be part of the ESET / NOD32 internet protection. I'm investigating now.

NickJackson · « **Reply #10 on:** October 07, 2009, 01:09:14 PM »

I've now allowed anrb.exe in the ESET personal firewall but it doesn't seem to make any difference.

tarbat · « **Reply #11 on:** October 07, 2009, 01:15:03 PM »

Sounds like this isn't a firewall problem then.

So, first to check. Are these aircraft received by your hardware, rather than received over the network?

And what database are they missing from - navdata or mylog?

NickJackson · « **Reply #12 on:** October 07, 2009, 02:11:10 PM »

The 131 missing aircraft were from the MyLog and therefore received by the hardware. However, if you look at the main RB screen in each of the 'MyFlights' and 'Network' lists there are large gaps for the registrations. I can readily see thsi with the RYR and EZY fleets but there are many gaps for many other airlines.

If I check some of the 131 missing aircraft in the Database Explorer under 'Aircraft' they don't appear in the list. Is that the navdata databse?

If I go to MyLogs -> Tools -> Populate it does seem to regularly add details (17 just now) but which 17 I'm not sure. It could be its NOW updating new db records but there's a group of old ones from 2008/2009 that it's never had and can't update for some reason. Sounds weird but I don't know how else to explain it.

Fenris · « **Reply #13 on:** October 07, 2009, 02:37:41 PM »

Quote from: tarbat on October 07, 2009, 01:15:03 PM

Sounds like this isn't a firewall problem then.

I wouldn't be so sure, someone was saying that they had a similar problem and they mentioned ESET. Is that Kaspersky?

Suggest Nick J that you deactivate the firewall and see if that makes it work. You can then try and work out what the firewall is doing to deny RB access to the server.

Just found this comment, maybe the OP can explain what he changed to make it work:

http://www.airnavsystems.com/forum/index.php?topic=3482.msg33600#msg33600

NickJackson · « **Reply #14 on:** October 07, 2009, 03:08:16 PM »

De-activated the firewall (ESET and Windows) and no difference.

What I have noticed is that in the main RB screen there's a line that says "All photo/info requests done". Twice today I've noticed it change to "Processing 160 photo/info requests" (or whatever number it said). If you put your mouse over that message whilst it says that you get a pop-up window listing the ModeS codes being processed. Guess what - a quick comparison of some of these reveals some of the ones I'm missing.

It looks like it's trying to update and fill in the blanks but it can't update the database?

Author Topic: Database problem (Read 8027 times)

NickJackson

Database problem

tarbat

Re: Database problem

NickJackson

Re: Database problem

Fenris

Re: Database problem

tarbat

Re: Database problem

DaveReid

Re: Database problem

tarbat

Re: Database problem

NickJackson

Re: Database problem

tarbat

Re: Database problem

NickJackson

Re: Database problem

NickJackson

Re: Database problem

tarbat

Re: Database problem

NickJackson

Re: Database problem

Fenris

Re: Database problem

NickJackson

Re: Database problem