DBD::mysql install nightmare.

am 22.10.2003 17:47:13 von John Day

--=====================_659180812==.ALT
Content-Type: text/plain; charset="us-ascii"

Hi,

I am usually handed prebuilt servers with everything installed for me. But this time I am setting up my own development machine. I installed RH8.0 with Apache 1.3.28, mod_perl 1.28 and mod_ssl etc. RH8.0 comes with Perl 5.8.0 and there is a problem with Unicode support - I couldn't install a lot of modules I needed.

SO - I set out to do some upgrading. I installed Perl 5.8.1 from sources (that was easy!) Then MySQL 4.0.16 from sources, a little harder, but it works fine now!

BUT - then I tried installing modules, DBI installed okay, but DBD::mysql is a nightmare! Here is the START of what I get:

Checking if your kit is complete...
Looks good
Using DBI 1.38 installed in /usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
cc -c -I/usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI -I'/usr/include' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O3 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic "-I/usr/local/lib/perl5/5.8.1/i686-linux/CORE" dbdimp.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
/usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI/Dri ver.xst > mysql.xsi
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
/usr/local/bin/perl /usr/local/lib/perl5/5.8.1/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.1/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 193
Warning: duplicate function definition 'rows' detected in mysql.xs, line 291
cc -c -I/usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI -I'/usr/include' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O3 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic "-I/usr/local/lib/perl5/5.8.1/i686-linux/CORE" mysql.c
cc1: cc1: warning: changing search order for system directory "/usr/include"
cc1: warning: as it has already been specified as a non-system directory
warning: changing search order for system directory "/usr/include"
cc1: warning: as it has already been specified as a non-system directory
In file included from mysql.xs:15:
dbdimp.h:31:49: mysql.h: No such file or directory
dbdimp.h:32:49: errmsg.h: No such file or directory
In file included from dbdimp.c:29:
dbdimp.h:31:49: mysql.h: No such file or directory
dbdimp.h:32:49: errmsg.h: No such file or directory
In file included from mysql.xs:15:
dbdimp.h:116: parse error before "MYSQL"
dbdimp.h:116: warning: no semicolon at end of struct or union
In file included from dbdimp.c:29:
dbdimp.h:116: parse error before "MYSQL"
dbdimp.h:116: warning: no semicolon at end of struct or union
dbdimp.h:127: parse error before '}' token
dbdimp.h:127: parse error before '}' token
dbdimp.h:156: parse error before "MYSQL_RES"
dbdimp.h:156: warning: no semicolon at end of struct or union
dbdimp.h:169: parse error before '}' token
I am lost. Can anyone help?

Kindest regards,

John
--=====================_659180812==.ALT--

Re: DBD::mysql install nightmare.

am 22.10.2003 18:19:52 von Jochen Wiedmann

John Day wrote:

> In file included from mysql.xs:15:
> dbdimp.h:31:49: mysql.h: No such file or directory
> dbdimp.h:32:49: errmsg.h: No such file or directory

This quite looks like you need to install the mysql-devel RPM
or something similar.

Jochen

--
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 install nightmare.

am 22.10.2003 18:19:52 von Jochen Wiedmann

Re: DBD::mysql install nightmare.

am 22.10.2003 18:30:22 von John Day

At 06:19 PM 10/22/2003 +0200, Jochen Wiedmann wrote:
>John Day wrote:
>
>>In file included from mysql.xs:15: dbdimp.h:31:49: mysql.h: No such file or directory dbdimp.h:32:49: errmsg.h: No such file or directory
>
>This quite looks like you need to install the mysql-devel RPM
>or something similar.
>
>
>Jochen

I installed MySQL from sources. Not from RPM's! That is why I am stumped.
Could it be that the DBD::mysql needs to be installed manually so I can specify the directories?

Since my email I have been looking, I think that the DBD::mysql expects things to be in places where the standard install from source doesn't put them. Should I have installed from the X86 RPM's on the MySQL site and just install all the RPM's?

John

--
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 install nightmare.

am 22.10.2003 18:30:22 von John Day

Re: DBD::mysql install nightmare.

am 22.10.2003 18:33:58 von Rudy Lippan

On Wed, 22 Oct 2003, John Day wrote:

> Hi,
>
Hi.

> In file included from mysql.xs:15:
> dbdimp.h:31:49: mysql.h: No such file or directory
> dbdimp.h:32:49: errmsg.h: No such file or directory

It looks like DBD::mysql is not able to find mysql.h.

Maybe DBD::mysql is unable to find / (find the correct) mysql_config and
is therefore not able to locate the mysql header files.

Try setting your path to include the mysql binary directory (for the mysql
that you just installed) and then run 'perl Makefile.PL' and see if that
helps.

If that does not help could you send the output of 'perl Makefile.PL'.

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 install nightmare.

am 22.10.2003 18:33:58 von Rudy Lippan

Re: DBD::mysql install nightmare.

am 22.10.2003 22:08:21 von John Day

At 12:33 PM 10/22/2003 -0400, Rudy Lippan wrote:
>On Wed, 22 Oct 2003, John Day wrote:
>
>> Hi,
>>
>Hi.
>
>
>> In file included from mysql.xs:15:
>> dbdimp.h:31:49: mysql.h: No such file or directory
>> dbdimp.h:32:49: errmsg.h: No such file or directory
>
>
>It looks like DBD::mysql is not able to find mysql.h.
>
>
>Maybe DBD::mysql is unable to find / (find the correct) mysql_config and
>is therefore not able to locate the mysql header files.
>
>Try setting your path to include the mysql binary directory (for the mysql
>that you just installed) and then run 'perl Makefile.PL' and see if that
>helps.
>
>If that does not help could you send the output of 'perl Makefile.PL'.
>
>
>Rudy
Rudy ( and Jochen ),
Thanks for the responses. Yes, in the end it was a case of the libraries being missing in action - well actually not findable! In the end I decided to make DBD::mysql manually, using the info in the README file for Windows/CygWin and just changed the directory names.

Presto it all worked.

It would seem to me that the default locations for things vary. If you install from the RPM's it is one way, make from source it is different.

Now I am happy :)

John

--
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 install nightmare.

am 22.10.2003 22:08:21 von John Day

Re: DBD::mysql install nightmare.

am 22.10.2003 22:17:01 von Jochen Wiedmann

John Day wrote:

> I installed MySQL from sources. Not from RPM's! That is why I am stumped.
> Could it be that the DBD::mysql needs to be installed manually so I can specify the directories?

If so, use the options --cflags and --libs when running "perl Makefile.PL".
See the INSTALL document for details. Or make sure, that mysql_config is
in your path.

Jochen

--
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 install nightmare.

am 22.10.2003 22:17:01 von Jochen Wiedmann