Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Videos are downloaded, but they are nowhere #47

Open
janaxhell opened this issue Nov 22, 2024 · 44 comments
Open

Videos are downloaded, but they are nowhere #47

janaxhell opened this issue Nov 22, 2024 · 44 comments
Assignees
Labels
enhancement New feature or request setup assistance Assist user to setup on their infrastructure

Comments

@janaxhell
Copy link

janaxhell commented Nov 22, 2024

I've just deployed Streamsphere, I've added the first random playlist YT proposed me and the UI actually showed the downloads were happening. But after finishing, both Playlists and Videos sections were empty. Also the content folder was empty. The only thing that actually happened was the video thumbnails stored in the config folder.
This is my compose, what's wrong?

services:
  streamsphere:
    image: streamsphere/streamsphere:latest
    # image: streamsphere/streamsphere:latest-arm
    container_name: streamsphere
    restart: unless-stopped
    ports:
      - 1282:3000
    environment:
      HOST_IP: "192.168.1.94"
      APPLICATION_PORT: "1282"
      CONTENT_PORT: "1288"
    volumes:
      - /srv/dev-disk-by-uuid-5b67514d-485e-4306-873e-b1cbb54ccf99/Config/streamsphere/db-data:/app/database/db
      - /srv/dev-disk-by-uuid-5b67514d-485e-4306-873e-b1cbb54ccf99/Config/streamsphere/content-data:/app/content
  content:
    image: streamsphere/streamsphere-content:latest
    # image: streamsphere/streamsphere-content:latest-arm
    container_name: streamsphere-content
    restart: unless-stopped
    ports:
      - 1288:3500
    volumes:
      - /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere:/content
networks:
  default:
    external:
      name: omv1

This is the streamsphere-content log:

Starting up http-server, serving ./
http-server version: 14.1.1
http-server settings: 
CORS: 'Access-Control-Allow-Origin:*'
Cache: 3600 seconds
Connection Timeout: 120 seconds
Directory Listings: visible
AutoIndex: visible
Serve GZIP Files: false
Serve Brotli Files: false
Default File Extension: none
Available on:
  http://127.0.0.1:3500
  http://172.16.0.19:3500
