Submitting data with a Raspberry P

Questions about joining this site
Post Reply
bosgnoom
Posts: 7
Joined: Mon Jul 27, 2015 7:16 am

Submitting data with a Raspberry P

Post by bosgnoom »

Hello all,

Perhaps you can help me out... I used to upload my data to the live military mode s site using my Raspberry Pi 2. As I also use it for other hobby projects I have been offline for some time.

Now I want to get back to upload my data also to this site. However, the java client seems to have an error. It does fetch the data from dump1090, but when uploading there is something wrong.

Fetching data:

Code: Select all

MSG,6,333,15,400AE3,115,2016/04/03,07:29:43.619,2016/04/03,07:29:43.619,,37025,,,,,,1000,0,0,0,0
MSG 6 400AE3   Roermond, NL   2016/04/03   1000   37025
[4CA97E, 3C6628, 471EA7, 471F63, 485064, 471EAA, 4CA808, 3C49C8, 400AE3]
MSG 6 Prepared Statmentcom.mysql.jdbc.JDBC4PreparedStatement@187f9e0: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('400AE3','Roermond, NL','2016/04/03','07:29:43.619','07:29:43.619','1000','37025')
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO: MSG 6 Prepared Statmentcom.mysql.jdbc.JDBC4PreparedStatement@187f9e0: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('400AE3','Roermond, NL','2016/04/03','07:29:43.619','07:29:43.619','1000','37025')
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO:
Uploading to server? Some tables do not exist...

Code: Select all

Exception: Exc H6 Status PI com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
        at foo.db.Logging_Current.main(Logging_Current.java:403)
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO: Exception: Exc H6 Status PIcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO:
Has this anything to do with the main site being offline?

Can anyone help me out?
modesfan
Posts: 111
Joined: Thu Apr 07, 2016 7:37 pm

Re: Submitting data with a Raspberry P

Post by modesfan »

Hello bosgnoom,

I had the same problems that you reported at that time. Seems the server was down or overloaded.

My solution: just waited and tried again a couple of days later.

I configured the run-script to write the output into a logfile. From time to time I check this file. There are periods, when the SQL server doesn't respond: 'modes.LATLONPI' or 'modes.STATUSPI' doesn't exit.

The forum seems to be kind of dead. Maybe it is because one doesn't get a login when registering for SQL-stuff.

I made a proposal to filter out civil traffic like EZY*, AB* and DLH* etc. on client side using a blacklist. This should reduce load on server drastically. If the data is not used for MLAT then it would be save to ignore them. But Albert did not seem to be interested.

Cheers!
bosgnoom
Posts: 7
Joined: Mon Jul 27, 2015 7:16 am

Re: Submitting data with a Raspberry P

Post by bosgnoom »

Thanks for your information. I have noticed that there's not much activity on this forum ;-)

I've restarted submitting to the website. The log shows that I am submitting the data, the previous errors do not longer occur. However, I cannot see any of my data showing on the website. Also the last submitted date does not show for my location, as with the other Pi's...

Anyone have a clue?

[EDIT]

I've just checked and now my info shows on the Netherlands - Current page!
Post Reply