A list about the Perl support for MySQL with msql-mysql-modules.

mohammed.mustafa | 8 May 2008 15:13

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 2008 15:41

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 2008 15:44

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 2008 16:01

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 2008 16:15

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 2008 14:03

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 2008 14:28

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 2008 15:57

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 2008 16:30

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 2008 16:37

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)

Group

gmane.comp.db.mysql.perl.

Search Archive

Page

1 | 2

Articles in period: 19

May 2008

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

Please update DBD::MySQL with how to create test database (13 Apr 2013)
Still active? (12 Apr 2013)
question about stored procedures with Select statements and critical e (19 Jul 2012)
bind parameter guessing corrupts results (13 Feb 2012)
DBD::drizzle version 0.304 released (3 Nov 2011)
DBD::mysql: no errstr under Windows (18 Oct 2011)
want to install mysql client only (29 Sep 2011)
nature of the server side prepared statement issues? (26 Sep 2011)
can't call statistics_info() method (30 Aug 2011)
DBD::mysql 4.020 released (24 Aug 2011)
DBD::mysql 4.019 Released (9 May 2011)
The install fails due a missing compile parameter (9 May 2011)
Fwd: Patch for DBD::mysql (29 Apr 2011)
'sprintf' is not recognized as an internal or external command, operab (7 Apr 2011)
MySQL queries in a relational database (30 Mar 2011)
Insert or update data in mysql using a perl script (4 Mar 2011)
Bind parameters for SET statements (3 Mar 2011)
Perl script to insert data in mysql from Excel file (23 Feb 2011)
utf8 behavior and approach (24 Jan 2011)
DBD::MySQL (15 Nov 2010)
Faulty version check in foreign_key_info (27 Oct 2010)

Archives

4	April 2013
1	July 2012
5	February 2012
1	November 2011
1	October 2011
2	September 2011
2	August 2011
1	June 2011
4	May 2011
6	April 2011
10	March 2011
6	February 2011
1	January 2011
4	November 2010
2	October 2010
1	August 2010
9	July 2010
2	June 2010
3	May 2010
8	April 2010
3	March 2010
5	January 2010
6	December 2009
2	November 2009
5	October 2009
4	September 2009
2	August 2009
2	July 2009
4	June 2009
6	May 2009
3	April 2009
8	March 2009
6	February 2009
1	November 2008
4	October 2008
4	September 2008
3	August 2008
3	July 2008
7	June 2008
19	May 2008
15	April 2008
32	March 2008
7	February 2008
6	January 2008
47	December 2007
13	November 2007
18	October 2007
21	September 2007
7	August 2007
15	July 2007
5	June 2007
11	May 2007
13	April 2007
12	March 2007
13	February 2007
13	January 2007
6	December 2006
27	November 2006
6	October 2006
21	September 2006
25	August 2006
31	July 2006
25	June 2006
48	May 2006
13	April 2006
24	March 2006
48	February 2006
23	January 2006
21	December 2005
35	November 2005
19	October 2005
20	September 2005
18	August 2005
24	July 2005
27	June 2005
38	May 2005
28	April 2005
72	March 2005
24	February 2005
30	January 2005
47	December 2004
74	November 2004
20	October 2004
52	September 2004
60	August 2004
38	July 2004
80	June 2004
78	May 2004
88	April 2004
74	March 2004
50	February 2004
64	January 2004
50	December 2003
33	November 2003
103	October 2003
104	September 2003
128	August 2003
35	July 2003
11	June 2003
21	May 2003
7	April 2003
66	March 2003
37	February 2003
18	January 2003
14	December 2002
11	November 2002
24	October 2002
32	September 2002
22	August 2002
30	July 2002
11	June 2002

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template