Re: Storing data into mysql server
Hi Srinivasa, Srinivasa Rao Munagala wrote: > > Hi, > I am trying to configure the kannel gateway. > I was able to configure the kannel gateway with dlr-db > as mysql. > There are no panics when the gateway is started using > ./bearerbox confile. > > Problem > > when i am sending fake smsc i am getting reply from > the kannel gateway. > But the data related to fake sms is not stored in > Mysql database. > Please can one help me to configure the kannel to > store the sms data into mysql server database. I guess you didn't get the point. The dlr-db group defines where to store (in your case the mysql db) the temporary DLR (delivery report) data, *not* the sms data itself! So when you fire out an SMS to an *real* SMSC and you want them to reply with a receive report you have to store that temporary data somewhere, either in memory or in the mysql db. So you mistaked by two ways: 1. Assuming that the fakesmsc would deliver DLRs, which it does not, AFAIK. 2. Assuming that the dlr-db group stores the messages into the db. If you want to store messages into your mysql db, then this should be out of scope of Kannel. Hence for MO messages smsbox is sending them to an HTTP server. Let the HTTP server do the storing of the SMS to your mysql db. Another suggested approach would be: (list, please thread this as proposal ;) Implement an 'msg-db' group that defines the fields of an SMS entry and a 'store-db' action in the 'sms-servce' group to tell smsbox to which db id to store an MO'ed message. So you'd get something like this: group = msg-id id = msg_store table = messages field-source = source_address field-destination = destination_address ... group = sms-service keyword = default store-db = msg_store max-messages = 0 This would allow you to store all incoming messages to the mysql table without replying to them directy. You could even extend the beast by implementing a read thread that queues in an "outgoing" messsages table and sends those to bearerbox for MT transport. Stipe [EMAIL PROTECTED] --- Wapme Systems AG Vogelsanger Weg 80 40470 Düsseldorf Tel: +49-211-74845-0 Fax: +49-211-74845-299 E-Mail: [EMAIL PROTECTED] Internet: http://www.wapme-systems.de --- wapme.net - wherever you are
Storing data into mysql server
Hi, I am trying to configure the kannel gateway. I was able to configure the kannel gateway with dlr-db as mysql. There are no panics when the gateway is started using ./bearerbox confile. Problem when i am sending fake smsc i am getting reply from the kannel gateway. But the data related to fake sms is not stored in Mysql database. Please can one help me to configure the kannel to store the sms data into mysql server database. Below is the config file group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar #status-password = foo #admin-deny-ip = "" #admin-allow-ip = "" log-file = "/tmp/kannel.log" log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" unified-prefix = "00358,0"\ dlr-storage= mysql access-log = "access.log" #store-file = "kannel.store" #ssl-certkey-file = "mycertandprivkeyfile.pem" # SMSC CONNECTIONS group = smsc smsc = fake smsc-id = FAKE port = 1 connect-allow-ip = 127.0.0.1 # SMSBOX SETUP group = smsbox bearerbox-host = localhost sendsms-port = 13013 global-sender = 13013 #sendsms-chars = "0123456789 +-" #log-file = "/tmp/smsbox.log" #log-level = 0 #access-log = "access.log" # SEND-SMS USERS group = sendsms-user username = tester password = foobar #user-deny-ip = "" #user-allow-ip = "" # this sender is for Kannel relay testing (http_smsc) group = sendsms-user username = kannel password = rL4y user-deny-ip = "*.*.*.*" user-allow-ip = "127.0.0.1" # SERVICES group = sms-service keyword = nop text = " You asked nothing and I did it!" # this service is for Kannel relay testing, when this Kannel # works as relay gateway group = sms-service keyword = relay #max-messages = 1 get-url = "http://www.thegate.com/testingkannel/testkannel.asp?user=kannel&pass=rL4y&from=%p&to=%P&text=%r"; # there should be default always group = sms-service keyword = default text = "No service specified" # DLR with MySQL support configuration group = mysql-connection id = mydlr host = localhost mysql-username = root mysql-password = database = dlr group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-source=source field-destination = destination field-service = service field-url = url field-mask = mask field-status = status Thanks, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/