headers
Peter Leonard | 2 Mar 2005 19:00
Gravatar

DBD::mysql 2.9004 connect issues.


Hello,

I'm facing some extremely bizarre behavior on my SuSE 9.2 i586 box that 
I'm completely stumped by.  Hopefully someone can help.

Installed MySQL & all dependent packages via YAST (SuSE's package 
management system).

Compiled & installed perl 5.8.6 manually (stupid SuSE threaded version).

Installed DBI no problem.

Installed DBD::mysql w/ no major issues - a few complaints in the tests, 
but nothing that seemed bad.

When I try and connect to the DB, I get the following error:

peter <at> linux:~/dev/nextgen> ./test.pl
Had to create ::imp_data_size unexpectedly at 
/usr/local/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line 1165.
Segmentation fault

test.pl as follows:

#!/usr/bin/perl

use strict;
use warnings;
(Continue reading)

Permalink | Reply | 0 comments |
headers
Peter Leonard | 2 Mar 2005 20:03
Gravatar

re: DBD::mysql 2.9004 connect issues.


Never mind.

Going through the reinstallation of the SuSE perl RPMs, and then 
installing the new perl from source seems to have fixed everything.

 	--pete

----
Peter Leonard
pete <at> peteleonard.com

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Wagner, David --- Senior Programmer Analyst --- WGO | 3 Mar 2005 23:30
Picon

Would like to work with Perl and MySQL.

	I have MySQL 4.1 loaded. I am running AS 5.8.3 build 809.
	What do I need? Or where can I go to get the info to load on to machine.
	I have no compilers available. As stated above, use binaries from AS.

Any questions and/or problems, please let me know.

	Thanks!

Wags ;)
WGO: x2224

*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Peter Sugiarto | 8 Mar 2005 02:30

question on DBD::mysql

Hi,

I am wondering if any one can help me locate DBD::mysql for windows.

I tried to do 

ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd

but it took long time and finally I had to control C

when I do it again, it says "is already installed"

should I use something else?

Thanks

Petetr
Permalink | Reply | 0 comments |
headers
Peter Sugiarto | 8 Mar 2005 03:10

FW: question on DBD::mysql


-----Original Message-----
From: Peter Sugiarto [mailto:peter.sugiarto <at> troposnetworks.com] 
Sent: Monday, March 07, 2005 5:30 PM
To: 'msql-mysql-modules <at> lists.mysql.com'
Subject: question on DBD::mysql

Hi,

I am wondering if any one can help me locate DBD::mysql for windows.

I tried to do 

ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd

but it took long time and finally I had to control C

when I do it again, it says "is already installed"

should I use something else?

Thanks

Petetr
Permalink | Reply | 1 comment |
headers
Randy Kobes | 8 Mar 2005 06:15
Picon
Favicon

Re: FW: question on DBD::mysql

On Mon, 7 Mar 2005, Peter Sugiarto wrote:

> I am wondering if any one can help me locate DBD::mysql for windows.
> I tried to do
>
> ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd
> but it took long time and finally I had to control C
>
> when I do it again, it says "is already installed"
> should I use something else?

Does
   C:\> perl -MDBD::mysql -e "print 1"
produce any error message? If not, then it's probably
installed OK, although you should test it with some scripts
to be sure. If there is an error message, then there was an
error in installing, and you'll have to track that down. For
that, one of the win32-perl mailing lists hosted by
ActiveState would be a more appropriate forum.

-- 
best regards,
randy kobes

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
(Continue reading)

Permalink | Reply | 0 comments |
headers
Steve Hay | 8 Mar 2005 10:30

Handling UTF-8 (again)

There have been several attempts in the past to have DBI/DBD-mysql do 
something useful with UTF-8 data, but as far as I can see nothing has 
yet come of it in any released versions of the modules.

MySQL 4.1.10 is currently the recommended release of MySQL, and contains 
lots of character set support.  Are there any plans to provide access to 
such support in DBD-mysql?

