Frequently Asked Questions (FAQ)

I need help!

If you can’t find the answer in the documentation, do not hesitate in looking for help.

Recalculate prices retroactively

I’ve adjusted my energy prices but there are no changes! How can I regenerate them with my new prices?

Execute:

sudo su - dsmr
./manage.py dsmr_stats_recalculate_prices

I’m not seeing any gas readings

Please make sure that your meter supports reading gas consumption and that you’ve waited for a few hours for any graphs to render. The gas meter positions are only be updated once per hour (for DSMR v4). The Status page will give you insight in this as well.

How do I enable timezone support for MySQL?

See also

Check these docs for more information about how to enable timezone support on MySQL.

On recent versions it should be as simple as executing the following command as root/sudo user:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

How do I fix errors such as DETAIL: Key (id)=(123) already exists?

This depends on the situation, but you can always try this yourself first:

# Note: dsmr_sqlsequencereset is only available in DSMR-reader v3.3.0 and higher
sudo su - dsmr
./manage.py dsmr_sqlsequencereset

If it does not resolve your issue, ask for support.

I’ve changed to a different smart meter

Sometimes, when relocating or due to replacement of your meter, the meter positions read by DSMR-reader will cause invalid data (e.g.: big gaps or inverted consumption). Any consecutive days should not be affected by this issue, so you will only have to adjust the data for one day.

The day after, you should be able to manually adjust any invalid Day or Hour Statistics in the admin interface for the invalid day.

How can I create the (super)user or update its password?

See also

Env Settings.

Configure DSMR_USER and DSMR_PASSWORD of the Env Settings.

Now execute:

sudo su - dsmr
./manage.py dsmr_superuser

The user should either be created or the existing user should have its password updated.

How do I fix: Error: Already running on PID 1234 (or pid file '/var/tmp/gunicorn--dsmr_webinterface.pid' is stale)?

Just delete the PID file and restart the webinterface:

sudo supervisorctl restart dsmr_webinterface