mohammed.mustafa | 8 May 15:13 2008

Error while connecting to data base.

Hi,

  I am new to perl and database and trying to connect to the data base,
but getting the below error.

And perl version I am using is 5.8.5.

[wipcafe <at> testbrix Test]$ perl data.pl

DBI connect('database=mustafa;host=10.207.36.108','root',...) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at data.pl line 7

can't connect: Client does not support authentication protocol requested
by server; consider upgrading MySQL client at data.pl line 7.

And please find the code here........

 use DBI;

  # $user = "mohammed";

  # $pass = "mohammed";

  #my $dbh = DBI->connect
("dbi:mysql:uitest;host=10.207.36.119",$user,$pass) or

  my $dbh =
DBI->connect("DBI:mysql:database=mustafa;host=10.207.36.108","root",
"wipcafe")or
(Continue reading)

Patrick Galbraith | 8 May 15:41 2008

Re: Error while connecting to data base.

Mohammed,

What version of MySQL are you running?

regards,

Patrick

mohammed.mustafa <at> wipro.com wrote:

>Hi,
>
>  I am new to perl and database and trying to connect to the data base,
>but getting the below error.
>
>And perl version I am using is 5.8.5.
>
> 
>
>[wipcafe <at> testbrix Test]$ perl data.pl
>
>DBI connect('database=mustafa;host=10.207.36.108','root',...) failed:
>Client does not support authentication protocol requested by server;
>consider upgrading MySQL client at data.pl line 7
>
>can't connect: Client does not support authentication protocol requested
>by server; consider upgrading MySQL client at data.pl line 7.
>
> 
>
(Continue reading)

mohammed.mustafa | 8 May 15:44 2008

RE: Error while connecting to data base.

Hi Patrick,

   I am using the same version like 5.8.6 which I downloaded from
cpan.org.
Thanks for your kind attention.

Thanks,
Mustafa

-----Original Message-----
From: Patrick Galbraith [mailto:patg <at> grazr.com] 
Sent: Thursday, May 08, 2008 7:12 PM
To: Mohammed Mustafa (WT01 - Testing Services)
Cc: perl <at> lists.mysql.com
Subject: Re: Error while connecting to data base.

Mohammed,

What version of MySQL are you running?

regards,

Patrick

mohammed.mustafa <at> wipro.com wrote:

>Hi,
>
>  I am new to perl and database and trying to connect to the data base,
>but getting the below error.
(Continue reading)

Patrick Galbraith | 8 May 16:01 2008

Re: Error while connecting to data base.

mohammed.mustafa <at> wipro.com wrote:

>Hi Patrick,
> 
>   I am using the same version like 5.8.6 which I downloaded from
>cpan.org.
>Thanks for your kind attention.
>  
>
Mohammed,

What I mean is the database server  - what version of MySQL are you using ?

If you do:

mysql -u mohammed -p mohammed -h 10.207.36.119 uitest

then:

mysql>select version();

What do you get?

Also do this:

perl -e 'use DBI; print "$DBI::VERSION\n"'

perl -e 'use DBD::mysql; print "$DBD::mysql::VERSION\n"'

Also:
(Continue reading)

mohammed.mustafa | 8 May 16:15 2008

RE: Error while connecting to data base.

Hi Patrick,
    Please find the requested message as below, and help me how to
proceed.

      [wipcafe <at> testbrix Test]$ mysql -u mohammed -p mohammed -h
0.207.36.119 uitest 

mysql  Ver 14.12 Distrib 5.0.22, for unknown-linux-gnu (x86_64) using
readline 5.0
Copyright (C) 2002 MySQL AB

 [wipcafe <at> testbrix Test]$ select version();
