Hi all, When I kick off sqlbox (on CentOS), it doesn't connect. The kannel-sqlbox.log says:
2011-06-15 22:45:37 [15745] [0] INFO: MYSQL: server version 5.0.92-community,client version 5.0.92. 2011-06-15 22:45:37 [15745] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2011-06-15 22:45:37 [15745] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 15745. 2011-06-15 22:45:37 [15745] [1] DEBUG: Connecting to <127.0.0.1> 2011-06-15 22:45:37 [15745] [1] ERROR: connect to <127.0.0.1> failed 2011-06-15 22:45:37 [15745] [1] ERROR: System error 111: Connection refused 2011-06-15 22:45:37 [15745] [1] ERROR: error connecting to server `localhost' at port `13001' 2011-06-15 22:45:37 [15745] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) terminates. The MySQL connection seems to be fine. I believe, that somehow the ports as defined in the conf files cause a conflict. This is my kannel-sqlbox.conf file: “group = sqlbox id = sqlbox-db smsbox-id = sqlbox global-sender = "" bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 group=mysql-connection id =sqlbox-db host = localhost username = gebruiker password = password database = tekstberichten” My main config file is: "group = core admin-port = 13000 admin-password = bar admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1" smsbox-port = 13003 log-file = "/var/log/kannel/bearerbox.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" dlr-storage=mysql log-level=0 group = smsbox bearerbox-host="localhost" sendsms-port = 13013 sendsms-chars = "+0123456789" log-file = "/var/log/kannel/smsbox.log" log-level = 0 access-log = "/var/log/kannel/access.log" log-level = 0 mo-recode = 1 group = smsc smsc = smpp smsc-id = smpp host = msg1.smpp.com port = 8000 receive-port = 8000 transceiver-mode = false throughput = 10 smsc-username = gebruiker smsc-password = paswoord system-type = 9ca36c15 dest-addr-ton=1 log-file = "/var/log/kannel/smpp.log" log-level = 0 msg-id-type=0x01 enquire-link-interval = 30 group = sendsms-user username = username password = pwd forced-smsc = smpp name = users user-deny-ip = "*.*.*.*" user-allow-ip = "127.0.0.1" max-messages = 3 concatenation = 1 omit-empty = 1 # DLR SETUP #mysql connection group = mysql-connection id = mydlr host = localhost username = gebruiker password = password database = sms max-connections = 10 group = dlr-db id = mydlr table=log field-smsc=smsc field-timestamp=timestamp field-destination=destination field-source=source field-service=service field-url=url field-mask=mask field-status=status field-boxc-id=boxc_id" Would anyone be able to help me get on track? Thanks in advance! Michael
