Je privacy is voor het eerst geschonden bij de eerste echo. Daarna wordt het er de rest van je leven niet meer beter op.
Docker draait hier op een pi4. k probeer zoveel mogelijk databases in MariaDB te houden en draai daar 1x daags geautomatiseerd een backup van naar de PC toe. Die backups blijven 7 dagen op de PC maar viavia (backblaze) een jaar lang bewaard. Backups zijn wel vaker een lifesaver geweest -> beveel ik dus iedereen aan, en niet alleen voor databases maar ook voor configuraties en andere relevante bestanden.:
Hmmm, dank voor de waarschuwing! Hier ook een groot gat tussen 15-11-2010 22:24 en 28-06-2025 04:24.
Ik draai Spotweb direct, geen container ofzo. Geen dingen gewijzigd de laatste tijd, dus een bug in Spotweb zelf lijkt mij waarschijnlijk.
Database grootte is ook niet dramatisch kleiner geworden: ongeveer 5GB nu en ongeveer 5GB twee dagen geleden.
Nu even bedenken hoe dit terug te zetten is. Heb geen SQL backup gemaakt, maar wel dagelijks een snapshot in het filesysteem.
Je privacy is voor het eerst geschonden bij de eerste echo. Daarna wordt het er de rest van je leven niet meer beter op.
"Technological advancements don't feel fun anymore because of the motivations behind so many of them." Bron
Deze problemen worden veroorzaakt door recente Windows 11-updates (KB5064081 en KB5065426).
Ja, daar had ik dus ook last van... nieuwe posts kwamen wel binnen maar de comments bleven weg.
Met diverse varianten van de getallen voor de 'Data too long for column' error melding en op verschillende 'rows'.
'usersignatur' is een veld in de 'commentsfull' tabel en is bij mij een varchar(255). Ik heb het veld opgerekt naar een varchar(512) op onderstaande manier:Disclaimer:
Dit is hoe IK het heb opgelost op mijn systeem. Jou systeem ZAL anders zijn en mijn oplossing KAN bij jou niet werken! Maak een backup (of een snapshot) voordat je begint. Ik ben niet verantwoordelijk als jou system kapot gaat. Garantie tot het einde van deze zin
1
2
3
4
| mysql use spotweb; alter table commentsfull modify usersignature varchar(512); exit |
Kortom, een halfuurtje schrapen op de harddisk om het veld op te rekken.
Was bezig om een bug te melden exact hiervoor. Gebruikte de laatste release versie en kreeg deze fout bij het ophalen van de comments. In github bij de issues was niets hierover terug te vinden
1
2
3
4
5
6
7
| Retrieving 21410002 till 21411002, found 1000 comments in 29.17 seconds SpotWeb v0.68.38.34 on PHP v8.4.13 crashed Fatal error occured during retrieve: 22001: 1406: Data too long for column 'usersignature' at row 64 |
Absolute n00body
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
| #!/usr/bin/env bash
# Spotweb Proxmox LXC Installer - All-in-One Version
# Copyright (c) 2025 VenimK
# License: MIT
# Creates LXC container and installs Spotweb automatically
source <(curl -s https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/misc/build.func)
# Colors
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
CYAN='\033[0;36m'
NC='\033[0m' # No Color
function header_info {
clear
cat <<"EOF"
_____ __ __
/ ___/____ ____ / /__ _____ / /_
\__ \/ __ \/ __ \/ __/ | /| / / _ \/ __ \
___/ / /_/ / /_/ / /_ | |/ |/ / __/ /_/ /
/____/ .___/\____/\__/ |__/|__/\___/_.___/
/_/
Automated Debian LXC + Spotweb Installer
EOF
echo ""
}
header_info
# Start timer
START_TIME=$(date +%s)
# Configuration
CTID=""
HOSTNAME="spotweb"
DISK_SIZE="20"
CORES="2"
MEMORY="2048"
BRIDGE="vmbr0"
OSTYPE="debian"
OSVERSION="12"
WEBSERVER="apache" # or nginx
# Get next available CTID
NEXTID=$(pvesh get /cluster/nextid)
# Detect available storage for containers
echo -e "${BLUE}Detecting available storage...${NC}"
# Prefer storages that explicitly support rootdir (containers)
mapfile -t STORAGE_OPTIONS < <(pvesm status -content rootdir 2>/dev/null | awk 'NR>1 {print $1}')
# Fallback: any storage entry if none reported with rootdir
if [ ${#STORAGE_OPTIONS[@]} -eq 0 ]; then
mapfile -t STORAGE_OPTIONS < <(pvesm status 2>/dev/null | awk 'NR>1 {print $1}')
fi
if [ ${#STORAGE_OPTIONS[@]} -eq 0 ]; then
echo -e "${RED}Error: No storage found on this Proxmox host${NC}"
echo -e "${YELLOW}pvesm status output:${NC}"
pvesm status || true
exit 1
fi
echo -e "${CYAN}Available storage options:${NC}"
idx=1
for store in "${STORAGE_OPTIONS[@]}"; do
echo -e " ${idx}) ${store}"
idx=$((idx+1))
done
echo ""
read -p "Select storage [1-${#STORAGE_OPTIONS[@]}] (default 1): " STORAGE_CHOICE
if [ -z "${STORAGE_CHOICE}" ]; then
STORAGE_CHOICE=1
fi
if ! [[ "${STORAGE_CHOICE}" =~ ^[0-9]+$ ]] || [ "${STORAGE_CHOICE}" -lt 1 ] || [ "${STORAGE_CHOICE}" -gt ${#STORAGE_OPTIONS[@]} ]; then
echo -e "${RED}Invalid selection. Aborting.${NC}"
exit 1
fi
STORAGE=${STORAGE_OPTIONS[$((STORAGE_CHOICE-1))]}
echo -e "${GREEN}✓ Using storage: ${STORAGE}${NC}"
echo -e "${CYAN}Spotweb LXC Container Setup${NC}"
echo ""
echo -e "${YELLOW}This will create a Debian 12 LXC container and install Spotweb${NC}"
echo ""
echo -e "${GREEN}Default settings:${NC}"
echo -e " Container ID: ${NEXTID}"
echo -e " Hostname: ${HOSTNAME}"
echo -e " CPU Cores: ${CORES}"
echo -e " RAM: ${MEMORY}MB"
echo -e " Disk: ${DISK_SIZE}GB"
echo -e " Storage: ${STORAGE}"
echo -e " OS: Debian ${OSVERSION}"
echo -e " Web Server: ${WEBSERVER}"
echo ""
read -p "Container hostname [${HOSTNAME}]: " INPUT_HOST
if [[ -n "${INPUT_HOST}" ]]; then
HOSTNAME="${INPUT_HOST}"
fi
read -p "Disk size in GB [${DISK_SIZE}]: " INPUT_DISK
if [[ -n "${INPUT_DISK}" && "${INPUT_DISK}" =~ ^[0-9]+$ && "${INPUT_DISK}" -gt 0 ]]; then
DISK_SIZE="${INPUT_DISK}"
fi
read -p "CPU cores [${CORES}]: " INPUT_CORES
if [[ -n "${INPUT_CORES}" && "${INPUT_CORES}" =~ ^[0-9]+$ && "${INPUT_CORES}" -gt 0 ]]; then
CORES="${INPUT_CORES}"
fi
read -p "RAM in MB [${MEMORY}]: " INPUT_MEM
if [[ -n "${INPUT_MEM}" && "${INPUT_MEM}" =~ ^[0-9]+$ && "${INPUT_MEM}" -gt 0 ]]; then
MEMORY="${INPUT_MEM}"
fi
read -p "Web server (apache/nginx) [${WEBSERVER}]: " INPUT_WEB
if [[ -n "${INPUT_WEB}" && ("${INPUT_WEB}" == "apache" || "${INPUT_WEB}" == "nginx") ]]; then
WEBSERVER="${INPUT_WEB}"
fi
echo ""
echo -e "${CYAN}Final settings:${NC}"
echo -e " Container ID: ${NEXTID}"
echo -e " Hostname: ${HOSTNAME}"
echo -e " CPU Cores: ${CORES}"
echo -e " RAM: ${MEMORY}MB"
echo -e " Disk: ${DISK_SIZE}GB"
echo -e " Storage: ${STORAGE}"
echo -e " OS: Debian ${OSVERSION}"
echo -e " Web Server: ${WEBSERVER}"
echo ""
read -p "Press Enter to create the container and install Spotweb, or Ctrl+C to cancel: "
CTID=$NEXTID
echo ""
echo -e "${BLUE}Creating LXC container...${NC}"
# Find the latest Debian 12 template
echo -e "${YELLOW}Finding Debian ${OSVERSION} template...${NC}"
pveam update
# Get the latest Debian 12 template name
TEMPLATE=$(pveam available | grep "debian-${OSVERSION}" | grep "standard" | tail -n1 | awk '{print $2}')
if [ -z "$TEMPLATE" ]; then
echo -e "${RED}Error: Could not find Debian ${OSVERSION} template${NC}"
echo -e "${YELLOW}Available templates:${NC}"
pveam available | grep debian
exit 1
fi
echo -e "${GREEN}✓ Found template: ${TEMPLATE}${NC}"
TEMPLATE_PATH="/var/lib/vz/template/cache/${TEMPLATE}"
if [ ! -f "$TEMPLATE_PATH" ]; then
echo -e "${YELLOW}Downloading template...${NC}"
pveam download local "$TEMPLATE"
fi
# Create container (unprivileged for better security)
pct create $CTID $TEMPLATE_PATH \
--hostname $HOSTNAME \
--cores $CORES \
--memory $MEMORY \
--rootfs ${STORAGE}:${DISK_SIZE} \
--net0 name=eth0,bridge=${BRIDGE},ip=dhcp \
--unprivileged 1 \
--features nesting=1 \
--onboot 1 \
--start 1
echo -e "${GREEN}✓ Container created (ID: $CTID)${NC}"
# Wait for container to start
echo -e "${BLUE}Waiting for container to start...${NC}"
sleep 5
# Wait for network
echo -e "${BLUE}Waiting for network...${NC}"
for i in {1..30}; do
if pct exec $CTID -- ping -c 1 8.8.8.8 >/dev/null 2>&1; then
echo -e "${GREEN}✓ Network is ready${NC}"
break
fi
sleep 2
done
# Get container IP
IP=$(pct exec $CTID -- hostname -I | awk '{print $1}')
echo -e "${GREEN}✓ Container IP: $IP${NC}"
echo ""
# Run installation inside container
echo -e "${BLUE}╔════════════════════════════════════════════════════════════╗${NC}"
echo -e "${BLUE}║ Starting Spotweb installation inside container... ║${NC}"
echo -e "${BLUE}║ This will take 5-15 minutes ║${NC}"
echo -e "${BLUE}╚════════════════════════════════════════════════════════════╝${NC}"
echo ""
# Create installation script inside container
pct exec $CTID -- bash <<'INSTALLER_SCRIPT'
#!/bin/bash
set -e
# Error trap to show what failed
trap 'echo -e "\n\033[0;31m✗ Installation failed at line $LINENO\033[0m\n"; exit 1' ERR
# Colors
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
NC='\033[0m'
print_success() { echo -e "${GREEN}✓ $1${NC}"; }
print_info() { echo -e "${BLUE}ℹ $1${NC}"; }
print_warning() { echo -e "${YELLOW}⚠ $1${NC}"; }
SPOTWEB_DIR="/var/www/html/spotweb"
DB_NAME="spotweb"
DB_USER="spotweb"
generate_password() {
tr -dc 'A-Za-z0-9!@#$%^&*()_+=' < /dev/urandom 2>/dev/null | head -c 20
}
DB_PASS=$(generate_password)
# Update system
print_info "Updating system packages..."
apt-get update -qq
apt-get upgrade -y -qq
print_success "System updated"
# Fix locale warnings
print_info "Configuring locales..."
apt-get install -y locales
sed -i 's/# en_US.UTF-8 UTF-8/en_US.UTF-8 UTF-8/' /etc/locale.gen
locale-gen en_US.UTF-8 > /dev/null 2>&1
update-locale LANG=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
print_success "Locales configured"
# Install basic tools
print_info "Installing basic tools (curl, wget, git, unzip)..."
apt-get install -y curl wget git unzip ca-certificates gnupg2
print_success "Basic tools installed"
# Detect Debian version and set PHP version
DEBIAN_VERSION=$(cat /etc/debian_version | cut -d. -f1)
if [ "$DEBIAN_VERSION" -ge 12 ]; then
PHP_VERSION="8.2"
else
PHP_VERSION="7.4"
fi
print_info "Using PHP $PHP_VERSION"
# Install PHP
print_info "Installing PHP ${PHP_VERSION} and extensions..."
echo " → Installing: php, curl, gd, mbstring, xml, zip, mysql, dom, intl, opcache"
apt-get install -y \
php${PHP_VERSION} \
php${PHP_VERSION}-cli \
php${PHP_VERSION}-common \
php${PHP_VERSION}-curl \
php${PHP_VERSION}-gd \
php${PHP_VERSION}-mbstring \
php${PHP_VERSION}-xml \
php${PHP_VERSION}-zip \
php${PHP_VERSION}-mysql \
php${PHP_VERSION}-dom \
php${PHP_VERSION}-intl \
php${PHP_VERSION}-opcache
WEBSERVER="WEBSERVER_PLACEHOLDER"
if [ "$WEBSERVER" == "nginx" ]; then
echo " → Installing PHP-FPM for Nginx"
apt-get install -y php${PHP_VERSION}-fpm
else
echo " → Installing Apache PHP module"
apt-get install -y libapache2-mod-php${PHP_VERSION}
fi
print_success "PHP installed"
# Install MariaDB
print_info "Installing MariaDB server..."
echo " → Installing mariadb-server and mariadb-client"
apt-get install -y mariadb-server mariadb-client
echo " → Enabling and starting MariaDB service"
systemctl enable mariadb
systemctl start mariadb
print_success "MariaDB installed"
# Configure database
print_info "Creating database and user..."
echo " → Creating database: ${DB_NAME}"
mysql -e "CREATE DATABASE IF NOT EXISTS ${DB_NAME} CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
echo " → Creating user: ${DB_USER}"
# Drop and recreate user to ensure password matches
mysql -e "DROP USER IF EXISTS '${DB_USER}'@'localhost';" 2>/dev/null || true
mysql -e "CREATE USER '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PASS}';"
mysql -e "GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${DB_USER}'@'localhost';"
mysql -e "FLUSH PRIVILEGES;"
print_success "Database configured"
# Install web server
if [ "$WEBSERVER" == "nginx" ]; then
print_info "Installing Nginx web server..."
apt-get install -y nginx
# Configure Nginx
cat > /etc/nginx/sites-available/spotweb <<EOF
server {
listen 80 default_server;
listen [::]:80 default_server;
root /var/www/html/spotweb;
index index.php index.html;
server_name _;
location / {
try_files \$uri \$uri/ /index.php?\$query_string;
}
location ~ \.php$ {
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/run/php/php${PHP_VERSION}-fpm.sock;
fastcgi_param SCRIPT_FILENAME \$document_root\$fastcgi_script_name;
include fastcgi_params;
}
location ~ /\.ht {
deny all;
}
}
EOF
ln -sf /etc/nginx/sites-available/spotweb /etc/nginx/sites-enabled/spotweb
rm -f /etc/nginx/sites-enabled/default
systemctl enable nginx > /dev/null 2>&1
systemctl enable php${PHP_VERSION}-fpm > /dev/null 2>&1
systemctl restart php${PHP_VERSION}-fpm
systemctl restart nginx
print_success "Nginx configured"
else
print_info "Installing Apache web server..."
apt-get install -y apache2
# Configure Apache
echo " → Enabling Apache modules: rewrite, php"
a2enmod rewrite
a2enmod php${PHP_VERSION}
cat > /etc/apache2/sites-available/spotweb.conf <<'EOF'
<VirtualHost *:80>
ServerAdmin webmaster@localhost
DocumentRoot /var/www/html/spotweb
<Directory /var/www/html/spotweb>
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Require all granted
</Directory>
ErrorLog ${APACHE_LOG_DIR}/spotweb_error.log
CustomLog ${APACHE_LOG_DIR}/spotweb_access.log combined
</VirtualHost>
EOF
a2dissite 000-default.conf > /dev/null 2>&1
a2ensite spotweb.conf > /dev/null 2>&1
systemctl enable apache2 > /dev/null 2>&1
systemctl restart apache2
print_success "Apache configured"
fi
# Download Spotweb
print_info "Downloading Spotweb from GitHub..."
echo " → Cloning repository (master branch)"
rm -rf "$SPOTWEB_DIR"
if git clone -b master --depth 1 https://github.com/spotweb/spotweb.git "$SPOTWEB_DIR"; then
print_success "Spotweb downloaded"
else
echo -e "${RED}✗ Failed to download Spotweb${NC}"
echo "Please check your internet connection and try again"
exit 1
fi
# Set permissions
print_info "Setting file permissions..."
echo " → Setting owner to www-data"
chown -R www-data:www-data "$SPOTWEB_DIR"
echo " → Setting directory permissions (755)"
find "$SPOTWEB_DIR" -type d -exec chmod 755 {} \;
echo " → Setting file permissions (644)"
find "$SPOTWEB_DIR" -type f -exec chmod 644 {} \;
echo " → Creating cache directory"
mkdir -p "${SPOTWEB_DIR}/cache"
chmod 777 "${SPOTWEB_DIR}/cache"
print_success "Permissions set"
# Create database config
print_info "Creating configuration files..."
echo " → Creating dbsettings.inc.php"
cat > "${SPOTWEB_DIR}/dbsettings.inc.php" <<EOF
<?php
\$dbsettings['engine'] = 'mysql';
\$dbsettings['host'] = 'localhost';
\$dbsettings['dbname'] = '${DB_NAME}';
\$dbsettings['user'] = '${DB_USER}';
\$dbsettings['pass'] = '${DB_PASS}';
?>
EOF
chown www-data:www-data "${SPOTWEB_DIR}/dbsettings.inc.php"
chmod 640 "${SPOTWEB_DIR}/dbsettings.inc.php"
# Create basic ownsettings.php
echo " → Creating ownsettings.php"
cat > "${SPOTWEB_DIR}/ownsettings.php" <<'EOF'
<?php
error_reporting(E_ALL);
$settings['custom_stylesheet'] = '';
?>
EOF
chown www-data:www-data "${SPOTWEB_DIR}/ownsettings.php"
chmod 644 "${SPOTWEB_DIR}/ownsettings.php"
print_success "Configuration files created"
# Note: vendor/ directory is included in Spotweb git repo, so no Composer needed
cd "$SPOTWEB_DIR"
# Initialize Spotweb database
print_info "Initializing Spotweb database schema..."
echo " → Creating tables and structure"
php ${SPOTWEB_DIR}/bin/upgrade-db.php
print_success "Database initialized"
# Reset admin password to default
print_info "Setting admin password..."
echo " → Resetting admin user password to default"
php ${SPOTWEB_DIR}/bin/upgrade-db.php --reset-password admin
print_success "Admin password set to: spotweb"
# Setup systemd timer
print_info "Configuring automatic spot retrieval..."
echo " → Creating systemd service"
cat > /etc/systemd/system/spotweb-retrieve.service <<EOF
[Unit]
Description=Spotweb Spot Retrieval
After=network.target mysql.service
[Service]
Type=oneshot
User=www-data
WorkingDirectory=${SPOTWEB_DIR}
ExecStart=/usr/bin/php ${SPOTWEB_DIR}/retrieve.php
StandardOutput=journal
StandardError=journal
[Install]
WantedBy=multi-user.target
EOF
echo " → Creating systemd timer (hourly execution)"
cat > /etc/systemd/system/spotweb-retrieve.timer <<'EOF'
[Unit]
Description=Run Spotweb Retrieval Hourly
[Timer]
OnBootSec=5min
OnUnitActiveSec=1h
Persistent=true
[Install]
WantedBy=timers.target
EOF
echo " → Enabling and starting timer"
systemctl daemon-reload
systemctl enable spotweb-retrieve.timer
systemctl start spotweb-retrieve.timer
print_success "Automatic retrieval configured (runs every hour)"
# Save credentials to file for easy access
print_info "Saving credentials..."
cat > /root/spotweb-credentials.txt <<EOF
Spotweb Installation Credentials
================================
Database Name: ${DB_NAME}
Database User: ${DB_USER}
Database Password: ${DB_PASS}
Web Interface: http://$(hostname -I | awk '{print $1}')/
Admin Login:
Username: admin
Password: spotweb
Installation Date: $(date)
EOF
chmod 600 /root/spotweb-credentials.txt
echo ""
echo -e "${GREEN}╔════════════════════════════════════════════════════════════╗${NC}"
echo -e "${GREEN}║ Installation Complete! ║${NC}"
echo -e "${GREEN}╚════════════════════════════════════════════════════════════╝${NC}"
echo ""
echo -e "${YELLOW}Database Credentials (SAVE THESE):${NC}"
echo ""
echo " Database: ${DB_NAME}"
echo " Username: ${DB_USER}"
echo " Password: ${DB_PASS}"
echo ""
echo -e "${BLUE}Credentials saved to: /root/spotweb-credentials.txt${NC}"
echo ""
INSTALLER_SCRIPT
# Replace webserver placeholder in the script
pct exec $CTID -- sed -i "s/WEBSERVER_PLACEHOLDER/${WEBSERVER}/g" /tmp/installer.sh 2>/dev/null || true
# Get the credentials
echo ""
echo -e "${GREEN}╔════════════════════════════════════════════════════════════╗${NC}"
echo -e "${GREEN}║ Spotweb Installation Complete! ║${NC}"
echo -e "${GREEN}╚════════════════════════════════════════════════════════════╝${NC}"
echo ""
echo -e "${CYAN}Container Information:${NC}"
echo -e " Container ID: ${CTID}"
echo -e " Hostname: ${HOSTNAME}"
echo -e " IP Address: ${IP}"
echo -e " Web Server: ${WEBSERVER}"
echo ""
# Get credentials from container
CREDS=$(pct exec $CTID -- cat /root/spotweb-credentials.txt 2>/dev/null)
echo -e "${YELLOW}Database Credentials:${NC}"
echo ""
pct exec $CTID -- grep -E "Database Name|Database User|Database Password" /root/spotweb-credentials.txt 2>/dev/null
echo ""
echo -e "${YELLOW}Admin Login Credentials:${NC}"
echo ""
echo -e " Username: ${GREEN}admin${NC}"
echo -e " Password: ${GREEN}spotweb${NC}"
echo ""
echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}"
echo -e "${GREEN}Access Spotweb:${NC}"
echo ""
echo -e " ${BLUE}→ http://${IP}/${NC}"
echo ""
echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}"
echo ""
echo -e "${CYAN}Next Steps:${NC}"
echo " 1. Open the URL above in your browser"
echo " 2. Login with default admin credentials (admin/spotweb)"
echo " 3. Configure your Usenet server in Settings"
echo " 4. Start retrieving spots!"
echo ""
echo -e "${CYAN}Container Management:${NC}"
echo " Enter container: pct enter ${CTID}"
echo " View credentials: pct exec ${CTID} -- cat /root/spotweb-credentials.txt"
echo " Stop container: pct stop ${CTID}"
echo " Start container: pct start ${CTID}"
echo " Check retrieval: pct exec ${CTID} -- systemctl status spotweb-retrieve.timer"
echo ""
# Calculate elapsed time
END_TIME=$(date +%s)
ELAPSED=$((END_TIME - START_TIME))
MINUTES=$((ELAPSED / 60))
SECONDS=$((ELAPSED % 60))
echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}"
echo -e "${GREEN}✓ Installation completed in ${MINUTES}m ${SECONDS}s${NC}"
echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}"
echo "" |
Een vraag: hoe voer ik dit script uit in Proxmox?:
code:
#!/usr/bin/env bash # Spotweb Proxmox LXC Installer - All-in-One Version # Copyright (c) 2025 VenimK # License: MIT # Creates LXC container and installs Spotweb automatically source <(curl -s https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/misc/build.func) # Colors RED='\033[0;31m' GREEN='\033[0;32m' YELLOW='\033[1;33m' BLUE='\033[0;34m' CYAN='\033[0;36m' NC='\033[0m' # No Color function header_info { clear cat <<"EOF" _____ __ __ / ___/____ ____ / /__ _____ / /_ \__ \/ __ \/ __ \/ __/ | /| / / _ \/ __ \ ___/ / /_/ / /_/ / /_ | |/ |/ / __/ /_/ / /____/ .___/\____/\__/ |__/|__/\___/_.___/ /_/ Automated Debian LXC + Spotweb Installer EOF echo "" } header_info # Start timer START_TIME=$(date +%s) # Configuration CTID="" HOSTNAME="spotweb" DISK_SIZE="20" CORES="2" MEMORY="2048" BRIDGE="vmbr0" OSTYPE="debian" OSVERSION="12" WEBSERVER="apache" # or nginx # Get next available CTID NEXTID=$(pvesh get /cluster/nextid) # Detect available storage for containers echo -e "${BLUE}Detecting available storage...${NC}" # Prefer storages that explicitly support rootdir (containers) mapfile -t STORAGE_OPTIONS < <(pvesm status -content rootdir 2>/dev/null | awk 'NR>1 {print $1}') # Fallback: any storage entry if none reported with rootdir if [ ${#STORAGE_OPTIONS[@]} -eq 0 ]; then mapfile -t STORAGE_OPTIONS < <(pvesm status 2>/dev/null | awk 'NR>1 {print $1}') fi if [ ${#STORAGE_OPTIONS[@]} -eq 0 ]; then echo -e "${RED}Error: No storage found on this Proxmox host${NC}" echo -e "${YELLOW}pvesm status output:${NC}" pvesm status || true exit 1 fi echo -e "${CYAN}Available storage options:${NC}" idx=1 for store in "${STORAGE_OPTIONS[@]}"; do echo -e " ${idx}) ${store}" idx=$((idx+1)) done echo "" read -p "Select storage [1-${#STORAGE_OPTIONS[@]}] (default 1): " STORAGE_CHOICE if [ -z "${STORAGE_CHOICE}" ]; then STORAGE_CHOICE=1 fi if ! [[ "${STORAGE_CHOICE}" =~ ^[0-9]+$ ]] || [ "${STORAGE_CHOICE}" -lt 1 ] || [ "${STORAGE_CHOICE}" -gt ${#STORAGE_OPTIONS[@]} ]; then echo -e "${RED}Invalid selection. Aborting.${NC}" exit 1 fi STORAGE=${STORAGE_OPTIONS[$((STORAGE_CHOICE-1))]} echo -e "${GREEN}✓ Using storage: ${STORAGE}${NC}" echo -e "${CYAN}Spotweb LXC Container Setup${NC}" echo "" echo -e "${YELLOW}This will create a Debian 12 LXC container and install Spotweb${NC}" echo "" echo -e "${GREEN}Default settings:${NC}" echo -e " Container ID: ${NEXTID}" echo -e " Hostname: ${HOSTNAME}" echo -e " CPU Cores: ${CORES}" echo -e " RAM: ${MEMORY}MB" echo -e " Disk: ${DISK_SIZE}GB" echo -e " Storage: ${STORAGE}" echo -e " OS: Debian ${OSVERSION}" echo -e " Web Server: ${WEBSERVER}" echo "" read -p "Container hostname [${HOSTNAME}]: " INPUT_HOST if [[ -n "${INPUT_HOST}" ]]; then HOSTNAME="${INPUT_HOST}" fi read -p "Disk size in GB [${DISK_SIZE}]: " INPUT_DISK if [[ -n "${INPUT_DISK}" && "${INPUT_DISK}" =~ ^[0-9]+$ && "${INPUT_DISK}" -gt 0 ]]; then DISK_SIZE="${INPUT_DISK}" fi read -p "CPU cores [${CORES}]: " INPUT_CORES if [[ -n "${INPUT_CORES}" && "${INPUT_CORES}" =~ ^[0-9]+$ && "${INPUT_CORES}" -gt 0 ]]; then CORES="${INPUT_CORES}" fi read -p "RAM in MB [${MEMORY}]: " INPUT_MEM if [[ -n "${INPUT_MEM}" && "${INPUT_MEM}" =~ ^[0-9]+$ && "${INPUT_MEM}" -gt 0 ]]; then MEMORY="${INPUT_MEM}" fi read -p "Web server (apache/nginx) [${WEBSERVER}]: " INPUT_WEB if [[ -n "${INPUT_WEB}" && ("${INPUT_WEB}" == "apache" || "${INPUT_WEB}" == "nginx") ]]; then WEBSERVER="${INPUT_WEB}" fi echo "" echo -e "${CYAN}Final settings:${NC}" echo -e " Container ID: ${NEXTID}" echo -e " Hostname: ${HOSTNAME}" echo -e " CPU Cores: ${CORES}" echo -e " RAM: ${MEMORY}MB" echo -e " Disk: ${DISK_SIZE}GB" echo -e " Storage: ${STORAGE}" echo -e " OS: Debian ${OSVERSION}" echo -e " Web Server: ${WEBSERVER}" echo "" read -p "Press Enter to create the container and install Spotweb, or Ctrl+C to cancel: " CTID=$NEXTID echo "" echo -e "${BLUE}Creating LXC container...${NC}" # Find the latest Debian 12 template echo -e "${YELLOW}Finding Debian ${OSVERSION} template...${NC}" pveam update # Get the latest Debian 12 template name TEMPLATE=$(pveam available | grep "debian-${OSVERSION}" | grep "standard" | tail -n1 | awk '{print $2}') if [ -z "$TEMPLATE" ]; then echo -e "${RED}Error: Could not find Debian ${OSVERSION} template${NC}" echo -e "${YELLOW}Available templates:${NC}" pveam available | grep debian exit 1 fi echo -e "${GREEN}✓ Found template: ${TEMPLATE}${NC}" TEMPLATE_PATH="/var/lib/vz/template/cache/${TEMPLATE}" if [ ! -f "$TEMPLATE_PATH" ]; then echo -e "${YELLOW}Downloading template...${NC}" pveam download local "$TEMPLATE" fi # Create container (unprivileged for better security) pct create $CTID $TEMPLATE_PATH \ --hostname $HOSTNAME \ --cores $CORES \ --memory $MEMORY \ --rootfs ${STORAGE}:${DISK_SIZE} \ --net0 name=eth0,bridge=${BRIDGE},ip=dhcp \ --unprivileged 1 \ --features nesting=1 \ --onboot 1 \ --start 1 echo -e "${GREEN}✓ Container created (ID: $CTID)${NC}" # Wait for container to start echo -e "${BLUE}Waiting for container to start...${NC}" sleep 5 # Wait for network echo -e "${BLUE}Waiting for network...${NC}" for i in {1..30}; do if pct exec $CTID -- ping -c 1 8.8.8.8 >/dev/null 2>&1; then echo -e "${GREEN}✓ Network is ready${NC}" break fi sleep 2 done # Get container IP IP=$(pct exec $CTID -- hostname -I | awk '{print $1}') echo -e "${GREEN}✓ Container IP: $IP${NC}" echo "" # Run installation inside container echo -e "${BLUE}╔════════════════════════════════════════════════════════════╗${NC}" echo -e "${BLUE}║ Starting Spotweb installation inside container... ║${NC}" echo -e "${BLUE}║ This will take 5-15 minutes ║${NC}" echo -e "${BLUE}╚════════════════════════════════════════════════════════════╝${NC}" echo "" # Create installation script inside container pct exec $CTID -- bash <<'INSTALLER_SCRIPT' #!/bin/bash set -e # Error trap to show what failed trap 'echo -e "\n\033[0;31m✗ Installation failed at line $LINENO\033[0m\n"; exit 1' ERR # Colors RED='\033[0;31m' GREEN='\033[0;32m' YELLOW='\033[1;33m' BLUE='\033[0;34m' NC='\033[0m' print_success() { echo -e "${GREEN}✓ $1${NC}"; } print_info() { echo -e "${BLUE}ℹ $1${NC}"; } print_warning() { echo -e "${YELLOW}⚠ $1${NC}"; } SPOTWEB_DIR="/var/www/html/spotweb" DB_NAME="spotweb" DB_USER="spotweb" generate_password() { tr -dc 'A-Za-z0-9!@#$%^&*()_+=' < /dev/urandom 2>/dev/null | head -c 20 } DB_PASS=$(generate_password) # Update system print_info "Updating system packages..." apt-get update -qq apt-get upgrade -y -qq print_success "System updated" # Fix locale warnings print_info "Configuring locales..." apt-get install -y locales sed -i 's/# en_US.UTF-8 UTF-8/en_US.UTF-8 UTF-8/' /etc/locale.gen locale-gen en_US.UTF-8 > /dev/null 2>&1 update-locale LANG=en_US.UTF-8 export LANG=en_US.UTF-8 export LC_ALL=en_US.UTF-8 print_success "Locales configured" # Install basic tools print_info "Installing basic tools (curl, wget, git, unzip)..." apt-get install -y curl wget git unzip ca-certificates gnupg2 print_success "Basic tools installed" # Detect Debian version and set PHP version DEBIAN_VERSION=$(cat /etc/debian_version | cut -d. -f1) if [ "$DEBIAN_VERSION" -ge 12 ]; then PHP_VERSION="8.2" else PHP_VERSION="7.4" fi print_info "Using PHP $PHP_VERSION" # Install PHP print_info "Installing PHP ${PHP_VERSION} and extensions..." echo " → Installing: php, curl, gd, mbstring, xml, zip, mysql, dom, intl, opcache" apt-get install -y \ php${PHP_VERSION} \ php${PHP_VERSION}-cli \ php${PHP_VERSION}-common \ php${PHP_VERSION}-curl \ php${PHP_VERSION}-gd \ php${PHP_VERSION}-mbstring \ php${PHP_VERSION}-xml \ php${PHP_VERSION}-zip \ php${PHP_VERSION}-mysql \ php${PHP_VERSION}-dom \ php${PHP_VERSION}-intl \ php${PHP_VERSION}-opcache WEBSERVER="WEBSERVER_PLACEHOLDER" if [ "$WEBSERVER" == "nginx" ]; then echo " → Installing PHP-FPM for Nginx" apt-get install -y php${PHP_VERSION}-fpm else echo " → Installing Apache PHP module" apt-get install -y libapache2-mod-php${PHP_VERSION} fi print_success "PHP installed" # Install MariaDB print_info "Installing MariaDB server..." echo " → Installing mariadb-server and mariadb-client" apt-get install -y mariadb-server mariadb-client echo " → Enabling and starting MariaDB service" systemctl enable mariadb systemctl start mariadb print_success "MariaDB installed" # Configure database print_info "Creating database and user..." echo " → Creating database: ${DB_NAME}" mysql -e "CREATE DATABASE IF NOT EXISTS ${DB_NAME} CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;" echo " → Creating user: ${DB_USER}" # Drop and recreate user to ensure password matches mysql -e "DROP USER IF EXISTS '${DB_USER}'@'localhost';" 2>/dev/null || true mysql -e "CREATE USER '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PASS}';" mysql -e "GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${DB_USER}'@'localhost';" mysql -e "FLUSH PRIVILEGES;" print_success "Database configured" # Install web server if [ "$WEBSERVER" == "nginx" ]; then print_info "Installing Nginx web server..." apt-get install -y nginx # Configure Nginx cat > /etc/nginx/sites-available/spotweb <<EOF server { listen 80 default_server; listen [::]:80 default_server; root /var/www/html/spotweb; index index.php index.html; server_name _; location / { try_files \$uri \$uri/ /index.php?\$query_string; } location ~ \.php$ { include snippets/fastcgi-php.conf; fastcgi_pass unix:/run/php/php${PHP_VERSION}-fpm.sock; fastcgi_param SCRIPT_FILENAME \$document_root\$fastcgi_script_name; include fastcgi_params; } location ~ /\.ht { deny all; } } EOF ln -sf /etc/nginx/sites-available/spotweb /etc/nginx/sites-enabled/spotweb rm -f /etc/nginx/sites-enabled/default systemctl enable nginx > /dev/null 2>&1 systemctl enable php${PHP_VERSION}-fpm > /dev/null 2>&1 systemctl restart php${PHP_VERSION}-fpm systemctl restart nginx print_success "Nginx configured" else print_info "Installing Apache web server..." apt-get install -y apache2 # Configure Apache echo " → Enabling Apache modules: rewrite, php" a2enmod rewrite a2enmod php${PHP_VERSION} cat > /etc/apache2/sites-available/spotweb.conf <<'EOF' <VirtualHost *:80> ServerAdmin webmaster@localhost DocumentRoot /var/www/html/spotweb <Directory /var/www/html/spotweb> Options Indexes FollowSymLinks MultiViews AllowOverride All Require all granted </Directory> ErrorLog ${APACHE_LOG_DIR}/spotweb_error.log CustomLog ${APACHE_LOG_DIR}/spotweb_access.log combined </VirtualHost> EOF a2dissite 000-default.conf > /dev/null 2>&1 a2ensite spotweb.conf > /dev/null 2>&1 systemctl enable apache2 > /dev/null 2>&1 systemctl restart apache2 print_success "Apache configured" fi # Download Spotweb print_info "Downloading Spotweb from GitHub..." echo " → Cloning repository (master branch)" rm -rf "$SPOTWEB_DIR" if git clone -b master --depth 1 https://github.com/spotweb/spotweb.git "$SPOTWEB_DIR"; then print_success "Spotweb downloaded" else echo -e "${RED}✗ Failed to download Spotweb${NC}" echo "Please check your internet connection and try again" exit 1 fi # Set permissions print_info "Setting file permissions..." echo " → Setting owner to www-data" chown -R www-data:www-data "$SPOTWEB_DIR" echo " → Setting directory permissions (755)" find "$SPOTWEB_DIR" -type d -exec chmod 755 {} \; echo " → Setting file permissions (644)" find "$SPOTWEB_DIR" -type f -exec chmod 644 {} \; echo " → Creating cache directory" mkdir -p "${SPOTWEB_DIR}/cache" chmod 777 "${SPOTWEB_DIR}/cache" print_success "Permissions set" # Create database config print_info "Creating configuration files..." echo " → Creating dbsettings.inc.php" cat > "${SPOTWEB_DIR}/dbsettings.inc.php" <<EOF <?php \$dbsettings['engine'] = 'mysql'; \$dbsettings['host'] = 'localhost'; \$dbsettings['dbname'] = '${DB_NAME}'; \$dbsettings['user'] = '${DB_USER}'; \$dbsettings['pass'] = '${DB_PASS}'; ?> EOF chown www-data:www-data "${SPOTWEB_DIR}/dbsettings.inc.php" chmod 640 "${SPOTWEB_DIR}/dbsettings.inc.php" # Create basic ownsettings.php echo " → Creating ownsettings.php" cat > "${SPOTWEB_DIR}/ownsettings.php" <<'EOF' <?php error_reporting(E_ALL); $settings['custom_stylesheet'] = ''; ?> EOF chown www-data:www-data "${SPOTWEB_DIR}/ownsettings.php" chmod 644 "${SPOTWEB_DIR}/ownsettings.php" print_success "Configuration files created" # Note: vendor/ directory is included in Spotweb git repo, so no Composer needed cd "$SPOTWEB_DIR" # Initialize Spotweb database print_info "Initializing Spotweb database schema..." echo " → Creating tables and structure" php ${SPOTWEB_DIR}/bin/upgrade-db.php print_success "Database initialized" # Reset admin password to default print_info "Setting admin password..." echo " → Resetting admin user password to default" php ${SPOTWEB_DIR}/bin/upgrade-db.php --reset-password admin print_success "Admin password set to: spotweb" # Setup systemd timer print_info "Configuring automatic spot retrieval..." echo " → Creating systemd service" cat > /etc/systemd/system/spotweb-retrieve.service <<EOF [Unit] Description=Spotweb Spot Retrieval After=network.target mysql.service [Service] Type=oneshot User=www-data WorkingDirectory=${SPOTWEB_DIR} ExecStart=/usr/bin/php ${SPOTWEB_DIR}/retrieve.php StandardOutput=journal StandardError=journal [Install] WantedBy=multi-user.target EOF echo " → Creating systemd timer (hourly execution)" cat > /etc/systemd/system/spotweb-retrieve.timer <<'EOF' [Unit] Description=Run Spotweb Retrieval Hourly [Timer] OnBootSec=5min OnUnitActiveSec=1h Persistent=true [Install] WantedBy=timers.target EOF echo " → Enabling and starting timer" systemctl daemon-reload systemctl enable spotweb-retrieve.timer systemctl start spotweb-retrieve.timer print_success "Automatic retrieval configured (runs every hour)" # Save credentials to file for easy access print_info "Saving credentials..." cat > /root/spotweb-credentials.txt <<EOF Spotweb Installation Credentials ================================ Database Name: ${DB_NAME} Database User: ${DB_USER} Database Password: ${DB_PASS} Web Interface: http://$(hostname -I | awk '{print $1}')/ Admin Login: Username: admin Password: spotweb Installation Date: $(date) EOF chmod 600 /root/spotweb-credentials.txt echo "" echo -e "${GREEN}╔════════════════════════════════════════════════════════════╗${NC}" echo -e "${GREEN}║ Installation Complete! ║${NC}" echo -e "${GREEN}╚════════════════════════════════════════════════════════════╝${NC}" echo "" echo -e "${YELLOW}Database Credentials (SAVE THESE):${NC}" echo "" echo " Database: ${DB_NAME}" echo " Username: ${DB_USER}" echo " Password: ${DB_PASS}" echo "" echo -e "${BLUE}Credentials saved to: /root/spotweb-credentials.txt${NC}" echo "" INSTALLER_SCRIPT # Replace webserver placeholder in the script pct exec $CTID -- sed -i "s/WEBSERVER_PLACEHOLDER/${WEBSERVER}/g" /tmp/installer.sh 2>/dev/null || true # Get the credentials echo "" echo -e "${GREEN}╔════════════════════════════════════════════════════════════╗${NC}" echo -e "${GREEN}║ Spotweb Installation Complete! ║${NC}" echo -e "${GREEN}╚════════════════════════════════════════════════════════════╝${NC}" echo "" echo -e "${CYAN}Container Information:${NC}" echo -e " Container ID: ${CTID}" echo -e " Hostname: ${HOSTNAME}" echo -e " IP Address: ${IP}" echo -e " Web Server: ${WEBSERVER}" echo "" # Get credentials from container CREDS=$(pct exec $CTID -- cat /root/spotweb-credentials.txt 2>/dev/null) echo -e "${YELLOW}Database Credentials:${NC}" echo "" pct exec $CTID -- grep -E "Database Name|Database User|Database Password" /root/spotweb-credentials.txt 2>/dev/null echo "" echo -e "${YELLOW}Admin Login Credentials:${NC}" echo "" echo -e " Username: ${GREEN}admin${NC}" echo -e " Password: ${GREEN}spotweb${NC}" echo "" echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}" echo -e "${GREEN}Access Spotweb:${NC}" echo "" echo -e " ${BLUE}→ http://${IP}/${NC}" echo "" echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}" echo "" echo -e "${CYAN}Next Steps:${NC}" echo " 1. Open the URL above in your browser" echo " 2. Login with default admin credentials (admin/spotweb)" echo " 3. Configure your Usenet server in Settings" echo " 4. Start retrieving spots!" echo "" echo -e "${CYAN}Container Management:${NC}" echo " Enter container: pct enter ${CTID}" echo " View credentials: pct exec ${CTID} -- cat /root/spotweb-credentials.txt" echo " Stop container: pct stop ${CTID}" echo " Start container: pct start ${CTID}" echo " Check retrieval: pct exec ${CTID} -- systemctl status spotweb-retrieve.timer" echo "" # Calculate elapsed time END_TIME=$(date +%s) ELAPSED=$((END_TIME - START_TIME)) MINUTES=$((ELAPSED / 60)) SECONDS=$((ELAPSED % 60)) echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}" echo -e "${GREEN}✓ Installation completed in ${MINUTES}m ${SECONDS}s${NC}" echo -e "${GREEN}━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━${NC}" echo ""
dit maakt de CT aan, installeerd spotweb en al het nodige... bij mij duurt het 1 minuut
Gadget-freakz.com. Feedback en tips zijn welkom.
Thx, aanpassing aan de themes is nog mogelijk; en zal nog van doen zijn ...[Video: https://private-user-images.githubusercontent.com/666520/524114977-125be297-9d80-4632-b2cf-73059957dfae.mp4?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjUyNjEzNzUsIm5iZiI6MTc2NTI2MTA3NSwicGF0aCI6Ii82NjY1MjAvNTI0MTE0OTc3LTEyNWJlMjk3LTlkODAtNDYzMi1iMmNmLTczMDU5OTU3ZGZhZS5tcDQ_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUxMjA5JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MTIwOVQwNjE3NTVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1hMjUyYjE5MGFmYmNhZmM3NmM5YTY3ZDk3Y2UwOGMwMmViY2NkMDU3ZWU4YWNmNzY2OWY5ODVhNmY4NDZjNzRhJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.8GbFYmWt64paz5JEcrshX9TA_D9SWjEp31Tfiekvc7U]
:strip_exif()/f/image/dVDQiTc0gZGu2D5ssc2wZ30G.png?f=user_large)
:strip_exif()/f/image/BivzxxbrASMBzIQ0hxjp65AK.png?f=user_large)
:strip_exif()/f/image/Yq8k0rcgl3DzRNDD62NGJjg2.png?f=user_large)
[ Voor 94% gewijzigd door Venimk1 op 09-12-2025 07:23 ]
dat zal ik later ff bezien....:
kan je deze in de repo van helper scripts plaatsen? dan hebben duizenden mensen er wat aan
Super! ik heb hem nu als home assistant addon maar een lxc lijkt mij beter!
:
the LXC setup installer + spotweb
wget https://raw.githubusercon...te-and-install-spotweb.sh
chmod +x proxmox-create-and-install-spotweb.sh
./proxmox-create-and-install-spotweb.sh
Option 3 Theme Pack
= spotweb install met 8 preinstalled themes
Theme Editor
wget https://raw.githubusercon...nly/deploy-theme-tools.sh
chmod +x deploy-theme-tools.sh
./deploy-theme-tools.sh
Access your theme tools:
🎨 Theme Customizer:
http://YOUR_IP/tools/theme-customizer.html
📤 Theme Upload:
http://YOUR_IP/tools/theme-upload.php
(Default password: spotweb123)
💡 Workflow:
1. Create theme in Customizer
2. Download CSS file
3. Upload via Upload Tool
4. Theme appears in Spotweb instantly!
🔒 Security Note:
Change upload password in: theme-upload.php (line
Gadget-freakz.com. Feedback en tips zijn welkom.
Dit werkt perfect, dankjewel!
[ Voor 36% gewijzigd door Bakkertje_01 op 15-12-2025 12:27 ]
Ik heb het net nagekeken en heb sowiezo maar 20 connecties van de 50 ingesteld om te downloaden. Ik vermoed dat het bij Eweka zal liggen.
Nu kan ik weer bedankjes achterlaten.
[ Voor 27% gewijzigd door Bubble-BE op 22-12-2025 15:39 ]
Dit is hopelijk wel over https? 119 is naar mijn weten unencrypted. Ik gebruik alleen nog maar TLS, ook al is dat mogelijk langzamer.:
[...]
Ik heb het net nagekeken en heb sowiezo maar 20 connecties van de 50 ingesteld om te downloaden. Ik vermoed dat het bij Eweka zal liggen.
Edit: gevonden! Geen idee of het nieuw is, maar je moet nu een andere server ingeven als je wil posten.
[...]
Nu kan ik weer bedankjes achterlaten.
:strip_exif()/f/image/WVXALZHGlFVBESZyt4CKCpsy.png?f=user_large)
1
| git fetch origin themes-only:refs/remotes/origin/themes-only |
1
| ./update-themes.sh |
[ Voor 9% gewijzigd door Webjunkie op 06-01-2026 19:45 ]
:strip_icc():strip_exif()/u/32068/kanarie_klein.jpg?f=community)
:strip_icc():strip_exif()/u/65843/chef60x60.jpg?f=community)
:strip_icc():strip_exif()/u/63169/crop62e2741907d9b_cropped.jpg?f=community)
/u/438991/crop60e72c64b6ce6_cropped.png?f=community)
/u/113691/Boxee3.png?f=community)
:strip_icc():strip_exif()/u/485368/crop56fb87f6373c9_cropped.jpeg?f=community)
/u/424300/crop5f1ff702b07dc_cropped.png?f=community)
:strip_icc():strip_exif()/u/20862/dusty2.jpg?f=community)
/u/34186/crop62e07d174532d_cropped.png?f=community)
/u/188033/crop61646ce500644_cropped.png?f=community)
:strip_exif()/u/217171/avatar60.gif?f=community){kind=avatar}
:strip_icc():strip_exif()/u/29789/crop5e0e0442175ae_cropped.jpeg?f=community)
:strip_icc():strip_exif()/u/126677/crop5db3098e0d250.jpeg?f=community)
/u/201086/crop5dc1ddf0ec80b.png?f=community)
:strip_exif()/f/image/PTrWHId6ZaPdRgvH41j3wcfh.png?f=user_large)
:strip_exif()/f/image/5O8ln0oQxW99LCIJO3gEl2cx.png?f=user_large)
:strip_icc():strip_exif()/u/289675/crop6401bf2c85501_cropped.jpg?f=community)
:strip_icc():strip_exif()/u/1146931/crop5bffcf9e2aea8_cropped.jpeg?f=community)
:strip_icc():strip_exif()/u/114280/web.jpg?f=community)
:strip_icc():strip_exif()/u/228018/crop5ee8807bd52c7_cropped.jpeg?f=community)