MYSQL: Unknown database 'dlr' Did you create the database?
On Thu, Sep 19, 2013 at 10:26 AM, alex Preda <[email protected]> wrote: > Hello Alvaro, > Thanks for your reply ! :) > As per your instructions i tried to start bearerbox but it is showing some > following error. > > [root@test1 kannel]# !b > bearerbox -v 0 /etc/kannel.conf > 2013-09-19 18:05:40 [30340] [0] INFO: Debug_lvl = 0, log_file = <none>, > log_lvl = 0 > 2013-09-19 18:05:40 [30340] [0] ERROR: MYSQL: can not connect to database! > 2013-09-19 18:05:40 [30340] [0] ERROR: MYSQL: Unknown database 'dlr' > 2013-09-19 18:05:40 [30340] [0] PANIC: DLR: MySQL: database pool has no > connections! > 2013-09-19 18:05:40 [30340] [0] PANIC: bearerbox(gw_panic+0x147) [0x486067] > 2013-09-19 18:05:40 [30340] [0] PANIC: bearerbox(dlr_init_mysql+0x48e) > [0x41c29e] > 2013-09-19 18:05:40 [30340] [0] PANIC: bearerbox(dlr_init+0x7c) [0x41a83c] > 2013-09-19 18:05:40 [30340] [0] PANIC: bearerbox(main+0xd9) [0x40e659] > 2013-09-19 18:05:40 [30340] [0] PANIC: > /lib64/libc.so.6(__libc_start_main+0xfd) [0x7eff9db35cdd] > 2013-09-19 18:05:40 [30340] [0] PANIC: bearerbox() [0x40d6a9] > > Please check my kannel.conf file, if you find any misconfiguration please > let me know. > > #CORE > group = core > admin-port = 13000 > smsbox-port = 13001 > admin-password = test > log-file = "/var/log/kannel/kannel.log" > log-level = 0 > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1;x.x.x.x" > admin-deny-ip = "" > admin-allow-ip = "" > unified-prefix = "00358,0" > access-log = "/var/log/kannel/access.log" > dlr-storage = mysql > > #SMSC > group = smsc > smsc = smpp > smsc-id = "sms1" > host = x.x.x.x > smsc-username = test > smsc-password = test > port = 1234 > system-type = sms > > #smsbox > group = smsbox > bearerbox-host = localhost > sendsms-port = 13013 > global-sender = 13013 > sendsms-chars = "0123456789 +-" > log-file = "/var/log/kannel/smsbox.log" > log-level = 0 > access-log = "/var/log/kannel/access.log" > > # sendsms-user > group = sendsms-user > username = test > password = test > user-deny-ip = "" > user-allow-ip = "" > default-sender = 123456 > > #smsroute > group = smsbox-route > smsbox-id = mysmsc > smsc-id = "sms1" > shortcode = "1111;2222" > > #sms-service > group = sms-service > keyword = default > accept-x-kannel-headers = true > max-messages = 3 > concatenation = true > catch-all = true > > # Example MYSQL Connection > group = mysql-connection > id = mydlr > host = localhost > username = root > password = redhat > database = dlr > port = 3306 > > #dlr-db > group = dlr-db > id = mydlr > table = dlr > field-smsc = smsc > field-timestamp = ts > field-destination = destination > field-source = source > field-service = service > field-url = url > field-mask = mask > field-status = status > field-boxc-id = boxc > > Thanks > > > On Thu, Sep 19, 2013 at 7:23 PM, Alvaro Cornejo > <[email protected]>wrote: > >> Hi >> >> You need to first start bearerbox and have it listen on port 13001 as >> you specified in its config. >> >> Regards >> >> Alvaro >> >> On 9/19/13, alex Preda <[email protected]> wrote: >> > Hello kannel Team, >> > I have installed gateway 1.5.0(v) with option >> > --with-mysql, and installed kannel rpm kannel-1.4.3, I have been >> > trying to set up *dlr-storage using mysql*. but im getting error in >> > restart kannel. service failed to restart. but its work with >> > dlr-storage = internal. i was check old posts in kannel user directory >> > and find some related issues but still facing error. Thanks >> > >> > >> > here is my log file of smsbox. >> > >> > 2013-09-19 14:50:54 [30003] [0] ERROR: connect failed 2013-09-19 >> 14:50:54 >> > [30003] [0] ERROR: System error 111: Connection refused 2013-09-19 >> 14:50:54 >> > [30003] [0] ERROR: error connecting to server `localhost' at port >> `13001' >> > 2013-09-19 14:50:54 [30003] [0] PANIC: Couldn't connect to the >> bearerbox. >> > 2013-09-19 14:50:54 [30003] [0] PANIC: /usr/sbin/smsbox(gw_panic+0x15a) >> > [0x43ddfa] 2013-09-19 14:50:54 [30003] [0] PANIC: >> > /usr/sbin/smsbox(main+0xca0) [0x40e530] 2013-09-19 14:50:54 [30003] [0] >> > PANIC: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f2d47967cdd] >> 2013-09-19 >> > 14:50:54 [30003] [0] PANIC: /usr/sbin/smsbox() [0x40d1b9] 2013-09-19 >> > 14:50:58 [30040] [0] INFO: Added logfile `/var/log/kannel/smsbox.log' >> with >> > level `0'. >> > >> > Regards >> > Alex Preda >> > >> >> >> -- >> >> |-----------------------------------------------------------------------------------------------------------------| >> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier >> celular y Nextel >> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via >> SMS y GPRS online >> Visitenos en www.perusms.NET www.smsglobal.com.mx y >> www.pravcom.com >> > >
