::Oracle 1.76.
Using DBD::Oracle 1.76.
=========
Please help,
Daniel
--
Daniel Chmielewski
--
Daniel Chmielewski
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
izrt.Mobile: +46 (0)730-808025
From: Fennell, Brian mailto:fenne...@radial.com>>
Sent: Friday, May 28, 2021 03:11
To: Bruce Johnson
mailto:john...@pharmacy.arizona.edu>>; dbi users
mailto:dbi-users@perl.org>>
Subject: RE: Strange
can easily be converted to and from (losslessly)
7-bit-ascii (such as EBCIDIC with some creativity).
And there is always good old hexadecimal.
It all depends on your use-cases, how much control you have over your
environment and how much time you can spend being clever.
--
Bruce Johnson
U
ng reported by oracle in
the error doesn’t match any of the values that I see in perl. I’m not sure this
is a DBI issue or not.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
d TNS_ADMIN Environment
variables and appropriate config file for the latter, then build DBD::Oracle in
CPAN. I've never had an issue doing it that way.
If you’re using JDBC I think all you need is the base client install.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information
cess on a server still using the 18c client and the
> core dump does not happen. Our DBA is creating
> ticket with Oracle, but I wanted to see if anyone else has had the same issue.
I am not seeing this issue with the 19C instant client ( 19.6 ) running on
CentOS8, DBD::Oracle 1.80
)
On Jun 3, 2020, at 10:37 AM, Bruce Johnson
mailto:john...@pharmacy.arizona.edu>> wrote:
On Jun 2, 2020, at 12:30 PM, Andreas Mock
mailto:andreas.m...@web.de>> wrote:
Hi Bruce,
only some hints. It sounds to me like a shared object mess which may be
possible after upgrading.
It
hink of any reason that running it under
mod_perl would cause a problem with DBI, it doesn’t happen with any other
systems I’m running it on. I”m going to take this off to the mod_perl list, I
guess.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
To clarify the DBD::mysql module is present, is reachable via @INC and has a
‘driver’ method present.
On Jun 2, 2020, at 10:55 AM, Bruce Johnson
mailto:john...@pharmacy.arizona.edu>> wrote:
I’ve copied a working script from one server to another (upgrading a web
application serve
bhost;port=$dbport" or die
$DBI::errstr;
my $dbh = DBI->connect($dsn, $dbuser, $dbpass,{'RaiseError' => 1});
Pretty standard stuff. I'm not sure why this is happening. It is NOT the error
being reported...
--
Bruce Johnson
University of Arizona
College of Pharmacy
> On Feb 18, 2020, at 9:58 AM, Bruce Johnson
> wrote:
>
> Just a heads up for those of you on the close-to-the-bleeding-edge. libnsl is
> no longer included with the standard glibc libs with CentOS (and I'm guessing
> also in RHEL 8, and whatever the current Fed
till in the repo, so yum install libnsl fixes it.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
minutes) without becoming unresponsive, even if they do return tens or hundreds
of thousands of rows.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
re ONLY opened in the child process doing the
work and get closed properly.
With DBI in use you can use the variable DBI_TRACE to get extensive log. Google
for that in combination with mod_perl.
Just some hints.
Best regards
Andreas
--
Bruce Johnson
University of Arizona
College of Pharmacy
I
middle of the afternoon and I'm seeing
'accesses per minute' kind of traffic.
And clues as to where I should start to look?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
, but all of the
perl modules I’ve installed from cpan are in the macports directory tree.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On 1/15/19, 2:59 PM, "Rajeev Jain"
mailto:jainr...
I’ve always just used the Bundle package and not had any problem:
https://metacpan.org/pod/Bundle::DBD::mysql
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On 1/15/19, 3:34 PM, "Daniël van
On Apr 10, 2018, at 8:31 AM, Bruce Johnson
mailto:john...@pharmacy.arizona.edu>> wrote:
On Apr 10, 2018, at 8:02 AM, tim.bu...@pobox.com<mailto:tim.bu...@pobox.com>
wrote:
- Forwarded message from "Seidler, Reinhard"
mailto:reinhard.seid...@amtc-dresden.com>&g
rsion 11. Now the database will be migrated to 12.2.0.1. How should
we deal with that? Any
answer would be appreciated.
Here is the canonical client compatibility guide for Oracle Database.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
a symlink to it in
the expected directory and everything worked just fine.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
the Basic and the SDK packages. The
latter gets the developer header files and libs that DBD::Oracle uses to
compile the c code.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
and
ORACLE_SID.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
to just $ORACLE_HOME.
The first step before trying to get DBI working is getting SQLPlus to work. Bet
the LD_LIBRARY_PATH fix above fixes that as well.
Don’t forget you also need to get the additional *Instant Client Package -
SDK", since that has the header files needed to compile DBD::Ora
> 10.2.0.3-1 installed
>
You know it’s vaguely coming back to me that I had to install several _devel
packages as well as the lib packages when I last set up a linux server.
You may need the libstdc++-devel.x86_64 package...
--
Bruce Johnson
University of Ari
et you install it as root as of 11.2 (at least, probably
much earlier but I went from 8.1.2 to 11.2 in one swell foop) .
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
D_LIBRARY_PATH=$ORACLE_HOME/lib
> export LD_RUN_PATH=$ORACLE_HOME/lib
> export PATH=$PATH:$ORACLE_HOME/bin
I know I’ve gotten this error with Instant Client when the SDK component wasn’t
installed. I haven’t used the full client in years so I don’t know if the SDK
is automatically i
MIGHT be default NLS_LANG thing, but I don’t think so.
A quick test would be to connect to the DB with hardcoded credentials in a test
perl script? This will determine whether it’s perl/DBI or encoding issues from
the config file.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
ugh, I was just a bit puzzled. I”ll have to go
look back and see if I did install SQLPlus on the other systems. The problem is
I set up a new server just once in a blue moon, not all the time, and forget
all the bits and bobs I need.
--
Bruce Johnson
University of Arizona
College of Ph
:/usr/bin:/root/bin:/usr/lib/oracle/12.1/client64/bin
TNS_ADMIN=/usr/lib/oracle/12.1/client64/admin
It worked, eventually, just wondering if others have run into the issue...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions
VARCHAR2(30 CHAR)
> C2 VARCHAR2(30)
>
> Note the difference is the character semantics, c1 is CHAR, c2 is BYTE.
>
isn’t that dependent on what ns_lang is set to? for single-byte encoding this
is correct, as 30 char == 30 bytes.
<http://www.dba-ora
PT_1,DESC
>> PT_2,DESC
>> ...
>> PT_N,DESC.
>> I'm using the DBI module in Perl, would this be better with the other
>> modules mentioned?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
n named ‘DESC’ in oracle and it just works. But
Oracle’s got a long history of letting you get away with murder in naming
things...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
/.cpan/Metadata’
You installed DBI as root, but are trying to install DBD::Pg as taranis. Path
or other environment issues?
Any reason you’re not installing DBD::Pg via cpan (as root) as well? I’ve found
that minimizes these kinds of things...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
;$i is ascii ".(ord $i)."\n"
}
exit;
This is what it produces:
dbdev2:~ johnson$ perl test
? is ascii 63
' is ascii 39
" is ascii 34
? is ascii 210
? is ascii 211
? is ascii 212
? is ascii 213
Note the displayed ‘?’’s….this is in my standard OSX terminal, whi
> On Jun 3, 2015, at 7:19 AM, William Bulley wrote:
>
> According to Bruce Johnson on Wed, 06/03/15
> at 10:10:
>>
>>
>> Make sure your original $query is delimited by double quotes, not single.
>
> I've tried _everything_!!
>
> Single q
not single.
if you do $sth->prepare(‘select column from table where column = ?’); you’ll
get that error.
That’s the only way the ? would get past DBI, I’d think, which is what your
oracle error seems to be indicating.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Te
makes the statement marginally faster to execute in
oracle, and a lot faster if you’re doing a lot of ‘em because the statement
plan gets calculated only once, then cached, like all queries with parameters.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Nov 5, 2014, at 6:09 AM, RaJaG* wrote:
> Hi Team,
>
> I am getting the error while downloading and install the
> mysql driver:
I believe the cpan.winnipeg.ca server went a while back. Try pointing it to one
of the mirrors: <http://www.cpan.org/SITES.ht
client, for example, you have to install an additional SDK package to get the
various files needed to compile applications as well as the basic client to
successfully install DBD::Oracle.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
out DB2, and less about Strawberry perl :-/ but I do know
a very common issue with is bitness mismatch in the database vendor drivers;
32-bit database driver vs 64-bit perl and vice versa, although there are
usually install time errors that will signal this.
--
Bruce Johnson
University of Arizon
he::DBI
<http://perl.apache.org/docs/1.0/guide/databases.html>) and once the first call
to a failed instance takes 100 seconds to fail over, the $dbh will then talk to
the backup server thereafter?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
like systems (including Solaris and Linux/x86_64),
> changing LD_LIBRARY_PATH while a process is running has no effect. So
> this:
>
>> On Feb 19, 2014 9:23 AM, "Bruce Johnson"
>> wrote:
>
>>> $ENV{"ORACLE_HOME"}="/usr/lib/oracle/11.2/cli
s/test.pl line 18
DB test: sysdate = Done testing connection
It appears that DBI is NOT inheriting the environment when it’s called via ‘use
DBI’ even though it’s called after I explicitly set them within the perl script.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
The
error line number doesn’t make sense, since the error refers to the line making
my db connection in the main script, and doesn’t correspond to an existing line
in the perl module, but I’ve run into oddball misdirections in perl error
statements in the past.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Feb 18, 2014, at 4:02 AM, Peter J. Holzer wrote:
> On 2014-02-17 22:43:58 +0000, Bruce Johnson wrote:
>> On Feb 17, 2014, at 2:48 PM, John D Groenveld
>> wrote:
>>> The OP shouldn't need to set a LD_LIBRARY_PATH so long as
>>> he built DBD::Oracle w
me most of the nights, so it
may take a few days to work through checking stuff since I only have about two
hours a day when I can actually run it :-)
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
nt64/lib/libocci.so.11.1
This is odd…
>
> On 02/17/2014 10:30 AM, Bruce Johnson wrote:
>> I get the following error:
>>
>> install_driver(Oracle) failed: Can't load
>> '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:
>&g
bin:/bin
PWD = /root
SHELL = /bin/sh
SHLVL = 1
USER = root
_ = /home/allwebfiles/perl/kfs/showenvcron.pl
These are the correct values.
So what am I missing?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Jan 27, 2014, at 12:25 PM, Bruce Johnson
wrote:
>
> On Jan 27, 2014, at 12:04 PM, Alexander Foken wrote:
>
>>>
>>> I'm running 64 bit Windows and 64 bit Perl. Is it possible the DBD loader
>>> is failing because it is trying to load a
bit and
64-bit Oracle libraries on one system; just install them in different
directories and ensure that the environmental variables are properly set prior
to running the perl code.
I never install the full Oracle client on anything any more.
--
Bruce Johnson
University of Arizona
College o
as
>> early as possible, even before DBI is loaded:
>>
>> $ENV{'ORACLE_HOME'}='/some/where';
>> # maybe set up other Oracle related environment variables
>> require DBD::Oracle; # loads the XS part AFTER setting up the environment
>>
>>
>
just using CGI. If we have performance issues we'll revisit the issue.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
with that LD_LIBRARY_PATH?
> And against that install?
>
> Maybe Oracle.so is using LD_LIBRARY_PATH set at build time instead of
> runtime?
>
>
>
>
> Carl Furst
>
>
>
>
>
> On 10/21/13 4:03 PM, "Bruce Johnson" wrote:
>
>>
>
On Oct 20, 2013, at 1:03 PM, Bruce Johnson wrote:
> Oh it turned out to be even simpler than that, and for once it wasn't MY fat
> fingers that fat fingered it this time :-)
Cue the sad trombone, because I was wrong, again.
It turns out the issue seems to have something to do wi
tions, and Carl, who was right all along!
On Oct 20, 2013, at 5:53 AM, lesleyb wrote:
> Hi Bruce
>
> On Fri, Oct 18, 2013 at 07:56:52PM +, Bruce Johnson wrote:
>> First thing I checked, and they're set correctly;
>>
>>> From %ENV on the broken system:
&
On Sep 23, 2013, at 2:02 PM, Bruce Johnson wrote:
> This can happen if you have 32-bit oracle db installed on the system, but use
> the 64-bit Oracle Instant Client to compile DBD::Oracle.
Or Vice-versa, of course, which might be what your problem is.
--
Bruce Johnson
University of A
_LIBRARY_PATH environment
variables set? This can happen if you have 32-bit oracle db installed on the
system, but use the 64-bit Oracle Instant Client to compile DBD::Oracle. You
can run a 32-bit Oracle DB and use a 64-Bit oracle client on the same system,
you just need to know which set of lib
rent perl package, which on
my just installed RHEL system is:
"This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi"
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
package and/or check that all the various files and such are where
they're expected to be.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
k the lazy way out and created a Developer directory and symlinked /usr
into it. Worked fine, but going forward this is probably something to consider
in the installer.
--
Bruce Johnson
"Wherever you go, there you are" B. Banzai, PhD
y $dbh = DBI->connect($dsn,$user,$password);"
the $dsn creation statement is where you can put a ton of options; mysql-only
ones would be documented in the DBD:mysql documentation, I'll bet.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
ction 6.1.6, “Security
Issues with LOAD DATA LOCAL”, for information on how to change this."
<http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html>
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
essful insert not the one that failed.
Mystery now solved.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
ch one to a scalar variable
> and including the list of variables in the execute(). It'd be more readable
> that way anyway. Or if you must put them all one one line like this, add the
> scalar() function on each argument.
>
>
> On Wed, May 8, 2013 at 9:18 AM, Bruce Johnson
value('emplId'),
$mesg->entry($n)->get_value('employeeType'),$mesg->entry($n)->get_value('employeeFTE'),$mesg->entry($n)->get_value('employeeTotalAnnualRate'));
All the columns allow null entries, and these are all single-valued entries in
the LDAP schema.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
d Unix toolchain for the particular version of Apple'd development
tools that you have.
Or
Go to en entirely /opt/ centered setup using MacPorts (you'll likely need to
install the MacPorts perl as well.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Tec
e you can pass specified environment vars from the user who starts the
Apache httpd processes in a directive, SetEnv:
#PassEnv PATH
SetEnv LD_LIBRARY_PATH /usr/lib/oracle/11.2/client64/lib
SetEnv ORACLE_HOME /usr/lib/oracle/11.2/client64
This is for linux-based Oracle Instant Client.
--
Bru
d DBD::Oracle on the same compiler and it worked also
> had a full 64 bit client for Oracle as well.
Yeah, I had this working just fine in 10.6 with the 64-bit Instant Client.
Grrr. Wish oracle'd get off their butts and fix this. :-(
Thanks.
--
Bruce Johnson
University of Arizona
Co
/DBD/Oracle/Oracle.bundle
# Reason: no suitable image found. Did find:
# /oracle32/libclntsh.dylib.10.1: mach-o, but wrong architecture at
/opt/local/lib/perl5/5.12.4/darwin-thread-multi-2level/DynaLoader.pm line 204.
# at (eval 9) line 3
Is this because my perl is 64-bit and I'm using the 32-bit Oracle drivers?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
;0 }) or die "Could not connect to database: " . DBI->errstr ;
You may need to change your connection string, depending on how your oracle
client is set up. mine is:
"host=oracle.host.dns.name;sid=SID"
As I dimly recall we had to make that change at some point in the past t
On Jun 30, 2012, at 9:20 PM, Bruce Johnson wrote:
> This code fragment:
>
After struggling with it for a bit (which included copying the offending code
from the non-working script, and pasting it into a test script with just that
bit...which worked)...I ended up pasting in the workin
cy.arizona.edu/s/list_all_fixed.pl
Clearly I am executing the thing, it has the param values!
(the query works in DB visualizer with the param values plugged into the right
place...this is driving me mad...I'm supposed to be on vacation., [Belushi/]But
No![/Belushi] I have to debug code)
--
Bruce Johnson
"Wherever you go, there you are" B. Banzai, PhD
with a new parameter. DO I have to do $csr->close(); ?
or can I just do $csr->execute($param);
again?
--
Bruce Johnson
"Wherever you go, there you are" B. Banzai, PhD
D'OH!
Thanks!
On Jun 4, 2012, at 11:12 AM, Jeffrey Seger wrote:
> $dbh->do() executes your sql. You are binding the parameter after this.
> Use $dbh->prepare instead.
>
> On Mon, Jun 4, 2012 at 2:01 PM, Bruce Johnson
> wrote:
>
>> I'm getting the foll
w_id', \$new_resource_id, 25);
$csr_insert->execute();
There's only one variable, and as far as I can see it's correct.
$sq_insert is the statement listed in the logged error. resource_id is created
via an 'on insert' trigger.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
eady returned all the rows for
that cursor.
(and really dumb me, I've seen this very error in the past when I've referenced
the wrong cursor)
--
Bruce Johnson
"Wherever you go, there you are" B. Banzai, PhD
eadminaffil r, resources r2, adminaffil a2, affils a3 where a.pid =
r.pid and r.resource_id = r2.resource_id and a.pid = a2.pid and a2.affil_id =
a3.affil_id and a3.affil_code in ('1901','PHRM') and r2.resource_id =?" with
ParamValues: :p1='120'] at /home/allwebfiles/perl/reserve2.pl line 124.,
referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Mar 29, 2012, at 2:45 PM, Bruce Johnson wrote:
> another odd error:
>
Accidentally clipped off the actual error:
DBD::Oracle::st fetchrow failed: ERROR no statement executing (perhaps you need
to call execute first)
> [for Statement "select distinct a.cn, a.email
this is being called,
because the right value is in the ParamValues part of the error message
while (($k, $j) =
$csr_prefapp->fetchrow()){$approvers{$k}=$j;$have_pref=1;}
if (!$have_pref){
$csr_allapp->execute($i) or die $DBI::errstr;
while (
str;
$csr_res_pend->bind_param(':D',$res_purp) or die $DBI::errstr;
$csr_res_pend->bind_param(':E',$res_affil) or die $DBI::errstr;
$csr_res_pend->bind_param_inout(":NEWID",\$new_res_id, 25) or die $DBI::errstr;
$csr_res_pend->execute();
Got right throu
On Mar 29, 2012, at 1:46 PM, Bruce Johnson wrote:
> Can't mix placeholder styles (:foo/?) at /usr/local/lib64/perl5/DBD/Oracle.pm
> line 329., referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
>
Commenting out this section code gets rid of the
or die $DBI::errstr;
$csr_res_pend->execute();
This is the only place in my program where I even used bind_param; every other
cursor is of the 'select foo, bar, bax from thetable where id =?' style.
Also, the line number in the error is from Oracle.pm, how do I find out what
line in my program caused this?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
ode...and why it failed in my
jdbc-based db utility...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
with instead is the code in the trigger:
create or replace trigger resource_key before insert on resources
for each row
begin
select resource_id_seq.nextval into :new.resource_id from dual
And an error about an invalid sql command for the 'end;' bit.
How do I make this work within d
d_param_inout method? as well?
>
> bind_param_inout is implimented fully on the DBI side so what ever the DBI
> spec says it needs it then it needs it.
>
>
> Hope this helps.
It does. Thank you.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
ram_inout method? as well?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Dec 30, 2011, at 9:57 PM, Bruce Johnson wrote:
>>
>> otool still shows the dylib file sans path, but the original script now
>> works...
>
> But python is still broken, which is another part of my toolchain.
>
> Gonna rip it all out and use MacPorts...
Wh
On Dec 30, 2011, at 6:55 PM, Bruce Johnson wrote:
>> I would say yes, here's mine (from MacPorts):
>
> Well, I found this:
>
> <http://probably.co.uk/problems-installing-dbdmysql-on-os-x-snow-leopard.html>
> that was supposed to fix the issue.
>
> It di
On Dec 29, 2011, at 5:02 PM, Brian Manning wrote:
> On Thu, Dec 29, 2011 at 3:26 PM, Bruce Johnson
> wrote:
>>> Does the output of:
>>>
>>> otool -L
>>> /Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
>>>
>>&g
On Dec 29, 2011, at 4:00 PM, Brian Manning wrote:
> On Thu, Dec 29, 2011 at 2:40 PM, Bruce Johnson
> wrote:
>>
>> On Dec 29, 2011, at 3:36 PM, Bruce Johnson wrote:
>>
>>> I tried installing Bundle::DBD::mysql via cpan, but got errors about how it
>
On Dec 29, 2011, at 3:36 PM, Bruce Johnson wrote:
> I tried installing Bundle::DBD::mysql via cpan, but got errors about how it
> couldn't find mysql_config, so I downloaded the DBD::mysql package manually
> and used perl Makefile.pl --mysql_config=/usr/local/mysql/bin/mysql_conf
sqlclient.dylib
-rw-r--r-- 1 root wheel 93405392 Nov 23 08:04 libmysqld-debug.a
-rw-r--r-- 1 root wheel 85193728 Nov 23 08:07 libmysqld.a
-rw-r--r-- 1 root wheel 8488 Nov 23 08:07 libmysqlservices.a
drwxr-xr-x 14 root wheel 476 Nov 23 08:09 plugin
Any ideas?
--
Bruce J
the connection is staying open long enough to get stale and be disconnected,
then you shouldn't be running into timing issues.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
I know it sounds silly but did you forget to commit? I've been
>> doing DB programming for years but every now and again I waste 10-15
>> minutes on mysteriously disappearing data because I forgot to commit.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
directory and see
if it works now)
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
database, which will be about as fast as you can
manage, especially if you do block commits. Then if it's still not fast enough
to keep up, you need to look elsewhere for speed improvements
Quit making Perl do the work of Mysql, in other words.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Feb 21, 2011, at 11:20 AM, Bruce Johnson wrote:
>
> On Feb 21, 2011, at 11:11 AM, Bruce Johnson wrote:
>
>> On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
>>
>>> Figured it out.
>>>
>>> The second ldap query did not return all the attribu
On Feb 21, 2011, at 11:11 AM, Bruce Johnson wrote:
> On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
>
>> Figured it out.
>>
>> The second ldap query did not return all the attributes I was looking for,
>> and when it returned no value for that attri
On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
> Figured it out.
>
> The second ldap query did not return all the attributes I was looking for,
> and when it returned no value for that attribute, the bind variable wasn't
> populated, leading to the mismatch between expe
, email, eid, uname) values (?,?,?,?)"
with ParamValues: :p1='Jane Someone',:p2='jane@elsewhere',:p3='567',
:p4='jblow']
I had to look through a bunch of the errors to find the pattern.
Fortunately there were only two fields in the LDAP query I was
1 - 100 of 144 matches
Mail list logo
