Help needed to test new reporting tool

Questions about joining this site
faxstefa
Posts: 9
Joined: Tue Apr 26, 2016 8:39 pm

Re: Help needed to test new reporting tool

Post by faxstefa »

Hi Roy,

I had to install the latest version of JAVA for Raspberry Pi.
https://www.raspberrypi.org/forums/view ... 1&t=101543

I think that I used this command line via SSH:
sudo apt-get update && sudo apt-get install oracle-java8-jdk

Installation takes about 5 min. Reboot the Pi after the installation is complete.

Regards
Stefan
ronagel
Posts: 20
Joined: Sat Apr 11, 2015 3:24 pm

Re: Help needed to test new reporting tool

Post by ronagel »

Hi Stefan,

thanks a lot for your reply ! I'll give it a try in the next few days.

Regards
Roy
ronagel
Posts: 20
Joined: Sat Apr 11, 2015 3:24 pm

Re: Help needed to test new reporting tool

Post by ronagel »

I get the following error messages:

IOException IO Exc F: java.net.ConnectException: Connection refused
.....

java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at java.net.Socket.<init>(Socket.java:434)
at java.net.Socket.<init>(Socket.java:211)

Roy
modesfan
Posts: 111
Joined: Thu Apr 07, 2016 7:37 pm

Re: Help needed to test new reporting tool

Post by modesfan »

Hello Roy, please check the parameters in the script /etc/init.d/modes.sh!
Do they fit your setup?
If so, try "java -jar modesfiltered -port 30005" from command line. This sould give you some lines of: "stringarray to short" and "no MSG symbol.
ronagel
Posts: 20
Joined: Sat Apr 11, 2015 3:24 pm

Re: Help needed to test new reporting tool

Post by ronagel »

Hi modesfan,

thanks for your reply. Could you give me some more details about the necesarry config details. Does the port # in modes.sh file has to match the port # in the piaware config file ?

Thanks in advance
Roy
modesfan
Posts: 111
Joined: Thu Apr 07, 2016 7:37 pm

Re: Help needed to test new reporting tool

Post by modesfan »

The default output port of dump1090 for BaseStation format is 30003. Modesfiltered is configured to use this port by default. You can override it with the parameter -port followed by a number.
If you want to use a second port (parameter -port2) for MLAT data then you have to configure piaware to output the data to port 31003:

Code: Select all

sudo piaware-config -mlatResultsFormat "beast,connect,localhost:30104 basestation,listen,31003"
restart

Code: Select all

sudo service piaware restart
start modesfiltered with

Code: Select all

java -jar modesfiltered.jar -port2 31003
Last edited by modesfan on Fri Feb 03, 2017 7:22 pm, edited 1 time in total.
modesfan
Posts: 111
Joined: Thu Apr 07, 2016 7:37 pm

Re: Help needed to test new reporting tool

Post by modesfan »

You can check whether there is data coming from the ports with:

standard port of dump1090

Code: Select all

nc 127.0.0.1 30003
You can stop the output with CTRL+C. If this doesn't ouput lines with comma separated values then you should check your installation.


newly created MLAT port

Code: Select all

nc 127.0.0.1 31003
You can stop the output with CTRL+C. If this doesn't ouput lines with comma separated values then you should not use the optional -port2.
modesfan
Posts: 111
Joined: Thu Apr 07, 2016 7:37 pm

Re: Help needed to test new reporting tool

Post by modesfan »

Hi Roy,
Thanks for reporting! I see 3 cases: “---“, a white block or an altitude.
The “---“ means that modesfiltered did not send altitude information to the database. Within 10 to 60 seconds after the first contact (based on hexid) the station did not receive an altitude but reports the flight without.
A white block means that Albert’s programs (database or website) somehow ignored altitude and squawk. This happens if the first contact was a message of type 3 that will be inserted into LATLONPI. I will investigate this.
ronagel
Posts: 20
Joined: Sat Apr 11, 2015 3:24 pm

Re: Help needed to test new reporting tool

Post by ronagel »

Hi modesfan
"---" is the case, I will queck the logfile tomorow and give you some more details what the script sends to the server
ronagel
Posts: 20
Joined: Sat Apr 11, 2015 3:24 pm

Re: Help needed to test new reporting tool

