search

bravohe / sma-bluetooth

Automatically exported from code.google.com/p/sma-bluetooth
0 stars 0 forks source link

Segmentation fault with SB3600TL-21 #130

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. run ./smatool

What is the expected output? What do you see instead?
# ./smatool -d -c smatool.conf -v
variable=Inverter value=3600TL
variable=BTAddress value=00:80:25:A6:XX:XX
variable=BTTimeout value=
variable=Password value=XXXX
variable=Config value=./smatool.conf
variable=File value=sma.in.new
variable=Latitude value=51.4530491
variable=Longitude value=3.7739149
variable=MySqlHost value=localhost
variable=MySqlDatabase value=smatool
variable=MySqlUser value=root
variable=MySqlPwd value=XXXX
variable=Inverter value=3600TL
variable=Code1 value=0xcf
variable=Code2 value=0x7f
variable=Code3 value=0x39
variable=Code4 value=0x39
variable=InvCode value=0x8a
utc=2013-11-21 21:50 local=2013-11-21 22:50 diff 1 hours
localOffset=1.000000
localOffset=1.000000 isdst=0
tzsecs=e11 3601
tzsecs=0e 11
Before todays Almanac
SELECT sunrise FROM Almanac WHERE date=DATE_FORMAT( NOW(), "%Y-%m-%d" )
Segmentation fault

What version of the product are you using? On what operating system?
- smatool v18 on Debian 7.2
- SB3600-TL-21 inverter is used, the inverter codes in invcode.in are 
subtracked from a capture with SnoopyPro (see attached file).

Please provide any additional information below.

How can we get smatool working with the SB3600TL-21 inverter? can you please 
help with the Segmentation Fault?

When running smatool with --test parameter the segmentation fault does not 
appear. Hereby the output:

# ./smatool -d -c smatool.conf -v --test
variable=Inverter value=3600TL
variable=BTAddress value=00:80:25:A6:75:09
variable=BTTimeout value=
variable=Password value=XXXX
variable=Config value=./smatool.conf
variable=File value=sma.in.new
variable=Latitude value=51.4530491
variable=Longitude value=3.7739149
variable=MySqlHost value=localhost
variable=MySqlDatabase value=smatool
variable=MySqlUser value=root
variable=MySqlPwd value=XXXX
variable=Inverter value=3600TL
variable=Code1 value=0xcf
variable=Code2 value=0x7f
variable=Code3 value=0x39
variable=Code4 value=0x39
variable=InvCode value=0x8a
utc=2013-11-21 21:56 local=2013-11-21 22:56 diff 1 hours
localOffset=1.000000
localOffset=1.000000 isdst=0
tzsecs=e11 3601
tzsecs=0e 11
SELECT data FROM settings WHERE value='schema'
auto_set_dates
Auto set dates from 2000-01-01 00:00:00 to 2013-11-21 22:56:00
Address 00:80:25:A6:XX:XX
datefrom=2000-01-01 00:00:00 dateto=2013-11-21 22:56:00
[18] 2013-11-21 22:56:11 Waiting for string
[18] 2013-11-21 22:56:11 waiting for: 7e 1f 00 61 09 75 a6 25 80 00 00 00 00 00 
00 00 02 00 00 04 70 00

[18] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1f 00 61
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 02 00 00 04
    00000020: 70 00 01 00 00 00 00 01 00 00 00  rr=31

[18] 2013-11-21 22:56:11 looking for: 7e 1f 00 61 09 75 a6 25 80 00 00 00 00 00 
00 00 02 00 00 04 70 00
[18] 2013-11-21 22:56:11 received:    7e 1f 00 61 09 75 a6 25 80 00 00 00 00 00 
00 00 02 00 00 04 70 00 01 00 00 00 00 01 00 00 00

[18] 2013-11-21 22:56:11 Found string we are waiting for
[19] 2013-11-21 22:56:11 Extracting
extracting invcode=01
[20] 2013-11-21 22:56:11 Sending
[20] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1f 00 61
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 02 00 00 04
    00000020: 70 00 01 00 00 00 00 01 00 00 00  cc=31

[21] 2013-11-21 22:56:11 Waiting for string
[21] 2013-11-21 22:56:11 waiting for: 7e 22 00 5c 09 75 a6 25 80 00 00 00 00 00 
00 00 05 00 09 75 a6 25 80 00

[21] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1f 00 61
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 0a 00 09 75
    00000020: a6 25 80 00 01 14 71 da 7d 1a 00  rr=31

