Re: SQLBox not compatible with smppbox version cvs 20081222

Hi,

smppbox is commercial addon and we don't have source to fix it.
Please contact Stipe and he will fix it for you.

Thanks,
Alex

Farida N. Bedwei schrieb:
> Please find configuration below:
> 
>  
> 
> module.d/smppbox.conf
> 
> #
> 
> # The smppbox configuration.
> 
> # Mainly similar to bearerbox core group.
> 
> #
> 
> # default-smsc defines which smsc-id should be used for all
> 
> # MT messages that have no ESME routing applied. You may define
> 
> # this to a generic route.
> 
> #
> 
> group = smppbox
> 
> admin-port = 13005
> 
> admin-password = xxx
> 
> #status-password = xxx
> 
> #admin-allow-ip =
> 
> #admin-deny-ip =
> 
> bearerbox-host = localhost
> 
> bearerbox-dcs = utf-8
> 
> smppbox-port = 2305
> 
> system-id = "KSMSC"
> 
> log-file = "/var/log/kannel/smppbox.log"
> 
> log-level = 3
> 
> access-log = "/var/log/kannel/smpp_access.log"
> 
> store-file = "/var/log/kannel/kannel_smppbox.store"
> 
>  
> 
>  
> 
> *_sqlbox_smpp.conf_*
> 
>  
> 
> #MYSQL CONNECTION GROUP
> 
>  
> 
> group = mysql-connection
> 
> id = sqlbox-db
> 
> port = 3306
> 
> host = localhost
> 
> username = xxxx
> 
> password = xxxx
> 
> database = kannel
> 
> max-connections = 1
> 
>  
> 
>  
> 
> group = sqlbox
> 
> id = sqlbox-db
> 
> smsbox-id = SQLSMSC
> 
> bearerbox-host = localhost
> 
> bearerbox-port = 13001
> 
> smsbox-port = 13003
> 
> smsbox-port-ssl = false
> 
> sql-log-table = sent_sms
> 
> sql-insert-table = send_sms
> 
> log-file = "/var/log/kannel/sqlboxsmpp.log"
> 
> log-level = 0
> 
>  
> 
>  
> 
>  
> 
> *_core.conf_*
> 
>  
> 
> #CORE GROUP SETUP
> 
>  
> 
> group = core
> 
> admin-port = 13000
> 
> smsbox-port = 13001
> 
> wapbox-port = 13002
> 
> admin-password = xx
> 
> wdp-interface-name = "*"
> 
> #status-password = xx
> 
> #admin-deny-ip = ""
> 
> admin-allow-ip = "*.*.*.*"
> 
> log-file = "/var/log/kannel/bbox.log"
> 
> log-level = 3
> 
> #log-level = 0
> 
> #box-deny-ip = "*.*.*.*"
> 
> #box-allow-ip = 127.0.0.1
> 
> box-allow-ip = "127.0.0.1"
> 
> access-log = "/var/log/kannel/bearerbox_access.log"
> 
> store-file = "/var/log/kannel/rms.store"
> 
> include = "/home/rms/config/dlr-mysql.conf"
> 
>  
> 
> *_sqlbox.conf_*
> 
>  
> 
> #MYSQL CONNECTION GROUP
> 
>  
> 
> group = mysql-connection
> 
> id = sqlbox-db
> 
> port = 3306
> 
> host = localhost
> 
> username = xxxx
> 
> password = xxxx
> 
> database = kannel
> 
> max-connections = 1
> 
>  
> 
>  
> 
> group = sqlbox
> 
> id = sqlbox-db
> 
> smsbox-id = SQLBOX
> 
> bearerbox-host = localhost
> 
> bearerbox-port = ""
> 
> smsbox-port = 13004
> 
> smsbox-port-ssl = false
> 
> sql-log-table = sent_sms
> 
> sql-insert-table = send_sms
> 
> log-file = "/var/log/kannel/sqlbox.log"
> 
> log-level = 0
> 
>  
> 
> We’re running on a 32-bit Centos 5 OS.
> 
> Regards,
> 
> **Farida N. Bedwei**
> 
>  ****
> 
> **Senior Software Architect**
> 
> **Rancard Solutions Ltd.**
> 
> **web**: www.rancardmobility.com <http://www.rancardmobility.com/>
> 
> **mobile**: +233.24.425.5654 / +233.207.984.347
> 
> **office**: +233.289.529.573
> 
> ------------------------------------------------------------------------
> 
> *From:* Alejandro Guerrieri [mailto:[email protected]]
> *Sent:* Wednesday, December 24, 2008 10:33 AM
> *To:* Farida N. Bedwei
> *Cc:* [email protected]
> *Subject:* Re: SQLBox not compatible with smppbox version cvs 20081222
> 
>  
> 
> Please send complete configuration files for the three programs (remove 
> passwords and outside smsc information if any). I'll try to reproduce 
> the problem.
> 
>  
> 
> Regards,
> 
> --
> 
> Alejandro Guerrieri
> 
> [email protected] <mailto:[email protected]>
> 
>  
> 
>  
> 
>  
> 
> El 24/12/2008, a las 9:50, Farida N. Bedwei escribió:
> 
> 
> 
> Hi,
> 
>  
> 
> I pulled from CVS the latest version of SQLBox and kannel and run it 
> with smppbox version 20081222.  Although all boxes start up correctly, 
> when I attempt to send a message via smppbox, sqlbox shuts down with the 
> error below:
> 
>  
> 
>  
> 
> 2008-12-23 13:57:11 [307] [7] INFO: Connected to bearerbox at localhost 
> port 13001.
> 
> 2008-12-23 13:57:11 [307] [7] DEBUG: Started thread 8
> 
> (sqlbox.c:bearerbox_to_smsbox)
> 
> 2008-12-23 13:57:11 [307] [7] DEBUG: smsbox_to_bearerbox: got boxc_id 
> <KSMSC> from <127.0.0.1>
> 
> 2008-12-23 13:57:11 [307] [8] DEBUG: Thread 8
> 
> (sqlbox.c:bearerbox_to_smsbox) maps to pid 307.
> 
> 2008-12-23 13:57:19 [307] [7] ERROR: Msg packet was invalid.
> 
> 2008-12-23 13:57:19 [307] [7] ERROR: Failed to unpack data!
> 
> 2008-12-23 13:57:20 [307] [0] DEBUG: Thread 2 
> (sqlbox.c:bearerbox_to_sql) still running
> 
> 2008-12-23 13:57:20 [307] [0] DEBUG: Thread 7 (sqlbox.c:function) still 
> running
> 
> 2008-12-23 13:57:20 [307] [0] DEBUG: Thread 8
> 
> (sqlbox.c:bearerbox_to_smsbox) still running
> 
> 2008-12-23 13:57:20 [307] [0] DEBUG: Immutable octet strings: 54.
> 
>  
> 
> Is there a patch available which addresses this problem?
> 
>  
> 
> Regards,
> 
>  
> 
>  
> 
> **Farida N. Bedwei**
> 
>  
> 
> **Senior Software Architect**
> 
> **Rancard Solutions Ltd.**
> 
> **web**: www.rancardmobility.com <http://www.rancardmobility.com/>
> 
> **mobile**: +233.24.425.5654 / +233.207.984.347
> 
> **office**: +233.289.529.573
> 
>  
> 
>  
>