Hey folks
Finally after installing Mysql-devel I was able to compilekannel with Mysql
support but now I am unable to connect kannel with Mysqldatabase. Every time
that I try to start the bearerbox there comes anerror indicating that there is
aconnection failure and that access cannot be granted. If anyone knows what
Ishould do in order to advance this stage so that I can finally store
messagesinto the external storage which is Mysql database. Below is the
kannelconfiguration file and the errors that pop up whenever am starting
thebearerbox. Provide me with all the necessary steps that I must undertake
tosuccessfully connect to the database. Otherwise all the information in
thekannel user guide reflects my configuration or point me to the site that I
mustvisit for more information.
group = core
admin-port = 13000
admin-password = henry
status-password = henry
admin-deny-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1"
smsbox-port = 13001
#wapbox-port = 13002
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
wdp-interface-name = "*"
log-file ="/home/camcom/bearerbox.log"
log-level = 1
access-log ="/home/camcom/kannel.access"
dlr-storage = mysql
#group = smsc
#smsc = at
#modemtype = auto
#device = /dev/ttyUSB0
#my-number = 0888959802
#log-level = 0
#connect-allow-ip = 127.0.0.1
#sim-buffering = true
#group = modems
#id = huawei_e160
#name = "huawei_e160"
#detect-string = "huawei"
#init-string = "ATZ"
#init-string = "ATQ0 V1 E1 S0=0&C1 &D2 +FCLASS=0"
#init-string ="AT+CNMI=2,1,2,2,0"
#message-storage = sm
#speed = 115200
group = smsbox
bearerbox-host = localhost
sendsms-port = 13013
sendsms-chars = "0123456789"
global-sender = "0884238523"
access-log ="/home/camcom/kannel.access"
log-file = "/home/camcom/smsbox.log"
log-level = 0
group = sendsms-user
username = 123
password = 123
max-messages = 1
concatenation = true
group = sms-service
keyword = baddy
text = "singly configured for theworld of poly!"
#default service
group = sms-service
keyword = default
text = "INSTANT REPLY”
group = smsc
smsc = fake
smsc-id = FAKE
host = localhost
port = 10000
group = mysql-connection
id = mydlr
host = localhost
username = camcom
password = camcom
database = dlr
# max count of connections that willbe opened for dbpool
# default is 1
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
Error messages at starting bearerbox
2010-09-25 02:21:58 [2789] [0] ERROR:MYSQL: can not connect to database!
2010-09-25 02:21:58 [2789] [0] ERROR:MYSQL: Access denied for user
'camcom'@'localhost' (using password: YES)
2010-09-25 02:21:58 [2789] [0] PANIC:DLR: MySQL: database pool has no
connections!
2010-09-25 02:21:58 [2789] [0] PANIC:sbin/bearerbox(gw_panic+0x147) [0x485cb7]
2010-09-25 02:21:58 [2789] [0] PANIC:sbin/bearerbox(dlr_init_mysql+0x48e)
[0x41c1fe]
2010-09-25 02:21:58 [2789] [0] PANIC:sbin/bearerbox(dlr_init+0x7c) [0x41a79c]
2010-09-25 02:21:58 [2789] [0] PANIC:sbin/bearerbox(main+0xd9) [0x40e6a9]
2010-09-25 02:21:58 [2789] [0] PANIC:/lib64/libc.so.6(__libc_start_main+0xfd)
[0x7f1f18d34c5d]
2010-09-25 02:21:58 [2789] [0] PANIC:sbin/bearerbox() [0x40d6f9]