sum=80length change from 1f to 1e

[21] 2013-11-21 22:56:11 looking for: 7e 22 00 5c 09 75 a6 25 80 00 00 00 00 00 
00 00 05 00 09 75 a6 25 80 00
[21] 2013-11-21 22:56:11 received:    7e 1e 00 62 09 75 a6 25 80 00 00 00 00 00 
00 00 0a 00 09 75 a6 25 80 00 01 14 71 da 3a 00

[21] 2013-11-21 22:56:11 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 0c 00 02 00  rr=20

[21] 2013-11-21 22:56:11 looking for: 7e 22 00 5c 09 75 a6 25 80 00 00 00 00 00 
00 00 05 00 09 75 a6 25 80 00
[21] 2013-11-21 22:56:11 received:    7e 14 00 6a 09 75 a6 25 80 00 00 00 00 00 
00 00 0c 00 02 00

[21] 2013-11-21 22:56:11 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 22 00 5c
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 05 00 09 75
    00000020: a6 25 80 00 01 01 14 71 da 7d 1a 00 02 01  rr=34

sum=7elength change from 22 to 21

[21] 2013-11-21 22:56:11 looking for: 7e 22 00 5c 09 75 a6 25 80 00 00 00 00 00 
00 00 05 00 09 75 a6 25 80 00
[21] 2013-11-21 22:56:11 received:    7e 21 00 5d 09 75 a6 25 80 00 00 00 00 00 
00 00 05 00 09 75 a6 25 80 00 01 01 14 71 da 3a 00 02 01

[21] 2013-11-21 22:56:11 Found string we are waiting for
[22] 2013-11-21 22:56:11 Extracting
[24] 2013-11-21 22:56:11 Sending
[24] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[25] 2013-11-21 22:56:11 Waiting for string
[25] 2013-11-21 22:56:11 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[25] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[25] 2013-11-21 22:56:11 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[25] 2013-11-21 22:56:11 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[25] 2013-11-21 22:56:11 Found string we are waiting for
[26] 2013-11-21 22:56:11 Extracting
bluetooth signal = 66%
[27] 2013-11-21 22:56:11 Sending
[27] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[28] 2013-11-21 22:56:11 Waiting for string
[28] 2013-11-21 22:56:11 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[28] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[28] 2013-11-21 22:56:11 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[28] 2013-11-21 22:56:11 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[28] 2013-11-21 22:56:11 Found string we are waiting for
[29] 2013-11-21 22:56:11 Sending
[29] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[30] 2013-11-21 22:56:11 Waiting for string
[30] 2013-11-21 22:56:11 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[30] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[30] 2013-11-21 22:56:11 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[30] 2013-11-21 22:56:11 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[30] 2013-11-21 22:56:11 Found string we are waiting for
[31] 2013-11-21 22:56:11 Sending
sum=80
  length change from 3f to 3e diff=80
new sum=7e
[31] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 3e 00 40
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 09 a0 ff ff ff ff ff ff 00 00 78 00 cf
    00000030: 7f 39 39 00 00 00 00 00 00 01 80 00 02 00 00 00
    00000040: 00 00 00 00 00 00 00 40 9d 7e  cc=62

[32] 2013-11-21 22:56:11 Sending
sum=80
  length change from 3b to 3a diff=80
new sum=7e
[32] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 3a 00 44
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 08 a0 ff ff ff ff ff ff 00 03 78 00 cf
    00000030: 7f 39 39 00 03 00 00 00 00 00 80 0e 01 fd ff ff
    00000040: ff ff ff db 50 7e  cc=58

[33] 2013-11-21 22:56:11 Sending
sum=7e
  length change from 54 to 52 diff=7e
new sum=7e
[33] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 52 00 2c
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 0e a0 ff ff ff ff ff ff 00 01 78 00 cf
    00000030: 7f 39 39 00 01 00 00 00 00 02 80 0c 04 fd ff 07
    00000040: 00 00 00 84 03 00 00 7a 81 8e 52 00 00 00 00 b8
    00000050: b8 b8 b8 88 88 88 88 88 88 88 88 e0 c5 7e  cc=82

[35] 2013-11-21 22:56:11 Waiting for string
[35] 2013-11-21 22:56:11 waiting for: 7e 6a 00 14 09 75 a6 25 80 00

