Haack's Wiki

User Tools

Site Tools

Trace: • pix3lfed
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>
 </code> </code>
  
-Additionally, the Pixelfed website mentions that some users of apache might have difficulty with the default ''.htaccess'' file in ''public'' so they recommended changing it. My instance had trouble finding certain locations and directories unless I changed to their recommendation. Open up ''sudo nano /var/www/pixelfed/public/.htaccess'' and enter the recommendation as follows:+Additionally, the Pixelfed website mentions that some users of apache might have difficulty with the default ''.htaccess'' file in ''public'' so they recommended changing it. My instance indeed had trouble finding certain locations and directories unless I changed to their recommendation. Open up ''sudo nano /var/www/pixelfed/public/.htaccess'' and enter the recommendation as follows:
  
   <IfModule mod_rewrite.c>   <IfModule mod_rewrite.c>
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.1772392402.txt.gz · Last modified: by oemb1905

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
GNU Free Documentation License 1.3 Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki