mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Stefan Bethke
Since last year, updates to mysql-client-5.5.x kept breaking all dependant 
ports, including the server itself.  Apparently, the client library could not 
be located, thus triggering a re-install of the client, which failed because 
the client was already installed.  At the same time, the old binaries would not 
be able to find the client library, because the so version had been bumped.

I finally found the culprit, after trying to replicate the situation in a 
sandbox (instead of on my main mail server): the ${PREFIX)/lib/mysql dir is 
created with the standard umask, instead of overriding the bits.

In my particular case, the umask is set to 0002 instead of the default 0022, 
leaing to a lib dir with rwxrwxr-x.  ldconfig(8) refuses to take libs from 
group-writable directories.

It appears that the mkdir for this dir is somewhere inside the install target 
of MySQL, so I'n not certain what the easiest way would be to fix the 
permission bits.

I've updated my portupgrade script to reset the umask to avoid similar problems


Stefan

-- 
Stefan Bethke s...@lassitu.de   Fon +49 151 14070811



___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Robert Huff

For the record: the upgrade wo 5.5.10 went smoothly here, vith
both server and client appearing (on very minimal testing) to work
as before.


Robert Huff
___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Patrick Powell

On 03/20/11 06:39, Robert Huff wrote:

For the record: the upgrade wo 5.5.10 went smoothly here, vith
both server and client appearing (on very minimal testing) to work
as before.


Robert Huff
___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


did they fix the broken mysql_install_db which has bad values for
the various paths?


--
Patrick Powell Astart Technologies
papow...@astart.com1530 Jamacha Road, Suite X,
Network and System San Diego, CA 92019
  Consulting   858-874-6543
Web Site: www.astart.com

___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Jerry
On Sun, 20 Mar 2011 07:19:11 -0700
Patrick Powell papow...@astart.com articulated:

 On 03/20/11 06:39, Robert Huff wrote:
  For the record: the upgrade wo 5.5.10 went smoothly here,
  vith both server and client appearing (on very minimal testing) to
  work as before.
 
 
  Robert Huff
  ___
  freebsd-ports@freebsd.org mailing list
  http://lists.freebsd.org/mailman/listinfo/freebsd-ports
  To unsubscribe, send any mail to
  freebsd-ports-unsubscr...@freebsd.org
 
 did they fix the broken mysql_install_db which has bad values for
 the various paths?

Well, if it was broken it must have been fixed since I have not
experienced a single problem after updating the system last night. I
did need to reboot the system after the initial install since Postfix
was complaining. After that, all is working well.

-- 
Jerry ✌
freebsd-ports.u...@seibercom.net

Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the Reply-To header.
__

___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Patrick Powell

On 03/20/11 07:33, Jerry wrote:

On Sun, 20 Mar 2011 07:19:11 -0700
Patrick Powellpapow...@astart.com  articulated:


On 03/20/11 06:39, Robert Huff wrote:

For the record: the upgrade wo 5.5.10 went smoothly here,
vith both server and client appearing (on very minimal testing) to
work as before.


Robert Huff
___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to
freebsd-ports-unsubscr...@freebsd.org


did they fix the broken mysql_install_db which has bad values for
the various paths?

Well, if it was broken it must have been fixed since I have not
experienced a single problem after updating the system last night. I
did need to reboot the system after the initial install since Postfix
was complaining. After that, all is working well.



Try running mysql_update and mysql_install_db.  The last version of 
these died with error messages indicating they could not find 
executables.   The problem appeared to be that the scripts were 
generated with either null paths for the executable directories or the 
path was ./ (./data was one).   I suspect that the original script 
values did not

have entries for the paths.

--
Patrick Powell Astart Technologies
papow...@astart.com1530 Jamacha Road, Suite X,
Network and System San Diego, CA 92019
  Consulting   858-874-6543
Web Site: www.astart.com

___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Steven Hartland


- Original Message - 
From: Patrick Powell papow...@astart.com
Try running mysql_update and mysql_install_db.  The last version of 
these died with error messages indicating they could not find 
executables.   The problem appeared to be that the scripts were 
generated with either null paths for the executable directories or the 
path was ./ (./data was one).   I suspect that the original script 
values did not

have entries for the paths.


I just updated here and no problems with mysql_upgrade there is
no mysql_update, I assume that was just a typo?

   Regards
   Steve


This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. 


In the event of misdirection, illegible or incomplete transmission please 
telephone +44 845 868 1337
or return the E.mail to postmas...@multiplay.co.uk.

___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Patrick Powell

On 03/20/11 13:20, Steven Hartland wrote:


