Cron (cronie)抛出语法错误，但可以手动工作

Question

这是我第一次尝试使用cron，我希望它从数据库中提取数据，如果满足条件，则返回一些内容。我正在使用flask和sqlalchemy。

我一直在网上搜索，发现了类似的错误，但没有一些对我有效的东西。

import sqlite3
import datetime

connection = sqlite3.connect('sms_agenda/users.db')
cursor = connection.cursor()
cursor.execute("SELECT phone, timezone FROM user;")
result = cursor.fetchall()
now = datetime.datetime.utcnow()
now_str = str(now)[11:13]
for phone, timezone in result:
    if int(now_str) + int(timezone) == 20:
        print(phone)

cursor.close()
connection.close()

输入systemctl status cronie返回：

okt 23 10:58:01 qq88-pc CROND[30858]: (root) CMDOUT (import: unable to open X server `' @ error/import.c/ImportImageCommand/343.)
okt 23 10:58:01 qq88-pc CROND[30857]: (qq88) CMDOUT (import: unable to open X server `' @ error/import.c/ImportImageCommand/343.)
okt 23 10:58:01 qq88-pc CROND[30858]: (root) CMDOUT (import: unable to open X server `' @ error/import.c/ImportImageCommand/343.)
okt 23 10:58:01 qq88-pc CROND[30858]: (root) CMDOUT (/home/qq88/python-virtual-environments/sms/check_send.py: line 6: syntax error near unexpected token `(')
okt 23 10:58:01 qq88-pc CROND[30858]: (root) CMDOUT (/home/qq88/python-virtual-environments/sms/check_send.py: line 6: `connection = sqlite3.connect('sms_agenda/users.db')')
okt 23 10:58:01 qq88-pc CROND[30858]: pam_unix(crond:session): session closed for user root
okt 23 10:58:01 qq88-pc CROND[30857]: (qq88) CMDOUT (import: unable to open X server `' @ error/import.c/ImportImageCommand/343.)
okt 23 10:58:01 qq88-pc CROND[30857]: (qq88) CMDOUT (/home/qq88/python-virtual-environments/sms/check_send.py: line 6: syntax error near unexpected token `(')
okt 23 10:58:01 qq88-pc CROND[30857]: (qq88) CMDOUT (/home/qq88/python-virtual-environments/sms/check_send.py: line 6: `connection = sqlite3.connect('sms_agenda/users.db')')
okt 23 10:58:01 qq88-pc CROND[30857]: pam_unix(crond:session): session closed for user qq88

这就是我在cron中输入的内容：

* * * * * /home/qq88/python-virtual-environments/sms/check_send.py

仅供参考，这是通过Twilio发送短信，但为了测试，我只想它打印手机。

Answer 1

试着像这样做。

* * * * * /usr/bin/python3 /home/qq88/python-virtual-environments/sms/check_send.py