[35] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 69 00 17
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 01 00 7e ff
    00000020: 03 60 65 7d 33 90 78 00 cf 7f 39 39 00 00 8a 00
    00000030: b0 f7 f8 7d 5e 00 00 00 00 00 00 01 80 01 02 00
    00000040: 00 00 00 00 00 00 00 00 00 00 03 00 00 00 ff 00
    00000050: 00 e0 71 00 20 01 00 8a 00 b0 f7 f8 7d 5e 00 00
    00000060: 0a 00 0c 00 00 00 00 00 00 00 03 00 00 00 01 01
    00000070: 00 00 dd 32 7e  rr=105

sum=80length change from 69 to 65

[35] 2013-11-21 22:56:11 looking for: 7e 6a 00 14 09 75 a6 25 80 00
[35] 2013-11-21 22:56:11 received:    7e 65 00 1b 09 75 a6 25 80 00 14 71 da 3a 
00 01 00 7e ff 03 60 65 13 90 78 00 cf 7f 39 39 00 00 8a 00 b0 f7 f8 7e 00 00 
00 00 00 00 01 80 01 02 00 00 00 00 00 00 00 00 00 00 00 03 00 00 00 ff 00 00 
e0 71 00 20 01 00 8a 00 b0 f7 f8 7e 00 00 0a 00 0c 00 00 00 00 00 00 00 03 00 
00 00 01 01 00 00 dd 32 7e

[35] 2013-11-21 22:56:11 Found string we are waiting for
[36] 2013-11-21 22:56:11 Extracting
togo=256
len=39 data=03 00 00 00 ff 00 00 e0 71 00 20 01 00 8a 00 b0 f7 f8 7e 00 00 0a 
00 0c 00 00 00 00 00 00 00 03 00 00 00 01 01 00 00
serial=00:7e:f8:f7
[38] 2013-11-21 22:56:11 Sending
[38] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[39] 2013-11-21 22:56:11 Waiting for string
[39] 2013-11-21 22:56:11 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[39] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 53 00 2d
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 01 00 7e ff
    00000020: 03 60 65 0e d0 78 00 cf 7f 39 39 00 01 8a 00 b0
    00000030: f7 f8 7d 5e 00 01 00 00 00 00 02 80 0d 04 fd ff
    00000040: 07 00 00 00 84 03 00 00 7a 81 8e 52 00 00 00 00
    00000050: b8 b8 b8 b8 88 88 88 88 88 88 88 88 d3 4d 7e  rr=83

sum=80length change from 53 to 51

[39] 2013-11-21 22:56:11 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[39] 2013-11-21 22:56:11 received:    7e 51 00 2f 09 75 a6 25 80 00 14 71 da 3a 
00 01 00 7e ff 03 60 65 0e d0 78 00 cf 7f 39 39 00 01 8a 00 b0 f7 f8 7e 00 01 
00 00 00 00 02 80 0d 04 fd ff 07 00 00 00 84 03 00 00 7a 81 8e 52 00 00 00 00 
b8 b8 b8 b8 88 88 88 88 88 88 88 88 d3 4d 7e

[39] 2013-11-21 22:56:11 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[39] 2013-11-21 22:56:11 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[39] 2013-11-21 22:56:11 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[39] 2013-11-21 22:56:11 Found string we are waiting for
[40] 2013-11-21 22:56:11 Extracting
bluetooth signal = 66%
[41] 2013-11-21 22:56:11 Sending
[41] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[42] 2013-11-21 22:56:11 Waiting for string
[42] 2013-11-21 22:56:11 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[42] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[42] 2013-11-21 22:56:11 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[42] 2013-11-21 22:56:11 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[42] 2013-11-21 22:56:11 Found string we are waiting for
[43] 2013-11-21 22:56:11 Sending
[43] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[44] 2013-11-21 22:56:11 Waiting for string
[44] 2013-11-21 22:56:11 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[44] 2013-11-21 22:56:11 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[44] 2013-11-21 22:56:11 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[44] 2013-11-21 22:56:11 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[44] 2013-11-21 22:56:11 Found string we are waiting for
[45] 2013-11-21 22:56:11 Sending
sum=7e
[45] 2013-11-21 22:56:11 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 5c 00 22
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 10 a0 ff ff ff ff ff ff 00 00 78 00 cf
    00000030: 7f 39 39 00 00 00 00 00 00 03 80 0a 02 00 f0 00
    00000040: 6d 23 00 00 6d 23 00 00 6d 23 00 7a 81 8e 52 7a
    00000050: 81 8e 52 7a 81 8e 52 7d 31 0e 00 00 30 fe 7d 5e
    00000060: 00 01 00 00 00 ed 97 7e  cc=92

