无法访问数据库

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用户读/写。你知道吗

正确设置使其工作。你知道吗