SVI/ProxmoxVE
1
0
Fork 0
mirror of https://github.com/community-scripts/ProxmoxVE.git synced 2026-03-31 06:34:17 -04:00
Code Issues 2.6k Packages Projects Releases 10 Wiki Activity

PHP extension pdo_sqlite is missing! in the freshrss container #784

New Issue
Closed
opened 2025-11-20 04:53:59 -05:00 by saavagebueno · 9 comments
saavagebueno commented 2025-11-20 04:53:59 -05:00
Owner
Copy Link

Originally created by @Shimakuchi on GitHub (Mar 26, 2025).

📌 Task summary

improve the freshrss container by adding missing php extensions for better db migration

📋 Task details

Hello, I had freshrss running on my unraid server in a docker container and would like to change that now. After the export/import via the UI only worked semi well, I tried to create a database backup via the cli. That seems to have worked.

I moved the backup.sqlite file from the container to my Unraid server, copied it from there to the proxmox server using scp and then pushed it into the lxc. Unfortunately, I then realized that I cannot call the scripts in /opt/freshrss/cli/ because a php extension is missing “PHP extension pdo_sqlite is missing!”

I could imagine that others will also need these scripts sooner or later. It would therefore be nice if this would work.

Thank you very much

Originally created by @Shimakuchi on GitHub (Mar 26, 2025). ### 📌 Task summary improve the freshrss container by adding missing php extensions for better db migration ### 📋 Task details Hello, I had freshrss running on my unraid server in a docker container and would like to change that now. After the export/import via the UI only worked semi well, I tried to create a database backup via the cli. That seems to have worked. I moved the `backup.sqlite` file from the container to my Unraid server, copied it from there to the proxmox server using scp and then pushed it into the lxc. Unfortunately, I then realized that I cannot call the scripts in `/opt/freshrss/cli/` because a php extension is missing “PHP extension pdo_sqlite is missing!” I could imagine that others will also need these scripts sooner or later. It would therefore be nice if this would work. Thank you very much
saavagebueno commented 2025-11-20 04:54:00 -05:00
Author
Owner
Copy Link

@tremor021 commented on GitHub (Mar 26, 2025):

We don't use SQLite in our LXC. We use PostgreSQL as database

@tremor021 commented on GitHub (Mar 26, 2025): We don't use SQLite in our LXC. We use PostgreSQL as database
saavagebueno commented 2025-11-20 04:54:00 -05:00
Author
Owner
Copy Link

@tremor021 commented on GitHub (Mar 27, 2025):

Ohh, sorry i've missread your post. You want us to add SQLite support in the LXC? Right? @Shimakuchi

@bvdberg01

@tremor021 commented on GitHub (Mar 27, 2025): Ohh, sorry i've missread your post. You want us to add SQLite support in the LXC? Right? @Shimakuchi @bvdberg01
saavagebueno commented 2025-11-20 04:54:00 -05:00
Author
Owner
Copy Link

@bvdberg01 commented on GitHub (Mar 29, 2025):

@Shimakuchi Do you need the pdo_sqlite extention to import the sqlite db into the PostgreSQL or do you want to use the sqlite as DB?

@bvdberg01 commented on GitHub (Mar 29, 2025): @Shimakuchi Do you need the pdo_sqlite extention to import the sqlite db into the PostgreSQL or do you want to use the sqlite as DB?
saavagebueno commented 2025-11-20 04:54:00 -05:00
Author
Owner
Copy Link

@qzydustin commented on GitHub (Mar 30, 2025):

@Shimakuchi Do you need the pdo_sqlite extention to import the sqlite db into the PostgreSQL or do you want to use the sqlite as DB?

Thank you for the script! I prefer to use SQLite as my database since I am deploying it for personal use with no additional users. I would greatly appreciate it if you could add SQLite selection to the script!

@bvdberg01 @tremor021

@qzydustin commented on GitHub (Mar 30, 2025): > [@Shimakuchi](https://github.com/Shimakuchi) Do you need the pdo_sqlite extention to import the sqlite db into the PostgreSQL or do you want to use the sqlite as DB? Thank you for the script! I prefer to use SQLite as my database since I am deploying it for personal use with no additional users. I would greatly appreciate it if you could add SQLite selection to the script! @bvdberg01 @tremor021
saavagebueno commented 2025-11-20 04:54:00 -05:00
Author
Owner
Copy Link

@michelroegl-brunner commented on GitHub (Mar 31, 2025):

@tremor021 @bvdberg01
Before adding a new read in the script. is it worth discussing to ditch postgresql for sqlite entierly?

@michelroegl-brunner commented on GitHub (Mar 31, 2025): @tremor021 @bvdberg01 Before adding a new read in the script. is it worth discussing to ditch postgresql for sqlite entierly?
saavagebueno commented 2025-11-20 04:54:01 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Mar 31, 2025):

I don't see the big advantages of psql now, there aren't actually tons of data here, are there?

Only someone who uses it can answer that. How many data records are available?

@MickLesk commented on GitHub (Mar 31, 2025): I don't see the big advantages of psql now, there aren't actually tons of data here, are there? Only someone who uses it can answer that. How many data records are available?
saavagebueno commented 2025-11-20 04:54:01 -05:00
Author
Owner
Copy Link

@tremor021 commented on GitHub (Mar 31, 2025):

It would make migrating much easier, yes. Also performance wise, i don't think there would be any noticable difference, its not like its a heavy load read/write app.

@tremor021 commented on GitHub (Mar 31, 2025): It would make migrating much easier, yes. Also performance wise, i don't think there would be any noticable difference, its not like its a heavy load read/write app.
saavagebueno commented 2025-11-20 04:54:01 -05:00
Author
Owner
Copy Link

@bvdberg01 commented on GitHub (Mar 31, 2025):

FreshRSS has recommended PostgreSQL as database, thats why I used it for the script.
https://freshrss.github.io/FreshRSS/en/admins/02_Prerequisites.html

@bvdberg01 commented on GitHub (Mar 31, 2025): FreshRSS has recommended PostgreSQL as database, thats why I used it for the script. https://freshrss.github.io/FreshRSS/en/admins/02_Prerequisites.html
saavagebueno commented 2025-11-20 04:54:01 -05:00
Author
Owner
Copy Link

@MickLesk commented on GitHub (Mar 31, 2025):

Maybe you should also start a discussion in their repo about whether there are plans to switch to psql only (like wikijs) at some point, so that we don't have to rebuild the whole script in half a year. In general, you should also find out why they prefer PSQL?

@MickLesk commented on GitHub (Mar 31, 2025): Maybe you should also start a discussion in their repo about whether there are plans to switch to psql only (like wikijs) at some point, so that we don't have to rebuild the whole script in half a year. In general, you should also find out why they prefer PSQL?
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
🛑 Failure to comply with the guidelines
breaking change
bug
bug
bugfix
deferred
delete script
dependencies
enhancement
external
feature
github
help wanted
Implemented in VED waiting push to Main
in project pipeline
invalid
investigation
json
maintenance
new script
new script
nice to have
not a script issue
not planned
organization
pull-request
Mirrored from GitHub Pull Request
 question
refactor
rename script
security
update script
website
wontdo
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
saavagebueno
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: SVI/ProxmoxVE#784
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?