您好：
数据库里面的表是在哪个地方创建的？最开始只创建了个数据库，没找到创建表的代码呢，能讲解下么？

有时会报这个错误，有时又不会，但是对网站访问好像又没什么影响，想问一下是和gunicorn有关的什么吗？

[2018-05-10 22:56:02 +0000] [29972] [ERROR] Error handling request
Traceback (most recent call last):
  File "/home/sakakibara/project/Blog_mini/venv/local/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 174, in handle_request
    resp.write_file(respiter)
  File "/home/sakakibara/project/Blog_mini/venv/local/lib/python2.7/site-packages/gunicorn/http/wsgi.py", line 397, in write_file
    if not self.sendfile(respiter):
  File "/home/sakakibara/project/Blog_mini/venv/local/lib/python2.7/site-packages/gunicorn/http/wsgi.py", line 387, in sendfile
    sent += sendfile(sockno, fileno, offset + sent, count)
  File "/home/sakakibara/project/Blog_mini/venv/local/lib/python2.7/site-packages/gunicorn/http/_sendfile.py", line 67, in sendfile
    raise OSError(e, os.strerror(e))
OSError: [Errno 32] Broken pipe

后台的账号密码改了?

能否添加markdown写作支持

a = Article( ... ... articleType=aT, source=s)

但Article并没有articleType和source这两个字段。应该改成article_id=aT.id, source=s.id。

作者你好，感谢你的贡献，
目前已经成功部署，并做了一些定制化，
使用时有一个小问题，编辑博文时间太长，提交时会出现bad request，有没有什么思路可以解决这个问题，感谢。

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| blog_mini          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use blog_mini;
Database changed
mysql> show tables;
Empty set (0.00 sec)

起因是更改头像链接后能显示头像了，结果下午我再运行发现评论区的头像是我自己邮箱的，右上角管理员那里却是原来默认账户blog_mini的头像，并且进管理博客界面的大头像也是原来默认的没变；
看了半天觉得是加载头像那里的

hash = self.avatar_hash or hashlib.md5(
            self.email.encode('utf-8')).hexdigest()

使用了数据库默认的hash值，并且当我把前面的self.avatar_hash or 去掉后就显示正确了

博客挂久了有时候会自动终止，有时候不嫌麻烦也会手动重启，但是很多时候都不知道博客已经终止了。。想找个办法可以在崩溃的时候自动重启。。

初始化Blog_mini系统默认数据时候报错，
mysql是docker安装的，端口为13333，数据库可以远程连接，应该没问题，
我不知道是我的端口不对吗，还是什么问题，需要在哪个配置文件中修改这些，谢谢
我改用本地直接安装mysql可以，但是好像运行成功之后库里面没表啊，难道是我姿势不对？

除了这个问题之外，我还想就是在写文章的时候插入图片能直接粘贴吗，要不然有时候像云笔记中的文章想直接复制发表，图片很不方便

(venv) [root@123 Blog_mini]# python manage.py deploy product
Traceback (most recent call last):
File "manage.py", line 78, in
manager.run()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/flask_script/init.py", line 412, in run
result = self.handle(sys.argv[0], sys.argv[1:])
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/flask_script/init.py", line 383, in handle
res = handle(*args, **config)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/flask_script/commands.py", line 216, in call
return self.run(*args, **kwargs)
File "manage.py", line 43, in deploy
upgrade()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/flask_migrate/init.py", line 233, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/alembic/command.py", line 254, in upgrade
script.run_env()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/alembic/script/base.py", line 427, in run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/alembic/util/compat.py", line 141, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "migrations/env.py", line 87, in
run_migrations_online()
File "migrations/env.py", line 72, in run_migrations_online
connection = engine.connect()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
return self._connection_cls(self, **kwargs)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in init
if connection is not None else engine.raw_connection()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
self.pool.unique_connection, _connection)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
e, dialect, self)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1405, in _handle_dbapi_exception_noconnection
exc_info
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
return fn()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
rec = pool._do_get()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/pool.py", line 1151, in _do_get
return self._create_connection()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/pool.py", line 449, in init
self.connection = self.__connect()
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect
connection = self.__pool._invoke_creator(self)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/MySQLdb/init.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/local/python_blog/Blog_mini/venv/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in init
super(Connection, self).init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (2003, "Can't connect to MySQL server on '127.0.0.1' (111)")
(venv) [root@123 Blog_mini]#

