I try to start using opensmppbox with mysql base First I compiled kannel with mysql (--with-mysql), compiled sqlbox and compiled opensmppbox with mysql support too.
This is opensmppbox config, taken from samples group = core dlr-storage = mysql store-location = "/var/log/kannel/smpp_sms" group = opensmppbox opensmppbox-id = smppbox-01 opensmppbox-port = 10010 bearerbox-host = localhost bearerbox-port = 13005 log-level = 0 log-file = "/var/log/kannel/opensmppbox.log" our-system-id = bee-01 route-to-smsc = my-default-smsc smpp-logins = "/etc/kannel/smpplogins.txt" use-smppboxid = yes use-systemid-as-smsboxid = yes group = mysql-connection id = mydlr host = localhost username = kannel password = kannel database = kannel max-connections = 1 group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxcid group = client-route client-id = myclient1 smsc-id = mysmsc1 group = client-route client-id = myclient2 smsc-id = mysmsc2 When trying to start it up - receive 2012-10-29 15:28:32 [2582] [0] INFO: Starting to log to file /var/log/kannel/opensmppbox.log level 0 2012-10-29 15:28:32 [2582] [0] INFO: Added logfile `/var/log/kannel/opensmppbox.log' with level `0'. 2012-10-29 15:28:32 [2582] [0] DEBUG: Adding client routing to id <myclient1> for smsc id <mysmsc1> 2012-10-29 15:28:32 [2582] [0] DEBUG: Adding client routing to id <myclient2> for smsc id <mysmsc2> 2012-10-29 15:28:32 [2582] [0] INFO: MYSQL: Connected to server at localhost. 2012-10-29 15:28:32 [2582] [0] INFO: MYSQL: server version 5.5.24-0ubuntu0.12.04.1, client version 5.5.24. 2012-10-29 15:28:32 [2582] [0] INFO: DLR using storage type: mysql 2012-10-29 15:28:32 [2582] [0] WARNING: opensmmpbox: DLR: using default 'internal' for storage type. 2012-10-29 15:28:32 [2582] [0] PANIC: opensmppbox: DLR: storage type 'internal' don't implement needed functions 2012-10-29 15:28:32 [2582] [0] PANIC: opensmppbox(gw_backtrace+0xae) [0x45622e] 2012-10-29 15:28:32 [2582] [0] PANIC: opensmppbox(gw_panic+0x165) [0x4563a5] 2012-10-29 15:28:32 [2582] [0] PANIC: opensmppbox(box_dlr_init+0x6c8) [0x40c6b8] 2012-10-29 15:28:32 [2582] [0] PANIC: opensmppbox(main+0xb2a) [0x40aa8a] 2012-10-29 15:28:32 [2582] [0] PANIC: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f4c4b9c576d] 2012-10-29 15:28:32 [2582] [0] PANIC: opensmppbox() [0x40afd9] I found this bug report - https://redmine.kannel.org/issues/649 Tried to change dlr-storage to box-dlr-storage as said, so receive this error message 2012-10-29 15:35:43 [2587] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2012-10-29 15:35:43 [2587] [0] ERROR: Group 'core' may not contain field 'box-dlr-storage'. 2012-10-29 15:35:43 [2587] [0] ERROR: Error found on line 6 of file `/etc/kannel/opensmppbox.conf'. 2012-10-29 15:35:43 [2587] [0] PANIC: Couldn't read configuration from `/etc/kannel/opensmppbox.conf'. 2012-10-29 15:35:43 [2587] [0] PANIC: opensmppbox(gw_backtrace+0xae) [0x45622e] 2012-10-29 15:35:43 [2587] [0] PANIC: opensmppbox(gw_panic+0x165) [0x4563a5] 2012-10-29 15:35:43 [2587] [0] PANIC: opensmppbox(main+0xf8f) [0x40aeef] 2012-10-29 15:35:43 [2587] [0] PANIC: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f5b8679b76d] 2012-10-29 15:35:43 [2587] [0] PANIC: opensmppbox() [0x40afd9] So is it possible to make opensmppbox use mysql and how? Revisions Kannel - 5010 OpenSMPPBox - 66 SQLBox - 49 As I find - they are latest available.
