Ubuntu
mysql-dfsg-5.1 package

installation broken when /tmp has insufficient permissions

Bug #188334 reported by Henning Holtschneider
This bug report is a duplicate of:  Bug #375371: MySQL must not use /tmp. Edit Remove
2
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.1 (Ubuntu)
Triaged
Wishlist
Unassigned

Bug Description

I just tried to install mysql-server-5.0 on a Ubuntu 7.10 server which accidentally had wrong permissions on the /tmp directory (755, owned by root:root). At first sight, the installations succeeds, but it ends up with only debian-sys-maint in the user table. So, no changes to the database are possible.

I suppose the problem is in the postinst script, which uses mktemp to create several temporary SQL scripts in /tmp. The postinst script does not verify if the temporary files have been created successfully. There isn't even a warning indicating that something went wrong while bootstrapping MySQL.

Revision history for this message
Mathias Gug (mathiaz) wrote : Re: [Bug 188334] [NEW] installation broken when /tmp has insufficient permissions

On Sat, Feb 02, 2008 at 01:08:42PM -0000, hehol wrote:
> I just tried to install mysql-server-5.0 on a Ubuntu 7.10 server which
> accidentally had wrong permissions on the /tmp directory (755, owned by
> root:root).

How come did this happen ?

> I suppose the problem is in the postinst script, which uses mktemp to
> create several temporary SQL scripts in /tmp. The postinst script does
> not verify if the temporary files have been created successfully. There
> isn't even a warning indicating that something went wrong while
> bootstrapping MySQL.

Seems reasonable to me.

  status confirmed
  importance wishlist

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com

Changed in mysql-dfsg-5.0:
importance: Undecided → Wishlist
status: New → Confirmed
Revision history for this message
Henning Holtschneider (henning-loca) wrote : Re: [Bug 188334] [NEW] installation broken when /tmp has insufficient permissions

On Sat, 2 Feb 2008 21:43:44 +0100 Mathias Gug <email address hidden>
wrote:

> On Sat, Feb 02, 2008 at 01:08:42PM -0000, hehol wrote:
> > I just tried to install mysql-server-5.0 on a Ubuntu 7.10 server
> > which accidentally had wrong permissions on the /tmp directory
> > (755, owned by root:root).
>
> How come did this happen ?

The problem occured on a hosted installation. Obviously, the hosting
company provided a broken OS image. But still, the postinst script
should not produce weird results when mktemp runs into problems.

Best regards,
Henning Holtschneider
--
LocaNet oHG - http://www.loca.net
Lindemannstrasse 81, D-44137 Dortmund
tel +49 231 91596-25, fax +49 231 91596-55
sip <email address hidden>

Registergericht Amtsgericht Dortmund HRA 14208
Geschäftsführer Sven Haufe, Henning Holtschneider

Mathias Gug (mathiaz)
Changed in mysql-dfsg-5.0:
status: Confirmed → Triaged
Chuck Short (zulcss)
affects: mysql-dfsg-5.0 (Ubuntu) → mysql-dfsg-5.1 (Ubuntu)
Revision history for this message
Chuck Short (zulcss) wrote :

This should be fixed in the next upload since it no longer depends on /tmp.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.