Problem !!!

Habe Probleme beim installieren von DBD::mysql

HILFE



Starte /usr/bin/perl Makefile.PL && make ..

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include/mysql'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.28 installed in /usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/auto/ DBI
Writing Makefile for DBD::mysql
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/aut o/DBI -I'/usr/include/mysql' -D_R
EENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 --pipe
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC "-I/usr/lib/perl5/5.8.0/i586-linux-thread-multi/C
ORE" dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" < /usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/au
to/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.0/ExtUtils/typemap
mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'rows' detected in mysql.xs, line 290
cc -c -I/usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/aut o/DBI -I'/usr/include/mysql' -D_R
EENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 --pipe
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC "-I/usr/lib/perl5/5.8.0/i586-linux-thread-multi/C
ORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared dbdimp.o mysql.o -o blib/arch/auto
/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
/usr/lib/gcc-lib/i486-suse-linux/3.2/../../../../i486-suse-l inux/bin/ld: cannot find -lz
collect2: ld returned 1 exit status


An error occurred while linking the DBD::mysql driver. The error
message seems to indicate that you don't have a libz.a,
or a libz.so. This is typically resolved by:

1.) You may try to remove the -lz or -lgz flag from the libs list
by using the --libs switch for "perl Makefile.PL".
2.) On Red Hat Linux install libz-devel
3.) On other systems, please contact the mailing list

Msql-Mysql-modules@lists.mysql.com

For further hints, see INSTALL.html, section Linker flags.
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1




--
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: Problem !!!

Ralph Kronberg wrote:

> An error occurred while linking the DBD::mysql driver. The error
> message seems to indicate that you don't have a libz.a,
> or a libz.so. This is typically resolved by:
>
> 1.) You may try to remove the -lz or -lgz flag from the libs list
> by using the --libs switch for "perl Makefile.PL".
> 2.) On Red Hat Linux install libz-devel

--
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: Problem !!!

Ralph Kronberg wrote:

> An error occurred while linking the DBD::mysql driver. The error
> message seems to indicate that you don't have a libz.a,
> or a libz.so. This is typically resolved by:
>
> 1.) You may try to remove the -lz or -lgz flag from the libs list
> by using the --libs switch for "perl Makefile.PL".
> 2.) On Red Hat Linux install libz-devel

--
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: Problem !!!

Dose Mysql has function option like Oracle NOLOG login?
thanks
Brian
----- Original Message -----
From: "Jochen Wiedmann"
To: "Ralph Kronberg"
Cc:
Sent: Thursday, May 20, 2004 3:30 PM
Subject: Re: Problem !!!


> Ralph Kronberg wrote:
>
> > An error occurred while linking the DBD::mysql driver. The error
> > message seems to indicate that you don't have a libz.a,
> > or a libz.so. This is typically resolved by:
> >
> > 1.) You may try to remove the -lz or -lgz flag from the libs list
> > by using the --libs switch for "perl Makefile.PL".
> > 2.) On Red Hat Linux install libz-devel
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=lshen@pop900.gsfc.nasa.gov
>


--
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: Problem !!!

Dose Mysql has function option like Oracle NOLOG login?
thanks
Brian
----- Original Message -----
From: "Jochen Wiedmann"
To: "Ralph Kronberg"
Cc:
Sent: Thursday, May 20, 2004 3:30 PM
Subject: Re: Problem !!!


> Ralph Kronberg wrote:
>
> > An error occurred while linking the DBD::mysql driver. The error
> > message seems to indicate that you don't have a libz.a,
> > or a libz.so. This is typically resolved by:
> >
> > 1.) You may try to remove the -lz or -lgz flag from the libs list
> > by using the --libs switch for "perl Makefile.PL".
> > 2.) On Red Hat Linux install libz-devel
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=lshen@pop900.gsfc.nasa.gov
>


--
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: Problem !!!

Dose anyone know the mysql function password()? How dose it works? thank you

Brian
----- Original Message -----
From: "lei shen"
To: "Jochen Wiedmann" ; "Ralph Kronberg"

Cc:
Sent: Friday, May 21, 2004 9:40 AM
Subject: Re: Problem !!!


