Help needed to test new reporting tool

[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]

Hi Stefan,

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

Regards
Roy

[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]

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]

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]

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

[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]

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]

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]

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]