Ik begrijp nog steeds niet wat de invloed van de newshost is op het al dan niet schonen van de database als de schoning zegt: alles vanaf 1 november 2009 bewaren......
/u/438991/crop60e72c64b6ce6_cropped.png?f=community)
:strip_icc():strip_exif()/u/65843/chef60x60.jpg?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)
"Technological advancements don't feel fun anymore because of the motivations behind so many of them." Bron
:strip_icc():strip_exif()/u/63169/crop62e2741907d9b_cropped.jpg?f=community)
/u/188033/crop61646ce500644_cropped.png?f=community)
:strip_exif()/u/217171/avatar60.gif?f=community){kind=avatar}
Deze problemen worden veroorzaakt door recente Windows 11-updates (KB5064081 en KB5065426).
Er is inmiddels een update beschikbaar. Deze wordt automatisch geïnstalleerd, maar je kunt hem ook handmatig downloaden via het spotnet forum.
:strip_icc():strip_exif()/u/29789/crop5e0e0442175ae_cropped.jpeg?f=community)
Ja, daar had ik dus ook last van... nieuwe posts kwamen wel binnen maar de comments bleven weg.
In de logfile van het 'retriever.php' script kwam ik regelmatig de volgende melding tegen:
Met diverse varianten van de getallen voor de 'Data too long for column' error melding en op verschillende 'rows'.
De errormelding geeft aan dat het 'retriever.php' script meer data in het veld wil stoppen dan dat het betreffende veld groot is.
De oplossing is simpel, het veld groter maken
'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
Ik voer de commando's uit als root op mijn linux server.
code:
1
2
3
4
| mysql
use spotweb;
alter table commentsfull modify usersignature varchar(512);
exit |
Mijn database is bijna 6GB op schijf dus dat duurde even... het resultaat was:
Kortom, een halfuurtje schrapen op de harddisk om het veld op te rekken.
Vanaf dat moment heeft het 'retriever.php' script alle ontbrekende records opgehaald en daarmee is mijn locale spotweb weer in orde.
:strip_icc():strip_exif()/u/126677/crop5db3098e0d250.jpeg?f=community)
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
code:
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 |
Welgeteld 1 hit in google
Zag dit commentaar en heb de develop versie zojuist gedownload en over de release versie gekopieerd.
Heb eerst de upgrade-db moeten draaien en daarna loopt het weer door als een zonnetje. Dank!
Absolute n00body
/u/201086/crop5dc1ddf0ec80b.png?f=community)
code:
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 "" |
dit maakt de CT aan, installeerd spotweb en al het nodige... bij mij duurt het 1 minuut
Een vraag: hoe voer ik dit script uit in Proxmox?:
code:
dit maakt de CT aan, installeerd spotweb en al het nodige... bij mij duurt het 1 minuut
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!
Super! ik heb hem nu als home assistant addon maar een lxc lijkt mij beter!
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!
even tussen code blocks zetten als wordt je url ongeldig 
hartelijk dank!!
hartelijk dank!!
:
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.
:strip_exif()/f/image/PTrWHId6ZaPdRgvH41j3wcfh.png?f=user_large)
Dit werkt perfect, dankjewel!
p.s.
Voor de mensen die dit lezen, direct uitvoeren en denken wat moet ik hierna nog doen:
1. De spotweb url openen
2. Rechtsboven inloggen als admin
3. Rechtsboven op Config klikken en dan Settings
4. Onder tabblad Newsservers je newsserver invoeren (Change == Save)
5. Onder tabblad retrieve kun je bepalen hoever je terug wilt gaan met de spots. Zet hier iets neer naar jouw eigen voorkeur. Ikzelf download alleen muziek en heb hem op 31 gezet en de datum aangepast naar 1-12-2025. -> Change
6. Nu kun je wachten totdat de Retrieve actie is uigevoerd. Maar je kunt in Proxmox dit ook forceren door naar de shell te gaan van je proxmox instance -> type: "pct enter [3 cijferig container uid]" -> vervolgens naar de map "cd /var/www/html/spotweb" -> en vervolgens het commando: /usr/bin/php retrieve.php uit te voeren. (dit kan vast korter)
Hierna worden spots geladen.
[ Voor 36% gewijzigd door Bakkertje_01 op 15-12-2025 12:27 ]