> Dose Mysql has function option like Oracle NOLOG login?
> thanks
> Brian
> ----- Original Message -----
> From: "Jochen Wiedmann"
> To: "Ralph Kronberg"
> Cc:
> Sent: Thursday, May 20, 2004 3:30 PM
> Subject: Re: Problem !!!
>
>
> > Ralph Kronberg wrote:
> >
> > > An error occurred while linking the DBD::mysql driver. The error
> > > message seems to indicate that you don't have a libz.a,
> > > or a libz.so. This is typically resolved by:
> > >
> > > 1.) You may try to remove the -lz or -lgz flag from the libs list
> > > by using the --libs switch for "perl Makefile.PL".
> > > 2.) On Red Hat Linux install libz-devel
> >
> > --
> > MySQL Perl Mailing List
> > For list archives: http://lists.mysql.com/perl
> > To unsubscribe:
> http://lists.mysql.com/perl?unsub=lshen@pop900.gsfc.nasa.gov
> >
>


--
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: Problem !!!

Dose anyone know the mysql function password()? How dose it works? thank you

Brian
----- Original Message -----
From: "lei shen"
To: "Jochen Wiedmann" ; "Ralph Kronberg"

Cc:
Sent: Friday, May 21, 2004 9:40 AM
Subject: Re: Problem !!!


> Dose Mysql has function option like Oracle NOLOG login?
> thanks
> Brian
> ----- Original Message -----
> From: "Jochen Wiedmann"
> To: "Ralph Kronberg"
> Cc:
> Sent: Thursday, May 20, 2004 3:30 PM
> Subject: Re: Problem !!!
>
>
> > Ralph Kronberg wrote:
> >
> > > An error occurred while linking the DBD::mysql driver. The error
> > > message seems to indicate that you don't have a libz.a,
> > > or a libz.so. This is typically resolved by:
> > >
> > > 1.) You may try to remove the -lz or -lgz flag from the libs list
> > > by using the --libs switch for "perl Makefile.PL".
> > > 2.) On Red Hat Linux install libz-devel
> >
> > --
> > MySQL Perl Mailing List
> > For list archives: http://lists.mysql.com/perl
> > To unsubscribe:
> http://lists.mysql.com/perl?unsub=lshen@pop900.gsfc.nasa.gov
> >
>


--
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: Problem !!!

lei shen wrote:

>Dose Mysql has function option like Oracle NOLOG login?

Most probably it would help if you'd be able to explain what NOLOG does? At
least I have no idea at all.


--
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: Problem !!!

lei shen wrote:

>Dose Mysql has function option like Oracle NOLOG login?

Most probably it would help if you'd be able to explain what NOLOG does? At
least I have no idea at all.


--
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: Problem !!!

Dose Mysql has function option like Oracle NOLOG login?
Establishes no initial connection to Oracle. Before issuing any SQL
commands,
you must issue a CONNECT command to establish a valid logon. Use /NOLOG when
you
want to have a SQL*Plus command file prompt for the username, password, or
database specification. The first line of this command file is not assumed
to
contain a logon.

Brian
----- Original Message -----
From: "Jochen Wiedmann"
To: "lei shen"
Cc:
Sent: Monday, May 24, 2004 8:34 AM
Subject: Re: Problem !!!


> lei shen wrote:
>
> >Dose Mysql has function option like Oracle NOLOG login?
>
> Most probably it would help if you'd be able to explain what NOLOG does?
At
> least I have no idea at all.
>


--
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: Problem !!!

Dose Mysql has function option like Oracle NOLOG login?
Establishes no initial connection to Oracle. Before issuing any SQL
commands,
you must issue a CONNECT command to establish a valid logon. Use /NOLOG when
you
want to have a SQL*Plus command file prompt for the username, password, or
database specification. The first line of this command file is not assumed
to
contain a logon.

Brian
----- Original Message -----
From: "Jochen Wiedmann"
To: "lei shen"
Cc:
Sent: Monday, May 24, 2004 8:34 AM
Subject: Re: Problem !!!


> lei shen wrote:
>
> >Dose Mysql has function option like Oracle NOLOG login?
>
> Most probably it would help if you'd be able to explain what NOLOG does?
At
> least I have no idea at all.
>


--
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: Problem !!!

lei shen wrote:

> Dose Mysql has function option like Oracle NOLOG login?
> Establishes no initial connection to Oracle. Before issuing any SQL
> commands,
> you must issue a CONNECT command to establish a valid logon. Use /NOLOG when
> you
> want to have a SQL*Plus command file prompt for the username, password, or
> database specification. The first line of this command file is not assumed
> to
> contain a logon.

That is not a driver specific but an application specific thing.

I think, your misconception is, that MySQL does not have such thing as the
opposite of NOLOG: You *must* always pass a user name and password to the
database. Possibly the user name is implicitly choosen (the currently logged
in user), but that's a feature one should not use anyways.


--
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: Problem !!!

lei shen wrote:

> Dose Mysql has function option like Oracle NOLOG login?
> Establishes no initial connection to Oracle. Before issuing any SQL
> commands,
> you must issue a CONNECT command to establish a valid logon. Use /NOLOG when
> you
> want to have a SQL*Plus command file prompt for the username, password, or
> database specification. The first line of this command file is not assumed
> to
> contain a logon.

That is not a driver specific but an application specific thing.

I think, your misconception is, that MySQL does not have such thing as the
opposite of NOLOG: You *must* always pass a user name and password to the
database. Possibly the user name is implicitly choosen (the currently logged
in user), but that's a feature one should not use anyways.


--
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: Problem !!!

Dose Mysql can have more than one port for connection? if it dose, how to
operate it? thanks

Brian
----- Original Message -----
From: "Jochen Wiedmann"
To: "lei shen"
Cc:
Sent: Monday, May 24, 2004 8:34 AM
Subject: Re: Problem !!!


> lei shen wrote:
>
> >Dose Mysql has function option like Oracle NOLOG login?
>
> Most probably it would help if you'd be able to explain what NOLOG does?
At
> least I have no idea at all.
>


--
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: Problem !!!

Dose Mysql can have more than one port for connection? if it dose, how to
operate it? thanks

Brian
----- Original Message -----
From: "Jochen Wiedmann"
To: "lei shen"
Cc:
Sent: Monday, May 24, 2004 8:34 AM
Subject: Re: Problem !!!


> lei shen wrote:
>
> >Dose Mysql has function option like Oracle NOLOG login?
>
> Most probably it would help if you'd be able to explain what NOLOG does?
At
> least I have no idea at all.
>


--
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: Problem !!!

lei shen wrote:

> Dose Mysql can have more than one port for connection? if it dose, how to
> operate it? thanks

That would require different databases. If this is what you want: 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: Problem !!!

lei shen wrote:

> Dose Mysql can have more than one port for connection? if it dose, how to
> operate it? thanks

That would require different databases. If this is what you want: 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: Problem !!!

thanks Jochen, so you mean each database only can has one port? If i want
another port, i need to setup another database?

Brian

----- Original Message -----
From: "Jochen Wiedmann"
To: "lei shen"
Cc:
Sent: Monday, May 24, 2004 8:34 AM
Subject: Re: Problem !!!


> lei shen wrote:
>
> >Dose Mysql has function option like Oracle NOLOG login?
>
> Most probably it would help if you'd be able to explain what NOLOG does?
At
> least I have no idea at all.
>


--
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: Problem !!!

thanks Jochen, so you mean each database only can has one port? If i want
another port, i need to setup another database?

Brian

----- Original Message -----
From: "Jochen Wiedmann"
To: "lei shen"
Cc:
Sent: Monday, May 24, 2004 8:34 AM
Subject: Re: Problem !!!


> lei shen wrote:
>
> >Dose Mysql has function option like Oracle NOLOG login?
>
> Most probably it would help if you'd be able to explain what NOLOG does?
At
> least I have no idea at all.
>


--
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: Problem !!!

lei shen wrote:
> thanks Jochen, so you mean each database only can has one port? If i want
> another port, i need to setup another database?

Hi,

It may help you to look at the MySQL manual, which is all online and
searchable at:


HTH,
Dave


--
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: Problem !!!

lei shen wrote:
> thanks Jochen, so you mean each database only can has one port? If i want
> another port, i need to setup another database?

Hi,

It may help you to look at the MySQL manual, which is all online and
searchable at:


HTH,
Dave


--
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: Problem !!!

lei shen wrote:

>thanks Jochen, so you mean each database only can has one port? If i want
>another port, i need to setup another database?
>
>
>
The simple answer is, "Yes, MySQL uses one port and if you wish to use
another you'll need to setup a second MySQL instance -- with separate
databases, tables and underlying files."

But, perhaps the correct answer is: what are you seeking to gain from
another TCP/IP port? Why do you want multiple ports for, I assume, the
same MySQL running instance?

Describing your intention for the feature will help us understand how to
help.

Thanks,

Robert J Taylor
robert@rjamestaylor.com


--
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: Problem !!!

lei shen wrote:

>thanks Jochen, so you mean each database only can has one port? If i want
>another port, i need to setup another database?
>
>
>
The simple answer is, "Yes, MySQL uses one port and if you wish to use
another you'll need to setup a second MySQL instance -- with separate
databases, tables and underlying files."

But, perhaps the correct answer is: what are you seeking to gain from
another TCP/IP port? Why do you want multiple ports for, I assume, the
same MySQL running instance?

Describing your intention for the feature will help us understand how to
help.

Thanks,

Robert J Taylor
robert@rjamestaylor.com


--
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