Faqs

Admin (5)

I lost my Admin password, how could i reset it?

WSL uses a database for data storage.

The admin password is stored in the wsl.sdb database, table “config”, field “adminpasswd”.
Here are the steps to reset the admin password of your WebSolarLog;
install the sqlite3 package, so you could connect to the database;
sudo apt-get install sqlite3
Please try the following on the console;
sudo sqlite3 /path/to/websolarlog/database/wsl.sdb
and run the following query;
update config set adminpasswd = “d033e22ae348aeb5660fc2140aec35850c4da997″;
and to exit the SQLite3 tool;
.q

The admin password is now reset to default: admin

Now you could login to the admin.
Please note the security warning about the default password and change the admin password!

Permalink.

Howto create an Cronjob in DirectAdmin?

Here we have an example of job created on a hosted server with DirectAdmin:

WebSolarLogCronJobDirectAdmin

Please note;

  1. We want to run the script only once every minute;  */1
  2. We need PHP to run cron.php, so we need to the command to run php and in this case it is; /usr/local/bin/php
  3. We need the whole path to cron.php and in this case; /home/***/domains/***/public_html/websolarlog/utils/cron.php
  4. We do not want to return data to the prompt or a file, so we add; >/dev/null 2>&1

This is just a example and we advice to contact your hosting provider and ask them if the could help you with the Cronjob.

Permalink.

Howto update WebSolarLog?

WebSolarLog comes with a 2 (maybe 4) clicks update function.

Go to Admin::Update and click(1) on the version you want to update to and click(2) on the update button. The background process will then download the new source and extract it to the filesystem.

Its also possible to update to a unsupported Alpha/Beta or Trunk release. Go on the right side of the screen on the button “I understand and want to see the update options!” and click(1) on it, WebSolarLog will show you the possible update tags available, click(2) on one of the tags and WebSolarLog will show the possible version to update to, choice one version by clicking(3) it and after that click(4) on the update button.

The update will take a few minutes and will run in the background so you could leave the pages without disturbing the update process.

Permalink.

Howto make backup of the WebSolarLog database?

WebSolarLog uses a “single-file” SQLite3 database for data storage. The big advantage of SQLite3 database is, that you could copy/move the database at any given moment.

In the WebSolarLog admin its possible to make a copy of the database to Dropbox.

You could also make a copy of the database by making a file-based copy;

cp /path/to/websolarlog/database/wsl.sdb    /backup/location/other/medium/wsl.sdb

The above command will make a copy of /path/to/websolarlog/database/wsl.sdb to and place it in /backup/location/other/medium/wsl.sdb

Permalink.

My GPS coordinates on misc.php ?!

Based on the coords we can show people from the other side of the world where your system is located and what the performance is in that region. We though this is a create feature for you and visitors of your WebSolarLog.

What could you do if you don’t want others know where your system/house/garage/shet is located;

  1. insert “fake” coords from a location miles/kilometers from your location
  2. round the figures so the marker will move from the original location

For both options you need to go to Admin::General and click ” }Set coordinates ” to change it.

Permalink.

backup/restore (1)

Howto make backup of the WebSolarLog database?

WebSolarLog uses a “single-file” SQLite3 database for data storage. The big advantage of SQLite3 database is, that you could copy/move the database at any given moment.

In the WebSolarLog admin its possible to make a copy of the database to Dropbox.

You could also make a copy of the database by making a file-based copy;

cp /path/to/websolarlog/database/wsl.sdb    /backup/location/other/medium/wsl.sdb

The above command will make a copy of /path/to/websolarlog/database/wsl.sdb to and place it in /backup/location/other/medium/wsl.sdb

Permalink.

Bluetooth (1)

My RaspberryPi with SMAspot returns “BT_Connect() returned -1”

This error is reported in some different scenarios;

Best Practice;
We see good results with the following setup:
PowerRaspberryPiWithPoweredUSBhub

In the above picture the USB hub is connected to grid power. The RaspberryPi is connected to one of the output sockets of the Powered USB hub and one of the RaspberryPi’s USB ports is connected to the input socket of the Powered USB hub.

