nebgor / sma-bluetooth Goto Github PK

What steps will reproduce the problem?
1. execute ./smatool (arguments don't matter)
2.
3.

What is the expected output? What do you see instead?
All data (graph completely blank) is cleared on the display of the sunnyboy 
4000. After +/- 5min the data is visible again. Some users say there is a peak 
in the graph in sunny explorer

What version of the product are you using? On what operating system?
0.11test on ubuntu 10.04

Please provide any additional information below.
3 users have this problem - all having same config (smatool 0.11 ubuntu - 
SB4000-TL - Firmware 3.01)

I have attached the USB sniff results from my SB3000 HF30 and would be grateful 
for some detail on where to identify the inverter code and archive code values 
to provide support for this device. (first file XML output, 2nd SnoopyPro 
format).

Many thanks in advance for help -

Simon

The communication with SB2500 is not working fine as the format does not seem 
to be correct (also for SB1700)

[18] 2011-07-19 20:39:03 Waiting for string
[18] 2011-07-19 20:39:03 waiting for: 7e 1f 00 61 05 7e 1b 25 80 00 00 00 00 00 
00 00 02 00 00 04 70 00

[18] 2011-07-19 20:39:03 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1f 00 61
    00000010: 05 7e 1b 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] 2011-07-19 20:39:03 looking for: 7e 1f 00 61 05 7e 1b 25 80 00 00 00 00 00 
00 00 02 00 00 04 70 00
[18] 2011-07-19 20:39:03 received:    7e 1f 00 61 05 7e 1b 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] 2011-07-19 20:39:03 Found string we are waiting for
[19] 2011-07-19 20:39:03 Extracting
extracting invcode=01
[20] 2011-07-19 20:39:03 Sending
[20] 2011-07-19 20:39:03 sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1f 00 61
    00000010: 00 00 00 00 00 00 05 7e 1b 25 80 00 02 00 00 04
    00000020: 70 00 01 00 00 00 00 01 00 00 00  cc=31

[21] 2011-07-19 20:39:03 Waiting for string
[21] 2011-07-19 20:39:03 waiting for: 7e 22 00 5c 05 7e 1b 25 80 00 00 00 00 00 
00 00 05 00 05 7e 1b 25 80 00

[21] 2011-07-19 20:39:03 Waiting for data on rfcomm

Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1f 00 61
    00000010: 05 7e 1b 25 80 00 00 00 00 00 00 00 0a 00 05 7e
    00000020: 1b 25 80 00 01 2d 8d 00 7d 1a 00  rr=31

sum=80length change from 1f to 1e


[21] 2011-07-19 20:39:03 looking for: 7e 22 00 5c 05 7e 1b 25 80 00 00 00 00 00 
00 00 05 00 05 7e 1b 25 80 00
[21] 2011-07-19 20:39:03 received:    7e 1e 00 62 05 7e 1b 25 80 00 00 00 00 00 
00 00 0a 00 05 7e 1b 25 80 00 01 2d 8d 00 3a 00

[21] 2011-07-19 20:39:03 Did not find string

How can I solve this?
Thanks

root@hp-gerb:/home/gerbenr/sma-bluetooth# ./smatool -v -from "2011-02-20 
00:00:00" -to "2011-02-20 23:30:00"
QUERY RANGE    from 2011-02-20 00:00:00 to 2011-02-20 23:30:00
Address 00:80:25:0b:0f:28
bluetooth signal = 69%
serial=77:50:1f:9b
bluetooth signal = 69%
bluetooth signal = 69%
2011-02-21 14:51:56 Unit Serial          = 3821139 none                
2011-02-21 14:51:56 NO DATA for 1f 82 = 8001 NO UNITS
2011-02-21 14:51:56 NO DATA for 20 82 = 9022 NO UNITS
2011-02-21 14:51:56 NO DATA for 21 82 = 601 NO UNITS
2011-02-21 14:51:56 NO DATA for 21 82 = 636 NO UNITS
2011-02-21 14:51:56 Total Power          = 1383 Watts               
2011-02-21 14:51:56 Max Phase 1          = 2150 Watts               
2011-02-21 14:51:56 Max Phase 2          = 2150 Watts               
2011-02-21 14:51:56 Max Pahse 3          = 2150 Watts               
2011-02-21 14:51:56 Line Voltage Phase 1Volts = 241 Volts               
2011-02-21 14:51:56 Line Current Phase 1Amps = 6 Amps                
2011-02-21 14:51:56 Grid Frequency       = 50 Hertz               
2011-02-21 14:51:56 NO DATA for 1f 4a = 100 NO UNITS
bluetooth signal = 69%


28/4/1974 17:34:09  total=72058914471936.000 Kwh current=0 Watts togo=0 i=11 
crc=0
14/7/1970 05:20:14  total=72057589071872.000 Kwh current=-15977278341120 Watts 
togo=0 i=23 crc=0Date Error! prev=136398849 current=16777214

Can I do anything to help get my SB 2100TL supported? 

thanks for the work anyway, it seems that I at least can view my current power: 
In this case 1383 W . 

What steps will reproduce the problem?
1. ./smatool -v -from "2011-06-29 00:00:00" -to "2011-06-29 23:55:00" 

What is the expected output? What do you see instead?
I would expect it to behave as stated in the wiki. Instead i get this:

QUERY RANGE    from 2011-06-29 00:00:00 to 2011-06-29 23:55:00
Address 00:80:25:1C:43:90
bluetooth signal = 72%
sending password XXXXXserial=00:7d:32:51
bluetooth signal = 72%
bluetooth signal = 72%
Timeout reading bluetooth socket
bluetooth signal = 72%
sending password XXXXXserial=00:7d:32:51
bluetooth signal = 72%
bluetooth signal = 72%
Timeout reading bluetooth socket
bluetooth signal = 72%
sending password XXXXXserial=00:7d:32:51
bluetooth signal = 72%
bluetooth signal = 72%
Timeout reading bluetooth socket
bluetooth signal = 73%
sending password XXXXXserial=00:7d:32:51
bluetooth signal = 73%
bluetooth signal = 73%
Timeout reading bluetooth socket

after 4 of these timeout messages it quits

What version of the product are you using? On what operating system?
0.13
Debian Squeeze
Linux yoda 2.6.32-5-xen-686 #1 SMP Wed Mar 9 01:27:54 UTC 2011 i686 GNU/Linux

Please provide any additional information below.
i 've seen this problem quite a few times already on this forum... and
people always respond to this with "make sure the password is
correct"... well, i've typed the password on the same machine, same
keyboard settings
* in sunny explorer -> works ok to log in.
* In putty session to debian box typed in in config file -> doesnt
seem to work

so i guess it's not really the password but some other thing. Maybe
the SBx000TL-20 send password encoded differntly than before?
dunno.... need to do some sniffing with the windows laptop, but only
have one BT dongle, and it's currently in the debian box (which i need
to get on a chair and move a bunch of garbage to have access to ;/ )