- Original Message - From: Patrick Powell papow...@astart.com
Try running mysql_update and mysql_install_db.  The last version of 
these died with error messages indicating they could not find 
executables.   The problem appeared to be that the scripts were 
generated with either null paths for the executable directories or 
the path was ./ (./data was one).   I suspect that the original 
script values did not

have entries for the paths.


I just updated here and no problems with mysql_upgrade there is
no mysql_update, I assume that was just a typo?

   Regards
   Steve


This e.mail is private and confidential between Multiplay (UK) Ltd. 
and the person or entity to whom it is addressed. In the event of 
misdirection, the recipient is prohibited from using, copying, 
printing or otherwise disseminating it or any information contained in 
it.
In the event of misdirection, illegible or incomplete transmission 
please telephone +44 845 868 1337

or return the E.mail to postmas...@multiplay.co.uk.


My bad.  That was mysql_upgrade.  Sorry for the confusion.  How about 
mysql_install_db?


--
Patrick Powell Astart Technologies
papow...@astart.com1530 Jamacha Road, Suite X,
Network and System San Diego, CA 92019
  Consulting   858-874-6543
Web Site: www.astart.com

___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Steven Hartland
- Original Message - 
From: Patrick Powell papow...@astart.com
My bad.  That was mysql_upgrade.  Sorry for the confusion.  How about 
mysql_install_db?


Can't test that I'm afraid as the machine is now in production. Might want
to make sure the old mysql pkg was removed correctly before the new
version was installed.

If you want to compare your version with the one we have I've uploaded
to: http://www.multiplaygameservers.com/dropzone/mysql_install_db.gz

Hope that helps.

   Regards
   Steve


This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. 


In the event of misdirection, illegible or incomplete transmission please 
telephone +44 845 868 1337
or return the E.mail to postmas...@multiplay.co.uk.

___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Alex Dupre

Stefan Bethke ha scritto:

In my particular case, the umask is set to 0002 instead of the default 0022


http://lists.freebsd.org/pipermail/freebsd-ports/2007-September/043529.html


I've updated my portupgrade script to reset the umask to avoid similar problems


Correct way to install ports.

--
Alex Dupre
___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Stefan Bethke
Am 20.03.2011 um 22:43 schrieb Alex Dupre:

 Stefan Bethke ha scritto:
 In my particular case, the umask is set to 0002 instead of the default 0022
 
 http://lists.freebsd.org/pipermail/freebsd-ports/2007-September/043529.html
 
 I've updated my portupgrade script to reset the umask to avoid similar 
 problems
 
 Correct way to install ports.

Won't argue with Kris, but I still think that the login shell from which I 
initiate a port build should have limited, well-documented effects on the 
result of that build, and with most ports, that is the case.


Stefan

-- 
Stefan Bethke s...@lassitu.de   Fon +49 151 14070811



___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org


Re: mysql-client-5.5.10 fails to install properly, breaking all dependant ports

2011-03-20 Thread Patrick Powell

On 03/20/11 14:38, Steven Hartland wrote:

- Original Message - From: Patrick Powell papow...@astart.com
My bad.  That was mysql_upgrade.  Sorry for the confusion.  How about 
mysql_install_db?


Can't test that I'm afraid as the machine is now in production. Might 
want

to make sure the old mysql pkg was removed correctly before the new
version was installed.

If you want to compare your version with the one we have I've uploaded
to: http://www.multiplaygameservers.com/dropzone/mysql_install_db.gz

Hope that helps.

   Regards
   Steve


This e.mail is private and confidential between Multiplay (UK) Ltd. 
and the person or entity to whom it is addressed. In the event of 
misdirection, the recipient is prohibited from using, copying, 
printing or otherwise disseminating it or any information contained in 
it.
In the event of misdirection, illegible or incomplete transmission 
please telephone +44 845 868 1337

or return the E.mail to postmas...@multiplay.co.uk.



Yep.  Still messed up:

At the start you have:

basedir=
builddir=
ldata=./data
langdir=
srcdir=

This should be:


basedir=/usr/local  finds /usr/local/bin
builddir=
ldata=/var/db/mysql/  set up by some other parts of the configure 
script

  but not put into mysql_install_db script
langdir=
srcdir=

I use this quite heavily in some test scripts and installation scripts.  
Not to mention
that it pops up during the MySQL installation.   You also might have a 
peek at the
messages put out during installation.  They say something like ... start 
using:

/usr/local/etc/rc.d/mysql-server.sh start  drop the .sh

I would have put in a formal PR but I gave up trying to patch the source 
code.

Perhaps a little edit script in the pre-install part of the make file?

--
Patrick Powell Astart Technologies
papow...@astart.com1530 Jamacha Road, Suite X,
Network and System San Diego, CA 92019
  Consulting   858-874-6543
Web Site: www.astart.com

___
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org