gtk+ make 오류

Respected Sir,
Some engineering students of SMIT undergoing project work in our organization faced some problems while
working in RedHat8 Linux environment.

They are trying to develop an application program using GLADE as the front-end tool and MYSQL 3.23 as
the back-end in the platform RED HAT 8.1. They are using C for coding.
When they are trying to run the C code in the ?callbacks.c? file and try to compile it from GLADE to connect
MYSQL using the <make> command the following error msgs are displayed:-

[EMAIL PROTECTED] project1]# make
cd . && /bin/sh /root/Projects/project1/missing --run autoheader
WARNING: Using auxiliary files such as `acconfig.h', `config.h.bot'
WARNING: and `config.h.top', to define templates for `config.h.in'
WARNING: is deprecated and discouraged.

WARNING: Using the third argument of `AC_DEFINE' and
WARNING: `AC_DEFINE_UNQUOTED' allows to define a template without
WARNING: `acconfig.h':

WARNING: AC_DEFINE([NEED_MAIN], 1,
WARNING: [Define if a function `main' is needed.])
WARNING: More sophisticated templates can also be produced, see the
WARNING: documentation.
autoheader: `config.h.in' is unchanged
touch ./config.h.in
cd . && /bin/sh ./config.status config.h
config.status: creating config.h
config.status: config.h is unchanged
make all-recursive
make[1]: Entering directory `/root/Projects/project1'
Making all in src
make[2]: Entering directory `/root/Projects/project1/src'
source='callbacks.c' object='callbacks.o' libtool=no \
depfile='.deps/callbacks.Po' tmpdepfile='.deps/callbacks.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -DPACKAGE_DATA_DIR=\""/usr/local/share"\"
-DPACKAGE_LOCALE_DIR=\""/usr/local/share/locale"\" -I/usr/include/gtk-2.0 -I/usr/lib/gtk-2.0/include
-I/usr/include/atk-1.0 -I/usr/include/pango-1.0 -I/usr/include/Xft2 -I/usr/include/freetype2
-I/usr/X11R6/include -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include -g -O2 -Wall -c `test -f 'callbacks.c' ||
echo './'`callbacks.c
callbacks.c: In function `on_button1_clicked':
callbacks.c:48: warning: `return' with a value, in function returning void
callbacks.c:51: warning: `return' with a value, in function returning void
callbacks.c:59: warning: `return' with a value, in function returning void
callbacks.c:62:2: warning: no newline at end of file
gcc -g -O2 -Wall -o project1 main.o support.o interface.o callbacks.o -lgtk-x11-2.0 -lgdk-x11-2.0 -latk-1.0
-lgdk_pixbuf-2.0 -lm -lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -ldl -lglib-2.0
callbacks.o: In function `on_button1_clicked':
/root/Projects/project1/src/callbacks.c:35: undefined reference to `mysql_init'
/root/Projects/project1/src/callbacks.c:36: undefined reference to `mysql_real_connect'
/root/Projects/project1/src/callbacks.c:50: undefined reference to `mysql_query'
/root/Projects/project1/src/callbacks.c:54: undefined reference to `mysql_store_result'
/root/Projects/project1/src/callbacks.c:56: undefined reference to `mysql_free_result'
/root/Projects/project1/src/callbacks.c:58: undefined reference to `mysql_close'
collect2: ld returned 1 exit status
make[2]: *** [project1] Error 1
make[2]: Leaving directory `/root/Projects/project1/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/root/Projects/project1'
make: *** [all] Error 2

But when they are compiling the same code from outside of GLADE using the following command < gcc
conn.c -L /usr/lib/mysql -lmysqlclient -lz>, there is no compilation error.

The following is the code of the file ?conn.c? which they have used.

/*Here is an example C program taken from the mySQL book. named conn.c*/
#include "/usr/include/mysql/mysql.h"
#include "/usr/include/stdio.h"
#include "/usr/include/assert.h"
#include "/usr/include/stdlib.h"
#include "/usr/include/string.h"

char sql_command[2048];

int main()
{
MYSQL_RES *result;
MYSQL *connection, mysql;
int state;
// printf("we did it...hopefully\n");
sprintf(sql_command,"select * from stud");
// connect to the mySQL database at localhost
mysql_init(&mysql);
connection = mysql_real_connect(&mysql,
NULL, /*IP, server name, or
localhost, or just NULL
for localhost*/
NULL, /*user name*/
NULL, /*password*/
"payal", /*db name*/
0, /*port number*/
NULL, /*Unix socket name:
an addition of 3.23?*/
0); /*client_flag*/
// check for a connection error
if (connection ==NULL) return 0;
printf("con\n");
state = mysql_query(connection, sql_command);
if (state!=0) return 0;
// must call mysql_store_result() before we can issue any other
// query calls
result = mysql_store_result(connection);
// free the result set
mysql_free_result(result);
// close the connection
mysql_close(connection);
return 0;
}

So, for successful compilation of the code from GLADE, do they require to make certain changes in the
?make? file?
It would be very much kind of you if you could have suggest something to solve the problem in any way.

Warm regards,

On Monday 24 Feb 2003 13:35, santanu sinha wrote:
> guys,
> help me out on this.
> Dr. Susanta Sen of our instiute fwd. me this message.
> Send any help avialable to me.
> -santanu

Hi ,
Is miss Payal Kundu works there because the problem seems to very similar to
Payal Kundu's Problem.

First thing is that that #include <mysql/mysql.h> is needed & also have to
edit the make files so the generated program get linked with Mysql API.

The easier way is use GNOME DB which is wrapper code on the MySQL API to
access it from GTK.

Anirban Biswas.