RE: ERROR: Group 'mysql-connection' may not contain field 'mysql-username'

I scp'd the config (only) from a working redhat 9 installation to this new
EL4 build.

Bearerbox -- /etc/kannel/kannel.conf.test connects fine there.

Built cvs-20051021, (with no .configure options) config with 'dlr-storage =
internal' does exactly the same, so agree it seems nothing to do with mysql
port..

Has some other configuration value changed?

smsc config and log attached.

~

# SMSC SMPP
group = smsc
smsc = smpp
smsc-id = "xxx"
allowed-smsc-id = "xxx"
host = smpp.xxx.com
port = 2345
transceiver-mode = yes
#receive-port = 2347
smsc-username = "xxx"
smsc-password = "xxx"
system-type = "xxx"
#service-type =
interface-version = 33
our-host = xxx.xxx.xx.xxx
enquire-link-interval = 60
max-pending-submits = 10
reconnect-delay = 10
#source-addr-ton = 1
#source-addr-npi = 1
source-addr-autodetect = yes
dest-addr-ton = 1
dest-addr-npi = 1
#msg-id-type = 0
#alt-charset =
connection-timeout = 300
wait-ack = 60
#wait-ack-expire = 0x00 

~

2005-10-22 10:43:22 [7840] [0] INFO: Debug_lvl = -1, log_file = <none>,
log_lvl = 0
2005-10-22 10:43:22 [7840] [0] DEBUG: Loading include file
`/etc/kannel/modems.conf' (on line 17 of file ./kannel.conf.test).
2005-10-22 10:43:22 [7840] [0] INFO: DLR using storage type: internal
2005-10-22 10:43:22 [7840] [0] DEBUG: Kannel bearerbox version
`cvs-20051021'.
Build `Oct 22 2005 09:51:38', compiler `3.4.4 20050721 (Red Hat 3.4.4-2)'.
System Linux, release 2.6.9-22.EL.smp, version #1 SMP Sat Oct 8 19:11:43 CDT
2005, machine i686.
Hostname test.test.com, IP xxx.xxx.xxx.xxx.
Libxml version 2.6.16.
Using OpenSSL 0.9.7a Feb 19 2003.
Using native malloc.

