Recherche avancée

Sur d’autres sites (9183)

• Evolution #3771 : Ne plus mettre en cache la page 404

  27 avril 2016, par - Equipement

  Avec le squelette 404 de la dist (qui reste en cache), la trace des requêtes SQL sur le second appel (afin que la page soit prise dans le cache) sur le site public d’une page qui n’existe pas, donne les résultats suivants (sous SPIP 3.0.22) :

  "set sql_mode=’’" 
  "SELECT valeur FROM `nomdelabase`.spip_meta WHERE nom=’charset_sql_connexion’" 
  "SET NAMES ’utf8’" 
  "SHOW TABLES LIKE ’spip\\_%’" 
  "SHOW CREATE TABLE `spip_rubriques`" 
  "SHOW CREATE TABLE `spip_articles`" 
  "SHOW CREATE TABLE `spip_auteurs`" 
  "SHOW CREATE TABLE `spip_mots`" 
  "SHOW CREATE TABLE `spip_syndic`" 
  "SELECT * FROM `nomdelabase`.spip_meta WHERE nom=’pcre_u’" 
  

  suivi immédiatement les requêtes de la tâche de fond :
  

  "set sql_mode=’’" 
  "SELECT valeur FROM `nomdelabase`.spip_meta WHERE nom=’charset_sql_connexion’" 
  "SET NAMES ’utf8’" 
  "SELECT * FROM `nomdelabase`.spip_jobs WHERE status=1 AND date<=’2016-04-27 15:26:01’ ORDER BY priorite DESC,date LIMIT 0,201" 
  "DELETE FROM `nomdelabase`.spip_jobs
  "SHOW CREATE TABLE `spip_jobs`" 
  "INSERT INTO spip_jobs (id_job,descriptif,fonction,args,md5args,inclure,priorite,date,status) VALUES (320,’Tâche CRON syndic (toutes les 90s)’,’syndic’,’a:1 :i:0 ...
  "SELECT id_syndic FROM `nomdelabase`.spip_syndic WHERE ((syndication  IN (’sus’,’off’))) AND statut<>’refuse’ AND NOT((date_syndic>DATE_SUB(’2016-04-27 15:26:01’, INTERVAL 1440 MINUTE))) ORDER BY date_syndic LIMIT 1" 
  "SELECT id_syndic FROM `nomdelabase`.spip_syndic WHERE syndication=’oui’ AND statut<>’refuse’ AND NOT((date_syndic>DATE_SUB(’2016-04-27 15:26:01’, INTERVAL 120 MINUTE))) ORDER BY date_syndic LIMIT 1" 
  "SELECT id_job FROM `nomdelabase`.spip_jobs WHERE status=1 AND fonction=’syndic’" 
  "INSERT INTO spip_jobs (fonction,descriptif,args,md5args,inclure,priorite,date,status) VALUES (’syndic’,’Tâche CRON syndic (toutes les 90 s)’,’a:1 :i:0
  "SELECT id_job FROM `nomdelabase`.spip_jobs WHERE id_job<321 AND status=1 AND fonction=’syndic’" 
  "SELECT * FROM `nomdelabase`.spip_jobs WHERE status=0 AND date<’2016-04-27 15:23:01’" 
  "SELECT date FROM `nomdelabase`.spip_jobs WHERE status=1 ORDER BY date LIMIT 0,1" 
  "SELECT COUNT(*) FROM `nomdelabase`.spip_jobs WHERE status=1 AND date<’2016-04-27 15:26:01’" 
  "DELETE FROM `nomdelabase`.spip_jobs_liens WHERE id_job=320" 
  "DELETE FROM `nomdelabase`.spip_jobs
  

  Visiblement, si la page 404 reste dans le cache, il y a quand même une connexion à Mysql (suivie d’une seconde pour la tâche de fond).

