收藏一些docker镜像和使用方法 2019-02-22 16:06:10 version: '2'services: proxy: image: 'jwilder/nginx-proxy' volumes: - /var/run/docker.sock:/tmp/docker.sock ports: - '80:80' mysql: image: mysql:5.7 environment: - MYSQL_ROOT_PASSWORD=root volumes: - "./data/mysql:/var/lib/mysql" ports: - '3306:3306' redis: image: redis def: image: zhaishuaigan/php volumes: - "./:/app" links: - mysql - redis environment: - VIRTUAL_HOST=shuai.cndocker run -p 80:80 -p 443:443 -itd --restart always -v /var/run/docker.sock:/tmp/docker.sock:ro --name proxy neilpang/nginx-proxydocker run -d --name api --restart=always -v /www/api:/app -e VIRTUAL_HOST=api.ngapp.net -e ENABLE_ACME=true zhaishuaigan/php:tp5docker run -d --name api --restart=always -v /root/www/api:/app -e VIRTUAL_HOST=api.admin-ui.cn -e ENABLE_ACME=true zhaishuaigan/php
vagrant+docker一键搭建php+mysql开发环境 2018-04-17 19:05:21 必备软件 VagrantVirtual Box 启动脚本 Vagrantfile Vagrant.configure("2") do |config| config.vm.box = "ubuntu/xenial64" config.vm.network "forwarded_port", guest: 80, host: 80 config.vm.network "forwarded_port", guest: 3306, host: 3306 config.vm.network "private_network", ip: "10.0.0.2" config.vm.provision "shell", inline: <<-SHELL # 更换aliyun软件源 cp /etc/apt/sources.list /etc/apt/sources.list.bak echo 'deb http://mirrors.aliyun.com/ubuntu/ xenial main restricted universe multiverse' > /etc/apt/sources.list echo 'deb http://mirrors.aliyun.com/ubuntu/ xenial-security main restricted universe multiverse' >> /etc/apt/sources.list echo 'deb http://mirrors.aliyun.com/ubuntu/ xenial-updates main restricted universe multiverse' >> /etc/apt/sources.list echo 'deb http://mirrors.aliyun.com/ubuntu/ xenial-proposed main restricted universe multiverse' >> /etc/apt/sources.list echo 'deb http://mirrors.aliyun.com/ubuntu/ xenial-backports main restricted universe multiverse' >> /etc/apt/sources.list apt-get update # 安装docker apt-get -y install apt-transport-https ca-certificates curl software-properties-common curl -fsSL http://mirrors.aliyun.com/docker-ce/linux/ubuntu/gpg | sudo apt-key add - add-apt-repository "deb [arch=amd64] http://mirrors.aliyun.com/docker-ce/linux/ubuntu $(lsb_release -cs) stable" apt-get -y update apt-get -y install docker-ce docker-compose # 使用aliyun加速docker镜像 mkdir -p /etc/docker echo '{' > /etc/docker/daemon.json echo ' "registry-mirrors": ["https://kag9wqej.mirror.aliyuncs.com"]' >> /etc/docker/daemon.json echo '}' >> /etc/docker/daemon.json systemctl daemon-reload systemctl restart docker usermod -G docker vagrant cd /vagrant docker-compose up -d # 开机自启动 echo '#!/bin/bash' > /etc/rc.local echo 'sleep 10' >> /etc/rc.local echo 'cd /vagrant' >> /etc/rc.local echo 'docker-compose up -d' >> /etc/rc.local echo 'exit 0' >> /etc/rc.local sudo rm /bin/sh sudo ln -s /bin/bash /bin/sh SHELLend docker-compose.yml version: '2'services: mysql: image: mysql environment: - MYSQL_ROOT_PASSWORD=root volumes: - "./mysql:/var/lib/mysql" ports: - '3306:3306' networks: - bridge www: build: . volumes: - "./wwwroot/www:/app" - "./wwwroot/static/Uploads:/app/Uploads" environment: - VIRTUAL_HOST="你要绑定的域名" - PHP_DB_HOST=mysql - PHP_DB_NAME=你的数据库名称 - PHP_DB_USER=root - PHP_DB_PASSWORD=root networks: - bridge lb: image: 'dockercloud/haproxy' volumes: - /var/run/docker.sock:/var/run/docker.sock links: - www ports: - '80:80' networks: - bridgenetworks: bridge: Dockerfile FROM php:5.6-apache# 安装扩展COPY ./soft/*.tgz /soft/WORKDIR /softRUN pecl install redis-3.1.6.tgz \ && pecl install xdebug-2.5.5.tgz \ && docker-php-ext-enable redis xdebug \ && docker-php-ext-install pdo_mysql \ && docker-php-ext-install mysqli \ && rm -rf /soft# URL重写RUN a2enmod rewrite# 安装composerADD ./soft/composer.phar /usr/local/bin/composerRUN chmod 755 /usr/local/bin/composer \ && composer config -g repo.packagist composer https://packagist.phpcomposer.com# 安装代码COPY ./wwwroot /app/# 修改网站主目录ENV APACHE_DOCUMENT_ROOT /appRUN sed -ri -e 's!/var/www/html!${APACHE_DOCUMENT_ROOT}!g' /etc/apache2/sites-available/*.confRUN sed -ri -e 's!/var/www/!${APACHE_DOCUMENT_ROOT}!g' /etc/apache2/apache2.conf /etc/apache2/conf-available/*.conf# 可写权限RUN chmod -R 777 /app/# 默认工作目录WORKDIR /app# 暴露工作端口EXPOSE 80 443 22
mysql新建远程用户后不能远程连接的问题 2016-08-23 16:36:14 编辑 /etc/mysql/my.cnf 注释掉 bind-address = 127.0.0.1然后重启mysql, 就可以了
mysql的workbench导出数据报错问题 2015-12-23 23:49:32 MysqlWorkbench6.0之后的版本使用export data时会遇到这个错误 问题Running: /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --defaults-file...mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'...原因 我们看错误报告显示这个变量 ‘delayed-insert=FALSE’ 不被识别,workbench默认配置里会开启这个变量并且默认值是false。如果我们用不到这个变量可以更改配置文件,注释掉这个变量来解决 解决步骤 找到配置文件目录:InstallPath/modules打开python格式的输出配置文件:wb_admin_export_options.py找到所在行:”delayed-insert”:[“Write INSERT DELAYED statements rather than …在行开头插入#号注释改行保存文件,重启Workbench 配置文件所在位置windowsC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules MacApplications -> MYSQLWorkbench.app/Contents/Resources/plugins.Note: 在应用上右击选择 Show Package contents 进入应用目录 Ubuntu/usr/lib/mysql-workbench/modules/wb_admin_export_options.py