From owner-freebsd-questions@FreeBSD.ORG Fri Dec 28 00:21:19 2007 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 5519216A421 for ; Fri, 28 Dec 2007 00:21:19 +0000 (UTC) (envelope-from sdavtaker@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.245]) by mx1.freebsd.org (Postfix) with ESMTP id 06E4F13C457 for ; Fri, 28 Dec 2007 00:21:18 +0000 (UTC) (envelope-from sdavtaker@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so650690anc.13 for ; Thu, 27 Dec 2007 16:21:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; bh=CrbEfVh28pgVcpQOrFoWXiW44t6POnCEJisG5u5IWdA=; b=uP5v4ukAJKsg72IOGSx1T7KEjwFr+KaQH6N8r/+YA1Unn4OgiWz0hAurMHW9wowZsCf0bA7HHIdIeMQQNu/VsTW3izJ/IXFMCC0gi7WE6g2ocNNcGu6D53h+RhJQEjRoycWDyn3Wn4J9OoKka7B6TbG+vOF4c0AO3wo+IkYwYbQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=XP4ufXzEbEeLnHKkgxf7ZZ+1ZFSrCWKJHZfQxeqqQ9TCMx0RK6troYNo489zWWahVnkJ9RlAlnrRXDWnlJS1l92UkNnW3oEQ4EIlGeiK5E/ifzZ+1uG52lO4EFeH6fF90RZf3JhtytXXqcKTos6pavTZhG6dFxQKBpZ+jkIaa9s= Received: by 10.100.44.4 with SMTP id r4mr17723687anr.119.1198801277976; Thu, 27 Dec 2007 16:21:17 -0800 (PST) Received: from ?192.168.1.101? ( [190.18.36.119]) by mx.google.com with ESMTPS id m30sm13755351elf.17.2007.12.27.16.21.16 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 27 Dec 2007 16:21:17 -0800 (PST) Message-ID: <47744173.6090103@gmail.com> Date: Thu, 27 Dec 2007 21:21:07 -0300 From: =?ISO-8859-1?Q?Sd=E4vtaker?= User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: questions@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Subject: mysql port problem 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: Fri, 28 Dec 2007 00:21:19 -0000 Hello, I'd installed the mysql51-server port (actual snapshot, FBSD6.2r) After install I ran the create DBs scripts and tried to run a mysql client locally. Tried to run the mysqld manually and got a Socket error. /temp/mysql.sock is not.... I found the log file didnt log anything, so i started looking at the /var/db/mysql files... All files in /var/db/mysql were in wheel group and root owner, so I did chown -R mysql mysql chgrp -R mysql mysql After that it started working, im using it and can do all my work, but... Is it safe to set all those files to mysql user and mysql group? Why the port create those files with root and wheel if they cant be accessed. I found lots of people trying to find out why mysql says "sock error" after installation. I tried install mysql50-server and it has the same behavior and changing owner and group it is "solved" too. Can someone enlight me? Im running it from rc.conf with mysql_enable="YES" Thanks! Sdav