Carol Williams | 2 Feb 18:34 2005
Picon

Compile Problems on AIX 5.2

I am trying to compile the module DBD-mysql-2.9004 on
an AIX 5.2 server, running perl 5.8.5 and mysql 4.1.8.
 I am using the AIX C compiler version 6.0.  Both perl
and mysql were compiled using this compiler.  I get
the following error when I try to compile the
DBD-mysql module.

Running Mkbootstrap for DBD::mysql ()
        chmod 644 mysql.bs
        rm -f blib/arch/auto/DBD/mysql/mysql.so
        LD_RUN_PATH="" /usr/bin/perl myld ld  -bhalt:4
-bM:SRE
-bI:/usr/local/lib/perl5/5.8.5/aix/CORE/perl.exp
-bE:mysql.exp -bnoentry -lc -L/usr/local/lib dbdimp.o 
mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so  
-L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl_r
-lm -lz   
ld: 0711-317 ERROR: Undefined symbol:
.mysql_field_seek
ld: 0711-317 ERROR: Undefined symbol:
.mysql_fetch_field
ld: 0711-317 ERROR: Undefined symbol: .mysql_errno
ld: 0711-317 ERROR: Undefined symbol: .mysql_error
ld: 0711-317 ERROR: Undefined symbol: .mysql_init
ld: 0711-317 ERROR: Undefined symbol: .mysql_options
ld: 0711-317 ERROR: Undefined symbol:
.mysql_real_connect
ld: 0711-317 ERROR: Undefined symbol:
.mysql_real_escape_string
ld: 0711-317 ERROR: Undefined symbol:
(Continue reading)

Rudy Lippan | 2 Feb 20:55 2005

Re: Compile Problems on AIX 5.2

On Wed, 2 Feb 2005, Carol Williams wrote:

> Date: Wed, 2 Feb 2005 09:34:28 -0800 (PST)
> From: Carol Williams <cshw2002 <at> yahoo.com>
> To: perl <at> lists.mysql.com
> Subject: Compile Problems on AIX 5.2
> 
> I am trying to compile the module DBD-mysql-2.9004 on
> an AIX 5.2 server, running perl 5.8.5 and mysql 4.1.8.
>  I am using the AIX C compiler version 6.0.  Both perl
> and mysql were compiled using this compiler.  I get
> the following error when I try to compile the
> DBD-mysql module.
> 
> Running Mkbootstrap for DBD::mysql ()
>         chmod 644 mysql.bs
>         rm -f blib/arch/auto/DBD/mysql/mysql.so
>         LD_RUN_PATH="" /usr/bin/perl myld ld  -bhalt:4
> -bM:SRE
> -bI:/usr/local/lib/perl5/5.8.5/aix/CORE/perl.exp
> -bE:mysql.exp -bnoentry -lc -L/usr/local/lib dbdimp.o 
> mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so  
> -L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl_r
> -lm -lz   
> ld: 0711-317 ERROR: Undefined symbol:
> .mysql_field_seek
> ld: 0711-317 ERROR: Undefined symbol:
> .mysql_fetch_field
> ld: 0711-317 ERROR: Undefined symbol: .mysql_errno
> ld: 0711-317 ERROR: Undefined symbol: .mysql_error
(Continue reading)

Mohammad | 5 Feb 11:09 2005
Picon

RE: DBD::mysql always fails

Hi all,
On a freshly installed Solaris 8 OS, I installed gcc, make, tar and perl
from sunfreeware.com, downloaded the 32bit version of mysql from
mysql.com, DBI and DBD::mysql from CPAN. Now everything is working fine,
actually I was trying to install first a 64bit version of mysql and
after the failure I was trying to install 32 bit version on the same OS
which were giving me the error so I installed a fresh OS and then
started the installation of 32 bit version which works fine.

Thanks to all who responded.

Mohammad Junaid

-----Original Message-----
From: Mohammad [mailto:php <at> cyberia.net.sa] 
Sent: Monday, January 31, 2005 3:26 PM
To: david <at> lcscreative.com
Cc: perl <at> lists.mysql.com
Subject: RE: DBD::mysql always fails

David,
I installed first 64bit and then 32bit binary version 4.1.8 downloaded
from mysql.com, every time I am getting the same problem. I was using a
perl 5.8.3 binary downloaded from sunfreeware.com. Every time I was
getting same error only when I installed active perl as per Lapin's
suggestion it started working with a warning that multi-threaded perl
should not be used in production.

Mohammad Junaid

(Continue reading)

Wendy Tan | 8 Feb 00:45 2005
Picon

RedHat E3/MySQL 4.1.9/ - can not install DBD-MySQL 2.9004

Do DBD-MySQL 2.9004 and Msql-Mysql perl modules work with MySQL 4.1.9?
When I try to install DBD-MySQL after sucessfully installing MySQL
4.1.9, I got following error messages. 
So I tried to unstall 4.1.9 and wanted to go with RedHat Enterprice 3's
original MySQL version 3.23.58, mysql deamon can not be installed
anymore. I checked it with 'rpm -qi mysql-3.23.58' command. It's
installed indeed but mysql deamon can not be found anywhere. 
Can you help me solve one of above? Thanks a lot. 

