Hardware: Raspberry Pi at home YunoHost version: 126.96.36.199 I have access to my server : Through SSH Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : no
Description of my issue
my apps are lying in the domain yunohost.local
Now I created a new domain pixelfed.local and in addition installed Pixelfed.
To my surprise this is working generally
I had to turn off email verification in the .env-file to be able to login because I always get an error with the link provided in the verification email.
Now I would simply like to set a date into the database table “users” in the field “email_verified_at” to get rid of the message “email not verified”. I’m not used to work with postgre databases, but I maybe got close to solution:
With ssh I went into the folder /usr/lib/postgresql/11/bin/ and entered the command
psql -d pixelfed -U pixelfed -W
then I enter the password that I found in the .env-file
Seems like I’m into the Postgre-command interface. When I enter \dt I can see all tables of the pixelfed database.
Before altering some values I first try to do a select:
SELECT * FROM users
But nothing happens…
Second problem is that I can’t use PixelDroid. As I read a call to my /api/v1/instance should deliver mobile_api: true
But I don’t find mobile_api in there. Not “false” and not “true” - it’s missing. In .env OAUTH_ENABLED is set to true. And in the Pixelfed-Admin-Panel under “Settings” “APIs enabled” is checked
When I start PixelDroid I have to enter my domain. After tapping on the “connect” button my browser opens. Then I have to enter my credentials. A page opens where I can authorize PixelDroid with read write and follow permissions.
After tapping on “Authorize” the app PixelDroid is loading and is jumping to the first page where I have to enter my domain where my previous input is cleared.
In my Pixelfed under “Settings → Applications” I can see a new “Authorized” application “PixelDroid”. If I repeat previous steps, this list is getting longer.
Maybe my database is not working properly. When I go to “My Feed” while logged in, then I can see all my posts in the correct order.
But when I select “Public Feed” then some posts disappear. All of them are set public.
I found out that all missing posts have negative id’s in the database.
When I set one of these id’s into a positive value then the post is appearing in “Public Feed”, but still not in correct order…
Thanks for your explanations. I wonder if that should be reported to PixelDroid/Pixelfed authours, because it may look like a Pixelfed bug… but I’m unsure, and I don’t know how Pixelfed API work so I can’t really investigate this
Thank you very much for your help!
Can Pixelfed being used on a Raspberry Pi? I opened an issue on the Pixelfed site because of my random id numbers that sometimes get negative.
The reason for this seems to be that Pixelfed is using “snowflake” to generate the status id. I got the information that 64bit php is needed for this.
I’m not sure, but I don’t believe that my Raspberry Pi can do that?
So I’m looking for a solution to get “snowflake” switched off in my personal Pixelfed.
PixelDroid is not so important. Maybe the Oauth-values are also generated with 64bit php so they fail on my instance?
I can use Fedilab - the only problem are negative IDs of statuses. When I have one, Fedilab deliveres an error…