User Tools

Site Tools


computing:pix3lfed

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
computing:pix3lfed [2026/03/01 19:13] oemb1905computing:pix3lfed [2026/03/02 02:17] (current) oemb1905
Line 160: Line 160:
   sudo -u www-data php artisan view:cache   sudo -u www-data php artisan view:cache
   sudo -u www-data php artisan optimize   sudo -u www-data php artisan optimize
 +  sudo -u www-data php artisan instance:actor
 +  sudo -u www-data php artisan import:cities
  
 === Step 4: Additional Apache Tweaks === === Step 4: Additional Apache Tweaks ===
Line 180: Line 182:
 <Directory /var/www/> <Directory /var/www/>
     Options Indexes FollowSymLinks     Options Indexes FollowSymLinks
-    AllowOverride **All**+    AllowOverride All ### NOTE "All" instead of "None" ###
     Require all granted     Require all granted
 </Directory> </Directory>
Line 240: Line 242:
  
 === Step 6: User Creation & Instance Management === === Step 6: User Creation & Instance Management ===
 +
 +Let's create the admin user:
  
   cd /var/www/pixelfed   cd /var/www/pixelfed
Line 293: Line 297:
 This little script just helps me refresh everything if/when changes or adjustments need to be made. Once the instance gets approved and/or I have resolved the well-known federation and/or discovery stuff, I will post an update. Thanks all and happy hacking !! This little script just helps me refresh everything if/when changes or adjustments need to be made. Once the instance gets approved and/or I have resolved the well-known federation and/or discovery stuff, I will post an update. Thanks all and happy hacking !!
  
- --- //[[alerts@haacksnetworking.org|oemb1905]] 2026/03/01 18:02//+------------------------------------------- 
 + 
 +=== Debugging, Miscellaneous, Updates === 
 +From here forward, I post miscellaneous debugging. To fix images in DMs failing, as per github #5217, #5365, #5496, I edited the db to accept wrongly submitted null values from the bad DM code: 
 + 
 +  mysql -u root -p 
 +  USE pixel; 
 +  ALTER TABLE statuses MODIFY COLUMN caption TEXT NULL; 
 +  EXIT; 
 + 
 +This solves the issue and allows users to upload images inside their DMS. Here are the issues that helped me fix this: 
 + 
 +  * [[https://github.com/pixelfed/pixelfed/issues/5217|#5217]] 
 +  * [[https://github.com/pixelfed/pixelfed/issues/5365|#5365]] 
 +  * [[https://github.com/pixelfed/pixelfed/issues/5496|#5496]] 
 + 
 +I'm having an issue where the sql of the instance wrongly uses 19 for the re-issuance of the new client registration. Since this conflicts with 19 being used by the default personal client, it fails. After repeatedly messing with auto-increment according to github iALTER TABLE oauth_clients DROP PRIMARY KEY;ssues and seeing it fail once the keys and passport were re-initialized, I decided to change the entry to a varchar assignment instead, removing the conflict: 
 + 
 +  ALTER TABLE oauth_clients MODIFY id INT NOT NULL; 
 +  ALTER TABLE oauth_clients DROP PRIMARY KEY; 
 +  ALTER TABLE oauth_clients MODIFY id VARCHAR(255) NOT NULL; 
 +  ALTER TABLE oauth_clients ADD PRIMARY KEY (id); 
 +  DESCRIBE oauth_clients; #verify it changed properly 
 +  EXIT; 
 +  cd /var/www/pixelfed 
 +  sudo -u www-data php artisan passport:install --force 
 +  sudo -u www-data php artisan passport:keys --force 
 +  sudo /usr/local/bin/refresh.sh 
 +   
 +Once I did this, the ''passport:keys'' step no longer failed or barfed about row 19. 
 + 
 + --- //[[alerts@haacksnetworking.org|oemb1905]] 2026/03/02 02:12//
computing/pix3lfed.1772392414.txt.gz · Last modified: by oemb1905