Count on me for testing. 2009/12/28 Alejandro Guerrieri <alejandro.guerri...@gmail.com>
> I'm working on the patch to support meta-data right now. I'll have a > version for testing during this week for sure, though it'll need testing on > all DB engines. > > Regards, > > Alex > > > On Mon, Dec 28, 2009 at 5:51 PM, Bruno Aguirre < > brunoaguirreris...@gmail.com> wrote: > >> Is there any updates? or any dev source i can test? >> >> 2009/12/8 Bruno Aguirre <brunoaguirreris...@gmail.com> >> >> Is there any stable version?, Im facing the same issue compiling older >>> sqlbox versions. >>> >>> 2009/12/7 Bruno Aguirre <brunoaguirreris...@gmail.com> >>> >>> 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 >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >
