From owner-freebsd-questions@FreeBSD.ORG Fri Oct 13 08:33:10 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 57A3916A40F for ; Fri, 13 Oct 2006 08:33:10 +0000 (UTC) (envelope-from on@cs.ait.ac.th) Received: from mail.cs.ait.ac.th (mail.cs.ait.ac.th [192.41.170.16]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7B28743D46 for ; Fri, 13 Oct 2006 08:33:09 +0000 (GMT) (envelope-from on@cs.ait.ac.th) Received: from banyan.cs.ait.ac.th (banyan.cs.ait.ac.th [192.41.170.5]) by mail.cs.ait.ac.th (8.13.1/8.12.11) with ESMTP id k9D8WsGY012336 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 13 Oct 2006 15:32:54 +0700 (ICT) Received: (from on@localhost) by banyan.cs.ait.ac.th (8.13.3/8.12.11) id k9D8X8Tr017407; Fri, 13 Oct 2006 15:33:08 +0700 (ICT) Date: Fri, 13 Oct 2006 15:33:08 +0700 (ICT) Message-Id: <200610130833.k9D8X8Tr017407@banyan.cs.ait.ac.th> From: Olivier Nicole To: coughlandesmond@yahoo.fr In-reply-to: <20061013082110.83079.qmail@web27509.mail.ukl.yahoo.com> (message from Desmond Coughlan on Fri, 13 Oct 2006 10:21:08 +0200 (CEST)) References: <20061013082110.83079.qmail@web27509.mail.ukl.yahoo.com> X-Virus-Scanned: on CSIM by amavisd-milter (http://www.amavis.org/) Cc: freebsd-questions@freebsd.org Subject: Re: MySQL and Roundcube Problem - db won't start! 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, 13 Oct 2006 08:33:10 -0000 Hi, > With the gracious help of a poster here, I managed to get roundcube up and running, and had to resort to MySQL, which I know very little of. > > After it was all up and running, and we'd added the users and tested their access to webmail, we decided to put some more memory into the machine. So a quick shutdown later, and we were powering back up. Disaster: MySQL didn't start and so roundcube mail just gives us 'service currently unavailable' !! > > I've scoured the MySQL website, FAQ, etc., but can I start the damned database? Can I hell. > > [root@rachi]/usr/local/bin(111): ./mysqladmin start > ./mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' > Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! You say too little about your system to allow proper help. How did you install MySQL? Fro the source? From the ports? From package? If you installed MySQL through FreeBSD mechanism, it should be started with the comand: /usr/local/etc/rc.d/mysql.sh start provided you have put mysql_enable="YES" in /etc/rc.conf Else youmust locate your MySQL log file and see why it is not starting, if it is failingbecause of some error. mysqladmin is a command to MySQL database server, so it suppose that MySQL is running beforeyou can issue any mysqladmin command. Bests, Olivier