RE: Perl Modelues
Michael: Thanks. It did the trick. Kirti -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 6:32 PM To: Kirti S. Bajwa Cc: [EMAIL PROTECTED] Subject: Re: Perl Modelues Kirti S. Bajwa wrote: Ken: Thank you for your response. I tried the 'mysql_config' command and got an error message. I will add 'mysql_config' to the path (if I figure out how!!!). You need to add the directory which contains mysql_config to your path. Adding to your PATH isn't difficult, but the method depends on your shell. You can find your shell with echo $SHELL I noticed that on my installation the 'mysql_config' is in '/usr/local/mysql/bin' directory whereas you have indicated that it should be in '/usr/local/bin' directory! Please clarify!! /usr/local/mysql/bin is fine. With tcsh, you can add this to your path with set path=($PATH /usr/local/mysql/bin) With sh or bash, you should be able to add this to your path with export PATH=$PATH:/usr/local/mysql/bin Either way, you should probably also add this to the appropriate shell startup file, so mysql is always in your path. You can check your path with echo $PATH Two more questions: (1) Since I have done partial installation, would it hurt if I re-do the entire Perl instalation or start from the command where the errors were encountered? You didn't break anything, you just didn't succeed in adding the module. Just go back into CPAN and try again. I'd suggest perl -MCPAN -e shell install Bundle::DBI install Bundle::DBD::mysql Installing the bundles will make sure you have everything you need. As you've already installed DBI, you'll already have most of what the bundles contain, and CPAN is smart enough not to reinstall what you already have. (2) I also have two Client MySQL servers (which connect to master MySQL server for data). Do I also need to install Perl on these Client MySQL Servers? I'm not sure what you mean by Client MySQL servers. Do you mean machines which need the mysql client to connect to the machine running the mysql server, or do you mean machines which will run the mysql server as slaves to the master server? In any case, you can run the mysql server and client without perl. On the other hand, a number of the helper apps in /usr/local/mysql/bin are perl scripts. Of course, you will need to install perl on any machine where you want to use perl to connect/manipulate your mysql data, and perl is handy to have around in general. Please remember, I am an IBM mainframe guy my knowledge of LINUX related soft is pretty low on scale. Thanks. Kirti Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Perl Modelues
First a big thanks to Mark, BAO, Beacker, Matthais, Rich Ken for their response. My problem was that I thought that I needed to download tar file to start the installation. Rich's response somewhat cleared that. I ran the following commands, and got the following errors: % perl -MCPAN -e shell cpan install Data::Dumper cpan install DBI (no problem upto this point) cpan install DBD::mysql Errors returned: Can't exec mysql_config: No such file or directory at Makefile.PL line 174 readline() on closed filehandle PIPE at Makefile.PL line 176 ... (there are 10 such errors) Then few other lines of output without error. Then I get the following (error) response: Checking if your kit is complete... looks good Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (number of such errors) Note (probabally harmless): No library found for -lmysqlclient Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (again quite a number of such errors) Note (probabally harmless): No library found for -lgz 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 cpan What are these errors? How should I fix them? Can I continue installing other software (Apache, qmail, etc.) Thanks. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
iH is mysql installed and running? - hcir On Apr 8, 2004, at 9:53 AM, Kirti S. Bajwa wrote: cpan install DBD::mysql Errors returned: Can't exec mysql_config: No such file or directory at Makefile.PL line 174 readline() on closed filehandle PIPE at Makefile.PL line 176 ... (there are 10 such errors) Then few other lines of output without error. Then I get the following (error) response: Checking if your kit is complete... looks good Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (number of such errors) Note (probabally harmless): No library found for -lmysqlclient Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (again quite a number of such errors) Note (probabally harmless): No library found for -lgz 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 cpan What are these errors? How should I fix them? Can I continue installing other software (Apache, qmail, etc.) Thanks. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
Hi Kirti, mysql_config tell the perl build module how to link with the driver. The easiest way to fix this is make sure the bin driectory of MySQL is in your path. If you can type 'mysql_config' at the command line and get an answer like: Usage: /usr/local/bin/mysql_config [OPTIONS] Options: etc The perl DBD module should be able to find and use this program to configure itself. If you get a command not found error add the mysql bin driectory to the path. Ken - Original Message - From: Kirti S. Bajwa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 1:53 PM Subject: RE: Perl Modelues First a big thanks to Mark, BAO, Beacker, Matthais, Rich Ken for their response. My problem was that I thought that I needed to download tar file to start the installation. Rich's response somewhat cleared that. I ran the following commands, and got the following errors: % perl -MCPAN -e shell cpan install Data::Dumper cpan install DBI (no problem upto this point) cpan install DBD::mysql Errors returned: Can't exec mysql_config: No such file or directory at Makefile.PL line 174 readline() on closed filehandle PIPE at Makefile.PL line 176 ... (there are 10 such errors) Then few other lines of output without error. Then I get the following (error) response: Checking if your kit is complete... looks good Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (number of such errors) Note (probabally harmless): No library found for -lmysqlclient Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (again quite a number of such errors) Note (probabally harmless): No library found for -lgz 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 cpan What are these errors? How should I fix them? Can I continue installing other software (Apache, qmail, etc.) Thanks. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Perl Modelues
Ken: Thank you for your response. I tried the 'mysql_config' command and got an errot message. I will add 'mysql_config' to the path (if I figure out how!!!). I noticed that on my installation the 'mysql_config' is in '/usr/local/mysql/bin' directory whereas you have indicated that it should be in '/usr/local/bin' directory! Please clarify!! Two more questions: (1) Since I have doen partial installation, would it hurt if I re-do the entire Perl instalation or start from the command where the errors were encountered? (2) I also have two Client MySQL servers (which connect to master MySQL server for data). Do I also need to install Perl on these Client MySQL Servers? Please remember, I am an IBM mainframe guy my knowledge of LINUX related soft is pretty low on scale. Thanks. Kirti -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 3:29 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: Re: Perl Modelues Hi Kirti, mysql_config tell the perl build module how to link with the driver. The easiest way to fix this is make sure the bin driectory of MySQL is in your path. If you can type 'mysql_config' at the command line and get an answer like: Usage: /usr/local/bin/mysql_config [OPTIONS] Options: etc The perl DBD module should be able to find and use this program to configure itself. If you get a command not found error add the mysql bin driectory to the path. Ken - Original Message - From: Kirti S. Bajwa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 1:53 PM Subject: RE: Perl Modelues First a big thanks to Mark, BAO, Beacker, Matthais, Rich Ken for their response. My problem was that I thought that I needed to download tar file to start the installation. Rich's response somewhat cleared that. I ran the following commands, and got the following errors: % perl -MCPAN -e shell cpan install Data::Dumper cpan install DBI (no problem upto this point) cpan install DBD::mysql Errors returned: Can't exec mysql_config: No such file or directory at Makefile.PL line 174 readline() on closed filehandle PIPE at Makefile.PL line 176 ... (there are 10 such errors) Then few other lines of output without error. Then I get the following (error) response: Checking if your kit is complete... looks good Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (number of such errors) Note (probabally harmless): No library found for -lmysqlclient Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (again quite a number of such errors) Note (probabally harmless): No library found for -lgz 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 cpan What are these errors? How should I fix them? Can I continue installing other software (Apache, qmail, etc.) Thanks. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
Kirti S. Bajwa wrote: Ken: Thank you for your response. I tried the 'mysql_config' command and got an error message. I will add 'mysql_config' to the path (if I figure out how!!!). You need to add the directory which contains mysql_config to your path. Adding to your PATH isn't difficult, but the method depends on your shell. You can find your shell with echo $SHELL I noticed that on my installation the 'mysql_config' is in '/usr/local/mysql/bin' directory whereas you have indicated that it should be in '/usr/local/bin' directory! Please clarify!! /usr/local/mysql/bin is fine. With tcsh, you can add this to your path with set path=($PATH /usr/local/mysql/bin) With sh or bash, you should be able to add this to your path with export PATH=$PATH:/usr/local/mysql/bin Either way, you should probably also add this to the appropriate shell startup file, so mysql is always in your path. You can check your path with echo $PATH Two more questions: (1) Since I have done partial installation, would it hurt if I re-do the entire Perl instalation or start from the command where the errors were encountered? You didn't break anything, you just didn't succeed in adding the module. Just go back into CPAN and try again. I'd suggest perl -MCPAN -eshell install Bundle::DBI install Bundle::DBD::mysql Installing the bundles will make sure you have everything you need. As you've already installed DBI, you'll already have most of what the bundles contain, and CPAN is smart enough not to reinstall what you already have. (2) I also have two Client MySQL servers (which connect to master MySQL server for data). Do I also need to install Perl on these Client MySQL Servers? I'm not sure what you mean by Client MySQL servers. Do you mean machines which need the mysql client to connect to the machine running the mysql server, or do you mean machines which will run the mysql server as slaves to the master server? In any case, you can run the mysql server and client without perl. On the other hand, a number of the helper apps in /usr/local/mysql/bin are perl scripts. Of course, you will need to install perl on any machine where you want to use perl to connect/manipulate your mysql data, and perl is handy to have around in general. Please remember, I am an IBM mainframe guy my knowledge of LINUX related soft is pretty low on scale. Thanks. Kirti Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
Just type in the empty search box at the top of the screen: DBI returns: http://search.cpan.org/~timb/DBI-1.42/DBI.pm mysql returns: http://search.cpan.org/~rudy/DBD-mysql-2.9003/ Hope that helps Ken - Original Message - From: Kirti S. Bajwa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 2:57 PM Subject: Perl Modelues Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. Kirt TIB Mountain City, TN 37683 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
Short answer: Type 'cpan' Type 'install DBD::mysql' More information is at: http://search.cpan.org/~rudy/DBD-mysql-2.9003/lib/DBD/mysql/INSTALL.pod General information about installing Perl modules: http://www.cpan.org/misc/cpan-faq.html#How_install_Perl_modules Eamon Daly NextWave Media Group LLC Tel: 1 773 975-1115 Fax: 1 773 913-0970 - Original Message - From: Kirti S. Bajwa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 1:57 PM Subject: Perl Modelues Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. I'm not sure about the light, but when I typed in DBI in the search box at http://search.cpan.org and hit the search button it displayed a list of links and descriptions, the first of which was DBI. You can then either go to the descriptions DBI link or to the DBI-1.42 link just below it to get to the source directly. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
Eamon Daly wrote: Short answer: Type 'cpan' Type 'install DBD::mysql' Contrary to intuition, you should install DBI first! DBD::mysql will look for DBI too. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
BAO RuiXian wrote: Mark wrote: Eamon Daly wrote: Short answer: Type 'cpan' Type 'install DBD::mysql' Contrary to intuition, you should install DBI first! DBD::mysql will look for DBI too. DBI only needs to be installed once. After the installtion, you may need to add as many as you need DBD::XXX. Yes. but from the OP's comment figuring out installation of Perl DBI modules, it seemed to me that this was his first-time encounter with DBI/DBD. And I just wanted to point out, that while he needs the underlying DBD::mysql drivers for DBI to work, that, contrary to intuition, he would need to install DBI first. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]