Hi,
You either need to link the mysqlclient library statically, or set up the
LD_LIBRARY_PATH environment variable to the location of the library.
Regards
Quentin
> -----Original Message-----
> From: muttaqin [SMTP:muttaqin@stripped]
> Sent: Friday, August 25, 2000 3:19 PM
> To: mysql@stripped
> Subject: Error in loading shared libraries: libmysqlclient.so.9:
>
> Please Help me, I have problem while compiling example program.
>
> Error while running :
> ./e1.cgi: error in loading shared libraries: libmysqlclient.so.9: cannot
> open sy....
>
> Statement of compile
> =================================================
> cgi++ -o e1.cc e1.cgi++
> g++ -o e1.cgi e1.cc -lcgi++ -L/var/tmp/mysql/usr/lib -lmysqlclient
> ================================================
>
> Script File: e1.cgi++
> =================================================
> SQL_DB_DRIVER(mysql)
> SQL_ON_ERROR(sql_error)
> SQL_DECL_DBH(dbh)
>
> void sql_error()
> {
> HTML_START
> Database error: $mysql_error(&dbh)$
> HTML_END
> exit(1);
> }
>
> MAIN_START
> SQL_CONNECT(localhost, member, mysql, muttaqin)
>
> SQL_CURSOR_DO("select * from anggota")
> HTML_START
> <tr><td> $sql_row[0]$ </td>
> <td>$sql_row[1]$ </td>
> <td>$sql_row[2]$ </td>
> <td>$sql_row[3]$ </td>
> <td>$sql_row[4]$ </td>
> </tr>
> HTML_END
> SQL_CURSOR_DONE
>
> HTML_START
> </table>
> HTML_END
>
> MAIN_END
> ======================================================
>
> Lib Directory
> ======================================================
> <shell> cd /var/tmp/mysql/usr/lib
> <shell> ls -al
> total 197
> drwxr-xr-x 3 root root 1024 Aug 14 16:36 .
> drwxr-xr-x 10 root root 1024 Aug 14 16:36 ..
> lrwxrwxrwx 1 root root 23 Aug 14 16:36 libmysqlclient.so
> -> lib0
> lrwxrwxrwx 1 root root 23 Aug 14 16:36 libmysqlclient.so.9
> -> l0
> -rwxr-xr-x 1 root root 197384 Aug 14 16:23
> libmysqlclient.so.9.0.0
> drwxr-xr-x 2 root root 1024 Aug 14 16:36 mysql
>
> =====================================================================
>
> thank's
> Muttaqin@stripped
>