Post by ronagel »

Hi modesfan,

here's an excerpt of the log file.

Please note that all aircraft are shown with an altitude on my local installation (dump1090 accessed by a browser)

Hope this helps.

Tue Mar 21 16:57:05 UTC 2017 Received MSGs: 73313 filtered MSGs: 41884
149456 MSGs of types: 713, 0, 6554, 6628, 37083, 8306, 20658, 69109

Executed com.mysql.jdbc.JDBC4PreparedStatement@1940d4e: UPDATE statusPI SET Altitude = '25375' where HexCode = '3CE005'
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:16.069, 2017/03/21, 16:57:16.117, , 40000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:18.044, 2017/03/21, 16:57:18.087, , 40025, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 506C22, 1, 2017/03/21, 16:57:18.899, 2017/03/21, 16:57:18.954, , 38000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:21.069, 2017/03/21, 16:57:21.096, , 40000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 3C660B, 1, 2017/03/21, 16:57:21.439, 2017/03/21, 16:57:21.475, , 34975, , , , , , , , , , 0]
Exception: Exc H3 LATLONPI. Try to requeue.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.LATLONPI' doesn't exist
Lat
format error
[MSG, 3, 1, 1, 896461, 1, 2017/03/21, 16:57:22.181, 2017/03/21, 16:57:22.232, , 40000, , , , , , , , , , 0]
Lat
format error
[MSG, 3, 1, 1, 40087C, 1, 2017/03/21, 16:57:26.800, 2017/03/21, 16:57:26.827, , 38000, , , , , , , , , , 0]
Executed com.mysql.jdbc.JDBC4PreparedStatement@c5da09: UPDATE statusPI SET Altitude = '1875' where HexCode = '4D00D4'
Lat
format error
[MSG, 3, 1, 1, 3C660B, 1, 2017/03/21, 16:57:27.709, 2017/03/21, 16:57:27.751, , 34975, , , , , , , , , , 0]
Executed com.mysql.jdbc.JDBC4PreparedStatement@7af6a: INSERT IGNORE INTO liveidPI(hexcodeID, DateID, TimeID, CSID, Locatie) VALUES ('398560','2017/03/21','16:56:25.999','---','MyStation,DE')
Executed com.mysql.jdbc.JDBC4PreparedStatement@1e28167: INSERT IGNORE INTO LATLONPI(Hexcode, Location, Date, Time, Lat, Lng, head, Callsign, Alt, Squawk, TimeCreated) VALUES ('4784A1','MyStation,DE','2017/03/21','16:56:20.309','50.65599','4.40328','---','---','39075','0743','2017,03,11 10:02.02')
Lat
format error
[MSG, 3, 1, 1, 4B19E8, 1, 2017/03/21, 16:57:30.965, 2017/03/21, 16:57:30.981, , 24000, , , , , , , , , , 0]
4A91F8 removed from db.
406D4E removed from db.
4BA9A8 removed from db.
Executed com.mysql.jdbc.JDBC4PreparedStatement@13bcc34: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('398560','MyStation,DE','2017/03/21','16:56:37.083','16:56:37.083','1000','---')
format error
[MSG, 7, 1, 1, 4CA6FD, 1, 2017/03/21, 16:57:40.161, 2017/03/21, 16:57:40.203]
Executed com.mysql.jdbc.JDBC4PreparedStatement@199fac5: INSERT IGNORE INTO liveidPI(hexcodeID, DateID, TimeID, CSID, Locatie) VALUES ('4D020F','2017/03/21','16:57:37.228','---','MyStation,DE')
Executed com.mysql.jdbc.JDBC4PreparedStatement@d98a5b: INSERT IGNORE INTO liveidPI(hexcodeID, DateID, TimeID, CSID, Locatie) VALUES ('405636','2017/03/21','16:56:47.455','---','MyStation,DE')
Executed com.mysql.jdbc.JDBC4PreparedStatement@1b2f396: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('405636','MyStation,DE','2017/03/21','16:56:47.523','16:56:47.523','7523','---')
Lat
format error
[MSG, 3, 1, 1, 4D212D, 1, 2017/03/21, 16:57:50.701, 2017/03/21, 16:57:50.743, , 45000, , , , , , , , , , 0]
Post Reply