Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 06 Mar 2007 17:01:35 -0500
From:      Steve Bertrand <iaccounts@ibctech.ca>
To:        freebsd-questions@freebsd.org
Subject:   Re: upgraded 6.2 and mysql lost all privileges
Message-ID:  <45EDE4BF.3050406@ibctech.ca>
In-Reply-To: <45EDE2B7.2050705@enabled.com>
References:  <45EDB82D.2040300@enabled.com>	<45EDBBB5.7090600@alpha-tierchen.de>	<45EDCBF6.6040704@enabled.com>	<45EDD60B.2020006@unsane.co.uk>	<45EDE08F.3080707@enabled.com>	<20070306215038.GH86959@dan.emsphone.com> <45EDE2B7.2050705@enabled.com>

next in thread | previous in thread | raw e-mail | index | archive | help
>> In the last episode (Mar 06), Noah said:
>>> yeah - I have about 15 other user accounts specific to my mysql
>>> installation that were not in the /etc/passwd file.  where were those
>>> stored?
>>
>> If you're just talking about mysql users, those are in
>> /var/db/mysql/mysql/user.* .  An OS upgrade shouldn't have touched
>> them at all.  Unless you reformatted /var or something :)

It may be possible that mergemaster was used incorrectly.

If so, there should be a copy of the updated /etc/master.passwd file in:

# /var/tmp/temproot/etc

You can compare that against the new file in /etc. If they are the same, 
mergemaster hosed the original. I don't know if mergemaster makes a 
backup of the original, but it may be easier to pull master.passwd from 
a backup (you did backup /etc right?) and try re-merging if there were 
any differences.

Then again, I may be totally wrong with this assessment.

Steve



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?45EDE4BF.3050406>