Hello everyone, I am trying to use mysql as the dlr storage, but i get an error (see my log dump below):
-------------------------------------------------------------- 2009-06-22 13:12:14 [5828] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to database! 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to database! 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to database! 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to database! 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: can not connect to database! 2009-06-22 13:12:14 [5828] [0] ERROR: MYSQL: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2009-06-22 13:12:14 [5828] [0] PANIC: DLR: MySQL: database pool has no connections! 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(gw_panic+0xd4) [0x80d4674] 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(dlr_init_mysql+0x359) [0x8063529] 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(dlr_init+0x8b) [0x8061b2b] 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox(main+0x10a) [0x8054b5a] 2009-06-22 13:12:14 [5828] [0] PANIC: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb78e1775] 2009-06-22 13:12:14 [5828] [0] PANIC: bearerbox [0x8053f31] ---------------------------------------------------------------- my configurations as related to mysql settings are: ---------------------------------------- group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar #admin-deny-ip = "*.*.*.*" #admin-allow-ip = "" log-file = "/home/malaikamkuu/kannel/bearerbox.log" log-level = 1 #box-deny-ip = "*.*.*.*" #box-allow-ip = "127.0.0.1" #unified-prefix = "00358,0" store-type = spool store-location = "/home/malaikamkuu/kannel/spool" dlr-storage = mysql group = mysql-connection id = dlrdb host = localhost username = root password = password database = kannel max-connections = 5 group = dlr-db id = dlrdb table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = "" field-mask = mask field-status = status field-boxc-id = boxc --------------------------------------- i have the database up, i have created the database and the table and the fields, and i can access it using phpmyadmin, I can also access it using the terminal. But kannel gives me the above error My kannel environment is: Kannel bearerbox version `1.4.3'. Build `Feb 14 2009 16:26:23', compiler `4.3.3'. System Linux, release 2.6.28-11-generic, version #42-Ubuntu SMP Fri Apr 17 01:57:59 UTC 2009, machine i686. Hostname xps.tz, IP 127.0.1.1. Libxml version 2.6.32. Using OpenSSL 0.9.8g 19 Oct 2007. Compiled with MySQL 5.0.75, using MySQL 5.0.75. Using native malloc. Regards, Godfrey
