What is Domoticz database?
Domoticz Database Usage And Tips For Advanched Users. Domoticz saves everything in his own database. This is an SQLite database placed inside the Domoticz folder domoticz.db. Normally you have nothing to do with this file, You only have to back up and keep it safe. The Domoticz database cleans itself.
Where does Domoticz save his data?
Domoticz saves everything in his own database. This is an SQLite database placed inside the Domoticz folder domoticz.db. Normally you have nothing to do with this file, You only have to back up and keep it safe. The Domoticz database cleans itself.
How do I connect my local Domoticz to mydomoticz?
After clicking on “Apply settings” your local Domoticz instance will automatically try to connect to the MyDomoticz service. If you browse back again to your settings, you will see that a MyDomoticz instance ID was assigned. If not, look at your log for possible errors (search for proxy or mydomoticz).
Can I change the port number in the Domoticz remote hardware settings?
The port number in the Domoticz remote hardware settings is not used. It is possible to change an existing slave from a direct connection to MyDomoticz communication. To do so, simply change the IP address that is currently configured to the Domoticz instance ID. This way, all the devices that were previously added will still be intact.
How do I access Domoticz from the Internet?
6:3221:48How-to access Domoticz over the internet (securely)? - YouTubeYouTubeStart of suggested clipEnd of suggested clipFrom my own which is then poor forwarding port 80 to 80 82. The Raspberry Pi so again two differentMoreFrom my own which is then poor forwarding port 80 to 80 82. The Raspberry Pi so again two different rules one rule external port 80 to internal if you have the default demotic settings to port 8080.
What can you do with Domoticz?
Domoticz is a Home Automation System that lets you monitor and configure various devices like: Lights, Switches, various sensors/meters like Temperature, Rain, Wind, UV, Electra, Gas, Water and much more. Notifications/Alerts can be sent to any mobile device.
What is home automation?
“Home automation” refers to the automatic and electronic control of household features, activity, and appliances. In simple terms, it means you can easily control the utilities and features of your home via the Internet to make life more convenient and secure, and even spend less on household bills.
How do I stop Domoticz?
Stopping Monit can be done by sudo /etc/init. d/monit stop and after updating it can be started again with sudo /etc/init.
How do I uninstall Domoticz?
To uninstall Domoticz execute the following steps:service domoticz stop.remove the domoticz folder with binary and all subdirs.remove folder /etc/domoticz.remove file /etc/init. d/domoticz. sh.
How to share Domoticz instance?
Or your favorite tech support guru that helps you trouble shoot. Etc. You just enter their User ID or e-mail address and click on “Share”. On the dashboard of the party that you shared with, your Domoticz wil now appear automatically. After sharing, it’s easy to unshare again by just clicking the “Unshare” link. If another user shared their Domoticz instance with you, the Instance settings are a little bit different but the principle is the same.
How to use mydomoticz?
In order to use the MyDomoticz service, you need to register on https://my.domoticz.com/. Click on the Register link and fill out your name and email address.#N#After clicking on “next”, a verification email will be sent with a link. If the email doesn’t appear immediately, make sure you check your SPAM folder.#N#In the e-mail you will find your MyDomoticz user ID. Make note of this, you will need it in a next step.#N#Click on the link in the e-mail and choose a password. A password strength meter is provided to show if your password is strong enough. Then click next again and you can now use your e-mail address and password to log in. You can leave the "2 factor code" field empty for now. Later you can enable this in your MyDomoticz settings (see below).#N#You won’t see your Domoticz instance yet. For this, you need to set up your local Domoticz. In the settings page of your local Domoticz, scroll down to “MyDomoticz settings”. The MyDomoticz instance id will be empty. It will be assigned automatically later and you cannot change it. Below that you can copy and paste the user id that you got in the registration mail, together with the password that you chose. Also here, you can indicate if you want to use MyDomoticz for accessing the web interface, Domoticz master-slave communication and or app support (see below).#N#After clicking on “Apply settings” your local Domoticz instance will automatically try to connect to the MyDomoticz service. If you browse back again to your settings, you will see that a MyDomoticz instance ID was assigned.#N#If not, look at your log for possible errors (search for proxy or mydomoticz). You can use the same MyDomoticz User ID/password multiple times, for different Domoticz instances in case you have more than 1 Domoticz appliance running.#N#Now you can log in to https://my.domoticz.com/ and you will see that your Domoticz instance (s) appear in the dashboard. The dashboard refreshes automatically so if you were already logged in, it will appear automatically with the descriptive name "My Domoticz". To change this description you can click on that name and some settings will appear.
Is MyDomoticz in beta?
Note that currently the MyDomoticz service is in Beta phase and is available through the normal Beta release update. To participate as a beta tester, you can just follow the steps below.
Is there an app for MyDomoticz?
This feature is still being developed. Currently there are no apps available that can be connected via MyDomoticz.
Domoticz Database size and growth
Some users complained in the past that there was no free space left. The reason was a growing log file or a growing database file. So check your settings at Setup > Settings > Log History A high number means more records means a bigger database file. Experiment for yourself what you need and monitor the size.
Cleanup database with queries
Because my production system is now a real production system, but in the past, I have experimented a lot.
Accessing the home directory on the Pi with sftp
First get Filezilla, the free ftp client which has served me so well for years (if you note the security risks!). The website is https://filezilla-project.org/, be careful with alternative names!
How to reach Windows machines by name
Quite often, working with non-Windows machines, you need the IP number of another machine in your network. With DHCP active this means quite a lot of trouble finding this out over and over again.
Accessing a shared folder on the network
Windows and NAS systems offer shares to other WIndows machines in my network. Also to Raspberry Pi when you follow these steps.
Mounting the share permanent
Auto-mounting a password-protected share edit /etc/fstab (with root privileges) can be accomplished by adding this line:
How much does Domoticz cost per month?
Want to enjoy user-friendly cloud services for OAuth connections, easy and secure remote access and integration with voice assistants? Then you're out of luck with Domoticz, and Home Assistant Cloud will run you $5 per month. With Homey, these services come included, making the off-the-shelve option cheaper than its Raspberry Pi-based counterparts.
What is a domotz script?
Domoticz provides scripting for automation. You can write scripts in PHP or LUA to make your home work in the way you want. Next to that, Domoticz provides the Blockly editor for scenarios, which is a visual representation of code.
What is the best home automation for Raspberry Pi?
Domoticz and Home Assistant are the most popular options for home automation on a Raspberry Pi. They both feature large communities with active forums and development. This makes them work with lots of brands and devices. Domoticz has been around for a longer time, where Home Assistant is newer, but faster growing.
Why is Homey so popular?
Homey provides a friendlier user experience for non-programmers in the household, and makes outside access and cloud integrations easier. It's also the reason why some people switch from their Raspberry Pi-based systems to Homey.
What is home assistant script?
Home Assistant also provided scripting for automation. Scripts are made in Python, just like the rest of Home Assistant. Next to scripting, Home Assistant provides a minimal UI for Automation. In it, you can define a Trigger, Condition and Action. However, despite the UI, Actions in Home Assistant still involve code.
Is Homey compatible with Spotify?
For instance, Homey is compatible with all Spotify Connect speakers, Sunway blinds and Tado.
Is Homey open source?
In general, all three systems support roughly the same devices and brands. Most integrations on Homey, and all integrations on Home Assistant and Domotics, are open-source. The active communities around the platforms leverage this to add support back and forth.
Backup, please!
Most of the people start using backups when it’s too late. Domoticz has some built-in options, use them! You don’t want to lose your carefully constructed dashboards, the historical data of your water and power meters, lose that advanced smart scripts you spend ages on to get it to work, or pair every device in your home again.
Automatic backups
When the Automatic Back-up feature is ticked the system will create a back-up every hour in the Domoticz/backups/hourly/ folder, a daily back-up in the Domoticz/backups/daily/ folder and a monthly back-up in the Domoticz/backups/monthly/ folder. In that way, there will always be a recent copy of the Domoticz database available.
Backup Domoticz scripts
Check this tutorial for an advanced backup script that will backup more than only a database and transfers it to a separate device.
Hardware/Devices
- More general details about types of devices you can connect can be found in the following pages: 1. Hardware Setup (menu Setup - Hardware) 1.1. Python Pluginsfor additional Hardware/devices support 2. Device List (menu Setup - Devices) 2.1. Managing Devices (device navigation and edit…
User Interface
- After that you can change some settings that are user interface related: 1. Application Settings (Menu Setup - Settings) for central settings of themes, location, dashboard, backup, notifications etc. 2. FloorplansMake an interactive floorplan of your building. 3. DashboardCollect the most important devices on the first screen.
Setup, More Options
- In Menu Setup --> More Optionsyou can set the following options: 1. Cameras 2. Events 3. Mobile devices 4. Push data 4.1. Http 4.2. InfluxDB 4.3. Google PubSub 4.4. FibaroLink 5. User Variables 6. Plans 6.1. Roomplans / Floorplans 6.2. Timer plans 7. Edit Users (also for Device sharing) 8. Custom Icons 9. Check for Update 10. Restart/Shutdown system (= the complete computer, not …
Security
- Once Domoticz is installed and it is accessible from outside your local network it's a good idea to secure it. You can secure your Domoticz installation in numerous ways, from setting a passwordto enabling encrypted communication. Examples are: 1. Setup User management 2. Secure Remote Access 3. Automated banning of IP that fails to login multiple times- Using 'fail2…
Troubleshooting
- Log File When you experience strange behaviour of Domoticz please check the log file of Domoticz. It can be viewed trough the Domoticz user interface with menu Setup - Log. You can filter on Status and Errors and also on text strings (ie to only view log entries of a specific device). Use "!" to filter out specific terms, eg !ZwaveJS to filter out all log lines with value "ZwaveJS" The …
Domoticz Database Size and Growth
Cleanup Database with Queries
- Because my production system is now a real production system, but in the past, I have experimented a lot. Bought devices that are already gone But over the time I had some records in my database of devices I didn’t own anymore. with the SQLLitebrowser I was able to check records of: ‘MultiMeter’,’MultiMeter_Calendar’,’Percentage’,’Percentage_Calendar’,’Rain’,’Rain_Cale…
Recover Your Malformed Database
- Log in with SSH and fire the commands below: cd domoticz sqlite3 domoticz.db .mode insert .output dump.sql .dump .exit sqlite3 -init dump.sql repaired.db mv repaired.db domoticz.db Separately if you want to check a database to see if it’s corrupt you can use these commands:sqlite3 domoticz.db pragma integrity_check; .exit or another approach: # Rem...