MySQL problem

[Miloš Lesák]

KD> On Tue, 16 Mar 2004, Miloš Lesák wrote:
>> [root na milos tmp]# gcc `mysql_config --libs` `mysql_config --cflags` sql_auth.c -o sql_auth
>> sql_auth.c: In function `main':
>> sql_auth.c:25: warning: assignment makes pointer from integer without a cast
>> /tmp/ccghJOIS.o(.text+0x34): In function `main':
>> : undefined reference to `mysql_connect'
>> collect2: ld returned 1 exit status
KD> Mate ve zdrojaku #include <mysql.h> ?
KD> V nem je mysql_connect definovano jako neco jineho, co v knihovne uz je.

KD>                              Karel Dudasek


Cast kodu sql_auth.c aj s pouzitim mysql_connect:
-------------------------------------------
#include <string.h>
#include <stdio.h>
//#include <mysql/mysql.h>
#include <mysql.h>
#include <time.h>

#define SERVER "localhost"
#define SERVER_LOGIN "user"
#define SERVER_PASS "pass"

int check_time( char *accessString );
int auth_ok( MYSQL *srvr, char *login, char *pass );

main()
{
 MYSQL auth_server, *retv=NULL;
 char *login, *pass, buff[256];

 retv = mysql_connect( &auth_server, SERVER, SERVER_LOGIN, SERVER_PASS );
 mysql_select_db( &auth_server, "databaza" );
 setbuf( stdout, NULL );

 while( fgets( buff, sizeof(buff), stdin ) )
  {
   login = strtok( buff, " \n" );
   pass = strtok( NULL, " \n" );

   if( auth_ok( &auth_server, login, pass ) )
    puts("OK");
   else
    puts("ERR");
  }
 mysql_close( &auth_server );
}
--------------------------------------------
naozaj si uz s tym neviem rady

cely vypis kompilacie:

[root na milos tmp]# gcc `mysql_config --libs` `mysql_config --cflags` sql_auth.c -o sql_auth
sql_auth.c: In function `main':
sql_auth.c:25: warning: assignment makes pointer from integer without a cast
/tmp/ccS8yUof.o(.text+0x34): In function `main':
: undefined reference to `mysql_connect'
collect2: ld returned 1 exit status

[root na milos tmp]# mysql_config --help
Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
        --cflags         [-I/usr/local/mysql/include/mysql]
   --include     [-I/usr/local/mysql/include/mysql]
        --libs           [-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm]
        --libs_r         [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lpthread -lz -lcrypt -lnsl -lm -lpthread]
        --socket         [/tmp/mysql.sock]
        --port           [3306]
        --version        [4.0.18]
   --libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lpthread -lz -lcrypt -lnsl -lm -lpthread -lrt]

[root na milos tmp]# ls -la /usr/local/mysql/include/mysql/
total 292
drwxr-xr-x    2 root     mysql        4096 Mar 15 15:30 .
drwxr-xr-x    3 root     mysql        4096 Mar 15 15:30 ..
-rw-r--r--    1 root     mysql        3864 Mar 15 15:30 chardefs.h
-rw-r--r--    1 root     mysql        2266 Mar 15 15:30 errmsg.h
-rw-r--r--    1 root     mysql        9273 Mar 15 15:30 history.h
-rw-r--r--    1 root     mysql        3449 Mar 15 15:30 keymaps.h
-rw-r--r--    1 root     mysql        6140 Mar 15 15:30 m_ctype.h
-rw-r--r--    1 root     mysql        7802 Mar 15 15:30 m_string.h
-rw-r--r--    1 root     mysql        1858 Mar 15 15:30 my_alloc.h
-rw-r--r--    1 root     mysql       23692 Mar 15 15:30 my_config.h
-rw-r--r--    1 root     mysql        3369 Mar 15 15:30 my_dbug.h
-rw-r--r--    1 root     mysql        3509 Mar 15 15:30 my_dir.h
-rw-r--r--    1 root     mysql        2485 Mar 15 15:30 my_getopt.h
-rw-r--r--    1 root     mysql       35650 Mar 15 15:30 my_global.h
-rw-r--r--    1 root     mysql        1503 Mar 15 15:30 my_list.h
-rw-r--r--    1 root     mysql        3588 Mar 15 15:30 my_net.h
-rw-r--r--    1 root     mysql        1129 Mar 15 15:30 my_no_pthread.h
-rw-r--r--    1 root     mysql       24434 Mar 15 15:30 my_pthread.h
-rw-r--r--    1 root     mysql        1784 Mar 15 15:30 my_semaphore.h
-rw-r--r--    1 root     mysql        9142 Mar 15 15:30 mysql_com.h
-rw-r--r--    1 root     mysql        9006 Mar 15 15:30 mysqld_error.h
-rw-r--r--    1 root     mysql        1158 Mar 15 15:30 mysql_embed.h
-rw-r--r--    1 root     mysql       15334 Mar 15 15:30 mysql.h
-rw-r--r--    1 root     mysql         832 Mar 15 15:30 mysql_version.h
-rw-r--r--    1 root     mysql       31657 Mar 15 15:30 my_sys.h
-rw-r--r--    1 root     mysql        5828 Mar 15 15:30 raid.h
-rw-r--r--    1 root     mysql       24199 Mar 15 15:30 readline.h
-rw-r--r--    1 root     mysql        1055 Mar 15 15:30 sslopt-case.h
-rw-r--r--    1 root     mysql        1877 Mar 15 15:30 sslopt-longopts.h
-rw-r--r--    1 root     mysql         970 Mar 15 15:30 sslopt-vars.h
-rw-r--r--    1 root     mysql        2736 Mar 15 15:30 tilde.h

[root na milos tmp]# ls -la /usr/local/mysql/lib/mysql/
total 1092
drwxr-xr-x    2 root     root         4096 Mar 16 10:30 .
drwxr-xr-x    3 root     root         4096 Mar 15 15:30 ..
-rw-r--r--    1 root     root        11694 Mar 15 15:30 libdbug.a
-rw-r--r--    1 root     root        32706 Mar 15 15:30 libheap.a
-rw-r--r--    1 root     root        13536 Mar 15 15:30 libmerge.a
-rw-r--r--    1 root     root       256294 Mar 15 15:30 libmyisam.a
-rw-r--r--    1 root     root        23642 Mar 15 15:30 libmyisammrg.a
-rw-r--r--    1 root     root       213458 Mar 15 15:30 libmysqlclient.a
-rwxr-xr-x    1 root     root          868 Mar 15 15:30 libmysqlclient.la
lrwxrwxrwx    1 root     root           24 Mar 16 10:15 libmysqlclient.so -> libmysqlclient.so.12.0.0
lrwxrwxrwx    1 root     root           24 Mar 16 10:15 libmysqlclient.so.12 -> libmysqlclient.so.12.0.0
-rwxr-xr-x    1 root     root       159240 Mar 15 15:30 libmysqlclient.so.12.0.0
-rw-r--r--    1 root     root        20662 Mar 15 15:30 libmystrings.a
-rw-r--r--    1 root     root       233004 Mar 15 15:30 libmysys.a
-rw-r--r--    1 root     root        96468 Mar 15 15:30 libnisam.a
-rw-r--r--    1 root     root         5432 Mar 15 15:30 libvio.a



-- 
S pozdravom,
 Miloš                            mailto:lesak na uvn.sk