see debug output (trunctated after first cycle, and modified the
password)

It seems that after sending the password [33], the SB replies with the
serial [35] or do i see that incorrectly?
After receiving the serial, it sends something, and then it receives
the BT signal strength...

After that, it seems to receive a whole host of data that it doens't
recognize... the data it expects seems to be a lot shorter than what
it receives (e.g. length 5a expected vs length 6d received)

until it stops receiving (i guess) and "times out" and then retries...

What steps will reproduce the problem?
1. wrong password given on commandline or in smatool.conf file

What is the expected output?
Valid data

What do you see instead?
with verbose output you see several times
bluetooth signal = 70%


What version of the product are you using? On what operating system?
0.11test on ubuntu 10.04
inverter is 4000TL

Please provide any additional information below.
I propose to add some code in data extraction part of $TIMESTRING (case 12)
See code below (my changes are suffixed with //*VDJ*)

                case 12: // extract time strings $TIMESTRING
                                if (debug == 1) printf("received[60]=0x%0X - Expected 0x6D\n", received[60]);   //*VDJ*
                                if (debug == 1) printf("received[61]=0x%0X - Expected 0x23\n", received[61]);   //*VDJ*
                                if(( received[60] == 0x6d )&&( received[61] == 0x23 ))
                                {
                    memcpy(timestr,received+63,24);
                    if (debug == 1) printf("extracting timestring\n");
                                    memcpy(timeset,received+79,4);
                                    idate=ConvertStreamtoTime( received+63,4, &idate );
                                    /* Allow delay for inverter to be slow */
                                    if( reporttime > idate ) {
                                       if( debug == 1 )
                                           printf( "delay=%d\n", (int)(reporttime-idate) );
                                       sleep( reporttime - idate );
                                    }
                                }
                                else
                                {
                    if (received[61]==0x7e) {                               //*VDJ*
                    printf("$TIMESTRING extraction failed. Check password!!!\n");           //*VDJ*
                        exit(-1);                                   //*VDJ*
                    }                                           //*VDJ*
                    memcpy(timestr,received+63,24);
                    if (debug == 1) printf("bad extracting timestring\n");
                                    already_read=0;
                                    fseek( fp, returnpos, 0 );
                                    linenum = returnline;
                                    found=0;
                                    if( archdatalen > 0 )
                                       free( archdatalist );
                                    archdatalen=0;
                                    strcpy( lineread, "" );
                                    failedbluetooth++;
                                    if( failedbluetooth > 10 )
                                        exit(-1);
                                    goto start;
                                    //exit(-1);
                                }

                break;

Attached file is the sniff result of the SunnyBoy 1700 Inverter (not the 
1700TL).

I would be greatfull to be able to log data from the inverter using the 
sma-bluetooth.

System only works for SMA3000TL

Here is the log from my sniff.
I hope you'll find why I can't run sma-bluetooth with my inverter.

My inverter is a way from the main house and not the greatest of signals (67%) 
at 5 seconds it was timing out all the time - changed it to 10 seconds and 
things worked fine - might be worth putting something in for an increasing 
timeout? say two timeouts with no data - change timeout to 10 secs ?


Cheers

What steps will reproduce the problem?
1. Run smatool without sma.in.new in the correct directory as specified in 
smatool.conf

What is the expected output?
Program should test to make sure that the file is there, as it is not it should 
print out error and then exit gracefully.

What do you see instead?
Segmentation Fault.  Looked at the source code and using GDB saw that the code 
is crashing on the call to feof(fp) in InitReturnKeys() because fp will be null 
as expected.

What version of the product are you using? On what operating system?
Ubuntu 10.10, using v0.13

Please provide any additional information below.
Not a major problem, just good to have it fixed when possible.  Although could 
put off users, took me a while to figure it out.  I was trying to set it up as 
a cron job and this is when the problem started.

* What steps will reproduce the problem?
1. Running the smatool from cron job (every 15 mins)

* What do you see instead?
Everything worked fine for around 12 runs (from 7:30 - 10:30), then smatool 
started failing.  It was failing with "Too many connections" error.  I guessed 
that the error message was a MySQL error and coming from MySQL server, so I 
restarted MySQL and then smatool started working again.

* What version of the product are you using? On what operating system?
V0.13, Ubuntu 10.10

* Please provide any additional information below.
Is it possible that smatool is leaving connections open on MySQL?  This is the 
first day that I have tried smatool on a cron job.  Will keep an eye on it to 
see if it fails again.  It is possible that something else on my system is 
leaving connection open on MySQL but I haven't noticed this problem until today 
(when I started running smatool regularly).

There is a small change to smatool.conf.new necessary. The line

PVOutputURL   http://pvoutput.org/service/r1/addstatus.jsp
                                          ^^

should be changed to 

PVOutputURL   http://pvoutput.org/service/r2/addstatus.jsp
                                          ^^

regards,
HS

What steps will reproduce the problem?
1. I have two inverters: SB5000TL and SB2500HF3. 
2 create configuration files as in the attachments to this report. The 
SB2500HF30 is modeled as a 3000TLHF

3. call ./smatool -v -c SMA5000TL.conf
4. call ./smatool -c SMA2500HF30.conf

What is the expected output? What do you see instead?
Expected output is both inverters returning list of data with five minutes 
intervals. In many cases, this is also what is happening.
In some (between one in ten and one in five, I didn't do the statistics yet), 
the second call to the SB2500HF30 fails with

28/4/1974 17:34:09  total=151645896.704 Kwh current=0 Watts togo=0 i=11 
crc=-1216579361
1/1/1970 01:05:03  total=1954226896.896 Kwh current=21630972002304 Watts togo=0 
i=23 crc=-1216579361Date Error! prev=136398849 current=303

What version of the product are you using? On what operating system?
smatool-0.14
Gentoo linux 2.6.39-gentoo-r3

Please provide any additional information below.
The tool is running without mysql running yet.

In attachment: SMA5000TL.conf
In attachment: SMA2500HF30.conf
In attachment: output of ./smatool -v -d -c SMA2500HF30.conf

What steps will reproduce the problem?
1. ./smatool -d
2.  ./smatool -v -from "2011-04-28 00:00:00" -to "2011-04-30 23:55:00"
3.

What is the expected output? What do you see instead?
When using -d
7e 5c 00
Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 5c 00 22
    00000010: 88 92 17 25 80 00 22 16 12 83 15 00 01 00 7e ff
    00000020: 03 60 65 10 d0 78 00 3f 10 fb 39 00 a0 4e 00 1a
    00000030: c1 30 7d 5d 00 00 00 00 00 00 50 ad 0a 02 00 f0
    00000040: 00 00 00 00 00 00 00 00 00 6d 23 00 02 e0 bf 4d
    00000050: 56 66 b9 4d 02 e0 bf 4d 80 70 00 00 31 fe 7d 5e
    00000060: 00 01 00 00 00 66 78 7e  rr=92

22 88 92 17 25 80 00 22 16 12 83 15 00 01 00 7e ff 03 60 65 10 d0 78 00 3f 10 
fb 39 00 a0 4e 00 1a c1 30 7d 00 00 00 00 00 00 50 ad 0a 02 00 f0 00 00 00 00 
00 00 00 00 00 6d 23 00 02 e0 bf 4d 56 66 b9 4d 02 e0 bf 4d 80 70 00 00 31 fe 
7e 00 01 00 00 00 66 78 7e sum=7elength change from 5c to 5a

7e 5a 00 24 88 92 17 25 80 00 22 16 12 83 15 00 01 00 7e ff 03 60 65 10 d0 78 
00 3f 10 fb 39 00 a0 4e 00 1a c1 30 7d 00 00 00 00 00 00 50 ad 0a 02 00 f0 00 
00 00 00 00 00 00 00 00 6d 23 00 02 e0 bf 4d 56 66 b9 4d 02 e0 bf 4d 80 70 00 
00 31 fe 7e 00 01 00 00 00 66 78 7e

  [42] looking for: 7e 5a 00 24 88 92 17 25 80 00 22 16 12 83 15 00 01 00 7e ff 03 60 65
  [42] received:    7e 5a 00 24 88 92 17 25 80 00 22 16 12 83 15 00 01 00 7e ff 03 60 65 10 d0 78 00 3f 10 fb 39 00 a0 4e 00 1a c1 30 7d 00 00 00 00 00 00 50 ad 0a 02 00 f0 00 00 00 00 00 00 00 00 00 6d 23 00 02 e0 bf 4d 56 66 b9 4d 02 e0 bf 4d 80 70 00 00 31 fe 7e 00 01 00 00 00 66 78 7e

[42] Found string we are waiting for
7e 5a 00 24 88 92 17 25 80 00 22 16 12 83 15 00 01 00 7e ff 03 60 65

[43] Extracting
extracting timestring
delay=115

When using -v
QUERY RANGE    from 2011-04-28 00:00:00 to 2011-04-30 23:55:00
Address 00:80:25:17:92:88
Timeout reading bluetooth socket
Timeout reading bluetooth socket
bluetooth signal = 65%
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
serial=7d:30:c1:1a
Timeout reading bluetooth socket
bluetooth signal = 65%
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
bluetooth signal = 65%
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket
Timeout reading bluetooth socket


What version of the product are you using? On what operating system?
both 0.11 and 0.09 on ubuntu 10.04 headless server.

Please provide any additional information below.
Not sure what other information to provide. I have a ritmo CB715 bluetooth 
dongle that was recommended by whirlpool forum

Products such as the SB4000TL, SB5000TL, STP10000TL have multiple MPP trackers 
and/or multiple strings.

For analytical purposes (e.g. performance statistics when using shadow 
management), it would be very nice if MPPT's and/or string data could be 
separately logged.

- SMA Sunny Explorer shows the data, but does not log it ;
- SolarLog logs the different MPTT's/strings.

(Of course, I am willing to provide debug data, as soon as the BT sniffing wiki 
page has been extended.  :) )

nekobasu:/usr/local/src/sma-bluetooth# ./smatool
Error connecting to 00:80:25:09:E0:06
Error connecting to 00:80:25:09:E0:06
Error connecting to 00:80:25:09:E0:06
Error connecting to 00:80:25:09:E0:06

it probably should check the sunrise first to see if it is worth trying to 
connect

Also should it closeout or stay running? My thought is that it should stay 
running - that way I can do smatool & and have it collect data/update pvoutput 
quietly in the background without me worrying about it..

What steps will reproduce the problem?
1. ./smatool -from "2011-05-31 00:00:00" -to "2011-05-31 23:55:00"

What is the expected output? 
I expect to see the correct data being output on screen, somewhere between 
10-25 KWs per day.

What do you see instead?
2011-07-09 15:56:08 NO DATA for 6d 23 = 15041043 NO UNITS
2011-07-09 15:56:08 NO DATA for 6d 23 = 15041043 NO UNITS
1970-01-01 08:00:00 NO DATA for 09 18 = 12105912 NO UNITS


9/7/2011 15:55:52  total=13310592108344640.000 Kwh current=0 Watts togo=0 i=11 
crc=0


What version of the product are you using? On what operating system?
0.13, Ubuntu 11.04

Please provide any additional information below.
Attached debug output.

What steps will reproduce the problem?
1. Running the program with lat/long set

What is the expected output? What do you see instead?
I expect the Almanac table in MySQL to be populated correctly.  Instead it's 
setting the sunrise time to be '0000-00-00 00:00:00'.

What version of the product are you using? On what operating system?
0.14 on Fedora 15

Please provide any additional information below.
This can be *fixed* quite easily.  It's a mistake in the second-last line of 
the "sunrise" function.  The brackets are in the wrong place - the line should 
read as follows:

sprintf( returntime, 
"%02.0f:%02.0f",floor(localT),floor((localT-floor(localT))*60));

Without that change, the minutes value is meaning less and MySQL just sticks a 
zero in instead.

in the repost routine the dtotal and etotal today are scaled by 1000 which 
results in an error from pvoutput. both should remain as queried.

./smatool -d -from "2011-01-01 00:00:00" -to "2011-01-12 23:55:00"

it updated the mysql, but didn't run the pvouput post routine... 

Added "    //lets check what the flags are..
    if (debug == 1) printf("post=%d, mysql=%d, error=%d\n",post,mysql,error:wq!);"
 to line 1995 and got..

post=1, mysql=1, error=0
SELECT EtotalToday FROM DayData WHERE DateTime=DATE_FORMAT( NOW(), 
"%Y%m%d000000" ) 

I'm guessing that right now it doesn't post the results it finds, only today's 
result?

SB5000TL

Giving following issue:

[16] Sending
String to calculate FCS
ff 03 60 65 08 a0 ff ff ff ff ff ff 00 03 78 00 3f 10 fb 39 00 03 00 00 00 00 
00 80 0e 01 fd ff ff ff ff ff 

sum=80
  length change from 3b to 3a 
  [16] sending:
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 3a 00 44 
    00000010: 8d 88 43 83 15 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 3f 
    00000030: 10 fb 39 00 03 00 00 00 00 00 80 0e 01 fd ff ff 
    00000040: ff ff ff 4f b8 7e  cc=58

[17] Sending
String to calculate FCS
ff 03 60 65 0e a0 ff ff ff ff ff ff 00 01 78 00 3f 10 fb 39 00 01 00 00 00 00 
02 80 0c 04 fd ff 07 00 00 00 84 03 00 00 8a fa 2d 4d 00 00 00 00 b8 b8 b8 b8 
88 88 88 88 88 88 88 88 

sum=7e
  length change from 54 to 52 
NO CONVERSION!

What steps will reproduce the problem?
1. run smatool -v on my Ubuntu 10.

What is the expected output? What do you see instead?
I expect to upload data to PVOutput.org.  Once there's more than 10-something 
lines of data to process, I get this :

20/8/2011 21:35:00  total=156.771 Kwh current=0 Watts togo=0 i=11 crc=3
20/8/2011 21:40:00  total=156.771 Kwh current=0 Watts togo=0 i=23 crc=3
*** stack smashing detected ***: ./smatool terminated
======= Backtrace: =========
/lib/libc.so.6(__fortify_fail+0x50)[0xb75a8970]
/lib/libc.so.6(+0xe591a)[0xb75a891a]
./smatool[0x8052805]
[0x62623635]
======= Memory map: ========
08048000-08055000 r-xp 00000000 08:05 793221     
/local/Downloads/sma/sma-bluetooth/smatool
08055000-08056000 r--p 0000d000 08:05 793221     
/local/Downloads/sma/sma-bluetooth/smatool
08056000-08057000 rw-p 0000e000 08:05 793221     
/local/Downloads/sma/sma-bluetooth/smatool
09355000-09398000 rw-p 00000000 00:00 0          [heap]
b6f24000-b6f3e000 r-xp 00000000 08:02 2965       /lib/libgcc_s.so.1
b6f3e000-b6f3f000 r--p 00019000 08:02 2965       /lib/libgcc_s.so.1
b6f3f000-b6f40000 rw-p 0001a000 08:02 2965       /lib/libgcc_s.so.1
b6f40000-b6f44000 r-xp 00000000 08:02 13558      /lib/libnss_dns-2.12.1.so
b6f44000-b6f45000 r--p 00004000 08:02 13558      /lib/libnss_dns-2.12.1.so
b6f45000-b6f46000 rw-p 00005000 08:02 13558      /lib/libnss_dns-2.12.1.so
b6f5c000-b6f91000 r--s 00000000 08:02 268774     /var/cache/nscd/services
b6f91000-b6f94000 rw-p 00000000 00:00 0 
b6f94000-b6f97000 r-xp 00000000 08:02 48114      /lib/libgpg-error.so.0.4.0
b6f97000-b6f98000 r--p 00002000 08:02 48114      /lib/libgpg-error.so.0.4.0
b6f98000-b6f99000 rw-p 00003000 08:02 48114      /lib/libgpg-error.so.0.4.0
b6f99000-b700a000 r-xp 00000000 08:02 34594      /lib/libgcrypt.so.11.5.3
b700a000-b700b000 r--p 00070000 08:02 34594      /lib/libgcrypt.so.11.5.3
b700b000-b700d000 rw-p 00071000 08:02 34594      /lib/libgcrypt.so.11.5.3
b700d000-b701c000 r-xp 00000000 08:02 35545      /usr/lib/libtasn1.so.3.1.9
b701c000-b701d000 r--p 0000e000 08:02 35545      /usr/lib/libtasn1.so.3.1.9
b701d000-b701e000 rw-p 0000f000 08:02 35545      /usr/lib/libtasn1.so.3.1.9
b701e000-b7020000 r-xp 00000000 08:02 1502       /lib/libkeyutils.so.1.3
b7020000-b7021000 r--p 00001000 08:02 1502       /lib/libkeyutils.so.1.3
b7021000-b7022000 rw-p 00002000 08:02 1502       /lib/libkeyutils.so.1.3
b7022000-b7024000 r-xp 00000000 08:02 10528      /lib/libdl-2.12.1.so
b7024000-b7025000 r--p 00001000 08:02 10528      /lib/libdl-2.12.1.so
b7025000-b7026000 rw-p 00002000 08:02 10528      /lib/libdl-2.12.1.so
b7026000-b7027000 rw-p 00000000 00:00 0 
b7027000-b702d000 r-xp 00000000 08:02 22331      /usr/lib/libkrb5support.so.0.1
b702d000-b702e000 r--p 00005000 08:02 22331      /usr/lib/libkrb5support.so.0.1
b702e000-b702f000 rw-p 00006000 08:02 22331      /usr/lib/libkrb5support.so.0.1
b702f000-b7031000 r-xp 00000000 08:02 61236      /lib/libcom_err.so.2.1
b7031000-b7032000 r--p 00001000 08:02 61236      /lib/libcom_err.so.2.1
b7032000-b7033000 rw-p 00002000 08:02 61236      /lib/libcom_err.so.2.1
b7033000-b7054000 r-xp 00000000 08:02 62265      /usr/lib/libk5crypto.so.3.1
b7054000-b7055000 ---p 00021000 08:02 62265      /usr/lib/libk5crypto.so.3.1
b7055000-b7056000 r--p 00021000 08:02 62265      /usr/lib/libk5crypto.so.3.1
b7056000-b7057000 rw-p 00022000 08:02 62265      /usr/lib/libk5crypto.so.3.1
b7057000-b7100000 r-xp 00000000 08:02 63139      /usr/lib/libkrb5.so.3.3
b7100000-b7105000 r--p 000a9000 08:02 63139      /usr/lib/libkrb5.so.3.3
b7105000-b7106000 rw-p 000ae000 08:02 63139      /usr/lib/libkrb5.so.3.3
b7106000-b719c000 r-xp 00000000 08:02 35554      /usr/lib/libgnutls.so.26.14.12
b719c000-b71a0000 r--p 00095000 08:02 35554      /usr/lib/libgnutls.so.26.14.12
b71a0000-b71a1000 rw-p 00099000 08:02 35554      /usr/lib/libgnutls.so.26.14.12
b71a1000-b71a2000 rw-p 00000000 00:00 0 
b71a2000-b71b8000 r-xp 00000000 08:02 28383      /usr/lib/libsasl2.so.2.0.23
b71b8000-b71b9000 r--p 00015000 08:02 28383      /usr/lib/libsasl2.so.2.0.23
b71b9000-b71ba000 rw-p 00016000 08:02 28383      /usr/lib/libsasl2.so.2.0.23
b71ba000-b71ca000 r-xp 00000000 08:02 23023      /lib/libresolv-2.12.1.so
b71ca000-b71cb000 r--p 00010000 08:02 23023      /lib/libresolv-2.12.1.so
b71cb000-b71cc000 rw-p 00011000 08:02 23023      /lib/libresolv-2.12.1.so
b71cc000-b71ce000 rw-p 00000000 00:00 0 
b71ce000-b71e1000 r-xp 00000000 08:02 10547      /lib/libnsl-2.12.1.so
b71e1000-b71e2000 r--p 00012000 08:02 10547      /lib/libnsl-2.12.1.so
b71e2000-b71e3000 rw-p 00013000 08:02 10547      /lib/libnsl-2.12.1.so
b71e3000-b71e5000 rw-p 00000000 00:00 0 
b71e5000-b71ee000 r-xp 00000000 08:02 10526      /lib/libcrypt-2.12.1.so
b71ee000-b71ef000 r--p 00008000 08:02 10526      /lib/libcrypt-2.12.1.so
b71ef000-b71f0000 rw-p 00009000 08:02 10526      /lib/libcrypt-2.12.1.so
b71f0000-b7217000 rw-p 00000000 00:00 0 
b7217000-b722c000 r-xp 00000000 08:02 23019      /lib/libpthread-2.12.1.so
b722c000-b722d000 ---p 00015000 08:02 23019      /lib/libpthread-2.12.1.so
b722d000-b722e000 r--p 00015000 08:02 23019      /lib/libpthread-2.12.1.so
b722e000-b722f000 rw-p 00016000 08:02 23019      /lib/libpthread-2.12.1.so
b722f000-b7232000 rw-p 00000000 00:00 0 
b7232000-b7245000 r-xp 00000000 08:02 22188      /lib/libz.so.1.2.3.4
b7245000-b7246000 r--p 00012000 08:02 22188      /lib/libz.so.1.2.3.4
b7246000-b7247000 rw-p 00013000 08:02 22188      /lib/libz.so.1.2.3.4
b7247000-b737c000 r-xp 00000000 08:02 14274      /lib/libcrypto.so.0.9.8
b737c000-b7384000 r--p 00134000 08:02 14274      /lib/libcrypto.so.0.9.8
b7384000-b7393000 rw-p 0013c000 08:02 14274      /lib/libcrypto.so.0.9.8
b7393000-b7396000 rw-p 00000000 00:00 0 
b7396000-b73da000 r-xp 00000000 08:02 14280      /lib/libssl.so.0.9.8
b73da000-b73db000 ---p 00044000 08:02 14280      /lib/libssl.so.0.9.8
b73db000-b73dc000 r--p 00044000 08:02 14280      /lib/libssl.so.0.9.8
b73dc000-b73df000 rw-p 00045000 08:02 14280      /lib/libssl.so.0.9.8
b73df000-b740c000 r-xp 00000000 08:02 63073      /usr/lib/libgssapi_krb5.so.2.2
b740c000-b740d000 r--p 0002c000 08:02 63073      /usr/lib/libgssapi_krb5.so.2.2
b740d000-b740e000 rw-p 0002d000 08:02 63073      /usr/lib/libgssapi_krb5.so.2.2
b740e000-b7415000 r-xp 00000000 08:02 23024      /lib/librt-2.12.1.so
b7415000-b7416000 r--p 00006000 08:02 23024      /lib/librt-2.12.1.so
b7416000-b7417000 rw-p 00007000 08:02 23024      /lib/librt-2.12.1.so
b7417000-b7459000 r-xp 00000000 08:02 11518      /usr/lib/libldap_r-2.4.so.2.5.6
b7459000-b745a000 ---p 00042000 08:02 11518      /usr/lib/libldap_r-2.4.so.2.5.6
b745a000-b745b000 r--p 00042000 08:02 11518      /usr/lib/libldap_r-2.4.so.2.5.6
b745b000-b745c000 rw-p 00043000 08:02 11518      /usr/lib/libldap_r-2.4.so.2.5.6
b745c000-b745e000 rw-p 00000000 00:00 0 
b745e000-b7469000 r-xp 00000000 08:02 11517      /usr/lib/liblber-2.4.so.2.5.6
b7469000-b746a000 r--p 0000a000 08:02 11517      /usr/lib/liblber-2.4.so.2.5.6
b746a000-b746b000 rw-p 0000b000 08:02 11517      /usr/lib/liblber-2.4.so.2.5.6
b746b000-b749b000 r-xp 00000000 08:02 32957      
/usr/lib/libidn.so.11.6.1Aborted

What version of the product are you using? On what operating system?
Latest version of smatool on Ubuntu 10.10

Please provide any additional information below.

What steps will reproduce the problem?
Any time I run 'smatool'

What is the expected output? What do you see instead?
I expect to see my live data updated on pvoutput.  Nothing is sent.  The data 
does appear in the local database though.

What version of the product are you using? On what operating system?
0.14 on Fedora 12

Please provide any additional information below.

I get the following data in mysql:
mysql> select * from DayData;
+---------------------+----------+------------+--------------+-------------+----
------+---------------------+
| DateTime            | Inverter | Serial     | CurrentPower | ETotalToday | 
PVOutput | CHANGETIME          |
+---------------------+----------+------------+--------------+-------------+----
------+---------------------+
| 2011-09-29 14:15:00 | 3300     | 2001823863 |          768 |       0.126 | 
NULL     | 0000-00-00 00:00:00 |
| 2011-09-29 14:20:00 | 3300     | 2001823863 |         1476 |       0.249 | 
NULL     | 0000-00-00 00:00:00 |
| 2011-09-29 14:25:00 | 3300     | 2001823863 |         1344 |       0.361 | 
NULL     | 0000-00-00 00:00:00 |
| 2011-09-29 14:30:00 | 3300     | 2001823863 |         1236 |       0.464 | 
NULL     | 0000-00-00 00:00:00 |
| 2011-09-29 14:35:00 | 3300     | 2001823863 |         1656 |       0.602 | 
NULL     | 0000-00-00 00:00:00 |
| 2011-09-29 14:40:00 | 3300     | 2001823863 |         1572 |       0.733 | 
NULL     | 0000-00-00 00:00:00 |
| 2011-09-29 14:45:00 | 3300     | 2001823863 |         1392 |       0.849 | 
NULL     | 0000-00-00 00:00:00 |


Besides that, I've used Wireshark to see if any data is being transmitted at 
all to PVOutput - none is.

Using an SB3300.

Would it be feasible to provide an option to log/combine the data from multiple 
inverters ?


For now, I am using two separate databases to log data from two inverters.

Combining data from the two tables to compute total power production is no 
rocket science, though it can provide somewhat of a challenge.

is there data, schema etc for the database yet?

Attached file is the sniff result of the SunnyBoy 2500 Inverter.

I would be greatfull to be able to log data from the inverter using the 
sma-bluetooth.

What steps will reproduce the problem?
1. cd  /mnt/PC-INFO/SMA2/sma-bluetooth ; ./smatool -c SMA2500HF30.conf
succeeds

2. cd /home/user ; cp /mnt/PC-INFO/SMA2/sma-bluetooth/SMA2500HF30.conf
 /home/user/ ; ./smatool -c /home/user/SMA2500HF30.conf

3. cd /home/user ; /mnt/PC-INFO/SMA2/sma-bluetooth/smatool -v -c 
/mnt/PC-INFO/SMA2/sma-bluetooth/SMA2500HF30.conf
Segmentation fault

4. cd /home/user ; cp /mnt/PC-INFO/SMA2/sma-bluetooth/SMA2500HF30.conf
 . ; /mnt/PC-INFO/SMA2/sma-bluetooth/smatool -v -d -c SMA2500HF30.conf
variable=Inverter value=3000TLHF
variable=BTAddress value=00:80:25:1E:C7:D1
variable=BTTimeout value=
variable=Password value=0000
variable=Config value=
variable=File value=sma.in.new
variable=Latitude value=
variable=Longitude value=
variable=MySqlHost value=localhost
variable=MySqlDatabase value=smatool
variable=MySqlUser value=
variable=MySqlPwd value=
variable=PVOutputURL value=http://pvoutput.org/service/r1/addstatus.jsp
variable=PVOutputKey value=
variable=PVOutputSid value=
Segmentation fault



What is the expected output? What do you see instead?
smatool should be callable from any working directory. 
Instead I get a 'Segmentation fault' when my working directory is not equal to 
the directory where smatool resides.


What version of the product are you using? On what operating system?
smatool-0.14
Gentoo Linux 2.6.39-gentoo-r3 

Please provide any additional information below.
From the strace, I see the reason is that smatool doesn't find sma.in.new.

As a solution I propose:
1. in the program catch the error to exit gracefully 'Could not find 
/{dir-where-smatool-is-looking}sma.in.new'
2. in the default config file, document that the path to smatool should be 
either a full path (or relative to the location of smatool)
3. A more intuitive solution is to make sma.in.new relative to the conf file

running --UPDATE on my setup fails since the smatool user hasn't been given the 
rights to alter the schema

Perhaps if the update fails due to rights then update should exit by dumping 
the sql required to stdout?

Cheers

Bret

PS I have some php code to output graphs of last 24hr, last month and last year 
from the mysql - interested in adding them into this project? - Attached as a 
zip

running -v -d I now get this fairly consistently..

.
.
.
Receiving
    00000000: .. .. .. .. .. .. .. .. .. .. .. .. 7e 1b 00 65 
    00000010: 06 e0 09 25 80 00 21 50 24 98 80 00 01 00 54 00 
    00000020: 00 00 00 00 03 1f 7e  rr=27

65 06 e0 09 25 80 00 21 50 24 98 80 00 01 00 54 00 00 00 00 00 03 1f 7e 
7e 1b 00 65 06 e0 09 25 80 00 21 50 24 98 80 00 01 00 54 00 00 00 00 00 03 1f 
7e 

len=385 data=00 5c 84 2c 4d da 13 54 00 00 00 00 00 88 85 2c 4d da 13 54 00 00 
00 00 00 b4 86 2c 4d da 13 54 00 00 00 00 00 e0 87 2c 4d da 13 54 00 00 00 00 
00 0c 89 2c 4d da 13 54 00 00 00 00 00 38 8a 2c 4d da 13 54 00 00 00 00 00 64 
8b 2c 4d da 13 54 00 00 00 00 00 90 8c 2c 4d da 13 54 00 00 00 00 00 bc 8d 2c 
4d da 13 54 00 00 00 00 00 e8 8e 2c 4d da 13 54 00 00 00 00 00 14 90 2c 4d da 
13 54 00 00 00 00 00 40 91 2c 4d da 13 54 00 00 00 00 00 6c 92 2c 4d da 13 54 
00 00 00 00 00 98 93 2c 4d da 13 54 00 00 00 00 00 c4 94 2c 4d da 13 54 00 00 
00 00 00 f0 95 2c 4d da 13 54 00 00 00 00 00 1c 97 2c 4d da 13 54 00 00 00 00 
00 48 98 2c 4d da 13 54 00 00 00 00 00 74 99 2c 4d da 13 54 00 00 00 00 00 a0 
9a 2c 4d da 13 54 00 00 00 00 00 cc 9b 2c 4d da 13 54 00 00 00 00 00 f8 9c 2c 
4d da 13 54 00 00 00 00 00 24 9e 2c 4d da 13 54 00 00 00 00 00 50 9f 2c 4d da 
13 54 00 00 00 00 00 7c a0 2c 4d da 13 54 00 00 00 00 00 a8 a1 2c 4d da 13 54 
00 00 00 00 00 d4 a2 2c 4d da 13 54 00 00 00 00 00 00 a4 2c 4d da 13 54 00 00 
00 00 00 2c a5 2c 4d da 13 54 00 00 00 00 00 58 a6 2c 4d da 13 54 00 00 00 00 
00 84 a7 2c 4d da 13 54 00 00 00 00 00 b0 a8 2c 4d da 13 54 00 00 00 00 00
Date Error! prev=746871808 current=746948608

nekobasu:/usr/local/src/sma-bluetooth-local

Not sure what it means or why the main loop should need to bail at that point.. 
:)

