Thanks Alejandro, the symlink solved the mysql connection problem. I just found out from the kannel guide that AT command in smsc does not support DLR, so no report will be delivered. I'm using Huawei E172 modem with the at command, so I guess I won't be able to see the DLRs.
Thanks for the help. Now my kannel runs smoothly with no errors. On Tue, Jun 23, 2009 at 11:05 AM, Alejandro Guerrieri < [email protected]> wrote: > 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 >>> >> >> >
