09-07-2009
Authentication errror on Solaris 10 for MySQl 5.1 version.
Hi,
I have build one application which uses static reference of MySQL 4.0 old version library and dynamic reference of new version as MySQL 5.1 version library.
On Solaris
When I try to connect to MySQL server 5.1 using MySQL 5.1 library in application it always uses the old version library instead 5.1 library and I get the following error:
DataAccess: MySQL error: Client does not support authentication protocol requested by server; consider upgrading MySQL client; errno = 1251
On solaris 10 mahcine I have only installed MySQL 5.1. When I try to connect to MySQL server using mysql prompt it connects properly.
Also I have written one sample application which only uses the MySQL 5.1 library dynamic reference and trying to connect to Server 5.1. it connects successfully.
I wonder why in my Application it uses the old even I given or linked the new 5.1 version library.
Is there any compile time linking problem on Solaris or run time problem which does not allows like this mechanism or other else need to do to solve it?
Any help on this highly appreciated?
7 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am getting this message in the log file.
Apr 29 15:32:02 router ppp: Warning: Label COPYRIGHT rejected -direct connection: Configuration label not found
This repeats every so often, the link is up however...Any ideas why i am getting this. Its freebsd 6.1 and pppoE.
Frank (1 Reply)
Discussion started by: frankkahle
1 Replies
2. Shell Programming and Scripting
Hi,
I installed Perl 5.8.9 on Linux machine and when I complied Perl script.It give error like :-
perl: relocation error: /opt/ActivePerl-5.8/lib/auto/IO/IO.so: undefined symbol: Perl_newXS_flags
Please provide solution to this issue. Thanks in advance. (1 Reply)
Discussion started by: allways4u21
1 Replies
3. Solaris
I am trying to connect to MySQL installed on windows from Solaris machine.
While doing this getting error as:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client; errno = 1251"
I have installed mysql-5.1.34-solaris10-sparc.tar.gz on... (1 Reply)
Discussion started by: amit_27
1 Replies
4. Web Development
I just listened to a fairly dry MySQL/Sun webinar about performance tuning MySQL clusters.
One of the highlights of the presentation was the fact the MySQL team strongly advocated the use of this configuration tool:
Configurator for MySQL Cluster - version 2.9
Check it out! (0 Replies)
Discussion started by: Neo
0 Replies
5. Solaris
hi i need to upgrade my solaris mysql version.. can u guide me the upgrade steps..
my current version is
4.0.31-log
i need to upgrade to 5.0
..
thanks..
---------- Post updated at 12:04 PM ---------- Previous update was at 11:28 AM ----------
my solaris version is 10..
----------... (2 Replies)
Discussion started by: senkerth
2 Replies
6. Solaris
Hi Guys,
Could you please tell me how to read this Solaris version:-
Solaris 8 HW 5/03 s28s_hw2wos_06a SPARC
Thanks. (3 Replies)
Discussion started by: manalisharmabe
3 Replies
7. Solaris
Hi;
How can I disable or remove SNMPv1/2c authentication. I would like to use SNMP version 3 authentication.
bash-3.00# uname -a
SunOS SOL9229 5.10 Generic_142910-17 i86pc i386 i86pc
bash-3.00# (1 Reply)
Discussion started by: gc_sw
1 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::mysql
DBIx::Class::Storage::DBI::mysql(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::mysql(3)
NAME
DBIx::Class::Storage::DBI::mysql - Storage::DBI class implementing MySQL specifics
SYNOPSIS
Storage::DBI autodetects the underlying MySQL database, and re-blesses the $storage object into this class.
my $schema = MyApp::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } );
DESCRIPTION
This class implements MySQL specific bits of DBIx::Class::Storage::DBI, like AutoIncrement column support and savepoints. Also it augments
the SQL maker to support the MySQL-specific "STRAIGHT_JOIN" join type, which you can use by specifying "join_type => 'straight'" in the
relationship attributes
It also provides a one-stop on-connect macro "set_strict_mode" which sets session variables such that MySQL behaves more predictably as far
as the SQL standard is concerned.
STORAGE OPTIONS
set_strict_mode
Enables session-wide strict options upon connecting. Equivalent to:
->connect ( ... , {
on_connect_do => [
q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|,
q|SET SQL_AUTO_IS_NULL = 0|,
]
});
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2014-01-22 DBIx::Class::Storage::DBI::mysql(3)