Recherche avancée

Sur d’autres sites (13915)

• Anomalie #4401 : Erreur bloquante avec sql_showtable() en sqlite

  20 novembre 2019, par tcharlss (*´_ゝ｀)

  Pour compléter, le retour d’un var_dump($a) juste après spip_sqlite_fetch L.1782 au cas-où :
  

  array (size=2)
    ’sql’ => string ’CREATE TABLE "spip_billets_types" (
      `id_billets_type`    INTEGER NOT NULL,
      `id_billetterie`    bigint ( 21 ) NOT NULL DEFAULT 0,
      `titre`    text NOT NULL DEFAULT "" COLLATE NOCASE,
      `descriptif`    text NOT NULL DEFAULT "" COLLATE NOCASE,
      `quota`    int ( 11 ) NOT NULL DEFAULT 0,
      `prix`    decimal ( 20 , 6 ) NOT NULL DEFAULT 0,
      `taxe`    decimal ( 4 , 4 ) NOT NULL DEFAULT 0,
      `selection_min`    int ( 11 ) NOT NULL DEFAULT 0,
      `selection_max`    int ( 11 ) NOT NULL DEFAULT 0,
      `date_fin`    datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
      `date_debut`    datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
      `maj`    TIMESTAMP,
      `composition`    varchar ( 255 ) NOT NULL DEFAULT ’’ COLLATE NOCASE,
      `composition_lock`    tinyint ( 1 ) NOT NULL DEFAULT 0,
      `rang`    int NOT NULL DEFAULT 0, id_profil bigint(21) NOT NULL DEFAULT 0,
      PRIMARY KEY(`id_billets_type`)
  )’ (length=828)
    ’type’ => string ’table’ (length=5)
  

• Low FPS output using ffmpeg and a raspi camera

  23 novembre 2019, par Newe

  I am building a surveillance camera for a school project, which is based on a raspberry pi and a infrared raspberry Pi camera.

  I am capturing the camera’s video stream and outputting it as an HLS stream directly from ffmpeg. However, the resulting video is really low fps ( 5 at max)

  Strangely, raspivid manages to ouput a 60fps 720p stream without any problem, but when put through ffmpeg for streaming, the video is cropped in half and i cannot get it to show up entirely.

  Here is the ffmpeg command i use :

  #!/bin/bash
  
  ffmpeg -v verbose \
  
  -re \
  
  -i /dev/video0 \
  
  -c:v libx264 \
  
  -an \
  
  -f hls \
  
  -g 10  \
  
  -sc_threshold 0 \
  
  -hls_time 1 \
  
  -hls_list_size 4 \
  
  -hls_delete_threshold 1 \
  
  -hls_flags delete_segments \
  
  -hls_start_number_source datetime \
  
  -hls_wrap 15 \
  
  -preset superfast \
  
  -start_number 1 \
  
  /home/pi/serv/assets/stream.m3u8

  And the resulting log output (notice the fps)

  

  Here is the command using raspivid that i tested, based on a blog post i read :

  raspivid -n \
  
  -t 0 \
  
  -w 960 \
  
  -h 540 \
  
  -fps 25 \
  
  -o - | ffmpeg \
  
  -v verbose \
  
  -i - \
  
  -vcodec copy \
  
  -an \
  
  -f hls \
  
  -g 10 \
  
  -sc_threshold 0 \
  
  -hls_time 1 \
  
  -hls_list_size 4 \
  
  -hls_delete_threshold 1 \
  
  -hls_flags delete_segments \
  
  -hls_start_number_source datetime \
  
  -hls_wrap 15 \
  
  -preset superfast \
  
  -start_number 1 \
  
  /home/pi/serv/assets/stream.m3u8

  I am not a ffmpeg expert and am open to any suggestions that would help improve the stream’s quality and stability :)

• FFMPEG : new m3u8 playlist in every hour from the same segmented stream

  23 mars 2018, par iPog

  I’m using the latest Windows build of FFMPEG (by Zeranoe).

  Currently I create 2 outputs from the same raw live video input. I use the tee pseudo-muxer to give the user the following outputs :

  • PRIMARY OUTPUT : transcoded live stream ; using the HLS or the segment muxer ; 14 pieces of 10-second-long segments on a ramdisk.
  • SECONDARY OUTPUT : from the same transcoding I store every segment on the hard drive ; to make the hard drive versions watchable, I create m3u8 playlists with an automated batch script in every hour ; all individual playlist files contain 1 hour of content.

  Is it possible to achieve the same result with FFMPEG only ? I.e. the secondary output should be able to finish the current m3u8 playlist, and start a new one with a new filename at every hour o’clock.

  (My batch-based solution works fine, so it isn’t that important, but it would be nice to know if it is possible at all. I could not find a similar approach in the documentation/wiki.)