DBD-mysql-2.9002 incompatible to MySQL-4.10-alpha?

am 19.08.2003 02:08:21 von Hans van Harten

Rudy,

Just because I prefere Latin2_general_ci charset/collation above the swedish
default, I ran into the following:
Due to the change in file names and formats DBD-mysql-2.9002 does not
recognize MySQL-4.10-alpha's files in \share\charsets and spits an
error.
For now I've placed the old files from MySQL-4.14b next to their new
counterparts; at least it surpresses the error.

BTW why don't you make use of the setting of basedir in my.ini or my.cnf and
leave the pathes supplied at compile time by -I or -L for a last resort? It
would make life even more easy for those -me included- installing
pre-compiled binaries!

If every one has assumed you knew this already, I still might be the first
to report.
Keep up the good work,

Hans van Harten

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Can"t load "blib/arch/auto/DBD/mysql/mysql.so" for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal:

am 19.08.2003 02:42:14 von santosh kandi

Folks this is my 3 rd email, i hope to get some
response. Rudy i am copying you bcoz i have seen your
email solution for a similar problem.

I am trying to Install DBD::MYSQL on solaris 5.6, the
problem is i dont have root permissions.
We have perl 5.005 and DBI already installed by the
admin. SO i downloaded the binary for
mysql("mysql-standard-4.0.14-sun-solaris2.8-sparc-64bit")
and downloaded DBD-mysql-2.9002 source. Both in my
private directory.
I pointed my path to the MYSQL binary.
The follwoing are the results
Perl Makefile.PL
cflags (mysql_config) =
-I'/home/a0867706/myperl/mysql/include'
libs (mysql_config) =
-L/home/a0867706/myperl/mysql/lib/mysql -lmysqlclient
-lp
osix4 -lgen -lsocket -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL
--help' and
'perldoc INSTALL'.

Note (probably harmless): No library found for -lgen
Using DBI 1.21 installed in
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
Writing Makefile for DBD::mysql

MAKE:

cc -c
-I/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I'/home/a0867706/myper
l/mysql/include' -O -DVERSION=\"2.9002\"
-DXS_VERSION=\"2.9002\" -KPIC -I/usr/local/
lib/perl5/5.00503/sun4-solaris/CORE dbdimp.c
"dbdimp.c", line 1422: warning: argument #1 is
incompatible with prototype:
prototype: pointer to char :
"/usr/local/lib/perl5/5.00503/sun4-solaris/CORE/proto
..h", line 355
argument : pointer to const char
"dbdimp.c", line 1426: warning: argument #1 is
incompatible with prototype:
prototype: pointer to char :
"/usr/local/lib/perl5/5.00503/sun4-solaris/CORE/proto
..h", line 355
argument : pointer to const char
"dbdimp.c", line 1443: warning: argument #1 is
incompatible with prototype:
prototype: pointer to char :
"/usr/local/lib/perl5/5.00503/sun4-solaris/CORE/proto
..h", line 355
argument : pointer to const char
"dbdimp.c", line 1449: warning: argument #1 is
incompatible with prototype:
prototype: pointer to char :
"/usr/local/lib/perl5/5.00503/sun4-solaris/CORE/proto
..h", line 355
argument : pointer to const char
"dbdimp.c", line 1465: warning: argument #1 is
incompatible with prototype:
prototype: pointer to char :
"/usr/local/lib/perl5/5.00503/sun4-solaris/CORE/proto
..h", line 355
argument : pointer to const char
"dbdimp.c", line 1473: warning: argument #1 is
incompatible with prototype:
prototype: pointer to char :
"/usr/local/lib/perl5/5.00503/sun4-solaris/CORE/proto
..h", line 355
argument : pointer to const char
"dbdimp.c", line 1478: warning: argument #1 is
incompatible with prototype:
prototype: pointer to char :
"/usr/local/lib/perl5/5.00503/sun4-solaris/CORE/proto
..h", line 355
argument : pointer to const char
cc -c
-I/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I'/home/a0867706/myper
l/mysql/include' -O -DVERSION=\"2.9002\"
-DXS_VERSION=\"2.9002\" -KPIC -I/usr/local/
lib/perl5/5.00503/sun4-solaris/CORE mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
LD_RUN_PATH="/home/a0867706/myperl/mysql/lib/mysql:/lib"
/usr/bin/perl myld cc -o blib/arc
h/auto/DBD/mysql/mysql.so
-R/home/a0867706/myperl/mysql/lib/mysql -R/lib -G
dbdimp.o mysq
l.o -L/home/a0867706/myperl/mysql/lib/mysql
-lmysqlclient -lposix4 -lsocket -lnsl -lm
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
/usr/local/bin/pod2man: bad option in paragraph 178 of
lib/DBD/mysql/INSTALL.pod: ``-h'' s
hould be [CB]<-h>
/usr/local/bin/pod2man: bad option in paragraph 178 of
lib/DBD/mysql/INSTALL.pod: ``-h'' s
hould be [CB]<-h>

