Re: [Failed on test 761, perl mysql-test-run.pl]

2010-09-13 Thread Joerg Bruehe
Courtney, this happens because you acted against a sacred Unix commandment: "Thou shalt not work as 'root' user unless absolutely necessary." In particular, you should not run a database system as the root user. Courtney Waller wrote: > [[...]] > From: root > [[...]] > main.in

[Failed on test 761, perl mysql-test-run.pl]

2010-09-11 Thread Courtney Waller
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: mysql@lists.mysql.com Subject: [Failed on test 761, perl mysql-test-run.pl] >Description

Re: Perl & MySQL

2006-02-18 Thread Pooly
2006/2/18, Mike Blezien <[EMAIL PROTECTED]>: > Hello, > > MySQL version: 4.1.10a > > we are getting this error when attempting to connect to our MySQL database: > > install_driver(mysql) failed: Can't load > '/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' > for mo

Perl & MySQL

2006-02-18 Thread Mike Blezien
Hello, MySQL version: 4.1.10a we are getting this error when attempting to connect to our MySQL database: install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared

RE: perl/mysql issue...

2005-05-04 Thread bruce
Kristen G. Thorson [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 8:21 AM To: [EMAIL PROTECTED] Subject: Re: perl/mysql issue... Bruce, You can't issue SHOW SLAVE STATUS because you only have permissions on the livejournal database. Try this: as root or someone with sufficient p

RE: perl/mysql issue...' (Using password: NO)'

2005-05-03 Thread bruce
ECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of bruce Sent: Tuesday, May 03, 2005 10:53 AM To: perl-win32-users@listserv.ActiveState.com; mysql@lists.mysql.com; 'Nikolas Coukouma' Subject: perl/mysql issue... hi... i have the following issu

Re: perl/mysql issue...

2005-05-03 Thread Michael Stassen
bruce wrote: The problem is in your code, not your db. hi... i have the following issue.. i've researched it from google.. but i still can't quite figure it out... i'm using a test app with DBI->connect() and i'm getting the following response... (print/debug statements...)

Re: perl/mysql issue...

2005-05-03 Thread Chris Wagner
At 10:52 AM 5/3/05 -0700, [EMAIL PROTECTED] wrote: >'DBD::mysql::db selectrow_hashref failed: Access denied for user: >'[EMAIL PROTECTED]' (Using password: NO) at /var/www/html/cgi-bin/DBI/Role.pm >$ mysql -uroot -p >mysql> CREATE DATABASE livejournal; >mysql> GRANT ALL PRIVILEGES ON livejournal.*

perl/mysql issue...

2005-05-03 Thread bruce
hi... i have the following issue.. i've researched it from google.. but i still can't quite figure it out... i'm using a test app with DBI->connect() and i'm getting the following response... (print/debug statements...) -- 'bd ds

Re: Perl/mysql question

2003-07-30 Thread Octavian Rasnita
those warnings? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "Howell, Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 6:38 PM Subject:

Re: Perl/mysql question

2003-07-30 Thread Joel Fentin
Howell, Scott wrote: Has anyone written a perl script to get records from another database and write it to a file on mysql's LOAD DATA INFILE format? I just need some pointers in perl so a LOAD DATA INFILE will be read correctly. For example, a perl script: Select * from emp from a Progress databa

RE: Perl/mysql question

2003-07-30 Thread Dan Muey
> Has anyone written a perl script to get records from another > database and write it to a file on mysql's LOAD DATA INFILE > format? I just need some pointers in perl so a LOAD DATA > INFILE will be read correctly. You might want to check out Perl's DBI module at search.cpan.org I use that a

Perl/mysql question

2003-07-30 Thread Howell, Scott
Has anyone written a perl script to get records from another database and write it to a file on mysql's LOAD DATA INFILE format? I just need some pointers in perl so a LOAD DATA INFILE will be read correctly. For example, a perl script: Select * from emp from a Progress database Will write to a te

Re: what is wrong with this perl mysql code?

2003-03-04 Thread Paul DuBois
At 17:11 -0500 3/4/03, Jianping Zhu wrote: I am writing a simple login system by using perl( this is almost my first program in perl), After user pick a username i need to check if this username already exsited in mysql database table. if it is already in the table, this program will prompt user t

Re: what is wrong with this perl mysql code?

2003-03-04 Thread Joshua J . Kugler
You need quotes around $username in your SQL query, unless you've already run $username thorough $dbh->quote(); j- k- On Tuesday 04 March 2003 13:11, Jianping Zhu wrote: > I am writing a simple login system by using perl( this is almost my first > program in perl), After user pick a user

what is wrong with this perl mysql code?

2003-03-04 Thread Jianping Zhu
I am writing a simple login system by using perl( this is almost my first program in perl), After user pick a username i need to check if this username already exsited in mysql database table. if it is already in the table, this program will prompt user to pick another user name. but something

perl, MySQL, and Lost Connection while executing error!

2003-01-05 Thread Alan
Hey everyone I just joined this group today with an error that has been plaguing me for the past 2 weeks and I can't figure out what's wrong!! What's happening is I'll start up my perl program and sometimes, for no apparent reason, I will get the Lost Connection to MySQL Server while executing quer

Sorta OT: Perl/MySQL Mail List Module?

2002-11-18 Thread Will K.
Greetings, This may be a bit OT, but does anyone know of a good perl/cgi module that works with DBI (MySQL) to write a mailing list? PLMK, Thanks, Will _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.ms

Perl & MySQL installed with rpm's vs binaries combination

2002-10-03 Thread Chris Becker
Perl was installed from my RedHat 6.2 install media, I remember a problem of installing MySQL using the binaries would cause conflicts with a rpm installed Perl. That is what someone in this newsgroup told me about a year ago. Is this true? I couldn't get the MySQL to install with the RPM's.

Re: Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

2002-06-11 Thread Tonu Samuel
On Tue, 11 Jun 2002, Keith Smith (E-mail) wrote: > The system: a perl mailing list tool which accepts add/deletes via > emails (sendmail piped) and then updates the backend database > accordingly. > > The problem: once about 10 or more emails arrive, I begin to get > performance problems from t

Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

2002-06-11 Thread Keith Smith \(E-mail\)
Hi: I'm hoping you can lend some helping thoughts The system: a perl mailing list tool which accepts add/deletes via emails (sendmail piped) and then updates the backend database accordingly. The problem: once about 10 or more emails arrive, I begin to get performance problems from the Linu

Re: Perl-Mysql manual (.chm version)

2002-05-10 Thread Paul DuBois
; anyone know any manual about for perl-mysql? Better if would be .chm >> > version. Thanks. >> > >> > -Onder >> >> Not online, but the book "MySQL and Perl for the Web" by John Dubois is >> excellent. >> New Riders ISBN:0-7357-1

Re: Perl-Mysql manual (.chm version)

2002-05-10 Thread Jeremy Zawodny
On Fri, May 10, 2002 at 08:32:17PM -0400, Amer Neely wrote: > > I use Perl, Php, mysql for my applications. I have a great manual for php > > for mysql processes. But i do not know any manual for perl yet. Does > > anyone know any manual about for perl-mysql? Better if would b

Re: Perl-Mysql manual (.chm version)

2002-05-10 Thread Amer Neely
> I use Perl, Php, mysql for my applications. I have a great manual for php > for mysql processes. But i do not know any manual for perl yet. Does > anyone know any manual about for perl-mysql? Better if would be .chm > version. Thanks. > > -Onder Not online, but the book &

Re: Perl-Mysql manual (.chm version)

2002-05-10 Thread Colin Faber
Hi see perldoc DBI and perldoc DBD::mysql (search.cpan.org) Onder Hazaroglu wrote: > > I use Perl, Php, mysql for my applications. I have a great manual for php > for mysql processes. But i do not know any manual for perl yet. Does > anyone know any manual about for perl-mysq

Perl-Mysql manual (.chm version)

2002-05-10 Thread Onder Hazaroglu
I use Perl, Php, mysql for my applications. I have a great manual for php for mysql processes. But i do not know any manual for perl yet. Does anyone know any manual about for perl-mysql? Better if would be .chm version. Thanks. -Onder

Re: Perl - mysql

2002-03-04 Thread Son Nguyen
--- Horváth_Szabolcs <[EMAIL PROTECTED]> wrote: > Hello everyone! > > I would like to use my mysql server via Perl. > Does anyone send me links or documents about it? > Thanks > Szabolcs I am using DBI module in Perl to connect to mySQL database. More information can be found at the below lin

Perl - mysql

2002-03-04 Thread Victoria Reznichenko
Horváth, Monday, March 04, 2002, 9:51:05 AM, you wrote: HS> Hello everyone! HS> I would like to use my mysql server via Perl. HS> Does anyone send me links or documents about it? Look at Perl DBI interface. You can read more about it here: http://www.mysql.com/doc/P/e/Perl.html You can do

Perl - mysql

2002-03-03 Thread Horváth Szabolcs
Hello everyone! I would like to use my mysql server via Perl. Does anyone send me links or documents about it? Thanks Szabolcs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

Re: perl mysql DBI::db question

2002-02-28 Thread Paul van den Berg
Shon wrote > i am trying to write a program in perl and am getting a mysql error from my > module. here is the error: > > DBI::db=HASH(0x294738)->disconnect invalidates 1 active statement handle > (either destroy statement handles or call finish on them before > disconnecting) at ./pop.pl line 12

Re: perl mysql DBI::db question

2002-02-27 Thread Shon Stephens
Message - From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> To: "Shon Stephens" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 11:32 AM Subject: Re: perl mysql DBI::db question Try moving your $dbh->disconnect call afte

Re: perl mysql DBI::db question

2002-02-27 Thread Mike(mickalo)Blezien
On Wed, 27 Feb 2002 10:40:21 -0600, "nickg" <[EMAIL PROTECTED]> wrote: >> >>You need to tell the handler you are finished with your statement, this will >>free resources, etc.. >> >>http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish >> >> >>$sql_check->finish; EXTREMELY out-dated! MySQL

RE: perl mysql DBI::db question

2002-02-27 Thread nickg
inish; $dbh->disconnect; if($debug_state) { print "S: $t_user,$t_password,$t_prefs\n"; } nickg -Original Message- From: Shon Stephens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 10:08 AM To: [EMAIL PROTECTED] Subject: per

Re: perl mysql DBI::db question

2002-02-27 Thread Mike(mickalo)Blezien
Try moving your $dbh->disconnect call after it prints out the fetchrow_array() my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array(); if($debug_state) { print "S: $t_user,$t_password,$t_prefs\n"; } $dbh->disconnect(); If your using an older version of DBI, like 1.13 or

perl mysql DBI::db question

2002-02-27 Thread Shon Stephens
i am trying to write a program in perl and am getting a mysql error from my module. here is the error: DBI::db=HASH(0x294738)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at ./pop.pl line 124, line 2." i think a

Re: [Chicago.pm]: Perl MySQL OO design question

2001-09-10 Thread Andy Lester
> I have a perl->DBI->MySQL database app. that handles everything from my > order entry to my accounts payable. I am in the process of cleaning up > a lot of the code I've written to make it easier to maintain. I > probably use the following DBI staement handle about fifty different > places on

Re: Perl MySQL OO design question

2001-09-10 Thread Adams, Bill TQO
Richard Reina wrote: > I have a perl->DBI->MySQL database app. that handles everything from my > order entry to my accounts payable. I am in the process of cleaning up > a lot of the code I've written to make it easier to maintain. I > probably use the following DBI staement handle about fifty

Perl MySQL OO design question

2001-09-10 Thread Richard Reina
I have a perl->DBI->MySQL database app. that handles everything from my order entry to my accounts payable. I am in the process of cleaning up a lot of the code I've written to make it easier to maintain. I probably use the following DBI staement handle about fifty different places on differ

Re: Perl MySQL Interface

2001-04-12 Thread Mark Rowlands
IL PROTECTED]] > Sent: Wednesday, April 11, 2001 3:59 PM > To: [EMAIL PROTECTED] > Subject: Perl MySQL Interface > > > I have installed MySQL 3.23 on RedHat 7 using the rpms. > Installing the bench rpm gives "MySQL-DBI-perl-bin is needed > by MySQL-bench-3.23.36-1"

