Recherche avancée

Sur d’autres sites (5900)

• Anomalie #2924 (Nouveau) : MySQL ne retourne pas toute la table /* warning */

  5 janvier 2013, par YannX spip

  Bug relevant plutot de MySQL (détecté avec saveauto 1.0.beta)

  l’instruction mysql_query(’SHOW CREATE TABLE spip_articles’) ne renvoit pas le dernier champ (’virtuel’) de meme que phpMyAdmin , au contraire de mysqldump (problème egalement rencontré sur un serveur OVH mutualisé (sql5.modules) (...)

• FFmpeg doesn't work in Rails 3 app with Apache and Passenger in GoDaddy CentOS

  29 décembre 2011, par pablo89

  I try to upload a .mp4 video file, and it works ; I made a Bash script that calls ffmpeg in order to get the thumbs of the video. It works fine in localhost, but when I uploaded the project to a dedicated server in GoDaddy with CentOS it doesn't work, it doesn't create the thumbnails, and it shows no error. The Rails App is running under Apache with Passenger. I have tried everything, even I gave 0777 permissions to the action and to the Bash script, but nothing, it doesn't show any error, but it doesn't work.

  This is the action in Rails (as you can see, I use the commands system and exec) :

  def create
  
    if !params[:video][:video].nil?
  
      videoName = params[:video][:video].original_filename.gsub(/\s/,'_') 
  
      @video = Video.new({:title => params[:video][:title], :video => "/worshipvideos/#{videoName}"})
  
    else
  
      @video = Video.new({:title => params[:video][:title]})
  
    end
  
  
  
    if !params[:video][:video].nil?
  
      tmp = params[:video][:video].tempfile
  
      file = File.join("public/worshipvideos", videoName)
  
      FileUtils.cp tmp.path, file
  
      FileUtils.rm tmp
  
    end
  
  
  
    respond_to do |format|
  
      if @video.save
  
        if !params[:video][:video].nil?
  
          logger.debug "./createVideoPics.sh '#{videoName}'"
  
          fork do
  
            system("./createVideoPics.sh '#{videoName}'")
  
            #exec("./createVideoPics.sh '#{videoName}'")
  
          end
  
  
  
          @video.update_attribute("pic1", "worship_pics/#{videoName}_1.jpg")
  
          @video.update_attribute("pic2", "worship_pics/#{videoName}_2.jpg")
  
          @video.update_attribute("pic3", "worship_pics/#{videoName}_3.jpg")
  
        end
  
  
  
        format.html { redirect_to @video, notice: 'Video was successfully created.' }
  
        format.json { render json: @video, status: :created, location: @video }
  
      else
  
        format.html { render action: "new" }
  
        format.json { render json: @video.errors, status: :unprocessable_entity }
  
      end
  
    end
  
  end

  This is the script in Bash :

  #!/bin/bash
  
  chmod 0777 "public/worshipvideos/$1"
  
  ffmpeg -i "public/worshipvideos/$1" -an -ss 00:00:20 -r 1 -vframes 1 -f mjpeg -y "app/assets/images/worship_pics/${1}_1.jpg"
  
  ffmpeg -i "public/worshipvideos/$1" -an -ss 00:00:40 -r 1 -vframes 1 -f mjpeg -y "app/assets/images/worship_pics/${1}_2.jpg"
  
  ffmpeg -i "public/worshipvideos/$1" -an -ss 00:01:00 -r 1 -vframes 1 -f mjpeg -y "app/assets/images/worship_pics/${1}_3.jpg"
  
  echo "End of making thumbs"

  If I try to make the command in terminal ./createVideoPics.sh "abc.mp4" it works, it makes the thumbs ; it only doesn't work inside the Rails App.

  What do you think would be the problem ? thanks in advance

• FFMPEG : Extracting 20 images from a video of variable length

  12 novembre 2013, par Vapire

  I've browsed the internet for this very intensively, but I didn't find what I needed, only variations of it which are not quite the thing I want to use.

  I've got several videos in different lengths and I want to extract 20 images out of every video from start to the end, to show the broadest impression of the video.

  So one video is 16m 47s long => 1007s in total => I have to make one snapshot of the video every 50 seconds.

  So I figured using the -r switch of ffmpeg with the value of 0.019860973 (eq 20/1007) but ffmpeg tells me that the framerate is too small for it...

  The only way I figured out to do it would be to write a script which calls ffmpeg with a manipulated -ss switch and using -vframes 1 but this is quite slow and a little bit off for me since ffmpegs numerates the images itself...

  Any suggestions or directions ?

  Thanks,
  Vapire