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