• rails streamio-ffmpeg does not find uploaded video files

  26 avril 2016, par Felix

  I try to make a screenshot as thumbnail of a movie while uploading.

  My code looks like this at the moment

  require 'rubygems'
  
  require 'streamio-ffmpeg'
  
  
  
   def uploadMovie
  
     @channels = Channel.all
  
     @vid = Movie.new(movies_params)
  
  
  
     @channel = Channel.find(params[:vid][:channel_id])
  
     @vid.channel = @channel
  
  
  
     if @vid.save
  
       flash[:notice] = t("flash.saved")
  
       movieFile = FFMPEG::Movie.new(@vid.video.to_s)
  
       screenshot = movieFile.screenshot("uploads/screenshot", :seek_time => 10)
  
       render :add
  
     else
  
       render :add
  
     end
  
   end

  But when I do this I got this error :

    No such file or directory - the file 'http://.s3.amazonaws.com/uploads/movie/video/7/2016-04-24_16.26.10.mp4' does not exist

  That should be okay because I upload the movies to Amazon S3 with carrierwave ...

  What’s going wrong in this case ?

• Ffmpeg generated movie (png -> mp4) has no video

  21 avril 2016, par ILiveForVR

  I have a whole bunch of png’s which I would like to convert into a mp4 video.
  I am using the following command to stich them together :
  ffmpeg -i _2016-04-20_14-51-00-500_%06d.png -pix_fmt yuv420p movie.mp4

  I am getting a file, which has a size so it isn’t empty. But when I play it in VLC or Quicktime it shows the time going by, but it has no video in it. Any idea what I’m doing wrong ?
  I also tried :

  ffmpeg -framerate 1/5 -i _2016-04-20_14-51-00-500_%06d.png -c:v libx264 -r 30 -pix_fmt yuv420p out.mp4

  and

  ffmpeg -r 45 -f image2 -s 1920x1080 -i _2016-04-20_14-51-00-500_%06d.png -vcodec libx264 -crf 25  -pix_fmt yuv420p test.mp4

  But still no video.
  This is the commandline output :

  >ffmpeg -i _2016-04-20_14-51-00-500_%06d.png -pix_fmt yuv420p movie.mp4
  
  ffmpeg version N-79546-g13406b6 Copyright (c) 2000-2016 the FFmpeg developers
  
    built with gcc 5.3.0 (GCC)
  
    configuration: --enable-gpl --enable-version3 --disable-w32threads --enable-avisynth --enable-bzlib --enable-fontconfig --enable-frei0r --enable-gnutls --enable-iconv --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libfreetype --enable-libgme --enable-libgsm --enable-libilbc --enable-libmodplug --enable-libmfx --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-libopus --enable-librtmp --enable-libschroedinger --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libtheora --enable-libtwolame --enable-libvidstab --enable-libvo-amrwbenc --enable-libvorbis --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxavs --enable-libxvid --enable-libzimg --enable-lzma --enable-decklink --enable-zlib
  
    libavutil      55. 22.100 / 55. 22.100
  
    libavcodec     57. 35.100 / 57. 35.100
  
    libavformat    57. 34.102 / 57. 34.102
  
    libavdevice    57.  0.101 / 57.  0.101
  
    libavfilter     6. 44.100 /  6. 44.100
  
    libswscale      4.  1.100 /  4.  1.100
  
    libswresample   2.  0.101 /  2.  0.101
  
    libpostproc    54.  0.100 / 54.  0.100
  
  Input #0, image2, from '_2016-04-20_14-51-00-500_%06d.png':
  
    Duration: 00:00:02.60, start: 0.000000, bitrate: N/A
  
      Stream #0:0: Video: png, rgba(pc), 8192x4096 [SAR 3779:3779 DAR 2:1], 25 tbr, 25 tbn
  
  [libx264 @ 00000000025851e0] using SAR=1/1
  
  [libx264 @ 00000000025851e0] frame MB size (512x256) > level limit (36864)
  
  [libx264 @ 00000000025851e0] DPB size (4 frames, 524288 mbs) > level limit (1 frames, 184320 mbs)
  
  [libx264 @ 00000000025851e0] MB rate (3276800) > level limit (2073600)
  
  [libx264 @ 00000000025851e0] using cpu capabilities: MMX2 SSE2Fast SSSE3 SSE4.2 AVX FMA3 AVX2 LZCNT BMI2
  
  [libx264 @ 00000000025851e0] profile High, level 5.2
  
  [libx264 @ 00000000025851e0] 264 - core 148 r2665 a01e339 - H.264/MPEG-4 AVC codec - Copyleft 2003-2016 - http://www.videolan.org/x264.html - options: cabac=1 ref=3 deblock=1:0:0 analyse=0x3:0x113 me=hex subme=7 psy=1 psy_rd=1.00:0.00 mixed_ref=1 me_range=16 chroma_me=1 trellis=1 8x8dct=1 cqm=0 deadzone=21,11 fast_pskip=1 chroma_qp_offset=-2 threads=18 lookahead_threads=3 sliced_threads=0 nr=0 decimate=1 interlaced=0 bluray_compat=0 constrained_intra=0 bframes=3 b_pyramid=2 b_adapt=1 b_bias=0 direct=1 weightb=1 open_gop=0 weightp=2 keyint=250 keyint_min=25 scenecut=40 intra_refresh=0 rc_lookahead=40 rc=crf mbtree=1 crf=23.0 qcomp=0.60 qpmin=0 qpmax=69 qpstep=4 ip_ratio=1.40 aq=1:1.00
  
  [mp4 @ 0000000002583fc0] Using AVStream.codec to pass codec parameters to muxers is deprecated, use AVStream.codecpar instead.
  
  Output #0, mp4, to 'movie.mp4':
  
    Metadata:
  
      encoder         : Lavf57.34.102
  
      Stream #0:0: Video: h264 ([33][0][0][0] / 0x0021), yuv420p, 8192x4096 [SAR 1:1 DAR 2:1], q=2-31, 25 fps, 12800 tbn
  
      Metadata:
  
        encoder         : Lavc57.35.100 libx264
  
      Side data:
  
        cpb: bitrate max/min/avg: 0/0/0 buffer size: 0 vbv_delay: -1
  
  Stream mapping:
  
    Stream #0:0 -> #0:0 (png (native) -> h264 (libx264))
  
  Press [q] to stop, [?] for help
  
  frame=   65 fps=3.2 q=-1.0 Lsize=   13498kB time=00:00:02.48 bitrate=44585.2kbits/s speed=0.123x    6x
  
  video:13497kB audio:0kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: 0.009971%
  
  [libx264 @ 00000000025851e0] frame I:1     Avg QP:16.71  size:1373751
  
  [libx264 @ 00000000025851e0] frame P:52    Avg QP:23.59  size:234822
  
  [libx264 @ 00000000025851e0] frame B:12    Avg QP:21.17  size: 19609
  
  [libx264 @ 00000000025851e0] consecutive B-frames: 73.8%  3.1%  4.6% 18.5%
  
  [libx264 @ 00000000025851e0] mb I  I16..4: 14.7% 73.8% 11.5%
  
  [libx264 @ 00000000025851e0] mb P  I16..4:  3.1%  5.9%  0.5%  P16..4: 23.2%  7.7%  2.0%  0.0%  0.0%    skip:57.5%
  
  [libx264 @ 00000000025851e0] mb B  I16..4:  0.1%  0.1%  0.0%  B16..8:  9.0%  0.2%  0.0%  direct: 0.2%  skip:90.3%  L0:33.0% L1:66.6% BI: 0.4%
  
  [libx264 @ 00000000025851e0] 8x8 transform intra:63.5% inter:78.5%
  
  [libx264 @ 00000000025851e0] coded y,uvDC,uvAC intra: 33.7% 3.1% 1.0% inter: 10.1% 0.4% 0.0%
  
  [libx264 @ 00000000025851e0] i16 v,h,dc,p: 24% 57%  3% 17%
  
  [libx264 @ 00000000025851e0] i8 v,h,dc,ddl,ddr,vr,hd,vl,hu: 14% 31% 38%  2%  3%  2%  5%  2%  4%
  
  [libx264 @ 00000000025851e0] i4 v,h,dc,ddl,ddr,vr,hd,vl,hu: 12% 63% 10%  2%  2%  1%  5%  1%  4%
  
  [libx264 @ 00000000025851e0] i8c dc,h,v,p: 94%  2%  3%  0%
  
  [libx264 @ 00000000025851e0] Weighted P-Frames: Y:0.0% UV:0.0%
  
  [libx264 @ 00000000025851e0] ref P L0: 71.6% 13.1% 10.8%  4.4%
  
  [libx264 @ 00000000025851e0] ref B L0: 69.0% 30.6%  0.4%
  
  [libx264 @ 00000000025851e0] ref B L1: 89.7% 10.3%
  
  [libx264 @ 00000000025851e0] kb/s:42522.38