Page 1 of 1

Problem with JoinFS and FlightAirMap

Posted: Mon Mar 30, 2020 10:33 am
by vedum
Hello all,

I have installed a webserver apache2 with a mysql server and FlightAirMap.

The site running fine with my whazzup.txt file. The planes are showing well but i have some issues that i cannot fix.

1 )The name of the Aircrafts are not reconize
2) The heading of the aircraft is always at 0 degrees.

Please, help me?

Best regards

Re: Problem with JoinFS and FlightAirMap

Posted: Mon Mar 30, 2020 7:35 pm
by ATC Roo
vedum wrote: 1 )The name of the Aircrafts are not reconize
The CALLSIGN or AIRCRAFT TYPE?

Are the ones that dont show using XPlane?
vedum wrote: 2) The heading of the aircraft is always at 0 degrees.
The aircraft direction is based on more than one position update.
All aircraft start heading 360.
The map the shows the correct direction after it gains the next position.

Re: Problem with JoinFS and FlightAirMap

Posted: Mon Mar 30, 2020 8:20 pm
by vedum
Hello,

This is the aircraft type (ICAO) names "AircraftNot Available Not Available (NA)".

And it's not an xplane aircraft but FSX.

And for the heading, it's always at 0 even thought the multiple different positions of the aircraft.
Is there a parameter to fix this problem?

BR

Re: Problem with JoinFS and FlightAirMap

Posted: Mon Mar 30, 2020 11:59 pm
by ATC Roo
It sounds like your map source is incorrect.

Do you have source set to vatsim or IVAO?

If IVAO try setting everything to vatsim.

Re: Problem with JoinFS and FlightAirMap

Posted: Tue Mar 31, 2020 5:43 am
by vedum
Always same issues

i have set your whazzup.txt as source for test.
https://roo.servebeer.com/jfs/whazzup.txt

And set all sources as VATSIM orIVAO and it's KO.

Could you please give me your parameters of settings.txt?

Re: Problem with JoinFS and FlightAirMap

Posted: Tue Mar 31, 2020 8:00 am
by ATC Roo
//VATSIM
$globalVATSIM = TRUE;
//DATA SOURCES
$globalSources = array(array('host' => 'https://roo.servebeer.com/jfs/whazzup.txt','name' => 'JoinFS','format' => 'whazzup','sourcestats' => TRUE,'noarchive' => FALSE,'timezone' => 'UTC','callback' => FALSE));

Re: Problem with JoinFS and FlightAirMap

Posted: Tue Mar 31, 2020 8:41 am
by vedum
Always KO with your parameters.

Let see the log of the daemon-spotter.php.

