Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 20119 - mysqltool gives wroing post-install advice
Summary: mysqltool gives wroing post-install advice
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: x86 Linux
: High normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-04-28 13:48 UTC by Jeremy Huddleston (RETIRED)
Modified: 2003-05-12 03:20 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
90_mysqltool.conf (90_mysqltool.conf,336 bytes, text/plain)
2003-05-05 01:40 UTC, Jeremy Huddleston (RETIRED)
Details
90_mysqltool.conf (90_mysqltool.conf,336 bytes, text/plain)
2003-05-05 01:40 UTC, Jeremy Huddleston (RETIRED)
Details
conf.d/apache (apache,1.00 KB, text/plain)
2003-05-05 01:41 UTC, Jeremy Huddleston (RETIRED)
Details
postinst and config patch (mysqltool-0.95-r2.ebuild.patch,973 bytes, patch)
2003-05-12 03:16 UTC, Jeremy Huddleston (RETIRED)
Details | Diff
small typo (mysqltool-0.95-r2.ebuild.patch,972 bytes, patch)
2003-05-12 03:20 UTC, Jeremy Huddleston (RETIRED)
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Jeremy Huddleston (RETIRED) gentoo-dev 2003-04-28 13:48:21 UTC
After emerging mysqltool, the following is printed:  
 * Please add the following to commonapache.conf: 
 * PerlRequire {apache_root}/conf/mysqltool.conf 
 * <Directory {apache_document_root}/htdocs/mysqltool> 
 * Options ExecCGI 
 * <Files *.cgi> 
 * SetHandler perl-script 
 * PerlHandler MysqlTool 
 * </Files> 
 * </Directory> 
 
 
I'm pretty sure '{apache_root}/conf/mysqltool.conf' should be 
'{apache_root}/conf/mysqltool.conf' 
 
~ $ locate mysqltool.conf 
/etc/apache/conf/addon-modules/mysqltool.conf 
 

Reproducible: Always
Steps to Reproduce:
1.
2.
3.



~ $ emerge info 
Portage 2.0.47-r10 (default-x86-1.4, gcc-3.2.2, glibc-2.3.1-r4) 
================================================================= 
System uname: 2.4.20-gaming-r2 i686 Intel(R) Pentium(R) 4 Mobile CPU 1.60GHz 
GENTOO_MIRRORS="http://gentoo.oregonstate.edu/ 
http://distro.ibiblio.org/pub/Linux/distributions/gentoo" 
CONFIG_PROTECT="/etc /var/qmail/control /usr/kde/2/share/config 
/usr/kde/3/share/config /usr/X11R6/lib/X11/xkb /usr/kde/3.1/share/config 
/usr/share/config" 
CONFIG_PROTECT_MASK="/etc/gconf /etc/env.d" 
PORTDIR="/usr/portage" 
DISTDIR="/usr/portage/distfiles" 
PKGDIR="/usr/portage/packages" 
PORTAGE_TMPDIR="/usr/tmp" 
PORTDIR_OVERLAY="/usr/local/portage" 
USE="3dnow zlib bonobo opengl ldap aalib acl acpi alsa apm arts atlas avi berkdb 
bobobo cdr crypt cups dga directfb doc dvb dvd encode esd evo fbcon flash gb gd 
gdbm ggi gif gnome gphoto2 gpm gps gtk gtk2 gtkhtml guile imap imlib innodb ipv6 
java jikes jpeg junit kde kerberos lcms ldam leim libg++ libgda libwww mbox mikmod 
mmx motif mozilla mpeg mule mysql nas ncurses nls odbc oggvorbis oss pam pcmcia 
pda pdflib perl pic plotutils png pnp postgres python qt quicktime radeon readline ruby 
samba sasl scanner sdl slang slp snmp socks5 spell sse ssl svga tcltk tcpd tetex tiff 
truetype trusted usb wmf X xml xml2 xmms xv x86 mozsvg mozcalendar mozxmlterm" 
COMPILER="gcc3" 
CHOST="i686-pc-linux-gnu" 
CFLAGS="-march=pentium3 -mcpu=pentium4 -O3 -pipe -fomit-frame-pointer 
-falign-functions=4 -falign-jumps=4 -falign-loops=4 " 
CXXFLAGS="-march=pentium3 -mcpu=pentium4 -O3 -pipe -fomit-frame-pointer 
-falign-functions=4 -falign-jumps=4 -falign-loops=4 " 
ACCEPT_KEYWORDS="x86 jer" 
MAKEOPTS="-j2" 
AUTOCLEAN="yes" 
SYNC="rsync://rsync.gentoo.org/gentoo-portage" 
FEATURES="ccache sandbox userpriv usersandbox"
Comment 1 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2003-04-28 15:01:34 UTC
You said:
"I'm pretty sure '{apache_root}/conf/mysqltool.conf' should be 
'{apache_root}/conf/mysqltool.conf'" 
I assume you meant:
'{apache_root}/conf/addon-modules/mysqltool.conf' ?

I tried emerging mysqltool and found it's hardcoded for apache1, so that needs to get fixed anyway.

