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: => /usr/local/lib/ (0x180a5000) => /usr/local/lib/ 
(0x18177000) => /usr/local/lib/ 
(0x18202000) => /usr/local/lib/ (0x18236000) => 
/usr/local/lib/mysql/ (0x18291000) => /usr/lib/ (0x182ed000) => /usr/lib/ (0x1830b000) => /usr/local/lib/ (0x183da000) => /usr/local/lib/ (0x184f5000) => /usr/lib/ (0x18607000) => /usr/lib/ (0x18618000) => /usr/local/lib/ (0x18633000)
%ldd `which mysql`
/usr/local/bin/mysql: => /usr/local/lib/ (0x1807b000) => /usr/lib/ (0x180aa000) => 
/usr/local/lib/mysql/ (0x180f8000) => /usr/lib/ (0x18154000) => /usr/lib/ (0x1816f000) => /usr/lib/ (0x1818d000) => /usr/lib/ (0x1819e000)

you may see that my app is linked to the same 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 install

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

then I compile my app like this:

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.

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