From: Chris Hoogendyk (choogend@library.umass.edu)
Date: Sat May 24 2003 - 11:07:01 EDT
Sorry for my delay in continuing this. I thought I had someone who
could help, but got no further response. So I'm back to the group. I
will need to follow this up agressively in the next few days. If I get
no further advice, I'm going to rebuild all the perl stuff from scratch.
One concern I have is the possibility of breaking existing web stuff that
is successfully using the perl 5.8 from SunFreeware.
TIA
I got a number of people saying that there might be conflicts if
different components are built with different compilers (one suggested
that they use the Forte compiler for SunFreeware) and that I needed to
build all the perl stuff, including perl itself, locally using
gcc. A few others said they had the same combination I had & it worked.
One said they gave up and built everything from scratch. One said I
really needed to get gmake and not rely on /usr/ccs/bin/make. So, I'm
kind of left wondering whether I need to start over from scratch or
whether there is something that just needs to be configured or
rearranged to work properly.
Our web team has been using the Perl 5.8.0 for some time successfully. I
think I have mysql running alright from the SunFreeware build. I can do
the mysqladmin queries, but, depending on what I try, I sometimes get
disallowed. I assume that is a simple matter of proper user and
privileges in the mysql database setup.
When I try run-all-tests, I get
-------------------------
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/mysql/mysql.so'
for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal:
libmysqlclient.so.10: open failed: No such file or directory at
/usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 45) line 3
Compilation failed in require at (eval 45) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/mysql/sql-bench/server-cfg line 238
-------------------------
but that looks like it has nothing to do with mysql and everything to do
with the DBD and DBI stuff.
on the other hand, when I did the DBD and DBI installs using source from
CPAN, it looked alright.
In the mysql/bin directory, I did a "ln -s mysqld-safe mysqld", because
I was getting errors at one point saying it couldn't find that. I also
copied the my-medium.cnf to /etc/my.cnf.
I also got the following when testing mysql
-------------------------
/usr/local/mysql# bin/mysqlshow
bin/mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
/usr/local/mysql# su mysql
$PWD# /bin/ksh
/usr/local/mysql# PS1='$PWD\$ '
/usr/local/mysql$ export PS1
/usr/local/mysql$ bin/mysqlshow
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+
/usr/local/mysql$ bin/mysqlshow mysql
bin/mysqlshow: Access denied for user: '@localhost' to database 'mysql'
/usr/local/mysql$ bin/mysqlshow test
Database: test
+--------+
| Tables |
+--------+
+--------+
-------------------------
/usr/local/mysql/bin$ ./mysqladmin version
./mysqladmin Ver 8.23 Distrib 3.23.53, for sun-solaris2.8 on sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.53-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 28 min 55 sec
Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1
Open tables: 0 Queries per second avg: 0.001
-------------------------
my system is:
$PATH=/usr/local/bin:/usr/sbin:/usr/bin:/usr/ccs/bin
gcc version 2.95.3 20010315 (release)
perl, v5.8.0 built for sun4-solaris
mysql-3.23.53-sol8-sparc-local
DBI-1.35
DBD-mysql-2.1026
Sun E250, Solaris 8, relatively current patches (need to do this month's),
TIA for any advice you can offer.
---------------
Chris Hoogendyk
-- O__ ---- Network Specialist & Unix Systems Administrator c/ /'_ --- Library Information Systems & Technology Services (*) \(*) -- W.E.B. Du Bois Library ~~~~~~~~~~ - University of Massachusetts, Amherst <choogend@library.umass.edu> --------------- _______________________________________________ sunmanagers mailing list sunmanagers@sunmanagers.org http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:26:28 EDT