nebgor / sma-bluetooth Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/sma-bluetooth
Automatically exported from code.google.com/p/sma-bluetooth
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)
Original issue reported on code.google.com by [email protected]
on 4 Apr 2011 at 1:26
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
Original issue reported on code.google.com by [email protected]
on 22 Apr 2011 at 7:23
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 19 Jul 2011 at 9:05
Attachments:
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 .
Original issue reported on code.google.com by [email protected]
on 21 Feb 2011 at 1:55
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...
Original issue reported on code.google.com by [email protected]
on 16 Jul 2011 at 10:32
Attachments:
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;
Original issue reported on code.google.com by [email protected]
on 1 Apr 2011 at 7:47
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.
Original issue reported on code.google.com by [email protected]
on 12 Nov 2011 at 9:55
Attachments:
System only works for SMA3000TL
Original issue reported on code.google.com by [email protected]
on 6 Jan 2011 at 12:43
Here is the log from my sniff.
I hope you'll find why I can't run sma-bluetooth with my inverter.
Original issue reported on code.google.com by [email protected]
on 5 May 2011 at 8:44
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 11 Jan 2011 at 9:32
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.
Original issue reported on code.google.com by [email protected]
on 29 Jun 2011 at 1:26
* 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).
Original issue reported on code.google.com by [email protected]
on 1 Jul 2011 at 4:43
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
Original issue reported on code.google.com by [email protected]
on 21 Oct 2011 at 12:06
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
Original issue reported on code.google.com by [email protected]
on 23 Nov 2011 at 10:27
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 3 May 2011 at 11:04
Attachments:
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. :) )
Original issue reported on code.google.com by [email protected]
on 19 Apr 2011 at 1:30
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..
Original issue reported on code.google.com by [email protected]
on 12 Jan 2011 at 1:47
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.
Original issue reported on code.google.com by [email protected]
on 9 Jul 2011 at 7:59
Attachments:
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.
Original issue reported on code.google.com by [email protected]
on 2 Nov 2011 at 8:56
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.
Original issue reported on code.google.com by [email protected]
on 15 Jan 2011 at 1:58
./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?
Original issue reported on code.google.com by [email protected]
on 13 Jan 2011 at 8:08
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!
Original issue reported on code.google.com by [email protected]
on 12 Jan 2011 at 7:07
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.
Original issue reported on code.google.com by [email protected]
on 20 Aug 2011 at 7:46
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.
Original issue reported on code.google.com by [email protected]
on 30 Sep 2011 at 2:59
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.
Original issue reported on code.google.com by [email protected]
on 19 Apr 2011 at 1:34
is there data, schema etc for the database yet?
Original issue reported on code.google.com by [email protected]
on 11 Jan 2011 at 9:40
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.
Original issue reported on code.google.com by [email protected]
on 12 Nov 2011 at 9:55
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 23 Nov 2011 at 10:47
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 11 Feb 2011 at 6:13
Attachments:
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..
:)
Original issue reported on code.google.com by [email protected]
on 13 Jan 2011 at 7:48
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
Original issue reported on code.google.com by [email protected]
on 18 May 2011 at 10:48
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'
Original issue reported on code.google.com by [email protected]
on 12 Jan 2011 at 1:23
Please find attached data from my dual setup of SB 3300. Sniffed with
USBsniffer.
Marcus
Original issue reported on code.google.com by marcus.pool
on 2 May 2011 at 3:24
Attachments:
here is the session log... attached
Original issue reported on code.google.com by [email protected]
on 14 Jan 2011 at 8:07
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 24 Oct 2011 at 9:19
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 11 Jan 2011 at 9:03
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.
Original issue reported on code.google.com by [email protected]
on 9 Nov 2011 at 10:36
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 19 May 2011 at 7:24
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 28 Mar 2011 at 1:58
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)?
Original issue reported on code.google.com by [email protected]
on 13 Sep 2011 at 6:28
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!!
Original issue reported on code.google.com by [email protected]
on 16 Mar 2011 at 2:23
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
Original issue reported on code.google.com by [email protected]
on 17 Jul 2011 at 7:27
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?
Original issue reported on code.google.com by [email protected]
on 29 Jun 2011 at 2:03
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
Original issue reported on code.google.com by [email protected]
on 1 Sep 2011 at 1:34
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
Original issue reported on code.google.com by [email protected]
on 5 Oct 2011 at 7:25
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 12 Jan 2011 at 8:59
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.
Original issue reported on code.google.com by [email protected]
on 23 Oct 2011 at 4:13
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
Original issue reported on code.google.com by [email protected]
on 1 Apr 2011 at 1:34
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
Original issue reported on code.google.com by [email protected]
on 22 Sep 2011 at 10:06
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
Original issue reported on code.google.com by [email protected]
on 11 Feb 2011 at 6:16
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.