In particular, I want to have data that is retrieved from UTF-8 columns 
in the database flagged in Perl as utf8.  Gaal Yahas posted a patch 
(http://lists.mysql.com/perl/3006) which achieved this fairly crudely 
for all data.  Presumably the new character set support means that 
something similar could now be done properly, i.e. check with MySQL 
itself to see if data is from a UTF-8 column, rather than guessing or 
assuming that everything is.

- Steve

------------------------------------------------
Radan Computational Ltd.

The information contained in this message and any files transmitted with it are confidential and intended
for the addressee(s) only.  If you have received this message in error or there are any problems, please
notify the sender immediately.  The unauthorized use, disclosure, copying or alteration of this message
is strictly forbidden.  Note that any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of Radan Computational Ltd.  The recipient(s) of this
message should check it and any attached files for viruses: Radan Computational will accept no liability
for any damage caused by any virus transmitted by this email.

--

--
(Continue reading)

Permalink | Reply | 0 comments |
headers
Thomas Register | 8 Mar 2005 18:04
Favicon

Re: Install on Mac os X 10.3.7


>
> On Sun, 23 Jan 2005, James Burnette wrote:
> I am trying to install DBD-mysql-2.9004 on Mac OS X 10.3.7 with perl
> v5.8.1-RC3 built for darwin-thread-multi-2level and MySQL 4.1.9.Make
> fails with this message:
>
> make
...
> LD_RUN_PATH="/usr/lib" /usr/bin/perl myld MACOSX_DEPLOYMENT_TARGET=10.3
> cc  -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o
> -o blib/arch/auto/DBD/mysql/mysql.bundle   -L/usr/local/mysql/lib
> -lmysqlclient -lm -lz
> make: *** [blib/arch/auto/DBD/mysql/mysql.bundle] Error 255

I found a reference somewhere with google (don't have it right now, or
I'd give credit where it's due) that suggested removing the "myld" from
makefile.  I wasn't sure how best to do this,  but found that executing
makefile with the nocatchstderr option eliminated the problem:

perl makefile --nocatchstderr

I'm now doing selects and inserts into my database.  (after taking care 
of a password problem.  Sigh).

You can see the reference to the option inside makefile.pl.  Hope this
helps:  I've found that using Perl and MySQL can be a RPitA.
Interesting and educational, though.

I'm also running 10.3.7.  Interesting point;  I'm running Jaguar on
(Continue reading)

Permalink | Reply | 501 comments |
headers
Gilbert Aliwarga | 9 Mar 2005 13:05
Picon

Make file for mysql client problem

Hi, I'm following the instruction given on this site
http://server1.belchfire.net/protected-cgi-bin/manServer_107.pl/usr/share/man/man3pm/DBD::mysql::INSTALL.3pm.
Everything seems to be fine, but when I execute "make" it gives this
error
$ make
make  all-recursive
make[1]: Entering directory `/cygdrive/c/temp/mysql-4.1.10'
Making all in .
make[2]: Entering directory `/cygdrive/c/temp/mysql-4.1.10'
make[2]: Leaving directory `/cygdrive/c/temp/mysql-4.1.10'
Making all in include
make[2]: Entering directory `/cygdrive/c/temp/mysql-4.1.10/include'
make  all-am
make[3]: Entering directory `/cygdrive/c/temp/mysql-4.1.10/include'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/cygdrive/c/temp/mysql-4.1.10/include'
make[2]: Leaving directory `/cygdrive/c/temp/mysql-4.1.10/include'
Making all in Docs
make[2]: Entering directory `/cygdrive/c/temp/mysql-4.1.10/Docs'
make  all-recursive
make[3]: Entering directory `/cygdrive/c/temp/mysql-4.1.10/Docs'
Making all in Images
make[4]: Entering directory `/cygdrive/c/temp/mysql-4.1.10/Docs/Images'
make[4]: Nothing to be done for `all'.
make[4]: Leaving directory `/cygdrive/c/temp/mysql-4.1.10/Docs/Images'
make[4]: Entering directory `/cygdrive/c/temp/mysql-4.1.10/Docs'
make[4]: Nothing to be done for `all-am'.
make[4]: Leaving directory `/cygdrive/c/temp/mysql-4.1.10/Docs'
make[3]: Leaving directory `/cygdrive/c/temp/mysql-4.1.10/Docs'
make[2]: Leaving directory `/cygdrive/c/temp/mysql-4.1.10/Docs'
(Continue reading)

Permalink | Reply | 0 comments |
headers
Daniel Kasak | 10 Mar 2005 04:07
Picon

ANN: Gtk2::Ex::DBI-0.8

I'm pleased to annouce the 8th release of Gtk2::Ex::DBI ...
http://entropy.homelinux.org/Gtk2-Ex-DBI/

Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl
apps data aware. It handles querying, 'painting' records on your
Glade-generated form, passing updates back to the database server,
inserting, deleting, and much more. Roll your own MS Access.

 From the changelog:

- INCOMPATIBLE CHANGE: don't call on_current while we're constructing 
ourself - external code won't be able to 'see' us yet

- Added constructor_done flag to indicate whether we have been returned 
to the calling code yet
You should manually call the on_current code immediately *after* the 
object constructor ... when your Gtk2::Ex::DBI object will be available

- Added method of running external code before applying changes to the 
current record ( on_apply - similar to on_current )

- Apply changes to the current record before requerying ( query method )

- Properly handle empty recordsets in count method

- Append primary key to sql_select if necessary in fetch_new_slice method

- Added 'quiet' flag to silence warnings such as missing widgets

- Added 'use strict' directive and fixed up issues this raised
(Continue reading)

Permalink | Reply | 0 comments |

Gmane