rbachwiki - Recent changes [en]

RecipeApp

Bacchas — Wed, 10 Jun 2026 19:45:24 GMT

RecipeApp

Bacchas — Wed, 10 Jun 2026 19:18:30 GMT

Created page with "== Recipe App == ''''1. Install Packages '''' <pre> sudo apt update sudo apt install apache2 sqlite3 libsqlite3-dev libapache2-mod-php php-sqlite3 </pre> ''''If your Apache uses a specific PHP version, install SQLite for that version. Check Apache PHP:'''' <pre> apachectl -M | grep -i php ls -la /etc/apache2/mods-enabled/php*.load </pre> '''' Example: if Apache uses PHP 8.1:'''' <pre> sudo apt install php8.1-sqlite3 sudo phpenmod -v 8.1 -s apache2 pdo_sqlite sqlit..."

New page

== Recipe App ==

''''1. Install Packages ''''

<pre>
sudo apt update

sudo apt install apache2 sqlite3 libsqlite3-dev libapache2-mod-php php-sqlite3
</pre>

''''If your Apache uses a specific PHP version, install SQLite for that version. Check Apache PHP:''''

<pre>
apachectl -M | grep -i php
ls -la /etc/apache2/mods-enabled/php*.load
</pre>

'''' Example: if Apache uses PHP 8.1:''''

<pre>
sudo apt install php8.1-sqlite3
sudo phpenmod -v 8.1 -s apache2 pdo_sqlite sqlite3
sudo systemctl restart apache2
</pre>

'''' Verify SQLite support:''''

