python - Flask 和 Apache 的 API 错误 500

Question

我正在尝试让我的 API 使用 Apache 在我的 Ubuntu VPS 上工作，这是我的 FLASK 代码；

#!/usr/bin/env python
import os
from sqlalchemy import update
from flask import Flask, abort, request, jsonify, g, url_for
from flask.ext.sqlalchemy import SQLAlchemy
from flask.ext.httpauth import HTTPBasicAuth
from passlib.apps import custom_app_context as pwd_context
from itsdangerous import (TimedJSONWebSignatureSerializer
                          as Serializer, BadSignature, SignatureExpired)
from datetime import datetime
import math


# initialization
app = Flask(__name__)
app.config['SECRET_KEY'] = 'the quick brown fox jumps over the lazy dog'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db.sqlite'
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True

# extensions
db = SQLAlchemy(app)
auth = HTTPBasicAuth()


class User(db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(32))
    username = db.Column(db.String(32), index=True)
    password_hash = db.Column(db.String(64))

    def hash_password(self, password):
        self.password_hash = pwd_context.encrypt(password)

    def verify_password(self, password):
        return pwd_context.verify(password, self.password_hash)

    def generate_auth_token(self, expiration=600):
        s = Serializer(app.config['SECRET_KEY'], expires_in=expiration)
        return s.dumps({'id': self.id})

    @staticmethod
    def verify_auth_token(token):
        s = Serializer(app.config['SECRET_KEY'])
        try:
            data = s.loads(token)
        except SignatureExpired:
            return None    # valid token, but expired
        except BadSignature:
            return None    # invalid token
        user = User.query.get(data['id'])
        return user


class Points(db.Model):
    __tablename__ = 'points'
    id = db.Column(db.Integer, primary_key=True)
    date = db.Column(db.String(32))
    username = db.Column(db.String(32))
    shop = db.Column(db.String(64))
    point = db.Column(db.Integer)


class MyPoints(db.Model):
    __tablename__ = 'mypoints'
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(32))
    shop = db.Column(db.String(64))
    point = db.Column(db.Integer)

class Shops(db.Model):
    __tablename__ = 'shop'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(32))
    location = db.Column(db.String(32))
    website = db.Column(db.String(32))
    number = db.Column(db.String(32))
    message = db.Column(db.String(32))

@auth.verify_password
def verify_password(username_or_token, password):
    # first try to authenticate by token
    user = User.verify_auth_token(username_or_token)
    if not user:
        # try to authenticate with username/password
        user = User.query.filter_by(username=username_or_token).first()
        if not user or not user.verify_password(password):
            return False
    g.user = user
    return True


@app.route('/api/users/reg', methods=['POST'])
def new_user():
    name = request.json.get('name')
    username = request.json.get('username')
    password = request.json.get('password')
    if username is None or password is None or name is None:
        return (jsonify({'status': "Missing fields"}))
        abort(400)    # missing arguments
    if User.query.filter_by(username=username).first() is not None:
        return (jsonify({'status': "Email already Exists"}))
        abort(400)    # existing user
    user = User(username=username, name=name)
    user.hash_password(password)
    db.session.add(user)
    db.session.commit()
    return (jsonify({'status': "Account Created"}), 201)

@app.route('/api/users/up', methods=['POST'])
def update_password():
    username = request.json.get("username")
    password = request.json.get('password')
    if password is None or username is None:
        return (jsonify({'status': "Missing fields"}))
        abort(400)    # missing arguments
    user = pwd_context.encrypt(password)
    result = db.engine.execute('UPDATE users SET password_hash = "%s" WHERE username = "%s"' % (user, username))

    return (jsonify({'status': "Password Updated"}), 201)

@app.route('/api/users/log', methods=['GET'])
@auth.login_required
def login_user():
    token = g.user.generate_auth_token(600)
    return jsonify({'status': 'Logged in'})

@app.route('/api/users/del', methods=['POST'])
@auth.login_required
def delete_account():
    username = g.user.username
    if username is None:
        return (jsonify({'status': "Missing fields"}))
        abort(400)    # missing arguments

    db.engine.execute("DELETE FROM users WHERE username = '%s'" % username)

    return (jsonify({'status': "Account Deleted"}), 201)




