Hello gurus, I am trying to install the perl-DBD-MySQL and each time I get this
error message. Any ideas? I have tried it on a Sun X4150 (Dual Quad Cored
Intel) and a Sun X4200 (Dual Dual Core Opteron) both on CentOS 4.8. I have
tried to install and build with MySQL 4.x on the box
Nunzio,
Nunzio Daveri wrote:
Hello gurus, I am trying to install the perl-DBD-MySQL and each time I get
this
error message. Any ideas? I have tried it on a Sun X4150 (Dual Quad Cored
Intel) and a Sun X4200 (Dual Dual Core Opteron) both on CentOS 4.8. I have
tried to install and build
mysql.xs:653: warning: ignoring return value of `Perl_newSVpv', declared with
attribute warn_unused_result Running Mkbootstrap for DBD::mysql () chmod 644
mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH=/usr/local/lib/mysql /usr/bin/perl myld cc -shared
-L/usr/local/lib dbdimp.o
', declared with
attribute warn_unused_result Running Mkbootstrap for DBD::mysql () chmod 644
mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH=/usr/local/lib/mysql /usr/bin/perl myld cc -shared
-L/usr/local/lib dbdimp.o mysql.o -o blib/arch/aut
o/DBD/mysql/mysql.so\
-L/usr/local
() chmod 644 mysql.bs rm -f
blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/usr/local/lib/mysql
/usr/bin/perl myld cc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/aut
o/DBD/mysql/mysql.so\
-L/usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm \
/usr/bin/ld: /usr/local/lib
of `Perl_newSVpv',
declared with attribute warn_unused_result Running Mkbootstrap for
DBD::mysql () chmod 644 mysql.bs rm -f
blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/usr/local/lib/mysql
/usr/bin/perl myld cc -shared -L/usr/local/lib dbdimp.o mysql.o -o
blib/arch/aut
o/DBD/mysql/mysql.so
Yes .. and had to add it to jpeg-6b (on x86_64) to make that
work too.
Patrick Galbraith wrote:
Niels Larsen wrote:
Niels,
Do you mean in the Makefile for zlib?
Thanks!
Patrick
Connie,
I had the same error with another program recently, but probably the
fix for yours is the same: try
Solved --
After upgrading to 5.0.22, DBD::mysql builds without any problems.
-Original Message-
From: Tim Lucia [mailto:[EMAIL PROTECTED]
Sent: Monday, June 19, 2006 4:17 PM
To: mysql@lists.mysql.com
Subject: Mysqlhotcopy / Perl / DBD::mysql on RHEL 4 x86_64
I'm running on a Xeon 3.8
I'm running on a Xeon 3.8 under RHEL V.4. I wanted to try out mysqlhotcopy,
but it says I need DBD::mysql. Cpan gets it for me, but make DBD::mysql
dies with the below error. I am using 5.0.18 standard
(MySQL-server-standard-5.0.18-0.rhel4). Attempting to install
perl-dbd-mysql off the RPMS
hello,
thank you for info.
but i want one graphics tool which is free.
i m using perl and mysql.
i am also searching for the graphics tool which i can use for the data in
mysql table or the output by my perl program.
if anyoneknow abt this please do reply
Just go to http://dbi.perl.org/
You will need to download DBI and DBD::Mysql. Then you could install it manually,
even no need to run the CPAN shell.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
This is the 3rd time you have asked this.
Perhaps you should take it to a perl list where it belongs.
Kirti S. Bajwa wrote:
Hello:
I am trying to install Perl support with MySQL. After installing MySQL
(v4.0.20)I run the following commands:
% echo $PATH
% perl -MCPAN -e shell
Hello:
I am trying to install Perl support with MySQL. After installing MySQL
(v4.0.20)I run the following commands:
% echo $PATH
% perl -MCPAN -e shell
Note: Answer no to auto-configure perl.
cpan install Data::Dumper
(Upto this point. Following commands
Hello:
I am trying to install Perl support with MySQL. After installing MySQL
(v4.0.20)I run the following commands:
% echo $PATH
% perl -MCPAN -e shell
Note: Answer no to auto-configure perl.
cpan install Data::Dumper
(Upto this point. Following commands
before I begin sorry for the cross post but i'm desperate
The routine in question is below. It's pretty straight forward its a series of loops
which basically matches the row then dumps data stored in hash ref into the DB. for
some reason the script runs with no errors (ran with strict) I can
At 15:02 -0700 5/5/04, [EMAIL PROTECTED] wrote:
before I begin sorry for the cross post but i'm desperate
The routine in question is below. It's pretty straight forward its a
series of loops which basically matches the row then dumps data
stored in hash ref into the DB. for some reason the
If you want them set to NULL using DBI, you have to bind undef to the
proper parameter. Is that what you're doing, or are you binding
something else, such as 0 or the empty string?
No the initial values in the DB are set to null, with the exception of one field. I'm
trying to assign the
Issue resolved. For anybody else who runs into this problem here is what I did.
1. went to ftp.suse.com and navigated to /pub/suse/9.0/suse/i586.
2. I downloaded zlib-devel-1.1.4-232.i586.rpm
3. rpm -Uvh zlib-devel-1.1.4-232.i586.rpm
4. then I did the perl Makefile.PL, make, make
I am on suse 9.0.
using cpan perl module (perl -MCPAN -e shell)
and install DBD::mysql
obtained the following error:
An error occurred while linking the DBD::mysql
driver. The error message seems to indicate that you
dont have a libz.a or a libza.so
Can anybody suggest a possible fix?
Aleksei Wolff wrote:
I am on suse 9.0.
using cpan perl module (perl -MCPAN -e shell)
and install DBD::mysql
obtained the following error:
An error occurred while linking the DBD::mysql
driver. The error message seems to indicate that you
dont have a libz.a or a libza.so
Can anybody suggest a
Sorry, Geetika. It looks like I lost this thread in the mix.
Have you tried some Perl like this:
# concurrent.pl
# Check start time.
for my $n (1..$DO_TRIES) {
print qq{Doing # [$n] PID [$$]\n};
my $pid = fork();
if ($pid == 0) {
print qq{Child [$$] running command.\n};
I am trying to make my perl script fork several processes that all execute
'select' statements on MySQL. I want the statements to happen
concurrently (as I want to monitor the behaviour of MySQL with native ISAM
tables under this concurrent Read access). So I am using 'fork'. However,
I think
In the last episode (Nov 25), Geetika Tewari said:
I am trying to make my perl script fork several processes that all
execute 'select' statements on MySQL. I want the statements to
happen concurrently (as I want to monitor the behaviour of MySQL with
native ISAM tables under this concurrent
From: Geetika Tewari [EMAIL PROTECTED]
...perl script fork several processes...
...I think my 'select' statements are not happening concurrently.
Why do you think that?
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
concurrent select statements from perl on MySQL ISAM
tables (fwd)
I am trying to make my perl script fork several processes that all execute
'select' statements on MySQL. I want the statements to happen
concurrently (as I want to monitor the behaviour of MySQL with native ISAM
tables under
Services
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
V: 519.438.5887
Perl | PHP | MySQL | CGI programming for all data entry forms.
We make web sites work!
-
Before posting, please check:
http://www.mysql.com/manual.php
HI all
I'm trying to do the following
---
# want to select (just preparing) every thing from the table PERSON
where i don't know the deptID yet.
$per =
Hello all,
I am currently using perl to import some information into a mysql db. At
this point in time I have two issues:
1. The text files that are being imported contain both english and french
text. My text editor (textpad) gladly displays the text with all proper
hyphens and accentuated
Using apache 1.3.23 for win32
WinXp and Perl 5.6 and Mysql 3.23.44-nt
The localhost test page by apache runs correctly
The perl script runs from the command line, the Browser url line and just
by
clicking it in the dir.
Trying to launch this perl-dbi script from the browser
From: Bob T [EMAIL PROTECTED]
The browser displays a new page which displays the perl source code.
How do I run the perl script from the browser
This means that Apache isn't executing your code, instead he's just reading in the
text of myperlscript and sending it to the browser. You need to
Using apache 1.3.23 for win32
WinXp and Perl 5.6 and Mysql 3.23.44-nt
The localhost test page by apache runs correctly
The perl script runs from the command line, the Browser url line and just by
clicking it in the dir.
Trying to launch this perl-dbi script from the browser, all
I've been having some troubles install dbd::mysql on
Solaris 2.4 - make test is failing and I can't figure
out what is going wrong. The following shows the
results coming back from make test
If anybody can help me out here, I would appreciate
it. Thanks.
make[1]: Entering directory
Hi Darren,
The tests rely on the perl BDB and mysql-modules packages for perl.
Have you installed and tested these?
Ken
- Original Message -
From: Darren Ball [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 10:27 AM
Subject: PERL DBB::MYSQL MAKE TEST PROBLEM
:
Hi Darren,
The tests rely on the perl BDB and mysql-modules
packages for perl.
Have you installed and tested these?
Ken
- Original Message -
From: Darren Ball [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 10:27 AM
Subject: PERL DBB::MYSQL MAKE TEST
colorparam0100,0100,0100/paramHello Jeremy, list,
I asked:
After a select .. insert .. the mysql client returns something like:
Query OK, 11393 rows affected (0.47 sec)
Records: 11393 Duplicates: 0 Warnings: 0
Is it possible in perl/DBI to fetch the count of duplicates and
On Thu, Jan 24, 2002 at 01:48:58PM +0100, Paul van den Berg wrote:
Hello list,
the regular mysql-client returns some useful information after
batch-inserts like:
Query OK, 11393 rows affected (0.47 sec)
Records: 11393 Duplicates: 0 Warnings: 0
I can fetch the number of effected rows
Hello list,
the regular mysql-client returns some useful information after batch-inserts
like:
Query OK, 11393 rows affected (0.47 sec)
Records: 11393 Duplicates: 0 Warnings: 0
I can fetch the number of effected rows in perl/DBI with $sth-rows,
but is it possible to fetch the count of
This is a bit strange, but I was writing code
and adding some select statements that seemed to be
working fine until about the 5 th one, ...
then i get errors :
I am a bit of a newbie at mysql dbi.
any help much appreciated
Error:
Cant set DBI::db-HASH(0x1b73b70-{Printerror}:
-linux /usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl .) at ./tst.pl line 7
-- OTHER INFORMATION ---
Linux, distribution Redhat 7.0
DBI.1.20
DBD-mysql-2.0902
perl v5.6.0
anyone
INFORMATION ---
Linux, distribution Redhat 7.0
DBI.1.20
DBD-mysql-2.0902
perl v5.6.0
anyone experienced a similar problem?
grateful for any information whatsoever...
-
Before
From: Rudy Metzger [EMAIL PROTECTED]
ERROR MESSAGE ---
Can't locate auto/DBI/do.al in @INC...
It sounds like your DBI didn't get built correctly. If you think that it probably was
built right, then you can start by trying to find do.al:
Great. Thanks.
Tim.
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Tim Bunce [EMAIL PROTECTED]
Cc: Nathanial Hendler [EMAIL PROTECTED]; Mysql
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 12:05 AM
Subject: Re: Perl Script: MySQL Slow Query Log
On Wed, Jun 27, 2001 at 01:45:27PM +0100, Tim Bunce wrote:
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
I've submitted a patch against the manual to
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
Tim.
On Mon, Jun 25, 2001 at 11:59:59PM -0700, Nathanial Hendler wrote:
I wrote a perl script that will parse
any idea where any sort of documentation/tutorial can be found?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 1:45 PM
To: Nathanial Hendler
Cc: Mysql; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Perl Script: MySQL Slow Query Log Parser
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
Sorry, not on my server (MySQL 3.22.32).
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
http://www.mysql.com/udmsearch/search.php?q=mysqldumpslow
shows
I wrote a perl script that will parse slow_queries logs, and output some
useful information. It's kind of hard to explain, but I'll try. I wanted to
see what queries were taking a lot of time, and how often they were
happening. I wrote a perl script that parses the log files, ignores
This was a problem originally submitted on msql-mysql-modules:
Under Darwin 1.3.3/PPC G4, using mysql built from mysql-3.23.36+, the perl module
DBD-mysql-2.0901 (and previous versions of DBD::mysql do this as well) returns 0 for
$dbh-{'mysql_insertid'} (return LAST_INSERT_ID from a database
Trying to get text from a CGI textarea box to go into MySQL with the br
line breaks instead on generic \n breaks. Is there an easy way to parse
the var
and make the necessary change?
You can use a Perl regular expression. The following seems to work for me:
# replace line breaks with HTML
A better solution would be to use the DBI quote() function, see the DBI
perldoc for more information.
and FYI 99% of web clients pass CRLF not just LF so you'd need \r\n
Chris Thompson wrote:
Trying to get text from a CGI textarea box to go into MySQL with the br
line breaks instead on
So sprach Jeffrey L. Fitzgerald am Wed, Jun 06, 2001 at 12:08:18AM -0400:
Currently the text coming back from the database is all runs together in
the web browser...
Try nl2br - php.net/nl2br
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to
Trying to get text from a CGI textarea box to go into MySQL with the br
line breaks
instead on generic \n breaks. Is there an easy way to parse the var and
make the necessary change?
Currently the text coming back from the database is all runs together in
the web browser...
I have built a small guestbook using perl and MySQL
when i try to run my perl script i get the following error.
Software error:
[Thu Feb 22 14:38:01 2001] DBI.pm: Can't locate DBI.pm in @INC (@INC
contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005
Hi Thomas
well it may be that the install put it in another directory other than in
the ones listed below
I too am a bit of a beginner with perl and mysql but I found my DBI stuff in
another dir so I used the following in my perl script
use lib "dir/path/here/to/libs";
This tells pe
hey-
If anyone is looking for a freelance web developer check me out. I have
recently become available. We're talking perl/php/mysql/c++/linux and a
bs degreee.
jeff
--
Jeff Saenz ([EMAIL PROTECTED])
Perl/PHP/SQL/Unix Consulting
http://www.planetoid.net
55 matches
Mail list logo