In this case the Powered USB hub supplies power to the RaspberryPi and all the device connected to the USB hub. The RaspberryPi is connected to the Hub and can communicate with the USB devices connected with the hub.

Now you could connected the Bluetooth and/or WiFi adapter(s) to the Power USB hub and should not have power issues.

For more info about the “BT_Connect() returned -1” error, see the SMAspot support forum.

For more info about the power issues of the RaspberryPi, see the Power Issue topic on the RaspberryPi forum.

If these forum could not help, please see Google

Permalink.

Debugging (1)

Howto Debug WebSolarLog

You could turn on the debug-log by checking the “Debug mode” radio button in Admin::Advanced and save the settings.

After checking the radio box, WebSolarLog will log debug lines to;

/path/to/websolarlog/log/wsl.log
wsl.log is a so call “rotation log” so we have a compressed log file for each date. 

Or if you run a older version in;

/path/to/websolarlog/log/error.log

/path/to/websolarlog/log/info.log

/path/to/websolarlog/log/debug.log

Permalink.

Device Support (6)

Does WSL support PowerOne inverters?

WSL supports PowerOne inverters that are supported by the Aurora scripts of Curl Blanke.

You could find the script here:

http://www.curtronics.com/Solar/AuroraData.html

Permalink.

Where could i download the thirdparty software for my device?

Here you find a short list of all thirdparty scripts/software/programs WSL supports;

PowerOne  inverters with RS485 Interface:
http://www.curtronics.com/Solar/AuroraData.html

SMA  inverters with RS485 interface:
https://code.google.com/p/sma-get/

SMA inverters with BlueTooth interface:
https://code.google.com/p/sma-spot/

Kostal Piko inverters with Ethernet interface:
http://sourceforge.net/projects/piko/

Delta Solivia inverters with RS48 interface:
https://github.com/bprice/DeltaPVOutput

(Dutch)SmartMeter with P1 interface:
– Software available in the WebSolarLog codebase

Not all devices from a manufacturer are supported by the third-party scripts. Please check the page of the owner/creator of the scripts to see if your device is supported. When it is supported by the script, WSL supports your device.

Permalink.

Is my Diehl inverter with Ethernet compatible with WebSolarLog?

WebSolarLog communicates directly to Diehl inverters with ethernet connections.
There are only a few Diehl inverters that comes with the ethernet connection;

  • Diehl AKO Platinum 4600H
  • Diehl AKO Platinum 2100H

Permalink.

Is my PowerOne inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called Aurora to communicate with PowerOne inverters and WebSolarLog is compatible with Aurora. So its not WebSolarLog that needs to be compatible with a specific inverter, Aurora needs to be compatible with a specific inverter.

Please check the site of Aurora to see if your PowerOne inverter is compatible with Aurora and so with WebSolarLog;

http://www.curtronics.com/Solar/AuroraData.html

Permalink.

Is my SMA inverter with Bluetooth compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMAspot to communicate with SMA inverters and WebSolarLog is compatible with SMAspot. So its not WebSolarLog that needs to be compatible with a specific inverter, SMAspot needs to be compatible with a specific inverter.

Please check the site of SMAspot to see if your SMA inverter is compatible with SMAspot and so with WebSolarLog.

Permalink.

Is my SMA inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMA_get to communicate with SMA inverters and WebSolarLog is compatible with SMA_get. So its not WebSolarLog that needs to be compatible with a specific inverter, SMA_get needs to be compatible with a specific inverter. If your SMA is equiped with a  485PB-NR or, 485PB-MS-NR interface, then SMA_get is compatible with your device.

Permalink.

Devices (6)

Why shows my Weather section zeros and a smiley!

In the case that the Weather section shows zeros and a smiley, then there is no valid and/or actual weather present in the database.

If you experiencing this problem, please check the following;

  1. Did you create a Communication item in Admin::Communication?
  2. Did you create a Weather device in Admin::Devices?
  3. Did you connect the Communication item to the Device in Admin::devices::YourWeatherDevice?
  4. Test the Communication Item and Device. Go to Admin::Communication::YourWeaterCommunicationItem and test the settings. It could take several minutes to process the test. After processing the test should return a “Success”.

