Hi Theodore, I use MAMP (Mac clone of XAMPP).
It stores the mysqld.sock file elsewhere (usually in the MAMP directory). I would suggest trying to change "localhost" to "127.0.0.1" this should solve your problem. Alternatively, find the place where XAMPP is keeping your mysqld.sock file and edit your my.cnf file accordingly. Hope this helps. Donald http://www.thearchitech.com/ 2009/6/22 Theodore G <[email protected]> > 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 > -- Donald Jackson http://www.ddj.co.za/ donaldjster(a)gmail.com
