I've configure bearerbox and sqlbox, But I could't see anything happening and the messages are getting moved to log table of sqlbox. Can not see anything in bearerbox logs too
Am able to sent messages through HTTP send sms interface when i start an smsbox. But can not do this with a DB insertion for sqlbox *Core conf* group = core admin-port = 15000 admin-password = bar #admin-deny-ip = "*.*.*.*" #admin-allow-ip = "" #wapbox-port = 15002 smsbox-port = 15003 wdp-interface-name = "*" log-file = "/var/log/kannel/bearerbox.log" #box-deny-ip = "*.*.*.*" #box-allow-ip = "127.0.0.1" group = smsbox smsbox-id = mybox sendsms-port = 15005 bearerbox-host = localhost group = sendsms-user username = xxx password = xxx *SQLBOX Conf* group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" bearerbox-host = localhost bearerbox-port = 15000 sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 group = mysql-connection id = sqlbox-db host = localhost username = root password = database = kannel *SQLBOX Log* 2010-09-09 12:16:45 [4079] [0] INFO: MYSQL: Connected to server at localhost. 2010-09-09 12:16:45 [4079] [0] INFO: MYSQL: server version 5.1.37-1ubuntu5.4, client version 5.1.37. 2010-09-09 12:16:45 [4079] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2010-09-09 12:16:45 [4079] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 4079. 2010-09-09 12:16:45 [4079] [1] DEBUG: Connecting to <127.0.0.1> 2010-09-09 12:16:45 [4079] [1] INFO: Connected to bearerbox at localhost port 15000. 2010-09-09 12:16:45 [4079] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2010-09-09 12:16:45 [4079] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 4079. -------- *Thanks & Regards*** *Jinson * * * On Wed, Sep 8, 2010 at 6:17 PM, Jinson <[email protected]> wrote: > Hello preeteesh, > > Installation success. installed bison. Meanwhile I'm trying your version of > sqlbox...will keep you posted. > -------- > *JInson* > > > > On Wed, Sep 8, 2010 at 6:09 PM, preeteesh kakkar < > [email protected]> wrote: > >> Probably yacc will be installed with below command (use sudo as per ur >> needs) >> >> apt-get install bison >> >> >> On Wed, Sep 8, 2010 at 2:22 PM, Jinson <[email protected]> wrote: >> >>> * >>> Can somebody help me....Tried to compile the svn version of Gateway from >>> https://svn.kannel.org/gateway/trunk >>> >>> Makefile:336: .depend: No such file or directory >>> yacc -d -p ws_yy_ wmlscript/wsgram.y && mv y.tab.c wmlscript/wsgram.c >>> /bin/bash: yacc: command not found >>> make: *** [wmlscript/wsgram.c] Error 127 >>> >>> * >>> >>> >>> >>> On Wed, Sep 8, 2010 at 5:44 PM, Jinson <[email protected]> wrote: >>> >>>> I got it >>>> >>>> svn co https://svn.kannel.org/gateway/trunk >>>> >>>> Let me try with this... :) >>>> -------- >>>> * >>>> * >>>> >>>> On Wed, Sep 8, 2010 at 5:43 PM, Jinson <[email protected]> wrote: >>>> >>>>> Can you share the svn url for Kannel >>>>> >>>>> svn co https://svn.kannel.org/<project>/trunk >>>>> >>>>> I can see smppbox and sqlbox >>>>> -------- >>>>> *Thanks & Regards >>>>> ** >>>>> >>>>> Jinson >>>>> * >>>>> >>>>> >>>>> On Wed, Sep 8, 2010 at 5:39 PM, Alejandro Guerrieri < >>>>> [email protected]> wrote: >>>>> >>>>>> Latest SqlBox requires the SVN version of Kannel (to support >>>>>> meta-data). >>>>>> >>>>>> Regards, >>>>>> >>>>>> Alex >>>>>> >>>>>> >>>>>> On Wed, Sep 8, 2010 at 2:05 PM, Jinson <[email protected]> wrote: >>>>>> >>>>>>> Hello, >>>>>>> >>>>>>> I was trying to install SQLBox with Kannel 1.4.3 >>>>>>> >>>>>>> Getting the following error when I run *make* >>>>>>> * >>>>>>> * >>>>>>> * >>>>>>> * >>>>>>> * >>>>>>> sqlbox_mysql.c: In function ‘mysql_fetch_msg’: >>>>>>> sqlbox_mysql.c:143: error: ‘struct sms’ has no member named >>>>>>> ‘meta_data’ >>>>>>> sqlbox_mysql.c: In function ‘mysql_save_msg’: >>>>>>> sqlbox_mysql.c:207: error: ‘struct sms’ has no member named >>>>>>> ‘meta_data’ >>>>>>> make[2]: *** [sqlbox_mysql.o] Error 1 >>>>>>> make[2]: Leaving directory `/home/jins/Kannel/sqlbox/gw' >>>>>>> make[1]: *** [all-recursive] Error 1 >>>>>>> make[1]: Leaving directory `/home/jins/Kannel/sqlbox' >>>>>>> make: *** [all] Error 2 >>>>>>> >>>>>>> >>>>>>> Can Somebody help... >>>>>>> * >>>>>>> >>>>>>> -------- >>>>>>> *Thanks & Regards >>>>>>> ** >>>>>>> >>>>>>> JInson >>>>>>> * >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
