mysql through dbi problem
I'm having some serious trouble. I'm running a query and getting the
data, but having problems using that data in the next query. Thus:
$sth = $dbh->prepare
( "select distinct hmac, hport, hsid from netdata_history" );
( undef, \$hmac, \$hport, \$hsid );
while ( ( $hmac, $hport, $hsid ) = $sth->fetchrow_array )
push @hsid, $hsid;
push @hport, $hport;
push @hmac, $hmac;
#now cycle through result set in next query
...MySQL DBI Problem.
I have a Perl cron job that reads emails off a pop server once a minute
and stores them in a MySQL database on a remote machine. I logged onto
the MySQL server today and performed a select * from messages where
received > 20030322000000; Zero records were returned.
I did some more investigating and discovered that no records had been
inserted in 4 days. I performed a "flush tables" (Someone suggested
it, I don't know what it does) command and the records were still
missing, but suddenly the Perl cron job on the other machine, without
any changes, was po...DBI and mySQL problems
First, sorry for the wrap on the lines below, and my apologies if this
message has been seen already- I appear to be having problems sending
to nntp.perl.org (I didn't realise you had to be subscribed to
email@example.com to send).
I am trying to insert some values into a mySQL database, all of the
scalars below have a value(none are undefined). I keep getting errors
similar to the one below and despite being instructed to read the mySQL
manual, I cannot find anything that relates to the problem I'm
Is the problem with my Perl (likely), or mySQL?
C...MySQL DBI problem
I am trying to read email off a mail server using perl, parse it, and
then store the fields in a MySQL database. I managed to write the
first two parts in a couple of days, but now I've spent two weeks
trying to get the fields into a the "Messages" database. I have got
several fields to go in and then I ran the same script the next day
with no changes and it wasn't working any longer.
I have run into about every problem imaginable and I c...Severe DBI-Oracle DBI-ODBC Problem
Content-Type: text/plain; charset="US-ASCII"
Emergency assistance - This should never be so difficult! ?
All day working switching between the 2 activestate binary installation
versions from activestate site &amp; DBD/DBI versions.&nbsp; No headway
to oracle via perl DBI.&nbsp; Windows 2k - new system. Everything newly
installed for this PC.&nbsp; I do not see an activestate 6.xx binary at the
activestate site ?&nbsp;&nbsp; Uninterested...[perl5-dbi/DBI-Test] a2d1b2: create separate tests for DBI and DBI::Mock ...
Date: Wed, 31 Jul 2013 10:17:25 -0700
Author: Jens Rehsack <firstname.lastname@example.org>
Date: 2013-07-31 (Wed, 31 Jul 2013)
Changed ...POSSIBLE BUG IN Win32 DBI INSTALL MODULE: DBI "prepare" no work FW: List 'dbi-users' closed to public posts
I have ActiveState Win32perl running. I installed fresh DBI, DBD, etc. from
perl ppm.pl> prompt. But prepare( ) doesn't work (see below). perldoc
DBI/DBD/DBI-FAQ are not useful since they assume it works. Any hints?
recently charted above Madonna
From: Art Sulit [mailto:email@example.com]
Sent: Saturday, January 20, 2001 1:51 PM
Subject: POSSIBLE BUG IN YOUR DBI INSTALL MODULE: DBI "prepare" no work
THERE IS A POSSIBLE BUG IN YOUR DBI INSTALL M...timestamp problem with mysql and dbi
I have a simple table as follow:
mysql> describe mytest1;
| Field | Type | Null | Key | Default | Extra |
| mytime | timestamp(6) | YES | | NULL | |
| abc | varchar(8) | YES | | NULL | |
if I insert record by perl script with statement like this:
my $sth = $dbh->prepare("insert into mytest1 values (\"011011\",\"test\")") or die "Can&...Problem with DBI and MySQL Installation??
I have installed DBI and the DBD for MySql. I can't remember it very well, but I
think I got some error messages when doing 'make test' during the installation
Now, I can use DBI and when asking it for the available drivers, the driver for
my sql appears in the list.
However, when trying to connect to a mysql database I get the following message:
ld.so.1: /opt/perl5.6.1/bin/perl: fatal: relocation error: file
mysql_init: referenced symbol not found
Any id...DBI installation problem with DBI 1.20 on linux
Content-Type: TEXT/PLAIN; charset=US-ASCII
perl 5.6.1 (output of perl -V attached)
Perl works fine (insofar as I've tested it with a few scripts), and I
originally tried to install DBI from CPAN:
perl -MCPAN -e shell
shell%> install DBI
but it didn't take; I can't remember the errors.
Then I downloaded the source (DBI-1.20.tar.gz) and tried to compile it,
after of course reading the README's and looking at the documentation.
'perl Makefile.PL' and 'make' went ok, but 'ma...[perl5-dbi/dbi]
Date: Fri, 05 Apr 2013 01:45:43 -0700
...MySQL DBI on Windows problem
I'm having a problem on Windows 2k where I have a pair of scripts where
the parent forks off a few processes (a second perl script) which does
some database input for a period of time, and then returns to the
parent. Upon the return to the parent however, I can no longer do a
$sth->execute() call. When I attempt to do so, it hangs and I get no
Trying to run the same scripts on Windows ME with the same perl
installation I get the following error in a dialog box:
Perl has caused an error in MSVCRT.DLL. Perl will now close.
That file contains the run...Still having problems with DBI and MySQL.
I upgraded to MySql v 3.23.47, DBI-1.18, Data-ShowTable-3.3 all of which
compiled with out any problems.
BUT when trying to compile Msql-Mysql-modules-1.2216. I am getting the
same error as I got when I ran my perl test script last time:
[localhost:~dwalker/src/MySQL/Msql-Mysql-modules-1.2216] root# perl
dyld: perl Undefined symbols:
The database is running fine and I even managed to figure out how to
back up and restore my little test database while upgrading.
I am wandering if I should up...DBI/ Mysql DBD problem
I am having trouble setting up a working DBI/ Mysql DBD installation.
I get the following error on all of my test scripts:
ld.so.1: /usr/bin/perl: fatal: relocation error: file
symbol mysql_init: referenced symbol not found
I cannot find a solution to this problem on any FAQ's, so if you know
how I can solve this one then please let me know.