Startseite NF

02.03.2022 - Lesezeit: 2 Minuten

<?php

function anzeige_ohne_caption($sql){ $result = db_query_range($sql,0,10); foreach ($result as $record) { $node=node_load($record->nid); $node->title = ''; $anzeige = node_view($node, 'full'); $rendered = render($anzeige); print $rendered; echo '


'; } }

function anzeige($sql,$caption=''){ $result = db_query_range($sql,0,10); if (($result->rowCount()>0) and ($caption<>'')) { echo '


'; echo '

'.$caption.'

'; echo '
'; } foreach ($result as $record) { $node=node_load($record->nid); $anzeige = node_view($node, 'teaser'); $rendered = render($anzeige); print $rendered; } }

// Das Intro anzeigen $sql = "SELECT * FROM {node} WHERE nid=1 ORDER BY created ASC"; anzeige_ohne_caption($sql);

// Die oben in Listen Termine anzeigen $sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=1 ORDER BY created ASC"; anzeige($sql,'');

// Die heutigen Termine anzeigen $sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=0 AND DATE(FROM_UNIXTIME(created))=CURDATE() ORDER BY created DESC"; anzeige($sql,'Heute in Niederfrohna');

//Zukunft anzeigen 28 Tage $sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=0 AND DATE(FROM_UNIXTIME(created))>CURDATE() AND FROM_UNIXTIME(created)<DATE_ADD(CURDATE(),INTERVAL 28 DAY) ORDER BY created ASC"; anzeige($sql,'Demnächst in Niederfrohna');

//Vergangenheit anzeigen $sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND DATE(FROM_UNIXTIME(created))<CURDATE() AND sticky<>1 ORDER BY created DESC"; anzeige($sql,'Das war los in Niederfrohna');

?>

Tags: php

python3-fdb apache docker

17.12.2021 - Lesezeit: ~1 Minute

Das Python-wsgi Programm läuft einen halben Tag ohne Probleme, doch dann kommt eine Fehlermeldung:

[ERROR] incompatible types, LP_c_short instance instead of LP_c_short instance

Tags: Python Apache Docker

Docker

10.12.2021 - Lesezeit: ~1 Minute

svn checkout https://svn.wlsoft.de/web/docker

$ sudo docker ps -a

$ docker image prune 

$ docker image list

cd ~/Entwicklung/docker/lizenz
sudo docker build . -t wnf_lizenz

sudo docker-compose down

$ sudo docker-compose up -d

$ sudo docker exec -it lizenz_lizenz_1 /bin/bash
Tags:

Tastatur mit Hintergrundbeleuchtung

05.12.2021 - Lesezeit: ~1 Minute

In der Bedienungsanleitung steht, dass die Beleuchtung mit der SL-Taste eingeschaltet wird.

Das funktioniert unter Linux nicht.

Die Suche nach linux keyboard backlight control erbrachte

$ xset led 3
Tags: Linux-Hardware

Kein Zugriff über ssh (ungelöst): Connection reset by peer

25.11.2021 - Lesezeit: ~1 Minute

kex_exchange_identification: read: Connection reset by peer
```-
Tags: Linux-Grundlagen ssh

Redmine unter Docker

09.11.2021 - Lesezeit: ~1 Minute

docker-compose.yml


version: '3.3'

services:

  redmine:
    image: redmine
    restart: always
    ports:
      - 8080:3000
    secrets:
      - mysql_root
      - mysql_user
    environment:
      REDMINE_DB_MYSQL: db
      REDMINE_DB_PASSWORD_FILE: /run/secrets/mysql_root
      REDMINE_SECRET_KEY_BASE_FILE: /run/secrets/mysql_user
    volumes:
      - ./files:/usr/src/redmine/files

  db:
    image: mariadb:latest
    restart: always
    secrets: 
      - mysql_root
    environment:
      MYSQL_ROOT_PASSWORD_FILE: /run/secrets/mysql_root
      MYSQL_DATABASE: redmine
    volumes:
      - ./db:/var/lib/mysql
      - ./init:/docker-entrypoint-initdb.d
      - ./backup:/var/backups

secrets:
  mysql_root:
    file: ./mysql_root.txt
  mysql_user:
    file: ./mysql_user.txt
```-
Tags: Docker Redmine