Return-Path: 
 <server-user-return-20951-apmail-james-server-user-archive=james.apache.org@james.apache.org>
X-Original-To: apmail-james-server-user-archive@www.apache.org
Delivered-To: apmail-james-server-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 4C0A0D7F6
	for <apmail-james-server-user-archive@www.apache.org>;
 Fri, 29 Jun 2012 04:11:16 +0000 (UTC)
Received: (qmail 38293 invoked by uid 500); 29 Jun 2012 04:11:16 -0000
Delivered-To: apmail-james-server-user-archive@james.apache.org
Received: (qmail 38111 invoked by uid 500); 29 Jun 2012 04:11:15 -0000
Mailing-List: contact server-user-help@james.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:server-user-unsubscribe@james.apache.org>
List-Help: <mailto:server-user-help@james.apache.org>
List-Post: <mailto:server-user@james.apache.org>
List-Id: "James Users List" <server-user.james.apache.org>
Reply-To: "James Users List" <server-user@james.apache.org>
Delivered-To: mailing list server-user@james.apache.org
Received: (qmail 38054 invoked by uid 99); 29 Jun 2012 04:11:13 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Jun 2012 04:11:13 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=RCVD_IN_DNSWL_NONE,RCVD_NUMERIC_HELO,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [195.238.6.173] (HELO mailrelay007.isp.belgacom.be)
 (195.238.6.173)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Jun 2012 04:11:05 +0000
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: 
 Au8FAAwq7U9btyYw/2dsb2JhbABFtkGBCYIYAQEEATgWCCIGCwgDGAkWDwkDAgECAR8IHgYIBQIEAQEBARkEh2UJB7kQizcZAYVwA5UygRKOcYJhgV0
Received: from 48.38-183-91.adsl-static.isp.belgacom.be (HELO localhost)
 ([91.183.38.48])
  by relay.skynet.be with ESMTP; 29 Jun 2012 06:10:45 +0200
MIME-Version: 1.0
X-UserIsAuth: true
Received: from 91.178.198.182 (EHLO [192.168.1.5]) ([91.178.198.182])
          by srv002 (JAMES SMTP Server ) with ESMTPA ID 302563265;
          Fri, 29 Jun 2012 06:10:44 +0200 (CEST)
Message-ID: <4FED2AC2.5080908@apache.org>
Date: Fri, 29 Jun 2012 06:10:42 +0200
From: Eric Charles <eric@apache.org>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:11.0) Gecko/20120402 Thunderbird/11.0.1
To: James Users List <server-user@james.apache.org>
Subject: Re: how to persist mails in database
References: <34086759.post@talk.nabble.com> <4FECA1F7.9070605@apache.org>
 <A33537BE-8531-4484-A890-41D9DA1C6346@gmail.com>
In-Reply-To: <A33537BE-8531-4484-A890-41D9DA1C6346@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 06/29/2012 05:23 AM, Timothy Prepscius wrote:
> I just want you to know I got a chuckle out of the YourSQL no MySQL pun.

:)

NoSQL?

> On Jun 28, 2012, at 2:27 PM, Eric Charles wrote:
>
>> Hi,
>>
>> You're trying James2 way.
>>
>> If you have james_mailbox table, I suppose you run James3. In that case, the vanilla installation is already configured to persist the mails in an embedded derby database.
>>
>> Read http://james.apache.org/server/3/config-system.html#james-database.properties to change the settings to use YourSQL, nope, MySQL :) (and don't forget to put the jdbc driver jar in ./conf/lib).
>>
>> Thx, Eric
>>
>> On 06/28/2012 05:08 PM, gamliela wrote:
>>>
>>> I'm trying to persist mails to MySQL.
>>>
>>> I try this code but I get exception:
>>> <mailet match="All" class="ToRepository">
>>>     <repositoryPath>db://maildb/outbox</repositoryPath>
>>> </mailet>
>>>
>>> Obviously that's because I didn't create any mailbox associated with this
>>> path (james_mailbox table is empty).
>>> The problem is that I couldn't find any document that describes how to do
>>> that....
>>> JMX management doesn't support mailbox operations, and I don't know how to
>>> create the records in database manually.
>>>
>>> help please...
>>>
>>> P.S.
>>> Database is working fine with James, schema was created, domains and users
>>> are set.
>>>
>>
>> --
>> eric | http://about.echarles.net | @echarles
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>

-- 
eric | http://about.echarles.net | @echarles

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org