What to do when the test results are “failed”?
Verify that the URI field of the WeatherCommunicationItem contains the following url:
http://openweathermap.org/data/2.5/find?units=metrics&cnt=1&mode=json

Do you still have problems?
Please come to our WebSolarLog Support Group

Permalink.

My RaspberryPi with SMAspot returns “BT_Connect() returned -1”

This error is reported in some different scenarios;

Best Practice;
We see good results with the following setup:
PowerRaspberryPiWithPoweredUSBhub

In the above picture the USB hub is connected to grid power. The RaspberryPi is connected to one of the output sockets of the Powered USB hub and one of the RaspberryPi’s USB ports is connected to the input socket of the Powered USB hub.

In this case the Powered USB hub supplies power to the RaspberryPi and all the device connected to the USB hub. The RaspberryPi is connected to the Hub and can communicate with the USB devices connected with the hub.

Now you could connected the Bluetooth and/or WiFi adapter(s) to the Power USB hub and should not have power issues.

For more info about the “BT_Connect() returned -1” error, see the SMAspot support forum.

For more info about the power issues of the RaspberryPi, see the Power Issue topic on the RaspberryPi forum.

If these forum could not help, please see Google

Permalink.

Is my SMA inverter with Bluetooth compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMAspot to communicate with SMA inverters and WebSolarLog is compatible with SMAspot. So its not WebSolarLog that needs to be compatible with a specific inverter, SMAspot needs to be compatible with a specific inverter.

Please check the site of SMAspot to see if your SMA inverter is compatible with SMAspot and so with WebSolarLog.

Permalink.

Is my Diehl inverter with Ethernet compatible with WebSolarLog?

WebSolarLog communicates directly to Diehl inverters with ethernet connections.
There are only a few Diehl inverters that comes with the ethernet connection;

  • Diehl AKO Platinum 4600H
  • Diehl AKO Platinum 2100H

Permalink.

Is my PowerOne inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called Aurora to communicate with PowerOne inverters and WebSolarLog is compatible with Aurora. So its not WebSolarLog that needs to be compatible with a specific inverter, Aurora needs to be compatible with a specific inverter.

Please check the site of Aurora to see if your PowerOne inverter is compatible with Aurora and so with WebSolarLog;

http://www.curtronics.com/Solar/AuroraData.html

Permalink.

Is my SMA inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMA_get to communicate with SMA inverters and WebSolarLog is compatible with SMA_get. So its not WebSolarLog that needs to be compatible with a specific inverter, SMA_get needs to be compatible with a specific inverter. If your SMA is equiped with a  485PB-NR or, 485PB-MS-NR interface, then SMA_get is compatible with your device.

Permalink.

Diehl (1)

Is my Diehl inverter with Ethernet compatible with WebSolarLog?

WebSolarLog communicates directly to Diehl inverters with ethernet connections.
There are only a few Diehl inverters that comes with the ethernet connection;

  • Diehl AKO Platinum 4600H
  • Diehl AKO Platinum 2100H

Permalink.

graphs (1)

Dashboard won’t loading the today graph!

Please go to Admin::Graphs and use the button “reset graphs”. Wait for a few minutes and then refresh the dashboard. Is the issue not solved, please create a topic in the support group.

Permalink.

Hardware (2)

My RaspberryPi with SMAspot returns “BT_Connect() returned -1”

This error is reported in some different scenarios;

Best Practice;
We see good results with the following setup:
PowerRaspberryPiWithPoweredUSBhub

In the above picture the USB hub is connected to grid power. The RaspberryPi is connected to one of the output sockets of the Powered USB hub and one of the RaspberryPi’s USB ports is connected to the input socket of the Powered USB hub.

In this case the Powered USB hub supplies power to the RaspberryPi and all the device connected to the USB hub. The RaspberryPi is connected to the Hub and can communicate with the USB devices connected with the hub.

Now you could connected the Bluetooth and/or WiFi adapter(s) to the Power USB hub and should not have power issues.

For more info about the “BT_Connect() returned -1” error, see the SMAspot support forum.

