Hi ,
i compiled the kannel with ./configure --- --- with-mysql .its
compiled success fully.
and i added in the dlr-storage=mysql in the core group
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 = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
i added like this in the my conf file. and after in the
./bearerbox -v 1 kannelconf1.conf its gave below message
2009-02-10 17:25:09 [27753] [0] INFO: Debug_lvl = 1, log_file = <none>,
log_lvl = 0
2009-02-10 17:25:09 [27753] [0] INFO: MYSQL: Connected to server at
172.22.24.194.
2009-02-10 17:25:09 [27753] [0] INFO: MYSQL: server version
5.0.27-standard-log, client version 5.0.26.
2009-02-10 17:25:09 [27753] [0] INFO: DLR using storage type: mysql
2009-02-10 17:25:09 [27753] [0] INFO: Added logfile `log/bearer.log' with
level `0'.
2009-02-10 17:25:09 [27753] [0] INFO: Started access logfile
`log/beareraccess.log'.
2009-02-10 17:25:09 [27753] [0] INFO: HTTP: Opening server at port 13000.
2009-02-10 17:25:09 [27753] [0] INFO: Set SMS resend frequency to 60
seconds.
2009-02-10 17:25:09 [27753] [0] INFO: SMS resend retry set to unlimited.
2009-02-10 17:25:09 [27753] [0] WARNING: bool variable set to strange value,
assuming 'true'
2009-02-10 17:25:09 [27753] [0] INFO: Set throughput to 500.000 for smsc id
<(null)>
2009-02-10 17:25:09 [27753] [0] INFO: DLR rerouting for smsc id <(null)>
enabled.
2009-02-10 17:25:09 [27753] [0] INFO: Added logfile `log/kannel.log' with
level `0'.
This means bearerbox connected to mysql server
.but in the mysql-query-browser i created table with the below fields
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)
# )
but in the mysql table no messages are added in the table .pls
help me .where i am doing the mistake .and any filelds i can add in the
conf file . (please dont tell read user-guide like that .because i read
the user-guide 20 times but i can't find exactly wats problem.).i have to
meet my management with status ASAP. please tell me how can move from this
databases,.(i am using suse linux 10.1 version) .(my requirement is to
watch the messages in the tables like log files it is possible ?).
1) please exactly tell me wat we can do using mysql database in kannel
code
2) we can store the messages in tables.
can suggest me regarding this topics.
Best Regards,
Narendra.
