OpenGTS Integration not working - Unknown device

Deme Tole7 years ago

I made the following change:

    <entry key='database.selectAllDevices'>
        SELECT CONCAT('1', imeiNumber) AS id, imeiNumber AS uniqueId FROM Device WHERE imeiNumber REGEXP '^[0-9]+$';
    </entry>

But I always get the same results:

2017-10-22 20:42:03  INFO: Operating system name: Linux version: 3.10.0-693.2.2.el7.x86_64 architecture: amd64
2017-10-22 20:42:03  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 25.151-b12
2017-10-22 20:42:03  INFO: Memory limit heap: 1739mb non-heap: 0mb
2017-10-22 20:42:03  INFO: Character encoding: UTF-8 charset: UTF-8
2017-10-22 20:42:03  INFO: Version: 3.14-SNAPSHOT
2017-10-22 20:42:05  INFO: Starting server...
2017-10-22 20:42:29  INFO: [0EBCF61F] connected
2017-10-22 20:42:29 DEBUG: [0EBCF61F: 5055 < 190.152.173.34] HEX: 504f5354202f3f69643d3633313230322674696d657374616d703d31353038323634343730266c61743d2d322e393034353635266c6f6e3d2d37382e39383336353333333333333333322673706565643d302e302662656172696e673d3233362e343239393932363735373831323526616c7469747564653d323531332e362661636375726163793d3233362e343239393932363735373831323526626174743d39312e3020485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420372e303b205669766f203552204275696c642f4e524439304d290d0a486f73743a2034352e37362e3233352e3138333a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2017-10-22 20:42:29  WARN: Unknown device - 631202 (190.152.173.34)
2017-10-22 20:42:29 DEBUG: [0EBCF61F: 5055 > 190.152.173.34] HEX: 485454502f312e31203430302042616420526571756573740d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2017-10-22 20:43:00 DEBUG: [0EBCF61F: 5055 < 190.152.173.34] HEX: 504f5354202f3f69643d3633313230322674696d657374616d703d31353038323634343730266c61743d2d322e393034353635266c6f6e3d2d37382e39383336353333333333333333322673706565643d302e302662656172696e673d3233362e343239393932363735373831323526616c7469747564653d323531332e362661636375726163793d3233362e343239393932363735373831323526626174743d39312e3020485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420372e303b205669766f203552204275696c642f4e524439304d290d0a486f73743a2034352e37362e3233352e3138333a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2017-10-22 20:43:00  WARN: Unknown device - 631202 (190.152.173.34)
2017-10-22 20:43:00 DEBUG: [0EBCF61F: 5055 > 190.152.173.34] HEX: 485454502f312e31203430302042616420526571756573740d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2017-10-22 20:43:30 DEBUG: [0EBCF61F: 5055 < 190.152.173.34] HEX: 504f5354202f3f69643d3633313230322674696d657374616d703d31353038323634343730266c61743d2d322e393034353635266c6f6e3d2d37382e39383336353333333333333333322673706565643d302e302662656172696e673d3233362e343239393932363735373831323526616c7469747564653d323531332e362661636375726163793d3233362e343239393932363735373831323526626174743d39312e3020485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420372e303b205669766f203552204275696c642f4e524439304d290d0a486f73743a2034352e37362e3233352e3138333a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2017-10-22 20:43:30  WARN: Unknown device - 631202 (190.152.173.34)
2017-10-22 20:43:30 DEBUG: [0EBCF61F: 5055 > 190.152.173.34] HEX: 485454502f312e31203430302042616420526571756573740d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2017-10-22 20:44:00 DEBUG: [0EBCF61F: 5055 < 190.152.173.34] HEX: 504f5354202f3f69643d3633313230322674696d657374616d703d31353038323634343730266c61743d2d322e393034353635266c6f6e3d2d37382e39383336353333333333333333322673706565643d302e302662656172696e673d3233362e343239393932363735373831323526616c7469747564653d323531332e362661636375726163793d3233362e343239393932363735373831323526626174743d39312e3020485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420372e303b205669766f203552204275696c642f4e524439304d290d0a486f73743a2034352e37362e3233352e3138333a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a436f6e74656e742d4c656e6774683a20300d0a0d0a

Which I'm doing wrong.

Thanks for your reply.

Anton Tananaev7 years ago

Are you sure you have 631202 in the database?