python - 无法访问数据库

Question

我正在尝试打开 FDB 文件，但似乎不起作用。无论我尝试什么，我都会收到此错误:

Opening ./20190401_database.fdb
Traceback (most recent call last):
  File "test.py", line 16, in <module>
    conn = fdb.connect(dsn=local_copy, user='****', password='****', charset='iso8859_1')
  File "/usr/local/lib/python3.6/site-packages/fdb/fbcore.py", line 848, in connect
    "Error while connecting to database:")
fdb.fbcore.DatabaseError: ('Error while connecting to database:\n- SQLCODE: -551\n- no permission for read-write access to database /var/www/wsgi/data/20190401_database.fdb', -551, 335544352)

我以用户 apache 身份运行此代码，并且同一用户刚刚将 FDB 文件复制到该位置，因此我非常确定该用户具有读/写访问权限。

import fdb
from datetime import date, timedelta

DB_PATH="."

yesterday = date.today() - timedelta(days = 1)
yesterday = yesterday.strftime("%Y%m%d")
filename = f'{yesterday}_database.fdb'
local_fullpath = f'{DB_PATH}/{filename}'

local_copy = local_fullpath

print("Opening "+local_copy)
conn = fdb.connect(dsn=local_copy, user='****', password='****', charset='iso8859_1')

conn.close()

即使以 root 身份运行脚本，我也会收到相同的错误。

Answer 1

问题在于 FDB 文件必须由 firebird 用户读取/写入。

正确设置使其正常工作。