Re: dlr-mysql problem
Hi james/alejandro/ Dear All Thanks a lot for the help the configure line in the original configure is /*MYSQL_LIBS="$($MYSQL_CONFIG --libs)"*/ and after changing to the MYSQL_LIBS="$($MYSQL_CONFIG --libs | sed 's/\x27//g')" and changing the mysql version from the default mysql-3.23.58-1 which comes with Red Hat to 4.0.17-0 and the its working fine. On Tue, 2004-11-09 at 19:53, James Coleman wrote: > On Tue, Nov 09, 2004 at 05:11:18PM +0530, shyam kumar wrote: > > > >Hi James/all > >Thank you for the suggestions/help > >There's little progress from the past error. > >i configured using the parameters given but it is telling unable to > >find MyAQL client libraries > >but i had installed mysqlclient software a server software and the > >mysql is working fine, > >may be the problem is with -lmysqlclient since in the /usr/lib/mysql > >we have all > >libmysqlclient.x.x... x=a,so > >and i searched the system for any mysqlclient but no use > >i tried to change the mysql_config file with libmysqlclient for > >mysqlclient but no use > >as i am novice to the script language used, so finding it difficult to > >make it. > >Hope to get the solution. > >thanks in advance > >below is the error code generated. > >[bash]$ ./configure --disable-ssl --with-mysql > >--with-mysql-dir=/usr/lib/mysql > > that configure line looks incorrect > > --with-mysql-dir=/usr not --with-mysql-dir=/usr/lib/mysql > > --with-mysql-dir is set to where lib/mysql/ is > > if I do this I get a configure error too: > > ./configure --disable-ssl --with-mysql --with-mysql-dir=/usr/lib/mysql > > > Configuring DB support ... > checking whether to compile with MySQL support... searching > checking for mysql_config... /usr/bin/mysql_config > checking mysql version... 3.23.58 > checking mysql libs... -L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl > -lm > checking for mysql_init in -lmysqlclient... no > configure: error: Unable to find MySQL client libraries > > > > if I do this configure with unedited configure I get same problem: > > ./configure --disable-ssl --with-mysql --with-mysql-dir=/usr > > because I haven't fixed the configure script > > > hmm. work is impinging on this reply > probably by this stage someone else has answered but ... in case not ... > I'm going to expand but the solution is a simple one really - a one line > change to configure script in my case. Hopefully the same for others. > > > > gateway-cvshead/$ grep -Hni MYSQL_LIBS configure > configure:4496:MYSQL_LIBS="" > configure:4498:MYSQL_LIBS="$($MYSQL_CONFIG --libs_r)" > configure:4501:echo "$ac_t"" $MYSQL_LIBS " 1>&6 > configure:4509:LIBS="-lmysqlclient_r $MYSQL_LIBS $LIBS" > configure:4537: LIBS="$LIBS $MYSQL_LIBS" > configure:4540: MYSQL_LIBS="" > configure:4544:if test -z "$MYSQL_LIBS" ; then > configure:4545:MYSQL_LIBS="$($MYSQL_CONFIG --libs)" > configure:4548:echo "$ac_t"" $MYSQL_LIBS " 1>&6 > configure:4556:LIBS="-lmysqlclient $MYSQL_LIBS $LIBS" > configure:4584: LIBS="$LIBS $MYSQL_LIBS" > > gateway-cvshead/$ grep -Hni \$MYSQL_CONFIG configure > configure:4399: case "$MYSQL_CONFIG" in > configure:4401: ac_cv_path_MYSQL_CONFIG="$MYSQL_CONFIG" # Let the user > override the test with a path. > configure:4404: ac_cv_path_MYSQL_CONFIG="$MYSQL_CONFIG" # Let the user > override the test with a dos path. > configure:4422:if test -n "$MYSQL_CONFIG"; then > configure:4423: echo "$ac_t""$MYSQL_CONFIG" 1>&6 > configure:4428:if test "$MYSQL_CONFIG" = "no"; then > configure:4494:mysql_version=`$MYSQL_CONFIG --version` > configure:4497:if $MYSQL_CONFIG --libs_r &>/dev/null ; then > configure:4498:MYSQL_LIBS="$($MYSQL_CONFIG --libs_r)" > configure:4545:MYSQL_LIBS="$($MYSQL_CONFIG --libs)" > configure:4593:if $MYSQL_CONFIG --include &>/dev/null ; then > configure:4594:CFLAGS="$CFLAGS $($MYSQL_CONFIG --include)" > configure:4595:echo "$ac_t""$($MYSQL_CONFIG --include)" 1>&6 > configure:4597:CFLAGS="$CFLAGS $($MYSQL_CONFIG --cflags)" > configure:4598:echo "$ac_t""$($MYSQL_CONFIG --cflags)" 1>&6 > configure:5756:[EMAIL PROTECTED]@%$MYSQL_CONFIG%g > > each call to $MYSQL_CONFIG is a potential problem > > your configure is different to the lastest cvshead configure ... but perhaps > not by much > same principles apply > > we want to fix things somewhat like this > bash$ mysql_config --cflags |sed s/\'//g > -I/usr/include/mysql > > bash$ MYSQL_CONFIG=mysql_config > bash$ MYSQL_LIBS="$($MYSQL_CONFIG --libs |sed s/\'//g)" > bash$ echo $MYSQL_LIBS > -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm > > > cp configure configure.oldset_MYSQL_LIBS # or something > edit configure > configure:4498:MYSQL_LIBS="$($MYSQL_CONFIG --libs_r)" > configure:4545:MYSQL_LIBS="$($MYSQL_CONFIG --libs)" > > I just edited one line. Th
Re: dlr-mysql problem
On Tue, Nov 09, 2004 at 05:11:18PM +0530, shyam kumar wrote: > >Hi James/all >Thank you for the suggestions/help >There's little progress from the past error. >i configured using the parameters given but it is telling unable to >find MyAQL client libraries >but i had installed mysqlclient software a server software and the >mysql is working fine, >may be the problem is with -lmysqlclient since in the /usr/lib/mysql >we have all >libmysqlclient.x.x... x=a,so >and i searched the system for any mysqlclient but no use >i tried to change the mysql_config file with libmysqlclient for >mysqlclient but no use >as i am novice to the script language used, so finding it difficult to >make it. >Hope to get the solution. >thanks in advance >below is the error code generated. >[bash]$ ./configure --disable-ssl --with-mysql >--with-mysql-dir=/usr/lib/mysql that configure line looks incorrect --with-mysql-dir=/usr not --with-mysql-dir=/usr/lib/mysql --with-mysql-dir is set to where lib/mysql/ is if I do this I get a configure error too: ./configure --disable-ssl --with-mysql --with-mysql-dir=/usr/lib/mysql Configuring DB support ... checking whether to compile with MySQL support... searching checking for mysql_config... /usr/bin/mysql_config checking mysql version... 3.23.58 checking mysql libs... -L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm checking for mysql_init in -lmysqlclient... no configure: error: Unable to find MySQL client libraries if I do this configure with unedited configure I get same problem: ./configure --disable-ssl --with-mysql --with-mysql-dir=/usr because I haven't fixed the configure script hmm. work is impinging on this reply probably by this stage someone else has answered but ... in case not ... I'm going to expand but the solution is a simple one really - a one line change to configure script in my case. Hopefully the same for others. gateway-cvshead/$ grep -Hni MYSQL_LIBS configure configure:4496:MYSQL_LIBS="" configure:4498:MYSQL_LIBS="$($MYSQL_CONFIG --libs_r)" configure:4501:echo "$ac_t"" $MYSQL_LIBS " 1>&6 configure:4509:LIBS="-lmysqlclient_r $MYSQL_LIBS $LIBS" configure:4537: LIBS="$LIBS $MYSQL_LIBS" configure:4540: MYSQL_LIBS="" configure:4544:if test -z "$MYSQL_LIBS" ; then configure:4545:MYSQL_LIBS="$($MYSQL_CONFIG --libs)" configure:4548:echo "$ac_t"" $MYSQL_LIBS " 1>&6 configure:4556:LIBS="-lmysqlclient $MYSQL_LIBS $LIBS" configure:4584: LIBS="$LIBS $MYSQL_LIBS" gateway-cvshead/$ grep -Hni \$MYSQL_CONFIG configure configure:4399: case "$MYSQL_CONFIG" in configure:4401: ac_cv_path_MYSQL_CONFIG="$MYSQL_CONFIG" # Let the user override the test with a path. configure:4404: ac_cv_path_MYSQL_CONFIG="$MYSQL_CONFIG" # Let the user override the test with a dos path. configure:4422:if test -n "$MYSQL_CONFIG"; then configure:4423: echo "$ac_t""$MYSQL_CONFIG" 1>&6 configure:4428:if test "$MYSQL_CONFIG" = "no"; then configure:4494:mysql_version=`$MYSQL_CONFIG --version` configure:4497:if $MYSQL_CONFIG --libs_r &>/dev/null ; then configure:4498:MYSQL_LIBS="$($MYSQL_CONFIG --libs_r)" configure:4545:MYSQL_LIBS="$($MYSQL_CONFIG --libs)" configure:4593:if $MYSQL_CONFIG --include &>/dev/null ; then configure:4594:CFLAGS="$CFLAGS $($MYSQL_CONFIG --include)" configure:4595:echo "$ac_t""$($MYSQL_CONFIG --include)" 1>&6 configure:4597:CFLAGS="$CFLAGS $($MYSQL_CONFIG --cflags)" configure:4598:echo "$ac_t""$($MYSQL_CONFIG --cflags)" 1>&6 configure:5756:[EMAIL PROTECTED]@%$MYSQL_CONFIG%g each call to $MYSQL_CONFIG is a potential problem your configure is different to the lastest cvshead configure ... but perhaps not by much same principles apply we want to fix things somewhat like this bash$ mysql_config --cflags |sed s/\'//g -I/usr/include/mysql bash$ MYSQL_CONFIG=mysql_config bash$ MYSQL_LIBS="$($MYSQL_CONFIG --libs |sed s/\'//g)" bash$ echo $MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm cp configure configure.oldset_MYSQL_LIBS # or something edit configure configure:4498:MYSQL_LIBS="$($MYSQL_CONFIG --libs_r)" configure:4545:MYSQL_LIBS="$($MYSQL_CONFIG --libs)" I just edited one line. The --libs line. If I just change the --libs call to MYSQL_CONFIG in the configure script my configure is okay. bash$ ./configure --disable-ssl --with-mysql --with-mysql-dir=/usr Configuring DB support ... checking whether to compile with MySQL support... searching checking for mysql_config... /usr/bin/mysql_config checking mysql version... 3.23.58 checking mysql libs... -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm checking for mysql_init in -lmysqlclient... yes checking mysql includes... -I'/usr/include/mysql' checking for mysql/mysql.h... yes checking for mysql/mysql_version.h... yes checking whether to compile with MySQL supp
Re: dlr-mysql problem
Shyam, That's the (in)famous RedHat 9 bug :) Look on the list archive, there's a solution I've posted sometime ago for it. Basically, the single quotes on checking mysql libs... -L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl are the cause of the failure. A simple mod on the configure script will make it work for you (check the list archive). Regards, On Tue, 09 Nov 2004 17:11:18 +0530, shyam kumar <[EMAIL PROTECTED]> wrote: > Hi James/all > Thank you for the suggestions/help > > There's little progress from the past error. > i configured using the parameters given but it is telling unable to find > MyAQL client libraries > but i had installed mysqlclient software a server software and the mysql is > working fine, > may be the problem is with -lmysqlclient since in the /usr/lib/mysql we have > all > libmysqlclient.x.x... x=a,so > and i searched the system for any mysqlclient but no use > i tried to change the mysql_config file with libmysqlclient for mysqlclient > but no use > as i am novice to the script language used, so finding it difficult to make > it. > > Hope to get the solution. > thanks in advance > below is the error code generated. > > [bash]$ ./configure --disable-ssl --with-mysql > --with-mysql-dir=/usr/lib/mysql > loading cache ./config.cache > > Configuring for Kannel gateway version 1.3.2 ... > > Running system checks ... > checking host system type... i686-pc-linux-gnu > checking for gcc... (cached) gcc > > > > Configuring OpenSSL support ... > checking whether to compile with SSL support... disabled > > Configuring DB support ... > checking whether to compile with MySQL support... searching > checking for mysql_config... /usr/bin/mysql_config > checking mysql version... 3.23.58 > ./configure: line 1: MYSQL_CONFIG: command not found > ./configure: line 4454: /bin: is a directory > checking mysql libs... -L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl > -lm > checking for mysql_init in -lmysqlclient... no > configure: error: Unable to find MySQL client libraries > > > > > On Mon, 2004-11-08 at 21:26, James Coleman wrote: > What is your configure line ? ./configure --disable-ssl --with-mysql > --with-mysql-dlr=/usr this would be mine for kannel 1.3.2 though the > disabled could come have from the error in the config file the configure > options changed ... definately from 1.2.1 to 1.3.x not sure exactly > when if you do use --with-mysql --with-mysql-dlr=/usr then there is another > error in configure script ? causing it to be disabled? Hmmm. Everywhere > MYSQL_LIBS is set you could maybe echo it or force it to be the correct > value (get correct value from running mysql_config) mysql_config Usage: > /usr/bin/mysql_config [OPTIONS] Options: --cflags [-I'/usr/include/mysql'] > --libs [-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm] --socket > [/var/lib/mysql/mysql.sock] --port [3306] --version [3.23.58] e.g. > MYSQL_LIBS=/usr/include/mysql everywhere hacky :-7 check your configure > line first. James. > > -- > shyam kumar <[EMAIL PROTECTED]> > Tanla Solutions Ltd > > * This > e-mail and any files transmitted with it are for the sole use of the > intended recipient(s) and may contain confidential and > privileged information. If you are not the intended recipient, please > contact the sender by reply e-mail and destroy all copies of the original > message. Any unauthorized review, use, disclosure, dissemination, > forwarding, printing or copying of this email or any action taken in > reliance on this e-mail is strictly prohibited and may be > unlawful. * -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/
Re: dlr-mysql problem
Hi James/all Thank you for the suggestions/help There's little progress from the past error. i configured using the parameters given but it is telling unable to find MyAQL client libraries but i had installed mysqlclient software a server software and the mysql is working fine, may be the problem is with -lmysqlclient since in the /usr/lib/mysql we have all libmysqlclient.x.x... x=a,so and i searched the system for any mysqlclient but no use i tried to change the mysql_config file with libmysqlclient for mysqlclient but no use as i am novice to the script language used, so finding it difficult to make it. Hope to get the solution. thanks in advance below is the error code generated. [bash]$ ./configure --disable-ssl --with-mysql --with-mysql-dir=/usr/lib/mysql loading cache ./config.cache Configuring for Kannel gateway version 1.3.2 ... Running system checks ... checking host system type... i686-pc-linux-gnu checking for gcc... (cached) gcc Configuring OpenSSL support ... checking whether to compile with SSL support... disabled Configuring DB support ... checking whether to compile with MySQL support... searching checking for mysql_config... /usr/bin/mysql_config checking mysql version... 3.23.58 ./configure: line 1: MYSQL_CONFIG: command not found ./configure: line 4454: /bin: is a directory checking mysql libs... -L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm checking for mysql_init in -lmysqlclient... no configure: error: Unable to find MySQL client libraries On Mon, 2004-11-08 at 21:26, James Coleman wrote: What is your configure line ? ./configure --disable-ssl --with-mysql --with-mysql-dlr=/usr this would be mine for kannel 1.3.2 though the disabled could come have from the error in the config file the configure options changed ... definately from 1.2.1 to 1.3.x not sure exactly when if you do use --with-mysql --with-mysql-dlr=/usr then there is another error in configure script ? causing it to be disabled? Hmmm. Everywhere MYSQL_LIBS is set you could maybe echo it or force it to be the correct value (get correct value from running mysql_config) mysql_config Usage: /usr/bin/mysql_config [OPTIONS] Options: --cflags[-I'/usr/include/mysql'] --libs [-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm] --socket[/var/lib/mysql/mysql.sock] --port [3306] --version [3.23.58] e.g. MYSQL_LIBS=/usr/include/mysql everywhere hacky :-7 check your configure line first. James. -- shyam kumar <[EMAIL PROTECTED]> Tanla Solutions Ltd * This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. *
Re: dlr-mysql problem
What is your configure line ? ./configure --disable-ssl --with-mysql --with-mysql-dlr=/usr this would be mine for kannel 1.3.2 though the disabled could come have from the error in the config file the configure options changed ... definately from 1.2.1 to 1.3.x not sure exactly when if you do use --with-mysql --with-mysql-dlr=/usr then there is another error in configure script ? causing it to be disabled? Hmmm. Everywhere MYSQL_LIBS is set you could maybe echo it or force it to be the correct value (get correct value from running mysql_config) mysql_config Usage: /usr/bin/mysql_config [OPTIONS] Options: --cflags[-I'/usr/include/mysql'] --libs [-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm] --socket[/var/lib/mysql/mysql.sock] --port [3306] --version [3.23.58] e.g. MYSQL_LIBS=/usr/include/mysql everywhere hacky :-7 check your configure line first. James. On Mon, Nov 08, 2004 at 07:02:21PM +0530, shyam kumar wrote: > >Dear James/Dear All >Thanks a lot for the reply. >i made the change at line 4453 from >MYSQL_LIBS="$($MYSQL_CONFIG --libs)" >to >MYSQL_LIBS="$($MYSQL_CONFIG --libs | sed 's/\x27//g')" >to the configure file and configured, it showed these lines as > >.. >checking for openssl/ssl.h... (cached) yes >checking for openssl/err.h... (cached) yes >checking whether the OpenSSL library is multithread-enabled... yes >checking whether to compile with SSL support... yes >Configuring DB support ... >checking whether to compile with MySQL support... disabled >checking whether to compile with LibSDB support... disabled >checking whether to compile with SQLite support... disabled >checking whether to compile with Oracle support... disabled >checking whether to compile with PostgresSQL support... disabled > >. >but didn't get any better, the problem is same and the error is same, >may be, it is unable to compile the MySQL, and it is disabled >if the solution is that MySQL is Disabled, request to let me know how >to enable it. >Thanks in advance. >error after changing the line is: >2004-11-08 18:31:56 [5882] [0] INFO: Debug_lvl = -1, log_file = >, log_lvl = 0 >2004-11-08 18:31:56 [5882] [0] ERROR: Group 'dlr-mysql' may not >contain field 'field-url'. >2004-11-08 18:31:56 [5882] [0] ERROR: Error found on line 109 of file >`gw/testkannel.conf'. >2004-11-08 18:31:56 [5882] [0] PANIC: Couldn't read configuration from >`gw/testkannel.conf'. >2004-11-08 18:31:56 [5882] [0] PANIC: ./gw/bearerbox(gw_panic+0x175) >[0x80c8501] >2004-11-08 18:31:56 [5882] [0] PANIC: ./gw/bearerbox(main+0x171) >[0x805254d] >2004-11-08 18:31:56 [5882] [0] PANIC: >/lib/tls/libc.so.6(__libc_start_main+0xf8) [0xb722e748] >2004-11-08 18:31:57 [5882] [0] PANIC: ./gw/bearerbox(SSL_write+0x51) >[0x80515d9] >error before changing the line was: >2004-11-08 16:59:20 [4147] [0] INFO: Debug_lvl = -1, log_file = >, log_lvl = 0 >2004-11-08 16:59:20 [4147] [0] ERROR: Group 'dlr-mysql' may not >contain field 'field-url'. >2004-11-08 16:59:20 [4147] [0] ERROR: Error found on line 109 of file >`gw/testkannel.conf'. >2004-11-08 16:59:20 [4147] [0] PANIC: Couldn't read configuration from >`gw/testkannel.conf'. >2004-11-08 16:59:20 [4147] [0] PANIC: ./gw/bearerbox(gw_panic+0x175) >[0x80c8501] >2004-11-08 16:59:20 [4147] [0] PANIC: ./gw/bearerbox(main+0x171) >[0x805254d] >2004-11-08 16:59:20 [4147] [0] PANIC: >/lib/tls/libc.so.6(__libc_start_main+0xf8) [0xb722e748] >On Mon, 2004-11-08 at 17:38, James Coleman wrote: > > On Mon, Nov 08, 2004 at 04:07:13PM +0530, shyam kumar wrote: > > > >Dear James/Dear all > >did u got your problem resolved of the dlr connectivity to the > >mysql database, i am also facing the same problem and hope to get the > >answer from U, if your problem gets solved, by the way i am using the > >kannel 1.3.2 version and mysql 4.0.20. and the error i am getting is > > > > Yes, the problem is solved > > Alejandro found the problem and solution, it's in the list archives somewhere. > > The call to mysql_config from configure script doesn't handle quoted cflags > param okay. > > I found it. > > > So, what I did was to modify the configure script on line 4453: > > Before: > MYSQL_LIBS="$($MYSQL_CONFIG --libs)" > > After: > MYSQL_LIBS="$($MYSQL_CONFIG --libs | sed 's/\x27//g')" > > > Try that. I can't remember was there a patch :-7 > > Not exactly sure what kannel version that solution was for so the > line you find MYSQL_LIBS="$($MYSQL_CONFIG --libs)" at in the > configure file might be different? > > Hopefully that'll work okay for you. > > James. > > > > > -- > > shyam kumar <[EMAIL PROTECTED]> > > Tan
Re: dlr-mysql problem
Dear James/Dear All Thanks a lot for the reply. i made the change at line 4453 from MYSQL_LIBS="$($MYSQL_CONFIG --libs)" to MYSQL_LIBS="$($MYSQL_CONFIG --libs | sed 's/\x27//g')" to the configure file and configured, it showed these lines as .. checking for openssl/ssl.h... (cached) yes checking for openssl/err.h... (cached) yes checking whether the OpenSSL library is multithread-enabled... yes checking whether to compile with SSL support... yes Configuring DB support ... checking whether to compile with MySQL support... disabled checking whether to compile with LibSDB support... disabled checking whether to compile with SQLite support... disabled checking whether to compile with Oracle support... disabled checking whether to compile with PostgresSQL support... disabled . but didn't get any better, the problem is same and the error is same, may be, it is unable to compile the MySQL, and it is disabled if the solution is that MySQL is Disabled, request to let me know how to enable it. Thanks in advance. error after changing the line is: 2004-11-08 18:31:56 [5882] [0] INFO: Debug_lvl = -1, log_file = , log_lvl = 0 2004-11-08 18:31:56 [5882] [0] ERROR: Group 'dlr-mysql' may not contain field 'field-url'. 2004-11-08 18:31:56 [5882] [0] ERROR: Error found on line 109 of file `gw/testkannel.conf'. 2004-11-08 18:31:56 [5882] [0] PANIC: Couldn't read configuration from `gw/testkannel.conf'. 2004-11-08 18:31:56 [5882] [0] PANIC: ./gw/bearerbox(gw_panic+0x175) [0x80c8501] 2004-11-08 18:31:56 [5882] [0] PANIC: ./gw/bearerbox(main+0x171) [0x805254d] 2004-11-08 18:31:56 [5882] [0] PANIC: /lib/tls/libc.so.6(__libc_start_main+0xf8) [0xb722e748] 2004-11-08 18:31:57 [5882] [0] PANIC: ./gw/bearerbox(SSL_write+0x51) [0x80515d9] error before changing the line was: 2004-11-08 16:59:20 [4147] [0] INFO: Debug_lvl = -1, log_file = , log_lvl = 0 2004-11-08 16:59:20 [4147] [0] ERROR: Group 'dlr-mysql' may not contain field 'field-url'. 2004-11-08 16:59:20 [4147] [0] ERROR: Error found on line 109 of file `gw/testkannel.conf'. 2004-11-08 16:59:20 [4147] [0] PANIC: Couldn't read configuration from `gw/testkannel.conf'. 2004-11-08 16:59:20 [4147] [0] PANIC: ./gw/bearerbox(gw_panic+0x175) [0x80c8501] 2004-11-08 16:59:20 [4147] [0] PANIC: ./gw/bearerbox(main+0x171) [0x805254d] 2004-11-08 16:59:20 [4147] [0] PANIC: /lib/tls/libc.so.6(__libc_start_main+0xf8) [0xb722e748] On Mon, 2004-11-08 at 17:38, James Coleman wrote: On Mon, Nov 08, 2004 at 04:07:13PM +0530, shyam kumar wrote: > >Dear James/Dear all >did u got your problem resolved of the dlr connectivity to the >mysql database, i am also facing the same problem and hope to get the >answer from U, if your problem gets solved, by the way i am using the >kannel 1.3.2 version and mysql 4.0.20. and the error i am getting is > Yes, the problem is solved Alejandro found the problem and solution, it's in the list archives somewhere. The call to mysql_config from configure script doesn't handle quoted cflags param okay. I found it. So, what I did was to modify the configure script on line 4453: Before: MYSQL_LIBS="$($MYSQL_CONFIG --libs)" After: MYSQL_LIBS="$($MYSQL_CONFIG --libs | sed 's/\x27//g')" Try that. I can't remember was there a patch :-7 Not exactly sure what kannel version that solution was for so the line you find MYSQL_LIBS="$($MYSQL_CONFIG --libs)" at in the configure file might be different? Hopefully that'll work okay for you. James. -- shyam kumar <[EMAIL PROTECTED]> Tanla Solutions Ltd * This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. *
Re: dlr-mysql problem
On Mon, Nov 08, 2004 at 04:07:13PM +0530, shyam kumar wrote: > >Dear James/Dear all >did u got your problem resolved of the dlr connectivity to the >mysql database, i am also facing the same problem and hope to get the >answer from U, if your problem gets solved, by the way i am using the >kannel 1.3.2 version and mysql 4.0.20. and the error i am getting is > Yes, the problem is solved Alejandro found the problem and solution, it's in the list archives somewhere. The call to mysql_config from configure script doesn't handle quoted cflags param okay. I found it. So, what I did was to modify the configure script on line 4453: Before: MYSQL_LIBS="$($MYSQL_CONFIG --libs)" After: MYSQL_LIBS="$($MYSQL_CONFIG --libs | sed 's/\x27//g')" Try that. I can't remember was there a patch :-7 Not exactly sure what kannel version that solution was for so the line you find MYSQL_LIBS="$($MYSQL_CONFIG --libs)" at in the configure file might be different? Hopefully that'll work okay for you. James.
dlr-mysql problem
Dear James/Dear all did u got your problem resolved of the dlr connectivity to the mysql database, i am also facing the same problem and hope to get the answer from U, if your problem gets solved, by the way i am using the kannel 1.3.2 version and mysql 4.0.20. and the error i am getting is 2004-11-08 15:47:59 [4040] [0] INFO: Debug_lvl = -1, log_file = , log_lvl = 0 2004-11-08 15:47:59 [4040] [0] ERROR: Group 'dlr-mysql' may not contain field 'field-url'. 2004-11-08 15:47:59 [4040] [0] ERROR: Error found on line 109 of file `gw/testkannel.conf'. 2004-11-08 15:47:59 [4040] [0] PANIC: Couldn't read configuration from `gw/testkannel.conf'. 2004-11-08 15:47:59 [4040] [0] PANIC: ./gw/bearerbox(gw_panic+0x175) [0x80c8501] 2004-11-08 15:47:59 [4040] [0] PANIC: ./gw/bearerbox(main+0x171) [0x805254d] 2004-11-08 15:47:59 [4040] [0] PANIC: /lib/tls/libc.so.6(__libc_start_main+0xf8) [0xb722e748] 2004-11-08 15:47:59 [4040] [0] PANIC: ./gw/bearerbox(SSL_write+0x51) [0x80515d9] and the conf file parameters are group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar #status-password = foo #admin-deny-ip = "" #admin-allow-ip = "" #log-file = "/tmp/kannel.log" #log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" #unified-prefix = "+358,00358,0;+,00" access-log = "/tmp/access.log" store-file = "/tmp/kannel.store" #ssl-server-cert-file = "cert.pem" #ssl-server-key-file = "key.pem" #ssl-certkey-file = "mycertandprivkeyfile.pem" #dlr-storage = internal dlr-storage = mysql # DATABASE CONNECTION FOR DELIVERY RECEIPTS group = mysql-connection id = mydlr host = localhost mysql-username = mysql-password = x database = dlr group = dlr-mysql id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = ""> field-mask = mask field-status = status field-boxc-id = boxc Thanks in Advance with best regards -- shyam kumar <[EMAIL PROTECTED]> Tanla Solutions Ltd * This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. *
RE: dlr mysql problem [with sms-services]
In the devel-list there's a link to sqlbox. This box stores incoming and outgoing SMS messages in an SQL table. Rene Kluwen Chimit -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of R manoSent: zaterdag 16 oktober 2004 19:21To: [EMAIL PROTECTED]Subject: dlr mysql problem [with sms-services] Hi all ! I have a problem with the dlr storage. In fact when I use sendsms to send a sms, I can store a trace of it in my Mysql database, but when I send sms from other services it doesn't keep any trace of it in the database. What should I do to solve it ? Thanks in advance. Rmano Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Créez votre Yahoo! MailLe nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis. Téléchargez GRATUITEMENT ici !
dlr mysql problem [with sms-services]
Hi all ! I have a problem with the dlr storage. In fact when I use sendsms to send a sms, I can store a trace of it in my Mysql database, but when I send sms from other services it doesn't keep any trace of it in the database. What should I do to solve it ? Thanks in advance. Rmano Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Créez votre Yahoo! Mail Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis. Téléchargez GRATUITEMENT ici !
