A list about the Perl support for MySQL with msql-mysql-modules.

Carol Williams | 2 Feb 2005 18:34

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 2005 20:55

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 2005 11:09

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 2005 00:45

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 2005 20:10

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 2005 03:07

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 2005 10:12

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 2005 04:58

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 2005 17:11

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 2005 17:19

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)

Group

gmane.comp.db.mysql.perl.

Search Archive

Page

1 | 2 | 3

Articles in period: 27

February 2005

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

Please update DBD::MySQL with how to create test database (13 Apr 2013)
Still active? (12 Apr 2013)
question about stored procedures with Select statements and critical e (19 Jul 2012)
bind parameter guessing corrupts results (13 Feb 2012)
DBD::drizzle version 0.304 released (3 Nov 2011)
DBD::mysql: no errstr under Windows (18 Oct 2011)
want to install mysql client only (29 Sep 2011)
nature of the server side prepared statement issues? (26 Sep 2011)
can't call statistics_info() method (30 Aug 2011)
DBD::mysql 4.020 released (24 Aug 2011)
DBD::mysql 4.019 Released (9 May 2011)
The install fails due a missing compile parameter (9 May 2011)
Fwd: Patch for DBD::mysql (29 Apr 2011)
'sprintf' is not recognized as an internal or external command, operab (7 Apr 2011)
MySQL queries in a relational database (30 Mar 2011)
Insert or update data in mysql using a perl script (4 Mar 2011)
Bind parameters for SET statements (3 Mar 2011)
Perl script to insert data in mysql from Excel file (23 Feb 2011)
utf8 behavior and approach (24 Jan 2011)
DBD::MySQL (15 Nov 2010)
Faulty version check in foreign_key_info (27 Oct 2010)

Archives

4	April 2013
1	July 2012
5	February 2012
1	November 2011
1	October 2011
2	September 2011
2	August 2011
1	June 2011
4	May 2011
6	April 2011
10	March 2011
6	February 2011
1	January 2011
4	November 2010
2	October 2010
1	August 2010
9	July 2010
2	June 2010
3	May 2010
8	April 2010
3	March 2010
5	January 2010
6	December 2009
2	November 2009
5	October 2009
4	September 2009
2	August 2009
2	July 2009
4	June 2009
6	May 2009
3	April 2009
8	March 2009
6	February 2009
1	November 2008
4	October 2008
4	September 2008
3	August 2008
3	July 2008
7	June 2008
19	May 2008
15	April 2008
32	March 2008
7	February 2008
6	January 2008
47	December 2007
13	November 2007
18	October 2007
21	September 2007
7	August 2007
15	July 2007
5	June 2007
11	May 2007
13	April 2007
12	March 2007
13	February 2007
13	January 2007
6	December 2006
27	November 2006
6	October 2006
21	September 2006
25	August 2006
31	July 2006
25	June 2006
48	May 2006
13	April 2006
24	March 2006
48	February 2006
23	January 2006
21	December 2005
35	November 2005
19	October 2005
20	September 2005
18	August 2005
24	July 2005
27	June 2005
38	May 2005
28	April 2005
72	March 2005
24	February 2005
30	January 2005
47	December 2004
74	November 2004
20	October 2004
52	September 2004
60	August 2004
38	July 2004
80	June 2004
78	May 2004
88	April 2004
74	March 2004
50	February 2004
64	January 2004
50	December 2003
33	November 2003
103	October 2003
104	September 2003
128	August 2003
35	July 2003
11	June 2003
21	May 2003
7	April 2003
66	March 2003
37	February 2003
18	January 2003
14	December 2002
11	November 2002
24	October 2002
32	September 2002
22	August 2002
30	July 2002
11	June 2002

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template