Something looks familiar to me: 2010-09-25 02:21:58 [2789] [0] ERROR: MYSQL: Access denied for user 'camcom'@'localhost' (using password: YES)
Acess denied for user *camcom *with password *camcom*! Provide the right credentials! You should have your database and table created! And by the way, you will not store messages with this configuration.... only delivery reports! 2010/9/25 <mac...@fastermail.com> > > Hey folks > Finally after installing Mysql-devel I was able to compile kannel with > Mysql support but now I am unable to connect kannel with Mysql database. > Every time that I try to start the bearerbox there comes an error indicating > that there is a connection failure and that access cannot be granted. If > anyone knows what I should do in order to advance this stage so that I can > finally store messages into the external storage which is Mysql database. > Below is the kannel configuration file and the errors that pop up whenever > am starting the bearerbox. Provide me with all the necessary steps that I > must undertake to successfully connect to the database. Otherwise all the > information in the kannel user guide reflects my configuration or point me > to the site that I must visit 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 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