-bash: syntax error near unexpected token `('

[wipcafe <at> testbrix Test]$ perl -e 'use DBI; print "$DBI::VERSION\n"'
1.604

[wipcafe <at> testbrix Test]$ perl -e 'use DBD::mysql; print
"$DBD::mysql::VERSION\n"'
2.9004

[wipcafe <at> testbrix Test]$ locate libmysqlclient
warning: locate: could not open database: /var/lib/slocate/slocate.db:
No such file or directory
warning: You need to run the 'updatedb' command (as root) to create the
database.
Please have a look at /etc/updatedb.conf to enable the daily cron job.

Regards,
Mustafa
(Continue reading)

mohammed.mustafa | 9 May 14:03 2008

Communication between Perl and VBSript for DataBase

Hi,

  We need your help for writing a tool driver with perl script, which
will be disclosed as below.

1)       We have a driver which is written in VB script , which
communicates with Database (Mysql) and retrive the data.

2)       We are developing one more driver in perl, which has to
communicate with the VBScript driver mentioned above.

3)       Perl driver will communicated with a target m/c like
Linux/unix/Solaris and do some operations & return a value.

My main query is 

1) How can we communicate the data between perl script driver ( Linux or
Windows m/c ) to VBScript driver so that I can transact the data between
these two.

Thanks for your kind help.

Regards,

Mustafa

Please do not print this email unless it is absolutely necessary. 

The information contained in this electronic message and any attachments to this message are intended for
the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged
(Continue reading)

John Scoles | 9 May 14:28 2008

Re: Communication between Perl and VBSript for DataBase

In which context is the VBScript  written, .NET, ASP, VB ??

Anyway you are not giving us (me anyway) enough detail to give you any 
guidance.

Is you VB code really a driver (direct calls to a DB API) or is it just 
a VB program that connects to the MySQL DB with ODBC or alike?

cheers
John Scoles

mohammed.mustafa <at> wipro.com wrote:
> Hi,
>
>  
>
>   We need your help for writing a tool driver with perl script, which
> will be disclosed as below.
>
> 1)       We have a driver which is written in VB script , which
> communicates with Database (Mysql) and retrive the data.
>
> 2)       We are developing one more driver in perl, which has to
> communicate with the VBScript driver mentioned above.
>
> 3)       Perl driver will communicated with a target m/c like
> Linux/unix/Solaris and do some operations & return a value.
>
>  
>
(Continue reading)

mohammed.mustafa | 9 May 15:57 2008

RE: Communication between Perl and VBSript for DataBase

Hi John,

It is written in VB concept and it is a VB program which connects to the
MySQL with ODBC.

 Hope I am clear here, if not please let me know, as I am new to
Database & VBScript, so I may not understand everything upto the point.

Thanks,
Mustafa

-----Original Message-----
From: John Scoles [mailto:scoles <at> pythian.com] 
Sent: Friday, May 09, 2008 5:59 PM
To: Mohammed Mustafa (WT01 - Testing Services)
Cc: perl <at> lists.mysql.com
Subject: Re: Communication between Perl and VBSript for DataBase

In which context is the VBScript  written, .NET, ASP, VB ??

Anyway you are not giving us (me anyway) enough detail to give you any 
guidance.

Is you VB code really a driver (direct calls to a DB API) or is it just 
a VB program that connects to the MySQL DB with ODBC or alike?

cheers
John Scoles

mohammed.mustafa <at> wipro.com wrote:
(Continue reading)

John Scoles | 9 May 16:30 2008

Re: Communication between Perl and VBSript for DataBase

In that case it is easy.

Simply use PERL with DBI and DBD::ODBC or DBD::MySQL

you can find all three on www.cpan.org

To connect to the database.

I do not think is is practical to get  PERL to try and run teh VB code

What is VB concept?

cheers

mohammed.mustafa <at> wipro.com wrote:
> Hi John,
>
> It is written in VB concept and it is a VB program which connects to the
> MySQL with ODBC.
>
>  Hope I am clear here, if not please let me know, as I am new to
> Database & VBScript, so I may not understand everything upto the point.
>
> Thanks,
> Mustafa
>
>
>
> -----Original Message-----
> From: John Scoles [mailto:scoles <at> pythian.com] 
(Continue reading)

mohammed.mustafa | 9 May 16:37 2008

RE: Communication between Perl and VBSript for DataBase

Thanks John,

    In my application I want the data from VBScript rather than data
base,
so rather directly connecting perl to MySQL data base. I want the data
to be get from VB script, which I indicated in point 2. As In below
query.

I Hope that clarified your doubt.

Pictorial view....

Database <--- VBScript driver <-- Perl Script Driver.

 So here I want the data from VBScript not the Database directly.

If you need more clarification, plz let me know.

Thanks,
Mustafa

-----Original Message-----
From: John Scoles [mailto:scoles <at> pythian.com] 
Sent: Friday, May 09, 2008 8:01 PM
To: Mohammed Mustafa (WT01 - Testing Services)
Cc: perl <at> lists.mysql.com
Subject: Re: Communication between Perl and VBSript for DataBase

In that case it is easy.

(Continue reading)


Gmane