headers
Jochen Wiedmann | 1 Nov 2003 11:46
Picon

Re: DBD::mysql install issues on HPUX 11.0

Keith Paschal wrote:

>  libs          (mysql_config) = -L/other/mysql/lib -lmysqlclient -lcrypt 
> -lnsl -lm

[...]

> /usr/bin/ld: Invalid loader fixup in text space needed in output file 
> for symbol "$0000004B" in input file: "/other/mysql/lib/libmys
> qlclient.a(libmysql.o)". Make sure it was compiled with +z/+Z.
> *** Error exit code 1

The message says it all: Try using the option

   --libs="-L/other/mysql/lib -lmysqlclient -lcrypt -lnsl -lm +z"

or

   --libs="-L/other/mysql/lib -lmysqlclient -lcrypt -lnsl -lm +Z"

when running "perl Makefile.PL".

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 <at> m.gmane.org
(Continue reading)

Permalink | Reply | 0 comments |
headers
Tony Dean | 3 Nov 2003 13:50

Re: Session database error

Perhaps a solution is to do it the obvious way,
namely to include the $user and $password values
as hidden input fields in the form.

--

-- 
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
Keith Paschal | 4 Nov 2003 01:51
Picon
Favicon

Re: DBD::mysql install issues on HPUX 11.0

Jochen;

I would say this is not a valid fix:

# /opt/perl/bin/perl Makefile.PL --libs="-L/other/mysql/lib -lmysqlclient 
-lcrypt -lnsl -lm +Z"
I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I'/other/mysql/include'
  libs          (Users choice) = -L/other/mysql/lib -lmysqlclient -lcrypt 
-lnsl -lm +Z
  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'.

Unrecognized argument in LIBS ignored: '+Z'
Using DBI 1.38 installed in 
/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI
Writing Makefile for DBD::mysql
# make
        gcc -c  -I/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI 
-I'/other/mysql/include'  -mpa-risc-2-0 -D_HPUX_SOURCE -fno-stri
ct-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
(Continue reading)

Permalink | Reply | 1 comment |
headers
Jochen Wiedmann | 4 Nov 2003 07:16
Picon

Re: DBD::mysql install issues on HPUX 11.0

Keith Paschal wrote:

> I would say this is not a valid fix:
> 
> # /opt/perl/bin/perl Makefile.PL --libs="-L/other/mysql/lib 
> -lmysqlclient -lcrypt -lnsl -lm +Z"

Sorry, didn't notice that you are using gcc and not the HP compiler.
It's -fPIC then.

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 <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Kangara, Madhu | 4 Nov 2003 17:43
Favicon

RE: DBD::mysql install issues on HPUX 11.0

Here is a small HOWTO on compiling DBD::mysql on HPUX 11.0 which I compiled
3 months back

Special thanks to Jochen.
So here is what I have done.
1) Created a new mysql client with gcc 3.2.3 with following options

$ CFLAGS="-fomit-frame-pointer -O3 -fPIC"
$ CXX=gcc
$ CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O3 -fPIC"
$ ./configure --without-server --prefix=/usr/local/mysqlc --with-low-memory
--enable-thread-safe-client --enable-local-infile --with-pthread
--with-lib-ccflags=-fPIC --disable-shared

$ gmake 

# gmake install

$ /usr/local/mysqlc/bin/mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4429 to server version: 4.0.13

Reading history-file /home/madhu/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

2) Then compiled DBD-mysql
$ pwd
/apps/depot/sw/DBD-mysql-2.1026

$ perl Makefile.PL --cflags="-I/usr/local/mysqlc/include/mysql"
(Continue reading)

Permalink | Reply | 0 comments |
headers
Keith Paschal | 4 Nov 2003 20:36
Picon
Favicon

Re: DBD::mysql install issues on HPUX 11.0

Jochen;

Please excuse my ignorance...  ... you say:

>Sorry, didn't notice that you are using gcc and not the HP compiler.
>It's -fPIC then.