[47] 2013-11-21 22:56:12 Sending
[47] 2013-11-21 22:56:12 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[48] 2013-11-21 22:56:12 Waiting for string
[48] 2013-11-21 22:56:12 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[48] 2013-11-21 22:56:12 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[48] 2013-11-21 22:56:12 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[48] 2013-11-21 22:56:12 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[48] 2013-11-21 22:56:12 Found string we are waiting for
[49] 2013-11-21 22:56:12 Extracting
bluetooth signal = 66%
[50] 2013-11-21 22:56:12 Sending
[50] 2013-11-21 22:56:12 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[51] 2013-11-21 22:56:12 Waiting for string
[51] 2013-11-21 22:56:12 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[51] 2013-11-21 22:56:12 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[51] 2013-11-21 22:56:12 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[51] 2013-11-21 22:56:12 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[51] 2013-11-21 22:56:12 Found string we are waiting for
[52] 2013-11-21 22:56:12 Sending
[52] 2013-11-21 22:56:12 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 14 00 6a
    00000010: 00 00 00 00 00 00 09 75 a6 25 80 00 03 00 05 00  cc=20

[53] 2013-11-21 22:56:12 Waiting for string
[53] 2013-11-21 22:56:12 waiting for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00

[53] 2013-11-21 22:56:12 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 18 00 66
    00000010: 09 75 a6 25 80 00 00 00 00 00 00 00 04 00 05 00
    00000020: 00 00 a9 00  rr=24

[53] 2013-11-21 22:56:12 looking for: 7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00
[53] 2013-11-21 22:56:12 received:    7e 18 00 66 09 75 a6 25 80 00 00 00 00 00 
00 00 04 00 05 00 00 00 a9 00

[53] 2013-11-21 22:56:12 Found string we are waiting for
[54] 2013-11-21 22:56:12 Sending
sum=80
  length change from 5b to 5a diff=80
new sum=7e
[54] 2013-11-21 22:56:12 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 5a 00 24
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 10 a0 ff ff ff ff ff ff 00 00 78 00 cf
    00000030: 7f 39 39 00 00 00 00 00 00 04 80 0a 02 00 f0 00
    00000040: 6d 23 00 00 6d 23 00 00 6d 23 00 7b 81 8e 52 79
    00000050: 81 8e 52 7b 81 8e 52 00 00 00 00 01 00 00 00 01
    00000060: 00 00 00 91 06 7e  cc=90

[55] 2013-11-21 22:56:12 Sending
sum=80
  length change from 3f to 3e diff=80
new sum=7e
[55] 2013-11-21 22:56:12 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 3e 00 40
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 09 a0 ff ff ff ff ff ff 00 00 78 00 cf
    00000030: 7f 39 39 00 00 00 00 00 00 05 80 00 02 00 58 00
    00000040: 1e 82 00 ff 21 82 00 91 15 7e  cc=62

[56] 2013-11-21 22:56:12 Sending
sum=80
  length change from 3f to 3e diff=80
new sum=7e
[56] 2013-11-21 22:56:12 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 3e 00 40
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 09 a0 ff ff ff ff ff ff 00 00 78 00 cf
    00000030: 7f 39 39 00 00 00 00 00 00 06 80 00 02 00 58 00
    00000040: 1e a2 00 ff 1e a2 00 95 fc 7e  cc=62

[57] 2013-11-21 22:56:12 Sending
sum=80
  length change from 3f to 3e diff=80
new sum=7e
[57] 2013-11-21 22:56:12 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 3e 00 40
    00000010: 14 71 da 7d 1a 00 ff ff ff ff ff ff 01 00 7e ff
    00000020: 03 60 65 09 a0 ff ff ff ff ff ff 00 00 78 00 cf
    00000030: 7f 39 39 00 00 00 00 00 00 07 80 00 02 80 51 00
    00000040: 48 21 00 ff 48 21 00 fd c2 7e  cc=62

[58] 2013-11-21 22:56:12 Waiting for string
[58] 2013-11-21 22:56:12 waiting for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65

[58] 2013-11-21 22:56:12 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 5d 00 23
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 01 00 7e ff
    00000020: 03 60 65 10 d0 78 00 cf 7f 39 39 00 a0 8a 00 b0
    00000030: f7 f8 7d 5e 00 00 00 00 00 00 10 8c 0a 02 00 f0
    00000040: 00 00 00 00 00 00 00 00 00 6d 23 00 7b 81 8e 52
    00000050: b6 6b 8e 52 7b 81 8e 52 7d 31 0e 00 00 30 fe 7d
    00000060: 5e 00 01 00 00 00 8c a2 7e  rr=93

