From owner-freebsd-questions@FreeBSD.ORG Tue Mar 6 22:03:44 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 6DFD116A402 for ; Tue, 6 Mar 2007 22:03:44 +0000 (UTC) (envelope-from iaccounts@ibctech.ca) Received: from pearl.ibctech.ca (pearl.ibctech.ca [208.70.104.210]) by mx1.freebsd.org (Postfix) with ESMTP id 11B7613C46B for ; Tue, 6 Mar 2007 22:03:43 +0000 (UTC) (envelope-from iaccounts@ibctech.ca) Received: (qmail 12055 invoked by uid 1002); 6 Mar 2007 22:03:43 -0000 Received: from iaccounts@ibctech.ca by pearl.ibctech.ca by uid 89 with qmail-scanner-1.22 (spamassassin: 2.64. Clear:RC:1(208.113.63.132):. Processed in 9.938061 secs); 06 Mar 2007 22:03:43 -0000 Received: from unknown (HELO ?192.168.1.22?) (steve@ibctech.ca@208.113.63.132) by pearl.ibctech.ca with SMTP; 6 Mar 2007 22:03:32 -0000 Message-ID: <45EDE4BF.3050406@ibctech.ca> Date: Tue, 06 Mar 2007 17:01:35 -0500 From: Steve Bertrand User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: freebsd-questions@freebsd.org 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> In-Reply-To: <45EDE2B7.2050705@enabled.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: upgraded 6.2 and mysql lost all privileges X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 06 Mar 2007 22:03:44 -0000 >> 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