Closed JHeijting closed 4 years ago
:wave: Thanks for opening your first issue here! If you're reporting a :bug: bug, please make sure you include steps to reproduce it. Also, logs, error messages and information about your hardware might be useful.
I think I have found the cause of this problem. It might not be caused by permissions, but by the names of the CSV and config files. I reported the work around on the Firefly III issue: https://github.com/firefly-iii/firefly-iii/issues/3239#issuecomment-610226268
If you can post samples of the files with issues, I can take a look still. According to the comments this shouldn't occur, so could possibly be something in nginx/php.
Thank you for your response. I wrongly assumed that the upload worked. Whenever I upload a file (even one that worked fine before) it doesn't work. Somehow when I do not upload a configuration file I get passed the error, but then no columns in the CSV are detected.
It is a CSV in UTF8 format.
I cannot duplicate the issue as imports are working fine for me. To duplicate I need some form of dummy data that you can share with steps to reproduce.
This dummy data is not working on my import.
Once I fixed the CSV formatting of the import file, I can import fine.
At which stage do you see the error?
Thanks for looking in to this. I receive the error after selecting the files to upload and than when I press the green button 'upload files'.
I cannot duplicate even with your data, just to rule out any differences, what is your platform you are running on, and are your running the app in a different locale?
I'm running Firefly III 5.1.1 using the Edge add-on (0094e85) on HASSIO 0.107.7. Default settings with the stable MariaDB add-on v2.1.1
Which hardware platform? Can you post the addon log when the upload occurs, I am most interested if you can capture the nginx post.
I run it on VMware ESXi on Debian GNU/Linux 10 (buster).
This is the addon log:
[17:39:24] INFO: Starting PHP-FPM... [17:39:24] INFO: Starting NGinx... [09/Apr/2020:17:39:35 +0200] 302 -(172.26.6.132) GET / HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:35 +0200] 200 -(172.26.6.132) GET /login HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:37 +0200] 302 -(172.26.6.132) POST /login HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:37 +0200] 200 -(172.26.6.132) GET / HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:37 +0200] 200 -(172.26.6.132) GET /v1/jscript/variables?ext=.js&v=5.1.1 HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /chart/account/frontpage HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /chart/budget/frontpage HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /chart/category/frontpage HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /json/box/balance HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /chart/account/revenue HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /json/box/bills HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /json/box/available HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /json/frontpage/piggy-banks HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /json/box/net-worth HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:38 +0200] 200 -(172.26.6.132) GET /chart/account/expense HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:40 +0200] 200 -(172.26.6.132) GET /import HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:40 +0200] 200 -(172.26.6.132) GET /v1/jscript/variables?ext=.js&v=5.1.1 HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:41 +0200] 302 -(172.26.6.132) GET /import/create/file HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:41 +0200] 200 -(172.26.6.132) GET /import/job/configuration/XAGL7Er3HVFg HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:41 +0200] 200 -(172.26.6.132) GET /v1/jscript/variables?ext=.js&v=5.1.1 HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36) [09/Apr/2020:17:39:48 +0200] 500 -(172.26.6.132) POST /import/job/configuration/XAGL7Er3HVFg HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36)
This is the info from Firefly III: `Error This error occured in file /var/www/firefly/vendor/league/flysystem/src/Adapter/Local.php on line 135 with code 0.
Stack trace
The only other thing I can possibly think of is maybe the file naming particularly the data files (although not sure if relevant, but maybe an outcome from when I switched from SQLLite to MySQL). The files on you host (assuming default install) will be at /usr/share/hassio/addons/data/40817795_firefly-iii/firefly/upload.
You could possibly try moving these out and retrying, I would recommend a snapshot beforehand.
This thread has been automatically locked because it has not had recent activity. Please open a new issue for related bugs and link to relevant comments in this thread.
First of all I know that edge add-ons are not intended to use in production. However, I really don't understand the installation instructions from Firefly. And than there is this great add-on. It's very easy and userfriendly; great work!
Problem Somehow I can't import any CSV files anymore. This has been working flawlessly before (in fact, I haven't found any issue besides this one yet).
Expected behaviour Being able to select an import file and configuration file. Than upload them to Firefly III.
Actual behavior I get an error: Failed to open stream: Permission denied More specific information about the error can be found here: https://github.com/firefly-iii/firefly-iii/issues/3239