FlightAirMap

c0by

New Member
#1
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

#2
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:
#3
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

New Member
#4
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
 

juha

New Member
#5
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
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.
 

loplo

New Member
#7
I'm successfully connecting to my dump1090 30003 output.
Importing the database (manually) is a PITA. I'm running mysql 5.5.43.
 
#8
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
 
#10
#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.
 
#11
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

New Member
#12
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.
 
#13
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

New Member
#14
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?
 
#15
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:

 
#18
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
 
#20
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.