Correct, --prefix=/usr/local/mysql [EMAIL PROTECTED] support-files]# mysql_config --include -I/usr/local/mysql/include [EMAIL PROTECTED] support-files]#
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... tia Mike -----Original Message----- From: Stipe Tolj [mailto:[EMAIL PROTECTED] Sent: 21 October 2005 04:13 To: Mike Harris Cc: [email protected] Subject: Re: ERROR: Group 'mysql-connection' may not contain field 'mysql-username' Mike Harris wrote: > I have just downloaded the latest stable release and have some issues > compiling it. BTW, we advice to use the current CVS HEAD which is a 1.4.1-rc stable, a lot of this have been fixed since 1.4.0 stable. (including the mysql vs kannel list_foobar() naming clash) > > ./configure --prefix=/usr/local \ > --disable-wap \ > --enable-start-stop-daemon \ > --disable-ssl \ > --with-mysql \ > --with-mysql-dir=/usr/local/mysql \ > --with-dlr=mysql > > When I run ./configure I get; > > Configuring DB support ... > checking whether to compile with MySQL support... searching checking > for mysql_config... /usr/local/sbin/mysql_config checking mysql > version... 5.0.13-rc checking mysql reentrant libs... > -L/usr/local/mysql/lib -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm > -lpthread checking for mysql_init in -lmysqlclient_r... yes checking > mysql includes... -I/usr/local/mysql/include checking for > mysql/mysql.h... no checking for mysql/mysql_version.h... no checking > whether to compile with MySQL support... yes > > So it appears to not find mysql/mysql.h - not surprising its in > /usr/local/Mysql/include.. > So make depend fails with; > > # make depend > for dir in gw gw/smsc gwlib test utils wmlscript checks wap radius; do \ > gcc -D_REENTRANT=1 -I. -Igw -D_XOPEN_SOURCE=600 -D_BSD_SOURCE > -I/usr/include/libxml2 -I/usr/local/mysql/include -MM $dir/*.c | sed > "s:^[^ ]:$dir/&:"; done > .depend > gw/dlr_mysql.c:74:25: mysql/mysql.h: No such file or directory which means the behaviour of mysql-4.x to mysql-5.x changed in the way the include header file layout is set while installation. Which --prefix path did you use while compiling mysql? was it --prefix=/usr/local/mysql? What is the output of 'mysql_config --include'? Since configure depends on those value when the mysql_config binary is found. If mysql-5.x does not prefix the header directory with an additional 'mysql' dir, then we need to change this to reflect latest mysql layout behaviour. > If I hardcode all of the $loc to /usr/local/Mysql - make then does > this; > > make > gcc -D_REENTRANT=1 -I. -Igw -D_XOPEN_SOURCE=600 -D_BSD_SOURCE > -I/usr/include/libxml2 -I/usr/local/mysql/include -o gw/dlr_mysql.o -c > gw/dlr_mysql.c In file included from > /usr/local/mysql/include/mysql.h:62, > from gw/dlr_mysql.c:74: > /usr/local/mysql/include/my_list.h:32: error: conflicting types for > 'list_delete' > ./gwlib/list.h:179: error: previous declaration of 'list_delete' was > here > /usr/local/mysql/include/my_list.h:32: error: conflicting types for > 'list_delete' > ./gwlib/list.h:179: error: previous declaration of 'list_delete' was > here > make: *** [gw/dlr_mysql.o] Error 1 > > I then find this; > > "This issue has been fixed a while ago by renaming all list_* > functions in gwlib to gwlist_*. Please use CVS HEAD. It's fairly stable" > > So I download CVS HEAD, same problem with mysql/mysql.h so hardcode > paths and it builds!! ok, see above, please answer and we'll go on further with this. Obviously it would be better to file a bug report for this, with minor priority, simply to keep track of it... http://bugs.kannel.org/ > But when I try to run it; > > /usr/local/sbin/bearerbox -- /etc/kannel/kannel.conf.cvs 2005-10-20 > 17:47:42 [3936] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = > 0 2005-10-20 17:47:42 [3936] [0] DEBUG: Loading include file > `/etc/kannel/modems.conf' (on line 17 of file /etc/kannel/kannel.conf.cvs). > 2005-10-20 17:47:42 [3936] [0] ERROR: Group 'mysql-connection' may not > contain field 'mysql-username'. > 2005-10-20 17:47:42 [3936] [0] ERROR: Error found on line 164 of file > `/etc/kannel/kannel.conf.cvs'. > 2005-10-20 17:47:42 [3936] [0] PANIC: Couldn't read configuration from > `/etc/kannel/kannel.conf.cvs'. > 2005-10-20 17:47:42 [3936] [0] PANIC: > /usr/local/sbin/bearerbox(gw_panic+0x174) [0x80cee60] 2005-10-20 > 17:47:42 [3936] [0] PANIC: /usr/local/sbin/bearerbox(main+0x17d) > [0x8058b78] > 2005-10-20 17:47:42 [3936] [0] PANIC: > /lib/tls/libc.so.6(__libc_start_main+0xd3) [0x4ade23] 2005-10-20 > 17:47:42 [3936] [0] PANIC: /usr/local/sbin/bearerbox [0x8057e59] > > # > > # MySQL connection > group = mysql-connection > id = mydlr > host = localhost > mysql-username = xxx > mysql-password = xxx > database = xxx > max-connections = 1 > > # MySQL config > group = dlr-db > id = mydlr > table = dlr > field-smsc = smsc > field-timestamp = ts > field-destination = destination > field-service = service > field-url = url > field-mask = mask > field-status = status > field-source = source > field-boxc-id = boxc > > What am I doing wrong here? Help! nothing... there has been a compatibility breaking change since 1.4.0 and cvs, see ChangeLog entry: 2005-09-21 Stipe Tolj <[EMAIL PROTECTED]> Feature request #254 in order to set port values for mysql and pgsql database connection types. Used as DLR storage space. * gwlib/cfg.def: added config directive 'port' to 'myqsl|pgsql-connection' groups, changed mysql config directive names to 'username' and 'password' to reflect the harmonization to others. (COMPATIBILITY BREAKER) * gwlib/dbpool.[ch]: added port value to mysql and pgsql confs, also renamed internal pgsql variables to be more harmonized. * gwlib/dbpool_[pgsql|myqsl].c: added port variable support and changed internal variable naming. * gw/dlr_[sdb|oracle].c: source code layout fixes. No logic change. * gw/dlr_[pgsql|mysql].c: added port variable support and minor source layout changes. hence use 'username' and 'password' as config directive. 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/ -------------------------------------------------------------------