场景:搭起来跑了一段时间,现在需要换个主机,数据不能丢啊?要转移哪写数据. 数据库用的sqlite

第一次接触flask，想改写一下你的代码，在route中添加正则匹配url，该怎么做？

按照逻辑，隐藏一篇文章的步骤如下：
1.新建一个文章分类，属性设置为隐藏
2.将需要隐藏的文章添加到该分类下
即可完成文章的隐藏，但是实际却无法实现这样的效果，将会在新版本中更正该问题。

浏览器也没法http请求

尊敬的作者你好，我在github上看了你的程序，很好的python作品，只是目前好像官网打不开了，我目前管理着公司数台服务器，带宽都是100M独享的，我想我可以为你提供IDC业务，免费的，如果有需要的话，请联系！可以更好的推广开源服务，！

因为我在安装项目依赖时发现报错，显示豆瓣源没有Flask==0.10.1,换成清华源就可以了
因此建议教程《在Ubuntu上部署开源博客系统Blog_mini》中 6.安装Blog_mini需求文件的命令
pip install -i http://pypi.douban.com/simple/ -r requirements/common.txt 中的豆瓣源换成清华源

作者你好，我用的你写的程序搭建的博客
我想请问下博文中插入图片的操作情况
好像是要贴上图片的链接地址，是要把图片上传到服务器然后写图片路径来实现图片插入嘛
还算有其它方法只是我还没解锁，不会用

作者你好，请问图片的位置该怎么存放，而且代码如何加进base.html呢？我现在想为网页标题栏插入一个ico图标，现在只能借助http链接添加进去，服务器的图片不知道该如何添加。

挺好的项目，推测作者最近忙于工作/学业无法维护。
最近简书嗝屁，我在找一个合适的博客系统部署到自己服务器。
你要是不嫌麻烦，我就顺手给你维护好了。

不然很容易有spam

不知道是域名到期还是被非法利用了，总之打开的网站不可描述~

all done. https://github.com/huangtao36/Blog_mini

jackness@ubuntu:/project/Blog_mini$ virtualenv venv
New python executable in /home/jackness/project/Blog_mini/venv/bin/python
Installing setuptools, pip, wheel...done.
jackness@ubuntu:/project/Blog_mini$ ls
app LICENSE migrations README.md requirements.txt
config.py manage.py Procfile requirements venv
jackness@ubuntu:/project/Blog_mini$ source venv/bin/activate
(venv) jackness@ubuntu:/project/Blog_mini$ pip install -i http://pypi.douban.com/simple/ -r requirements/common.txt
Looking in indexes: http://pypi.douban.com/simple/
Collecting Flask==0.10.1 (from -r requirements/common.txt (line 1))
The repository located at pypi.douban.com is not a trusted or secure host and is being ignored. If this repository is available via HTTPS we recommend you use HTTPS instead, otherwise you may silence this warning and allow it anyway with '--trusted-host pypi.douban.com'.
Could not find a version that satisfies the requirement Flask==0.10.1 (from -r requirements/common.txt (line 1)) (from versions: )
No matching distribution found for Flask==0.10.1 (from -r requirements/common.txt (line 1))
The repository located at pypi.douban.com is not a trusted or secure host and is being ignored. If this repository is available via HTTPS we recommend you use HTTPS instead, otherwise you may silence this warning and allow it anyway with '--trusted-host pypi.douban.com'.
错误发生在我安装Blog mini需求文件的时候，这个是什么原因呢？希望大神帮我看下，我是个才学了16天Python的小菜鸟，只是想学习下你的博客系统运用下。谢谢大神！！！

接下来的任务

• 文章搜索功能和多用户支持
• 支持Markdown方式发表博文
  搜索和多用户功能已经有网友提交PR，需要做的只是测试，Markdown的目前正着手准备着。

运行pip install -r requirements.txt时报错：

Double requirement given: gunicorn==19.4.5 (from -r requirements.txt (line 2)) (already in gunicorn==19.4.5 (from -r requirements/common.txt (line 17)), name='gunicorn')

查看了下是requirements.txt和requirements/common.txt都定义了gunicorn

In file included from psycopg/psycopgmodule.c:27:0:
./psycopg/psycopg.h:30:20: fatal error: Python.h: No such file or directory
compilation terminated.
error: command 'x86_64-linux-gnu-gcc' failed with exit status 1

