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]
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]
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]
Unicode (utf8) and MySQL (with Perl)
Hi List. Please excuse the cross posting but I've been scouring the archives and no joy as yet. I'm trying to get Perl and MySQL using utf8 happily and I've followed several tutorials but am not getting the same results. I've got a load of utf8 characters like so (perl): my %uni = ( hebrew_alef = { character = chr(0x05d0), language = hebrew, }, smiley = { character = \x{263a}, language = none, }, ); I am inserting them into MySQL using the dbi module DBD::MySQL The tutorial said to insert the values like this: INSERT INTO unitest (id, aword) VALUES ( smiley, CONVERT(_utf8'\x{263a}' USING utf8) ); get the values back like this: select aword from unitest where id = smiley; then use perl to decode the returned value like so: decode(utf8, $aword) This doesn't work for me properly. However when I insert them like this: INSERT INTO unitest (id, aword) VALUES ( $smiley, '\x{263a}' ); It seems to work for all but the hebrew_alef which is the character chr(0x05d0) So here's my questions: Is chr(0x05d0) a unicode character? Do we need to use CONVERT to insert data (it's seems to working better without it here, but I don't understand CONVERT and the manual didn't clear that up for me), or should we be inserting utf8 chars the standard way. I'm using mysql 4.1.7 and perl 5.8.1 on OS X 10.3 TIA I'm struggling now. Angie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unicode (utf8) and MySQL (with Perl)
- Original Message - From: angie ahl [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 9:26 AM Subject: Unicode (utf8) and MySQL (with Perl) Hi List. Please excuse the cross posting but I've been scouring the archives and no joy as yet. I'm trying to get Perl and MySQL using utf8 happily and I've followed several tutorials but am not getting the same results. I've got a load of utf8 characters like so (perl): my %uni = ( hebrew_alef = { character = chr(0x05d0), language = hebrew, }, smiley = { character = \x{263a}, language = none, }, ); I am inserting them into MySQL using the dbi module DBD::MySQL The tutorial said to insert the values like this: INSERT INTO unitest (id, aword) VALUES ( smiley, CONVERT(_utf8'\x{263a}' USING utf8) ); get the values back like this: select aword from unitest where id = smiley; then use perl to decode the returned value like so: decode(utf8, $aword) This doesn't work for me properly. However when I insert them like this: INSERT INTO unitest (id, aword) VALUES ( $smiley, '\x{263a}' ); It seems to work for all but the hebrew_alef which is the character chr(0x05d0) So here's my questions: Is chr(0x05d0) a unicode character? Do we need to use CONVERT to insert data (it's seems to working better without it here, but I don't understand CONVERT and the manual didn't clear that up for me), or should we be inserting utf8 chars the standard way. I'm using mysql 4.1.7 and perl 5.8.1 on OS X 10.3 TIA I'm struggling now. I can't help with very much of your question because I haven't really worked with character sets in MySQL. However, I can tell you that 0x05d0 *is* the Unicode value of aleph in Hebrew. You can see the entire Hebrew Unicode character set at http://www.unicode.org/charts/PDF/U0590.pdf to confirm this for yourself (and look up other Hebrew codes). To see all of the Unicode charts, go to http://www.unicode.org/charts/. By the way, I don't know if you've examined it already but there is a full chapter in the MySQL manual on character sets which may answer some of your questions. See http://dev.mysql.com/doc/mysql/en/Charset.html. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unicode (utf8) and MySQL (with Perl)
On Wed, 1 Dec 2004, Rhino wrote: I'm using mysql 4.1.7 and perl 5.8.1 on OS X 10.3 It also wouldn't hurt you to upgrade past all the minor updates of your other components. That means 4.1.7 (check), 5.8.6, and 10.3.6. I'm sure Perl had a lot of bug fixes or improvements after 5.8.1, especially since Unicode support is used a lot less than ascii historically. Also, make sure you have DBI 1.46 and DBD::mysql the newest. -- Darren Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrading Mysql and Perl DBD
I now have MySQL 4.0.2 and MySQL 4.1.3 beta both installed and running on one machine. I want to be able to use the Perl DBI / DBD to connect to both servers. I understand that there have been some changes between the MySQL 4.0.X and 4.1.X series that may require differently compiled DBD's. So my question is, do i need to have 2 separate DBD versions, or will the newer one work for both MySQL servers. The old DBD does not work for the new server. This is demonstrated by the error message: DBI-connect(...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at connect_test.pl line 19 All the connect_test.pl tries to do is create a db connection to each server separately. Any insight would be greatly appreciated thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading Mysql and Perl DBD
This is covered in the manual http://dev.mysql.com/doc/mysql/en/Password_hashing.html: A 4.1 client can connect to a pre-4.1 server, because the client understands both the old and new password hashing mechanisms. So, if you build the Perl modules against the 4.1.x library, you should be able to connect to either server. Michael sean c peters wrote: I now have MySQL 4.0.2 and MySQL 4.1.3 beta both installed and running on one machine. I want to be able to use the Perl DBI / DBD to connect to both servers. I understand that there have been some changes between the MySQL 4.0.X and 4.1.X series that may require differently compiled DBD's. So my question is, do i need to have 2 separate DBD versions, or will the newer one work for both MySQL servers. The old DBD does not work for the new server. This is demonstrated by the error message: DBI-connect(...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at connect_test.pl line 19 All the connect_test.pl tries to do is create a db connection to each server separately. Any insight would be greatly appreciated thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Reading MS Access tables from MySQL or Perl
Are you looking for an interface to read MS Access other than the default application and MS Query? -Original Message- From: Nik Belajcic To: [EMAIL PROTECTED] Sent: 5/3/04 9:52 PM Subject: Reading MS Access tables from MySQL or Perl Hello, This is partially off-topic as I am looking at reading Access tables from either Perl (preferred) or MySQL, but if anyone has any suggestions, I will be most grateful. My first thoughts were to write a Perl script which will read 2 columns from an MS Access table and load them into MySQL. It would be run at a click of a button from a web interface to display updated MySQL tables. However, after few hours of googling it appears that this is easier said than done due to ODBC and DSN quirks. Direct import into MySQL requires external utility like DBTools which defeats desired automation of the procedure. Is there a known best way to do this and has anyone done something similar? Thanks in advance for any hints. -- Nik Belajcic [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]
Reading MS Access tables from MySQL or Perl
Hello, This is partially off-topic as I am looking at reading Access tables from either Perl (preferred) or MySQL, but if anyone has any suggestions, I will be most grateful. My first thoughts were to write a Perl script which will read 2 columns from an MS Access table and load them into MySQL. It would be run at a click of a button from a web interface to display updated MySQL tables. However, after few hours of googling it appears that this is easier said than done due to ODBC and DSN quirks. Direct import into MySQL requires external utility like DBTools which defeats desired automation of the procedure. Is there a known best way to do this and has anyone done something similar? Thanks in advance for any hints. -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Reading MS Access tables from MySQL or Perl
Nik Belajcic wrote: Hello, This is partially off-topic as I am looking at reading Access tables from either Perl (preferred) or MySQL, but if anyone has any suggestions, I will be most grateful. My first thoughts were to write a Perl script which will read 2 columns from an MS Access table and load them into MySQL. It would be run at a click of a button from a web interface to display updated MySQL tables. However, after few hours of googling it appears that this is easier said than done due to ODBC and DSN quirks. Direct import into MySQL requires external utility like DBTools which defeats desired automation of the procedure. Is there a known best way to do this and has anyone done something similar? Thanks in advance for any hints. I haven't done this myself, but one of my friends uses a perl thing call DBI::Proxy. You install it on the server ( ie machine with MS Access ) and client ( ie machine you'll be running the Perl scripts from ) and it *somehow* works. Sorry I'm a bit lean on the details. I've seen it working. Google for it. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Reading MS Access tables from MySQL or Perl
Thanks for that tip. It helped me find a page which explains it properly. In case anyone else might be interested, here is the link. http://www.awilcox.com/geek_stuff/perl/proxy.html -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query in MySQL vs. PERL
I'm using MySQL to track data throughput information on my company's routers. The routers are queried every 5 minutes 24 hours/day. I need to produce a report showing data accumulated during business hours - Monday through Friday, 8:00-5:00. The program to pull the data and manipulate it will be written in PERL. What I don't know is, will it be more efficient to have the PERL program query data from MySQL only for business hours or should I write the MySQL query (and sub-query) to only SELECT data from business hours. I can do either one, I just don't know which one would be best. I'm running MySQL 4.0.16 standard on a Sun e250 running Solaris 8. The database consists of around 650 tables ranging in size from 20 KB to 3-4 GB (approx. 12 million records). Any help and advice would be greatly appreciated. If more info is needed, please let me know. Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705
Re: Query in MySQL vs. PERL
Jack- I think it's pretty much based on preference. I prefer doing everything in epoch, it seems to make it easier for me. This means that the queries would be selecting for business hours, based on epoch time. We do this for our pix logs, web stats, etc... Calculations are much easier this way since there is less converting to do. My dependency on epoch has led me not to use mysql's built in time/date functions. This, of course, is dependent on having epoch in the database in the first place. Then I just dynamically create the 'BETWEEN' queries on the epoch field with the business hours between a range, concatenate them, and run the query. As far as efficiency goes, I don't think that this particular query would be the dependency. It depends on how well laid out the dbase is itself, and how the manipulation scripting works (what it does). I would assume that the manipulation includes streamlining the dataset a bit. I have something like this which I use to graph trending (MRTGish) for servers (disk/cpu/load/response/etc) across the enterprise (I use nagios to gather the data thru snmp). It runs with the same frequency, and I have no performance issues generating the graphs on the fly with any reasonable timeframe. Anyhow.. Hope that helps a bit. Peter J. Milanese Jack Coxen [EMAIL PROTECTED] 04/06/2004 02:01 PM To: MySQL List (E-mail) [EMAIL PROTECTED] cc: Subject:Query in MySQL vs. PERL I'm using MySQL to track data throughput information on my company's routers. The routers are queried every 5 minutes 24 hours/day. I need to produce a report showing data accumulated during business hours - Monday through Friday, 8:00-5:00. The program to pull the data and manipulate it will be written in PERL. What I don't know is, will it be more efficient to have the PERL program query data from MySQL only for business hours or should I write the MySQL query (and sub-query) to only SELECT data from business hours. I can do either one, I just don't know which one would be best. I'm running MySQL 4.0.16 standard on a Sun e250 running Solaris 8. The database consists of around 650 tables ranging in size from 20 KB to 3-4 GB (approx. 12 million records). Any help and advice would be greatly appreciated. If more info is needed, please let me know. Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705 -- 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]
MySQL and Perl DBI Persistent Connection
Hello, 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? I also removed any disconnect statements in my Perl CGI script, but I still see the quit in mysql.query.log. Thank you... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 3,4 + Perl
Hi, I am planning to run an instance of MySQL 3.23.55 and 4.0.11-max on the same machine. The question is: what do I do with DBD::mysql ? Can I leave it intact? The install note says I have to recompile modules that link against libmysqlclient... but do I really have to do that? Or can I reinstall DBD and use it for both 3.x and 4.0.x, too? Should I create two installations of DBD? The later one I would like to avoid... Thanx, - Csongor - 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: An Idea (really: MySQL and Perl for the Web)
we are all in sales, 24/7. :-) Jim -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 9:24 PM To: JamesD; Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea (really: MySQL and Perl for the Web) At 17:35 -0800 12/29/02, JamesD wrote: while Paul probably wouldnt say it, I would: Well, I *have* been known to make shameless plugs from time to time, but of course it's better if readers make them for me. :-) So, thanks, I appreciate it. his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) I of course appreciate it when people purchase a copy of the book, but for those who prefer to take a look at part of it first, I will point out that there is a sample chapter available online at: http://www.kitebird.com/mysql-perl/ It's a 78-page PDF, and it deals with a number of questions that probably would come up in a FAQ, but in more detail. For example, it answers the oft-posed questions: how do I store images in MySQL? and how do I retrieve images from MySQL for display in a Web page? The sample code that implements the answers to these questions is also available at the URL above, as are some sample applications. (One of which is an e-card thing that demonstrates image retrieval and display.) I guess that's enough shameless plugging for now. :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- - 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: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote: while Paul probably wouldnt say it, I would: Well, I *have* been known to make shameless plugs from time to time, but of course it's better if readers make them for me. :-) So, thanks, I appreciate it. his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) I of course appreciate it when people purchase a copy of the book, but for those who prefer to take a look at part of it first, I will point out that there is a sample chapter available online at: http://www.kitebird.com/mysql-perl/ It's a 78-page PDF, and it deals with a number of questions that probably would come up in a FAQ, but in more detail. For example, it answers the oft-posed questions: how do I store images in MySQL? and how do I retrieve images from MySQL for display in a Web page? The sample code that implements the answers to these questions is also available at the URL above, as are some sample applications. (One of which is an e-card thing that demonstrates image retrieval and display.) I guess that's enough shameless plugging for now. :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- - 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: Using MySQL with Perl 5.8?
At 12:58 13/11/2002 +0200, Octavian Rasnita wrote: Hi, Hi all, I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under Windows 2000) but after installing Perl 5.8, ppm can't find this module anymore. I had the same issue, then I removed Perl and re-installed the below early version: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. D:\perl --version This is perl, v5.6.0 built for MSWin32-x86-multi-thread (with 1 registered patch, see perl -V for more detail) Copyright 1987-2000, Larry Wall Binary build 623 provided by ActiveState Tool Corp. http://www.ActiveState.com Built 16:27:07 Dec 15 2000 Instead to use: ppmInstall DBI ppmInstall DBD::mysql I did at prompt command: ppm install http://www.perl.com/CPAN-local/authors/id/JWIED/DBD-mysql-1.2212.x86.ppd and I was be able for to make my tests with MySQL. Maybe there is other best option, but just now the above option is enough to me, hope it help you too. I could find only the module DBD::mysqlPP for pure Perl. I don't understand what pure perl means but I've seen that this module accepts less functions than DBD::mysql. Do you know if DBD::mysql works with Perl 5.8 and how can I install it? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [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 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.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
Using MySQL with Perl 5.8?
Hi all, I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under Windows 2000) but after installing Perl 5.8, ppm can't find this module anymore. I could find only the module DBD::mysqlPP for pure Perl. I don't understand what pure perl means but I've seen that this module accepts less functions than DBD::mysql. Do you know if DBD::mysql works with Perl 5.8 and how can I install it? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [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: Using MySQL with Perl 5.8?
Did you remember to allow backwards compatibility in @INC for perl 5.6.1? ~K Black -Original Message- From: Octavian Rasnita [mailto:orasnita;home.ro] Sent: Wednesday, November 13, 2002 2:58 AM To: MySQL List Subject: Using MySQL with Perl 5.8? Hi all, I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under Windows 2000) but after installing Perl 5.8, ppm can't find this module anymore. I could find only the module DBD::mysqlPP for pure Perl. I don't understand what pure perl means but I've seen that this module accepts less functions than DBD::mysql. Do you know if DBD::mysql works with Perl 5.8 and how can I install it? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [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 - 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
MySQL-DBI-perl-bin ... problems
hi list, have got an error in trying to install MySQL-bench-3.23.52-1 rpm says, that the file MySQL-DBI-perl-bin is reqired, but MySQL-DBI-perl-bin-1.1825-1 is installed. and so I could see in rpmfind.org, this file is the last one. would it be possible, that there should be another version of this file installed ? here is an output of a new try to install MySQL-DBI-perl-bin and have discovered the following hint in the messages, rpm produce with the -options : D: the B dependency needs an epoch (assuming same as A) A DBI-perl-bin = 1:0.93-1 B DBI-perl-bin = 0.90 ~~ ~~~ ~~ D: YESA DBI-perl-bin = 1:0.93-1 B DBI-perl-bin = 0.90 D: Requires: DBI-perl-bin = 0.90 YES (db provides) hmm, maybe, this is eventually a possible solution ? the kernel-version, I have is : kernel-2.4.9-31mppe the gcc-version : [root@mozart /root]# gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) [root@mozart /root]# the full output of just installed Mysql-DBI ... is as follows : Mysql-DBI-perl-bin-1.1825-1 hope that helps for a solution thanks again bye hans - 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
Unable to find MySQL-DBI-perl-bin RPM?
Hello, I recently started trying to learn MySQL, and toward that goal I thought it would be a good idea to put it on my Redhat Linux system. I downloaded all the RPMs I could find, since I'm still fairly new to Linux and the whole tarball idea is strange to me. However when I go to install the MySQL-bench-3.23.52 RPM I get a problem that it requires MySQL-DBI-perl-bin. I've searched your site, and I can't find the required RPM. So, I searched through your manual next, and came up with section 2.7.1 Installing Perl on Unix as the next best answer. While I haven't gone through the steps yet, I feel pretty confident that your documentation is clear, concise and will work with no problems. But I would still like to know if there is a MySQL-DBI-perl-bin RPM available on your site, since the MySQL-bench-3.23.52 RPM clearly requires it? Thank you. Sincerely, Paul Laska [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: How to get data from MySQL with perl
Here's an example: - #! /usr/bin/perl use Mysql; $dbh = Mysql-connect(localhost, verycooldatabase, , ); $query = select this from that; $sth = $dbh-query($query); // returns one row at the time in array @arr while(@arr = $sth-fetchrow) { foreach $data (@arr) print($data\n); } - Good luck! Eivind 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
How to get data from MySQL with perl
How do I query a database with Perl - retrieve a item and then have that as a var to use in another insert statement Currently I have : Use DBI I define: my vars : host,db,username,password etc I create my db object etc I used the script to do a insert to my db and it worked fine - but I cant get data from a table with a SELECT * table WHERE whatever) I don't know excactly how to tel perl how to get the field as a var. Any help welcome - any good Perl tutorials out there ? - 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
diffrent amount of datasets with mysql man perl
Hello, im using mysql 3.23.41-log perl 5.6 This might be a perl question but I have to start somewhere:-) to get the data out of the DB im using: --- perl snip --- while (my @fields = $sth-fetchrow_array()) { print join (;, @fields), \n; } --- perl snip --- so each data set is presented in csv style. But the amount of data sets is not the same. For a sql statement im using a simple select count(*)... When im using the mysql client for the select statement more datasets are returned then with the perl script( as an example 2348 lines to 3206 lines). does someone have a clue to this problem? Thanks in advance, sake. - 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: diffrent amount of datasets with mysql man perl
Hi, thanks for the fast replies, It was a database problem. I compared two tables wich were not syncronised and therefor didnt have the same amount of datasets. Thanks sake. Samier.Kesou@bfa-berli An: [EMAIL PROTECTED] n.de Kopie: Thema:diffrent amount of datasets with mysql man perl 14.05.02 15:55 Hello, im using mysql 3.23.41-log perl 5.6 This might be a perl question but I have to start somewhere:-) to get the data out of the DB im using: --- perl snip --- while (my @fields = $sth-fetchrow_array()) { print join (;, @fields), \n; } --- perl snip --- so each data set is presented in csv style. But the amount of data sets is not the same. For a sql statement im using a simple select count(*)... When im using the mysql client for the select statement more datasets are returned then with the perl script( as an example 2348 lines to 3206 lines). does someone have a clue to this problem? Thanks in advance, sake. - 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
MySQL and Perl for the Web now available in Dutch
I'm pleased to announce that MySQL and Perl for the Web (New Riders, by me) is now available in a Dutch translation (MySQL en Perl voor het web). Not that I can read a word of it ... :-) Information is available on the translations page at the book's Web site: http://www.kitebird.com/mysql-perl/ - 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: Where is MySQL-DBI-perl-bin.rpm?
AFAIK not all of the perl modules are available as RPMs, you may either have to create the RPM on your own, or have to install that module the normal way, and force the installation of the dependent RPM using '--nodeps'. the latest distributions built by SuSE contain some of the perl modules as RPMs. maybe you can find them on their FTP server. concerning version ... take a look inside the RPM, it tells you whether a certain version is required or just any version. Andreas * sql, select * -Original Message- From: Iago Sineiro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 12:11 PM To: MySql Mail List Subject: Where is MySQL-DBI-perl-bin.rpm? Hi. I've installed mysql-3.23.49a rpm packages from www.mysql.com on a Pentium RedHat 7.2 machine. When I try to install MySQL-bench-3.23.49a-1.i386.rpm package it depends in MySQL-DBI-perl-bin package. I failed to find MySQL-DBI-perl-bin package in www.mysql.com, where is it? and what version I need for MySQL-bench-3.23.49a-1.i386.rpm package. - 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
Where is MySQL-DBI-perl-bin.rpm?
Hi. I've installed mysql-3.23.49a rpm packages from www.mysql.com on a Pentium RedHat 7.2 machine. When I try to install MySQL-bench-3.23.49a-1.i386.rpm package it depends in MySQL-DBI-perl-bin package. I failed to find MySQL-DBI-perl-bin package in www.mysql.com, where is it? and what version I need for MySQL-bench-3.23.49a-1.i386.rpm package. Thanks in advance. Iago. - 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
I need MySQL-DBI-perl-bin but can only find Mysql-dbi-perl-bin
Hello, I'm sure this is a rehash of a common benchmark installation problem, but my searches have not yielded a satisfactory answer. I've been digging through some old threads related to this subject, but I'm still unable to find MySQL-DBI-perl-bin that is required by MySQL-bench-3.23.48-1.i386.rpm. I can find a ton of links to Mysql-DBI-perl-bin, though. Follows is the output from my attempt at installing the benchmark RPM that I downloaded from one of the mysql mirror sites. rpm -i MySQL-bench-3.23.48-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.48-1 Thanks in advance, Ryan _ Send and receive Hotmail on your mobile device: http://mobile.msn.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: How to access MySql using Perl. Help
I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. man DBD::mysql Cheers. -- Luis Calero Muñoz $email{luis} = '[EMAIL PROTECTED]' $who{luis} = 'sysadm at ociojoven dot 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
MySQL-BDI-PERL-BIN Install help!
Sorry if I am asking a stupid question by I am rather New to Linux and MySQL. I am running RedHat Linux 7.1 and am trying to load MySQL 3.23.48 (in RPM form) and all the neat little packages that go along with it. My question is specifically about MySQL-bench and more specifically it's package dependencies. MySQL-bench requires MySQL-DBI-perl-bin (note the case) but the ONLY RPMs I could find are mysql-DBI-perl-bin and Mysql-DBI-perl-bin (again, please note the case). I have tried to load both of the above RPMs but MySQL-bench will not accept them (presumably due to case sensitivity) and I have also tried to rename the DBI RPMs and then load, but they do not load with the changed name. What do I do? Will I have to compile the DBI files myself? Will the files show up in Package Manager (I don't now how to turn source tars into RPMS)? If so, how do tell the ./configure to name all appropriate file MySQL instead of Mysql. Any advice would be a huge help! --- Thank You, Eric Gibson - 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: How to access MySql using Perl. Help
http://www.hotscripts.com Or http://www.scriptsearch.com Both sites show examples on how to contect to a database with perl or PHP. They also show how to connect to other databases! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 3:11 AM To: Andy Cheng Cc: [EMAIL PROTECTED] Subject: Re: How to access MySql using Perl. Help I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. man DBD::mysql Cheers. -- Luis Calero Muñoz $email{luis} = '[EMAIL PROTECTED]' $who{luis} = 'sysadm at ociojoven dot 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 - 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: How to access MySql using Perl. Help
Read through the man doc lcalero gave you it tells everything you need to know. Below is a basic example to help get you started: #!/usr/bin/perl use CGI; use DBI; $hostname = 'www.hostname.com'; $database = 'nameofdatabase'; $user = 'username'; $password = 'password'; $driver = 'mysql'; $dsn = DBI:$driver:database=$database;host=$hostname; my $dbh = DBI-connect($dsn, $user, $password) or die Cant connect to the DB: $DBI::errstr\n; my $sth = $dbh-prepare(SELECT attributes from entities); $sth-execute(); my $something; while (my @row = $sth-fetchrow_array()) { $something .= qq| $row[2]$row[1]etc.\n|; } #each row is respective to the row returned from the query with the first being row 0 $sth-finish; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 4:11 AM To: Andy Cheng Cc: [EMAIL PROTECTED] Subject: Re: How to access MySql using Perl. Help I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. man DBD::mysql Cheers. -- Luis Calero Muñoz $email{luis} = '[EMAIL PROTECTED]' $who{luis} = 'sysadm at ociojoven dot 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 - 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: How to access MySql using Perl. Help
Hi. You have to install DBI::DBD module. Then in perl use Mysql; $dbh = Mysql-connect(undef,database,username,'password'); $sql = select blah from blah; $sth = $dbh-query($sql); @arr = $sth-fetchrow; for example if the result is more than one line you have to loop it Ofcoz there is other ways to do it i guess:) /PM\ Andy Cheng wrote: Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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
How to access MySql using Perl. Help
Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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
How to access MySql using Perl. Help
Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: How to access MySql using Perl. Help
Hi. You have to install DBI::DBD module. Then in perl use Mysql; $dbh = Mysql-connect(undef,database,username,'password'); $sql = select blah from blah; $sth = $dbh-query($sql); @arr = $sth-fetchrow; for example if the result is more than one line you have to loop it Ofcoz there is other ways to do it i guess:) /PM\ Andy Cheng wrote: Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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
How to get connected with mysql using perl scripts
Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - 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: How to get connected with mysql using perl scripts
Hi, Check the following links: http://dbi.symbolstone.org/ http://www.saturn5.com/~jwb/dbi-examples.html http://www.oreilly.com/catalog/perldbi/ Best of luck. ~ SubbaReddy .M E-mail: [EMAIL PROTECTED] W3Page: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 1:51 PM Subject: How to get connected with mysql using perl scripts Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - 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: How to get connected with mysql using perl scripts
And here some more good links for DBI: http://www.he.net/adm/mysql/chapter7.html http://www.he.net/adm/mysql/chapter6.html ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad ( http://www.frontlinesoft.com ) Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/ ICQ: 56093095 From: SubbaReddy M [EMAIL PROTECTED] To: Charitha [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 3:42 PM Subject: Re: How to get connected with mysql using perl scripts Hi, Check the following links: http://dbi.symbolstone.org/ http://www.saturn5.com/~jwb/dbi-examples.html http://www.oreilly.com/catalog/perldbi/ Best of luck. ~ SubbaReddy .M E-mail: [EMAIL PROTECTED] W3Page: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 1:51 PM Subject: How to get connected with mysql using perl scripts Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - 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
How to get connected with mysql using perl scripts
Charitha, Wednesday, January 30, 2002, 10:21:11 AM, you wrote: C Hi all, C Please guide me to get the connection with mysql through perl scripts and C through the scripts i have to insert some lot of data in the existing C tables. You can refer to: http://www.mysql.com/downloads/api-dbi.html C Regards, C Charitha. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: How to get connected with mysql using perl scripts
Hi, see the DBI perldoc here is a quick example: my $dbh = DBI-connect(DBI:mysql:mydb, $user, $password) or die Can't connect to $data_source: $DBI::errstr; Charitha wrote: Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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
Watchdog für mysql in Perl?
Hi! Short question: i want to have a perl watchdog telling me when executed if my sql-server is running and if anything is allright with it. So if i get any errormessage i can restart the server by remote. Has someone done this allready? Any hint? Thanks again and best regards Sascha Kettner - 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: Watchdog für mysql in Perl?
Well, you could use a shell script to run mysqladmin status. I.e. this bash script: #! /bin/bash # mystatus.sh is really just a simple alias for a # longer command. # Usage: 'mystatus.sh PASSWORD' # replace values of $my_hostname and $my_username if needed my_hostname='localhost' my_username='root' my_password=${1} export my_hostname my_username my_password # execute the command /usr/local/mysql/bin/mysqladmin -h $my_hostname -u $my_username \ --password=$my_password status # end of file I tested this out with variables corresponding to my own system, I'm running RH Linux with MySQL 3.23.46. You don't even have to replace the values in the variables section of the script with your own, if your MySQL server is on the localhost. The setup as is takes the password from STDIN, so it's not stored anywhere (though I don't know how to write a script that hides the password as you type it [yet]). I'm sure that you could do a better script than this in Perl, which I don't yet know. I'm still learning how to write bash scripts (this is my second one that does anything useful) so if this code is amateurish, sorry. Erik On Friday, January 4, 2002, at 06:52 AM, Sascha Kettner wrote: Hi! Short question: i want to have a perl watchdog telling me when executed if my sql-server is running and if anything is allright with it. So if i get any errormessage i can restart the server by remote. Has someone done this allready? Any hint? Thanks again and best regards Sascha Kettner - 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 mysql-unsubscribe- [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: Watchdog für mysql in Perl?
I use a simple script that does the following: --- snip --- mysql -e SELECT * from table_name limit 1 db 2/tmp/filename x=`cat /tmp/filename` if [ $x = ] then do_nothing=1 else ## There's an issue! echo ERROR! fi --- end snip --- Using the re-direct of stderr is the key. the 2/tmp/filename sends all error output to the /tmp/filename file. If there are no errors, the file will be empty. I run it as a cron job every ten minutes, and if there is an error, it pages me. Keeps me in the know! -Original Message- From: Sascha Kettner [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 5:53 AM To: [EMAIL PROTECTED] Subject: Watchdog für mysql in Perl? Hi! Short question: i want to have a perl watchdog telling me when executed if my sql-server is running and if anything is allright with it. So if i get any errormessage i can restart the server by remote. Has someone done this allready? Any hint? Thanks again and best regards Sascha Kettner - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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
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
MySQL and Perl for the Web
I've been mildly scolded for not announcing this somewhere, so, on the better late than never principle, here goes. :-) New Riders has published a new book called MySQL and Perl for the Web (by me). It focuses on using MySQL together with the Perl DBI and CGI.pm modules to perform various kinds of Web-related tasks. It's also got some stuff on using mod_perl. The book's home page is at: http://www.kitebird.com/mysql-perl/ where you can also find a pointer to the New Riders listing. That listing provides access to a PDF version of one of the chapters, which you can read to get some idea of what the rest of the book is like. I'll point out that there's a review of the book on Amazon. It's negative. From my point of view, the review is unsatisfactory, not because it's negative, but because it doesn't really say what the reader found wrong with it in any specific manner. That doesn't help me know how it could have been improved. (Feedback that I've received privately has been much more positive.) I should also point out that some of the online booksellers have a table of contents posted that is inaccurate. Specifically, such TOCs list a chapter on XML, but there is no such chapter. (Had one planned, but ran out of time and energy.) -- 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: Where is the MySQL-DBI-perl-bin RPM?
- Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: citizen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 11:57 PM Subject: Re: Where is the MySQL-DBI-perl-bin RPM? citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 for example is one place for it. Evidently not, at least not if by it you mean ftp://ftp.mysql.com/RPMS/i386/Mysql-DBI-perl-bin-1.1825-1.i386.rpm $ rpm -qa | egrep -i '(dbi|mysql)' MySQL-client-3.23.39-1 Mysql-DBI-perl-bin-1.1825-1 MySQL-3.23.39-1 DBI-perl-bin-0.93-1 $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 If I resort to --nodeps to force the installation, the test procedures obviously have no idea where the components of MySQL that are needed to execute the tests are located, so it appears to me that either the information you gave me is not operative or the MySQL testbench RPM resulting from a --rebuild of the MySQL 3.23.39-1 SRPM on SourceForge was not tested. - 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: Where is the MySQL-DBI-perl-bin RPM?
citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 fox example is one place for it. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.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: Where is the MySQL-DBI-perl-bin RPM?
- Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: citizen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 11:57 PM Subject: Re: Where is the MySQL-DBI-perl-bin RPM? citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 for example is one place for it. Excellent. I hope this URL will find its way into above error message. Saves time. Thank you. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.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: Where is the MySQL-DBI-perl-bin RPM?
- Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: citizen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 11:57 PM Subject: Re: Where is the MySQL-DBI-perl-bin RPM? citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 for example is one place for it. Evidently not, at least not if by it you mean ftp://ftp.mysql.com/RPMS/i386/Mysql-DBI-perl-bin-1.1825-1.i386.rpm $ rpm -qa | egrep -i '(dbi|mysql)' MySQL-client-3.23.39-1 Mysql-DBI-perl-bin-1.1825-1 MySQL-3.23.39-1 DBI-perl-bin-0.93-1 $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 If I resort to --nodeps to force the installation, the test procedures obviously have no idea where the components of MySQL that are needed to execute the tests are located, so it appears to me that either the information you gave me is not operative or the MySQL testbench RPM resulting from a --rebuild of the MySQL 3.23.39-1 SRPM on SourceForge was not tested. -- Maximize end-user autonomy. - 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
Where is the MySQL-DBI-perl-bin RPM?
$ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? Thank you. - 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
Where is the MySQL-DBI-perl-bin RPM?
$ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? Thank you. - 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: Good book for MySQL and Perl DBI?
Paul DuBois' Book. it is extremely well written and indexed. I've gone from a complete mysql bumbler to somebody that can actually make it work in a short time thanks to his book. Chris On Sat, 23 Jun 2001 16:40:04 -0500, Chris Petersen wrote: Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Just realizing that there's so much out there that I haven't been told... -Chris - 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: Good book for MySQL and Perl DBI?
Actually, a new book by Paul is to be published MySql and Perl for WWW. Gonna be a great one. (to be published on August 13th) -- sherzod_ruzmetov (sherzodR) email: [EMAIL PROTECTED] It really doesn't bother me if people want to use grep or map in a void context. It didn't bother me before there was a for modifier, and now that there is one, it still doesn't bother me. I'm just not very easy to bother. -- Larry Wall in [EMAIL PROTECTED] Sent on Jul 2 by Chris Worth to Chris Petersen and MYSQL caw caw Paul DuBois' Book. caw caw it is extremely well written and indexed. I've gone from a complete mysql bumbler to caw somebody that can actually make it work in a short time thanks to his book. caw caw caw Chris caw caw caw On Sat, 23 Jun 2001 16:40:04 -0500, Chris Petersen wrote: caw caw Does anyone have any recommendations for a good book on MySQL SQL? What caw about PerlDBI (I noticed that the O'Reilly one is over a year old)? caw caw Just realizing that there's so much out there that I haven't been told... caw caw -Chris caw caw caw - caw Before posting, please check: cawhttp://www.mysql.com/manual.php (the manual) cawhttp://lists.mysql.com/ (the list archive) caw caw To request this thread, e-mail [EMAIL PROTECTED] caw To unsubscribe, e-mail caw [EMAIL PROTECTED] caw Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php caw caw caw caw caw - caw Before posting, please check: cawhttp://www.mysql.com/manual.php (the manual) cawhttp://lists.mysql.com/ (the list archive) caw caw To request this thread, e-mail [EMAIL PROTECTED] caw To unsubscribe, e-mail [EMAIL PROTECTED] caw Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php caw - 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: Good book for MySQL and Perl DBI?
Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Just realizing that there's so much out there that I haven't been told... -Chris Paul Dubois and New Riders are releasing 'MySQL and Pearl for the Web'. If that's what you're interested in, the book is due at the end of July. There's a little information about the book at www.newriders.com. I'm going through a review copy and it looks pretty good. The publisher said that I could say that. :) Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - 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: Good book for MySQL and Perl DBI?
At 5:38 PM -0400 6/24/01, Bob Hall wrote: Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Just realizing that there's so much out there that I haven't been told... -Chris Paul Dubois and New Riders are releasing 'MySQL and Pearl for the Web'. If that's what you're interested in, the book is due at the end of July. There's a little information about the book at www.newriders.com. I'm going through a review copy and it looks pretty good. The publisher said that I could say that. :) Yes, but publishers will always be in favor of people saying their books are good. :-) The book's not out yet, as Bob says, but the code used for examples in the book is available now, at: http://www.kitebird.com/mysql-perl/ Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database -- 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
Good book for MySQL and Perl DBI?
Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Just realizing that there's so much out there that I haven't been told... -Chris - 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: Good book for MySQL and Perl DBI?
Mysql by Paul Dubois, New Riders publisher, is strongly recommended. Get the perldoc on dbi and dbd. terse, but up to date. other reading are: cgi programming 101 by jacqueline hamilton. basic information. well presented. with examples that work. very broad, very shallow. of course the camel book, Programming perl, larry wall, tom christiansen and jon orwant, o'reilly, 3rd ed. with these books and the internet, you will find a wealth of information. ciao At 04:40 PM 6/23/01 -0500, you wrote: Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Just realizing that there's so much out there that I haven't been told... -Chris - 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 -- tom marlin [EMAIL PROTECTED] fax / voice mail: 714 507 3802 ext 4881 Never be afraid to try something new. Remember that - amateurs built the ark. - professionals built the Titanic.
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
MySQL with perl
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
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
MySQL-DBI-perl-bin , error
Hi, Thx Rolf for your help I did setup the password Now, I have installed the RPM called mysql-DBI-perl-bin...rpm But when I want to install the MySQL-bench...rpm it asks me for the MySQL-DBI-perl..rpm Can someone tell me how to solve this probem? thx JP __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.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
RPM dependency on MySQL-DBI-perl-bin
Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because of a MySQL-DBI-perl-bin dependency. Does anyone know what this is(RPM?or Perl Mod?), and where i can find it?Ive been looking, but no luck yet. Thanks!jason _ Get your FREE download of MSN Explorer at http://explorer.msn.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: RPM dependency on MySQL-DBI-perl-bin
Hi: I believe MySQL-bench uses Perl program to benchmark databases so that it requires Perl-DBI. DBI is a Perl module that provides API for database connection. I have never installed Perl modules in RPM format but you should be able to find it on RedHat ftp server. And I think the name 'MySQL-DBI-perl-bin' is somewhat misleading because DBI is not tied to any specific databse. DBI module provides general API for databse handling and for MySQL, you also need DBD-MySQL module. Anyway, unless you have a real need of benchmarking MySQL, why bother installing it? Seung-woo Nam Jason Feingold wrote: Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because of a MySQL-DBI-perl-bin dependency. Does anyone know what this is(RPM?or Perl Mod?), and where i can find it?Ive been looking, but no luck yet. Thanks!jason _ - 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: RPM dependency on MySQL-DBI-perl-bin
Dear Jason - Jason Feingold writes: Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because of a MySQL-DBI-perl-bin dependency. Using the RPM mechanism to install perl modules is fraught with problems. Don't use it; you'll be sorry you did in the long run. But, fear not there is a good solution to your problem. The perl community has developed a solution analogous to RPM called cpan. There is a cpan module that is most likely already installed on your system. You can confirm that by typing 'perl -e use CPAN; ' (without the single quotes) at the command line. If you don't get any wierd error messages you already have the cpan module. (If you don't have it you can download it, and zillions of others, at www.cpan.org. Now that you've got CPAN.pm you can type 'perl -MCPAN -e shell' and follow the reasonably intuitive interactive prompts. There's also documentation available by typing 'perldoc CPAN'. The commands you're going to end up typing in the end are: cpan i /mysql/ cpan install Bundle::DBD::mysql cpan i /dbi/ cpan install Bundle::DBI The cpan tool is built specifically for perl and you will get a more robust install by using it for perl modules. Let me warn you that I haven't installed these modules in a while and you may find that there are C dependencies that I'm forgetting that aren't handled well. If you have problems just write again and I or someone else will be happy to help. Yours - Billy - 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
Problem in connecting to mysql using perl
Dear Sir, I have downloaded DBI-1.15. I tried installing it. The tests failed. I am using PMAKE to prepare an install program. The error is as follows: can't locate loadable object for module DBI in @INC. I am also providing you with the procedure i adopted to install DBI step 1: I checked my perl version. It is active-state perl 5.6.0 step 2: I gave the command pmake makefile.pl err:can't 'MAKE', - no target makefile.pl at Make.pm line 1164. step 3: On command pmake pro: Reading Make.pm Reading /..makefile ... err: The name specified is not recognized as an internal or an external command, operable program or batch file. step 4: On command pmake test pro: Reading Make.pm Reading /..makefile ... err: The name specified is not recognized as an internal or an external command, operable program or batch file. Please tell me where I am wrong. Is there any setup kit, so that I can install the DBI module easily. With this, I also request you to give a suggession to connect to mySQL without using DBI. Can I connect to mySQL database using win32::ODBC. If yes, please give me code details on how to connect using this. waiting for a positive response, -harish
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
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 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
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. I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-13.tar.gz. Can any one help Gordon [gordon@fido gordon]$ cd Msql-Mysql-modules-1.2213 [gordon@fido Msql-Mysql-modules-1.2213]$ perl Makefile.PL Which drivers do you want to install? 1)MySQL only 2)mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2) 4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2 Enter the appropriate number: [3] 1 Do you want to install the MysqlPerl emulation? You might keep your old Mysql module (to be distinguished from DBD::mysql!) if you are concerned about compatibility to existing applications! [n] Where is your MySQL installed? Please tell me the directory that contains the subdir 'include'. [/usr] Which database should I use for testing the MySQL drivers? [test] On which host is database test running (hostname, ip address or host:port) [localhost] 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/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/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/i386-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/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/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/i386-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/gcc-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 -MExtUtils::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 - 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
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
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
MYSQL using PERL
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
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
MySQL-DBI-perl-bin
Hello guys Does anyone know where I can get the MySQL-DBI-perl-bin RPM distribution (version 3.23.17-1.i386). I'm running a RH6.0 box. Thanks a lot *Wilmar Prez * IT Department * Libraries System *University of Antioquia *tels: +(57)4 2105145 *+(57)3 4612166 * Medelln - Colombia - 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