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 > > >