RE: Perl MySQL Interface

2001-04-11 Thread Chris Becker
] === -Original Message- From: Brian Cassidy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 3:59 PM To: [EMAIL PROTECTED] Subject: Perl MySQL Interface I have installed MySQL 3.23 on RedHat 7 using the rpms. Installing the bench rpm gives "MySQL-DBI-perl-bin is needed by MySQL-bench-3.

Perl MySQL Interface

2001-04-11 Thread Brian Cassidy
I have installed MySQL 3.23 on RedHat 7 using the rpms. Installing the bench rpm gives "MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.36-1". I can't seem to locate any version of this dbi which will install. I see that mysql.com has a perl dbd module for MySQL but that is not an rpm. Is that wh

Re: Perl-MySql DBD Errors

2001-04-04 Thread B. van Ouwerkerk
>Msql-Mysql-modules-1.2215.tar. For the life of me I can't find the >mysql.h file that it keeps asking for? Any ideas where this is...is it >a bug with this version. Type find -name mysql.h I found mine (MySQL 3.23.36) in /usr/local/mysql/include Sometimes it helps to use a very basic method

RE: Perl-MySql DBD Errors

2001-04-04 Thread Ravi Raman
ECTED]] Sent: Wednesday, April 04, 2001 3:24 PM To: [EMAIL PROTECTED] Subject: Perl-MySql DBD Errors Hello, I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the Mysql version that came on the redhat cd's. Perl and the Perl DBI are installed and working correctly. MySq

