FlightAirMap

c0by

c0by

New Member
i found some great software...

https://github.com/Ysurac/FlightAirMap/

[...]
Open source project displaying aircrafts on a map. Browse through the data based on a particular aircraft, airline or airport to search through the database. See extensive statistics such as most common aircraft type, airline, departure & arrival airport and busiest time of the day, or just explore flights. Can use FlightAware, ADS-B in SBS1 for…
http://flightairmap.zugaina.net/
[...]

[...]
FlightAirMap is a fork of Barrie Spotter https://github.com/barriespotter/Web_App with map, airspaces, PDO and ADS-B support. Browse through the data based on a particular aircraft, airline or airport to search through the database. See extensive statistics such as most common aircraft type, airline, departure & arrival airport and busiest time of the day, or just explore flights.
[...]
 

Attachments

  • pf1.JPG
    pf1.JPG
    271.4 KB · Views: 212
  • pf2.JPG
    pf2.JPG
    111.4 KB · Views: 200
caius

caius

Member
That has some pretty nice features. Installation is interesting though...

Edit - Installation using lighttpd is a complete pain, due to lighttpd not understanding apache style .htaccess files. It means rewriting all the rules into lighttpd.conf, or switching to a different web server. Ho hum.
 
Last edited:
tonkepen

tonkepen

New Member
I took 3 days and trying to connect anything, I talk to Mario over the program and either, or local or dedicated my god if anyone knows to tell me something, in the end I shot out the window.
 
loplo

loplo

New Member
I can't make it work on ubuntu/apache. Can't import some databases, receiving some errors like:
Code: 
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
 
J

juha

New Member
loplo said:
I can't make it work on ubuntu/apache. Can't import some databases, receiving some errors like:
Code: 
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Click to expand...

Probably too old mysql. I think it requires mysql 5.6.
I don't think it's possible to install this, there's so many errors/glitches even if you get the database working.
 
tonkepen

tonkepen

New Member
No, not the mysql is in a version higher than 5.6, the problem is that the puck does not connect to the web for departing flights, see the web ....

And thank you very much for your answer.

http://tres.piro.biz
 
loplo

loplo

New Member
I'm successfully connecting to my dump1090 30003 output.
Importing the database (manually) is a PITA. I'm running mysql 5.5.43.
 
tonkepen

tonkepen

New Member
For the truth I'm going crazy, I can not connect web-care I have on a different server where I have the puck.

And if you know put it in God I would love you to help me because as I tell you and took 3 days and nothing on trying.

I give you my TeamSpeak3 if you want to talk. host: ts.piro.biz - no password.

And verry verry thanks
 
tonkepen

tonkepen

New Member
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

This error is the version of mysql.
 
tonkepen

tonkepen

New Member
when I run it from the browser I get this error...

Connecting to SBS ... Connection in progress to 87.222.29.220:30003.... Connected! SCAN MODE
Warning: socket_read(): unable to read from socket [110]: Connection timed out in /home/trespiro/public_html/cron-sbs.php on line 81
Connection in progress to 87.222.29.220:30003....
 
loplo

loplo

New Member
If it comes to mysql 5.6, then i'm not ready to upgrade, since the default mysql for my ubuntu is 5.5.

Did you forward your ports? on the router/network running the pi? You need to forward 30003 to any desired port.
 
tonkepen

tonkepen

