perl-DBD-mysql for MySQL4

perl-DBD-mysql for MySQL4

am 07.04.2004 17:42:43 von Joao Miguel Ferreira

Hello all,

I'm writting to this list because I can't find a RPM file to install the
perl DBD for MySQL4.

I've installed MySQL 4 from RPM's and it went ok.

Now I need to work with MySQL with perl and I'm not able to find the
correct rpm. The one rpm I can find uses libmysql.????.so.10 and I have
only ???.so.12.

My system is Red Hat 9.

Can anyone help ?

Thank you

jmf



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 17:45:43 von Rudy Lippan

> Hello all,
>
> I'm writting to this list because I can't find a RPM file to install the
> perl DBD for MySQL4.
>
> I've installed MySQL 4 from RPM's and it went ok.
>
> Now I need to work with MySQL with perl and I'm not able to find the
> correct rpm. The one rpm I can find uses libmysql.????.so.10 and I have
> only ???.so.12.
>
> My system is Red Hat 9.
>
> Can anyone help ?

Make sure that the correct mysql_config (for MySQL 4) is in you path and
then:

perl -MCPAN -e 'install DBD::mysql'


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 17:45:43 von Rudy Lippan

> Hello all,
>
> I'm writting to this list because I can't find a RPM file to install the
> perl DBD for MySQL4.
>
> I've installed MySQL 4 from RPM's and it went ok.
>
> Now I need to work with MySQL with perl and I'm not able to find the
> correct rpm. The one rpm I can find uses libmysql.????.so.10 and I have
> only ???.so.12.
>
> My system is Red Hat 9.
>
> Can anyone help ?

Make sure that the correct mysql_config (for MySQL 4) is in you path and
then:

perl -MCPAN -e 'install DBD::mysql'


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 18:01:30 von Joao Miguel Ferreira

> Make sure that the correct mysql_config (for MySQL 4) is in you path

