Hardware: Raspberry Pi at home YunoHost version: 4.3.6.2 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
Hi,
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.
Some testings later e.g. with the app Fedilab I found out that there are some entries inm the nginx logfiles.
Seems like both apps are trying to call files like
My installation does not have these files. Are they missing or are they optional?
Pixeldroid seems to fail verifying the credentials. Is the redirect address that is set automatically correct (redirect_uri=oauth2redirect://org.pixeldroid.app) ?
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ā¦
I donāt know if ARM architecture are well supported, but in terms of performances, it should be running fine (for a small instance).
I donāt really know how that works on Raspberry Pi, I know the official distribution is available in 64 bits only very recently, but I suppose 64 bits program were already runningā¦ well Iām not sure
It might be interesting to report the issue you encounters to Pixelfed github repositoryā¦ I hope they will have more information.