<pre>
php -m | grep -i sqlite
ls -la /etc/php/*/apache2/conf.d/ | grep sqlite
</pre>

'''' You should see:''''

<pre>
pdo_sqlite
sqlite3
</pre>

'''' 2. Copy App Files
Example location:3. Set Permissions
Apache must write to SQLite and image upload folders:''''

<pre>
cd /var/www/html/11square

sudo mkdir -p data uploads/recipes
sudo chown -R www-data:www-data data uploads
sudo chmod -R 775 data uploads
</pre>

'''' Do not make the whole app writable unless needed. Only data/ and uploads/ need write access.
4. Apache Virtual Host
Create a site config:''''

<pre>
sudo nano /etc/apache2/sites-available/11square.conf
</pre>

'''' ''''

<pre>
<VirtualHost *:80>
ServerName 11square.com
ServerAlias www.11square.com

DocumentRoot /var/www/html/11square

<Directory /var/www/html/11square>
Options -Indexes +FollowSymLinks
AllowOverride All
Require all granted
</Directory>

ErrorLog ${APACHE_LOG_DIR}/11square-error.log
CustomLog ${APACHE_LOG_DIR}/11square-access.log combined
</VirtualHost></pre>

''''Enable the site: ''''

<pre>
sudo a2ensite 11square.conf
sudo a2enmod rewrite
sudo apachectl configtest
sudo systemctl restart apache2
</pre>

''''If config test says Syntax OK, Apache is good.
5. Test App From Server
From the app folder: ''''

<pre>
cd /var/www/html/11square

php -l index.php
php -l lib/Database.php
</pre>

'''' ''''

<pre>
'''7. Optional HTTPS
Install Certbot:'''

sudo apt install certbot python3-certbot-apache

Issue certificate:

sudo certbot --apache -d 11square.com -d www.11square.com

'''Then test:'''
sudo apachectl configtest
sudo systemctl restart apache2

'''8. Common Troubleshooting'''
'''Check Apache/PHP errors:'''

sudo tail -n 100 /var/log/apache2/11square-error.log
sudo tail -n 100 /var/log/apache2/error.log

'''Watch live while refreshing the browser:'''

sudo tail -f /var/log/apache2/11square-error.log

'''If you see:'''

'''PDOException: could not find driver'''
'''Install SQLite for Apache’s active PHP version:'''

ls -la /etc/apache2/mods-enabled/php*.load
sudo apt install php8.1-sqlite3
sudo phpenmod -v 8.1 -s apache2 pdo_sqlite sqlite3
sudo systemctl restart apache2

If you see permission errors for SQLite or uploads:
sudo chown -R www-data:www-data /var/www/html/11square/data /var/www/html/11square/uploads
sudo chmod -R 775 /var/www/html/11square/data /var/www/html/11square/uploads
Backup
Back up these folders/files:
/var/www/html/11square/data/cocktails.sqlite
/var/www/html/11square/uploads/
Those contain your saved recipes and uploaded images.
</pre>

AI APPS

Bacchas — Wed, 10 Jun 2026 19:09:27 GMT

← Older revision		Revision as of 19:09, 10 June 2026
Line 1:		Line 1:
	==[[PYTHONAPP]]==		==[[PYTHONAPP]]==
	==[[IMAGEBROWSER]]==		==[[IMAGEBROWSER]]==
			==[[RecipeApp]]==

IMAGEBROWSER

Bacchas — Fri, 29 May 2026 16:46:21 GMT

← Older revision		Revision as of 16:46, 29 May 2026
(7 intermediate revisions by the same user not shown)
Line 1:		Line 1:
	== Server Setup ==		== Server Setup ==
	1. upload contents to web folder		1. upload contents to web folder

			''' Even if PHP is already installed, confirm MySQL and GD support:'''
			<pre>
			sudo apt update
			sudo apt install php-mysql php-gd exiftool
			php -v
			php -m \| grep -E 'pdo_mysql\|gd'
			</pre>

			==Create Database==

			'''In phpMyAdmin:'''

			'''Create a database, for example imagebrowser.'''

			'''Use collation utf8mb4_unicode_ci.'''

			'''Import:'''

			database/schema.sql

			4. Create MySQL User

			'''You can do this in phpMyAdmin, or with MySQL CLI:'''
			<pre>
			CREATE USER 'imagebrowser_user'@'localhost' IDENTIFIED BY 'your-strong-password';
			GRANT ALL PRIVILEGES ON imagebrowser.* TO 'imagebrowser_user'@'localhost';
			FLUSH PRIVILEGES;
			</pre>

			5. Configure app on the server

			<pre>
			cd /var/www/html
			cp config/config.example.php config/config.php
			nano config/config.php
			</pre>

			'''Set these values'''
			<pre>
			'base_url' => '',
			'categories_dir' => __DIR__ . '/../categories',
			'thumbnail_dir' => __DIR__ . '/../cache/thumbs',
			'db' => [
			'host' => '127.0.0.1',
			'port' => 3306,
			'database' => 'imagebrowser',
			'username' => 'imagebrowser_user',
			'password' => 'your-strong-password',
			'charset' => 'utf8mb4',
			],
			</pre>

			'''Use base_url => '' if the app is at the domain root. If installed in a subfolder like /gallery, use:'''
			'base_url' => '/gallery',

			6. Set Permissions

			'''Apache/PHP must be able to read categories/ and write to cache/ and uploads:'''


			<pre>
			sudo chown -R www-data:www-data /var/www/html/cache /var/www/html/uploads /var/www/html/categories
			sudo chmod -R 775 /var/www/html/cache /var/www/html/uploads /var/www/html/categories
			</pre>

			7. Apache Setup

			'''Check which document root Apache is actually serving:'''

			sudo apachectl -S

			8. Setup Conf file

			sudo nano /etc/apache2/sites-available/imagebrowser.conf

			'''Example '''
			<pre>
			<VirtualHost *:80>
			ServerName yourdomain.com
			DocumentRoot /var/www/imagebrowser

			<Directory /var/www/imagebrowser>
			AllowOverride All
			Require all granted
			</Directory>

			ErrorLog ${APACHE_LOG_DIR}/imagebrowser_error.log
			CustomLog ${APACHE_LOG_DIR}/imagebrowser_access.log combined
			</VirtualHost>
			</pre>

			8. Enable it

			<pre>
			sudo a2ensite imagebrowser.conf
			sudo a2enmod rewrite
			sudo systemctl reload apache2
			</pre>

			9. Create an Admin User For the App

			'''Cd into the App Folder'''

			<pre>
			cd /var/www/html
			php cli/create_admin.php admin@example.com "your-admin-password"
			</pre>

			10. Add Images to the Category Folder

			11. Sign in to the Admin

			<pre>
			https://yourdomain.com/login.php
			</pre>

			12. Go ot Admin and click

			Sync Library
			Render Category Thumbnails

			13. Quick verifications. Run these on the server

			<pre>
			cd /var/www/html
			php -l index.php
			php -l thumb.php
			php -l app/bootstrap.php
			php -l app/thumbnails.php
			</pre>


			<pre>

			</pre>

IMAGEBROWSER

Bacchas — Fri, 29 May 2026 16:15:48 GMT

Created page with "== Server Setup == 1. upload contents to web folder"

New page

== Server Setup ==
1. upload contents to web folder

AI APPS

Bacchas — Fri, 29 May 2026 16:14:50 GMT

← Older revision		Revision as of 16:14, 29 May 2026
Line 1:		Line 1:
	==[[PYTHONAPP]]==		==[[PYTHONAPP]]==
			==[[IMAGEBROWSER]]==

AI APPS

Bacchas — Fri, 29 May 2026 16:14:08 GMT

Created page with "==PYTHONAPP=="

New page

==[[PYTHONAPP]]==

Main Page

Bacchas — Fri, 29 May 2026 16:13:57 GMT

← Older revision		Revision as of 16:13, 29 May 2026
Line 1:		Line 1:
	==[[APPSHEET]]==		==[[APPSHEET]]==
	==[[~~PYTHONAPP~~]]==		==[[AI APPS]]==

	== [[AWS\|Amazon Cloud Service]] ==		== [[AWS\|Amazon Cloud Service]] ==
	== [[Bash]] ==		== [[Bash]] ==

PYTHONAPP

Bacchas — Fri, 29 May 2026 15:31:45 GMT

@@ Line 187: / Line 187: @@
 sudo lsof -i :3000 -P -n            # gets PID
 ps -o unit= -p <PID>                # gets service name
 </pre>