sorry but, how exactly do I do that (I'm not very expert) ?

> and
> then:
>
> perl -MCPAN -e 'install DBD::mysql'

this one I know. it connects to the CPAN and instals the DBD, right ?

>
>
> Rudy
thank you

jmf

>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 18:01:30 von Joao Miguel Ferreira

> Make sure that the correct mysql_config (for MySQL 4) is in you path

sorry but, how exactly do I do that (I'm not very expert) ?

> and
> then:
>
> perl -MCPAN -e 'install DBD::mysql'

this one I know. it connects to the CPAN and instals the DBD, right ?

>
>
> Rudy
thank you

jmf

>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 18:04:49 von Rudy Lippan

On 7 Apr 2004, Joao Miguel Ferreira wrote:

> > Make sure that the correct mysql_config (for MySQL 4) is in you path
>
> sorry but, how exactly do I do that (I'm not very expert) ?
>

You can do a 'which mysql_config' that will tell you which mysql_config
the system will use. If it returns nothing or if it returns the path to a
mysql_config from a mysql that you do not want to use (mysql 3 for
example) then you will need to modify your path:

export PATH=path/to/mysql_config:$PATH;

The RPM probably already took care of that for you.

> > and
> > then:
> >
> > perl -MCPAN -e 'install DBD::mysql'
>
> this one I know. it connects to the CPAN and instals the DBD, right ?
>

Yes.


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 18:04:49 von Rudy Lippan

On 7 Apr 2004, Joao Miguel Ferreira wrote:

> > Make sure that the correct mysql_config (for MySQL 4) is in you path
>
> sorry but, how exactly do I do that (I'm not very expert) ?
>

You can do a 'which mysql_config' that will tell you which mysql_config
the system will use. If it returns nothing or if it returns the path to a
mysql_config from a mysql that you do not want to use (mysql 3 for
example) then you will need to modify your path:

export PATH=path/to/mysql_config:$PATH;

The RPM probably already took care of that for you.

> > and
> > then:
> >
> > perl -MCPAN -e 'install DBD::mysql'
>
> this one I know. it connects to the CPAN and instals the DBD, right ?
>

Yes.


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:08:21 von Joao Miguel Ferreira

Rudy,

I've just done what you suggested:

1 - the PATH is correct because "which mysql_config" returns the correct
path and the file is there.

2 - then I executed "perl -MCPAN -e 'install DBD::mysql'".
I was able to get through the initial configuration and finally it
started downloading the DBD. It was correctly unpacked but somtehing bad
hapened after (something which I have seen before because before I
downloaded de DBD 'by hand' and tried installing it and the same
hapened). So here is:


a) I get lots of lines equal to this one:

----------
"Unsuccessfull stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm";
------------


b) imediatly after it goes:

-----------
Writing Makefile for DBD::mysql
Makefile:89: *** missing separator. Stop.
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible
---------

I copied the (aparently bad) Makefile to this URL for you to see:
http://robotica.estg.ipvc.pt/software/linux/Makefile

All this I have seen before when trying to install 'manually'.

My system is a Red Hat 9, and it had a previouslly installed MySQL and
DBD-mysql which I removed with "rpm -i" without any dependencies
problems.

Thanks for your help... any further instructions ?

your name appears during the whole download... so you should be the
author.... pleasure to meet you.

jmf



On Wed, 2004-04-07 at 17:04, Rudy Lippan wrote:
> On 7 Apr 2004, Joao Miguel Ferreira wrote:
>
> > > Make sure that the correct mysql_config (for MySQL 4) is in you path
> >
> > sorry but, how exactly do I do that (I'm not very expert) ?
> >
>
> You can do a 'which mysql_config' that will tell you which mysql_config
> the system will use. If it returns nothing or if it returns the path to a
> mysql_config from a mysql that you do not want to use (mysql 3 for
> example) then you will need to modify your path:
>
> export PATH=path/to/mysql_config:$PATH;
>
> The RPM probably already took care of that for you.
>
> > > and
> > > then:
> > >
> > > perl -MCPAN -e 'install DBD::mysql'
> >
> > this one I know. it connects to the CPAN and instals the DBD, right ?
> >
>
> Yes.
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:08:21 von Joao Miguel Ferreira

Rudy,

I've just done what you suggested:

1 - the PATH is correct because "which mysql_config" returns the correct
path and the file is there.

2 - then I executed "perl -MCPAN -e 'install DBD::mysql'".
I was able to get through the initial configuration and finally it
started downloading the DBD. It was correctly unpacked but somtehing bad
hapened after (something which I have seen before because before I
downloaded de DBD 'by hand' and tried installing it and the same
hapened). So here is:


a) I get lots of lines equal to this one:

----------
"Unsuccessfull stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm";
------------


b) imediatly after it goes:

-----------
Writing Makefile for DBD::mysql
Makefile:89: *** missing separator. Stop.
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible
---------

I copied the (aparently bad) Makefile to this URL for you to see:
http://robotica.estg.ipvc.pt/software/linux/Makefile

All this I have seen before when trying to install 'manually'.

My system is a Red Hat 9, and it had a previouslly installed MySQL and
DBD-mysql which I removed with "rpm -i" without any dependencies
problems.

Thanks for your help... any further instructions ?

your name appears during the whole download... so you should be the
author.... pleasure to meet you.

jmf



On Wed, 2004-04-07 at 17:04, Rudy Lippan wrote:
> On 7 Apr 2004, Joao Miguel Ferreira wrote:
>
> > > Make sure that the correct mysql_config (for MySQL 4) is in you path
> >
> > sorry but, how exactly do I do that (I'm not very expert) ?
> >
>
> You can do a 'which mysql_config' that will tell you which mysql_config
> the system will use. If it returns nothing or if it returns the path to a
> mysql_config from a mysql that you do not want to use (mysql 3 for
> example) then you will need to modify your path:
>
> export PATH=path/to/mysql_config:$PATH;
>
> The RPM probably already took care of that for you.
>
> > > and
> > > then:
> > >
> > > perl -MCPAN -e 'install DBD::mysql'
> >
> > this one I know. it connects to the CPAN and instals the DBD, right ?
> >
>
> Yes.
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:10:36 von Rudy Lippan

On 7 Apr 2004, Joao Miguel Ferreira wrote:

> 2 - then I executed "perl -MCPAN -e 'install DBD::mysql'".
> I was able to get through the initial configuration and finally it
> started downloading the DBD. It was correctly unpacked but somtehing bad
> hapened after (something which I have seen before because before I
> downloaded de DBD 'by hand' and tried installing it and the same
> hapened). So here is:
>
>
> a) I get lots of lines equal to this one:
>
> ----------
> "Unsuccessfull stat on filename containing newline at
> /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm";
> ------------


That is a problem with perl 5.8.0 & redhat 9. This should get you through
it:

LANG="" perl -MCPAN -e 'install DBD::mysql'

or you can 'unset LANG' or 'export LANG=""' &c.


Rudy



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:10:36 von Rudy Lippan

On 7 Apr 2004, Joao Miguel Ferreira wrote:

> 2 - then I executed "perl -MCPAN -e 'install DBD::mysql'".
> I was able to get through the initial configuration and finally it
> started downloading the DBD. It was correctly unpacked but somtehing bad
> hapened after (something which I have seen before because before I
> downloaded de DBD 'by hand' and tried installing it and the same
> hapened). So here is:
>
>
> a) I get lots of lines equal to this one:
>
> ----------
> "Unsuccessfull stat on filename containing newline at
> /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm";
> ------------


