Hi List,
It's me again. I'm adding foreign_id field in the current sqlbox. And these are
what I have done.
sqlbox_mysql.c
Msg *mysql_fetch_msg()
{
…
msg->sms.foreign_id = octstr_null_create(row[27]);
…
}
void mysql_save_msg(Msg *msg, Octstr *momt /*, Octstr smsbox_id */)
{
…
sql = octstr_format(SQLBOX_MYSQL_INSERT_QUERY….st_str(msg->sms.foreign_id));
…
}
sqlbox_mysql.h
#define SQLBOX_MYSQL_CREATE_LOG_TABLE "CREATE TABLE IF NOT EXISTS %S ( \
sql_id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, \
...foreign_id VARCHAR(255) NULL)"
#define SQLBOX_MYSQL_CREATE_INSERT_TABLE "CREATE TABLE IF NOT EXISTS %S ( \
....foreign_id VARCHAR(255) NULL)"
#define SQLBOX_MYSQL_SELECT_QUERY "SELECT sql_id, momt, sender, receiver,
udhdata, \
...foreign_id FROM %S LIMIT 0,1"
#define SQLBOX_MYSQL_INSERT_QUERY "INSERT INTO %S ( sql_id, momt, sender, \
...%S)"
The compilation smooth and the daemon launched well. But when I tried to
inject row then SQLBox dies on panic
2012-09-06 18:27:29 [27785] [4] PANIC: Internal error: unknown message type:
10507536
2012-09-06 18:27:29 [27785] [4] PANIC:
/home/sprabv/kanopi/test/sbin/sqlbox(gw_backtrace+0xae) [0x42656e]
2012-09-06 18:27:29 [27785] [4] PANIC:
/home/sprabv/kanopi/test/sbin/sqlbox(gw_panic+0x155) [0x4266d5]
2012-09-06 18:27:29 [27785] [4] PANIC:
/home/sprabv/kanopi/test/sbin/sqlbox(msg_pack+0x4c) [0x40d28c]
2012-09-06 18:27:29 [27785] [4] PANIC: /home/sprabv/kanopi/test/sbin/sqlbox()
[0x40a666]
2012-09-06 18:27:29 [27785] [4] PANIC: /home/sprabv/kanopi/test/sbin/sqlbox()
[0x40a789]
2012-09-06 18:27:29 [27785] [4] PANIC: /home/sprabv/kanopi/test/sbin/sqlbox()
[0x41dfae]
2012-09-06 18:27:29 [27785] [4] PANIC: /lib/libpthread.so.0(+0x69ca)
[0x7f77896469ca]
2012-09-06 18:27:29 [27785] [4] PANIC: /lib/libc.so.6(clone+0x6d)
[0x7f778918ccdd]
It is said "unknown message type" AFAIK foreign_id is already in msg-decl.h
Would you give some clue? Many thanks for your assistance.
Willy Mularto
F300HD+MR18DE (NLC1725)
