You are viewing a plain text version of this content. The canonical link for it is here.

Posted to server-user@james.apache.org by emailguy <er...@fastmail.fm> on 2008/05/23 22:12:34 UTC

James & MySQL

1. I'm trying to use MySQL as the db for James 2.3.1. From the instructions
at 
http://james.apache.org/server/2.3.1/using_database.html

 I've changed config.xml at this point:

      <data-source name="maildb"
class="org.apache.james.util.dbcp.JdbcDataSource">
         <driver>org.gjt.mm.mysql.Driver</driver>
         <dburl>jdbc:mysql://localhost:3306/jamesemail</dburl>
         <user>myuser</user>
         <password>mypassword</password>
         <poolPreparedStatements>true</poolPreparedStatements>
         <max>20</max>
      </data-source>

I have also tried 
<dburl>com.mysql.jdbc.Driver</dburl>

After restarting James, I expected tables to be created in the jamesemail
database. Neither of these has caused the tables to be created in my
jamesemail database. What is wrong? 

2. My other questions is where should these be placed in config.xml?
Anywhere not contained by other tags?

<spoolRepository>
   <repository destinationURL="dbfile://maildb/spool/spool" type="SPOOL"/>
</spoolRepository>
<inboxRepository>
   <repository destinationURL="db://maildb/inbox/" type="MAIL"/>
</inboxRepository>



-- 
View this message in context: http://www.nabble.com/James---MySQL-tp17440114p17440114.html
Sent from the James - Users mailing list archive at Nabble.com.


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

Re: BOUNTY

Posted by Stefano Bagnara <ap...@bago.org>.

emailguy ha scritto:
> This worked for <spoolrepository> however, there does not appear to be an
> <inboxrepository> section. The spool table now exists in the mysql db. Any
> further help editing the config.xml file so that I get all of the possible
> tables into the mysql db would be appreciated. 

Try to send a message to an inbox.
The creation is delayed to the first use.

Stefano


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

Re: BOUNTY

Posted by Bernd Fondermann <be...@googlemail.com>.

On Sat, Jun 7, 2008 at 12:32 AM, Athar Shiraz Siddiqui
<at...@gmail.com> wrote:
> I totally agree. Great idea Fondermann (only a German could have
> thought of this innovative application)
>
> We should have some "net flix bounty" kind of fund where we give the
> highest prize to the team that comes up with a certain feature set.
>
> We should each contribute to a fund called the "Feature X Lottery"
> with a deadline on "fund collection closing date" (the higher the fund
> the greater the demand for the feature). We should store all paypaled
> money into an online savings account and then have teams go at the
> feature.
>
> Then we should appoint judges who evaluate the best team submissions.
> And award the prize to the winning team.
>
> What do you think?

Just to clarify: Apache's mission is to provide software for the
general public free of charge.
We won't have something like a fund for implementing features here.
And I doubt this would yield the best results. It would only push the
work yielding the most money.

Nevertheless, some Apache committers are paid for working on their
open source projects. At James, as far as I know, no committer is paid
for it.

  Bernd

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

Re: BOUNTY

Posted by Athar Shiraz Siddiqui <at...@gmail.com>.

I totally agree. Great idea Fondermann (only a German could have
thought of this innovative application)

We should have some "net flix bounty" kind of fund where we give the
highest prize to the team that comes up with a certain feature set.

We should each contribute to a fund called the "Feature X Lottery"
with a deadline on "fund collection closing date" (the higher the fund
the greater the demand for the feature). We should store all paypaled
money into an online savings account and then have teams go at the
feature.

Then we should appoint judges who evaluate the best team submissions.
And award the prize to the winning team.

What do you think?

On Fri, Jun 6, 2008 at 1:00 PM, Bernd Fondermann
<be...@googlemail.com> wrote:
> On Fri, Jun 6, 2008 at 4:26 PM, emailguy <er...@fastmail.fm> wrote:
>> Steve Short gets the $30.00. Thank you, Steve.
>> The bounty is closed.
>
> ;-)
> Great, this is a really innovative way to get people going to
> contribute to open source projects!
>
>  Bernd
>
> ---------------------------------------------------------------------
> 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

Re: BOUNTY

Posted by Bernd Fondermann <be...@googlemail.com>.

On Fri, Jun 6, 2008 at 4:26 PM, emailguy <er...@fastmail.fm> wrote:
> Steve Short gets the $30.00. Thank you, Steve.
> The bounty is closed.

;-)
Great, this is a really innovative way to get people going to
contribute to open source projects!

  Bernd

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