Hi I have compiled kannel with mysql support but am unable to have it started with mysql.And somone from the mailing list suggested I should provide the right credentials when during the configuration process i created the database named dlr and the table with the same name called dlr with its required fields but the mysql error of no access keeps popping up every time i start the bearerbox.Worse still someone from the mailing list suggested that my configuration file below cannot store messages as a result i need help on how i can make kannel talk to mysql and in turn make mysql to store messages.In actual sense i thougt the mysql username and password is those that the mysql database are using as such i created the username and the password as provided in the configuration file.Provide me with all the neccessary steps that i need to undertake to have support for mysql.
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 the world 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 will be 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]
