10 More Discussions You Might Find Interesting
1. AIX
Hi,
I have an AIX 7.1 lpar with cmake, gmp, libmpc, mpfr on it and a gcc 4.6.2 compiler that was made with the no-dependency flag.
I am trying to complile MySql5.5.28 from Oracle. Cmake runs fine. Then when I run make, I get the following:
<nyissz>
Scanning dependencies of target strings
... (12 Replies)
Discussion started by: Ismeret Tenger
12 Replies
2. Red Hat
I have removed php-5.1.6-27.el5 from our system. Because I installed it without mysql before.
How can I install php together with mysql.
# rpm -qa | grep mysql*
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-5.0.77-4.el5_4.2
mysql-server-5.0.77-4.el5_4.2
mysql-connector-odbc-3.51.26r1127-1.el5
##... (5 Replies)
Discussion started by: getrue
5 Replies
3. Solaris
Hello,
I'm trying to compile PHP 5.3.6 with Apache2 and MySql 5.5.12. I hit a problem that I can't seem to resolve by myself and I could not find a solution on the web.
It looks like Apache and MySql installed ok, I can start/stop them with no problem.
When I try to compile PHP the... (4 Replies)
Discussion started by: pn8830
4 Replies
4. Solaris
Hi folks
I am trying to compile SSCEP (Simple SCEP client for Unix) on Solaris 10 box. SSCEP - Simple SCEP client for Unix
The errror is "ld: fatal: Symbol referencing errors. No output written to"
$ make
gcc -Wall -O -lcrypto -o sscep sscep.o init.o net.o sceputils.o pkcs7.o ias.o... (2 Replies)
Discussion started by: slashdotweenie
2 Replies
5. Shell Programming and Scripting
Hi,
I want to connect perl with the mysql to select and so on but the connection don't work
code
#!/usr/bin/perl
BEGIN {
# PERL MODULES WE WILL BE USING
use DBI;
$dbh = DBI->connect('DBI:mysql:C:\Program Files\MySQL\MySQL Server 5.0\data\db1','','pass') or die $DBI::errstr;}
#... (1 Reply)
Discussion started by: eng_shimaa
1 Replies
6. Shell Programming and Scripting
I am getting the error "Can't call method "prepare" on an undefined value at..." with the following code:
<code>my %dbh;
my $dbh = DBI->connect("DBI:mysql:Customer_Data",
$username,
$password
) or die "Database connection... (1 Reply)
Discussion started by: vincaStar
1 Replies
7. Solaris
have installed and am using the GNU based tools from the Sunfreeware site to compile PHP. I already have Apache, MySQL, and Oracle compiled and working properly. Below is my configure string for my PHP build:
./configure --prefix=/usr/local/php5 \... (2 Replies)
Discussion started by: sunsysadm2003
2 Replies
8. Programming
Hi,
I have 2 files-->server.c and client.c
My server.c takes local ip as saying:
*.sin_addr.s_addr=INADDR_ANY;
client.c is in the same machine.It has a line like:
*.sin_addr.s_addr=inet_addr(argv);
I don't know how to compile.I tried
./client 127.0.0.1
It used port 7777 in both client... (2 Replies)
Discussion started by: mlhazan
2 Replies
9. Solaris
I'm trying to build 64 bit mysql-5.0.37 on Solaris 10.
CFLAGS="-O3" CXX='gcc -m64 -mcpu=v9' CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure -disable-shared --prefix=/usr/local/mysql --datadir=/home1/mysql_data --with-mysqld-user=mysql
... (0 Replies)
Discussion started by: csross
0 Replies
10. Programming
Hi all,
how do i compile a c program into a library on solaris
Thanks in advance
Zing (3 Replies)
Discussion started by: zing
3 Replies
Class::DBI::mysql(3pm) User Contributed Perl Documentation Class::DBI::mysql(3pm)
NAME
Class::DBI::mysql - Extensions to Class::DBI for MySQL
SYNOPSIS
package Film;
use base 'Class::DBI::mysql';
__PACKAGE__->set_db('Main', 'dbi:mysql:dbname', 'user', 'password');
__PACKAGE__->set_up_table("film");
__PACKAGE__->autoinflate(dates => 'Time::Piece');
# Somewhere else ...
my $type = $class->column_type('column_name');
my @allowed = $class->enum_vals('column_name');
my $tonights_viewing = Film->retrieve_random;
DESCRIPTION
This is an extension to Class::DBI, containing several functions and optimisations for the MySQL database. Instead of setting Class::DBI as
your base class, use this instead.
METHODS
set_up_table
__PACKAGE__->set_up_table("table_name");
Traditionally, to use Class::DBI, you have to set up the columns:
__PACKAGE__->columns(All => qw/list of columns/);
__PACKAGE__->columns(Primary => 'column_name');
Whilst this allows for more flexibility if you're going to arrange your columns into a variety of groupings, sometimes you just want to
create the 'all columns' list. Well, this information is really simple to extract from MySQL itself, so why not just use that?
This call will extract the list of all the columns, and the primary key and set them up for you. It will die horribly if the table contains
no primary key, or has a composite primary key.
autoinflate
__PACKAGE__->autoinflate(column_type => 'Inflation::Class');
__PACKAGE__->autoinflate(timestamp => 'Time::Piece');
__PACKAGE__->autoinflate(dates => 'Time::Piece');
This will automatically set up has_a() relationships for all columns of the specified type to the given class.
We currently assume that all classess passed will be able to inflate and deflate without needing extra has_a arguments, with the example of
Time::Piece objects, which we deal with using Time::Piece::mysql (which you'll have to have installed!).
The special type 'dates' will autoinflate all columns of type date, datetime or timestamp.
create_table
$class->create_table(q{
name VARCHAR(40) NOT NULL PRIMARY KEY,
rank VARCHAR(20) NOT NULL DEFAULT 'Private',
serial INTEGER NOT NULL
});
This creates the table for the class, with the given schema. If the table already exists we do nothing.
A typical use would be:
Music::CD->table('cd');
Music::CD->create_table(q{
cdid MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
artist MEDIUMINT UNSIGNED NOT NULL,
title VARCHAR(255),
year YEAR,
INDEX (artist),
INDEX (title)
});
Music::CD->set_up_table;
drop_table
$class->drop_table;
Drops the table for this class, if it exists.
column_type
my $type = $class->column_type('column_name');
This returns the 'type' of this table (VARCHAR(20), BIGINT, etc.)
enum_vals
my @allowed = $class->enum_vals('column_name');
This returns a list of the allowable values for an ENUM column.
retrieve_random
my $film = Film->retrieve_random;
This will select a random row from the database, and return you the relevant object.
(MySQL 3.23 and higher only, at this point)
SEE ALSO
Class::DBI. MySQL (http://www.mysql.com/)
AUTHOR
Tony Bowden
BUGS and QUERIES
Please direct all correspondence regarding this module to:
bug-Class-DBI-mysql@rt.cpan.org
COPYRIGHT AND LICENSE
Copyright (C) 2001-2005 Tony Bowden.
This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License; either version 2 of the License,
or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE.
perl v5.10.0 2005-09-03 Class::DBI::mysql(3pm)