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