From owner-freebsd-questions@FreeBSD.ORG Thu Dec 29 12:18:00 2005 Return-Path: X-Original-To: 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 733DB16A41F for ; Thu, 29 Dec 2005 12:18:00 +0000 (GMT) (envelope-from vaaf@broadpark.no) Received: from osl1smout1.broadpark.no (osl1smout1.broadpark.no [80.202.4.58]) by mx1.FreeBSD.org (Postfix) with ESMTP id DD81843D5F for ; Thu, 29 Dec 2005 12:17:59 +0000 (GMT) (envelope-from vaaf@broadpark.no) Received: from broadpark.no ([217.13.4.96]) by osl1smout1.broadpark.no (Sun Java System Messaging Server 6.1 HotFix 0.05 (built Oct 21 2004)) with ESMTP id <0IS9002VYEDW9KB0@osl1smout1.broadpark.no> for questions@freebsd.org; Thu, 29 Dec 2005 13:22:44 +0100 (CET) Received: from [80.202.4.61] (Forwarded-For: [213.187.181.70]) by bgo1mstore1.broadpark.no (mshttpd); Thu, 29 Dec 2005 13:17:55 +0100 Date: Thu, 29 Dec 2005 13:17:55 +0100 From: Kristian Vaaf To: questions@freebsd.org Message-id: MIME-version: 1.0 X-Mailer: Sun Java(tm) System Messenger Express 6.1 HotFix 0.05 (built Oct 21 2004) Content-type: text/plain; charset=us-ascii Content-language: en Content-transfer-encoding: 7BIT Content-disposition: inline X-Accept-Language: en Priority: normal Cc: Subject: Weird database error 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: Thu, 29 Dec 2005 12:18:00 -0000 Hello! I have a serious problem. I am running a regular FreeBSD 4.11 jail, under which I've installed mysql-client-5.0.16 and mysql-server-5.0.16 plus the PHP modules and extensions. I've created a database like this: CREATE DATABASE msc; GRANT USAGE ON msc.* TO msc@localhost IDENTIFIED BY 'aheeem'; GRANT ALL ON msc.* TO msc@localhost; and then proceeded to install WordPress (the publishing platform). The installation was flawless! Here's the actual problem. Every morning when I wake up, WordPress has an "Error establishing the database connection". And that makes no sense, because I have not been messing with the database nor with WordPress. The database is still there. Now, the _strange_ thing is, that shortly after (from 5 to 15 minutes) I've logged onto my FreeBSD jail via SSH (and also mysql -u root -p to check if the database is still there), WordPress can mysteriously re-establish the database connection. That is, I just click Firefox's reload. What is going on ;) Thanks a lot, Kristian