That is a problem with perl 5.8.0 & redhat 9. This should get you through
it:

LANG="" perl -MCPAN -e 'install DBD::mysql'

or you can 'unset LANG' or 'export LANG=""' &c.


Rudy



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:28:20 von Joao Miguel Ferreira

Rudy,

It worked.

It executed 'make' and then 'make test' with all tests ok and one test
skipped (the t/60leaks one). 'make install' also went ok.

About 'make test':
- did it really connect to MySQL to execute the tests ?
- or is it just an internal test ?
- If it did not connect to the database server, is there any quick way
to test this comunication ? maybe a sample script...?

Once again thanks for the quick help.

jmf


On Wed, 2004-04-07 at 18:10, Rudy Lippan wrote:
> On 7 Apr 2004, Joao Miguel Ferreira wrote:
>
> > 2 - then I executed "perl -MCPAN -e 'install DBD::mysql'".
> > I was able to get through the initial configuration and finally it
> > started downloading the DBD. It was correctly unpacked but somtehing bad
> > hapened after (something which I have seen before because before I
> > downloaded de DBD 'by hand' and tried installing it and the same
> > hapened). So here is:
> >
> >
> > a) I get lots of lines equal to this one:
> >
> > ----------
> > "Unsuccessfull stat on filename containing newline at
> > /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm";
> > ------------
>
>
> That is a problem with perl 5.8.0 & redhat 9. This should get you through
> it:
>
> LANG="" perl -MCPAN -e 'install DBD::mysql'
>
> or you can 'unset LANG' or 'export LANG=""' &c.
>
>
> Rudy
>
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:28:20 von Joao Miguel Ferreira

Rudy,

It worked.

It executed 'make' and then 'make test' with all tests ok and one test
skipped (the t/60leaks one). 'make install' also went ok.

About 'make test':
- did it really connect to MySQL to execute the tests ?
- or is it just an internal test ?
- If it did not connect to the database server, is there any quick way
to test this comunication ? maybe a sample script...?

Once again thanks for the quick help.

jmf


On Wed, 2004-04-07 at 18:10, Rudy Lippan wrote:
> On 7 Apr 2004, Joao Miguel Ferreira wrote:
>
> > 2 - then I executed "perl -MCPAN -e 'install DBD::mysql'".
> > I was able to get through the initial configuration and finally it
> > started downloading the DBD. It was correctly unpacked but somtehing bad
> > hapened after (something which I have seen before because before I
> > downloaded de DBD 'by hand' and tried installing it and the same
> > hapened). So here is:
> >
> >
> > a) I get lots of lines equal to this one:
> >
> > ----------
> > "Unsuccessfull stat on filename containing newline at
> > /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm";
> > ------------
>
>
> That is a problem with perl 5.8.0 & redhat 9. This should get you through
> it:
>
> LANG="" perl -MCPAN -e 'install DBD::mysql'
>
> or you can 'unset LANG' or 'export LANG=""' &c.
>
>
> Rudy
>
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:29:26 von Rudy Lippan

On 7 Apr 2004, Joao Miguel Ferreira wrote:

> About 'make test':
> - did it really connect to MySQL to execute the tests ?

Yes.


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:29:26 von Rudy Lippan

On 7 Apr 2004, Joao Miguel Ferreira wrote:

> About 'make test':
> - did it really connect to MySQL to execute the tests ?

Yes.


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:44:26 von Joao Miguel Ferreira

On Wed, 2004-04-07 at 18:29, Rudy Lippan wrote:
> On 7 Apr 2004, Joao Miguel Ferreira wrote:
>
> > About 'make test':
> > - did it really connect to MySQL to execute the tests ?
>
> Yes.

Great.

"I love this game !!!"

jmf

>
>
> Rudy
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: perl-DBD-mysql for MySQL4

am 07.04.2004 19:44:26 von Joao Miguel Ferreira

On Wed, 2004-04-07 at 18:29, Rudy Lippan wrote:
> On 7 Apr 2004, Joao Miguel Ferreira wrote:
>
> > About 'make test':
> > - did it really connect to MySQL to execute the tests ?
>
> Yes.

Great.

"I love this game !!!"

jmf

>
>
> Rudy
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org