Hi Macboy, 1º read the kannel user guide! 2º your log shows that bearerbox cannot connect to your database due to credentials! - "Access denied for user 'camcom'@'localhost'" - if you still getting troubles try to connect to your database with some other client (sql client) with same credentials, check what is happening! 3º you are in the wrong direction for storing messages, find and read user guide of sqlbox!
[]'s 2010/9/25 <mac...@fastermail.com> > > 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] > > > * * > -- Luís Tiago Rico *Present Technologies* Rua D. João de Castro, Lote 12 Urbanização Quinta da Fonte 3030-384 Coimbra Portugal