I have a Sunnybeam that communicates over Bluetooth with the inverter. If this 
is connected then I cannot run sma-tool repeatedly.
I can resolve the problem by either logging off the sunnybeam or by running 
sunny-explorer under windows. The inverter can hold 2 connections and will run 
sunnybeam and sunny-explorer together fine.
This seems to suggest that sma-tool is using 2 connections at the same time - 
perhaps until the later connection is successful?

What steps will reproduce the problem?
1. connect sunnybeam to inverter 
2. run sma-tool = successful
3. run sma-tool again = unsuccessful
Resolution -- either
4. Disconect sunnybeam 
5. run sma-tool multiple times = successful
OR
4. boot up hated windows XP machine (built for purpose)
5. run sunny-explorer and connect
6. disconnect sunny-explorer
7. run sma-tool once - successful
8. run sma-tool again - unsuccessful

What is the expected output? What do you see instead?
As the inverter allows 2 bluetooth conections conescutivly I should be able to 
have sunnybeam working and run sma-tool periodically

What version of the product are you using? On what operating system?
Inverter - SM3000-HF30
SMA-tool v0.12
Debian Linux on NSLU2

Please provide any additional information below.

myslug:/home/simon/sma-bluetooth-0.12# ./smatool -d    
variable=Inverter value=3000TLHF
variable=BTAddress value=00:80:25:18:56:8B
variable=BTTimeout value=
variable=Password value=0000
variable=Config value=
variable=File value=sma.in.new
variable=Latitude value=
variable=Longitude value=
variable=MySqlHost value=localhost
variable=MySqlDatabase value=smatool
variable=MySqlUser value=user
variable=MySqlPwd value=password
variable=PVOutputURL value=http://pvoutput.org/service/r1/addstatus.jsp
variable=PVOutputKey value=xxxxxxxxxxxxxxxxxxxxxxxxxx
variable=PVOutputSid value=xxxx
variable=PVOutputSid value=
utc=2011-05-18 22:40 local=2011-05-18 23:40 diff 1 hours
localOffset=1.000000
localOffset=1.000000 isdst=1
tzsecs=1 1
tzsecs=00 01
SELECT data FROM settings WHERE value='schema' 
SELECT DATE_FORMAT( DateTime, "%Y-%m-%d %H:%i:%S" ) FROM DayData ORDER BY 
DateTime DESC LIMIT 1
SELECT if(sunrise < NOW(),1,0) FROM Almanac WHERE date= DATE_FORMAT( NOW(), 
"%Y-%m-%d" ) 
SELECT if( dd.datetime > al.sunset,1,0) FROM DayData as dd left join Almanac as 
al on al.date=DATE(dd.datetime) and al.date=DATE(NOW()) WHERE 1 ORDER BY 
dd.datetime DESC LIMIT 1
datefrom=2011-05-18 23:30:00 dateto=2011-05-18 23:40:00
Error connecting to 00:80:25:18:56:8B
Error connecting to 00:80:25:18:56:8B
Error connecting to 00:80:25:18:56:8B
Error connecting to 00:80:25:18:56:8B