Hit CTRL-C to stop the server
[Fri Nov 22 2024 17:07:18 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Crawling%20-%20Behind%20The%20Scenes%20[Jw1TSKRJ8po].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
(node:1) [DEP0066] DeprecationWarning: OutgoingMessage.prototype._headers is deprecated
(Use `node --trace-deprecation ...` to show where the warning was created)
[Fri Nov 22 2024 17:07:18 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Crawling%20-%20Behind%20The%20Scenes%20[Jw1TSKRJ8po].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:07:32 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/DISGUSTING!%20Behind%20The%20Scenes%20[lez7ZODBas8].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:07:32 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/DISGUSTING!%20Behind%20The%20Scenes%20[lez7ZODBas8].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:07:42 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20BEG!%20(Official%20Music%20Video)%20[hwLa4VYL0BI].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:07:42 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20BEG!%20(Official%20Music%20Video)%20[hwLa4VYL0BI].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:07:57 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20Clandestine%20(Official%20Music%20Video)%20[eJDqfQF_Oqc].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:07:57 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20Clandestine%20(Official%20Music%20Video)%20[eJDqfQF_Oqc].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:05 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20Crawling%20(Official%20Music%20Video)%20[6khuplM8Dnw].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:05 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20Crawling%20(Official%20Music%20Video)%20[6khuplM8Dnw].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:13 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20DISGUSTING!%20(Official%20Music%20Video)%20[V1oxX0TKOLU].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:13 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20DISGUSTING!%20(Official%20Music%20Video)%20[V1oxX0TKOLU].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:23 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:23 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Crawling%20(Official%20Lyric%20Video)%20[_-lzFUfNG0U].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Diamond%20on%20a%20Hoe%20(Official%20Minecraft%20Remix%20of%20Foggy%20Windows)%20[aQNj1kOFu_E].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Crawling%20(Official%20Lyric%20Video)%20[_-lzFUfNG0U].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Foggy%20Windows%20(Official%20Audio)%20[7Vqy2Z19Uoc].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Diamond%20on%20a%20Hoe%20(Official%20Minecraft%20Remix%20of%20Foggy%20Windows)%20[aQNj1kOFu_E].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20PRETTYBOY!%20(Official%20Visualizer)%20[3Xqr8Og_eOw].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Foggy%20Windows%20(Official%20Audio)%20[7Vqy2Z19Uoc].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Ragdoll%20(Official%20Lyric%20Video)%20[ZtO5G4tJmJU].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20PRETTYBOY!%20(Official%20Visualizer)%20[3Xqr8Og_eOw].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Ragdoll%20(Official%20Lyric%20Video)%20[ZtO5G4tJmJU].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20LIVE%20at%20BigFan%202023%20-%20AUCKLAND%20SHOW%20[zOBc3m6ATng].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20LIVE%20at%20BigFan%202023%20-%20AUCKLAND%20SHOW%20[zOBc3m6ATng].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20x%20Sophie%20Powers%20-%20PLAYBOi%20[Official%20Visualizer]%20[dzj9hb-4rjM].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20x%20Sophie%20Powers%20-%20PLAYBOi%20[Official%20Visualizer]%20[dzj9hb-4rjM].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20BEG!%20(Official%20Music%20Video)%20[hwLa4VYL0BI].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:33 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20BEG!%20(Official%20Music%20Video)%20[hwLa4VYL0BI].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:40 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Crawling%20(Official%20Lyric%20Video)%20[_-lzFUfNG0U].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:40 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Crawling%20(Official%20Lyric%20Video)%20[_-lzFUfNG0U].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:08:47 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Diamond%20on%20a%20Hoe%20(Official%20Minecraft%20Remix%20of%20Foggy%20Windows)%20[aQNj1kOFu_E].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:08:47 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Diamond%20on%20a%20Hoe%20(Official%20Minecraft%20Remix%20of%20Foggy%20Windows)%20[aQNj1kOFu_E].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:09:09 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Foggy%20Windows%20(Official%20Audio)%20[7Vqy2Z19Uoc].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:09:09 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20Foggy%20Windows%20(Official%20Audio)%20[7Vqy2Z19Uoc].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:09:17 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20PRETTYBOY!%20(Official%20Visualizer)%20[3Xqr8Og_eOw].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:09:17 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20-%20PRETTYBOY!%20(Official%20Visualizer)%20[3Xqr8Og_eOw].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:09:40 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20LIVE%20at%20BigFan%202023%20-%20AUCKLAND%20SHOW%20[zOBc3m6ATng].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:09:40 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20LIVE%20at%20BigFan%202023%20-%20AUCKLAND%20SHOW%20[zOBc3m6ATng].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:09:48 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20x%20Sophie%20Powers%20-%20PLAYBOi%20[Official%20Visualizer]%20[dzj9hb-4rjM].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:09:48 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20x%20Sophie%20Powers%20-%20PLAYBOi%20[Official%20Visualizer]%20[dzj9hb-4rjM].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:10:09 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20BEG!%20(Official%20Music%20Video)%20[hwLa4VYL0BI].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:10:09 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20BEG!%20(Official%20Music%20Video)%20[hwLa4VYL0BI].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:10:16 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:10:16 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" Error (404): "Not found"
[Fri Nov 22 2024 17:12:12 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
[Fri Nov 22 2024 17:12:12 GMT+0000 (Coordinated Universal Time)]  "GET /youtube.com/Vana/Videos/Thumbnails/Vana%20%20-%20SERPENTINE%20(Official%20Music%20Video)%20[NE2QAYVlUJE].webp" Error (404): "Not found"

And this is the last bit of the main app log:

2024/11/22 17:09:38.278543 network.go:346: [Info] MESSAGE VALUE: [download]  93.2% of   84.60MiB at  353.29KiB/s ETA 00:16
2024/11/22 17:09:38.809211 network.go:346: [Info] MESSAGE VALUE: [download] 100% of   84.60MiB in 00:00:03 at 23.19MiB/s
2024/11/22 17:09:38.906347 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of    3.45MiB at  Unknown B/s ETA Unknown
2024/11/22 17:09:39.004177 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.45MiB in 00:00:00 at 17.84MiB/s
2024/11/22 17:09:39.530302 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.45MiB in 00:00:00 at 17.84MiB/s
2024/11/22 17:09:39.530321 network.go:351: [Info] Error Reading:EOF
2024/11/22 17:09:39.530347 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/22 17:09:40.401298 content.go:179: [Info] Request Params:#0000000900000008 - 172.16.0.20:3000 <-> 192.168.1.21:15416 - GET http://192.168.1.94:1282/api/search/info
2024/11/22 17:09:40.401635 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
17:09:40 | 200 |     445.521µs | 192.168.1.21 | GET | /api/search/info | -
17:09:40 | 200 |     522.258µs | 192.168.1.21 | GET | /api/search/info | -
17:09:40 | 200 |     644.259µs | 192.168.1.21 | GET | /api/search/info | -
17:09:40 | 200 |     110.416µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:09:40 | 200 |     134.738µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:09:40 | 200 |     172.944µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/22 17:09:46.088494 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/22 17:09:46.330864 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of   20.50MiB at  Unknown B/s ETA Unknown
2024/11/22 17:09:47.136443 network.go:346: [Info] MESSAGE VALUE: [download]  97.8% of   20.50MiB at    4.89MiB/s ETA 00:00
2024/11/22 17:09:47.186294 network.go:346: [Info] MESSAGE VALUE: [download] 100% of   20.50MiB in 00:00:01 at 19.22MiB/s
2024/11/22 17:09:47.242115 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of    3.00MiB at  924.47KiB/s ETA 00:03
2024/11/22 17:09:47.328586 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.00MiB in 00:00:00 at 21.37MiB/s
2024/11/22 17:09:47.721425 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.00MiB in 00:00:00 at 21.37MiB/s
2024/11/22 17:09:47.721445 network.go:351: [Info] Error Reading:EOF
2024/11/22 17:09:47.721458 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/22 17:09:48.405822 content.go:179: [Info] Request Params:#000000090000000A - 172.16.0.20:3000 <-> 192.168.1.21:15416 - GET http://192.168.1.94:1282/api/search/info
17:09:48 | 200 |     504.762µs | 192.168.1.21 | GET | /api/search/info | -
2024/11/22 17:09:48.406228 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
17:09:48 | 200 |     585.329µs | 192.168.1.21 | GET | /api/search/info | -
17:09:48 | 200 |     704.023µs | 192.168.1.21 | GET | /api/search/info | -
17:09:48 | 200 |      80.698µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:09:48 | 200 |       99.19µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:09:48 | 200 |     133.732µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/22 17:09:54.322165 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/22 17:09:54.503679 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of  329.37MiB at  Unknown B/s ETA Unknown
2024/11/22 17:09:55.415924 network.go:346: [Info] MESSAGE VALUE: [download]   8.4% of  329.37MiB at   42.71MiB/s ETA 00:07
2024/11/22 17:09:56.357734 network.go:346: [Info] MESSAGE VALUE: [download]  14.8% of  329.37MiB at   17.50MiB/s ETA 00:16
2024/11/22 17:09:57.377909 network.go:346: [Info] MESSAGE VALUE: [download]  23.7% of  329.37MiB at   10.40MiB/s ETA 00:24
2024/11/22 17:09:58.373243 network.go:346: [Info] MESSAGE VALUE: [download]  33.0% of  329.37MiB at   37.43MiB/s ETA 00:05
2024/11/22 17:09:59.363602 network.go:346: [Info] MESSAGE VALUE: [download]  40.7% of  329.37MiB at   26.07MiB/s ETA 00:07
2024/11/22 17:10:00.655095 network.go:346: [Info] MESSAGE VALUE: [download]  49.6% of  329.37MiB at   14.58MiB/s ETA 00:11
2024/11/22 17:10:01.402636 network.go:346: [Info] MESSAGE VALUE: [download]  55.5% of  329.37MiB at   44.31MiB/s ETA 00:03
2024/11/22 17:10:02.352879 network.go:346: [Info] MESSAGE VALUE: [download]  63.0% of  329.37MiB at   34.34MiB/s ETA 00:03
2024/11/22 17:10:03.348033 network.go:346: [Info] MESSAGE VALUE: [download]  71.2% of  329.37MiB at   37.12MiB/s ETA 00:02
2024/11/22 17:10:04.374733 network.go:346: [Info] MESSAGE VALUE: [download]  81.9% of  329.37MiB at   40.47MiB/s ETA 00:01
2024/11/22 17:10:05.382726 network.go:346: [Info] MESSAGE VALUE: [download]  91.3% of  329.37MiB at  Unknown B/s ETA Unknown
2024/11/22 17:10:06.725947 network.go:346: [Info] MESSAGE VALUE: [download]  96.7% of  329.37MiB at    7.39MiB/s ETA 00:01
2024/11/22 17:10:07.229063 network.go:346: [Info] MESSAGE VALUE: [download] 100% of  329.37MiB in 00:00:12 at 25.57MiB/s
2024/11/22 17:10:07.312308 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of    3.40MiB at  694.19KiB/s ETA 00:05
2024/11/22 17:10:07.404765 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.40MiB in 00:00:00 at 19.49MiB/s
2024/11/22 17:10:08.162842 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.40MiB in 00:00:00 at 19.49MiB/s
2024/11/22 17:10:08.162860 network.go:351: [Info] Error Reading:EOF
2024/11/22 17:10:08.162889 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/22 17:10:09.423119 content.go:179: [Info] Request Params:#000000090000000C - 172.16.0.20:3000 <-> 192.168.1.21:15416 - GET http://192.168.1.94:1282/api/search/info
17:10:09 | 200 |     148.634µs | 192.168.1.21 | GET | /api/search/info | -
17:10:09 | 200 |     173.237µs | 192.168.1.21 | GET | /api/search/info | -
2024/11/22 17:10:09.423227 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
17:10:09 | 200 |     218.885µs | 192.168.1.21 | GET | /api/search/info | -
17:10:09 | 200 |     120.057µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:10:09 | 200 |     145.711µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:10:09 | 200 |     189.009µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/22 17:10:14.873662 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/22 17:10:15.092143 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/22 17:10:15.092164 network.go:351: [Info] Error Reading:EOF
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/22 17:10:15.092175 service.go:88: [Info] VideoById -1: no such table: tblVideos
2024/11/22 17:10:16.427096 content.go:179: [Info] Request Params:#000000090000000E - 172.16.0.20:3000 <-> 192.168.1.21:15416 - GET http://192.168.1.94:1282/api/search/info
17:10:16 | 200 |     149.107µs | 192.168.1.21 | GET | /api/search/info | -
17:10:16 | 200 |     171.465µs | 192.168.1.21 | GET | /api/search/info | -
17:10:16 | 200 |     215.079µs | 192.168.1.21 | GET | /api/search/info | -
2024/11/22 17:10:16.427208 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
17:10:16 | 200 |      77.336µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:10:16 | 200 |     106.821µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:10:16 | 200 |     149.389µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/22 17:10:22.618483 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/22 17:10:22.834542 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/22 17:10:22.834570 network.go:351: [Info] Error Reading:EOF
2024/11/22 17:10:22.834581 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/22 17:10:24.135001 content.go:179: [Info] Request Params:#0000000900000010 - 172.16.0.20:3000 <-> 192.168.1.21:15416 - GET http://192.168.1.94:1282/api/search/info
2024/11/22 17:10:24.135396 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
17:10:23 | 200 |     689.871µs | 192.168.1.21 | GET | /api/search/info | -
17:10:23 | 200 |     769.899µs | 192.168.1.21 | GET | /api/search/info | -
17:10:23 | 200 |     910.693µs | 192.168.1.21 | GET | /api/search/info | -
2024/11/22 17:12:08.932378 content.go:31: [Info] Request Params:#0000000900000011 - 172.16.0.20:3000 <-> 192.168.1.21:15416 - GET http://192.168.1.94:1282/api/homepage/playlists
2024/11/22 17:12:08.932755 content.go:42: [Info] error fetching all playlistserror fetching playlists: no such table: tblPlaylists
17:12:08 | 200 |    3.015184ms | 192.168.1.21 | GET | /api/homepage/playlists | -
17:12:08 | 200 |    3.102098ms | 192.168.1.21 | GET | /api/homepage/playlists | -
17:12:08 | 200 |    3.229047ms | 192.168.1.21 | GET | /api/homepage/playlists | -
2024/11/22 17:12:10.687319 content.go:15: [Info] Request Params:#0000000900000012 - 172.16.0.20:3000 <-> 192.168.1.21:15416 - GET http://192.168.1.94:1282/api/homepage/videos
2024/11/22 17:12:10.687846 content.go:23: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
17:12:10 | 200 |     626.394µs | 192.168.1.21 | GET | /api/homepage/videos | -
17:12:10 | 200 |      683.94µs | 192.168.1.21 | GET | /api/homepage/videos | -
17:12:10 | 200 |     817.399µs | 192.168.1.21 | GET | /api/homepage/videos | -
17:12:11 | 200 |     428.324µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:12:11 | 200 |     525.768µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:12:11 | 200 |     673.579µs | 192.168.1.21 | GET | /api/download/queued-items | -
17:12:11 | 101 |     278.758µs | 192.168.1.21 | GET | /ws/status | -
@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 24, 2024

Hey Jana,

The path on your machine for the second volume in streamsphere and the volume in content require to be the same! I have made the fix in the docker compose below. Please try it out and let me know if this works for you? :-)

for the downloaded media, based on how yt-dlp works, it is likely that the downloaded videos should have been in /app/cmd which was not mounted to a permanent volume and should have been deleted when the running streamsphere container stopped.

I would also suggest that you remove the existing docker volumes and, containers and start afresh!

Thanks for providing the detailed logs and apologies for the late reply!

services:
  streamsphere:
    image: streamsphere/streamsphere:latest
    # image: streamsphere/streamsphere:latest-arm
    container_name: streamsphere
    restart: unless-stopped
    ports:
      - 1282:3000
    environment:
      HOST_IP: "192.168.1.94"
      APPLICATION_PORT: "1282"
      CONTENT_PORT: "1288"
    volumes:
      - /srv/dev-disk-by-uuid-5b67514d-485e-4306-873e-b1cbb54ccf99/Config/streamsphere/db-data:/app/database/db
      - /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere:/app/content
  content:
    image: streamsphere/streamsphere-content:latest
    # image: streamsphere/streamsphere-content:latest-arm
    container_name: streamsphere-content
    restart: unless-stopped
    ports:
      - 1288:3500
    volumes:
      - /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere:/content
networks:
  default:
    external:
      name: omv1

@rs-anantmishra rs-anantmishra self-assigned this Nov 24, 2024
@rs-anantmishra rs-anantmishra moved this to In Progress in Streamsphere Nov 24, 2024
@janaxhell
Copy link
Author

janaxhell commented Nov 24, 2024

Hi,
I've changed the binds to the same folder like this

    volumes:
      - /srv/dev-disk-by-uuid-5b67514d-485e-4306-873e-b1cbb54ccf99/Config/streamsphere/db-data:/app/database/db
      - /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere/content:/app/content
  content:
    image: streamsphere/streamsphere-content:latest
    # image: streamsphere/streamsphere-content:latest-arm
    container_name: streamsphere-content
    restart: unless-stopped
    ports:
      - 1288:3500
    volumes:
      - /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere/content:/content

but now the only thing that has changed is that I see the thumbnails while downloading (I didn't see any previously), but all that physically appears in the folder are the thumbnails. The app clearly shows the megabytes of the video downloading, but only a thumb is stored.
Also, with previous compose thumbnails ended in the /config folder, now they are in the /content folder

?                   Fiber v2.52.5                   ? 
?               http://127.0.0.1:3000               ? 
?       (bound on host 0.0.0.0 and port 3000)       ? 
?                                                   ? 
? Handlers ............ 35  Processes ........... 1 ? 
? Prefork ....... Disabled  PID ................ 11 ? 
????????????????????????????????????????????????????? 
08:30:27 | 200 |     120.341µs | 192.168.1.21 | GET | / | -
2024/11/24 08:30:28.410752 content.go:179: [Info] Request Params:#0000000100000002 - 172.16.0.4:3000 <-> 192.168.1.21:54069 - GET http://192.168.1.94:1282/api/search/info
08:30:28 | 200 |     284.765µs | 192.168.1.21 | GET | /api/search/info | -
08:30:28 | 200 |     306.969µs | 192.168.1.21 | GET | /api/search/info | -
08:30:28 | 200 |     362.813µs | 192.168.1.21 | GET | /api/search/info | -
2024/11/24 08:30:28.410881 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
2024/11/24 08:30:28.413063 content.go:179: [Info] Request Params:#0000000200000001 - 172.16.0.4:3000 <-> 192.168.1.21:54070 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 08:30:28.413173 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
08:30:28 | 200 |     196.466µs | 192.168.1.21 | GET | /api/search/info | -
08:30:28 | 200 |     218.082µs | 192.168.1.21 | GET | /api/search/info | -
08:30:28 | 200 |      289.27µs | 192.168.1.21 | GET | /api/search/info | -
08:30:28 | 200 |     492.276µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:30:28 | 200 |     540.546µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:30:28 | 200 |     586.846µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:30:28 | 101 |     109.615µs | 192.168.1.21 | GET | /ws/status | -
2024/11/24 08:30:31.559460 ingest.go:34: [Info] Request Params:&{https://www.youtube.com/playlist?list=PLa4DEu_EKtlZFsVaMQ1zEpjitdz2I4ZyF false false}
2024/11/24 08:30:40.630964 network.go:314: [Info] Error Reading:EOF
error: no such table: tblChannels
error: no such table: tblPlaylists
error: no such table: tblDomains
error: no such table: tblFormats
error: no such table: tblVideos
error: no such table: tblPlaylistVideoFiles
error: no such table: tblCategories
error: no such table: tblVideoFileCategories
error: no such table: tblChannels
error: no such table: tblPlaylists
error: no such table: tblDomains
error: no such table: tblFormats
error: no such table: tblVideos
error: no such table: tblPlaylistVideoFiles
error: no such table: tblCategories
error: no such table: tblVideoFileCategories
2024/11/24 08:30:48.286550 network.go:314: [Info] Error Reading:EOF
2024/11/24 08:30:48.515252 network.go:314: [Info] Error Reading:EOF
error: no such table: tblFiles
08:30:31 | 200 | 16.956692009s | 192.168.1.21 | POST | /api/download/metadata | -
08:30:31 | 200 | 16.956714838s | 192.168.1.21 | POST | /api/download/metadata | -
08:30:31 | 200 | 16.956743835s | 192.168.1.21 | POST | /api/download/metadata | -
08:30:48 | 200 |     117.544µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:30:48 | 200 |     141.982µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:30:48 | 200 |     181.194µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/24 08:30:48.529892 content.go:179: [Info] Request Params:#0000000200000005 - 172.16.0.4:3000 <-> 192.168.1.21:54070 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 08:30:48.530016 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
08:30:48 | 200 |     257.239µs | 192.168.1.21 | GET | /api/search/info | -
08:30:48 | 200 |     278.776µs | 192.168.1.21 | GET | /api/search/info | -
08:30:48 | 200 |     318.265µs | 192.168.1.21 | GET | /api/search/info | -
08:30:48 | 101 |     146.302µs | 192.168.1.21 | GET | /ws/status | -
2024/11/24 08:30:54.110615 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/24 08:30:54.210314 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of  255.61MiB at  Unknown B/s ETA Unknown
2024/11/24 08:30:55.169269 network.go:346: [Info] MESSAGE VALUE: [download]  15.1% of  255.61MiB at   46.45MiB/s ETA 00:04
2024/11/24 08:30:56.147300 network.go:346: [Info] MESSAGE VALUE: [download]  26.7% of  255.61MiB at  Unknown B/s ETA Unknown
2024/11/24 08:30:57.148298 network.go:346: [Info] MESSAGE VALUE: [download]  43.6% of  255.61MiB at   55.49MiB/s ETA 00:02
2024/11/24 08:30:58.217391 network.go:346: [Info] MESSAGE VALUE: [download]  59.0% of  255.61MiB at   34.78MiB/s ETA 00:03
2024/11/24 08:30:59.189238 network.go:346: [Info] MESSAGE VALUE: [download]  72.1% of  255.61MiB at   34.72MiB/s ETA 00:02
2024/11/24 08:31:00.144721 network.go:346: [Info] MESSAGE VALUE: [download]  85.9% of  255.61MiB at   31.77MiB/s ETA 00:01
2024/11/24 08:31:01.254671 network.go:346: [Info] MESSAGE VALUE: [download] 100% of  255.61MiB in 00:00:07 at 35.94MiB/s
2024/11/24 08:31:01.269117 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of    3.69MiB at  Unknown B/s ETA Unknown
2024/11/24 08:31:01.309156 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.69MiB in 00:00:00 at 68.65MiB/s
2024/11/24 08:31:02.025006 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.69MiB in 00:00:00 at 68.65MiB/s
2024/11/24 08:31:02.025033 network.go:351: [Info] Error Reading:EOF
2024/11/24 08:31:02.025047 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/24 08:31:03.296271 content.go:179: [Info] Request Params:#0000000200000006 - 172.16.0.4:3000 <-> 192.168.1.21:54070 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 08:31:03.296390 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
08:31:03 | 200 |     157.737µs | 192.168.1.21 | GET | /api/search/info | -
08:31:03 | 200 |     177.015µs | 192.168.1.21 | GET | /api/search/info | -
08:31:03 | 200 |     219.729µs | 192.168.1.21 | GET | /api/search/info | -
08:31:04 | 200 |     118.123µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:31:04 | 200 |     149.196µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:31:04 | 200 |     187.844µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:31:04 | 200 |     120.335µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:31:04 | 200 |      146.93µs | 192.168.1.21 | GET | /api/download/queued-items | -
08:31:04 | 200 |     196.462µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/24 08:31:08.642011 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/24 08:31:08.743315 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of  178.88MiB at  778.31KiB/s ETA 03:57
2024/11/24 08:31:09.675076 network.go:346: [Info] MESSAGE VALUE: [download]  21.7% of  178.88MiB at   46.18MiB/s ETA 00:03
2024/11/24 08:31:10.704548 network.go:346: [Info] MESSAGE VALUE: [download]  43.8% of  178.88MiB at   19.58MiB/s ETA 00:05
2024/11/24 08:31:11.679458 network.go:346: [Info] MESSAGE VALUE: [download]  64.9% of  178.88MiB at  Unknown B/s ETA Unknown
2024/11/24 08:31:12.731568 network.go:346: [Info] MESSAGE VALUE: [download]  91.0% of  178.88MiB at   52.58MiB/s ETA 00:00
2024/11/24 08:31:13.540154 network.go:346: [Info] MESSAGE VALUE: [download] 100% of  178.88MiB in 00:00:04 at 36.73MiB/s
2024/11/24 08:31:13.552857 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of    3.40MiB at  Unknown B/s ETA Unknown
2024/11/24 08:31:13.610898 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.40MiB in 00:00:00 at 48.54MiB/s
2024/11/24 08:31:14.191175 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.40MiB in 00:00:00 at 48.54MiB/s
2024/11/24 08:31:14.191196 network.go:351: [Info] Error Reading:EOF
2024/11/24 08:31:14.191209 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/24 08:31:15.305456 content.go:179: [Info] Request Params:#0000000100000004 - 172.16.0.4:3000 <-> 192.168.1.21:54069 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 08:31:15.305572 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
08:31:15 | 200 |      145.66µs | 192.168.1.21 | GET | /api/search/info | -
08:31:15 | 200 |      169.17µs | 192.168.1.21 | GET | /api/search/info | -
08:31:15 | 200 |     212.615µs | 192.168.1.21 | GET | /api/search/info | -

BTW, It's Jan ;-)

@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 24, 2024

Hey Jan, :)

thanks for the update! It seems like one error is fixed and thumbs are going into the right location.
Could you please confirm if the videos are also getting stored in the parent folder for the thumbnails?

I really appreciate your time and efforts on this! :-)
Thank you!

Update: If the video files are also being stored in the content directory, kindly try the following -

for the error that we have now, it looks like the database is not in place for the application, although it is shipped initialized within the docker image itself.

This could be because the bind-mount did not bind correctly onto the physical location.
Can you try the below steps, (this would really help identify the problem) -

  1. Login to the container via shell (docker exec -it streamsphere /bin/bash)
  2. Install sqlite3 (apt install sqlite3 -y)
  3. Change directory to /app/database/db (cd /app/database/db)
  4. Create the database (sqlite3 streamsphere.db < ../scripts/create.sql)
  5. Initialize the db (sqlite3 streamsphere.db < ../scripts/seed.sql)
  6. exit from the container shell (exit)

Once the database is in place, do try to download through the streamsphere now and it should work!

@janaxhell
Copy link
Author

No, as of now, no video is to be found anywhere, only the thumbnails are stored into

/content/youtube.com/[name of playlist]/Videos/Thumbnails/*.webp

/Videos folder contains nothing but the /Thumbnails subfolder.
The database is located in

/srv/dev-disk-by-uuid-5b67514d-485e-4306-873e-b1cbb54ccf99/Config/streamsphere/db-data/streamsphere.db

but it is 0 Bytes in size, so nothing seems to be saved to it after job is done. It's been created by the app as soon as it started.

Should I do the steps anyway?

@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 24, 2024

No no, pls dont perform the steps since the video files are not in place.
The data base is being created by the application which is incorrect, thats why it is 0 bytes.

Can you pls try to remove the streamsphere & streamsphere-content containers, their images, and the docker bind-mounts as well and then try again with the "docker compose up -d".

The path for the videos is in the golang binary file, the videos should be downloaded into the /content/youtube.com/[name of playlist]/Videos/ directory.

Also just to confirm you are using an AMD64 machine or ARM64?

@janaxhell
Copy link
Author

Ok, I have erased everything, including images, containersm, etc and redeployed from scratch.
Now all I see is:

http://192.168.1.94:1282
http://192.168.1.94:1282
http://192.168.1.94:1288
Connected to database.

 ┌───────────────────────────────────────────────────┐ 
 │                   Streamsphere                    │ 
 │                   Fiber v2.52.5                   │ 
 │               http://127.0.0.1:3000               │ 
 │       (bound on host 0.0.0.0 and port 3000)       │ 
 │                                                   │ 
 │ Handlers ............ 35  Processes ........... 1 │ 
 │ Prefork ....... Disabled  PID ................ 11 │ 
 └───────────────────────────────────────────────────┘ 

and the app doesn't move from there, nor I can open any UI. Tried to restart, but it just repeated the same behavior.
A 0-bytes .db file has been created, as well as a /content folder, but I cannot use it in any way.
Yes, I use AMD64 and I do everything from Portainer, my machine runs Open Media Vault 6.

@rs-anantmishra
Copy link
Owner

Hi Jan,

This is quite unexpected! let me get back to you in sometime, I will make an omv6 + portainer installation and try to replicate the issue you are facing. Sorry for the troubles! and I really appreciate your time and effort on this! :)

@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 24, 2024

Hey,

If you can make just one last try, and I understand its asking a bit too much but can you pls remove container, bind mount, images and once try with the following docker-compose:

services:
  streamsphere:
    image: streamsphere/streamsphere:latest
    container_name: streamsphere
    restart: unless-stopped
    ports:
      - 1282:3000
    environment:
      HOST_IP: "192.168.1.94"
      APPLICATION_PORT: "1282"
      CONTENT_PORT: "1288"
    volumes:
      - db-data:/app/database/db
      - content-data:/app/content
  content:
    image: streamsphere/streamsphere-content:latest
    container_name: streamsphere-content
    restart: unless-stopped
    ports:
      - 1288:3500
    volumes:
      - content-data:/content
volumes:
  db-data:
  content-data:
networks:
  default:
    external:
      name: omv1

Thank you! If you're not able to do this test I will totally understand!

@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 24, 2024

Hey, no worries!
The latest-arm is commented out. I'll update the docker compose to remove that line to avoid confusion. :)

Update: So, I've just updated the docker compose to use named volumes instead of bind mounts..

@janaxhell
Copy link
Author

janaxhell commented Nov 24, 2024

Yes yes, noticed soon after posting. Ok, tried this, but something wrong happened after the last time I deleted everything. I cannot open UI:

This site can’t be reached
The connection was reset.
Try:

Checking the connection
[Checking the proxy and the firewall](chrome-error://chromewebdata/#buttons)
[Running Windows Network Diagnostics](javascript:diagnoseErrors())
ERR_CONNECTION_RESET

And the app is stuck to the above picture. I have deployed your compose as-is, untouched.

EDIT
Got it: cookies. After deleting them I can open UI.

@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 24, 2024

Owh nice! :) Atleast we are where we were before!

@janaxhell
Copy link
Author

janaxhell commented Nov 24, 2024

Ok, I have downloaded a couple of videos and I can see them from Videos UI tab.
But I don't like volumes, I want to use folders to access files directly, if needed.

EDIT Maybe Streamsphere needs to assign rights to /content folder?

@rs-anantmishra
Copy link
Owner

I can totally understand, this effort just helps us understand the issue! and as I see your edit, I agree, this definitely has something to do with rights. Let me check on this and get back to you. :)

Thank you!

@janaxhell
Copy link
Author

No problem, but I'll be away for a few hours, cheers.

@rs-anantmishra
Copy link
Owner

No worries, pls reply back with your convenience! Cheers!

@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 24, 2024

Hi Jan,

Please stop and remove the volumes and containers, keeping the images should be fine though, after that pls try setting the rights to the directories on host machine to 666 with below commands -

chmod 666 /srv/dev-disk-by-uuid-5b67514d-485e-4306-873e-b1cbb54ccf99/Config/streamsphere/db-data -R
chmod 666 /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere -R

start the containers with docker compose up at this point.

Please let me know if this fixes your problem!
Thanks! :)

@rs-anantmishra rs-anantmishra added help wanted Extra attention is needed setup assistance Assist user to setup on their infrastructure and removed help wanted Extra attention is needed labels Nov 24, 2024
@janaxhell
Copy link
Author

janaxhell commented Nov 24, 2024

Done, but as before videos are nowhere to be found, despite having bind the folders. Also this time videos are not even present in the Videos UI tab.
Is it possible that the container need to assign PUID/PGID to OMV admin (which in my case is 998:100) ?
Many times I saw problems like this resolving by setting those env's.

@rs-anantmishra
Copy link
Owner

Hey Jan,

That is definitely worth a try!!
If the container is run as an administrator, there's a good chance that it will resolve the issue!

Do let me know if that works!!

Thank You!

@janaxhell
Copy link
Author

I have added PUID and PGID env, but unfortunately this produced no effect, no video is visible in any folder, nor in the Videos UI tab.

This is the log

http://192.168.1.94:1282
http://192.168.1.94:1282
http://192.168.1.94:1288
Connected to database.
 ????????????????????????????????????????????????????? 
 ?                   Streamsphere                    ? 
 ?                   Fiber v2.52.5                   ? 
 ?               http://127.0.0.1:3000               ? 
 ?       (bound on host 0.0.0.0 and port 3000)       ? 
 ?                                                   ? 
 ? Handlers ............ 35  Processes ........... 1 ? 
 ? Prefork ....... Disabled  PID ................ 11 ? 
 ????????????????????????????????????????????????????? 
2024/11/24 22:24:25.923500 content.go:179: [Info] Request Params:#0000000100000001 - 172.16.0.4:3000 <-> 192.168.1.21:11394 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 22:24:25.923940 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
22:24:25 | 200 |    1.074018ms | 192.168.1.21 | GET | /api/search/info | -
22:24:25 | 200 |     1.18044ms | 192.168.1.21 | GET | /api/search/info | -
22:24:25 | 200 |    1.477153ms | 192.168.1.21 | GET | /api/search/info | -
2024/11/24 22:24:25.926618 content.go:179: [Info] Request Params:#0000000200000001 - 172.16.0.4:3000 <-> 192.168.1.21:11395 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 22:24:25.926932 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
22:24:25 | 200 |     472.748µs | 192.168.1.21 | GET | /api/search/info | -
22:24:25 | 200 |     528.328µs | 192.168.1.21 | GET | /api/search/info | -
22:24:25 | 200 |     673.858µs | 192.168.1.21 | GET | /api/search/info | -
22:24:25 | 200 |    1.268312ms | 192.168.1.21 | GET | /api/download/queued-items | -
22:24:25 | 200 |    1.367956ms | 192.168.1.21 | GET | /api/download/queued-items | -
22:24:25 | 200 |    1.507823ms | 192.168.1.21 | GET | /api/download/queued-items | -
22:24:26 | 101 |      283.18µs | 192.168.1.21 | GET | /ws/status | -
22:24:36 | 200 |     350.301µs | 192.168.1.21 | GET | / | -
22:24:36 | 200 |     235.177µs | 192.168.1.21 | GET | /themes/aura-dark-blue/theme.css | -
22:24:36 | 200 |     168.249µs | 192.168.1.21 | GET | /styles-4R7UPK3F.css | -
22:24:36 | 200 |      221.44µs | 192.168.1.21 | GET | /chunk-A7WYG7VQ.js | -
22:24:36 | 200 |     179.741µs | 192.168.1.21 | GET | /polyfills-Y3LZGLES.js | -
22:24:36 | 200 |     190.292µs | 192.168.1.21 | GET | /main-CDA5FTVF.js | -
22:24:37 | 200 |     259.788µs | 192.168.1.21 | GET | /scripts-F47BY6XV.js | -
22:24:37 | 200 |     213.967µs | 192.168.1.21 | GET | /themes/aura-dark-blue/fonts/Inter-roman.var.woff2 | -
2024/11/24 22:24:37.758207 content.go:179: [Info] Request Params:#0000000500000004 - 172.16.0.4:3000 <-> 192.168.1.21:11407 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 22:24:37.758681 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
22:24:37 | 200 |     787.885µs | 192.168.1.21 | GET | /api/search/info | -
22:24:37 | 200 |     865.701µs | 192.168.1.21 | GET | /api/search/info | -
22:24:37 | 200 |      994.34µs | 192.168.1.21 | GET | /api/search/info | -
2024/11/24 22:24:37.759286 content.go:179: [Info] Request Params:#0000000200000006 - 172.16.0.4:3000 <-> 192.168.1.21:11395 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 22:24:37.759560 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
22:24:37 | 200 |     343.398µs | 192.168.1.21 | GET | /api/search/info | -
22:24:37 | 200 |     408.047µs | 192.168.1.21 | GET | /api/search/info | -
22:24:37 | 200 |     529.116µs | 192.168.1.21 | GET | /api/search/info | -
22:24:37 | 200 |      188.03µs | 192.168.1.21 | GET | /assets/smol-sphere.gif | -
22:24:37 | 200 |      508.35µs | 192.168.1.21 | GET | /api/download/queued-items | -
22:24:37 | 200 |     619.522µs | 192.168.1.21 | GET | /api/download/queued-items | -
22:24:37 | 200 |     762.631µs | 192.168.1.21 | GET | /api/download/queued-items | -
22:24:37 | 200 |      180.08µs | 192.168.1.21 | GET | /assets/noimage.png | -
22:24:37 | 200 |      184.38µs | 192.168.1.21 | GET | /media/primeicons-4GST5W3O.woff2 | -
22:24:37 | 101 |     273.764µs | 192.168.1.21 | GET | /ws/status | -
22:24:37 | 200 |     213.631µs | 192.168.1.21 | GET | /assets/favicon.png | -
2024/11/24 22:24:47.416580 ingest.go:34: [Info] Request Params:&{https://www.youtube.com/playlist?list=PLa4DEu_EKtlZFsVaMQ1zEpjitdz2I4ZyF false false}
2024/11/24 22:24:55.997050 network.go:314: [Info] Error Reading:EOF
error: no such table: tblChannels
error: no such table: tblPlaylists
error: no such table: tblDomains
error: no such table: tblFormats
error: no such table: tblVideos
error: no such table: tblPlaylistVideoFiles
error: no such table: tblCategories
error: no such table: tblVideoFileCategories
error: no such table: tblChannels
error: no such table: tblPlaylists
error: no such table: tblDomains
error: no such table: tblFormats
error: no such table: tblVideos
error: no such table: tblPlaylistVideoFiles
error: no such table: tblCategories
error: no such table: tblVideoFileCategories
2024/11/24 22:25:01.882307 network.go:314: [Info] Error Reading:EOF
2024/11/24 22:25:02.130628 network.go:314: [Info] Error Reading:EOF
error: no such table: tblFiles
error: no such table: tblFiles
22:24:47 | 200 | 14.715418364s | 192.168.1.21 | POST | /api/download/metadata | -
22:24:47 | 200 | 14.715451092s | 192.168.1.21 | POST | /api/download/metadata | -
22:24:47 | 200 | 14.715499458s | 192.168.1.21 | POST | /api/download/metadata | -
22:25:01 | 200 |     126.444µs | 192.168.1.21 | GET | /api/download/queued-items | -
22:25:01 | 200 |     154.789µs | 192.168.1.21 | GET | /api/download/queued-items | -
22:25:01 | 200 |     212.214µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/24 22:25:02.146412 content.go:179: [Info] Request Params:#000000020000000D - 172.16.0.4:3000 <-> 192.168.1.21:11395 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 22:25:02.146582 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
22:25:01 | 200 |     211.574µs | 192.168.1.21 | GET | /api/search/info | -
22:25:01 | 200 |     354.859µs | 192.168.1.21 | GET | /api/search/info | -
22:25:01 | 200 |     461.134µs | 192.168.1.21 | GET | /api/search/info | -
22:25:02 | 101 |      76.365µs | 192.168.1.21 | GET | /ws/status | -
2024/11/24 22:25:07.629984 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/24 22:25:07.758797 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of  255.61MiB at  Unknown B/s ETA Unknown
2024/11/24 22:25:08.752392 network.go:346: [Info] MESSAGE VALUE: [download]  11.9% of  255.61MiB at    9.96MiB/s ETA 00:22
2024/11/24 22:25:09.664289 network.go:346: [Info] MESSAGE VALUE: [download]  26.7% of  255.61MiB at   33.43MiB/s ETA 00:05
2024/11/24 22:25:10.670844 network.go:346: [Info] MESSAGE VALUE: [download]  38.5% of  255.61MiB at   10.27MiB/s ETA 00:15
2024/11/24 22:25:11.664734 network.go:346: [Info] MESSAGE VALUE: [download]  50.3% of  255.61MiB at   11.97MiB/s ETA 00:10
2024/11/24 22:25:12.749934 network.go:346: [Info] MESSAGE VALUE: [download]  61.9% of  255.61MiB at   15.50MiB/s ETA 00:06
2024/11/24 22:25:13.667777 network.go:346: [Info] MESSAGE VALUE: [download]  72.7% of  255.61MiB at  Unknown B/s ETA Unknown
2024/11/24 22:25:14.674149 network.go:346: [Info] MESSAGE VALUE: [download]  84.2% of  255.61MiB at  Unknown B/s ETA Unknown
2024/11/24 22:25:15.707177 network.go:346: [Info] MESSAGE VALUE: [download]  97.1% of  255.61MiB at   37.86MiB/s ETA 00:00
2024/11/24 22:25:16.433295 network.go:346: [Info] MESSAGE VALUE: [download] 100% of  255.61MiB in 00:00:08 at 29.14MiB/s
2024/11/24 22:25:16.455405 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of    3.69MiB at  Unknown B/s ETA Unknown
2024/11/24 22:25:16.514083 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.69MiB in 00:00:00 at 46.70MiB/s
2024/11/24 22:25:17.160461 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.69MiB in 00:00:00 at 46.70MiB/s
2024/11/24 22:25:17.160482 network.go:351: [Info] Error Reading:EOF
2024/11/24 22:25:17.160506 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/24 22:25:17.924702 content.go:179: [Info] Request Params:#000000020000000E - 172.16.0.4:3000 <-> 192.168.1.21:11395 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 22:25:17.925046 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
22:25:17 | 200 |     480.018µs | 192.168.1.21 | GET | /api/search/info | -
22:25:17 | 200 |     564.476µs | 192.168.1.21 | GET | /api/search/info | -
22:25:17 | 200 |      702.52µs | 192.168.1.21 | GET | /api/search/info | -
22:25:18 | 200 |     146.264µs | 192.168.1.21 | GET | /api/download/queued-items | -
22:25:18 | 200 |     182.664µs | 192.168.1.21 | GET | /api/download/queued-items | -
22:25:18 | 200 |     222.203µs | 192.168.1.21 | GET | /api/download/queued-items | -
2024/11/24 22:25:23.508199 network.go:346: [Info] MESSAGE VALUE: WARNING: --paths is ignored since an absolute path is given in output template
2024/11/24 22:25:23.610449 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of  178.88MiB at  Unknown B/s ETA Unknown
2024/11/24 22:25:24.589938 network.go:346: [Info] MESSAGE VALUE: [download]  20.7% of  178.88MiB at   46.02MiB/s ETA 00:03
2024/11/24 22:25:25.581229 network.go:346: [Info] MESSAGE VALUE: [download]  40.2% of  178.88MiB at   43.67MiB/s ETA 00:02
2024/11/24 22:25:26.559566 network.go:346: [Info] MESSAGE VALUE: [download]  56.6% of  178.88MiB at   27.94MiB/s ETA 00:02
2024/11/24 22:25:27.568701 network.go:346: [Info] MESSAGE VALUE: [download]  70.7% of  178.88MiB at   20.62MiB/s ETA 00:02
2024/11/24 22:25:28.652190 network.go:346: [Info] MESSAGE VALUE: [download]  86.0% of  178.88MiB at   18.54MiB/s ETA 00:01
2024/11/24 22:25:29.535999 network.go:346: [Info] MESSAGE VALUE: [download] 100% of  178.88MiB in 00:00:06 at 29.81MiB/s
2024/11/24 22:25:29.558984 network.go:346: [Info] MESSAGE VALUE: [download]   0.0% of    3.40MiB at  Unknown B/s ETA Unknown
2024/11/24 22:25:29.627179 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.40MiB in 00:00:00 at 38.05MiB/s
2024/11/24 22:25:30.177616 network.go:346: [Info] MESSAGE VALUE: [download] 100% of    3.40MiB in 00:00:00 at 38.05MiB/s
2024/11/24 22:25:30.177643 network.go:351: [Info] Error Reading:EOF
2024/11/24 22:25:30.177658 service.go:88: [Info] VideoById -1: no such table: tblVideos
pkg dowonload network - ExtractMediaContent open ../content///Videos: no such file or directory
2024/11/24 22:25:30.934014 content.go:179: [Info] Request Params:#0000000200000010 - 172.16.0.4:3000 <-> 192.168.1.21:11395 - GET http://192.168.1.94:1282/api/search/info
2024/11/24 22:25:30.934347 content.go:189: [Info] error fetching all videoserror fetching Videos: no such table: tblVideos
22:25:30 | 200 |     492.159µs | 192.168.1.21 | GET | /api/search/info | -
22:25:30 | 200 |     555.284µs | 192.168.1.21 | GET | /api/search/info | -
22:25:30 | 200 |     656.947µs | 192.168.1.21 | GET | /api/search/info | -

Going offline.

@rs-anantmishra
Copy link
Owner

Wow! Let me reproduce and sort this on an omv setup! I'll get back to you!

@rs-anantmishra
Copy link
Owner

Hey Jan, I tried a couple of combinations with bind mounts unfortunately it never reproduces for me, just wanted to give you an update. This is something very specific, but it clearly has to do with permissions for the docker container.

Thanks!

@janaxhell
Copy link
Author

Did you try with PUID:PGID?
This is the last compose I've tried (for those values I've used the command id admin which is the OMV user of the system.
In my case it's 998/100. Also the reason I use a custom "omv1" network is because I've maxed out the available IPs.

services:
 streamsphere:
   image: streamsphere/streamsphere:latest
   container_name: streamsphere
   restart: unless-stopped
   ports:
     - 1282:3000
   environment:
     HOST_IP: "192.168.1.94"
     APPLICATION_PORT: "1282"
     CONTENT_PORT: "1288"
     PUID: "998"
     PGID: "100"
   volumes:
     - /srv/dev-disk-by-uuid-5b67514d-485e-4306-873e-b1cbb54ccf99/Config/streamsphere/db-data:/app/database/db
     - /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere/content:/app/content
 content:
   image: streamsphere/streamsphere-content:latest
   container_name: streamsphere-content
   restart: unless-stopped
   ports:
     - 1288:3500
   volumes:
     - /srv/dev-disk-by-uuid-BAF04088F0404D37/data/media/streamsphere/content:/content
networks:
 default:
   external:
     name: omv1

@rs-anantmishra
Copy link
Owner

I think the network is alright! I did try with 998/100 and 1000/1000 works perfectly with both, tried a bunch of different combinations of permissions as well, Still no luck, it always worked correctly, I'm not really sure what we could be missing at this point! :/

@rs-anantmishra
Copy link
Owner

Give me some more time, I will research this more, and get back to you!

@janaxhell
Copy link
Author

Don't worry at all, take your time, I'm not a programmer, so I can only make tests.

@Eidenz
Copy link

Eidenz commented Nov 29, 2024

So far I reproduced the bug and did a dirty fix on my install.

It only happens when binding a folder instead of using Docker volume (still need to figure out why).
In a nutshell, when binding a folder directly, the DB is not initialized. Therefore it downloads, fails to do DB stuff to link and finish.

The dirty fix? Initialize db manually:
I opened the streamsphere container and executed those commands:

cd database/db
apt install sqlite3
sqlite3 streamsphere.db < ../scripts/create.sql | bash
sqlite3 streamsphere.db < ../scripts/seed.sql | bash

Now everything works just fine.

@rs-anantmishra
Copy link
Owner

Hey Eidenz,

are you also facing the same problem? are you also using OMV?

@Eidenz
Copy link

Eidenz commented Nov 29, 2024

I am using UNRAID on my end.

As with all things that work in a volume but not with a binding, it is always a permission issue. Might want to specify a user.
I saw the previous user's approach of adding PUID and PGID, but they did it as environment variables.

Might want to try directly with the user flag, like:

services:
  streamsphere:
    user: "1000:1000"

@Eidenz
Copy link

Eidenz commented Nov 29, 2024

I can give a quick try, haven't started pouring my content in yet

@rs-anantmishra
Copy link
Owner

Hey @janaxhell ,

Could you pls try with

 PUID: "1000"
 PGID: "1000"

instead of 998/100, if you're okay with that?

@rs-anantmishra
Copy link
Owner

I can give a quick try, haven't started pouring my content in yet

Pls do try that!!

@Eidenz
Copy link

Eidenz commented Nov 29, 2024

I was unable to fix using that. In fact, it completely fails to create the file now.

I believe something might need to be done on the Dockerfile or something.

FYI, UNRAID and OMW uses special PUID/PGID, which might be why it works on a simple ubuntu but not those two.
For instance, UNRAID uses PUID 99 and PGID 100 while ubuntu would use 1000 for both iirc.

@rs-anantmishra
Copy link
Owner

rs-anantmishra commented Nov 29, 2024

I was unable to fix using that. In fact, it completely fails to create the file now.

I believe something might need to be done on the Dockerfile or something.

FYI, UNRAID and OMW uses special PUID/PGID, which might be why it works on a simple ubuntu but not those two. For instance, UNRAID uses PUID 99 and PGID 100 while ubuntu would use 1000 for both iirc.

Hey @Eidenz,

Thanks for making the test! Yes you're correct, it seems like it's something related to that!
Could you pls check your userid/guid with the below command and try with that uid/gid?

In shell terminal: cat /etc/passwd | grep $(whoami)

Thanks!!

@Eidenz
Copy link

Eidenz commented Nov 29, 2024

That would be 0:0. Users work very differently in UNRAID, would need a read at the forums to understand what's going on there.

And for correction on my previous statement, UNRAID itself doesn't use 99:100. It's just very commonly used for docker containers there.

What I find weird is why the app is able to create the .db file but not initialize its content. It was clearly able to write to it after I did it manually.

@Eidenz
Copy link

Eidenz commented Nov 29, 2024

In that case, maybe a simple fix would be to do like a lot of apps and initialize in your app rather than the Dockerfile.

Like, check for empty db / table not existing and initialize.

@rs-anantmishra
Copy link
Owner

The .db file gets created when the app tries to open it and since its sqlite, it would just create the db!
Yeah I was thinking the same, it might be a solution to check for and create tables when the app starts the first time!

Thanks for your inputs @Eidenz ! This really helps! :-)

@janaxhell
Copy link
Author

Hey @janaxhell ,

Could you pls try with

 PUID: "1000"
 PGID: "1000"

instead of 998/100, if you're okay with that?

Hello anant, sorry, but I've been busy with a major problem with one of my servers.
I have tried the above, but it's always the same: videos are downloaded, but they are nowhere to be found, nor can be played by Streamsphere.

OT: I have a test next tuesday, so I won't be able to try anything on Streamsphere until then.

@rs-anantmishra
Copy link
Owner

Hey @janaxhell

Thanks for trying, I will fix it through code Jan, all the best for your test!! x)

@rs-anantmishra rs-anantmishra added the enhancement New feature or request label Dec 4, 2024
@rs-anantmishra
Copy link
Owner

Changes will be added to address this during application runtime.

  1. Check for existing tables
  2. If tables do not exist, attempt to create it by executing a shell script.
  3. If tables create - resume normal workflow, if failed to create: panic and exit

@toneck
Copy link

toneck commented Dec 27, 2024

Hi there, I have a similar problem and I think I found the problem
After messing for a few days with docker ( I thought I was doing something wrong), the db file would be written without a problem but the video would be missing. In some configuration, the thumbnail would get downloaded, but not the video (the interface would say the video got downloaded, but the filesystem would show only the thumbnail present)
Anyway, I took the docker images and run them in a chroot so I can have direct access to their file system and get rid of the docker overlay and I discovered that the video would get downloaded, but in /Videos.
Eg. thumbnail would get downloaded in /app/content/youtube.com/{channel.name}/Videos/Thumbnails, but the video would end up in /Videos
I presume there is a bug somewhere when generating the path for the video

The same thing happens in docker as well. If I explore the filesystem of streamsphere in docker-desktop, I can see /Videos appearing with the downloaded video inside. Unfortunately, mapping /Videos is not a solution as all videos from all channels end up in there

@toneck
Copy link

toneck commented Dec 27, 2024

After looking around the code and at the files I think the problem may be related to extracting or parsing MediaInfo (SavedInfo). When assembling the path for the file, the domain and channel names from the SavedInfo structure are used to create the directory structure and the video title for the filename. For the thumbnail, there seems to be no problem, but for the Video file, the saved path results in just /Videos and the final filename does not contain the video title, only the ID.
I presume that when calling the buildDownloadPath function, for some reason the savedInfo parameter is empty.

@Eidenz
Copy link

Eidenz commented Dec 27, 2024

Weird conclusion knowing that it works perfectly fine in a docker volume or when you manually create the database file...

See my previous comment on the matter.

So far I reproduced the bug and did a dirty fix on my install.

It only happens when binding a folder instead of using Docker volume (still need to figure out why). In a nutshell, when binding a folder directly, the DB is not initialized. Therefore it downloads, fails to do DB stuff to link and finish.

The dirty fix? Initialize db manually: I opened the streamsphere container and executed those commands:

cd database/db
apt install sqlite3
sqlite3 streamsphere.db < ../scripts/create.sql | bash
sqlite3 streamsphere.db < ../scripts/seed.sql | bash

Now everything works just fine.

@toneck
Copy link

toneck commented Dec 27, 2024

I took the database file from database/db from the repo and placed in in database/db and now it works.
I find it weird that not finding the database results in (my assumption) missing info about the video, but not about the thumbnails

@rs-anantmishra
Copy link
Owner

@toneck Hey, this was concluded to be a permissions issue. It did replicate for me about ~4 days back, this will be properly sorted in the upcoming release. :-)

I do appreciate the time you have spent on the codebase, however, the bizarre outcomes are really because of permissions/db not being setup correctly for some reason when using bind mounts.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request setup assistance Assist user to setup on their infrastructure
Projects
Status: In Progress
Development

No branches or pull requests

4 participants