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 >
