mysql - 由于 SQL 语法错误，Gammu 无法启动服务

Question

我安装了Gammu，我用的是1.33版本

我从日志中复制了一些错误。

Tue 2015/04/14 11:00:28 gammu-smsd[7272]: SQL failure: 2

Tue 2015/04/14 11:00:28 gammu-smsd[7272]: Error inserting into database (SMSDSQL_InitAfterConnect)

Tue 2015/04/14 11:00:28 gammu-smsd[7272]: Post initialisation failed, stopping Gammu smsd: Unknown error. (UNKNOWN[27])

Tue 2015/04/14 11:00:28 gammu-smsd[7272]: Terminating communication...

Tue 2015/04/14 11:03:13 gammu-smsd[2816]: Using generic SQL for ODBC, this might fail. In such case please set SQL configuration option.

Tue 2015/04/14 11:03:13 gammu-smsd[2816]: Connected to Database odbc: aptikad on sms

Tue 2015/04/14 11:03:13 gammu-smsd[2816]: Created Windows RW shared memory at 0000000002D60000

Tue 2015/04/14 11:03:13 gammu-smsd[2816]: Starting phone communication...

Tue 2015/04/14 11:03:21 gammu-smsd[2816]: Inserting phone info

Tue 2015/04/14 11:03:21 gammu-smsd[2816]: SQLExecDirect failed, Code = -1, ODBC diagnostics:

Tue 2015/04/14 11:03:21 gammu-smsd[2816]: 42000:1:1064:[MySQL][ODBC 3.51 Driver][mysqld-5.6.20]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Signal) VALUES ("354232040876139", "", "yes", "yes", {fn CURRENT_TIMESTAMP()}, {

当我启动 gammu 的服务时，它启动了不到 1 秒，然后又停止了。

• 我使用 Gammu 1.33
• MySQL 连接器/ODBC 3.51.30 连接到我的 MySQL 数据库

Answer 1

它在日志中告诉你要做什么:

Using generic SQL for ODBC, this might fail. In such case please set SQL configuration option.

在 SMSD 配置中设置 SQL = mysql。参见 http://wammu.eu/docs/manual/smsd/config.html#option-SQL了解更多详情。