@app.route('/api/points/list', methods=['GET'])
@auth.login_required
def all_points():
    user = g.user.username
    result = MyPoints.query.filter_by(username=user).limit(10).offset(0)

    json_results = []
    for result in result:
      d = {'id': result.id,
           'shop': result.shop,
           'point': result.point,
           'username': result.username}
      json_results.append(d)

    return jsonify(items=json_results)

@app.route('/api/points/<path:shop>', methods=['GET'])
@auth.login_required
def list_points(shop):
    user = g.user.username
    result = MyPoints.query.filter_by(shop=shop).limit(10).offset(0)

    json_results = []
    for result in result:
      d = {'id': result.id,
           'shop': result.shop,
           'point': result.point,
           'username': result.username}
      json_results.append(d)

    return jsonify(items=json_results, )



@app.route('/api/points', methods=['POST'])
@auth.login_required
def update_points():
    date = str(datetime.now())
    username = request.json.get('username')
    shop = request.json.get('shop')
    point = request.json.get('point')
    user = Points(date=date, username=username, shop=shop, point=point)
    db.session.add(user)
    db.session.commit()
    result = db.engine.execute('select point from points WHERE shop == "%s" AND username="%s"' % (shop, username))
    names = []
    for row in result:
        names.append(row[0])
    names = [x.encode('utf-8') for x in names]
    results = map(int, names)
    r = sum(results)
    result = db.engine.execute('UPDATE mypoints SET point = "%s" WHERE username = "%s"' % (r, username))
    return (jsonify({'Points': r}), 201)



if __name__ == '__main__':
    if not os.path.exists('db.sqlite'):
        db.create_all()
    app.run(debug=True)

每次我尝试运行 Curl 命令时；

curl -i -X POST -H "Content-Type: application/json" -d '{"username":"miguel","password":"python"}' http://adventorious.com/api/users

它抛出；

HTTP/1.1 500 Internal Server Error
Date: Sun, 15 Feb 2015 16:01:37 GMT
Server: Apache/2.4.7 (Ubuntu)
Content-Length: 623
Connection: close
Content-Type: text/html; charset=iso-8859-1

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>500 Internal Server Error</title>
</head><body>
<h1>Internal Server Error</h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator at 
 administrator@91.103.6.23 to inform them of the time this error occurred,
 and the actions you performed just before this error.</p>
<p>More information about this error may be available
in the server error log.</p>
<hr>
<address>Apache/2.4.7 (Ubuntu) Server at adventorious.com Port 80</address>
</body></html>

我不明白为什么会发生这种情况，因为它在我的本地计算机上完美运行，但如果我尝试从 VPS 运行它，它只会抛出错误 500。

我在网上搜索过，但似乎找不到解决方案。

非常感谢所有帮助。

添加;

这是错误；

[Sun Feb 15 16:17:53.470691 2015] [:error] [pid 1469] [client 178.167.254.175:4226] mod_wsgi (pid=1469): Target WSGI script '/var/www/FlaskApi/api.wsgi' cannot be loaded as Python module.
[Sun Feb 15 16:17:53.470790 2015] [:error] [pid 1469] [client 178.167.254.175:4226] mod_wsgi (pid=1469): Exception occurred processing WSGI script '/var/www/FlaskApi/api.wsgi'.
[Sun Feb 15 16:17:53.470817 2015] [:error] [pid 1469] [client 178.167.254.175:4226] Traceback (most recent call last):
[Sun Feb 15 16:17:53.470849 2015] [:error] [pid 1469] [client 178.167.254.175:4226]   File "/var/www/FlaskApi/api.wsgi", line 6, in <module>
[Sun Feb 15 16:17:53.470932 2015] [:error] [pid 1469] [client 178.167.254.175:4226]     from FlaskApi import app as application
[Sun Feb 15 16:17:53.470957 2015] [:error] [pid 1469] [client 178.167.254.175:4226] ImportError: No module named FlaskApi

我说;从 FlaskApi 导入应用程序

但是wsgi和init文件在同一个地方，是这个问题吗>>？

Answer 1

看起来您确实在尝试从 FlaskApi 导入应用程序，但您已经在其中了。

您可以尝试将脚本的第 6 行更改为:

from . import app as application

或者

import app as application

为了更快地测试(并避免一直重启服务器)，您也可以尝试运行:

python /var/www/FlaskApi/api.wsgi