New Member
1.- This fail because MySQL < 5.6.5. CURRENT_TIMESTAMP as default value for DATETIME type is not available before.
True, or I will have to support MySQL < 5.6...
You can try to remove "DEFAULT CURRENT_TIMESTAMP" in class.update_schema.php.
For example :
sed -i 's: DEFAULT CURRENT_TIMESTAMP::g' install/*.php

This should work.

2.- the second point that you ask me I do not understand what you mean, forgive my English is very bad, I understand that if I have open port 30003 on the router ?.
 
loplo

loplo

New Member
Your port is open, I just checked and I'm able to connect and receive data.
Code: 
./cron-sbs.php
Connecting to SBS ...
Connection in progress to 87.222.29.220:30003....
Connected!
SCAN MODE

*********** New aircraft hex : 4CA859 ***********
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flightmap.translation' doesn't exist' in /var/www/html/flightmap/require/class.Spotter.php:1804
Stack trace:
#0 /var/www/html/flightmap/require/class.Spotter.php(1804): PDOStatement->execute(Array)
#1 /var/www/html/flightmap/require/class.SBS.php(15): Spotter::getOperator('RMMSG')
#2 /var/www/html/flightmap/require/class.SBS.php(100): SBS::get_Schedule('4CA859', 'RMMSG')
#3 /var/www/html/flightmap/cron-sbs.php(92): SBS::add(Array)
#4 {main}
  thrown in /var/www/html/flightmap/require/class.Spotter.php on line 1804
*********** New aircraft hex : 344459 ***********
*********** New aircraft hex : 4009D9 ***********
*********** New aircraft hex : 400F01 ***********
*********** New aircraft hex : 4068B7 ***********
*********** New aircraft hex : 4242AB ***********
*********** New aircraft hex : 020027 ***********
*********** New aircraft hex : 4CA226 ***********
*********** New aircraft hex : 3964ED ***********
*********** New aircraft hex : 4B38FE ***********
*********** New aircraft hex : 3C5444 ***********
*********** New aircraft hex : 3411D6 ***********
*********** New aircraft hex : 0200AF ***********
*********** New aircraft hex : 34260E ***********
*********** New aircraft hex : AA2336 ***********
*********** New aircraft hex : 06A1A3 ***********
*********** New aircraft hex : 3C6442 ***********
*********** New aircraft hex : 406D8D ***********
*********** New aircraft hex : 4D00C1 ***********
*********** New aircraft hex : 020066 ***********
^C

ctrl-c or kill signal received. Tidying up ... Bye!
Disregard the errors. It's mysql related.

Does your hosting/server meet all the requirements? curl/etc?
 
tonkepen

tonkepen

New Member
The question is whether the port 30003 on the server that have put the web would have to be open no ?.

Because then I think not, I'll ride it again and tell you to open it and see what happens, super thank you for your patience.

PD if everything is absolutely perfect as to all .....


System Requirements
To install the web app which Barrie Spotter runs, you need to have meet the following requirements:

  • PHP version 5.2.3 or greater (5.3 or greater is recommended)
  • MySQL version 5.6 or greater (or MariaDB)
  • SQLite 3 (if you use ADS-B as datasource)
  • An HTTP Server such as:
    • Apache 2.0+
    • Nginx (include install/flightairmap-nginx-conf.include in server part of the config)
Required Extensions
The follwing is a list of PHP extensions that must be installed on your server in order for this web app to run properly:

 
tonkepen

tonkepen

New Member
If the hosting is all right since. What I'm saying is the port open on the dedicated hosting pc not in my house where I have the radar.
 
tonkepen

tonkepen

New Member
Oleeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee y OLeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

see:

Connecting to SBS ... Connection in progress to 87.222.29.220:30003.... Connected! SCAN MODE *********** New aircraft hex : 4692D7 *********** *********** New aircraft hex : 344307 *********** *********** New aircraft hex : 341507 *********** *********** New aircraft hex : 342096 *********** *********** New aircraft hex : 406B6D *********** *********** New aircraft hex : 3C648E *********** *********** New aircraft hex : 4B15ED *********** *********** New aircraft hex : 396662 *********** *********** New aircraft hex : 34444C *********** *********** New aircraft hex : AE04D8 *********** *********** New aircraft hex : 43EA1F *********** *********** New aircraft hex : 400A7D *********** *********** New aircraft hex : 3C6424 *********** *********** New aircraft hex : 39840F *********** *********** New aircraft hex : 4242DA *********** *********** New aircraft hex : 406D8D *********** *********** New aircraft hex : 342059 *********** *********** New aircraft hex : 34208F *********** *********** New aircraft hex : 3445D2 *********** *********** New aircraft hex : 4068B7 *********** *********** N


Now grabs data was hosting server port that was closed fuck three days.

Thank LOPRO owe you a beer graciasssssssssss
 
caius

caius

Member
I managed to get this running eventually, but it's pretty resource heavy. On a raspberry pi 2, the map is slow to update with aircraft, and it doesn't seem to show all the aircraft that I'm receiving. After running for a while mysql ran out of memory, which is probably a configuration issue, but CPU use is also high. It probably works OK on a more powerful system or maybe if the pi is dedicated to running it, but as there are other services running it's a bit too much.
 
You must log in or register to reply here.
Top