Welcome to the MacNN Forums.

simonmartin · Jun 18, 2003, 08:21 AM

Hi,

I have managed to bluff my way through installing 'Webmin". It looks awsomely powerful so I really want to get to understand it.

My prime concern is to be able to manage mySQL through it. To do this I need to install some additional modules, two of them. The first one installed fine but "Installation of DBD::mysql failed"

The output from Webmin says:

Executing /usr/bin/perl Makefile.PL && make ..

/usr/local/bin/mysql_config: cd: /usr/local/mysql/: No such file or directory
/usr/local/bin/mysql_config: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: No such file or directo
ry
/usr/local/bin/mysql_config: exec: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: cannot execute: N
o such file or directory
/usr/local/bin/mysql_config: cd: /usr/local/mysql/: No such file or directory
/usr/local/bin/mysql_config: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: No such file or directo
ry
/usr/local/bin/mysql_config: exec: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: cannot execute: N
o such file or directory
/usr/local/bin/mysql_config: cd: /usr/local/mysql/: No such file or directory
/usr/local/bin/mysql_config: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: No such file or directo
ry
/usr/local/bin/mysql_config: exec: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: cannot execute: N
o such file or directory
/usr/local/bin/mysql_config: cd: /usr/local/mysql/: No such file or directory
/usr/local/bin/mysql_config: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: No such file or directo
ry
/usr/local/bin/mysql_config: exec: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: cannot execute: N
o such file or directory
/usr/local/bin/mysql_config: cd: /usr/local/mysql/: No such file or directory
/usr/local/bin/mysql_config: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: No such file or directo
ry
/usr/local/bin/mysql_config: exec: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: cannot execute: N
o such file or directory
/usr/local/bin/mysql_config: cd: /usr/local/mysql/: No such file or directory
/usr/local/bin/mysql_config: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: No such file or directo
ry
/usr/local/bin/mysql_config: exec: /tmp/.webmin/DBD-mysql-2.1027/bin/mysql_config: cannot execute: N
o such file or directory
Failed to determine directory of libmysqlclient.a|libmysqlclient.so. Use

perl Makefile.PL "--libs=-L
-lmysqlclient" to set this directory. For details see the INSTALL.html file, section "Linker flags" or type perl Makefile.PL --help

Installation of DBD::mysql failed. Check the output above and try installing manually.
You can also install the module from CPAN with the command perl -MCPAN -e shell

I attempted the last suggestion, to use CPAN.

This was going swimmingly until:
Connected to cpan.topo.teleglobe.net.
220 cont1.lhx.teleglobe.net FTP server ready.
331 Anonymous login ok, send your complete email address as your password.
230-************************************************** ******************
mirror.teleglobe.net hosted in London, UK

You are connection 21. Total connections allowed is 400.

On This Site:
CPAN Comprehensive Perl Archive Network
CTAN Comprehensive TeX Archive Network
apache Apache Distribution
ftp.debian.org Debian Linux ftp repository
ftp.gnu.org GNU ftp repository
ftp.kernel.org Kernel.org ftp repository
ftp.modssl.org modssl.org ftp repository
ftp.mozilla.org Mozilla.org software repository
ftp.openssl.org openssl.org ftp repository
ftp.qmail.org Qmail ftp repository
ftp.redhat.com Redhat.com ftp repository
ftp.sunfreeware.com SunFreeware.com ftp repository
gutenberg Project Gutenberg
mysql MySQL ftp repository
postfix Postfix software repository
sunsolve Sunsolve SUN Patches
winsite winsite.com ftp repository
www.analog.cx analog.cx web stats
ftp.isc.org ISC ftp repository
************************************************** *******************

230 Anonymous access granted, restrictions apply.
Remote system type is UNIX.
Using binary mode to transfer files.
Local directory now /Users/simon/n/sources/authors/id/A/AN/ANDK
250 CWD command successful.
250 CWD command successful.
250 CWD command successful.
250 CWD command successful.
250 CWD command successful.
250 CWD command successful.
250 CWD command successful.
250 CWD command successful.
200 Type set to I.
local: CPAN-1.70.tar.gz remote: CPAN-1.70.tar.gz
500 EPSV not understood.
227 Entering Passive Mode (195,219,14,24,221,139).
150 Opening BINARY mode data connection for CPAN-1.70.tar.gz (132124 bytes).
100% |*************************************| 129 KB 65.91 KB/s 00:00 ETA
226 Transfer complete.
132124 bytes received in 00:01 (65.86 KB/s)
221 Goodbye.
GOT n/sources/authors/id/A/AN/ANDK/CPAN-1.70.tar.gz

