Hi,
2006-03-01 13:35:33 [24447] [0] INFO: Added logfile
`/var/log/kannel/sqlbox.log' with level `0'.
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: can not connect to database!
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: Can't connect to MySQL server
on 'db1.XXXXX.com' (111)
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: can not connect to database!
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: Can't connect to MySQL server
on 'db1.XXXXX.com' (111)
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: can not connect to database!
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: Can't connect to MySQL server
on 'db1.XXXXX.com' (111)
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: can not connect to database!
2006-03-01 13:35:33 [24447] [0] ERROR: MYSQL: Can't connect to MySQL server
on 'db1.XXXXX.com' (111)
2006-03-01 13:35:33 [24447] [0] PANIC: SQLBOX: MySQL: database pool has no
connections!
2006-03-01 13:35:33 [24447] [0] PANIC: ./sqlbox/sqlbox(gw_panic+0x255)
[0x425f74]
2006-03-01 13:35:33 [24447] [0] PANIC:
./sqlbox/sqlbox(sqlbox_init_mysql+0x3e6) [0x40e1a7]
2006-03-01 13:35:33 [24447] [0] PANIC: ./sqlbox/sqlbox(sqlbox_init_sql+0x22)
[0x40c7ee]
2006-03-01 13:35:33 [24447] [0] PANIC: ./sqlbox/sqlbox [0x409a2c]
2006-03-01 13:35:33 [24447] [0] PANIC: ./sqlbox/sqlbox(main+0x110)
[0x409bed]
2006-03-01 13:35:33 [24447] [0] PANIC:
/lib64/tls/libc.so.6(__libc_start_main+0xea) [0x2aaaab7ff54a]
2006-03-01 13:35:33 [24447] [0] PANIC: ./sqlbox/sqlbox [0x408a3a]
Thanks,
Stuart
----- Original Message -----
From: "Rene Kluwen" <[EMAIL PROTECTED]>
To: "Stuart" <[EMAIL PROTECTED]>
Cc: <users@kannel.org>
Sent: Wednesday, March 01, 2006 1:58 PM
Subject: Re: SQLBox Mysql Connection
What do your logfile say?
Rene Kluwen
Chimit
Hi,
Thanks for your reply....
Here's the config for group = smsbox:
# SMSBOX SETUP
group = smsbox
bearerbox-host = localhost
bearerbox-is-sqlbox = true
#sendsms-port = 13013
sendsms-port = 13013
global-sender = "12345"
sendsms-url = "/cgi-bin/sendsms"
#sendsms-chars = "0123456789 +-"
log-file = "/var/log/kannel/smsbox.log"
#log-level = 0
access-log = "/var/log/kannel/access.log"
I've also set "bearerbox-is-sqlbox = true" in the "smsbox" group.
Stuart
----- Original Message -----
From: "Rene Kluwen" <[EMAIL PROTECTED]>
To: "Stuart" <[EMAIL PROTECTED]>
Sent: Wednesday, March 01, 2006 1:23 PM
Subject: Re: SQLBox Mysql Connection
How about
group = smsbox?
Do you use the parameter bearerbox-is-sqlbox?
Rene Kluwen
Chimit
Hi,
I'm trying to set up sqlbox to log incoming and outgoing messages to /
from
the smbox but cannot get the smsbox to connect to mysql.
I'm using the same connection settings as I did for dlr with mysql and
that
worked fine. Is there something I'm missing? It's running on SuSe 10 on
a
dual 64-bit Xeon machine. The code make's with no error and I'm using
the
latest cvs of kannel and sqlbox.
Here is a snippet of the conf file:
# mysql DLR
group = mysql-connection
id = mydlr
host = db.XXXXX.com
username = XXXXX
password = XXXXX
database = test
max-connections = 4
and,
# SQLBOX SETUP
group = sqlbox
# id corresponds to id in group = mysql-connection.
# this is analogous to id in group = dlr-db
id = mydlr
# smsbox-id indicates the box where SQL-injected messages appear to be
coming from
smsbox-id = sqlbox2
# bearerbox host to connect to
bearerbox-host = "localhost"
# smsbox port to be listening on
smsbox-port = 13013
##smsbox-port-ssl = false
# sql-log-table is the table used to log all sent messages
sql-log-table = sent_sms
# sql-insert-table is the table that is monitored for new messages to
send
sql-insert-table = send_sms
# global sender: If no sender is specified in sql-insert-table then
this
# value is used.
global-sender = 06121
# log-file =
log-file = "/var/log/kannel/sqlbox.log"
# log-level = 10
# ssl-client-certkey-file = ""
# ssl-server-cert-file = ""
# ssl-server-key-file = ""
# ssl-trusted-ca-file = ""
Any help with this would be much appreciated, thanks!
Stuart