2005-10-22 10:43:22 [7840] [0] INFO: Added logfile `/tmp/kannel.log' with
level `0'.
2005-10-22 10:43:22 [7840] [0] INFO: Started access logfile
`/tmp/kannel.access'.
2005-10-22 10:43:22 [7840] [0] INFO: HTTP: Opening server at port 13000.
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 1
(gwlib/fdset.c:poller)
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 2
(gwlib/http.c:server_thread)
2005-10-22 10:43:22 [7840] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps
to pid 7840.
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 3
(gw/bb_http.c:httpadmin_run)
2005-10-22 10:43:22 [7840] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [0] DEBUG: starting smsbox connection module
2005-10-22 10:43:22 [7840] [0] INFO: BOXC: 'smsbox-max-pending' not set,
using default (100).
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 4
(gw/bb_boxc.c:sms_to_smsboxes)
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 5
(gw/bb_boxc.c:smsboxc_run)
2005-10-22 10:43:22 [7840] [0] INFO: DLR rerouting for smsc id <xxx>
disabled.
2005-10-22 10:43:22 [7840] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [4] DEBUG: Thread 4
(gw/bb_boxc.c:sms_to_smsboxes) maps to pid 7840.
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 6
(gw/smsc/smsc_smpp.c:io_thread)
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 7
(gw/bb_smscconn.c:sms_router)
2005-10-22 10:43:22 [7840] [0] DEBUG: starting UDP sender/receiver module
2005-10-22 10:43:22 [7840] [0] INFO: Adding interface *
2005-10-22 10:43:22 [7840] [0] DEBUG: udpc_create: Bound to UDP
<0.0.0.0:9200>
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 8
(gw/bb_udp.c:udp_receiver)
2005-10-22 10:43:22 [7840] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 9
(gw/bb_udp.c:udp_sender)
2005-10-22 10:43:22 [7840] [7] DEBUG: sms_router: time to sleep
2005-10-22 10:43:22 [7840] [0] DEBUG: udpc_create: Bound to UDP
<0.0.0.0:9201>
2005-10-22 10:43:22 [7840] [6] DEBUG: Thread 6
(gw/smsc/smsc_smpp.c:io_thread) maps to pid 7840.
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 10
(gw/bb_udp.c:udp_receiver)
2005-10-22 10:43:22 [7840] [8] DEBUG: Thread 8 (gw/bb_udp.c:udp_receiver)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 11
(gw/bb_udp.c:udp_sender)
2005-10-22 10:43:22 [7840] [0] DEBUG: starting wapbox connection module
2005-10-22 10:43:22 [7840] [0] ERROR: Missing wapbox-port variable, cannot
start WAP
2005-10-22 10:43:22 [7840] [0] DEBUG: starting WDP router
2005-10-22 10:43:22 [7840] [11] DEBUG: Thread 11 (gw/bb_udp.c:udp_sender)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [0] DEBUG: Started thread 12
(gw/bearerbox.c:wdp_router)
2005-10-22 10:43:22 [7840] [0] INFO:
----------------------------------------
2005-10-22 10:43:22 [7840] [0] INFO: Kannel bearerbox II version
cvs-20051021 starting
2005-10-22 10:43:22 [7840] [0] INFO: MAIN: Start-up done, entering mainloop
2005-10-22 10:43:22 [7840] [10] DEBUG: Thread 10 (gw/bb_udp.c:udp_receiver)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [7] DEBUG: sms_router: gwlist_len = 0
2005-10-22 10:43:22 [7840] [9] DEBUG: Thread 9 (gw/bb_udp.c:udp_sender) maps
to pid 7840.
2005-10-22 10:43:22 [7840] [12] DEBUG: Thread 12 (gw/bearerbox.c:wdp_router)
maps to pid 7840.
2005-10-22 10:43:22 [7840] [12] DEBUG: udp_die: removing producers from
udp-lists
2005-10-22 10:43:22 [7840] [12] DEBUG: Thread 12 (gw/bearerbox.c:wdp_router)
terminates.
2005-10-22 10:43:22 [7840] [6] ERROR: bind to local port 0 failed
2005-10-22 10:43:22 [7840] [6] ERROR: System error 99: Cannot assign
requested address
2005-10-22 10:43:22 [7840] [6] ERROR: error connecting to server
`smpp.xxx.com' at port `2345'
2005-10-22 10:43:22 [7840] [6] ERROR: SMPP[xxx]: Couldn't connect to server.
2005-10-22 10:43:22 [7840] [6] ERROR: SMPP[xxx]: Couldn't connect to SMS
center (retrying in 10 seconds).
2005-10-22 10:43:23 [7840] [0] WARNING: Killing signal or HTTP admin command
received, shutting down...
2005-10-22 10:43:23 [7840] [0] DEBUG: Shutting down Kannel...
2005-10-22 10:43:23 [7840] [0] DEBUG: shutting down smsc
2005-10-22 10:43:23 [7840] [0] DEBUG: Shutting down SMSCConn
SMPP:smpp.xxx.com:2345/2345:test:287763 (slow)
2005-10-22 10:43:23 [7840] [6] DEBUG: Thread 6
(gw/smsc/smsc_smpp.c:io_thread) terminates.
2005-10-22 10:43:23 [7840] [0] DEBUG: SMSCConn
SMPP:smpp.xxx.com:2345/2345:test:287763 shut down.
2005-10-22 10:43:23 [7840] [0] DEBUG: shutting down udp
2005-10-22 10:43:23 [7840] [8] DEBUG: Thread 8 (gw/bb_udp.c:udp_receiver)
terminates.
2005-10-22 10:43:23 [7840] [10] DEBUG: Thread 10 (gw/bb_udp.c:udp_receiver)
terminates.
2005-10-22 10:43:23 [7840] [9] DEBUG: Thread 9 (gw/bb_udp.c:udp_sender)
terminates.
2005-10-22 10:43:23 [7840] [11] DEBUG: Thread 11 (gw/bb_udp.c:udp_sender)
terminates.
2005-10-22 10:43:24 [7840] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router)
terminates.
2005-10-22 10:43:24 [7840] [4] DEBUG: Thread 4
(gw/bb_boxc.c:sms_to_smsboxes) terminates.
2005-10-22 10:43:24 [7840] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run)
terminates.
2005-10-22 10:43:24 [7840] [0] INFO: All flow threads have died, killing
core
2005-10-22 10:43:24 [7840] [0] DEBUG: Waiting for 2
(gwlib/http.c:server_thread) to terminate
2005-10-22 10:43:24 [7840] [3] DEBUG: HTTP: No clients with requests,
quitting.
2005-10-22 10:43:24 [7840] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run)
terminates.
2005-10-22 10:43:24 [7840] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread)
terminates.
2005-10-22 10:43:24 [7840] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller)
terminates.
2005-10-22 10:43:24 [7840] [0] INFO: Total WDP messages: received 0, sent 0
2005-10-22 10:43:24 [7840] [0] INFO: Total SMS messages: received 0, sent 0
2005-10-22 10:43:24 [7840] [0] DEBUG: Immutable octet strings: 338.


-----Original Message-----
From: Stipe Tolj [mailto:[email protected]]
Sent: 21 October 2005 15:59
To: Mike Harris
Cc: [email protected]
Subject: Re: ERROR: Group 'mysql-connection' may not contain field
'mysql-username'

