我正在尝试使用Python将日志文件中的值插入MariaDB
我的密码是
db = mysql.connector.connect(
host="localhost",
user="x",
passwd="y",
database="z"
)
cursor=db.cursor()
file=open('../uploads/%s' % baseFileName + '.log','rt')
line=file.readline()
for line in file:
status1=line.find('UFW')+5
status2=line.find(' ',status1)-1
status=line[status1:status2]
sql_query="INSERT INTO table01 (status) VALUES (%s)"
values=(status)
cursor.execute(sql_query,values)
db.commit()
cursor.close()
file.close()
通过注释掉部分,问题似乎是从sql\u查询行开始的,所以我的语法有点错误
运行此命令时收到的错误消息是:
Traceback (most recent call last):
File "./process.py", line 43, in <module>
cursor.execute(sql_query,values)
File "/usr/local/lib/python2.7/dist-packages/mysql/connector/cursor_cext.py", line 248, in execute
prepared = self._cnx.prepare_for_mysql(params)
File "/usr/local/lib/python2.7/dist-packages/mysql/connector/connection_cext.py", line 538, in prepare_for_mysql
raise ValueError("Could not process parameters")
ValueError: Could not process parameters
我在debian9(Stretch)机器上运行这个。安装的python版本是python2.7.13和python3.5.3,尽管在脚本中我以#开头/usr/bin/python
目前没有回答
相关问题 更多 >
编程相关推荐