Re: Perl-MySql DBD Errors

2001-04-04 Thread Peter Skipworth
Eric, Download the source tarball for mysql from the website and reinstall using that - the necessary include files do not come with the redhat rpm. regads, P On Wed, 4 Apr 2001, Eric Fegraus wrote: > > Hello, > > I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the > M

Perl-MySql DBD Errors

2001-04-04 Thread Eric Fegraus
Hello, I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the Mysql version that came on the redhat cd's. Perl and the Perl DBI are installed and working correctly. MySql seems to be working correctly as well(i.e. no problems with permissions, created db's, tables, etc). Howe

RE: Off Topic Perl Mysql modules install problem

2001-03-07 Thread Robin Keech
March 2001 16:55 To: MySQL List Subject: Off Topic Perl Mysql modules install problem Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux /2.9 6" cc -o ../bli

Re: Off Topic Perl Mysql modules install problem

2001-03-07 Thread Gerald L. Clark
Curtis Maurand wrote: > > Hello, > I'm now lost. I cannot figure out what the make file is looking for. Anyone have >any ideas? > > LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 > 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdi

Re: Perl/mysql.

2001-03-06 Thread Gerald L. Clark
N Sikkandar Dulkarnai wrote: > > Hello there, > > I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How >do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some >one can send some basic structure of connecting into sql using perl and

Off Topic Perl Mysql modules install problem

2001-03-06 Thread Curtis Maurand
Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L

Perl/mysql.

2001-03-03 Thread N Sikkandar Dulkarnai
Hello there, I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some one can send some basic structure of connecting into sql using perl and some useful links. Thanks in advance.