----------------------------------------

Command "/usr/bin/python3.5 -u -c "import setuptools, tokenize;file='/tmp/pip-install-srh3n03y/psycopg2/setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" install --record /tmp/pip-record-p4a2app1/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /tmp/pip-install-srh3n03y/psycopg2/

网站无法正常打开啦....... 哭唧唧....... 求修复.......

Hi, I would like to report Cross Site Scripting vulnerability in latest release.

Description:
Cross-site scripting (XSS) vulnerability in app/main/views.py articleDetails() function and app/templates/_article_comments.html 70 line.
Steps To Reproduce:
1.select one article detials, like:http://122.152.231.228:8080/article-detials/4
2.find the article comment or create new comment.
3.Reply the comment, and the nikename is XSS payload.like: <script>alert(1)</script>,then submit.

4.Click the reply button, trigger the payload.use this vulnerability, I can stealing admin cookies and more.

author by [email protected]

New python executable in /var/www/html/Blog_mini/venv/bin/python
Installing setuptools, pip, wheel...
Complete output from command /var/www/html/Blog_mini/venv/bin/python - setuptools pip wheel:
Traceback (most recent call last):
File "", line 23, in
File "/usr/lib/python2.6/site-packages/virtualenv-15.0.1-py2.6.egg/virtualenv_support/pip-8.1.1-py2.py3-none-any.whl/pip/init.py", line 215, in main
File "/var/www/html/Blog_mini/venv/lib64/python2.6/locale.py", line 513, in setlocale
return _setlocale(category, locale)

locale.Error: unsupported locale setting

...Installing setuptools, pip, wheel...done.
Traceback (most recent call last):
File "/usr/bin/virtualenv", line 9, in
load_entry_point('virtualenv==15.0.1', 'console_scripts', 'virtualenv')()
File "/usr/lib/python2.6/site-packages/virtualenv-15.0.1-py2.6.egg/virtualenv.py", line 708, in main
symlink=options.symlink)
File "/usr/lib/python2.6/site-packages/virtualenv-15.0.1-py2.6.egg/virtualenv.py", line 941, in create_environment
download=download,
File "/usr/lib/python2.6/site-packages/virtualenv-15.0.1-py2.6.egg/virtualenv.py", line 897, in install_wheel
call_subprocess(cmd, show_stdout=False, extra_env=env, stdin=SCRIPT)
File "/usr/lib/python2.6/site-packages/virtualenv-15.0.1-py2.6.egg/virtualenv.py", line 792, in call_subprocess
% (cmd_desc, proc.returncode))
OSError: Command /var/www/html/Blog_mini/venv/bin/python - setuptools pip wheel failed with error code 1

PS: locale.Error: unsupported locale setting

管理员登录后，右上角的头像无法显示，也没见可以设置头像的地方

部署完给网站加ssl证书，在chrome上会提示‘’您与此网站建立的连接并非完全安全‘’
希望作者能解决一下这个问题
http://www.ip110.com/faq/technique/978.shtml

File "d:\program files\python36\lib\site-packages\flask\app.py", line 2309, in call
return self.wsgi_app(environ, start_response)
File "d:\program files\python36\lib\site-packages\flask\app.py", line 2295, in wsgi_app
response = self.handle_exception(e)
File "d:\program files\python36\lib\site-packages\flask\app.py", line 1741, in handle_exception
reraise(exc_type, exc_value, tb)
File "d:\program files\python36\lib\site-packages\flask_compat.py", line 35, in reraise
raise value
File "d:\program files\python36\lib\site-packages\flask\app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "d:\program files\python36\lib\site-packages\flask\app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "d:\program files\python36\lib\site-packages\flask\app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "d:\program files\python36\lib\site-packages\flask_compat.py", line 35, in reraise
raise value
File "d:\program files\python36\lib\site-packages\flask\app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "d:\program files\python36\lib\site-packages\flask\app.py", line 1799, in dispatch_request
return self.view_functionsrule.endpoint
File "D:\pycharmwork\Blog_mini\app\main\views.py", line 20, in index
pagination=pagination, endpoint='.index')
File "d:\program files\python36\lib\site-packages\flask\templating.py", line 135, in render_template
context, ctx.app)
File "d:\program files\python36\lib\site-packages\flask\templating.py", line 117, in _render
rv = template.render(context)
File "d:\program files\python36\lib\site-packages\jinja2\asyncsupport.py", line 76, in render
return original_render(self, *args, **kwargs)
File "d:\program files\python36\lib\site-packages\jinja2\environment.py", line 1008, in render
return self.environment.handle_exception(exc_info, True)
File "d:\program files\python36\lib\site-packages\jinja2\environment.py", line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File "d:\program files\python36\lib\site-packages\jinja2_compat.py", line 37, in reraise
raise value.with_traceback(tb)
File "D:\pycharmwork\Blog_mini\app\templates\index.html", line 2, in top-level template code
{% import "_macros.html" as macros %}
File "D:\pycharmwork\Blog_mini\app\templates\base.html", line 8, in top-level template code
{% block title %}
File "D:\pycharmwork\Blog_mini\app\templates\base.html", line 9, in block "title"
{{ BlogInfo.query.first().title }}
File "d:\program files\python36\lib\site-packages\jinja2\environment.py", line 430, in getattr
return getattr(obj, attribute)
jinja2.exceptions.UndefinedError: 'BlogInfo' is undefined

