一个简单视频网站开发小记

前言

视频格式转换&＃xff0c;视频图片截取&＃xff0c;视频存储设计&＃xff0c;大文件上传处理以及相关配置&＃xff0c;前端视频播放&＃xff0c;视频播放流畅度&＃xff0c;每一个都不简单&＃xff0c;都需要花心思思考解决方法&＃xff01;基本上每个问题&＃xff0c;都是使用相应的开源库&＃xff01;

需求背景

手机拍摄的视频越来越多&＃xff0c;然而手机的容量有限&＃xff0c;故想到开发一个手机视频保存与播放的简单网站&＃xff0c;只需要实现我的需求即可&＃xff01;

技术实现方案

VBox&＃43;LNMP&＃43;Laravel5.1&＃43;ffmpeg&＃43;ckplayer
网站运行于笔记本虚拟机中

运行系统相关说明

Virtual Box:4.3.18
Linux:CentOS Linux release 7.1.1503 (Core)
Nginx:nginx/1.8.0
MySQL:Ver 5.7.9 for Linux on x86_64 (MySQL Community Server (GPL))
PHP:PHP 5.6.16
ffmpeg:version 2.6.3

实现效果图

源代码下载

http://files.cnblogs.com/files/wadeyu/familyvideo.zip

问题总结之PHP

