Urgent-DBD::MySQL

am 20.05.2004 11:23:35 von Subramanyam Malepati

--0-919997377-1085045015=:96249
Content-Type: text/plain; charset=us-ascii

Hi,there

I am trying to install bugzilla on my redhat 7.3. I failed to
install bundle::bugzilla. so I decide to upgrade my perl to 5.8.0.
Then I run
perl -MCPAN -e 'install "Bundle::Bugzilla"'

It complained something wrong with DBD::mysql, I download this module
and tried to install it manually. Since mysql did not install to
default directory, I spent sometime to tune up --cflags and --libs
settig for Makefile.PL

but finally I still get such error message after I run Perl Makefile
for DBD::mysql

I will use the following settings for compiling and testing:

cflags (Users choice) = -I/usr/local/mysql/include/mysql
libs (Users choice) = -L/usr/local/mysql/lib/mysql
-lmysqlclient -lz -lcrypt -lnsl -lm
nocatchstderr (default ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

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

WARNING: EXE_FILES takes a array reference not a string/number.
Please inform the author.
Checking if your kit is complete...
Looks good
Can't use string ("dbimon pmysql") as an ARRAY ref while "strict
refs" in use at /usr/lib/perl5/5.8.0/ExtUtils/MM_Unix.pm line 1424.

I don't know what I can do. I serach internet for solution but it
seems few people encounter such a problem.

I hope there are some perl/DBD expert in this mailing list and give
me some advice on this

Thanks a lot!

---------------------------------
Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year
--0-919997377-1085045015=:96249--

password encryption

am 20.05.2004 14:01:52 von lshen

Hi! Dose anyone know how to encryption the password in perl? i do not want
to show the database password in my file. thank you very much.

Brian

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

password encryption

am 20.05.2004 14:01:52 von lshen

Re: password encryption

am 20.05.2004 15:17:25 von Jochen Wiedmann

lei shen wrote:

> Hi! Dose anyone know how to encryption the password in perl? i do not want
> to show the database password in my file. thank you very much.

As you need to encrypt and decrypt the password, you would typically need
some kind of "key". However, to perform the decryption, access to the key
is required. So you end up with the same problem: How to protect the key?

A typical solution for the problem is to store the credentials in a separate
file with proper permissions. For example, if root is running the program in
question, then one would use a file readable by root only.

Jochen

--
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: password encryption

am 20.05.2004 15:17:25 von Jochen Wiedmann

Re: password encryption

am 24.05.2004 14:22:24 von lshen

dose mysql or any other database has function like Oracle NOLOG option?
thanks

Brian
----- Original Message -----
From: "Jochen Wiedmann"
To: "lei shen"
Cc: "Subramanyam Malepati" ;
Sent: Thursday, May 20, 2004 9:17 AM
Subject: Re: password encryption

> lei shen wrote:
>
> > Hi! Dose anyone know how to encryption the password in perl? i do not
want
> > to show the database password in my file. thank you very much.
>
> As you need to encrypt and decrypt the password, you would typically need
> some kind of "key". However, to perform the decryption, access to the key
> is required. So you end up with the same problem: How to protect the key?
>
> A typical solution for the problem is to store the credentials in a
separate
> file with proper permissions. For example, if root is running the program
in
> question, then one would use a file readable by root only.
>
> Jochen
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=sugiarto.Then@infotronik.c om
>
>

--
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: password encryption

am 24.05.2004 14:22:24 von lshen

Re: password encryption

am 25.05.2004 00:03:55 von Greg Meckes

Perl's crypt function will do the trick:
http://www.perldoc.com/perl5.6/pod/func/crypt.html

--- lei shen wrote:
> dose mysql or any other database has function like Oracle NOLOG option?
> thanks
>
> Brian
> ----- Original Message -----
> From: "Jochen Wiedmann"
> To: "lei shen"
> Cc: "Subramanyam Malepati" ;
> Sent: Thursday, May 20, 2004 9:17 AM
> Subject: Re: password encryption
>
>
> > lei shen wrote:
> >
> > > Hi! Dose anyone know how to encryption the password in perl? i do not
> want
> > > to show the database password in my file. thank you very much.
> >
> > As you need to encrypt and decrypt the password, you would typically need
> > some kind of "key". However, to perform the decryption, access to the key
> > is required. So you end up with the same problem: How to protect the key?
> >
> > A typical solution for the problem is to store the credentials in a
> separate
> > file with proper permissions. For example, if root is running the program
> in
> > question, then one would use a file readable by root only.
> >
> > Jochen
> >
> >
> > --
> > MySQL Perl Mailing List
> > For list archives: http://lists.mysql.com/perl
> > To unsubscribe:
> http://lists.mysql.com/perl?unsub=sugiarto.Then@infotronik.c om
> >
> >
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe: http://lists.mysql.com/perl?unsub=gregmeckes@yahoo.com
>

__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.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: password encryption

am 25.05.2004 00:03:55 von Greg Meckes