What is the output of ldd test?
Tavaris Thomas wrote:
>
> To whom it may concern:
>
> I am running MySQL ver 3.22.20a
> My compiler is egcs 1.1.2 on a SUN Ultra 1 with Solaris 2.6
> I am trying to write CGIs to access MySQL via a web browser. (written in C)
>
> I compiled my source code with the following command (all on one line)
>
> gcc -I/usr/local/mysql/include/mysql -L/usr/local/mysql/lib/mysql -o test
> test2.c -lmysqlclient -lsocket -lm
>
> this compiles without errors however when I try to run "test"
> I get the following error:
>
> # ./test
> ld.so.1: ./test: fatal: libmysqlclient.so.6: open failed: No such file or
> directory
> Killed
>
> I know my error has to do with the mysqlclient library but can't solve it.
> The ld.so.1 file exists in the /etc/lib directory
>
> Incidentally here is my /usr/local/mysql/lib/mysql directory.
> *******Here are the contents**********
> # ls -al
> total 1280
> drwxr-xr-x 2 root other 512 Apr 15 13:05 .
> drwxr-xr-x 3 root other 512 Apr 6 11:06 ..
> -rw-r--r-- 1 root other 14068 Apr 6 11:06 libdbug.a
> -rw-r--r-- 1 root other 29224 Apr 6 11:06 libheap.a
> -rw-r--r-- 1 root other 13128 Apr 6 11:06 libmerge.a
> -rw-r--r-- 1 root other 142796 Apr 6 11:06 libmysqlclient.a
> -rw-r--r-- 1 root other 559 Apr 6 11:06 libmysqlclient.la
> lrwxrwxrwx 1 root other 23 Apr 6 11:06 libmysqlclient.so ->
> libmysqlclient.so.6.0.0
> lrwxrwxrwx 1 root other 23 Apr 15 13:05 libmysqlclient.so.6 ->
> libmysqlclient.so.6.0.0
> -rw-r--r-- 1 root other 106456 Apr 6 11:06
> libmysqlclient.so.6.0.0
> -rw-r--r-- 1 root other 27116 Apr 6 11:06 libmystrings.a
> -rw-r--r-- 1 root other 160892 Apr 6 11:06 libmysys.a
> -rw-r--r-- 1 root other 106904 Apr 6 11:06 libnisam.a
>
> *******Here is my code********
>
> >#include "mysql.h"
> >#include <stdlib.h>
> >#include "/usr/local/etc/httpd/cgi-bin/NETREG/getcgi.c"
> >#include <stdio.h>
> >#include <string.h>
> >
> >
> >void main() {
> > char **cgivars ;
> > int i ;
> > MYSQL mysql;
> >
> > /** First, get the CGI variables into a list of strings **/
> > cgivars= getcgivars() ;
> >
> > /** Print the CGI response header, required for all HTML output. **/
> > /** Note the extra \n, to send the blank line. **/
> > printf("Content-type: text/html\n\n") ;
> >
> > printf("<html>\n") ;
> > printf("<head><title>test Results</title></head>\n")
> ;
> > printf("<body>\n") ;
> >
> > mysql_init(&mysql);
> >
> > if (!mysql_real_connect(&mysql, "localhost", "tavaris",
> >"thomas","network_registration",0,NULL,0))
> > { printf("I didn't connect to the database!\n");}
> > else { printf("I did connect to the database!\n");}
> >
> > printf("</body>\n") ;
> > printf("</html>\n") ;
> >
> > mysql_close(&mysql);
> >}
>
> Can anyone help?????
>
> -Much thanks in advance.
> If you need anymore info or can help please reply to
>
> -Tavaris
> tavaris@stripped
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread1922@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)