search

Ysurac / FlightAirMap

Open source project displaying live aircrafts, ships or trackers on 2D/3D map. Browse through the data based on a particular aircraft, airline, airport, tracker or vessel to search through the database or see extensive statistics. Can use ADS-B in SBS1 format (dump1090, Radarcape,...), VRS, VA (VATSIM, IVAO whazzup.txt, phpvms,...), ACARS (acarsdec, acarsdeco2), APRS, AIS as datasource.
https://www.flightairmap.com/
GNU Affero General Public License v3.0
516 stars 157 forks source link

AIS NMEA feed #417

Open shaffye opened 5 years ago

shaffye commented 5 years ago

Hi, my install/index.php is not showing the content. Only the toolbar is displaying. Can I know if I missed any step here?

Ysurac commented 5 years ago

You have to check your apache/nginx and php logs file to find where the problem can be.

shaffye commented 5 years ago

@Ysurac turns out, my rewriting rule for PHP is disabled. Now its working.

Can you assist me on adding the vessel data from MarineTraffic API? If you wont commit to the updates, can you provide me a quick and dirty way where to update the database(for me to create windows service push to DB)? here is the API: https://www.marinetraffic.com/en/ais-api-services/documentation/api-service:ps03/

Many Thanks!

Ysurac commented 5 years ago

I don't have a paid access to marinetraffic feed, so difficult to add and test. But it should be easy by copying an existing import in script/daemon-spotter.php

shaffye commented 5 years ago

@Ysurac , I am using different source, which is AIS NMEA. The data is feeding every second, non stop. I am using PostgreSQL/MySQL. While I am doing this, I saw my PGSQL is stuck at 'idle in transaction'. While I saw the query already got the NMEA data, it has not been inserted to the database due to idle in transaction. Do you got any idea how can I overcome this? Thanks.

shaffye commented 5 years ago

image when I run the update_db, it stuck at Add to DB as per picture

b4b857f6ee commented 5 years ago

@shaffye did you solve your problem?