{"action":"created","issue":{"url":"https://api.github.com/repos/pi-hole/pi-hole/issues/2386","repository_url":"https://api.github.com/repos/pi-hole/pi-hole","labels_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/2386/labels{/name}","comments_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/2386/comments","events_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/2386/events","html_url":"https://github.com/pi-hole/pi-hole/issues/2386","id":352515445,"node_id":"MDU6SXNzdWUzNTI1MTU0NDU=","number":2386,"title":"Pihole long term database connected but not filled","user":{"login":"Marcel81","id":42575138,"node_id":"MDQ6VXNlcjQyNTc1MTM4","avatar_url":"https://avatars0.githubusercontent.com/u/42575138?v=4","gravatar_id":"","url":"https://api.github.com/users/Marcel81","html_url":"https://github.com/Marcel81","followers_url":"https://api.github.com/users/Marcel81/followers","following_url":"https://api.github.com/users/Marcel81/following{/other_user}","gists_url":"https://api.github.com/users/Marcel81/gists{/gist_id}","starred_url":"https://api.github.com/users/Marcel81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Marcel81/subscriptions","organizations_url":"https://api.github.com/users/Marcel81/orgs","repos_url":"https://api.github.com/users/Marcel81/repos","events_url":"https://api.github.com/users/Marcel81/events{/privacy}","received_events_url":"https://api.github.com/users/Marcel81/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-08-21T12:26:10Z","updated_at":"2018-08-23T12:58:54Z","closed_at":null,"author_association":"NONE","body":"**In raising this issue, I confirm the following:** `{please fill the checkboxes, e.g: [X]}`\r\n\r\n- [x] I have read and understood the [contributors guide](https://github.com/pi-hole/pi-hole/blob/master/CONTRIBUTING.md).\r\n- [x] The issue I am reporting can be *replicated*.\r\n- [x] The issue I am reporting isn't a duplicate (see [FAQs](https://github.com/pi-hole/pi-hole/wiki/FAQs), [closed issues](https://github.com/pi-hole/pi-hole/issues?utf8=%E2%9C%93&q=is%3Aissue%20is%3Aclosed%20), and [open issues](https://github.com/pi-hole/pi-hole/issues)).\r\n\r\n**How familiar are you with the the source code relevant to this issue?:**\r\n1\r\n---\r\n**Expected behaviour:**\r\nShow long term data in the webinterface.\r\n\r\n**Actual behaviour:**\r\nNo data is shown in long term data.\r\n\r\n**Steps to reproduce:**\r\n\r\nI'm running a Raspberry pi 3 with Stretch distro.\r\nAfter an unsuccesfull upgrade to pihole 4.0 i uninstalled the old version and re-installed the pihole software from the original installer (bash command). One thing i had to do is run the FTL deamon as root otherwise it was not able to start the DNS software. Pi-Hole itself is working fine and blocks advertisements.\r\nWhat i do miss is long term data (nothing is showing up in the long term section in the webinterface, not even a pup-up with an error).\r\nAfter some google and testing i can see that the FTL is connected to the database (according to the logs), it also creates a new database when i stop the service, delete the database and start the service again. BUT the database file is **not** growing or updated. The FTL debug also shows 0 records in the database file. To be shure that it doesn't have got something to do with timing or something else i rebooted several times and waited for a day if to see if it suddenly got fixed. \r\nUnfortionately it doesn't.\r\n\r\n\r\n**Debug token provided by [uploading `pihole -d` log](https://discourse.pi-hole.net/t/the-pihole-command-with-examples/738#debug):**\r\n\r\nekpcqnz03f\r\n\r\n**Troubleshooting undertaken, and/or other relevant information:**\r\n`{Steps of what you have done to fix this}`\r\n\r\n> Uninstall and install (due to failing upgrade)\r\n> Run the pihole -r several times (no luck)\r\n> Delete .db file to see if it is recreating (it does)\r\n> Look in Logs for errors (none found with this subject)\r\n> Check growth and timestamp of db file (not increasing or updated)\r\n> Run FTL debug to check for errors (none found)\r\n"},"comment":{"url":"https://api.github.com/repos/pi-hole/pi-hole/issues/comments/415405004","html_url":"https://github.com/pi-hole/pi-hole/issues/2386#issuecomment-415405004","issue_url":"https://api.github.com/repos/pi-hole/pi-hole/issues/2386","id":415405004,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNTQwNTAwNA==","user":{"login":"Marcel81","id":42575138,"node_id":"MDQ6VXNlcjQyNTc1MTM4","avatar_url":"https://avatars0.githubusercontent.com/u/42575138?v=4","gravatar_id":"","url":"https://api.github.com/users/Marcel81","html_url":"https://github.com/Marcel81","followers_url":"https://api.github.com/users/Marcel81/followers","following_url":"https://api.github.com/users/Marcel81/following{/other_user}","gists_url":"https://api.github.com/users/Marcel81/gists{/gist_id}","starred_url":"https://api.github.com/users/Marcel81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Marcel81/subscriptions","organizations_url":"https://api.github.com/users/Marcel81/orgs","repos_url":"https://api.github.com/users/Marcel81/repos","events_url":"https://api.github.com/users/Marcel81/events{/privacy}","received_events_url":"https://api.github.com/users/Marcel81/received_events","type":"User","site_admin":false},"created_at":"2018-08-23T12:58:54Z","updated_at":"2018-08-23T12:58:54Z","author_association":"NONE","body":"Hi @knightphoenix . Thx for the tip but this also did not work for me. When the data is stored it is showing up in the interface (i already tested with the import of a backup). It seems like my data is not stored in the db (since the new install)."}}
{"actor":{"display_login":"Marcel81"}}