From owner-freebsd-questions@FreeBSD.ORG Tue Mar 6 22:06:10 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 734BF16A401 for ; Tue, 6 Mar 2007 22:06:10 +0000 (UTC) (envelope-from admin2@enabled.com) Received: from typhoon.enabled.com (typhoon.enabled.com [216.218.220.21]) by mx1.freebsd.org (Postfix) with ESMTP id 5FD4313C478 for ; Tue, 6 Mar 2007 22:06:10 +0000 (UTC) (envelope-from admin2@enabled.com) Received: from [172.23.10.40] (nat-service4.juniper.net [66.129.225.151]) (authenticated bits=0) by typhoon.enabled.com (8.14.0/8.14.0) with ESMTP id l26M6167070680 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Tue, 6 Mar 2007 14:06:02 -0800 (PST) (envelope-from admin2@enabled.com) Message-ID: <45EDE5CB.5020502@enabled.com> Date: Tue, 06 Mar 2007 14:06:03 -0800 From: Noah User-Agent: Thunderbird 1.5.0.10 (Macintosh/20070221) MIME-Version: 1.0 To: Steve Bertrand 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> In-Reply-To: <45EDE4BF.3050406@ibctech.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org 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:06:10 -0000 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"