For more info about the power issues of the RaspberryPi, see the Power Issue topic on the RaspberryPi forum.

If these forum could not help, please see Google

Permalink.

My RaspberryPi is unstable (crashes/reboots)

When your RaspberryPi is unstable, this mostly is a power issue. The Raspberry needs a  “high power” more then 2A (5V x 1A = 5W) power supply. If you connect Bluetooth, WiFi or other wireless adapters,  a power supply of  more then 2A (5V x 2A = 10W)  is recommended.

You could also use a Powered USB hub and we see good results with the following setup:

PowerRaspberryPiWithPoweredUSBhub

In the above picture the USB hub is connected to grid power. The RaspberryPi is connected to one of the output sockets of the Powered USB hub and one of the RaspberryPi’s USB ports is connected to the input socket of the Powered USB hub.

In this case the Powered USB hub supplies power to the RaspberryPi and all the device connected to the USB hub. The RaspberryPi is connected to the Hub and can communicate with the USB devices connected with the hub.

Permalink.

Installation (6)

I want to get started with WebSolarLog?!

There are several ways for you to get started with WebSolarLog;

1. For the RaspberryPi we created a WebSolarLog image which contains the following software;

  • PHP, SQLite, NginX
  • Aurora (PowerOne RS485),
  • DeltaPVOutput (Delta Solivia RS485),
  • SMAget (SMA RS485).

For more information about this image, see the post in our Support group.

2. Create a WebSolarLog LNSP (Linux, Nginx, SQLite, PHP) installation based on the WebSolarLog installation manual.

3. Install WebSolarlog on a distro with Webserver and Database engine of your choice.

Permalink.

Howto get WebSolarLog on my host?

With the following commands you can download WebSolarLog to your host;

Download the most recent Stable to “/usr/share/nginx/www/websolarlog”
sudo svn checkout http://svn.code.sf.net/p/websolarlog/code/tags/stable-release-1.0.0  /usr/share/nginx/www/websolarlog

Stable only support a few device but give full support.

Trunk support much more device, but we can’t everything will work and we do not support it because its a development version.

Download the most recent Trunk to “/usr/share/nginx/www/websolarlog”
sudo svn checkout http://svn.code.sf.net/p/websolarlog/code/tags/trunk  /usr/share/nginx/www/websolarlog

The you could change the destination directory by changing the last part of the command.

Permalink.

Why shows my Weather section zeros and a smiley!

In the case that the Weather section shows zeros and a smiley, then there is no valid and/or actual weather present in the database.

If you experiencing this problem, please check the following;

  1. Did you create a Communication item in Admin::Communication?
  2. Did you create a Weather device in Admin::Devices?
  3. Did you connect the Communication item to the Device in Admin::devices::YourWeatherDevice?
  4. Test the Communication Item and Device. Go to Admin::Communication::YourWeaterCommunicationItem and test the settings. It could take several minutes to process the test. After processing the test should return a “Success”.

What to do when the test results are “failed”?
Verify that the URI field of the WeatherCommunicationItem contains the following url:
http://openweathermap.org/data/2.5/find?units=metrics&cnt=1&mode=json

Do you still have problems?
Please come to our WebSolarLog Support Group

Permalink.

Could i use WebSolarLog on a hosted server?

Theoretically this is possible, but only if you could create a Cronjob on this server and when your devices (inverter, smartmeter) is accessible by the internet.

In the folder /path/to/websolarlog/utils/ you find a file called cron.php.
On the hosted server you create a job that calls this file once every minute.

Please see this FAQ for more info about howto create a cronjob in DirectAdmin.

Permalink.

Howto create an Cronjob in DirectAdmin?

Here we have an example of job created on a hosted server with DirectAdmin:

WebSolarLogCronJobDirectAdmin

Please note;

  1. We want to run the script only once every minute;  */1
  2. We need PHP to run cron.php, so we need to the command to run php and in this case it is; /usr/local/bin/php
  3. We need the whole path to cron.php and in this case; /home/***/domains/***/public_html/websolarlog/utils/cron.php
  4. We do not want to return data to the prompt or a file, so we add; >/dev/null 2>&1