CPAN: MD5 security checks disabled because MD5 not installed.
Please consider installing the MD5 module.

sh: n/sources/authors/id/A/AN/ANDK/CPAN-1.70.tar.gz: No such file or directory
tar: End of archive volume 1 reached
tar: Sorry, unable to determine archive format.
n/sources/authors/id/A/AN/ANDK/CPAN-1.70.tar.gz: No such file or directory
Couldn't uncompress n/sources/authors/id/A/AN/ANDK/CPAN-1.70.tar.gz

cpan>

I then couldn't bluff any further and had to exit.

Can anyone help me past this?

Many thanks!

(The above are edited from the outputs of the terminal. I have more...)

Simon
London Uk

clam2000 · Jun 18, 2003, 09:59 AM

Webmin should be able to connect to your MySQL database locally through a socket even if you don't have the DBD::mysql module.

The DBD module has a fairly long list of dependencies, so you can't just install it by itself. (I know it requires DBI and some others)

figure out where mysql is on your system, because it doesn't seem to be in /usr/local/mysql where your install is looking for it... you should be able to specify where it is (perl Makefile.PL --help)

--will

simonmartin · Jun 18, 2003, 10:16 AM

Originally posted by clam2000:
figure out where mysql is on your system, because it doesn't seem to be in /usr/local/mysql where your install is looking for it... you should be able to specify where it is (perl Makefile.PL --help)

--will

clam2000,

Thanks for showing up...

I have actually corrected the path to /usr/local/bin/mysql

I'm still being told that:

Warning: The Perl module DBD::mysql is not installed on your system, so Webmin will not be able to reliably access your MySQL database. Click here to install it now

If I do follow the link I get the result I posted before. One of the dependencies installed fine but looking at the printout it looks as it there is a problem with a particular file which was downloaded.

Maybe I can just ignore the warning?

Thanks

Simon

snerdini · Jun 20, 2003, 11:14 PM

Webmin is great, but for MySQL management, I highly recommend phpmyadmin. Check it out

simonmartin · Jun 21, 2003, 01:25 AM

Originally posted by snerdini:
Webmin is great, but for MySQL management, I highly recommend phpmyadmin. Check it out

snerdini,

I have managed to get them both running in fact. It seems useful to have webmin as a backup to phpmyAdmin for using mySQL. Yesterday I ran 'Cocktail' and emptied all my cashes. This trashed /temp/mysql.sock which in turn meant that mySQL wouldn't start up. I don't know anything other than the most basic CL stuff and <mysql_safe &.> gave an error and phpmyAdmin can't be used to start mysql but webmin can.

Saved me looking even more silly in these forums ;-)

Simon

Paul McCann · Jun 21, 2003, 02:38 AM

Your CPAN installation isn't working because it's misconfigured. When you did the first run through (giving it the info about where to store things and where to get modules from) you've inadvertantly answered "n" to a question that was expecting a directory; hence you see things like

"sh: n/sources/authors/id/A/AN/ANDK/CPAN-1.70.tar.gz: No such file or directory"

in your output. You'll need to initialise the CPAN shell again. To do this get back in with the usual incantation. Nope, better, just use

% sudo cpan

which does the same thing. Enter your password, and once the cpan shell begins enter

o conf init

and carefully answer each of the questions. Your current values will be the defaults for each parameter, so watch carefully for that errant "n".

Cheers,
Paul

simonmartin · Jun 21, 2003, 02:58 AM

Originally posted by Paul McCann:
Your CPAN installation isn't working because it's misconfigured. When you did the first run through (giving it the info about where to store things and where to get modules from) you've inadvertantly answered "n" to a question that was expecting a directory; hence you see things like

"sh: n/sources/authors/id/A/AN/ANDK/CPAN-1.70.tar.gz: No such file or directory"

in your output. You'll need to initialise the CPAN shell again. To do this get back in with the usual incantation. Nope, better, just use

% sudo cpan

which does the same thing. Enter your password, and once the cpan shell begins enter

o conf init

and carefully answer each of the questions. Your current values will be the defaults for each parameter, so watch carefully for that errant "n".

Cheers,
Paul

Paul,

I managed to get things working right in the end. Not sure what I did though to be honest, I've been chasing my tail a lot in the last few days :-)

Part of the problem was that I had 2 versions of mysql running. Once I deleted the rogue one webmin installed the module just fine.

You can't help me with my 'connection refused'problem in the OSX forum can you ;-)

Thanks mate.

Simon
London Uk