sum=80length change from 5d to 59

[58] 2013-11-21 22:56:13 looking for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65
[58] 2013-11-21 22:56:13 received:    7e 59 00 27 09 75 a6 25 80 00 14 71 da 3a 
00 01 00 7e ff 03 60 65 10 d0 78 00 cf 7f 39 39 00 a0 8a 00 b0 f7 f8 7e 00 00 
00 00 00 00 10 8c 0a 02 00 f0 00 00 00 00 00 00 00 00 00 6d 23 00 7b 81 8e 52 
b6 6b 8e 52 7b 81 8e 52 11 0e 00 00 30 fe 7e 00 01 00 00 00 8c a2 7e

[58] 2013-11-21 22:56:13 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 6d 00 13
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 08 00 7e ff
    00000020: 03 60 65 45 90 78 00 cf 7f 39 39 00 a0 8a 00 b0
    00000030: f7 f8 7d 5e 00 00 00 00 00 00 05 80 01 02 00 58
    00000040: 00 00 00 00 05 00 00 00 01 1e 82 10 6e b6 8d 52
    00000050: 53 4e 3a 20 32 31 33 30 32 34 35 35 35 32 00 00
    00000060: 10 00 00 00 10 00 00 00 00 00 00 00 00 00 00 00
    00000070: 01 1f 82 08 6e b6 8d 52 41  rr=109

sum=80length change from 6d to 6b

[58] 2013-11-21 22:56:13 looking for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65
[58] 2013-11-21 22:56:13 received:    7e 6d 00 13 09 75 a6 25 80 00 14 71 da 3a 
00 08 00 7e ff 03 60 65 45 90 78 00 cf 7f 39 39 00 a0 8a 00 b0 f7 f8 7e 00 00 
00 00 00 00 05 80 01 02 00 58 00 00 00 00 05 00 00 00 01 1e 82 10 6e b6 8d 52 
53 4e 3a 20 32 31 33 30 32 34 35 35 35 32 00 00 10 00 00 00 10 00 00 00 00 00 
00 00 00 00 00 00 01 1f 82 08 6e b6 8d 52 41

[58] 2013-11-21 22:56:13 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 6d 00 13
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 08 00 1f 00
    00000020: 01 42 1f 00 00 fe ff ff 00 00 00 00 00 00 00 00
    00000030: 00 00 00 00 00 00 00 00 00 00 00 00 00 01 20 82
    00000040: 08 6e b6 8d 52 72 23 00 00 73 23 00 00 74 23 00
    00000050: 00 cd 23 00 01 d3 23 00 00 d4 23 00 00 d5 23 00
    00000060: 00 d6 23 00 00 01 20 82 08 6e b6 8d 52 fe ff ff
    00000070: 00 00 00 00 00 00 00 00 00  rr=109

sum=80length change from 6d to 6c

[58] 2013-11-21 22:56:13 looking for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65
[58] 2013-11-21 22:56:13 received:    7e 6d 00 13 09 75 a6 25 80 00 14 71 da 3a 
00 08 00 1f 00 01 42 1f 00 00 fe ff ff 00 00 00 00 00 00 00 00 00 00 00 00 00 
00 00 00 00 00 00 00 00 01 20 82 08 6e b6 8d 52 72 23 00 00 73 23 00 00 74 23 
00 00 cd 23 00 01 d3 23 00 00 d4 23 00 00 d5 23 00 00 d6 23 00 00 01 20 82 08 
6e b6 8d 52 fe ff ff 00 00 00 00 00 00 00 00 00

[58] 2013-11-21 22:56:13 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 6d 00 13
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 08 00 00 00
    00000020: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
    00000030: 00 00 01 21 82 08 8b 82 79 47 59 02 00 01 5b 02
    00000040: 00 01 5d 02 00 01 5e 02 00 01 5f 02 00 00 6a 02
    00000050: 00 01 78 02 00 01 79 02 00 01 01 21 82 08 8b 82
    00000060: 79 47 7a 02 00 01 7b 02 00 01 7c 02 00 00 7d 5d
    00000070: 02 00 01 87 02 00 01 88 02  rr=109

sum=80length change from 6d to 6b

