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