List:MySQL++« Previous MessageNext Message »
From:PS Date:October 29 2005 10:30am
Subject:error: Client does not support authentication...
View as plain text  
Hello everybody,

I installed the latest mysql++ 2.0.6 and got errors when running apps:

error: Client does not support authentication protocol requested by 
server; consider upgrading MySQL client

basicly, my app is called code.exe, here's ldd code.exe:


%ldd code.exe
code.exe:
         libboost_regex.so => /usr/local/lib/libboost_regex.so (0x180a5000)
         libboost_date_time.so => /usr/local/lib/libboost_date_time.so 
(0x18177000)
         libboost_filesystem.so => /usr/local/lib/libboost_filesystem.so 
(0x18202000)
         libmysqlpp.so.2 => /usr/local/lib/libmysqlpp.so.2 (0x18236000)
         libmysqlclient.so.14 => 
/usr/local/lib/mysql/libmysqlclient.so.14 (0x18291000)
         libm.so.2 => /usr/lib/libm.so.2 (0x182ed000)
         libc_r.so.4 => /usr/lib/libc_r.so.4 (0x1830b000)
         libicuuc.so.34 => /usr/local/lib/libicuuc.so.34 (0x183da000)
         libicui18n.so.34 => /usr/local/lib/libicui18n.so.34 (0x184f5000)
         libz.so.2 => /usr/lib/libz.so.2 (0x18607000)
         libcrypt.so.2 => /usr/lib/libcrypt.so.2 (0x18618000)
         libicudata.so.34 => /usr/local/lib/libicudata.so.34 (0x18633000)
%ldd `which mysql`
/usr/local/bin/mysql:
         libreadline.so.5 => /usr/local/lib/libreadline.so.5 (0x1807b000)
         libncurses.so.5 => /usr/lib/libncurses.so.5 (0x180aa000)
         libmysqlclient.so.14 => 
/usr/local/lib/mysql/libmysqlclient.so.14 (0x180f8000)
         libcrypt.so.2 => /usr/lib/libcrypt.so.2 (0x18154000)
         libm.so.2 => /usr/lib/libm.so.2 (0x1816f000)
         libz.so.2 => /usr/lib/libz.so.2 (0x1818d000)
         libc.so.4 => /usr/lib/libc.so.4 (0x1819e000)
%

you may see that my app is linked to the same libmysqlclient.so as mysql 
command line client, also, I can compile this program without linking it 
to libmysqlclient - it just didn't make any difference if I link it to 
this lib. What am I doing wrong?

I'm usig 4.1.14 mysql db on freebsd 4.11. installed mysqlpp as
./configure --enable-thread-check
make
make install

(There was problem with makemake.sh which requires bash, but I did this 
commands manually and mysqlpp was installed ok)

then I compile my app like this:

g++34 -pthread -Wall -D_NDEBUG -D_POSIX_THREAD_PROCESS_SHARED -o 
code.exe code.cpp src/date_validator.cpp -lboost_regex -lboost_date_time 
-lboost_filesystem -lfcgi -L /usr/local/lib -I /usr/local/include/mysql/ 
-lmysqlpp -L /usr/local/lib/mysql/ -lmysqlclient

if I ommit "-L /usr/local/lib/mysql/ -lmysqlclient" part then it still 
compiles well and runs with the same problem.


Thanks
Thread
error: Client does not support authentication...PS29 Oct
  • Re: error: Client does not support authentication...Chris Frey31 Oct