I'm going to migrating it to the optional include style, so you just have to change the /etc/conf.d/apache file to add '-D MYSQLTOOL' or something similar :-).
Comment 2 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2003-05-04 07:40:07 UTC
ok, the fix is in the unstable tree. could you please test it?
It works fine for me with Apache2. I don't have any boxes with Apache1 or mod_perl, so could you please test those for me? It should work, because that hasn't changed really.
Comment 3 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-04 15:29:42 UTC
You might want to change the message to 'Edit /etc/conf.d/apache and add "-D MYSQLTOOL" 
 to APACHE_OPTS'.  It's obvious what you mean, but it will probably help one person out 
somewhere ;) 
 
But there is a problem. 
 
instead of installing to /home/httpd/htdocs/ and /etc/apache, it is installed to /.  I'm guessing 
the prefix didn't get guessed or something: 
 
>>> /mysqltool/ 
>>> /mysqltool/images/ 
>>> /mysqltool/images/dirtree_elbow.gif 
>>> /mysqltool/images/dirtree_tee.gif 
>>> /mysqltool/images/servers3.gif 
>>> /mysqltool/images/dirtree_minus_tee.gif 
>>> /mysqltool/images/dirtree_plus_elbow.gif 
>>> /mysqltool/images/mysql-18.gif 
>>> /mysqltool/images/dirtree_vertical.gif 
>>> /mysqltool/images/server2.gif 
>>> /mysqltool/images/field.gif 
>>> /mysqltool/images/user2.gif 
>>> /mysqltool/images/users.gif 
>>> /mysqltool/images/trash.gif 
>>> /mysqltool/images/dirtree_plus_tee.gif 
>>> /mysqltool/images/table.gif 
>>> /mysqltool/images/edit_pad.gif 
>>> /mysqltool/images/db.gif 
>>> /mysqltool/images/transparent.gif 
>>> /mysqltool/images/dirtree_minus_elbow.gif 
>>> /mysqltool/index.cgi 
>>> /conf/ 
>>> /conf/addon-modules/ 
>>> /conf/addon-modules/mysqltool.pl 
>>> /conf/addon-modules/90_mysqltool.conf 
... 
<<<        obj /home/httpd/htdocs/mysqltool/index.cgi 
<<<        obj /home/httpd/htdocs/mysqltool/images/users.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/user2.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/trash.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/transparent.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/table.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/servers3.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/server2.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/mysql-18.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/field.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/edit_pad.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/dirtree_vertical.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/dirtree_tee.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/dirtree_plus_tee.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/dirtree_plus_elbow.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/dirtree_minus_tee.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/dirtree_minus_elbow.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/dirtree_elbow.gif 
<<<        obj /home/httpd/htdocs/mysqltool/images/db.gif 
--- cfgpro obj /etc/apache/conf/addon-modules/mysqltool.conf 
--- cfgpro dir /etc/apache/conf/addon-modules 
--- cfgpro dir /etc/apache/conf 
--- cfgpro dir /etc/apache 
<<<        dir /usr/share/doc/mysqltool-0.95-r1 
<<<        dir /home/httpd/htdocs/mysqltool/images 
<<<        dir /home/httpd/htdocs/mysqltool 
 
Comment 4 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2003-05-04 21:51:02 UTC
whoops.
i made a minor mistake in it.
please try it again.
i really need an apache1 server to try stuff on again.
Comment 5 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-05 01:16:10 UTC
I'm getting permission problems when connecting to http://localhost/mysqltool.  The index.cgi file is 755, and if I "run" it to an index.html file, that loads fine, so it I believe the '-D MYSQLTOOL' is not setting the ExecCGI in the /mysqltool directory.
Comment 6 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2003-05-05 01:29:27 UTC
Could you please post the '90_mysqltool.conf' file that was installed to your apache/conf/addon-modules/ dir? Also could I get your /etc/conf.d/apache file?
It works fine on my apache2, and not having an apache1 box to test on it being a pain.
Comment 7 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-05 01:40:15 UTC
Created attachment 11507 [details]
90_mysqltool.conf
Comment 8 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-05 01:40:30 UTC
Created attachment 11508 [details]
90_mysqltool.conf
Comment 9 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-05 01:41:03 UTC
Created attachment 11509 [details]
conf.d/apache
Comment 10 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2003-05-11 21:24:28 UTC
i'll merge a new version shortly with the fix.
Comment 11 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2003-05-11 21:33:07 UTC
commited.
i've moved it to stable as well now, since that is all of the issues worked out.
please re-open if anything more occurs.
Comment 12 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-11 23:03:02 UTC
one more thing... shouldn't it depend on mod_perl rather than perl?
Comment 13 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2003-05-11 23:26:14 UTC
Nope, I don't think so.
I don't use or even have installed mod_perl on my Apache2 system. I don't use it at all for anything. I just use plain perl.

The only time mod_perl would be needed, would be if they were using -D PERL in the conf.d/apache, which is beyond us. If they do have it installed, we support it, but we work anyway.

Possibly mod_perl needs a use flag, but I don't feel that would really add much at all.
Comment 14 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-12 03:16:58 UTC
Created attachment 11813 [details, diff]
postinst and config patch

The user needs to add 'Include	conf/addon-modules/90_mysqltool.conf' to the
bottom of /etc/apache/conf/apache.conf if they're using apache1, and this patch
to the ebuild helps them out with that.
Comment 15 Jeremy Huddleston (RETIRED) gentoo-dev 2003-05-12 03:20:52 UTC
Created attachment 11814 [details, diff]
small typo

small typo in the last patch... sorry