My guess is that it's the missing meta-data field support on sqlbox, but I still need to do some extra tests to confirm.
I've the patch partially ready (missing some details on a couple of db engines only), will finish testing it and commit next week. Regards, Alex On Fri, Nov 27, 2009 at 7:59 PM, Bruno Aguirre <brunoaguirreris...@gmail.com > wrote: > Ok, is there any way i can help? Perhaps if you have an idea of where is > the issue i can help you in the fix > > 2009/11/27 Alejandro Guerrieri <alejandro.guerri...@gmail.com> > > There seems to be an issue with latest CVS'es (with meta-data) and Sqlbox. >> >> I'm working on a fix, but I've been quite busy lately, I hope to be able >> to finish it next week. >> >> Regards, >> >> Alex >> >> >> On Fri, Nov 27, 2009 at 7:11 PM, Bruno Aguirre < >> brunoaguirreris...@gmail.com> wrote: >> >>> 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 >>> >>> >>> >> >
