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/
-------------------------------------------------------------------