Current CVS version of sqlbox now does read and use the port parameter in group = mysql-connection.
Rene Kluwen Chimit -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roman Yeryomin Sent: dinsdag 30 mei 2006 8:46 To: Stipe Tolj Cc: [email protected] Subject: Re: sqlbox with remote mysql database On Saturday 27 May 2006 15:03, Stipe Tolj wrote:: > Roman Yeryomin wrote: > > On Tuesday 16 May 2006 20:35, Roman Yeryomin wrote:: > >>I've compiled latest cvs head with mysql support but seems that sqlbox is > >>working only with localhost database. > >>When I try to use remote mysql database I get this error: > >> > >>2006-05-16 20:12:29 [27344] [0] ERROR: MYSQL: Can't connect to MySQL > >> server on 'x.x.x.x' (111) > >>2006-05-16 20:12:29 [27344] [0] ERROR: MYSQL: can not connect to > >> database! 2006-05-16 20:12:29 [27344] [0] ERROR: MYSQL: Can't connect to > >> MySQL server on 'x.x.x.x' (111) > >>2006-05-16 20:12:29 [27344] [0] PANIC: SQLBOX: MySQL: database pool has > >> no connections! > >>2006-05-16 20:12:29 [27344] [0] PANIC: sqlbox(gw_panic+0x175) [0x806c43a] > >>2006-05-16 20:12:29 [27344] [0] PANIC: sqlbox(sqlbox_init_mysql+0x405) > >>[0x8053f70] > >>2006-05-16 20:12:29 [27344] [0] PANIC: sqlbox(sqlbox_init_sql+0x18) > >>[0x8052798] > >>2006-05-16 20:12:29 [27344] [0] PANIC: sqlbox [0x804fd3c] > >>2006-05-16 20:12:29 [27344] [0] PANIC: sqlbox(main+0x140) [0x804ff23] > >>2006-05-16 20:12:29 [27344] [0] PANIC: /lib/tls/libc.so.6 > >>(__libc_start_main+0xd0) [0xb79f8e40] > >>2006-05-16 20:12:29 [27344] [0] PANIC: sqlbox [0x804ecc1] > >> > >>Connecting to that host with telnet or mysql client I have no problems. > >>Does anyone know where could be the problem? > > > > seems like conf->port is not working in gwlib/dbpool_mysql.c -- I > > hardcoded 3306 and now I can connect to remote database > > Is it a bug or I've misconfigured something? > > can you forward us the config with blanked-out password of course? > > Stipe my mysql-connection group config (or you need full config?): group = mysql-connection id = mydlr #host = localhost host = x.x.x.x #port = 3306 username=kannel password=yyyy database = kannel max-connections = 10 Roman