[58] 2013-11-21 22:56:13 looking for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65
[58] 2013-11-21 22:56:13 received:    7e 6d 00 13 09 75 a6 25 80 00 14 71 da 3a 
00 08 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 21 82 
08 8b 82 79 47 59 02 00 01 5b 02 00 01 5d 02 00 01 5e 02 00 01 5f 02 00 00 6a 
02 00 01 78 02 00 01 79 02 00 01 01 21 82 08 8b 82 79 47 7a 02 00 01 7b 02 00 
01 7c 02 00 00 7d 02 00 01 87 02 00 01 88 02

[58] 2013-11-21 22:56:13 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1f 00 61
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 01 00 00 01
    00000020: fe ff ff 00 00 00 00 00 9f 19 7e  rr=31

sum=80length change from 1f to 1e

[58] 2013-11-21 22:56:13 looking for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65
[58] 2013-11-21 22:56:13 received:    7e 1e 00 62 09 75 a6 25 80 00 14 71 da 3a 
00 01 00 00 01 fe ff ff 00 00 00 00 00 9f 19 7e

[58] 2013-11-21 22:56:13 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 6a 00 14
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 01 00 7e ff
    00000020: 03 60 65 7d 33 90 78 00 cf 7f 39 39 00 a0 8a 00
    00000030: b0 f7 f8 7d 5e 00 00 00 00 00 00 06 80 01 02 00
    00000040: 58 1f 00 00 00 1f 00 00 00 01 1e a2 00 6e b6 8d
    00000050: 52 00 00 00 00 00 00 00 00 fe ff ff ff fe ff ff
    00000060: ff b0 f7 f8 7d 5e b0 f7 f8 7d 5e 00 00 00 00 00
    00000070: 00 00 00 e2 16 7e  rr=106

sum=7elength change from 6a to 65

[58] 2013-11-21 22:56:13 looking for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65
[58] 2013-11-21 22:56:13 received:    7e 6a 00 14 09 75 a6 25 80 00 14 71 da 3a 
00 01 00 7e ff 03 60 65 13 90 78 00 cf 7f 39 39 00 a0 8a 00 b0 f7 f8 7e 00 00 
00 00 00 00 06 80 01 02 00 58 1f 00 00 00 1f 00 00 00 01 1e a2 00 6e b6 8d 52 
00 00 00 00 00 00 00 00 fe ff ff ff fe ff ff ff b0 f7 f8 7e b0 f7 f8 7e 00 00 
00 00 00 00 00 00 e2 16 7e

[58] 2013-11-21 22:56:13 Did not find string

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 68 00 16
    00000010: 09 75 a6 25 80 00 14 71 da 7d 1a 00 01 00 7e ff
    00000020: 03 60 65 7d 33 90 78 00 cf 7f 39 39 00 a0 8a 00
    00000030: b0 f7 f8 7d 5e 00 00 00 00 00 00 07 80 01 02 80
    00000040: 51 00 00 00 00 00 00 00 00 01 48 21 08 76 81 8e
    00000050: 52 23 00 00 00 2f 01 00 00 33 01 00 01 c7 01 00
    00000060: 00 fe ff ff 00 00 00 00 00 00 00 00 00 00 00 00
    00000070: 00 fa db 7e  rr=104

sum=7elength change from 68 to 65

[58] 2013-11-21 22:56:13 looking for: 7e 5a 00 24 09 75 a6 25 80 00 14 71 da 7d 
1a 00 01 00 7e ff 03 60 65
[58] 2013-11-21 22:56:13 received:    7e 65 00 19 09 75 a6 25 80 00 14 71 da 3a 
00 01 00 7e ff 03 60 65 13 90 78 00 cf 7f 39 39 00 a0 8a 00 b0 f7 f8 7e 00 00 
00 00 00 00 07 80 01 02 80 51 00 00 00 00 00 00 00 00 01 48 21 08 76 81 8e 52 
23 00 00 00 2f 01 00 00 33 01 00 01 c7 01 00 00 fe ff ff 00 00 00 00 00 00 00 
00 00 00 00 00 00 fa db 7e

[58] 2013-11-21 22:56:13 Did not find string

Original issue reported on code.google.com by goo...@dennisvandenbos.nl on 21 Nov 2013 at 10:04

Attachments:

johnthomas22 commented 9 years ago

Did you get anywhere with this?

Regards, JAYT

johnthomas22 commented 9 years ago

I fixed my problem by logging on to MySQL:

mysql -h localhost -u root -pPASSWORD smatool

USE SMATOOL;

Repair table DayData;