DBD-mysql-2.1013]$ perl -w Makefile.PL
I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/usr/include/mysql -mcpu=i486
-fno-strength-reduce
  libs          (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lcrypt
-lnsl -lm -lz -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files
-lnss_dns -lresolv
  nocatchstderr (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'.

Unsuccessful stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97.
Unsuccessful stat on filename containing newline at
(Continue reading)

Jochen Wiedmann | 8 Feb 20:10 2005
Picon

Re: RedHat E3/MySQL 4.1.9/ - can not install DBD-MySQL 2.9004

On Mon, 7 Feb 2005 15:45:38 -0800 (PST), Wendy Tan <wendyzqt <at> yahoo.com> wrote:

> Makefile:89: *** missing separator.  Stop.

This is a well known problem with late RH and Fedora releases, which
has been asked (and replied) a real lot on this list and should be
easily solvable be googling a little bit. :-(

A simple

    export LANG=C

before doing the installation should do.

Jochen

-- 
Sum. Cogitone?

--

-- 
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

J Wermont | 10 Feb 03:07 2005
Picon

need the list of possible values of a column

Hi, MySQL and Perl newbie here. Please don't hurt me! :)

I'm trying to get information, from within a Perl script, about a
column in one of my tables. It's a "set" type, and I need to know
what the order is for the list of possible values.

Ex: I have a column called "subjects" in one of my tables, whose
type is "set". The possible values of this column is a list that
looks like this:

"school",
"parent",
"sibling",
"friends",
"drugs",
"money",
"sports",
"movies",
"videogames",
"homework",
"teachers"

How would I obtain this list from a perl script?

Thanks,
J. Wermont

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
(Continue reading)

Christoffer Vig | 10 Feb 10:12 2005
Picon

Re: need the list of possible values of a column

Hi,
You should get the values with something like

my $sth = $dbh->column_info(undef, 'your_database', 'your_table', '%');
my $row = $sth->fetchall_hashref('COLUMN_NAME');
my $listofvalues = $row->{your_columnname}->{mysql_values};
print "your set was: " . join (",",  <at> {$listofvalues});

best regards Christoffer

On Wed, 9 Feb 2005 18:07:17 -0800, J Wermont <jwermont <at> sonic.net> wrote:
> Hi, MySQL and Perl newbie here. Please don't hurt me! :)
> 
> I'm trying to get information, from within a Perl script, about a
> column in one of my tables. It's a "set" type, and I need to know
> what the order is for the list of possible values.
> 
> Ex: I have a column called "subjects" in one of my tables, whose
> type is "set". The possible values of this column is a list that
> looks like this:
> 
> "school",
> "parent",
> "sibling",
> "friends",
> "drugs",
> "money",
> "sports",
> "movies",
> "videogames",
(Continue reading)

Daniel Kasak | 11 Feb 04:58 2005
Picon

ANN: Gtk2::Ex::DBI-0.7

I'm pleased to annouce the 7th 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.

This release completes support for MS SQL Server ( and almost certainly 
Sybase ) via DBD::ODBC. Other servers may also work with via DBD::ODBC.

Postgres support is *very* close. I basically need to know how to fetch 
the sequence of an inserted record via $dbh->last_insert_id ... but I 
don't use Postgres and the docs are a little obscure on what's needed. 
Postgres users are encouraged to step up to the plate and complete this 
small missing link :)

Dan

--

-- 
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

Boysenberry Payne | 11 Feb 17:11 2005

Installed too many mysqls

I was having issues with getting DBD installed and during my 
troubleshooting
efforts ended up installing a couple of mysql packages.  Now only one 
works,
and not the one I'd like to use.  When I try and run the I'd like to it 
gives me a can't
open mysql.sock errors.  I've read a little about using alternative 
locations for the
sock, but I'd like to use the default position /tmp/mysql.sock.
I'm on OS X 10.3 and have tried to uninstall using the instructions 
found here:
http://entropy.ch/software/macosx/mysql/
It uninstalled one, but I still have one exsisting that has a lock on 
the current
mysql.sock...

Thanks Ahead of time,
Boysenberry

--

-- 
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

Jan Eden | 11 Feb 17:19 2005

UNION statement to sort search results twice

Hi,

I wrote a search script which can search  only the page titles and author names for articles on my site or the
titles/authors and the pages' content.

To get the results for the two types in two sets, I used a UNION construct:

if ($search_string) {

    my $where_author_title = qq{(authors.last_name LIKE '\%$search_string\%' OR authors.first_name
LIKE '\%$search_string\%' OR pages.title LIKE '\%$search_string\%')};

    my $where_content = qq{MATCH(content) AGAINST ('$search_string' IN BOOLEAN MODE)};

    my  <at> wheres = ( $where_author_title );
    push  <at> wheres, $where_content if $volltext;

    my $query = join 'UNION', map(qq{(SELECT pages.page_id, pages.title, authors.first_name,
authors.last_name, pages.visible, pages.user_id FROM pages JOIN authors USING (author_id) WHERE $_
AND site_id = $sitemode ORDER BY pages.title)},  <at> wheres);

Later on, I test each row returned by the UNION statement if the $search_string is either in the title or in
the author's name. If not, I print a dividing line and a subheader once.

The result looks ok, something like:

Search results for 'Perl'

Title/author
...
(Continue reading)


Gmane