Re: Mysql and Perl
On Monday 25 September 2006 20:09, George Law wrote: damn outlook! fire up perl's CPAN interface: perl -MCPAN -eshell cpan i /mysql/ ... Bundle Bundle::DBD::mysql (C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz) ... cpan install Bundle::DBD::mysql Hello again... I'm back to this problem I had over a year ago. Yesterday I had to reinstall my system, since the disk containint the OS crashed. After a few hours I was back in businness again - except for the Perl module. My perl scripts does not work anymore. I have tried to install the Bundle::DBD::mysql, but it failes with the same error I had last time (see below). Somehow I managed to fix this the last time, but I forgot to write down what I did (shame on me). So... is there any kind soul out there that can give me some hints about how to fix this problem? Output when installing the bundle: -- cpan install Bundle::DBD::mysql DBI is up to date. Data::ShowTable is up to date. Running install for module Mysql Running make for R/RU/RUDY/DBD-mysql-2.9008.tar.gz CPAN: Digest::MD5 loaded ok CPAN: Compress::Zlib loaded ok Checksum for /root/.cpan/sources/authors/id/R/RU/RUDY/DBD-mysql-2.9008.tar.gz ok Scanning cache /root/.cpan/build for sizes DBD-mysql-2.9008/ DBD-mysql-2.9008/t/ DBD-mysql-2.9008/t/60leaks.t DBD-mysql-2.9008/t/40listfields.t DBD-mysql-2.9008/t/10dsnlist.t DBD-mysql-2.9008/t/40numrows.t DBD-mysql-2.9008/t/30insertfetch.t DBD-mysql-2.9008/t/00base.t DBD-mysql-2.9008/t/insertid.t DBD-mysql-2.9008/t/50commit.t DBD-mysql-2.9008/t/40nulls.t DBD-mysql-2.9008/t/dbdadmin.t DBD-mysql-2.9008/t/lib.pl DBD-mysql-2.9008/t/20createdrop.t DBD-mysql-2.9008/t/mysql.dbtest DBD-mysql-2.9008/t/40bindparam.t DBD-mysql-2.9008/t/mysql.t DBD-mysql-2.9008/t/40blobs.t DBD-mysql-2.9008/t/akmisc.t DBD-mysql-2.9008/t/50chopblanks.t DBD-mysql-2.9008/t/ak-dbd.t DBD-mysql-2.9008/t/mysql2.t DBD-mysql-2.9008/lib/ DBD-mysql-2.9008/lib/DBD/ DBD-mysql-2.9008/lib/DBD/mysql/ DBD-mysql-2.9008/lib/DBD/mysql/GetInfo.pm DBD-mysql-2.9008/lib/DBD/mysql/INSTALL.pod DBD-mysql-2.9008/lib/DBD/mysql.pm DBD-mysql-2.9008/lib/Bundle/ DBD-mysql-2.9008/lib/Bundle/DBD/ DBD-mysql-2.9008/lib/Bundle/DBD/mysql.pm DBD-mysql-2.9008/lib/Mysql/ DBD-mysql-2.9008/lib/Mysql/Statement.pm DBD-mysql-2.9008/lib/Mysql.pm DBD-mysql-2.9008/TODO DBD-mysql-2.9008/myld DBD-mysql-2.9008/constants.h DBD-mysql-2.9008/dbdimp.c DBD-mysql-2.9008/dbdimp.h DBD-mysql-2.9008/README DBD-mysql-2.9008/MANIFEST.SKIP DBD-mysql-2.9008/Makefile.PL DBD-mysql-2.9008/META.yml DBD-mysql-2.9008/INSTALL.html DBD-mysql-2.9008/ChangeLog DBD-mysql-2.9008/MANIFEST DBD-mysql-2.9008/mysql.xs Removing previously used /root/.cpan/build/DBD-mysql-2.9008 CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9008.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib -lssl -lcrypto mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 1 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(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.48 (for perl 5.008006 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm gcc -c -I/usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m64 -mtune=nocona -DVERSION=\2.9008\ -DXS_VERSION=\2.9008\ -fPIC -I/usr/lib64/perl5/5.8.6/x86_64-linux-thread-multi/CORE dbdimp.c dbdimp.c:1: error: CPU you selected does not support x86-64 instruction set make: *** [dbdimp.o] Error 1 /usr/bin/make -- NOT OK Running make test Can't
Re: Mysql and Perl
On Monday 25 September 2006 20:05, you wrote: there are two pieces -- dbi, and dbd::mysql. you installed the former but not the latter. go to: http://cpan.perl.org and search for mysql ... Found it, but it won't install: # perl Makefile.PL I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing embedded (mysql_config) = libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib -lssl -lcrypto mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 1 Use of uninitialized value in printf at Makefile.PL line 172, PIPE line 103. test_user ( ) = testdb (default ) = test testhost (default ) = testpassword (default ) = testsocket (default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/ /usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 724 Using DBI 1.52 (for perl 5.008006 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::mysql # make cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm gcc -c -I/usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m64 -mtune=nocona -DVERSION=\3.0007\ -DXS_VERSION=\3.0007\ -fPIC -I/usr/lib64/perl5/5.8.6/x86_64-linux-thread-multi/CORE dbdimp.c dbdimp.c:1: error: CPU you selected does not support x86-64 instruction set make: *** [dbdimp.o] Error 1 # uname -a Linux hostname 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:56:33 EDT 2005 x86_64 x86_64 x86_64 GNU/Linux It seems like it does not accept my 64-bit processor as a 64-bit prosessor... I also got some hints about using cpan (perl -MCPAN -eshell) but I felt like a prisoner @ Guantamo who had to answer questions to CIA... At one point I had no answer so I could not continue. -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql and Perl
someone correct me if I am wrong. DBI is the generic database interface module for perl DBD::mysql is the mysql specific module DBI relies upon to talk to mysql. cpan i /mysql/ -Original Message- From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED] Sent: Monday, September 25, 2006 1:59 PM To: MySQL List Subject: Mysql and Perl I try to write a perl script that will update a mysql database, but when running the script I get: install_driver(mysql) failed: Can't locate DBD/mysql.pm I have installed DBI 1.52, but that did not help. Now I have spend 1 hour searching internet for this well hidden file mysql.pm, but without luck. I have found a lot of references etc, but not a single link to the file... Can some kind soul please guide me to this file? Or has it been lost for man kind? ;-) -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- 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: Mysql and Perl
damn outlook! fire up perl's CPAN interface: perl -MCPAN -eshell cpan i /mysql/ ... Bundle Bundle::DBD::mysql (C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz) ... cpan install Bundle::DBD::mysql -Original Message- From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED] Sent: Monday, September 25, 2006 1:59 PM To: MySQL List Subject: Mysql and Perl I try to write a perl script that will update a mysql database, but when running the script I get: install_driver(mysql) failed: Can't locate DBD/mysql.pm I have installed DBI 1.52, but that did not help. Now I have spend 1 hour searching internet for this well hidden file mysql.pm, but without luck. I have found a lot of references etc, but not a single link to the file... Can some kind soul please guide me to this file? Or has it been lost for man kind? ;-) -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- 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: MySQL and Perl DBI Persistent Connection
On Fri, 16 Jan 2004 17:54:06 -0500 Syed Ali [EMAIL PROTECTED] wrote: I have a Perl CGI script which uses DBI to access MySQL. I noticed that each query through the Perl CGI script using DBI has a connect, query and then quit. I was wondering if there is a way of keeping the connection persistent to Mysql through the Perl CGI script. In my Apache httpd.conf I inserted PerlModule Apache::DBI before all LoadModule lines, but that does not solve the problem. I also downloaded the Apache::DBI module from CPAN and installed it. Perhaps I need to do something else? Is your script running through mod_perl or plain CGI? If it is running through CGI, you can't make persistent connection to MySQL. You should check: http://perl.apache.org/docs/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and Perl
Quite nicely. Take a look at the Perl DBI functions. Curtis On Tue, 11 Sep 2001, Nilesh Parmar wrote: Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Perl
PHP, Perl, Python, etc are all good ways to generate web pages, and they all get on with MySQL perfectly well (OK, I've only used Perl, but I've heard a lot about PHP and a little about Python). My personal input re Perl v. PHP is that PHP is great for people starting CGI stuff if they know HTML first - it lets you create web pages and embed bits of programs. Perl, on the other hand, is better if you know programming first, or if you want complete flexibility. Also note that the Perl DBI interface means that it is relatively simple to move from one database engine to another, but PHP only supports a limited number of database engines. Lezz Giles - Original Message - From: Nilesh Parmar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 8:13 PM Subject: MySQL and Perl Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Perl
PHP, Perl, Python, etc are all good ways to generate web pages, and they all get on with MySQL perfectly well (OK, I've only used Perl, but I've heard a lot about PHP and a little about Python). My personal input re Perl v. PHP is that PHP is great for people starting CGI stuff if they know HTML first - it lets you create web pages and embed bits of programs. Perl, on the other hand, is better if you know programming first, or if you want complete flexibility. Also note that the Perl DBI interface means that it is relatively simple to move from one database engine to another, but PHP only supports a limited number of database engines. Actually, PHP supports a gazillion different engines. However, the interface to each is implemented using a different set of function calls, so PHP scripts often are less than DBI scripts (or DB-API Python scripts, or JDBC Java scripts, for that matter). The PEAR DB class for PHP implements an abstraction layer, though it doesn't have support for as many of the engines yet. PHPLIB and MetaBase are other PHP packages that also provide abstraction layers. Lezz Giles - Original Message - From: Nilesh Parmar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 8:13 PM Subject: MySQL and Perl Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Perl
In web development PHP is very easy to use and best of all very well documented. I have to aggress with Lezz Giles on using PHP over perl for MySQL backed webpages.. The learning curve on PHP is far easier than perl.. I use both for various reasons..I tend to use perl of CGI apps that php cant do or commandline linux administration stuff.. check out the PHP documentation at http://www.php.net/ PHP has built in functions that will dump an entire row into an array (this works with CSV and SQL databases).well there is my 2 cents worth on PHP+MySQL On Tue, 2001-09-11 at 12:27, Lezz Giles wrote: PHP, Perl, Python, etc are all good ways to generate web pages, and they all get on with MySQL perfectly well (OK, I've only used Perl, but I've heard a lot about PHP and a little about Python). My personal input re Perl v. PHP is that PHP is great for people starting CGI stuff if they know HTML first - it lets you create web pages and embed bits of programs. Perl, on the other hand, is better if you know programming first, or if you want complete flexibility. Also note that the Perl DBI interface means that it is relatively simple to move from one database engine to another, but PHP only supports a limited number of database engines. Lezz Giles - Original Message - From: Nilesh Parmar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 8:13 PM Subject: MySQL and Perl Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Perl
PHP has built in functions that will dump an entire row into an array (this works with CSV and SQL databases).well there is my 2 cents worth on PHP+MySQL Um, not to start a language war, perl also can dump a row into an array, as well as into a hash so that one can refer to fields by name, not just ordinal number. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Perl
PHP's mysql_fetch_array() fetches an associative as well as indexed array...or you can specify which. (I'm a huge fan of perl, btw, and have used it to talk to mysql when PHP was just a baby language so no flames...just setting the record straight...) Cheers jenn Rich Duzenbury wrote: PHP has built in functions that will dump an entire row into an array (this works with CSV and SQL databases).well there is my 2 cents worth on PHP+MySQL Um, not to start a language war, perl also can dump a row into an array, as well as into a hash so that one can refer to fields by name, not just ordinal number. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Perl (STOP)
STOP PLEASE. Not again. See mailing list archives. [EMAIL PROTECTED] wrote: PHP's mysql_fetch_array() fetches an associative as well as indexed array...or you can specify which. (I'm a huge fan of perl, btw, and have used it to talk to mysql when PHP was just a baby language so no flames...just setting the record straight...) Cheers jenn Rich Duzenbury wrote: PHP has built in functions that will dump an entire row into an array (this works with CSV and SQL databases).well there is my 2 cents worth on PHP+MySQL Um, not to start a language war, perl also can dump a row into an array, as well as into a hash so that one can refer to fields by name, not just ordinal number. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL with perl error
The only reason why that might happen (assuming it is working somewhere else),
the object isn't return. So connect() constructor couldn't return the object.
To read the error message from DBI, you'll have to read $DBI::errstr:
my $dbh = DBI-connect(dsn, login, password) or die $DBI::errstr;
If the program passes the above line without errors, you'll not have that error
message.
another way of doing the above is:
my $dbh = DBI-connect(dsn, login, password, {RaiseError=});
Sent on Jul 4 by Dawn H to [EMAIL PROTECTED]
dpengu The error log says,
dpengu
dpengu Can't call method do: on an undefined value. . .
dpengu
dpengu But the EXACT SAME code works on another script I'm running. I don't see any
dpengu reason for it to suddenly have a problem. What does this error message MEAN?
dpengu
dpengu Code Snippet--
dpengu # Form was okay; get image type and contents and create new record.
dpengu # Use REPLACE to clobber any old image with the same name.
dpengu
dpengu $mime_type = uploadInfo ($image)-{'Content-Type'};
dpengu ($full, $thumb) = read_image_file ($image);
dpengu $dbh-do (REPLACE INTO image
dpengu (name,listing_id,image,thumbnail,mime_type)
dpengu VALUES(?,?,?,?,?),
dpengu undef,
dpengu $name, $listing_id, $full, $thumb, $mime_type)
dpengu or bail_out(There's a problem with the upload);
dpengu -End Snippet---
dpengu
dpengu http://www.rdcss.com/ - RD Computer Solutions
dpengu http://wow.cooncheese.com/ - WOW.CoonCheese.com
dpengu http://dpenguin.rdcss.com/ - Cornucopia
dpengu Filter fixer: database,sql,query
dpengu
dpengu
dpengu -
dpengu Before posting, please check:
dpenguhttp://www.mysql.com/manual.php (the manual)
dpenguhttp://lists.mysql.com/ (the list archive)
dpengu
dpengu To request this thread, e-mail [EMAIL PROTECTED]
dpengu To unsubscribe, e-mail
[EMAIL PROTECTED]
dpengu Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dpengu
--
Sherzod Ruzmetov
[EMAIL PROTECTED]
http://www.ultracgis.com/sherzodR
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl error
hallo!
With reference to Dawn H on 04.07 00:36:
The error log says,
Can't call method do: on an undefined value. . .
But the EXACT SAME code works on another script I'm running. I don't see any
reason for it to suddenly have a problem. What does this error message MEAN?
Code Snippet--
# Form was okay; get image type and contents and create new record.
# Use REPLACE to clobber any old image with the same name.
$mime_type = uploadInfo ($image)-{'Content-Type'};
($full, $thumb) = read_image_file ($image);
$dbh-do (REPLACE INTO image
(name,listing_id,image,thumbnail,mime_type)
VALUES(?,?,?,?,?),
undef,
$name, $listing_id, $full, $thumb, $mime_type)
or bail_out(There's a problem with the upload);
i have it with (). like ($name), ($listing_id), ...
-End Snippet---
http://www.rdcss.com/ - RD Computer Solutions
http://wow.cooncheese.com/ - WOW.CoonCheese.com
http://dpenguin.rdcss.com/ - Cornucopia
Filter fixer: database,sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gruß bye
Michael Ott
-
- Siemens AG - IS IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54 -
- [EMAIL PROTECTED] -
-
open-source and you have much fun
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL with perl error
The error log says,
Can't call method do: on an undefined value. . .
But the EXACT SAME code works on another script I'm running. I don't see any
reason for it to suddenly have a problem. What does this error message MEAN?
Code Snippet--
# Form was okay; get image type and contents and create new record.
# Use REPLACE to clobber any old image with the same name.
$mime_type = uploadInfo ($image)-{'Content-Type'};
($full, $thumb) = read_image_file ($image);
$dbh-do (REPLACE INTO image
(name,listing_id,image,thumbnail,mime_type)
VALUES(?,?,?,?,?),
undef,
$name, $listing_id, $full, $thumb, $mime_type)
or bail_out(There's a problem with the upload);
-End Snippet---
http://www.rdcss.com/ - RD Computer Solutions
http://wow.cooncheese.com/ - WOW.CoonCheese.com
http://dpenguin.rdcss.com/ - Cornucopia
Filter fixer: database,sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
I overcame this by adding to my php script, something that goves the
user the results, summerised, of what they added to the database, thus
when hitting refresh, it just refreshes the results of what the php
script returned, not what they submitted.
My php script is below.
Pete
html
body
?php
require(fedb.inc);
mysql_connect(localhost,$user,$password);
@mysql_select_db($db) or die( Unable to select database);
/*Insert into database */
mysql_query (INSERT INTO asset (site_id, hostname, device, model,
serial, ip,
dept, mhz, ram, hd_size, os_ver, status, data_port,
pp_port, hub_port,
digi_port, csmim_port, tprmim_port, xyplex_port,
comments, fe)
VALUES ('$site_id', '$hostname', '$device',
'$model', '$serial', '$ip',
'$dept', '$mhz', '$ram', '$hd_size',
'$os_ver', '$status',
'$data_port', '$pp_port', '$hub_port',
'$digi_port',
'$csmim_port', '$tprmim_port',
'$xyplex_port',
'$comments', '$fe')
);
print ($site_id);
print ( );
print ($hostname);
print ( );
print ($device);
print ( );
print ($model);
print ( );
print ($serial);
print ( );
print ($ip);
print ( );
print ($dept);
print ( );
print ($mhz);
print ( );
print ($ram);
print ( );
print ($hd_size);
print ( );
print ($os_ver);
print ( );
print ($status);
print ( );
print ($data_port);
print ( );
print ($pp_port);
print ( );
print ($hub_port);
print ( );
print ($digi_port);
print ( );
print ($csmim_port);
print ( );
print ($tprmim_port);
print ( );
print ($xyplex_port);
print ( );
print ($comments);
print ( );
print ($fe);
print ( );
print (p);
print (p);
print (Thanks for submitting your device.);
?
a href='index.html'bHome/b/a |
a href='searchform.html'bSearch Item/b/a |
a href='searchform_all.html'bSearch Site/b/a |
a href='updateform.html'bUpdate/b/a |
a href='deleteform.html'bDelete/b/a
/body
/html
Cindy wrote:
Dawn H writes:
I've written a couple of scripts and have a thing that I haven't quite
figured out. If anyone can shed light on this, I'd appreciate it.
When a person submits a form that inserts a record into the database, if
they then refresh the page that comes up after the submit, the record will
be submitted a second time. I suppose this is due to the fact that the
subroutine that is called with the submit contains both the write to
database bit and the view bit. So refreshing causes a repeat of both items.
How can I do this without that problem?
I was finally forced to add a check that there wasn't already an
identical record (using a minimum comparison set of fields) before
inserting the record. There really isn't any way to prevent dingbats
from refreshing, so... I CYA by emailing a copy of the record/element
values to myself when I refuse to add it in, but I havne't had any
spurious refusals so far.
--Cindy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
I've encountered this several times. When on the web I just use redirect
pages.
I'll submit the data to a page that puts the information into the database,
and then puts a header() call to redirect them to the real finishing page,
passing any minor variables I may need.
This way also has the unique ability that you can go back and forth in the
browser all you want (no back button woes).
- Original Message -
From: Pete Kuczynski [EMAIL PROTECTED]
To: MySQL Email List [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 8:32 AM
Subject: Re: MySQL with perl
I overcame this by adding to my php script, something that goves the
user the results, summerised, of what they added to the database, thus
when hitting refresh, it just refreshes the results of what the php
script returned, not what they submitted.
My php script is below.
Pete
html
body
?php
require(fedb.inc);
mysql_connect(localhost,$user,$password);
@mysql_select_db($db) or die( Unable to select database);
/*Insert into database */
mysql_query (INSERT INTO asset (site_id, hostname, device, model,
serial, ip,
dept, mhz, ram, hd_size, os_ver, status, data_port,
pp_port, hub_port,
digi_port, csmim_port, tprmim_port, xyplex_port,
comments, fe)
VALUES ('$site_id', '$hostname', '$device',
'$model', '$serial', '$ip',
'$dept', '$mhz', '$ram', '$hd_size',
'$os_ver', '$status',
'$data_port', '$pp_port', '$hub_port',
'$digi_port',
'$csmim_port', '$tprmim_port',
'$xyplex_port',
'$comments', '$fe')
);
print ($site_id);
print ( );
print ($hostname);
print ( );
print ($device);
print ( );
print ($model);
print ( );
print ($serial);
print ( );
print ($ip);
print ( );
print ($dept);
print ( );
print ($mhz);
print ( );
print ($ram);
print ( );
print ($hd_size);
print ( );
print ($os_ver);
print ( );
print ($status);
print ( );
print ($data_port);
print ( );
print ($pp_port);
print ( );
print ($hub_port);
print ( );
print ($digi_port);
print ( );
print ($csmim_port);
print ( );
print ($tprmim_port);
print ( );
print ($xyplex_port);
print ( );
print ($comments);
print ( );
print ($fe);
print ( );
print (p);
print (p);
print (Thanks for submitting your device.);
?
a href='index.html'bHome/b/a |
a href='searchform.html'bSearch Item/b/a |
a href='searchform_all.html'bSearch Site/b/a |
a href='updateform.html'bUpdate/b/a |
a href='deleteform.html'bDelete/b/a
/body
/html
Cindy wrote:
Dawn H writes:
I've written a couple of scripts and have a thing that I haven't quite
figured out. If anyone can shed light on this, I'd appreciate it.
When a person submits a form that inserts a record into the database,
if
they then refresh the page that comes up after the submit, the record
will
be submitted a second time. I suppose this is due to the fact that
the
subroutine that is called with the submit contains both the write to
database bit and the view bit. So refreshing causes a repeat of both
items.
How can I do this without that problem?
I was finally forced to add a check that there wasn't already an
identical record (using a minimum comparison set of fields) before
inserting the record. There really isn't any way to prevent dingbats
from refreshing, so... I CYA by emailing a copy of the record/element
values to myself when I refuse to add it in, but I havne't had any
spurious refusals so far.
--Cindy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http
Re: MySQL with perl
Dawn H writes: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? I was finally forced to add a check that there wasn't already an identical record (using a minimum comparison set of fields) before inserting the record. There really isn't any way to prevent dingbats from refreshing, so... I CYA by emailing a copy of the record/element values to myself when I refuse to add it in, but I havne't had any spurious refusals so far. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? Thanks in advance, Dawn H Two possible suggestions: 1) Provide a unique index field and catch the duplicate error if they try to resubmit the form. Then you can send them a nice Don't do that! message. 2) After the form is submitted redirect them to a second Thanks! page. They can reload that page all they want. Pete -- http://www.elbnet.com ELB Internet Services, Inc. Web Design, Computer Consulting, Internet Hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
You need to have your script operate in different modes. You do this by passing an argument when you call your script to tell the script what it is supposed to do. So in this case, if the script is called with out any arguments, it will display the form, as follows: http://www.sample.com/sample.pl Then, in your HTML, add a hidden field to your form that provides the action you want to do like this: FORM NAME='test' ACTION='sample.pl' FIELD TYPE='hidden' NAME='action' VALUE='1' Now, when you enter the Perl script again, and you extract the parameters, you will have a parameter called action that has a value of 1. Do a conditional test for this value, and if the value is not assigned, as in the original case, just display the form. If the action is set to 1, do your database update, and then show the form again with the new values. If the user hits the reload button, the page will reload, but the action will not be set causing the page to show with first doing a reset. Only if they hit the submit button will the hidden variable be passed to the script causing the action value to be set. Hope this helps. BTW, all this stuff you are wanting to do is MUCH MUCH MUCH easier in PHP which is quite Perl like is some respects, but is so much easier and more efficient, and it works GREAT with MySQL because is has a bunch of MySQL functions built in. Most top web applications these days are developed around what is called LAMP, which stands for Linux/Apache/MySQL/PHP. This is the winning combination. -Ken At 01:42 AM 6/6/01 -0500, Dawn H wrote: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? Thanks in advance, Dawn H It's practically impossible to look at a penguin and feel angry. --Joe Moore http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
Cindy, read my reply to this. You are mistaken. There is actually a way to make a single script do all kinds of different operations. I have single scripts that show a list of records, add a new record, update a record, and delete a record, all in the same script. This is more efficient to do because if the webserver is configured correctly, it will cache the script thereby preventing re-compilation of the script code. -Ken At 12:18 AM 6/6/01 -0700, Cindy wrote: Dawn H writes: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? I was finally forced to add a check that there wasn't already an identical record (using a minimum comparison set of fields) before inserting the record. There really isn't any way to prevent dingbats from refreshing, so... I CYA by emailing a copy of the record/element values to myself when I refuse to add it in, but I havne't had any spurious refusals so far. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
OTOH, if you use mod_perl, *all* scripts are cached. That way you can have a single script per function, which makes each smaller and simpler to debug. Paul Wilson iiNet Ltd Cindy, read my reply to this. You are mistaken. There is actually a way to make a single script do all kinds of different operations. I have single scripts that show a list of records, add a new record, update a record, and delete a record, all in the same script. This is more efficient to do because if the webserver is configured correctly, it will cache the script thereby preventing re-compilation of the script code. -Ken At 12:18 AM 6/6/01 -0700, Cindy wrote: Dawn H writes: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to database bit and the view bit. So refreshing causes a repeat of both items. How can I do this without that problem? I was finally forced to add a check that there wasn't already an identical record (using a minimum comparison set of fields) before inserting the record. There really isn't any way to prevent dingbats from refreshing, so... I CYA by emailing a copy of the record/element values to myself when I refuse to add it in, but I havne't had any spurious refusals so far. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and Perl DBI
Use only GCC-2.95.2 Gordon Stewart wrote: I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-14.tar.gz. User name for connecting to database test? [undef] Password for connecting to database test? [undef] Creating files for MySQL Checking if your kit is complete... Looks good Using DBI 1.14 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules [gordon@fido Msql-Mysql-modules-1.2213]$ make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/Msql-Mysql-modules mkdir blib/lib/auto mkdir blib/lib/auto/Msql-Mysql-modules mkdir blib/man1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux \ -I/usr/lib/perl5/5.6.0 -Ilib -MExtUtils::PerlPP \ -e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm" /usr/bin/pod2text mysql/lib/DBD/mysql.pm README make[1]: Entering directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir ../blib/lib/DBD mkdir ../blib/arch/auto/DBD mkdir ../blib/arch/auto/DBD/mysql mkdir ../blib/lib/auto/DBD mkdir ../blib/lib/auto/DBD/mysql mkdir ../blib/man3 cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm cp lib/Mysql.pm ../blib/lib/Mysql.pm gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/m ysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/li b/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i 386-linux/CORE -DDBD_MYSQL dbdimp.c /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI/Driver.xst mysql.xsi /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 /usr/lib/perl5/5.6.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.6.0/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/m ysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/li b/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i 386-linux/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.96" gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L/usr/lib/mysql -lmysqlclient -lm -L/usr/lib/gc c-lib/i386-redhat-linux/2.96 -lgcc chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Manifying ../blib/man3/DBD::mysql.3pm Manifying ../blib/man3/Bundle::DBD::mysql.3pm Manifying ../blib/man3/Mysql.3pm make[1]: Leaving directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir blib/script cp dbimon blib/script/dbimon /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -MExt Utils::MakeMaker -e "MY-fixin(shift)" blib/script/dbimon Manifying blib/man1/dbimon.1 *** ERROR: unterminated C... at line 1426 in file dbimon *** ERROR: unterminated C... at line 1450 in file dbimon Can any one help Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql and Perl DBI
The redhat 7 mysql version doesn't work correctly...i.e. the mysql.h is missing. The solution is to re-install with the a tarball from the mysql site.. :( eric -Original Message- From: Gordon Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 5:29 AM To: [EMAIL PROTECTED] Subject: Mysql and Perl DBI I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. Can any one help Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql and Perl DBI
I highly recommend a source installation for everyone anyway. The RPMs are problematic to say the least. The source install is easy anyway. At 09:21 AM 4/11/2001 -0700, Eric Fegraus wrote: The redhat 7 mysql version doesn't work correctly...i.e. the mysql.h is missing. The solution is to re-install with the a tarball from the mysql site.. :( eric -Original Message- From: Gordon Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 5:29 AM To: [EMAIL PROTECTED] Subject: Mysql and Perl DBI I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. Can any one help Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "It has been said that the primary function of schools is to impart enough facts to make children stop asking questions. Some, with whom the schools do not succeed, become scientists." - Knut Schmidt-Nielson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and Perl DBI
Gordon, What kind of errors? A copy/paste of errors would be useful. Cheers Ben - Original Message - From: Gordon Stewart [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 1:29 PM Subject: Mysql and Perl DBI I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. Can any one help Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL using PERL
Rajeev Ramanujan wrote: Hai, I am using Red Hat Linux 7. From where can I get example programmes of connectiong to MYSQL using PERL under Linux. Thankyou Rajeev Ramanujan Look at any of the perl based packages or utilities listed in the contributed section at mysql.com. One of the best ways to learn a new language is to study someone elses programs. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL using PERL
How about mysql.com, http://cpan.org/modules/by-module/DBI/ MySQL.com has numerous links to help documents and code samples. -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows." -- Sun Microsystems CEO, Scott McNealy __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL using PERL
Buy the MySQL book from New Riders. You won't be disappointed. -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows." -- Sun Microsystems CEO, Scott McNealy __ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL using PERL
Hi, Have you installed DBI/DBD?? if so you can perldoc DBI or perldoc mysql_dbd to read the manual. Alan. Hai, I am using Red Hat Linux 7. From where can I get example programmes of connectiong to MYSQL using PERL under Linux. Thankyou Rajeev Ramanujan -- Åwªï¨Ï¥ÎHongKong.com¶l¥ó¨t²Î Thank you for using hongkong.com Email system - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
