DBI with MySQL client library compile on Solaris


 
Thread Tools Search this Thread
Operating Systems Solaris DBI with MySQL client library compile on Solaris
# 1  
Old 01-28-2010
DBI with MySQL client library compile on Solaris

how dow you complie perl module DBI with mysql from /usr/local/mysql/bin

keeps going to mysql client for /usr/sfw/bin

is it the LD_PATH ???...Smilie

error is

Code:
# perl login.cgi
DBI connect('customers;mysql_socket=/tmp/mysql.sock:localhost','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at login.cgi line 17
Client does not support authentication protocol requested by server; consider upgrading MySQL client at login.cgi line 17.

# 2  
Old 01-29-2010
If you don't need the MySQL version (4.x) packaged with Solaris, then deinstall it. In order to do so, you have to deinstall the SIP express router first, then the mysql packages:

Code:
pkgrm SUNWserweb
pkgrm SUNWseru
pkgrm SUNWmysqlt
pkgrm SUNWmysqlu
pkgrm SUNWmysqlr

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

MySQL 5.5.28 compile on AIX 7.1

Hi, I have an AIX 7.1 lpar with cmake, gmp, libmpc, mpfr on it and a gcc 4.6.2 compiler that was made with the no-dependency flag. I am trying to complile MySql5.5.28 from Oracle. Cmake runs fine. Then when I run make, I get the following: <nyissz> Scanning dependencies of target strings ... (12 Replies)
Discussion started by: Ismeret Tenger
12 Replies

2. Red Hat

I want to install/compile php with mysql.

I have removed php-5.1.6-27.el5 from our system. Because I installed it without mysql before. How can I install php together with mysql. # rpm -qa | grep mysql* libdbi-dbd-mysql-0.8.1a-1.2.2 mysql-5.0.77-4.el5_4.2 mysql-server-5.0.77-4.el5_4.2 mysql-connector-odbc-3.51.26r1127-1.el5 ##... (5 Replies)
Discussion started by: getrue
5 Replies

3. Solaris

Compile PHP 5.3.6 with MySql on Sun Blade 1500 Solaris 10

Hello, I'm trying to compile PHP 5.3.6 with Apache2 and MySql 5.5.12. I hit a problem that I can't seem to resolve by myself and I could not find a solution on the web. It looks like Apache and MySql installed ok, I can start/stop them with no problem. When I try to compile PHP the... (4 Replies)
Discussion started by: pn8830
4 Replies

4. Solaris

Compile SSCEP (Simple SCEP client for Unix) on Solaris 10 box

Hi folks I am trying to compile SSCEP (Simple SCEP client for Unix) on Solaris 10 box. SSCEP - Simple SCEP client for Unix The errror is "ld: fatal: Symbol referencing errors. No output written to" $ make gcc -Wall -O -lcrypto -o sscep sscep.o init.o net.o sceputils.o pkcs7.o ias.o... (2 Replies)
Discussion started by: slashdotweenie
2 Replies

5. Shell Programming and Scripting

connect to MySQL from Perl using DBI

Hi, I want to connect perl with the mysql to select and so on but the connection don't work code #!/usr/bin/perl BEGIN { # PERL MODULES WE WILL BE USING use DBI; $dbh = DBI->connect('DBI:mysql:C:\Program Files\MySQL\MySQL Server 5.0\data\db1','','pass') or die $DBI::errstr;} #... (1 Reply)
Discussion started by: eng_shimaa
1 Replies

6. Shell Programming and Scripting

How to use Perl's DBI connect when no mysql passwd is set?

I am getting the error "Can't call method "prepare" on an undefined value at..." with the following code: <code>my %dbh; my $dbh = DBI->connect("DBI:mysql:Customer_Data", $username, $password ) or die "Database connection... (1 Reply)
Discussion started by: vincaStar
1 Replies

7. Solaris

Errors trying to compile PHP for use with MySQL on Solaris 10

have installed and am using the GNU based tools from the Sunfreeware site to compile PHP. I already have Apache, MySQL, and Oracle compiled and working properly. Below is my configure string for my PHP build: ./configure --prefix=/usr/local/php5 \... (2 Replies)
Discussion started by: sunsysadm2003
2 Replies

8. Programming

client/server compile question

Hi, I have 2 files-->server.c and client.c My server.c takes local ip as saying: *.sin_addr.s_addr=INADDR_ANY; client.c is in the same machine.It has a line like: *.sin_addr.s_addr=inet_addr(argv); I don't know how to compile.I tried ./client 127.0.0.1 It used port 7777 in both client... (2 Replies)
Discussion started by: mlhazan
2 Replies

9. Solaris

error: compile 64 bit mysql on Solaris 10

I'm trying to build 64 bit mysql-5.0.37 on Solaris 10. CFLAGS="-O3" CXX='gcc -m64 -mcpu=v9' CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure -disable-shared --prefix=/usr/local/mysql --datadir=/home1/mysql_data --with-mysqld-user=mysql ... (0 Replies)
Discussion started by: csross
0 Replies

10. Programming

How compile a library on solaris(like dll in windows)

Hi all, how do i compile a c program into a library on solaris Thanks in advance Zing (3 Replies)
Discussion started by: zing
3 Replies
Login or Register to Ask a Question