请问这是什么原因，，

现在没有人学习python2了，使用python3的环境来运行这个代码，一大堆的错误，对于新手来说，根本不通。 requirements/common.txt中的依赖直接安装不了， 我都是把版本依赖调整为>=
运行的时候又是一大堆问题。数据库连接不上。
python manage.py deploy product 初始化都过不去

我想学习一下python写后台的格式想在windows上安装

试用了一下Blog_mini，觉得应该增加一下功能：

1. 转载到其他博客
2. 支持markdown

1.A Cross-site scripting on Add plugin

Description

Cross-site scripting (XSS) vulnerability in /app/templates/base.html line 112 .
{{ plugin.content | safe }}
Use jinja2's safe tag to allow plugin content to be escaped and not filtered, resulting in Cross-site scripting (XSS) vulnerability

Steps To Reproduce:

After the administrator logged in.
Url :http://192.168.195.164:8080/admin/custom/blog-plugin/add
Data :csrf_token=1554792968%23%235f35bd58e994cc0ff9ee605d573442dc898ff6fc&title=plugin+xss&note=test&content=<svg/onload=alert(1)>

back to the homepage

2.A Cross-site scripting on Add Article

Description

Cross-site scripting (XSS) vulnerability in /app/templates/article_detials.html line 14 .
{{ article.content | safe }}
Use jinja2's safe tag to allow plugin content to be escaped and not filtered, resulting in Cross-site scripting (XSS) vulnerability

Steps To Reproduce:

After the administrator logged in.
URL http://192.168.195.164:8080/admin/submit-articles
Data: csrf_token=1554793565%23%239ed010b3b0416557e2930cd0cc53c334f9f3f8ca&source=1&title=Article+xss&content=<svg/onload=alert(3)>&types=1&summary=test

back to the homepage and Click on article ,this will trigger xss
http://192.168.195.164:8080/article-detials/2

演示网站后台查看不了吗，提示密码错误，就是想看看后台发布博客是不是支持markdown

  | <title>
  |  
  | Blog_mini -啦啦啦啦~~~
  |  
  | </title>

在电脑虽然不显示Blog_mini 出来，但是在手机上有。。请问该怎么解决呀？

Blog_mini从分享出来开始，作者一直在收集其出现的问题以及广大网友提出的功能建议，但是实在是因为学业上的问题还没有时间进行处理，这里感到非常抱歉！
目前刚开始实习，估计接下来半年也都是在实习，所以预计大四下学期会有非常充足的时间来做改进，Blog_mini有很多不成熟的地方，带来的不便，实在抱歉！也感谢大家对此项目的关注！

blog的博客正文的宽度设置在哪儿呀，css里和js里都没有看到，不知道在哪儿改，求告知

作者你好。
网页的底部栏颜色我觉得与背景不同，就删掉了base.html中的第139行的
div class="footer">
但随之，去底部的按钮失效了，去底部的JS代码在floatButton.js中
-- $('#goBottom').click(function(){
$('html, body').animate({scrollTop: $('.footer').offset().top}, 800); --
请问我该如何修改在删除底部栏的情况下还能使用去底部，或者有什么办法把底部栏的颜色和背景一样？

感谢分享，不过我的好像插件只有一项，是一个统计，该如何添加其他插件？