Mike Harris wrote:

> Correct, --prefix=/usr/local/mysql
> 
> [root@test support-files]# mysql_config --include 
> -I/usr/local/mysql/include [root@test support-files]#

ok, I have to investigate how mysql-5.x does it's layout, will do this and
commit more detection logic to the autoconf configure process.

> Do I have to now specify 'port = 3306' in config somewhere?
> I'm getting a 'bind to local port 0 failed' error now;
> 
> 2005-10-21 07:56:48 [6863] [0] INFO: Kannel bearerbox II version 
> cvs-20051010 starting
> 2005-10-21 07:56:48 [6863] [0] INFO: MAIN: Start-up done, entering 
> mainloop
> 2005-10-21 07:56:48 [6863] [7] DEBUG: Thread 7
> (gw/bb_smscconn.c:sms_router) maps to pid 6863.
> 2005-10-21 07:56:48 [6863] [7] DEBUG: sms_router: time to sleep
> 2005-10-21 07:56:48 [6863] [7] DEBUG: sms_router: gwlist_len = 0
> 2005-10-21 07:56:48 [6863] [6] DEBUG: Thread 6
> (gw/smsc/smsc_smpp.c:io_thread) maps to pid 6863.
> 2005-10-21 07:56:49 [6863] [6] ERROR: bind to local port 0 failed
> 2005-10-21 07:56:49 [6863] [6] ERROR: System error 99: Cannot assign 
> requested address
> 2005-10-21 07:56:49 [6863] [6] ERROR: error connecting to server 
> `smpp.server' at port `8000'
> 2005-10-21 07:56:49 [6863] [6] ERROR: SMPP[Server]: Couldn't connect 
> to server.
> 2005-10-21 07:56:49 [6863] [6] ERROR: SMPP[Server]: Couldn't connect 
> to SMS center (retrying in 10 seconds).
> 2005-10-21 07:56:50 [6863] [0] WARNING: Killing signal or HTTP admin 
> command received, shutting down...
> 2005-10-21 07:56:50 [6863] [0] DEBUG: Shutting down Kannel...

hmm, this is not related to the 'mysql-connection' group in the config.

The port within mysql-connection specifies the _remote_ server port to
connect to.

But reviewing the call logic, the DBPool connection that is trying to open a
connection to the mysql server via mysql_open_conn() has still a conf->port
== 0, hence this may be the reason.

Ok, I get the following for a mysql-connection group with _no_ port config:

2005-10-21 16:56:53 [26674] [0] INFO: Debug_lvl = -1, log_file = <none>,
log_lvl = 0
2005-10-21 16:56:53 [26674] [0] DEBUG: Loading include file `dlr-mysql.conf'
(on line 119 of file smskannel.conf).
2005-10-21 16:56:53 [26674] [0] ERROR: MYSQL: can not connect to database!
2005-10-21 16:56:53 [26674] [0] ERROR: MYSQL: Access denied for user
'foo'@'kannel' (using password: YES)
2005-10-21 16:56:53 [26674] [0] PANIC: DLR: MySQL: database pool has no
connections!
2005-10-21 16:56:53 [26674] [0] PANIC: 
../src/cvs/gateway/gw/bearerbox(gw_panic+0xa3) [0x80b59af]
2005-10-21 16:56:53 [26674] [0] PANIC: 
../src/cvs/gateway/gw/bearerbox(dlr_init_mysql+0x32f) [0x805d83b]
2005-10-21 16:56:53 [26674] [0] PANIC: 
../src/cvs/gateway/gw/bearerbox(dlr_init+0x84) [0x805bc28]
2005-10-21 16:56:53 [26674] [0] PANIC: 
../src/cvs/gateway/gw/bearerbox(main+0xec) [0x8052548]
2005-10-21 16:56:53 [26674] [0] PANIC: 
/lib/tls/libc.so.6(__libc_start_main+0xd3) [0x67ae23]
2005-10-21 16:56:53 [26674] [0] PANIC: ../src/cvs/gateway/gw/bearerbox
[0x8052091]

hence it's not related to that config diretive.

BTW, the ERROR happends within the SMPP reeiver thread, so I do assume that
you miss-configured the smsc section specifying the SMPP connection.

Can you forward please how that section looks like in the config.

Stipe

mailto:stolj_{at}_wapme-group.de
-------------------------------------------------------------------
Wapme Systems AG

Vogelsanger Weg 80
40470 Düsseldorf, NRW, Germany

phone: +49.211.74845.0
fax: +49.211.74845.299

mailto:info_{at}_wapme-systems.de
http://www.wapme-systems.de/
-------------------------------------------------------------------