1&＃xff09;编译安装PHP
yum install gcc gcc-c&＃43;&＃43; libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel curl curl-devel openssl openssl-devel
./configure --prefix&＃61;/usr/local/php --with-config-file-path&＃61;/usr/local/php/etc --with-mysql&＃61;/usr --with-mysqli&＃61;mysqlnd --with-iconv-dir&＃61;/usr --with-gd --with-freetype-dir&＃61;/usr --with-jpeg-dir&＃61;/usr --with-png-dir&＃61;/usr --with-zlib --disable-rpath --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --enable-mbregex --enable-fpm --enable-mbstring --with-mcrypt --with-openssl --with-mhash --enable-pcntl --enable-sockets --enable-soap --without-pear --enable-zip --with-bz2 --enable-calendar --enable-ftp --enable-ctype --enable-exif --disable-ipv6 --with-sqlite3 --enable-pdo --with-pdo-mysql&＃61;/usr --enable-phar --with-curl
2&＃xff09;yum install libmcrypt
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.163.com
* extras: mirrors.163.com
* updates: mirrors.163.com
No package libmcrypt available.
Error: Nothing to do
解决办法:
yum install epel-release //扩展包更新包
yum update //更新yum源
3&＃xff09;configure: error: Cannot find MySQL header files under /usr.
安装mysql-devel包 yum install mysql-devel
4&＃xff09;3.configure: error: Cannot find libmysqlclient under /usr.
find / -name &＃39;*libmysqlclient*&＃39;
/usr/lib64/mysql/libmysqlclient.so.18
/usr/lib64/mysql/libmysqlclient_r.so.18
/usr/lib64/mysql/libmysqlclient_r.so.18.1.0
/usr/lib64/mysql/libmysqlclient.so.20
/usr/lib64/mysql/libmysqlclient.so.18.1.0
/usr/lib64/mysql/libmysqlclient.so
/usr/lib64/mysql/libmysqlclient.a
/usr/lib64/mysql/libmysqlclient.so.20.0.9
发现其实保存在lib64那个目录下了&＃xff0c;拷贝一份到/usr/lib/mysql目录下就可以了
cp /usr/lib64/mysql/* /usr/lib/mysql/
5&＃xff09;composer安装
https://getcomposer.org/download/
file_get_contents(): Failed to enable crypto
解决方法&＃xff1a;
wget http://curl.haxx.se/ca/cacert.pem
curl -sS https://getcomposer.org/installer | php -- --cafile&＃61;cacert.pem
6&＃xff09;php-ffmpeg扩展编译安装
因为php-ffmpeg扩展很久没有更新&＃xff0c;跟我使用的ffmpeg版本不兼容&＃xff0c;编译安装过程中碰到不少坑&＃xff0c;
我使用这个扩展最新版本&＃43;加上修改编译配置才能成功
从GIT下载兼容最新版本的代码
git clone https://github.com/tony2001/ffmpeg-php.git ffmpeg-php-0.6.0
源代码目录找到config.m4文件&＃xff0c;ffmpeg头部检测的代码修改为:

7&＃xff09;mysqli::mysqli(): (HY000/2002): Can&＃39;t connect to local MySQL server through socket &＃39;MySQL&＃39; (2)
如果是localhost mysql客户端会尝试通过SOCKET连接 所以连不上 换成Ip地址就可以了 127.0.0.1

问题总结之Nginx

1&＃xff09;[error] 3109#0: *1 FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream, client: 10.0.2.2, server: localhost, request: "GET /phpinfo.php HTTP/1.1", upstream: "fastcgi://unix:/usr/local/php/run/php-fpm.socket:", host: "192.168.1.2"
nginx配置WEB根目录没有配置&＃xff0c;在SERVER CONTEXT设置好通用的ROOT就可以了&＃xff0c;还需要设置好SCRIPT_FILENAME这个参赛&＃xff0c;需要包含完整的路径&＃xff0c;有时候包含的fastcgi_params文件没有这个参数的设置&＃xff0c;需要主动设置好
2&＃xff09;windows下编辑虚拟机共享目录下的静态文件&＃xff0c;NGINX还是返回修改之前的文件
gzip on;开启gzip压缩解决了这个问题&＃xff0c;为什么&＃xff1f;
3&＃xff09;[error] 2126#0: *384 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 10.0.2.2, server: localhost, request: "POST /upload/ HTTP/1.1", upstream: "fastcgi://unix:/usr/local/php/run/php-fpm.socket", host: "192.168.1.2", referrer: "http://192.168.1.2/upload/"
fastcgi_read_timeout 600; # Set fairly high for debugging

问题总结之CentOS7

1&＃xff09;防火墙默认使用的是firewall不是iptables&＃xff0c;需要开放端口外部才能访问
开启端口
firewall-cmd --zone&＃61;public --add-port&＃61;80/tcp --permanent
重启防火墙
firewall-cmd --reload
2&＃xff09;开源视频库ffmpeg安装
因为用的最新的CentOS系统&＃xff0c;官方仓库中没要找到现成的rpm包&＃xff0c;费了一番周折找到第三方RPM仓库包含
先安装第三方仓库源 rpm -Uvh http://li.nux.ro/download/nux/dextop/el7/x86_64/nux-dextop-release-0-1.el7.nux.noarch.rpm
再安装ffmpeg yum install ffmpeg ffmpeg-devel
3&＃xff09;ffmpeg命令使用
ffmpeg -y -i IMG_0071.MOV -f mp4 -async 1 -acodec aac -vcodec libxvid -qscale 7 -dts_delta_threshold 1 -strict -2 output.mp4
ffmpeg -i test.asf -y -f image2 -t 0.001 -s 352x240 a.jpg

问题总结之MySQL

1&＃xff09;phpmysqladmin ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

 2) Your password has expired.

MySQL5.7版本以及以上自动开启了用户密码过期功能&＃xff0c;通过设置mysqld参数&＃xff1a;

default_password_lifetime&＃61;0 禁用此功能
然后重启mysql服务器

其它

1. nginx php-fpm php配置好了相关上传大文件的配置还是上传失败
1&＃xff09;检查php临时目录大小是否比上传文件要大几倍
2&＃xff09;临时目录需要有可写可执行权限
3&＃xff09;如果是虚拟机&＃xff0c;文件不要存储在共享目录下&＃xff0c;通过PHP move_uploaded_file文件移动到共享目录很慢&＃xff0c;而且碰到CGI程序中途退出

2.提供访问速度
1)laravel框架缓存
php artisan optimize --force
2)开启字节码缓存 opcache

后记

1.碰到的最大难点是ffmpeg库以及ffmpeg php扩展安装
2.视频需要加上标签分类
3.视频需要分片提高响应速度
4.使用虚拟机播放视频比较慢&＃xff0c;后面尝试使用树莓派

参考资料

[1] CentOS yum安装mcrypt
http://www.cnblogs.com/linux-super-meng/archive/2014/12/08/4150987.html
[2] PHP FastCGI Example
https://www.nginx.com/resources/wiki/start/topics/examples/phpfcgi/
[3] FastCGI sent in stderr: “Primary script unknown”
http://stackoverflow.com/questions/17194196/1-fastcgi-sent-in-stderr-primary-script-unknown
http://serverfault.com/questions/517190/nginx-1-fastcgi-sent-in-stderr-primary-script-unknown/517207#517207
[4] CentOS7 firewalld设置端口
http://www.cnblogs.com/kootao/p/4752435.html
[5] fedora/centos7防火墙FirewallD详解
http://www.cnblogs.com/yudar/p/4294500.html
[6] CentOS修改系统环境变量
http://www.linuxidc.com/Linux/2012-07/64532.htm
[7] 安装composer SSL operation failed with code 1
http://www.cnblogs.com/brookin/p/4425950.html
[8] Packagist / Composer 中国全量镜像
http://pkg.phpcomposer.com/
http://www.phpcomposer.com/
[9] 更改yum源为163镜像站点
http://mirrors.163.com/.help/centos.html
[10] FFmpeg常用基本命令
http://www.cnblogs.com/dwdxdy/p/3240167.html
http://www.cnblogs.com/top5/archive/2009/12/30/1636349.html
[11] Unable to install FFMPEG PHP extension
https://community.centminmod.com/threads/unable-to-install-ffmpeg-php-extension.1519/page-2
[12] Compile against newer ffmpeg fails because of avutil/time.h
http://sourceforge.net/p/ffmpeg-php/bugs/59/
[13] ffmpeg官方网站
http://ffmpeg-php.sourceforge.net/index.php
[14] mysqli::mysqli(): (HY000/2002): Can&＃39;t connect to local MySQL server through socket &＃39;MySQL&＃39;
http://stackoverflow.com/questions/13769504/mysqlimysqli-hy000-2002-cant-connect-to-local-mysql-server-through-sock
http://segmentfault.com/q/1010000000328531
[15] 解决大文件上传相关配置
http://blog.csdn.net/z_p_h/article/details/8995160

[16]mysql用户密码过期策略

http://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html