bad news... --INSTALL fails..

--
nekobasu:/usr/local/src/sma-bluetooth# ./smatool --INSTALL
--INSTALL MUST be the last argument


nekobasu:/usr/local/src/sma-bluetooth# ./smatool -v -d
variable=Inverter value=3000TL
variable=BTAddress value=00:80:25:09:E0:06
variable=BTTimeout value=15
variable=Password value=xxxxxxxxxxxxx
variable=Config value=
variable=File value=sma.in.new
variable=Latitude value=-32.0031
variable=Longitude value=116.04982
variable=MySqlHost value=localhost
variable=MySqlDatabase value=local_data
variable=MySqlUser value=smatool
variable=MySqlPwd value=xxxxxxx
variable=PVOutputURL value=http://pvoutput.org/service/r1/addstatus.jsp
variable=PVOutputKey value=xxxxxxxxxxxxxxxxxxc7bec0db716a9a5333d7ff
variable=PVOutputSid value=822
SELECT sunrise FROM Almanac WHERE date=DATE_FORMAT( NOW(), "%Y%m%d" ) 
SELECT data FROM settings WHERE value='schema' 

Please find attached data from my dual setup of SB 3300. Sniffed with 
USBsniffer. 

Marcus

here is the session log... attached

I have attached the USB sniff results from my mini central 6000A.
If there is anything I can do to help you add this inverter let me know.
Cheers Steve

