Hi to all!. I'm having some sort of issues using sqlbox, in a test enviroment i'm loosing 50% of the mos. In a graphical way:
SMPPSim <-----> Bearerbox <----> Sqlbox <-----> Smsbox <-------> HTTP - Inyect 100Mos - - Receives 100mos - - Inserts 50mos - - Sent 50 mts - - Inyect 50 mts - I'm using the SQLBox from the cvs, also i've correct the patch from Limit per cycle for this version, at first i thought that was my implementation the mistake then i've switched to the lastest cvs and the bug was already there. My config: 1 ############################################################### 2 # # 3 # CORE CONFIG - Extended Config Setup # 4 # # 5 ############################################################### 6 7 group = core 8 admin-port = 13000 9 # Administration Port 10 admin-password = @dM1nMe 11 # Administration Password 12 admin-deny-ip = "*.*.*.*" 13 # Deny all ips for Administrate 14 admin-allow-ip = "127.0.0.1" 15 # Allow only this IPs, semicolon separated 16 smsbox-port = 13010 17 # Smsbox connection Port 18 wapbox-port = 13020 19 # Wapbox connection Port 20 wdp-interface-name = "*" 21 # UDP BroadCast 22 log-level = 0 23 # Verbose level, 0 More debug... 4 Less debug 24 log-file = "/var/log/kannel/bearerbox.log" 25 # Log file path 26 box-deny-ip = "*.*.*.*" 27 # Deny All Ips to connect to Bearerbox 28 box-allow-ip = "127.0.0.1" 29 # Allow only this Ips , semicolon separated 30 dlr-storage = mysql 31 # Where to store temp DLR data, internal default, Mysql recomended 32 store-type = spool 33 # Store type, block file is default, spool is one file per message 34 store-location = "/var/spool/kannel" 35 # Folder location of the spool 36 37 ############################################################### 38 # # 39 # MYSQL CONFIG - DLR Temp Storage # 40 # # 41 ############################################################### 42 43 group = mysql-connection 44 id = mydlr 45 # Identification 46 host = 127.0.0.1 47 # IP of the MYSQL Database 48 port = 3306 49 # Port of the MYSQL Database 50 username = root 51 # Username of the connection 52 password = mysql 53 # Pasword of the connection 54 database = kannel 55 # Database name 56 max-connections = 50 57 # Maximun Concurrent conections 58 59 group = dlr-db 60 id = mydlr 61 # Identification 62 table = dlr 63 # Table Name 64 field-smsc = smsc 65 # Smsc Field Name 66 field-timestamp = ts 67 # Timestamp Field Name 68 field-destination = destination 69 # Destination Field Name 70 field-source = source 71 # Source Field Name 72 field-service = service 73 # Service Field Name 74 field-url = url 75 # Url Field Name 76 field-mask = mask 77 # Dlr Mask Field Name 78 field-status = status 79 # Status Field Name 80 field-boxc-id = box 81 # Box Id Field Name 82 83 group = smpp-tlv 84 name = MAS_APP_ID 85 smsc-id = "debug" 86 tag = 0x1401 87 type = nulterminated 88 length = 4 89 90 91 ############################################################### 92 # # 93 # SMSBOX CONFIG - Handle SQLBox Instance # 94 # # 95 ############################################################### 96 97 group = smsbox 98 #smsbox-id = smsbox 99 # Identification 100 bearerbox-host = localhost 101 #bearerbox-port = 13030 102 # Ip to the Bearerbox 103 sendsms-port = 13013 104 # Available port for SMS inyection 105 log-file = "/var/log/kannel/smsbox.log" 106 # Log file path 107 log-level = 0 108 # Verbose level, 0 More debug... 4 Less debug 109 #http-request-retry = 10 110 # Retry for the http request 111 #http-queue-delay = 30 112 # Delay per Retry 113 114 ############################################################### 115 # # 116 # WAPBOX CONFIG - Wap Gateway Main config # 117 # # 118 ############################################################### 119 120 group = wapbox 121 bearerbox-host = 127.0.0.1 122 # Bearerbox IP 123 log-file = "/var/log/kannelX1/wapbox.log" 124 # Log file path 125 log-level = 4 126 # Verbose level, 0 More debug... 4 Less debug 127 syslog-level = none 128 # Log in syslog 129 130 ############################################################### 131 # # 132 # PUSH PROXY GATEWAY - WapPush inyection # 133 # # 134 ############################################################### 135 136 group = ppg 137 ppg-url = /wappush 138 # Route in the inyection 139 ppg-port = 8080 140 # Port for inyection 141 concurrent-pushes = 100 142 # Concurrency 143 users = 1024 144 # Total users connected 145 ppg-allow-ip = "127.0.0.1" 146 # Allow only this Ips , semicolon separated 147 trusted-pi = true 148 # Trust by default 149 service-name = ppg1 150 # Service name 151 152 group = wap-push-user 153 wap-push-user = wappush 154 # User for the inyection 155 ppg-username = foo 156 # Username for the inyection 157 ppg-password = bar 158 # Password 159 allow-ip = "127.0.0.1" 160 # Allow only this Ips , semicolon separated 161 162 ############################################################### 163 # # 164 # SEND SMS - Send messages configuration # 165 # # 166 ############################################################### 167 168 group = sendsms-user 169 username = tester 170 # Username for the inyection 171 password = foobar 172 # Password For the inyection 173 user-deny-ip = "*.*.*.*" 174 # Deny All IPs 175 user-allow-ip = "127.0.0.1" 176 # Allow only this Ips , semicolon separated 177 178 ############################################################### 179 # # 180 # SEND SMS ROUTING - Send Messages routing # 181 # # 182 ############################################################### 183 184 group = sms-service 185 keyword = default 186 catch-all = true 187 # Catch All 188 omit-empty = true 189 # Omit Empty response 190 max-messages = 10 191 #max-messages = 0 192 # Dont send MTs synchronously 193 get-url = " http://localhost:8090/mo?smsc_id=%i&short_code=%P&phone=%p&message=%a"; 194 #text = "OK" 195 # URL to invoke ( README for constants ) 196 197 ############################################################### 198 # # 199 # SMSCS CONFIG - Carrier Specific Config # 200 # # 201 ############################################################### 202 203 include = "/etc/kannel/smsc/debug/carriers.conf" 1 ############################################################### 2 # # 3 # SQLBOX CONFIG - Full status storage and Queueing # 4 # # 5 ############################################################### 6 7 group = sqlbox 8 id = sqlbox 9 # Config Identification 10 #smsbox-id = chunkerbox 11 # Identification 12 bearerbox-host = localhost 13 # Bearerbox IP 14 bearerbox-port = 13010 15 # Bearerbox Port 16 smsbox-port = 13030 17 # Send Sms box ( From kannel core config ) 18 #limit-per-cycle = 1 19 # SELECT limit 20 smsbox-port-ssl = false 21 # Usses SSL? 22 sql-log-table = sent_sms 23 # Sent Sms Table name 24 sql-insert-table = send_sms 25 # Queueing Sms Table name 26 log-file = "/var/log/kannel/sqlbox.log" 27 # Log File name 28 log-level = 0 29 # Log Verbosity 30 31 group = mysql-connection 32 id = sqlbox 33 # Identification 34 host = 127.0.0.1 35 # Database IP 36 port = 3306 37 # Database Port 38 username = root 39 # Username ( Grant CREATE ) 40 password = mysql 41 # Password 42 database = kannel 43 # Database name 44 max-connections = 10