What's -fPIC?  I tried putting this at the end of the "Makefile" command, 
but that didn't work...  I'm starting to think windows DSN's are much better 
to use than Unix (heaven forbid, but they're easier to set up!!!)....

I hope I'm not asking too many stupid questions, but I'm not a sysAdmin (and 
not used to making stuff and compiling things... just used to writing 
scripts and such)...

Thanks;

Keith

>From: Jochen Wiedmann <joe <at> ispsoft.de>
>To: Keith Paschal <kwp0921 <at> hotmail.com>
>CC: perl <at> lists.mysql.com
>Subject: Re: DBD::mysql install issues on HPUX 11.0
>Date: Tue, 04 Nov 2003 07:16:04 +0100
>
>Keith Paschal wrote:
>
>>I would say this is not a valid fix:
>>
>># /opt/perl/bin/perl Makefile.PL --libs="-L/other/mysql/lib -lmysqlclient
(Continue reading)

Permalink | Reply | 1 comment |
headers
Jochen Wiedmann | 5 Nov 2003 13:09
Picon

Re: DBD::mysql install issues on HPUX 11.0

Keith Paschal wrote:

> Please excuse my ignorance...  ... you say:
> 
>> Sorry, didn't notice that you are using gcc and not the HP compiler.
>> It's -fPIC then.
> 
> 
> What's -fPIC?  I tried putting this at the end of the "Makefile" 
> command, but that didn't work...  I'm starting to think windows DSN's 
> are much better to use than Unix (heaven forbid, but they're easier to 
> set up!!!)....

See

     http://lists.mysql.com/perl/2548

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 <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Lionel David | 7 Nov 2003 09:36
Picon
Favicon

Pb : "DBD::mysql::db do failed: Can't create/write to file..."


> Hello,
>
> I've a very little experience with mysql/perl/perl's modules. I try to 
> install and to use the sympa server (mailing-list diffusion server) 
> which need his database with mysql. The database is created, but I 
> cannot access it, here are the error logs :
>
> >>unix passed to setlogsock, but path not available at 
> /home/sympa/bin/Log.pm line 95
> >>DBD::mysql::db do failed: Can't create/write to file 
> './sympa/user_table.frm' (Errcode: 13) at /home/sympa/bin/List.pm line 
> 6751.
> >>DBD::mysql::db do failed: Can't create/write to file 
> './sympa/subscriber_table.frm' (Errcode: 13) at 
> /home/sympa/bin/List.pm line 6751.
> >>Database sympa defined in sympa.conf has not the right structure or 
> is unreachable. If you don't use any database, comment db_xxx 
> parameters in sympa.conf
>
> I thought that it was a problem of databases' location or access 
> permissions but it's not. But user_table.frm and subscriber_table.frm 
> exists (in /usr/local/mysql/var/sympa - automatically created with a 
> sympa command).
>
> I search since 3 days, I already have asked to the sympa's 
> mailing-list, but no answer.
>
> Hope that someone can help me.
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Rudy Lippan | 7 Nov 2003 18:39

Re: Pb : "DBD::mysql::db do failed: Can't create/write to file..."

On Fri, 7 Nov 2003, Lionel David wrote:

> > Hello,

Hello,

> > >>DBD::mysql::db do failed: Can't create/write to file 
> > './sympa/user_table.frm' (Errcode: 13) at /home/sympa/bin/List.pm line 
> > 6751.
> > >>DBD::mysql::db do failed: Can't create/write to file 
> > './sympa/subscriber_table.frm' (Errcode: 13) at 
> > /home/sympa/bin/List.pm line 6751.
> > >>Database sympa defined in sympa.conf has not the right structure or 
> > is unreachable. If you don't use any database, comment db_xxx 
> > parameters in sympa.conf
> >
> > I thought that it was a problem of databases' location or access 
> > permissions but it's not. But user_table.frm and subscriber_table.frm 
> > exists (in /usr/local/mysql/var/sympa - automatically created with a 
> > sympa command).

It sounds like you have a permissions error and the mysql is not able to
write to the file and/or directory. Try chmoding it so that the user that 
you are runing the mysql daemon under has permssions to read and write to 
the files and directories.

Rudy

--

-- 
MySQL Perl Mailing List
(Continue reading)

Permalink | Reply | 0 comments |
headers
hari prasad nadig | 10 Nov 2003 12:09

DBD - Installation errors :(

I'm getting a whole pagefuk of errors :( Plz help..

dbdimp.c:425: (near initialization for `SQL_GET_TYPE_INFO_values[17]')
dbdimp.c:430: `FIELD_TYPE_BLOB' undeclared here (not in a function)
dbdimp.c:430: initializer element is not constant
dbdimp.c:430: (near initialization for 
`SQL_GET_TYPE_INFO_values[18].native_type')dbdimp.c:432: initializer
element is 
not constantdbdimp.c:432: (near initialization for 
`SQL_GET_TYPE_INFO_values[18]')dbdimp.c:437: `FIELD_TYPE_TINY_BLOB'
undeclared 
here (not in a function)dbdimp.c:437: initializer element is not constant
dbdimp.c:437: (near initialization for 
`SQL_GET_TYPE_INFO_values[19].native_type')dbdimp.c:439: initializer
element is 
not constantdbdimp.c:439: (near initialization for 
`SQL_GET_TYPE_INFO_values[19]')dbdimp.c:444: `FIELD_TYPE_MEDIUM_BLOB'
undeclared 
here (not in a function)dbdimp.c:444: initializer element is not constant
dbdimp.c:444: (near initialization for 
`SQL_GET_TYPE_INFO_values[20].native_type')dbdimp.c:446: initializer
element is 
not constantdbdimp.c:446: (near initialization for 
`SQL_GET_TYPE_INFO_values[20]')dbdimp.c:451: `FIELD_TYPE_LONG_BLOB'
undeclared 
here (not in a function)dbdimp.c:451: initializer element is not constant
dbdimp.c:451: (near initialization for 
`SQL_GET_TYPE_INFO_values[21].native_type')dbdimp.c:453: initializer
element is 
not constantdbdimp.c:453: (near initialization for
(Continue reading)

Permalink | Reply | 2 comments |

Gmane