Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 06 Mar 2007 14:06:03 -0800
From:      Noah <admin2@enabled.com>
To:        Steve Bertrand <iaccounts@ibctech.ca>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: upgraded 6.2 and mysql lost all privileges
Message-ID:  <45EDE5CB.5020502@enabled.com>
In-Reply-To: <45EDE4BF.3050406@ibctech.ca>
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> <45EDE4BF.3050406@ibctech.ca>

next in thread | previous in thread | raw e-mail | index | archive | help
I dont think that is the issue.  the problem is with the mysql virtual 
users

they do not appear in the /etc/passwd or /etc/master.passwd files.

so that is the wrong direction.
cheers,
Noah


Steve Bertrand wrote:
>>> 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
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe@freebsd.org"



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