Is there any update in the cvs to try to patch? Can i provide any help? 2009/11/27 Bruno Aguirre <brunoaguirreris...@gmail.com>
> Ok, thanks a lot! > > > 2009/11/27 Alejandro Guerrieri <alejandro.guerri...@gmail.com> > >> 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 >>>>> >>>>> >>>>> >>>> >>> >> >