This is just a example and we advice to contact your hosting provider and ask them if the could help you with the Cronjob.

Permalink.

wsl.sh won’t start and returns “/opt/bin/nohup: redirecting stderr to stdout”

This issue could be caused by a “hanging” PID file.

First stop WebSolarLog;
/path/to/websolarlog/scripts/./wsl.sh stop

Then go to the following directory;
cd /path/to/websolarlog/scripts/

and remove the following file;
rm -f server.php.pid

then start WebSolarLog again and the frontend should receive live data after 10-60 seconds;
/path/to/websolarlog/scripts/./wsl.sh start

If the issue still remains, please come to our

Permalink.

Inverters (4)

Is my Diehl inverter with Ethernet compatible with WebSolarLog?

WebSolarLog communicates directly to Diehl inverters with ethernet connections.
There are only a few Diehl inverters that comes with the ethernet connection;

  • Diehl AKO Platinum 4600H
  • Diehl AKO Platinum 2100H

Permalink.

Is my PowerOne inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called Aurora to communicate with PowerOne inverters and WebSolarLog is compatible with Aurora. So its not WebSolarLog that needs to be compatible with a specific inverter, Aurora needs to be compatible with a specific inverter.

Please check the site of Aurora to see if your PowerOne inverter is compatible with Aurora and so with WebSolarLog;

http://www.curtronics.com/Solar/AuroraData.html

Permalink.

Is my SMA inverter with Bluetooth compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMAspot to communicate with SMA inverters and WebSolarLog is compatible with SMAspot. So its not WebSolarLog that needs to be compatible with a specific inverter, SMAspot needs to be compatible with a specific inverter.

Please check the site of SMAspot to see if your SMA inverter is compatible with SMAspot and so with WebSolarLog.

Permalink.

Is my SMA inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMA_get to communicate with SMA inverters and WebSolarLog is compatible with SMA_get. So its not WebSolarLog that needs to be compatible with a specific inverter, SMA_get needs to be compatible with a specific inverter. If your SMA is equiped with a  485PB-NR or, 485PB-MS-NR interface, then SMA_get is compatible with your device.

Permalink.

PowerOne (1)

Is my PowerOne inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called Aurora to communicate with PowerOne inverters and WebSolarLog is compatible with Aurora. So its not WebSolarLog that needs to be compatible with a specific inverter, Aurora needs to be compatible with a specific inverter.

Please check the site of Aurora to see if your PowerOne inverter is compatible with Aurora and so with WebSolarLog;

http://www.curtronics.com/Solar/AuroraData.html

Permalink.

Programming (4)

Where could i find the source code of WebSolarLog

WebSolarLog is an opensource project and can be found on SourceForge.

http://sourceforge.net/p/websolarlog/code/HEAD/tree/

 

 

Permalink.

Could i use WebSolarLog on a hosted server?

Theoretically this is possible, but only if you could create a Cronjob on this server and when your devices (inverter, smartmeter) is accessible by the internet.

In the folder /path/to/websolarlog/utils/ you find a file called cron.php.
On the hosted server you create a job that calls this file once every minute.

Please see this FAQ for more info about howto create a cronjob in DirectAdmin.

Permalink.

Howto create an Cronjob in DirectAdmin?

Here we have an example of job created on a hosted server with DirectAdmin:

WebSolarLogCronJobDirectAdmin

Please note;

  1. We want to run the script only once every minute;  */1
  2. We need PHP to run cron.php, so we need to the command to run php and in this case it is; /usr/local/bin/php
  3. We need the whole path to cron.php and in this case; /home/***/domains/***/public_html/websolarlog/utils/cron.php
  4. We do not want to return data to the prompt or a file, so we add; >/dev/null 2>&1

This is just a example and we advice to contact your hosting provider and ask them if the could help you with the Cronjob.

Permalink.

wsl.sh won’t start and returns “/opt/bin/nohup: redirecting stderr to stdout”

This issue could be caused by a “hanging” PID file.

First stop WebSolarLog;
/path/to/websolarlog/scripts/./wsl.sh stop

Then go to the following directory;
cd /path/to/websolarlog/scripts/