*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : 9HAEN - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : 43.3701118290985 - Longitude : 9.51447658889065 - waypoints : - Altitude : 260 - Heading : - Speed : 311 - Departure Airport Time : - Arrival Airport time : - Pilot : - Source name : JoinFS LCA
\o/ Add 9HAEN from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
---- Deleting Live Spotter data Not updated since 2 hour... Done
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : FCYJGT - ICAO : NA - Departure Airport : TFFJ - Arrival Airport : TFFF - Latitude : 15.8034233671631 - Longitude : -61.3830010125244 - waypoints : - Altitude : 80 - Heading : - Speed : 273 - Departure Airport Time : - Arrival Airport time : - Pilot : VE-NANEX - Source name : JoinFS LCA
\o/ Add FCYJGT from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Not in DB.
\o/ Add PPCSM in archive DB : SuccessDelete old values and update latest data...
---- Deleting Live Spotter data older than 9 hours... Done
DATA : hex : 000000 - ident : PPCSM - ICAO : NA - Departure Airport : NA - Arrival Airport : NA - Latitude : 14.8879337310791 - Longitude : -24.4844436645508 - waypoints : - Altitude : 6 - Heading : - Speed : - Departure Airport Time : - Arrival Airport time : - Pilot : VH-DPW sandman - Source name : JoinFS LCA
\o/ Add PPCSM from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : ECIZR - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : -12.2996406555176 - Longitude : -77.2649459838867 - waypoints : - Altitude : 89 - Heading : - Speed : 299 - Departure Airport Time : - Arrival Airport time : - Pilot : - Source name : JoinFS LCA
\o/ Add ECIZR from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : ECLUN - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : -12.498893737793 - Longitude : -77.2040786743164 - waypoints : - Altitude : 136 - Heading : - Speed : 313 - Departure Airport Time : - Arrival Airport time : - Pilot : - Source name : JoinFS LCA
\o/ Add ECLUN from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : PHDLB - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : 50.9139823913574 - Longitude : -0.0573027469217777 - waypoints : - Altitude : 15 - Heading : - Speed : 121 - Departure Airport Time : - Arrival Airport time : - Pilot : PH-DLB - Source name : JoinFS LCA
\o/ Add PHDLB from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : PHEVA - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : 50.9389457702637 - Longitude : -0.0252668838948011 - waypoints : - Altitude : 11 - Heading : - Speed : 120 - Departure Airport Time : - Arrival Airport time : - Pilot : PH-EVA - Source name : JoinFS LCA
\o/ Add PHEVA from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000515 ***********
Check if aircraft is already in DB... Not in DB.
\o/ Add in archive DB : SuccessDelete old values and update latest data...
DATA : hex : 000515 - ident : - ICAO : NA - Departure Airport : NA - Arrival Airport : NA - Latitude : 9.4704532623291 - Longitude : 95.9639587402344 - waypoints : - Altitude : 380 - Heading : - Speed : 428 - Departure Airport Time : - Arrival Airport time : - Pilot : IV1301 - MidNight - - Source name : JoinFS LCA
\o/ Add from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000633 ***********
Check if aircraft is already in DB... Not in DB.
\o/ Add ISTEY in archive DB : SuccessDelete old values and update latest data...
DATA : hex : 000633 - ident : ISTEY - ICAO : NA - Departure Airport : LIPY - Arrival Airport : LIPO - Latitude : 43.738037109375 - Longitude : 12.6582708358765 - waypoints : - Altitude : 140 - Heading : - Speed : 136 - Departure Airport Time : - Arrival Airport time : - Pilot : IV1587 - Stefano - Source name : JoinFS LCA
\o/ Add ISTEY from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : N637BA - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : 34.9895248413086 - Longitude : -106.597869873047 - waypoints : - Altitude : 78 - Heading : - Speed : 254 - Departure Airport Time : - Arrival Airport time : - Pilot : - Source name : JoinFS LCA
\o/ Add N637BA from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : 35.1205253601074 - Longitude : -106.906402587891 - waypoints : - Altitude : 303 - Heading : - Speed : 412 - Departure Airport Time : - Arrival Airport time : - Pilot : - Source name : JoinFS LCA
\o/ Add from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : N585UP - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : 35.1778793334961 - Longitude : -106.859115600586 - waypoints : - Altitude : 367 - Heading : - Speed : 473 - Departure Airport Time : - Arrival Airport time : - Pilot : Avery - Source name : JoinFS LCA
\o/ Add N585UP from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 0003F4 ***********
Check if aircraft is already in DB... Not in DB.
\o/ Add ZB738 in archive DB : SuccessDelete old values and update latest data...
DATA : hex : 0003F4 - ident : ZB738 - ICAO : NA - Departure Airport : NA - Arrival Airport : NA - Latitude : 59.415843963623 - Longitude : 24.8072643280029 - waypoints : - Altitude : 1 - Heading : - Speed : - Departure Airport Time : - Arrival Airport time : - Pilot : 1012 Stromer - Source name : JoinFS LCA
\o/ Add ZB738 from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
New flight...
*********** New aircraft hex : 000000 ***********
Check if aircraft is already in DB... Already in DB.
DATA : hex : 000000 - ident : - ICAO : NA - Departure Airport : - Arrival Airport : - Latitude : 35.7585639953613 - Longitude : -89.5512619018555 - waypoints : - Altitude : 4 - Heading : - Speed : - Departure Airport Time : - Arrival Airport time : - Pilot : TownDogTenn - Source name : JoinFS LCA
\o/ Add from whazzup in Live DB : -- Delete previous data -- (Add to Spotter archive : success)success
Check all...


We see that the Heading and the ICAO are not reconize.

Re: Problem with JoinFS and FlightAirMap

Posted: Tue Mar 31, 2020 8:54 am
by ATC Roo
So the information on your map is different to my map, even when using my whazzup for both maps?

Re: Problem with JoinFS and FlightAirMap

Posted: Tue Mar 31, 2020 8:55 am
by vedum
yes. I don't understand what is wrong in my configuration.

Maybe that the version of flightairmap is not the same of yours?

Re: Problem with JoinFS and FlightAirMap

Posted: Tue Mar 31, 2020 9:07 am
by ATC Roo
Mine is the latest git clone as of 3 days ago when I had to rebuild my server.

Are your MySql tables correct?

Is aircraft data in the database?

Re: Problem with JoinFS and FlightAirMap

Posted: Tue Mar 31, 2020 11:43 am
by vedum
I have delete all the tables and create it again with the installer by php

I see this error when i run update_db.php

Code: Select all

root@web:/home/stephane# php /var/www/map/flightairmap/scripts/update_db.php                                                       updating NOTAM...NOTAM from FlightAirMap website : Download...Gunzip...Add to DB............................................................................Done
Check if new airspace version exist...Airspace from FlightAirMap website : Download...Gunzip...Add to DB...error (import /var/www/map/flightairmap/install/tmp/airspace.sql) : SQLSTATE[22003]: Numeric value out of range: 1416 Cannot get geometry object from data you send to the GEOMETRY field
Check if new geoid version exist...Geoid from FlightAirMap website : Download...Gunzip...Done
updating METAR...Downloading METAR cycle...Done - Updating DB...Done
Deleting archive old data...Deleting archive track old data...Done
Deleting tracker archive track old data...Done
Deleting marine archive track old data...Done
There are datas in the table spotter_live.

And what is your version of php?

Re: Problem with JoinFS and FlightAirMap

Posted: Wed Apr 01, 2020 10:54 am
by ATC Roo
Sorry for the late reply, I'm one of the few still in work. :roll:

I think it might be that your database isnt populated with all the tables.

The install script might be stopping before populating all the tables, like aircraft type.

Try disabling geo height as that is what the post above says it couldn't find.

Re: Problem with JoinFS and FlightAirMap

Posted: Wed Apr 01, 2020 11:33 am
by vedum
Hello,

I work from home too.

I think it comes from my version of PHP. I run with an Ubuntu 18.04 and a PHP version of 7.2.

In the prerequisites it says PHP 7.4 or higher. I will try to test with PHP 7.4.