Then use a symlink: ln -s /path/where/mysql-sock-is /path/where/mysql-sock-should-be
Hope it helps, Alejandro On Tue, Jun 23, 2009 at 9:16 AM, Theodore G <[email protected]> wrote: > Hi, > I found where xampp is keeping the mysql.sock. the my.cnf in xampp is > already set correctly, i found another my.cnf in /etc/mysql directory, and > changed that with the new mysql.sock location, but when I tried to start > bearerbox, the same error came up. looks like the location kannel is > searching for mysql.sock is looking from somewhere else, not in my.cnf file. > > > I also tried to change the host in the mysql-connection group to 127.0.0.1 > and this is the error i get > ----------------------------- > malaikam...@xps:/etc/kannel$ bearerbox > 2009-06-23 10:14:27 [5993] [0] INFO: Debug_lvl = -1, log_file = <none>, > log_lvl = 0 > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database! > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL server > on '127.0.0.1' (111) > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database! > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL server > on '127.0.0.1' (111) > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database! > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL server > on '127.0.0.1' (111) > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database! > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL server > on '127.0.0.1' (111) > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: can not connect to database! > 2009-06-23 10:14:27 [5993] [0] ERROR: MYSQL: Can't connect to MySQL server > on '127.0.0.1' (111) > 2009-06-23 10:14:27 [5993] [0] PANIC: DLR: MySQL: database pool has no > connections! > 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(gw_panic+0xd4) [0x80d4674] > 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(dlr_init_mysql+0x359) > [0x8063529] > 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(dlr_init+0x8b) [0x8061b2b] > 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox(main+0x10a) [0x8054b5a] > 2009-06-23 10:14:27 [5993] [0] PANIC: > /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb7855775] > 2009-06-23 10:14:27 [5993] [0] PANIC: bearerbox [0x8053f31] > > ------------------------------ > > > > On Mon, Jun 22, 2009 at 5:21 PM, Donald Jackson <[email protected]>wrote: > >> 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 >> > >
