boboglo部署II: 服务器

配置服务器环境

1安装python

登录服务器

ssh root@47.116.78.4

查看python版本

python3 --version

1. 更新apt

 sudo apt-get update

2. 安装software-properties-common

sudo apt-get install software-properties-commont

3. 添加 Deadsnakes PPA

sudo add-apt-repository ppa:deadsnakes/ppa

sudo apt-get update

4. 安装python3.8

sudo apt-get install python3.8

5. 安装pip3(如果没有)

sudo apt-get install python3-pip

6. 安装venv

pip3 install virtualenv

7. 创建虚拟环境

mkdir Environments

virtualenv Environments/boboblog

source Environments/boboblog/bin/activate

2 安装git

sudo apt-get install git

在合适的路径中clone git repository

git clone https://github.com/yanbozz/boboblog.git

将本地pip list复制requirements.txt

python -m pip freeze > requirements.txt

上传至服务器

scp requirements.txt root@47.116.78.4:/root/boboblog

服务器安装requirements.txt

python3 -m pip install -r requirements.txt

3 在服务器安装mysql

安装

wget https://dev.mysql.com/get/mysql-apt-config_0.8.16-1_all.deb

dpkg -i mysql-apt-config_0.8.16-1_all.deb 

apt-get install mysql-server

创建数据库和用户

mysql -u root -p
mysql> create DATABASE mydatabase;
create user 'username'@'localhost' IDENTIFIED BY 'password';

授权用户

mysql> grant all privileges on mydatabase.* to 'username'@'localhost';
mysql> flush privileges;

4 从本地倒入数据到服务器

本地terminal: 将数据库导入data.sql

 mysqldump --no-tablespaces -u zyb -p -u zyb -p mydatabase > data.sql

本地复制到scp到服务器

scp data.sql root@47.116.78.4:/root/boboblog/data.sql

服务器mysql:

use database
source data.sql

5 安装mysqlclient

运行

apt-get install libmysqlclient-dev

出现错误

Reading package lists... Done
Building dependency tree       
Reading state information... Done
libmysqlclient-dev is already the newest version (8.0.23-1ubuntu20.04).
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet dependencies:
 libmysqlclient-dev : Depends: libmysqlclient21 (= 8.0.23-1ubuntu20.04) but 8.0.22-0ubuntu0.20.04.3 is to be installed
E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).
(boboblog) root@iZuf64r7a771sbhalu4icqZ:~/mysql# apt --fix-broken install

运行

apt --fix-broken install

更新apt-get

apt-get update

pip安装 mysqlclient

pip install mysqlclient

最后, 在服务器上加入端口就可以线上运行了