by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Mario Behling
    @mariobehling
    @norbusan Did you sleep at all this night or going to bed now?
    Norbert Preining
    @norbusan
    @mariobehling no, I usually get up at 4am ....
    @mariobehling I still cannot log in with the credentials you sent me. Could you try to log in with yours. You need to add the following stuff to the /etc/hosts file temporarily:
    95.216.25.247   www.voicerepublic.com
95.216.25.247   admin.voicerepublic.com
95.216.25.247   voicerepublic.com
    Norbert Preining
    @norbusan
    Maybe also faye.voicerepublic.com ?
    Mario Behling
    @mariobehling
    Screenshot from 2020-01-23 22-48-27.png
    Norbert Preining
    @norbusan
    Strange ...
    Norbert Preining
    @norbusan

    @mariobehling Proxy Error is fixed, the nginx in the VM uses TLSv1 which was disabled on my apache. Enabling for this connection made it work, connection to admin.voicerepublic.com is now working.

    But after logging, I get a 404 error - ata least progress ;-)

    Norbert Preining
    @norbusan
    The reason is that there seems to be some problem with the postgres database ... 
    E, [2020-01-24T05:45:03.016445 #3488] ERROR -- : PG::InternalError: ERROR:  missing chunk number 0 for toast value 1334328 in pg_toast_2619
: SELECT "talks".* FROM "talks" WHERE (ends_at > '2020-01-24 00:45:03.011660' AND starts_at < '2020-01-24 10:45:03.011933')
    Norbert Preining
    @norbusan
    Anyone knows where the passwords for the backend postgres user is located?
    Norbert Preining
    @norbusan
    Forget that, user based

    Ok, the postgres table is broken

    SELECT * FROM talks LIMIT 1 offset $i

    gives error for each and every row. That means, I need a new pg dump ...

    Mario Behling
    @mariobehling

    @norbusan Here is the feedback from @telmich. He can provide the DB, but..

    I can do that, but there should already be tons of postgresql backups on the VM
    And to get the data, you can simply run pg_dump on the running VM

    Norbert Preining
    @norbusan
    @mariobehling Yes, there are many dumps, but aren't there any newer data since then? I can restore from the latest one for sure!
    Norbert Preining
    @norbusan
    I have now pulled a new DB dump from the current VR server and played it into my VM. Now the admin backend is working.
    @mariobehling please try out the admin backend, and if possible other features, too, so that we see whether the functionality is fully back up!
    Norbert Preining
    @norbusan
    Frontend seems to work, too, at least I could listen to a few talks.
    Norbert Preining
    @norbusan
    @/all I get sometimes OOM killers when convert is running. The VM has 16G mem, so that should suffice I thought. Any idea? I guess this is some process that converts images?
    Norbert Preining
    @norbusan
    Small success report: I got the backend starting on Debian/Buster with ruby 2.4.9 (a version that still gets at least security updates)
    Norbert Preining
    @norbusan
    And it actually runs !!! YEAH!!!
    Mario Behling
    @mariobehling
    Wooow! :thumbsup:
    Norbert Preining
    @norbusan
    The README.md in voicerepublic-dev git repo (frontend) talks about docker images for icebox and worker, are those necessary?
    Norbert Preining
    @norbusan
    VR frontend also working on ruby 2.4.9 with rails 4.2.11.1 on Debian/buster!
    Norbert Preining
    @norbusan

    In the frontend log (/home/app/app/shared/log/production.log) I see error messages:

    I, [2020-01-30T01:42:24.247430 #8082]  INFO -- : Started GET "/500.html" for 127.0.0.1 at 2020-01-30 01:42:24 +0100
I, [2020-01-30T01:42:24.251429 #8082]  INFO -- : Processing by ApplicationController#internal_server_error as HTML
I, [2020-01-30T01:42:24.261058 #8082]  INFO -- :   Rendered application/internal_server_error.html.haml within layouts/velvet (1.7ms)
I, [2020-01-30T01:42:24.264743 #8082]  INFO -- :   Rendered layouts/_head.html.haml (2.7ms)
I, [2020-01-30T01:42:24.265713 #8082]  INFO -- :   Rendered shared/_svg_defs.html (0.5ms)
I, [2020-01-30T01:42:24.266164 #8082]  INFO -- :   Rendered shared/_notice_or_error_velvet.html.erb (0.1ms)
I, [2020-01-30T01:42:24.266525 #8082]  INFO -- :   Rendered explore/_loading.html (0.1ms)
I, [2020-01-30T01:42:24.269821 #8082]  INFO -- :   Rendered shared/_avatar_image_velvet.html.haml (0.7ms)
I, [2020-01-30T01:42:24.279449 #8082]  INFO -- :   Rendered shared/_footer_velvet.html.haml (5.5ms)
I, [2020-01-30T01:42:24.281850 #8082]  INFO -- :   Rendered shared/_tawk.html.erb (0.1ms)
I, [2020-01-30T01:42:24.282137 #8082]  INFO -- :   Rendered shared/_google_analytics.html.erb (0.0ms)
I, [2020-01-30T01:42:24.282366 #8082]  INFO -- :   Rendered shared/_google_remarketing.html.erb (0.0ms)
I, [2020-01-30T01:42:24.282443 #8082]  INFO -- :   Rendered layouts/_scripts.html.haml (2.8ms)
I, [2020-01-30T01:42:24.282803 #8082]  INFO -- : Completed 500 Internal Server Error in 31ms (Views: 22.8ms | ActiveRecord: 2.5ms)

    but I don't see a visual error or anything missing.

    This happens even without doing anything on the page, so it seems to be something like an heartbeat check or similar. Any idea?

    Disruption Network Lab
    @disruptberlin_twitter
    Hi! SSL certificate expired yesterday...
    Norbert Preining
    @norbusan
    Oh, that's bad. Will try to fix it tonight. Thanks for the heads up!
    Norbert Preining
    @norbusan
    Should be fixed now. Thanks again @disruptberlin_twitter
    @mariobehling this is no long term solution - I cannot do every time a manual update. We really need to get this to buster ..
    Mario Behling
    @mariobehling
    @norbusan Backblaze B2 Cloud Storage Now Has S3 Compatible APIs https://www.backblaze.com/blog/backblaze-b2-s3-compatible-api/ Whaat do you think would be necessary to switch to Backblaze?
    Norbert Preining
    @norbusan
    Yeah @mariobehling I just saw the announcement email coming in. Switching to BB would mean moving all the recordings, right, which is a considerable amount. Or we split the stuff and try to save new recordings to BB, and keep the current ones in AWS, but that probably needs some adjustment in the code.
    Mario Behling
    @mariobehling
    @norbusan Best would be to move everything, around 600 GB as far as I can see. Would it be possible to transfer that directly from S3 to B2?
    Areeb Jamal
    @iamareebjamal
    https://help.backblaze.com/hc/en-us/articles/360041059194-Quickstart-Guide-for-Flexify-IO-to-Transfer-Data-from-Amazon-S3-to-B2
    This is paid option 0.10 USD/GB, there is also self hosted option and rclone CLI but it will use bandwidth
    As it will first download the files and then upload
    Norbert Preining
    @norbusan
    Thanks @iamareebjamal , so @mariobehling that would be an easy option, 600 * 0.1 = 60USD, that shouldn't be the problem if we can move completely to B2.
    Mario Behling
    @mariobehling
    Yes, sounds good for me.
    Disruption Network Lab
    @disruptberlin_twitter
    Hi! How can I redirect my VR rss feed to another feed?
    Mario Behling
    @mariobehling
    This feature is not available on the platform.
    Mario Behling
    @mariobehling

    Dear @/all @iamareebjamal our plan is to move forward with updating Voicerepublic and running it on Debian Buster. @norbusan has successfully set up a server on Buster. Thank you :-)
    The IP 49.12.97.210.
    Please help to test. You need to change the following in /etc/hosts:

    49.12.97.210 www.voicerepublic.com
    49.12.97.210 admin.voicerepublic.com
    49.12.97.210 voicerepublic.com

    François Cartegnie
    @fcartegnie
    49.12.97.210 voicerepublic.com www.voicerepublic.com admin.voicerepublic.com
    Mario Behling
    @mariobehling
    :thumbsup:
    Norbert Preining
    @norbusan
    Yes same effect ;-)
    Nguyễn Hồng Quân
    @hongquan
    Screenshot from 2020-07-08 23-06-53.png
    Failed to login with Facebook.
    Nguyễn Hồng Quân
    @hongquan
    image.png
    One request gets error 502.
    Norbert Preining
    @norbusan
    Thanks for testing, indeed it hangs there.
    Norbert Preining
    @norbusan

    Ok, I see the following errors when trying to get the file:

    2020/07/09 01:13:09 [error] 19442#19442: *458 upstream prematurely closed connection while reading response header from upstream, client: 49.12.97.210, server: , request: "POST /faye HTTP/1.1", upstream: "http://127.0.0.1:9292/faye", host: "voicerepublic.com:443"
2020/07/09 01:13:10 [error] 19442#19442: *461 upstream prematurely closed connection while reading response header from upstream, client: 49.12.97.210, server: , request: "GET /faye/client.js HTTP/1.1", upstream: "http://127.0.0.1:9292/faye/client.js", host: "www.voicerepublic.com"

    Anyone can make something out of this?

    That request is going via the nginx server forwarded to the thin server faye - which somehow seems not to answer ...
    Mario Behling
    @mariobehling
    Facebook app would need to be updated. We should remove Facebook login from the system. I dont see that it is necessary any longer.
    @hongquan Thanks! Any other errors?
    Norbert Preining
    @norbusan
    It still does not explain why the file cannot be downloaded from faye redirect. It seems that this one is somehow dead. I have played around a bit (but today is susi workshop so busy otherwise)