Compiled smatool fine, ran it vanilla and things worked ok,
tried to run it with a time period and I got this... Guessing my config is 
wrong.

This GDB was configured as "arm-linux-gnueabi"...
(gdb) run
Starting program: /usr/local/src/sma-bluetooth/smatool -v -from 2011-01-06\ 
00:00:00 -to 2011-01-06\ 23:55:00
[Thread debugging using libthread_db enabled]
[New Thread 0x407d9e80 (LWP 2719)]

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x407d9e80 (LWP 2719)]
0x402b5fe8 in feof () from /lib/libc.so.6
(gdb) backtrace
#0  0x402b5fe8 in feof () from /lib/libc.so.6
#1  0x0000c74c in GetConfig (conf=0xbece4854) at smatool.c:614
#2  0x0000d454 in main (argc=6, argv=0xbece4d14) at smatool.c:822

smatool.conf
--
# Configuration for smatoool bluetooth inverter logger
#
# Not all fields are compulsory
#
# Inverter (compulsory) type 3000TL, 5000TL others not tested
Inverter        3000TL
# Inverter (compulsory bluetooth address) use "hcitool scan" to find
BTAddress       00:80:25:09:E0:06
# Inverter User password (compulsory)
Password        xxxxxxxxxxx
# Config file (optional) defaults to ./smatool.conf
Config
# String file (compulsory) data strings to drive the system
File            sma.in.new
# Location (optional) required to avoid waking up system in the dark. 
# Requires  mysql below.
Latitude
Longitude
# Mysql (optional) required for storing data
MySqlHost       localhost
MySqlDatabase   smatool
MySqlUser
MySqlPwd
# PVOutput.org specific data if you are outputting to PVOutput.org.
PVOutputURL     http://pvoutput.org/service/r1/addstatus.jsp
PVOutputKey     xxxxxxxxxxxxxxxxxxx7bec0db716a9a5333d7ff
PVOutputSid

