Re: regarding mysql database

DO NOT CROSS POST!!!

On 10/02/2009, at 14:06, narendra reddy wrote:

> HI .
>
>
>        1)  first i download the source code from the kannel downlaod  
> 1.4.1 .and extract in the mydesktop.and according to user    guide    
> i done ./configure and make and make install.
>
>
>     I done the configure with mysql like  ./configure ---with- 
> mysql . its  successfully completed and after i done  make in  
> console .after make install done in root directory.
>
>
>                     after in the root /usr/local/sbin . in this  
> folder 3 boxes is genatated. from there i run the bearerbox like ./ 
> bearerbox -v 1 kannelconf1.conf    .its successfully run. and after  
> i run smsbox  like ./smsbox -v 1 kannelconf1.conf. and i opend the  
> mysql-query-browser and creat one table with fileds in the mysql  
> query-browser
> CREATE TABLE dlr (
> #     smsc varchar(40),
> #     ts varchar(40),
> #     destination varchar(40),
> #     source varchar(40),
> #     service varchar(40),
> #     url varchar(255),
> #     mask int(10),
> #     status int(10),
> #     boxc varchar(40)
> #   )
>    its create  a  table . and my config file is like below.
>       group = core
> admin-port = 13000
> admin-password = bar
> log-file = "log/bearer.log"
> log-level =0
> access-log = "log/beareraccess.log"
> smsbox-port = 13003
> store-file = "log/kannelqueue.log"
> smsbox-max-pending=5
> dlr-storage=mysql
> #storage-type=mysql
>
>
> group = mysql-connection
> id = mydlr
> host =172.22.24.194
> username = root
> password = admin
> database =narendra
> max-connections = 1
> group = dlr-db
> id = mydlr
> table = dlr
> field-smsc = smpp
> field-timestamp = ts
> field-destination =1234
> field-source = 998516774
> field-service = news
> field-url = url
> field-mask =delivered
> field-status = status
> field-boxc-id = mysmsc
>
>
> # SMSC SMPP
> group = smsc
> smsc =  smpp
> smsc-id =SMPPSim
> host = localhost
> port = 2775
> transceiver-mode=1
> log-file = "log/kannel.log"
> alt-dcs = true
> smsc-username =smppclient
> smsc-password = password
> system-type = "VMS"
> address-range ="555"
> source-addr-ton = 1
> source-addr-npi = 1
> dest-addr-ton = 1
> dest-addr-npi = 1
> msg-id-type = 0x01
> throughput = 50
> max-pending-submits = 10
> enquire-link-interval= 60
>
> # SMSBOX SETUP
> group = smsbox
> bearerbox-host = localhost
> sendsms-port = 13001
> log-file = "log/smsbox.log"
> log-level = 0
> access-log = "log/smsboxaccess.log"
>
> # SEND-SMS USERS
> group = sendsms-user
> username =pyro
> password = pyro
> max-messages = 5
> concatenation = true
>
> #SMS-Service
> group = sms-service
> keyword = default
> text = "Reply from others"
>
>
>              and done the changes like that  in  config file . but  
> messages are not inserted in the dlr table.wat is the wrong from my
> side.please help me .I have to submit my total ESME  product with in  
> two days. so suggest  me where i am doing mistake ASAP .
>
>
> Thanks and Regards,
> Narendra reddy,
> Hyderabad,
> A.P,
> Ph NO:+91 9985167784.
>
>
>
>
>
>
>
>
>
>