and remove the following file;
rm -f server.php.pid

then start WebSolarLog again and the frontend should receive live data after 10-60 seconds;
/path/to/websolarlog/scripts/./wsl.sh start

If the issue still remains, please come to our

Permalink.

SMA (3)

My RaspberryPi with SMAspot returns “BT_Connect() returned -1”

This error is reported in some different scenarios;

Best Practice;
We see good results with the following setup:
PowerRaspberryPiWithPoweredUSBhub

In the above picture the USB hub is connected to grid power. The RaspberryPi is connected to one of the output sockets of the Powered USB hub and one of the RaspberryPi’s USB ports is connected to the input socket of the Powered USB hub.

In this case the Powered USB hub supplies power to the RaspberryPi and all the device connected to the USB hub. The RaspberryPi is connected to the Hub and can communicate with the USB devices connected with the hub.

Now you could connected the Bluetooth and/or WiFi adapter(s) to the Power USB hub and should not have power issues.

For more info about the “BT_Connect() returned -1” error, see the SMAspot support forum.

For more info about the power issues of the RaspberryPi, see the Power Issue topic on the RaspberryPi forum.

If these forum could not help, please see Google

Permalink.

Is my SMA inverter with Bluetooth compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMAspot to communicate with SMA inverters and WebSolarLog is compatible with SMAspot. So its not WebSolarLog that needs to be compatible with a specific inverter, SMAspot needs to be compatible with a specific inverter.

Please check the site of SMAspot to see if your SMA inverter is compatible with SMAspot and so with WebSolarLog.

Permalink.

Is my SMA inverter with RS485 compatible with WebSolarLog?

WebSolarLog uses a third-party program called SMA_get to communicate with SMA inverters and WebSolarLog is compatible with SMA_get. So its not WebSolarLog that needs to be compatible with a specific inverter, SMA_get needs to be compatible with a specific inverter. If your SMA is equiped with a  485PB-NR or, 485PB-MS-NR interface, then SMA_get is compatible with your device.

Permalink.

Weather (1)

Why shows my Weather section zeros and a smiley!

In the case that the Weather section shows zeros and a smiley, then there is no valid and/or actual weather present in the database.

If you experiencing this problem, please check the following;

  1. Did you create a Communication item in Admin::Communication?
  2. Did you create a Weather device in Admin::Devices?
  3. Did you connect the Communication item to the Device in Admin::devices::YourWeatherDevice?
  4. Test the Communication Item and Device. Go to Admin::Communication::YourWeaterCommunicationItem and test the settings. It could take several minutes to process the test. After processing the test should return a “Success”.

What to do when the test results are “failed”?
Verify that the URI field of the WeatherCommunicationItem contains the following url:
http://openweathermap.org/data/2.5/find?units=metrics&cnt=1&mode=json

Do you still have problems?
Please come to our WebSolarLog Support Group

Permalink.

Website/Frontend (3)

Dashboard won’t loading the today graph!

Please go to Admin::Graphs and use the button “reset graphs”. Wait for a few minutes and then refresh the dashboard. Is the issue not solved, please create a topic in the support group.

Permalink.

wsl.sh won’t start and returns “/opt/bin/nohup: redirecting stderr to stdout”

This issue could be caused by a “hanging” PID file.

First stop WebSolarLog;
/path/to/websolarlog/scripts/./wsl.sh stop

Then go to the following directory;
cd /path/to/websolarlog/scripts/

and remove the following file;
rm -f server.php.pid

then start WebSolarLog again and the frontend should receive live data after 10-60 seconds;
/path/to/websolarlog/scripts/./wsl.sh start

If the issue still remains, please come to our

Permalink.

My GPS coordinates on misc.php ?!

Based on the coords we can show people from the other side of the world where your system is located and what the performance is in that region. We though this is a create feature for you and visitors of your WebSolarLog.

What could you do if you don’t want others know where your system/house/garage/shet is located;

  1. insert “fake” coords from a location miles/kilometers from your location
  2. round the figures so the marker will move from the original location

For both options you need to go to Admin::General and click ” }Set coordinates ” to change it.

Permalink.