Here is a log file for my SB 3000.  I'd be very grateful if you can work out 
the codes to support it.

Thanks.

I have attached the USB sniff results from my SB2000HF30 and would be grateful 
for some detail on where to identify the inverter code and archive code values 
to provide support for this device.

Many thanks in advance for help -

Henk

Multiple inputs to the mysql database breaks the auto_set_dates function.

it needs to add inverter or serial to the query string. - otherwise a race 
condition occurs and data is skipped

Suggested query:-

SELECT DATE_FORMAT( DateTime, \"%%Y-%%m-%%d %%H:%%i:%%S\" ) FROM DayData 
WHERE conf.inverter (probably should capture serial somewhere) = "xxxxTL"
ORDER BY DateTime DESC LIMIT 1

I just set up SMA-Bluetooth. Loaded the data to MySQL - all good.
How can I load all of the data from MySQL to PVOutput.org (have about 6 
months)? 

Hi I keep getting the same error... 

What steps will reproduce the problem?
1. ./smatool -v -d

What is the expected output? What do you see instead?
variable=Inverter value=5000TL
variable=BTAddress value=00:80:25:19:3A:FF
variable=BTTimeout value=15
variable=Password value=0000
variable=Config value=
variable=File value=sma.in.new
variable=Latitude value=32.0031
variable=Longitude value=116.04982
variable=MySqlHost value=localhost
variable=MySqlDatabase value=smatool
variable=MySqlUser value=user
variable=MySqlPwd value=pass
variable=PVOutputURL value=http://pvoutput.org/service/r1/addstatus.jsp
variable=PVOutputKey value=
variable=PVOutputSid value=
Segmentation fault


What version of the product are you using? On what operating system?
sma-bluetooth-0.9test

Please provide any additional information below.


Thanks for any help!!

For an unknown reason my inverter stores the data values not at a rount 
interval as 13:05:00 but at something like 13:07:42. For that reason the query

"SELECT DATE_FORMAT(dd1.DateTime,\'%%Y%%m%%d\'), 
DATE_FORMAT(dd1.DateTime,\'%%H:%%i\'), 
ROUND((dd1.ETotalToday-dd2.EtotalToday)*1000), dd1.CurrentPower, dd1.DateTime 
FROM DayData as dd1 join DayData as dd2 on 
dd2.DateTime=DATE_FORMAT(dd1.DateTime,\'%%Y%%m%%d0000000\') WHERE 
dd1.DateTime>=Date_Sub(CURDATE(),INTERVAL 1 DAY) and dd1.PVOutput IS NULL and 
dd1.CurrentPower>0 ORDER BY dd1.DateTime ASC"

does not return any hit.

To fix it I had to change both the date format and condition of the join clause 
as following:

"SELECT DATE_FORMAT(dd1.DateTime,\'%%Y%%m%%d\'), 
DATE_FORMAT(dd1.DateTime,\'%%H:%%i\'), 
ROUND((dd1.ETotalToday-dd2.EtotalToday)*1000), dd1.CurrentPower, dd1.DateTime 
FROM DayData as dd1 join DayData as dd2 on 
dd2.DateTime>=DATE_FORMAT(dd1.DateTime,\'%%Y-%%m-%%d 00:00:00\') and 
dd2.DateTime<=DATE_FORMAT(dd1.DateTime,\'%%Y-%%m-%%d 00:05:00\') WHERE 
dd1.DateTime>=Date_Sub(CURDATE(),INTERVAL 1 DAY) and dd1.PVOutput IS NULL and 
dd1.CurrentPower>0 ORDER BY dd1.DateTime ASC"

I've done that for all the queries containing "%%Y%%m%%d0000000" and now it 
works like a charm.

Thanks to the team for this great project!

Wally

What steps will reproduce the problem?
1. Trying to repost data for recent days that I have deleted from PVOutput.org

What is the expected output? What do you see instead?
Here is my console with the error messages:
smatool -from "2011-06-26 00:00:00" -to "2011-06-26 23:55:00" -repost
return=0 buf1=�|�23�
buf=431,0,431,431,431,0.079,1,20110628,20110628,0.079,20110628 here
Power 431.000000
return=0 buf1=0,431,431,431,0.079,1,20110628,20110628,0.079,20110628
buf=Forbidden 403: Exceeded 1 request per second
 here
return=0 buf1=0,431,431,431,0.079,1,20110628,20110628,0.079,20110628
buf=Forbidden 403: Exceeded 1 request per second
 here


What version of the product are you using? On what operating system?
V0.13, Ubuntu 10.10

Please provide any additional information below.
I am trying to repost some data and PVOutput is complaining.  I have tried to 
repost without any dates to/from and still get the same problem.  It would 
appear that smatool is polling the server too fast, is there a timing issue?

When I run the smatool with -d it gives me at the end this info, maybe here is 
somewhere the issue why it is not getting updated to the website?

SELECT DATE_FORMAT(dd1.DateTime,'%Y%m%d'), DATE_FORMAT(dd1.DateTime,'%H:%i'), 
ROUND((dd1.ETotalToday-dd2.EtotalToday)*1000), dd1.CurrentPower, dd1.DateTime 
FROM DayData as dd1 join DayData as dd2 on 
dd2.DateTime=DATE_FORMAT(dd1.DateTime,'%Y%m%d0000000') WHERE 
dd1.DateTime>=Date_Sub(CURDATE(),INTERVAL 1 DAY) and dd1.PVOutput IS NULL and 
dd1.CurrentPower>0 ORDER BY dd1.DateTime ASC

What steps will reproduce the problem?
1. just running ./smatool 

What is the expected output? What do you see instead?
The program is successful and properly does what it should do OR it fails with 
the message "bad extracting timestring". There is apparently no reason why it 
fails ~75% of the times. I tried to change bluetooth dongle, I tried to run 
smatool with and without options, result is always similar. 

What version of the product are you using? On what operating system?
sma-bluetooth-0.14, running NSLU2 with Debian (Linux nslu2 2.6.26-2-ixp4xx #1 
Mon Sep 19 09:19:39 UTC 2011 armv5tel GNU/Linux)

Please provide any additional information below.
In attachment what I get while running ./smatool -d -v for an unsuccessful and 
a successful case. 

Any help/advise is highly appreciated! 

Regards.

Alessandro

Host System Ubuntu 10.10

uname -a
Linux penni-ubuntu 2.6.35-22-generic #33-Ubuntu SMP Sun Sep 19 20:34:50 UTC 
2010 i686 GNU/Linux


root@kenny-ubuntu:/home/kenny/sma/sma-bluetooth0.3# gcc -lbluetooth -lcurl 
-lmysqlclient -g -o smatool smatool.c
smatool.c: In function ‘main’:
smatool.c:1406: warning: too few arguments for format
smatool.c:1548: warning: format ‘%03x’ expects type ‘unsigned int’, but 
argument 2 has type ‘time_t’
smatool.c:1575: warning: format ‘%03x’ expects type ‘unsigned int’, but 
argument 2 has type ‘time_t’
smatool.c:1600: warning: format ‘%03x’ expects type ‘unsigned int’, but 
argument 2 has type ‘time_t’
smatool.c:1628: warning: format ‘%03x’ expects type ‘unsigned int’, but 
argument 2 has type ‘time_t’
smatool.c:1832: warning: format ‘%d’ expects type ‘int’, but argument 2 
has type ‘time_t’
smatool.c:1832: warning: format ‘%d’ expects type ‘int’, but argument 3 
has type ‘time_t’
smatool.c:1915: warning: unknown conversion type character 0xa in format
smatool.c:1951: warning: format ‘%d’ expects type ‘int’, but argument 5 
has type ‘long unsigned int

What steps will reproduce the problem?
1. Set time zone to Adelaide Australia

What is the expected output? What do you see instead?
Expected:
crc=0
Output:
crc=0Date Error! prev=1319328000 current=1319333100

What version of the product are you using? On what operating system?
Current

Please provide any additional information below.
Changed

localOffset=(hour-utctime->tm_hour)+(minute-utctime->tm_min)/60;

to:

localOffset=(hour-utctime->tm_hour)+(float)(minute-utctime->tm_min)/60;

Fixed the problem.

What steps will reproduce the problem?
1. ./smatool -h
2. ./smatool -from "2011-31-03 00:00:00" -to "2011-31-03 23:55:00"
3.

What is the expected output? What do you see instead?
  -from  --datefrom YYYY-DD-MM HH:MM:00    Date range from date
  -to  --dateto YYYY-DD-MM HH:MM:00        Date range to date

<b>Time Coversion Error</b>

What version of the product are you using? On what operating system?
0.11 on ubuntu 10.04

Please provide any additional information below.

should be YYYY-MM-DD (see sourcecode: "%Y-%m-%d %H:%M:%S")

case 13: // $TIMEFROM1  
// get report time and convert
  if( daterange == 1 ) {
    if( strptime( datefrom, "%Y-%m-%d %H:%M:%S", &tm) == (time_t)NULL ) 
      {
        if( debug==1 ) printf( "datefrom %s\n", datefrom );
        printf( "Time Coversion Error\n" );
        error=1;
        exit(-1);
      }


As this is confusing, it's better to correct this in the next release. Also the 
type in "coversion" :-)

thanks,
Luc

Good job!! Great tool

Purpose of code changes on this branch:


When reviewing my code changes, please focus on:


After the review, I'll merge this branch into:
/trunk

I've noticed that for some reason - and I admit I've been too lazy to look. The 
data in the database is always one hour behind...

Last run using -v -d gave a final output of..
11/2/2011 14:09:35  total=13545342230331392.000 Kwh current=0 Watts togo=0 i=11 
crc=1073874040

looking at the db though..

2011-02-11 13:00:00 | 3000TL   | 2100085423 |         2160 |    6029.798 | NULL 
               | 0000-00-00 00:00:00 |

Cheers

Bret