NOW THE PROBLEM OCCURS IN MAKE TEST:
make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.00503/sun4
-solaris -I/usr/local/lib/perl5/5.00503 -e 'use
Test::Harness qw(&runtests $verbose); $ver
bose=0; runtests @ARGV;' t/*.t
t/00base............install_driver(mysql) failed:
Can't load 'blib/arch/auto/DBD/mysql/mys
ql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl:
fatal: libz.so.1: open failed: No su
ch file or directory at
/usr/local/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
line 169.

at (eval 1) line 3
Perhaps a required shared library or dll isn't
installed where expected
at t/00base.t line 38
dubious
Test returned status 255 (wstat 65280, 0xff00)
Warning: Use of "defined" without parens is ambiguous
at /usr/local/lib/perl5/site_perl/5.
005/sun4-solaris/_h2ph_pre.ph line 2.
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/10dsnlist.........install_driver(mysql) failed:
Can't load 'blib/arch/auto/DBD/mysql/mys
ql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl:
fatal: libz.so.1: open failed: No su
ch file or directory at
/usr/local/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm
line 169.

at (eval 1) line 3
Perhaps a required shared library or dll isn't
installed where expected
at t/10dsnlist.t line 45
dubious
Test returned status 255 (wstat 65280, 0xff00)
Undefined subroutine &Test::Harness::WCOREDUMP called
at /usr/local/lib/perl5/5.00503/Test
/Harness.pm line 288.
*** Error code 255
make: Fatal error: Command failed for target
`test_dynamic'

GUYS PLEASE HELP.
Thank,
Santosh

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.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@m .gmane.org

Can"t load "blib/arch/auto/DBD/mysql/mysql.so" for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal:

am 19.08.2003 02:42:14 von santosh kandi

Re: Can"t load "blib/arch/auto/DBD/mysql/mysql.so" for module DBD::mysql: ld.so.1: /usr/bin/perl: fa

am 19.08.2003 17:32:43 von Rudy Lippan

On Mon, 18 Aug 2003, santosh kandi wrote:

> Date: Mon, 18 Aug 2003 17:42:14 -0700 (PDT)
> From: santosh kandi
> To: msql-mysql-modules@lists.mysql.com
> Cc: rlippan@remotelinux.com
> Subject: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module
> DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libz.so.1: open failed:
>
> Folks this is my 3 rd email, i hope to get some
> response. Rudy i am copying you bcoz i have seen your
> email solution for a similar problem.

I don't know much about Solaris, alas. It looks like you are unable to
load the libz shared object. Have you tried making sure that you
have the object and that it can be loaded? Or have you tried compiling
without the -lz option?

Rudy.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Can"t load "blib/arch/auto/DBD/mysql/mysql.so" for module DBD::mysql: ld.so.1: /usr/bin/perl: fa

am 19.08.2003 17:32:43 von Rudy Lippan

Re: DBD-mysql-2.9002 incompatible to MySQL-4.10-alpha?

am 19.08.2003 17:54:19 von Rudy Lippan

On Tue, 19 Aug 2003, Hans van Harten wrote:

> Rudy,
>
> Just because I prefere Latin2_general_ci charset/collation above the swedish
> default, I ran into the following:
> Due to the change in file names and formats DBD-mysql-2.9002 does not
> recognize MySQL-4.10-alpha's files in \share\charsets and spits an
> error.

I have not tried using another charset with a binary distribution yet, so
I don't know all of the issues involved -- I guess it it time I start
working on charsets :) What is error are you getting?

> For now I've placed the old files from MySQL-4.14b next to their new
> counterparts; at least it surpresses the error.
>
> BTW why don't you make use of the setting of basedir in my.ini or my.cnf and
> leave the pathes supplied at compile time by -I or -L for a last resort? It
> would make life even more easy for those -me included- installing
> pre-compiled binaries!
>

DBD::mysql lets the mysql client libraries decide what to do; unless you
explicitly tell it to do otherwise. DBD::mysql itself does not default to
using any paths... The only thing that DBD::mysql uses those paths for,
IIRC, is to decide what libaries to link against.

> If every one has assumed you knew this already, I still might be the first
> to report.
> Keep up the good work,

Thank you.

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD-mysql-2.9002 incompatible to MySQL-4.10-alpha?

am 19.08.2003 17:54:19 von Rudy Lippan

Re: Can"t load "blib/arch/auto/DBD/mysql/mysql.so" for module DBD::mysql: ld.so.1: /usr/bin/perl: fa

am 19.08.2003 18:02:55 von santosh kandi

Rudy,
Thanks for the response.
I dont think i have the libz shared object. Is it a
part of the mysql servers client and devlopment files?
where can i get it?.

I have been compiling it without giving -lz option.
Also i didnt install the mysql binary, all i did is to
to download the binary and pointed my path to it, so
that it can pick up the include,bin and lib
directories, which i thought will have all the
required client and development files.

Thanks,
Santosh

--- Rudy Lippan wrote:
> On Mon, 18 Aug 2003, santosh kandi wrote:
>
> > Date: Mon, 18 Aug 2003 17:42:14 -0700 (PDT)
> > From: santosh kandi
> > To: msql-mysql-modules@lists.mysql.com
> > Cc: rlippan@remotelinux.com
> > Subject: Can't load
> 'blib/arch/auto/DBD/mysql/mysql.so' for module
> > DBD::mysql: ld.so.1: /usr/bin/perl: fatal:
> libz.so.1: open failed:
> >
> > Folks this is my 3 rd email, i hope to get some
> > response. Rudy i am copying you bcoz i have seen
> your
> > email solution for a similar problem.
>
>
> I don't know much about Solaris, alas. It looks
> like you are unable to
> load the libz shared object. Have you tried making
> sure that you
> have the object and that it can be loaded? Or have
> you tried compiling
> without the -lz option?
>
>
>
> Rudy.
>
>

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.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@m .gmane.org

Re: Can"t load "blib/arch/auto/DBD/mysql/mysql.so" for module DBD::mysql: ld.so.1: /usr/bin/perl: fa

am 19.08.2003 18:02:55 von santosh kandi

Re: DBD-mysql-2.9002 incompatible to MySQL-4.10-alpha?

am 19.08.2003 21:20:43 von Hans van Harten

Jochen Wiedmann wrote:
>> Just because I prefere Latin2_general_ci charset/collation above the
>> swedish default, I ran into the following:
>> Due to the change in file names and formats DBD-mysql-2.9002 does not
>> recognize MySQL-4.10-alpha's files in \share\charsets and
>> spits an error.
> Could you please explain in more detail, what the problem is? At least
> I am totally unaware of any problems related to charsets. (Typical
> latin1 user.)
I'll try. Just make Latin2 the default character set of a server by putting
into the [mysqld]-section of my.ini: 'default_character_set=latin2'.
Then run
use DBI;
my $dbh = DBI->connect("DBI:mysql:database='');
and find this message thrown at you:
File 'D:\mysql\share\charsets\?.conf' not found (Errcode: 22)
Character set '#9' is not a compiled character set and is not specified
in the 'C:\mysql\\share\charsets\Index' file

It seems the file 'Index' is renamed 'Index.XML' first time in MySQL-4.10;
its internal structure has changed too. The characterset definition files
has changed extention too; their internal stucture changed in a similar way.
FYI, I have seen the same renaming in mysql-4.1.0-alpha.tar.gz.
BTW,I could not find a hint on this in neither the ChangeLog nor the
documentation... not even in the README.
For mow I servive by having both these new files and the oldies from
4.014b-files in the same folder.

>> BTW why don't you make use of the setting of basedir in my.ini or
>> my.cnf and leave the pathes supplied at compile time by -I or -L for
>> a last resort? It would make life even more easy for those -me
>> included- installing pre-compiled binaries!
> Same thing here. However, note that you can configure use of the
> my.ini file in the DSN. (See mysql_read_default_group)
You made me realise, I had to configure the client, not DBD::mysql.
Inserting these THREE lines
[dbdmysql]
character-sets-dir=D:/mysql/share/charsets
default-character-set=cp1251
does the job (as long as the 4.014b-files are there too)

HansH

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD-mysql-2.9002 incompatible to MySQL-4.10-alpha?

am 19.08.2003 21:20:43 von Hans van Harten

what is the name of object table in MYSQL?

am 20.08.2003 15:22:09 von lshen

what is the name of object table in MYSQL?

----- Original Message -----
From: "Hans van Harten"
To:
Cc: ; "Jochen Wiedmann"
Sent: Tuesday, August 19, 2003 3:20 PM
Subject: Re: DBD-mysql-2.9002 incompatible to MySQL-4.10-alpha?

> Jochen Wiedmann wrote:
> >> Just because I prefere Latin2_general_ci charset/collation above the
> >> swedish default, I ran into the following:
> >> Due to the change in file names and formats DBD-mysql-2.9002 does not
> >> recognize MySQL-4.10-alpha's files in \share\charsets and
> >> spits an error.
> > Could you please explain in more detail, what the problem is? At least
> > I am totally unaware of any problems related to charsets. (Typical
> > latin1 user.)
> I'll try. Just make Latin2 the default character set of a server by
putting
> into the [mysqld]-section of my.ini: 'default_character_set=latin2'.
> Then run
> use DBI;
> my $dbh = DBI->connect("DBI:mysql:database='');
> and find this message thrown at you:
> File 'D:\mysql\share\charsets\?.conf' not found (Errcode: 22)
> Character set '#9' is not a compiled character set and is not
specified
> in the 'C:\mysql\\share\charsets\Index' file
>
> It seems the file 'Index' is renamed 'Index.XML' first time in MySQL-4.10;
> its internal structure has changed too. The characterset definition files
> has changed extention too; their internal stucture changed in a similar
way.
> FYI, I have seen the same renaming in mysql-4.1.0-alpha.tar.gz.
> BTW,I could not find a hint on this in neither the ChangeLog nor the
> documentation... not even in the README.
> For mow I servive by having both these new files and the oldies from
> 4.014b-files in the same folder.
>
> >> BTW why don't you make use of the setting of basedir in my.ini or
> >> my.cnf and leave the pathes supplied at compile time by -I or -L for
> >> a last resort? It would make life even more easy for those -me
> >> included- installing pre-compiled binaries!
> > Same thing here. However, note that you can configure use of the
> > my.ini file in the DSN. (See mysql_read_default_group)
> You made me realise, I had to configure the client, not DBD::mysql.
> Inserting these THREE lines
> [dbdmysql]
> character-sets-dir=D:/mysql/share/charsets
> default-character-set=cp1251
> does the job (as long as the 4.014b-files are there too)
>
> HansH
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=lshen@pop900.gsfc.nasa.gov
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

what is the name of object table in MYSQL?

am 20.08.2003 15:22:09 von lshen

Re: what is the name of object table in MYSQL?

am 20.08.2003 23:25:54 von Jeremy Zawodny

On Wed, Aug 20, 2003 at 09:22:09AM -0400, lei shen wrote:
> what is the name of object table in MYSQL?

What's an "object table"?
--
Jeremy D. Zawodny,
Technical Yahoo - Yahoo MySQL Geek
Desk: (408) 349-7878 Cell: (408) 685-5936

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: what is the name of object table in MYSQL?

am 20.08.2003 23:25:54 von Jeremy Zawodny