Jochen Wiedmann | 1 Nov 11:46 2003
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)

Tony Dean | 3 Nov 13:50 2003
Picon

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

Keith Paschal | 4 Nov 01:51 2003
Picon

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)

Jochen Wiedmann | 4 Nov 07:16 2003
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

Kangara, Madhu | 4 Nov 17:43 2003

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)

Keith Paschal | 4 Nov 20:36 2003
Picon

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)

Jochen Wiedmann | 5 Nov 13:09 2003
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

Lionel David | 7 Nov 09:36 2003
Picon

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)

Rudy Lippan | 7 Nov 18:39 2003

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)

hari prasad nadig | 10 Nov 12:09 2003

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)


Gmane