Thanks a lot..But the table will be there already in the DB..Now the issue
is when i update the send_sms table,the entered field will be transferred to
sent_sms table but my sqlbox is getting terminated giving a log as below...
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at
localhost.
2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard,
client version 4.1.22.
2007-09-18 03:52:48 [23846] [0] DEBUG: Started thread 1 (
sqlbox.c:sql_to_bearerbox)
2007-09-18 03:52:48 [23846] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox)
maps to pid 23846.
2007-09-18 03:52:48 [23846] [1] INFO: Connected to bearerbox at localhost
port 13010.
2007-09-18 03:52:48 [23846] [1] DEBUG: Started thread 2 (
sqlbox.c:bearerbox_to_sql)
2007-09-18 03:52:48 [23846] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql)
maps to pid 23846.
2007-09-18 03:53:48 [23846] [2] INFO: Connection closed by the box <(null)>
2007-09-18 03:53:48 [23846] [2] DEBUG: bearerbox_to_sql: connection to
bearerbox died.
2007-09-18 03:53:48 [23846] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql)
terminates.
2007-09-18 03:53:48 [23846] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox)
terminates.
2007-09-18 03:53:58 [23846] [0] DEBUG: Immutable octet strings: 65.
On 18/09/2007, preeteesh kakkar <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Below is table format for send_sms table
>
> CREATE TABLE IF NOT EXISTS %S (sql_id bigint(20) not null auto_increment
> primary key, momt enum('MO', 'MT', 'DLR') null, sender varchar(20) null,
> receiver varchar(20) null, udhdata blob null, msgdata text null, time
> bigint(20) null, smsc_id varchar(255) null, service varchar(255) null,
> account varchar(255) null, id bigint(20) null, sms_type bigint(20) null,
> mclass bigint(20) null, mwi bigint(20) null, coding bigint(20) null,
> compress bigint(20) null, validity bigint(20) null, deferred bigint(20)
> null, dlr_mask bigint(20) null, dlr_url varchar(255) null, pid bigint(20)
> null, alt_dcs bigint(20) null, rpi bigint(20) null, charset varchar(255)
> null, boxc_id varchar(255) null, binfo varchar(255) null)
>
> On 9/18/07, Jins <[EMAIL PROTECTED]> wrote:
> >
> >
> > hello,
> >
> > i heard it is possible to sent sms by updating db and by using sqlbox...
> > i have installed standalone sqlbox with kannel.can someone please tell
> > me about the table design for the sqlbox to work
> >
> >
> >
> >
> > --
> > Jinson Abraham,
> > Torque Technology Solutions,
> > T-BIC, Park Center, Technopark,
> > Trivandrum.
> > www.torque.co.in
>
>
>
--
Jinson Abraham,
Torque Technology Solutions,
T-BIC, Park Center, Technopark,
Trivandrum.
www.torque.co.in
