problem with instalaion of DBD::mysql

[gowthaman ramasamy]

Dear list,
i have a problem installing DBD::mysql module.
My built is FC3 on a P4 machine.
i installed mysql database via Mysql-serever-5.1.10-0.i386.rpm also via
a binary version of mysql-standard-4.1.10-pc-linux-gnu-i686.
both the mysql servers are fine. And i could install DBI modules thru
CPAN. But i could not install DBD::mysql thru cpan. I tried manually
too. i have attached the output produced by make and make test. Can some
one help me out.
I guess there si some problem with cflags and lib ... But i could not
sort it out 
Many thanks in advance ...
Sincerely,
gowtham


I will use the following settings for compiling and testing:

  cflags(mysql_config) = -I/usr/local/include/mysql
  libs  (mysql_config) = -L/usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
  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'.

Multiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI/ at Makefile.PL line 295
Using DBI 1.47 (for perl 5.008005 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::mysql
gcc -c  -I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ 
-I/usr/local/include/mysql -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS 
-DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE 
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 
-mtune=pentium4   -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC 
"-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE"   dbdimp.c
gcc -c  -I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ 
-I/usr/local/include/mysql -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS 
-DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE 
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 
-mtune=pentium4   -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC 
"-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE"   mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
/usr/bin/perl myld gcc  -shared -L/usr/local/lib dbdimp.o mysql.o  -o 
blib/arch/auto/DBD/mysql/mysql.so   -L/usr/local/lib/mysql -lmysqlclient -lz 
-lcrypt -lnsl -lm   
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/Mysql.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 
'blib/lib', 'blib/arch')" t/*.t
t/00base...install_driver(mysql) failed: Can't load 
'/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module 
DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file 
or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 
230.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/00base.t line 38
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/10dsnlistinstall_driver(mysql) failed: Can't load 
'/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module 
DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file 
or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 
230.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/10dsnlist.t line 45
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20createdrop.install_driver(mysql) failed: Can't load 
'/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module 
DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file 
or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 
230.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/20createdrop.t line 45
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetchinstall_driver(mysql) failed: Can't load 
'/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module 
DBD::mysql: libmysqlclient.so.14: ca

library mamager for linux

[gowthaman ramasamy]

Hi list,
can any one suggest a good PHP/mysql based library manager to manage
books,magazines, documents, cds etc . 
I tried libman .. but i am having problem with that .
many thanks in advance ...
with love
gowtham


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

displaying MySQL query results differently

[gowthaman ramasamy]

Dear list,

I want to display the result of the some mysql query differently .. 
I have a mysql table(allreps_orgs) with 2500,000 entries.

QUERY IS:
select distinct * from 
allreps_orgs as p1,allreps_orgs as p2, 
where p1.organism='Plasmodium' AND p2.organism='Caenorhabditis'  
AND p1.repeat=p2.repeat;
--
It displays the result correctly. But it joins two entries having same
values in repeat coloum. 

the typical result row looks like this.
|16804919|LKEKE|5|2|Plasmodium|1|155|22329777|LKEKE|5|2|Caenorhabditis|4|234|

In which first 7 columns are coming from one row and next 7 are from
another row which are satisfying the condition. 

I want these to be displayed in two different rows (first 7 in row 1 and
second 7 in row 2). Is it possible to that.

I could do it by displaying p1.* and p2.* in two different quries. But
that doubles the querying time. Any other suggestions or pointers.

following is my table structure. 
Note: i compare blob filed which is indexed in first 10 char. 
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| prot_id  | varchar(15)  | YES  | MUL | NULL|   |
| repeat   | blob | YES  | MUL | NULL|   |
| size_rep | int(10) unsigned | YES  | | NULL|   |
| freq | varchar(5)   | YES  | | NULL|   |
| organism | varchar(100) | YES  | | NULL|   |
| version  | char(3)  | YES  | | NULL|   |
| cordis   | blob | YES  | | NULL|   |




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

GUI for mysql

[gowthaman ramasamy]

dear users ...
i use MySQL 4.0.20 on RH7.3 on a sun fire workstation.
Can some one of you suggest a good GUI for mysql.
I also use Mysql 4.0.13-pc-linux-i686 on P4. 

many thanks in advance ..
-- 
Ra. Gowthaman,
Graduate Student,
Bioinformatics Lab,
Malaria Research Group,
ICGEB , New Delhi.
INDIA

Phone: 91-9811261804
   91-11-26173184; 91-11-26189360 #extn 314


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQl prints only first 1032 character in output line

[gowthaman ramasamy]

On Thu, 2004-03-25 at 21:23, Victoria Reznichenko wrote:
thank you dear victoria
it says 1024. How can i increase it?.

> 
> Check value of group_concat_max_len system variable:
> 
>   SELECT @@session.group_concat_max_len;





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQl prints only first 1032 character in output line

[gowthaman ramasamy]

hello list,
this is a MySQL realted question

I have a mySQL table with 15 columns. I query that table and group
(using GROUP_CONCAT) them based on one filed (say coloumn1). I get the
results. But, the result is truncated in some of the lines. It gets
truncated exactly after 1032th character of that line. Truncation
happens in lines having more than 1032 characters.
how can solve this ?

is this 1032 is limit set by mysql or linux (i use RH 7.3). How to sort
it out.
-- 
Ra. Gowthaman,
Graduate Student,
Bioinformatics Lab,
Malaria Research Group,
ICGEB , New Delhi.
INDIA

Phone: 91-9811261804
   91-11-26173184; 91-11-26189360 #extn 314


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]