I recently upgraded MySQL to version 5.0.4. After the upgrade,
several of my Perl scripts that access the MySQL database began to fail
with Memory fault coredump messages. Anyone have any suggestions?
I'm hoping a simple DBI::MySQL upgrade will fix this issue. Here is the
Perl
, November 04, 2006 3:54 AM
To: dbi-users@perl.org
Subject: Re: MySQL upgrade caused Perl coredumps...
At 10:35 PM -0600 11/3/06, NIPP, SCOTT V \(SBCSI\) wrote:
I recently upgraded MySQL to version 5.0.4. After the upgrade,
several of my Perl scripts that access the MySQL database began
Judging by this I am already running the latest DBD::MySQL,
though I am about 5 versions behind on the DBI module. I hope all of
this helps.
-Original Message-
From: NIPP, SCOTT V (SBCSI)
Sent: Saturday, November 04, 2006 12:02 PM
To: 'Darren Duncan'; dbi-users@perl.org
Subject: RE: MySQL
I would definitely look to Oracle rather than Perl as your
culprit. I don't have anything to back this up, just a suspicion.
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 10:04 AM
To: dbi-users@perl.org
Subject: switching perl
I am working on a script that parses a csv file. The actual
field delimiters in the file are pipes |. The problem I am running into
is that if the field is empty, then the database is getting a '0' rather
than 'NULL' as it should. The column is setup properly with NULLs
allowed and the
:[EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 10:14 AM
To: NIPP, SCOTT V (SBCSI); dbi-users@perl.org
Subject: RE: NULL field matching problem...
NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] wrote:
I am working on a script that parses a csv file. The actual
field delimiters
D (BRIAN) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 10:54 AM
To: NIPP, SCOTT V (SBCSI); Ronald J Kimball; dbi-users@perl.org
Subject: RE: NULL field matching problem...
I'm guessing that when a field is empty in your CSV file, then the
method $csv-fields puts an empty string
Still banging my head into a wall... Now I am getting NULLs
inserted as expected into the database, but I am getting errors on the
compare.
my @old = $test-fetchrow_array ();
foreach $n (0..20) {
chomp($file_val = $data[$n]);
$file_val =~ s/\s*$//;
I am working on a Perl MySQL problem. Basically, the script
parses a text file and then checks a database table to see if it needs
to be updated. If the entry is NOT in the table, it inserts the entry.
If the entry does exist, it compares the data. Assuming these data is
identical
Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 12:25 PM
To: dbi-users@perl.org
Subject: Insert help...
I am working on a Perl MySQL problem. Basically, the script
parses a text file and then checks a database table to see if it needs
]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Wieland Pusch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 3:17 AM
To: CAMPBELL, BRIAN D (BRIAN)
Cc: NIPP, SCOTT V (SBCSI); dbi-users@perl.org
Subject: Re: Large SQL statements...
Hallo BRIAN,
I like your
I have a database that I am working on a Perl script for to
manage. Basically, this is a database of user accounts on about 80 Unix
boxes. Most of it is working great, but I have one problem with the two
of the INSERTs. The INSERTs are putting data into a history table such
that we can
I am having a problem in that if a field is blank, it is getting
put into the database as a '0' rather than 'NULL'. The table is setup
to both allow NULL values in this field as well as NULL being the
default value. The problem is that on a few entries the field is
actually empty, but
for any feedback.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: S P [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 2:27 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: MySQL data matching
this out.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Steve Baldwin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 4:02 PM
To: 'Reidy, Ron'; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: SQL
I have a table that has a list of users with numeric user IDs.
The user IDs are not sequential. There are large gaps in the list of
numeric IDs. I want to pick the next unused number beginning at 3000.
How do I do this?
Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
08, 2004 3:17 AM
To: CAMPBELL, BRIAN D (BRIAN)
Cc: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: Large SQL statements...
Hallo BRIAN,
I like your solution with foreach and bind_param. Just add the prepare
like this:
$sth = $dbh-prepare(INSERT INTO AllMid_Data VALUES(?.(,? x 21
I have created a database that has a table for the active data,
and a table that basically captures the changes to that table. The
second table has all of the same fields as the first with one extra and
that being to capture a date of the change. I know that I can write a
piece of code
: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 07, 2004 1:18 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Parsing question...
Is there some reason you
PROTECTED]
Sent: Tuesday, September 07, 2004 2:05 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Parsing question...
What i understood from your question is , you want to split strings that
have comma within
quotes. Forgive me if i'm wrong.
If elements of @data are re-split , you can
I know that this question has come up before. I think I have
even asked it long, long ago. Unfortunately, this is not something I do
even infrequently, more like once in a blue moon. The problem is once
again getting DBD::MySQL to compile and play nice on HP-UX. Here are
the errors I
Message-
From: Vinnie Lima [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 12:18 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: DBD driver compile on HP...
Hmm.dont think this is going to help you at all, but i'm getting all
kinds of error on my HPUX 11.00 platform
I know this is not the correct forum for this question, but I figure
someone will know easily enough... I am attempting to use the Perl symlink
command to create/update a link on the Unix server. Below is the syntax I
am using, and not having any luck with. Any help would be most
, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: Basic symlink question...
NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] wrote:
I know this is not the correct forum for this question, but I
figure
someone will know easily enough... I am attempting to use the Perl
symlink
command to create
I am working on a script to gather data about Unix user accounts.
This is going well so far and has gotten us some initial data such as almost
27000 user accounts across about 80 servers. I have built into the script
and database some checking to track changes basically capture these
To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI)
Subject: Re: Strange matching problem...
My comments below as HM. I'll repeat one general suggestion made
previously - use placeholders :)
NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] 01/22/04 01:05PM
I am working on a script to gather data about
;
Thanks again for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 12:46 PM
To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI)
Subject: RE
, January 22, 2004 2:11 PM
To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI)
Subject: RE: Strange matching problem...
You really need to read 'perldoc DBI' (at a command prompt) and pay
attention to how placeholders are used. See below. As Dave Murray
suggested, the Programming the Perl DBI book would
-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 2:07 PM
To: NIPP, SCOTT V (SBCSI)
Cc: Hardy Merrill; [EMAIL PROTECTED]
Subject: RE: Strange matching problem...
On Jan 22, NIPP
I am working on a set of Perl scripts, along with some PHP web
pages, to help organize and automate user account creation in a large HP-UX
environment. I am currently writing a few scripts to gather all of the
existing user account data from every system and populate a couple of
database
: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 10:13 AM
To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI)
Subject: Re: Need some MySQL query help...
You're saying that you have a problem and that you think
-
NIPP, SCOTT V
(SBCSI)
[EMAIL PROTECTED
I was hoping for a little help in troubleshooting a problem I am
having with the DBD-Oracle module (1.14). I have set the ORACLE_HOME
variable and the Makefile creation completes. Once I try to run the make to
actually build the module it dies on me with the following output:
I have run into this problem before, but unfortunately, I can't seem
to figure out what I am doing wrong again this time... I am working on a
script to parse a data file and INSERT/UPDATE this data into a MySQL
database table. I am able to verify that the data I am dealing with is what
I
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 8:25 AM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Fetch without Execute...
On Tue, Oct 14, 2003 at 08:06:30AM -0500, NIPP, SCOTT V (SBCSI) wrote:
I have run
I am working on an application that has a database table with two
repeating fields. The table has several fields that are uniq, and the there
are two fields that occur 6 times i.e. a1, b1, a2, b2, ., a6, b6. This
table is populated and updated from a Perl script that parses a file.
I keep coming up with this error, but I AM performing an execute
prior to the fetch. I have seen some other threads on this, and have
upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a
small portion of the code:
if ($rows2 == 1) {
my $vals =
-fetchrow_hashref ('NAME_lc')) {
undef $set2;
This now includes the other execute. Thanks again.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 11:54 AM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: fetch
I am working on a script to parse a series of text files and insert
or update this data as appropriate into a couple of database tables. I am
stuck at a point with a couple of errors that are just confusing the hell
out of me. I keep going around in circles and I must be missing
I am working on a script to collect system information, and I have
run into a problem I cannot quite figure out. Here is the pertinent section
of code:
my $test = $dbh-prepare(SELECT id FROM fsref WHERE server ='$server' AND
fs_
name = '$fs_name');
$test-execute ();
$rows =
Hey all... I am developing a series of scripts to collect system
information on a fairly large number of HP-UX servers. Initially, this
system information is fairly limited to filesystem information but will be
expanded over time to include other things like kernel parameter settings,
. Thanks.
-Original Message-
From: William Goedicke [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 3:10 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Perl/MySQL script...
Dear Scott et al -
SCOTT == SCOTT V NIPP NIPP writes:
SCOTT I am developing a series
Is it possible to install the Perl DBD for MySQL on a system that
does not have MySQL installed? Basically, I am wanting for numerous servers
to be able to connect and interact with a MySQL database on another server.
Only 2 servers have MySQL installed, none of the others do. how do I
I am not sure if this is a Perl/DBI question specifically or not,
but here goes... I seem to remember reading somewhere that you could return
the value of an auto-increment field during an INSERT operation on a MySQL
database. Is this just wishful thinking on my part or does this sound
:35:20 -0500, NIPP, SCOTT V (SBCSI) wrote:
Hi Scott
Thanks again for all the good feedback. If anyone can recommend
a
good book that could help me out on this I would be most
appreciative. I
have some MySQL reference books, but nothing that really goes into
database
design. I am planning
.
Well, that's about all I can think of at the moment. I am sure that
I will have plenty more questions as this progresses. Thanks again for the
feedback.
-Original Message-
From: andy law (RI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 3:33 AM
To: NIPP, SCOTT V (SBCSI
in the mean time.
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:21 PM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Database layout and query questions...
Some questions, that might help you answer yours:
What's the advantage
This may or may not be obvious... Did you add the -lcl and
-lpthreads as the first in the list of libraries? I have learned from
experience they absolutely have to be the first two in the list in that
order. Also, maybe obvious, you were compiling Perl with the -lcl and
-lpthreads,
with this... I pretty much copied this code
from one of the examples, but I am definitely having a problem. Thanks
again.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 11:12 PM
To: NIPP, SCOTT V (SBCSI); ''Jeff Zucker' '; 'dbi-users
OK... I am stuck once again. I am to pull the data from the
database and export it directly to an Excel file. Now, I am trying to
figure out the formatting... The first problem I am running into is
reformatting dates from the output of MySQL to the desired Excel format.
Here is a same
I have a MySQL database that I have a few Perl scripts working on.
I am now looking into doing some reporting on these database tables. I
would really like to find a script that queries the database and the uses
the Spreadsheet::WriteExcel module to output the data directly to an Excel
if possible. This is also a great learning opportunity and I think that I
will have more requests in the future for generating Excel reports of this
nature.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 10:11 AM
To: NIPP, SCOTT V (SBCSI
I am pretty sure this is supposed to reside in /etc. I know that on
our HP-UX boxes the tnsnames.ora is in /etc and we use Perl for some
database access.
-Original Message-
From: Sridhar Saragu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:24 AM
To: [EMAIL
I have a question about connecting to one of two different FTP
servers. This is a libnet question that I know if off topic, but PLEASE
help me. I have a MySQL database running and I use Perl/DBI to populate the
database. I am using libnet to FTP the data to the server, and then post
Sorry for posting a slightly off topic question, but I am having
trouble figuring out how to do something basic. I have a MySQL database
that has a UNIQUE column in a table. My problem is that I need to change
the column to non-UNIQUE. I cannot figure out how to do this through the
I was able to install DBI, and DBD for MySQL under 11.0, and I will
be doing this under 11i. I am quite suprised that you are having trouble.
Please let us know of your results.
-Original Message-
From: Waldemar Zurowski [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002
Hey guys. I am still quite new to the database world and obviously
in need of help. Not sure if I am just stupid, or if there is really very
little information to be found concerning UPDATE statements. I am working
on a MySQL database with Perl 5.6.0 and the latest DBI version. I am
: Tuesday, April 02, 2002 10:03 AM
To: NIPP, SCOTT V (SBCSI); 'Tielman J de Villiers'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
At 10:50 AM 4/2/2002, NIPP, SCOTT V (SBCSI) wrote:
I added a COMMIT immediately after the UPDATE, and still have the
same problem. Below
Following another suggestion, I tried using the 'qq' quoting method
and received the following error.
DBD::mysql::db do failed: Unknown column 'harry' in 'where clause' at
sys_db_update1.pl line 41, INV line 81.
-Original Message-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL
\';
}
}
Thanks again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: UPDATE Statement Problem...
THe problem with the update statement is that you need a column name
before the value you are setting
it into the
database?!?! Below is the working UPDATE line:
$dbh-do(qq{UPDATE systems SET $set WHERE 'Name = $name'});
Not sure what is wrong now though. :(
-Original Message-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:46 AM
all very much for the
help. Please bear with me, and I will do my best to refrain from being
thick headed. :)
-Original Message-
From: Michael Ragsdale [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:15 AM
To: NIPP, SCOTT V (SBCSI); '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED
-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:47 AM
To: 'Michael Ragsdale'; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
OK. Sorry for my being stupid. Everyone keeps telling me the same
thing, and I must
63 matches
Mail list logo