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.X.com >>> username = X >>> password = X >>> 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 >>> >>> >>> >>> >> >> > > >
Re: SQLBox Mysql Connection
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.X.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.X.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.X.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.X.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) [0x2b7ff54a] 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: 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.X.com username = X password = X 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
Re: SQLBox Mysql Connection
Hi, I think I've worked out what was wrong, although I was setting the host for the DB, the sqlbox was always trying to connect to `localhost`. I set up mysql on the same machine and it can now connect. Although, it has led me to a different problem- the sqlbox will create the tables but will not write incoming or outgoing traffic into them. There are no sql errors in the logs. Has anyone experienced a similar problem? Stuart - Original Message - From: "Rene Kluwen" <[EMAIL PROTECTED]> To: "Stuart" <[EMAIL PROTECTED]> Cc: 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.X.com username = X password = X 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
RE: SQLBox Mysql Connection
Dear Stuart, You have to specify smsbox-id in the smsbox group to the same of that you specified in sqlbox group. As you used smsbox-id = sqlbox2 in the sqlbox group. Please add it to the smsbox group as well. Good luck! Rayson Lee InnoAge Hong Kong Limited -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Sent: Thursday, March 02, 2006 1:23 AM To: users@kannel.org Subject: Re: SQLBox Mysql Connection Hi, I think I've worked out what was wrong, although I was setting the host for the DB, the sqlbox was always trying to connect to `localhost`. I set up mysql on the same machine and it can now connect. Although, it has led me to a different problem- the sqlbox will create the tables but will not write incoming or outgoing traffic into them. There are no sql errors in the logs. Has anyone experienced a similar problem? Stuart - Original Message - From: "Rene Kluwen" <[EMAIL PROTECTED]> To: "Stuart" <[EMAIL PROTECTED]> Cc: 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.X.com >>>> username = X >>>> password = X >>>> 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 >>>> >>>> >>>> >>>> >>> >>> >> >> >> > >