known icon indicating copy to clipboard operation
known copied to clipboard

Issue importing a known rss export

Open sriperinkulam opened this issue 5 years ago • 3 comments

## While trying to do this: Importing a known RSS export does not do anything.

## I encountered this error: I get a message: 'Your import has started. We'll email you when it's done.' But the imported posts don't show up

## Some other notes: I don't have any issues creating/deleting new posts

Give us some context: This is a fresh install. I essentially used Marcus Povey's latest build and set it up in Docker. Documented my install here: https://srikanthperinkulam.com/2020/04/28/deploying-known-on-a-docker-stack/

  • It'd also be really handy if you could tell us the contents of your version.known file Known Diagnostics: Version 1.1.7+2020041201

  • What database are you using? (e.g. mongo, mysql, postgres) mysql

  • Any warnings or errors in your admin/diagnostics page? Nothing starkly alarming in the diagnostics report. Happy to share if that'd be helpful.

  • If this is a programming bug, can you include examples of any Micropub / API calls / webhook pings you make? Otherwise please don't worry about what this means!

  • Bonus points - are you able to illustrate the issue with a unit test? If so, submit it as a pull request!

sriperinkulam avatar Apr 30 '20 16:04 sriperinkulam

It'd be good to get a log output, there may be an exception being thrown

mapkyca avatar May 02 '20 21:05 mapkyca

of course! Below is the log during the import process. Likely that the import script is looking for the 'localhost' database? I did have to change it to 'mariadb' since i was deploying it on docker.

10.0.1.161 - - [03/May/2020:16:15:23 +0000] "GET /service/db/optimise HTTP/1.1" 200 946 "https://known.srkn.org/admin/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:75.0) Gecko/20100101 Firefox/75.0"
[Sun May 03 16:15:24.620549 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug - Checking for HSTS headers, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620705 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug - Valid HSTS found, no need to storeArray, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620724 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug - (, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620733 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [0] => HTTP/1.1 200 OK, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620741 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [1] => Content-Type: text/html; charset=UTF-8, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620761 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [2] => Date: Sun, 03 May 2020 16:15:24 GMT, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620770 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [3] => Server: Apache, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620824 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [4] => Content-Length: 0, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620839 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [5] => Connection: keep-alive, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620848 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [6] =>, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620860 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug -     [7] =>, referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620868 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug - ), referer: https://known.srkn.org/admin/
[Sun May 03 16:15:24.620877 2020] [php7:notice] [pid 19] [client 10.0.1.161:50736] Known (known.srkn.org): debug - , referer: https://known.srkn.org/admin/
10.0.1.161 - - [03/May/2020:16:15:23 +0000] "GET /service/vendor/messages HTTP/1.1" 200 961 "https://known.srkn.org/admin/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:75.0) Gecko/20100101 Firefox/75.0"
10.0.1.161 - - [03/May/2020:16:15:51 +0000] "GET /admin/import/ HTTP/1.1" 200 4403 "https://known.srkn.org/admin/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:75.0) Gecko/20100101 Firefox/75.0"
10.0.1.161 - - [03/May/2020:16:15:59 +0000] "GET /admin/import/ HTTP/1.1" 200 4480 "https://known.srkn.org/admin/import/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:75.0) Gecko/20100101 Firefox/75.0"
[Sun May 03 16:16:09.096163 2020] [php7:notice] [pid 94] [client 10.0.1.161:50888] Known (known.srkn.org): error - Import completed, but may not have been successful, referer: https://known.srkn.org/admin/import/
[Sun May 03 16:16:09.117428 2020] [php7:notice] [pid 94] [client 10.0.1.161:50888] Known (known.srkn.org): error - Error sending mail {"error":"Connection could not be established with host localhost :stream_socket_client(): unable to connect to localhost:25 (Cannot assign requested address)"}, referer: https://known.srkn.org/admin/import/
10.0.1.161 - - [03/May/2020:16:15:58 +0000] "POST /admin/import/ HTTP/1.1" 302 930 "https://known.srkn.org/admin/import/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:75.0) Gecko/20100101 Firefox/75.0"

sriperinkulam avatar May 03 '20 16:05 sriperinkulam

I also had this error message upon importing an RSS file exported from 0.9.9. On Dreamhost where the database is not at 'localhost' but uses a domain name, defined in the config file. It would be nice if it did not default to localhost.

motorbaby avatar Mar 12 '21 01:03 motorbaby