this code snippet... einfo "Setting correct privelegies" mysql -p mysql --exec="GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON ${mybugsdb}.* TO ${mybugsu ser}@${mybugshost} IDENTIFIED BY '${mybugspwd}'; FLUSH PRIVILEGES;" || die will not work, if i have database elsewhere than localhost. ps: privelegies needs spell-check ;) when the configure asked from me mysql bugs db host [localhost]: dbhost.lan i assumed, it's the host where *BUGZILLA* will connect for database. but now this same information is used for GRANT tables. but to grant tables there should go information of CLIENT address, in this case is the address where bugzilla.cgi will run. # ebuild /var/db/pkg/net-www/bugzilla-2.17.6-r2/bugzilla-2.17.6-r2.ebuild config * Finalizing the installation of bugzilla in /var/www/bugzilla mysql bugs db name [bugs]: mysql bugs db host [localhost]: dbhost.lan mysql bugs dbuser name [bugs]: mysql bugs dbuser password: bugz * Setting correct privelegies Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) !!! ERROR: net-www/bugzilla-2.17.6-r2 failed. !!! Function pkg_config, Line 104, Exitcode 1 !!! (no error message) so, as a solution it should say 'enter USERNAME/PASSWORD to adjust GRANT privileges on $mybugshost. it should then also figure out client address. or it should not be ran at all if dbhost is not localhost, and if it is so, then just print out commands that one should run on database server with full priviledges (or at least GRANT privs). Reproducible: Always Steps to Reproduce: 1. 2. 3.
Created attachment 31983 [details] modified bugzilla-2.17.6-r2.ebuild ok, i've attached my modified ebuild. feel free to correct my english and make texts more clear. also it fixes various permission problems for running crontab.
Created attachment 31984 [details, diff] the diffs a diff, for easier read. the ebuild i attached had some parts commented out (i forgot), which prevented double configure. these are not in this diff.
Thanks for your patch. If bugzilla really is being installed into /var/www/bugzilla, then it looks like that ebuild is long overdue an overhaul anyway :( Best regards, Stu
Created attachment 35186 [details] bugzilla-2.18.0_rc1.ebuild Stuart, Your wish is my command :) Attached is an overhauled version of the ebuild - now uses webapp-config - version bump to the latest RC - incorporated the MySQL server location patch (fixed a typo in a variable name as well) - needs dev-perl/PatchBuilder, which is also attached
Created attachment 35189 [details] files/bugzilla.conf
Created attachment 35190 [details] files/postinstall-en.txt
Created attachment 35191 [details] files/reconfig
Created attachment 35192 [details] files/bugzilla.conf files/bugzilla.conf has been modified, use it instead of the original one. Don't forget to copy over the rest of /usr/portage/net-www/bugzilla/files
Created attachment 35193 [details] dev-perl/PatchReader/PatchReader-0.9.4.ebuild
Wow. Thank you. I'll give this some testing as soon as I can. Best regards, Stu
Okay, this is now in Portage. Should appear on your local rsync mirror in about an hour. Please take it out for a test drive, and let me know what I've broken ;-) Best regards, Stu
