Hi there,
I have done some experiments with james 2.3 and now I'm trying to move on to
James 3. the problem is the lack of documentation specially when it comes to
DB configurations. I tried to use the same configs from james 2.3 to run
james 3 with MySql backend but till now I got actually nothing. can any one
point out the points I didn't made right in my config files?
this is my *database.properties *file:


# Use derby as default
database.driverClassName=org.apache.james.util.dbcp.JdbcDataSource
database.url=jdbc:mysql://127.0.0.1/james3test
database.username=myDbUser
database.password=myDbPass

# Supported adapters are:
# DB2, DERBY, H2, HSQL, INFORMIX, MYSQL, ORACLE, POSTGRESQL, SQL_SERVER,
SYBASE
vendorAdapter.database=MYSQL

# Use streaming for Blobs
# This is only supported on a limited set of databases atm. You should check
if its supported by your DB before enable
# it.
#
# See:
#
http://openjpa.apache.org/builds/latest/docs/manual/ref_guide_mapping_jpa.html
#7.11.  LOB Streaming
#
openjpa.streaming=false


but I actually don't know what should I change in *mailstore.xml *to store
the mails inside DB. or where to configure to store users in DB.

Thanks in advance,
Mohammad Naghavi
________________________________________
PHP & ASP .Net 3.5 web developer
Java & C# desktop developer
www.mohamnag.com



On Thu, Nov 11, 2010 at 2:36 PM, Eric Charles <[email protected]> wrote:

> Hi Ran,
> That's really great!!!
> If you like, you can add yourself to
> http://wiki.apache.org/james/JamesUsers :) (I still need to link the web
> site to this page...)
>
> I will also publish your notes/ref via Twitter @ApacheJames.
>
> The memory usage should still be lower with M2 tks to optimizations on
> activemq component.
>
> Tks,
>
> Eric
>
>
>
> On 11/11/2010 06:45, RanBing wrote:
>
>> I'm running a very early James 3 on a Linux 64 for mass marketing and the
>> memory stays at 320MB under load.
>>
>> br
>>
>>
>> --------------------------------------------------
>> From: "Eric MacAdie" <[email protected]>
>> Sent: Thursday, November 11, 2010 12:29 PM
>> To: "James Users List" <[email protected]>
>> Subject: Re: Quick Start for 3.0-M2
>>
>>  I have a couple of questions:
>>>
>>> 1. One of the requirements is 512 MB of RAM. I am running my site (and a
>>> James server) on a VPS account that has 512 MB RAM total. Is James 3 not an
>>> option for me?
>>>
>>> 2. Are there plans on documenting how to add users to the database? If I
>>> can run James 3 on my VPS, I may be able to help with this. Telnetting into
>>> the remote manager is not something I have any interest in at all.
>>>
>>> Regards,
>>> Eric MacAdie
>>> President, Chicago Java Users Group
>>> http://blog.cjug.org
>>>
>>> On 11/8/2010 4:21 AM, Eric Charles wrote:
>>>
>>>> Hi Everyone,
>>>>
>>>> I tried to make a short (though complete) quick start doc for 3.0-M2.
>>>> The goal of the doc is to allow anyone to start with James binary
>>>> distribution as an operational mail server.
>>>>
>>>> Feel free to give it a try (should be valid for 3.0-M1) and send your
>>>> feedback so we can have the best possible doc for upcoming 3.0-M2 release.
>>>> Tks,
>>>>
>>>> Eric
>>>>
>>>> Step 0: Requirements
>>>> ####################
>>>>
>>>> JRE 1.5+
>>>> root (linux/unix) or Administrator (Windows)
>>>> libc6 (linux)
>>>> 512MB RAM
>>>>
>>>> Step 1: Download
>>>> #################
>>>>
>>>> Download james-server-container-spring-3.0-M2-bin.zip from
>>>> http://james.apache.org/download.cgi#Apache_James_Server
>>>>
>>>> Step 2: Deploy
>>>> ##############
>>>>
>>>> Unzip james-server-container-spring-3.0-M2-bin.zip.
>>>> You should have a folder with sub-folders bin, conf, lib, log, var and
>>>> four text files.
>>>>
>>>> $ unzip james-server-container-spring-3.0-M2-bin.tar.gz
>>>> $ cd james-server-container-spring-3.0-M2
>>>> $ ls -l
>>>> drwxrwxrwx. 2 root root  4096 2010-11-06 09:24 bin
>>>> -rw-r--r--. 1 root root   495 2010-11-06 08:56 BUILD.txt
>>>> drwxrwxrwx. 4 root root  4096 2010-11-06 14:43 conf
>>>> drwxrwxrwx. 2 root root 12288 2010-11-06 09:01 lib
>>>> -rw-r--r--. 1 root root 12082 2010-11-01 17:23 LICENSE.txt
>>>> drwxrwxrwx. 2 root root  4096 2010-11-06 09:24 log
>>>> -rw-r--r--. 1 root root  1579 2010-11-01 17:23 NOTICE.txt
>>>> -rw-r--r--. 1 root root  1545 2010-11-06 08:55 README.txt
>>>> drwxrwxrwx. 6 root root  4096 2010-11-06 09:25 var
>>>>
>>>>
>>>> Step 3: Configure
>>>> #################
>>>>
>>>> All configuration files reside in the conf folder.
>>>>
>>>> $ cd conf
>>>> $ ls -l
>>>> -rw-------. 1 root root  1414 2010-11-05 16:01 database.properties
>>>> -rw-------. 1 root root  2749 2010-10-21 14:07 dnsservice.xml
>>>> -rw-------. 1 root root  2802 2010-11-06 09:22 domainlist.xml
>>>> -rw-------. 1 root root 18599 2010-10-21 14:07 fetchmail.xml
>>>> -rw-------. 1 root root  3201 2010-10-21 14:07 imapserver.xml
>>>> -rw-------. 1 root root  2850 2010-11-04 08:10 james-listmanager.xml
>>>> -rw-------. 1 root root  5821 2010-10-21 14:07 jcr-repository.xml
>>>> -rw-------. 1 root root     0 2010-11-05 16:01 jmx.access
>>>> -rw-------. 1 root root     0 2010-11-05 16:01 jmx.password
>>>> -rw-------. 1 root root   961 2010-11-06 08:42 jmx.properties
>>>> drwxrwxrwx. 2 root root  4096 2010-10-21 14:07 lib
>>>> -rw-------. 1 root root  3129 2010-10-21 14:07 lmtpserver.xml
>>>> -rw-------. 1 root root  7463 2010-11-05 15:54 log4j.properties
>>>> -rw-------. 1 root root 31478 2010-11-06 09:22 mailetcontainer.xml
>>>> -rw-------. 1 root root  2473 2010-11-06 09:22 mailserver.xml
>>>> -rw-------. 1 root root  5234 2010-10-21 14:54 mailstore.xml
>>>> drwxrwxrwx. 2 root root  4096 2010-10-21 14:07 META-INF
>>>> -rw-------. 1 root root  8038 2010-10-21 14:07 miResources.xml
>>>> -rw-------. 1 root root  3327 2010-10-21 14:07 pop3server.xml
>>>> -rw-------. 1 root root  3369 2010-10-21 14:07 remotemanager.xml
>>>> -rw-------. 1 root root 15837 2010-11-05 15:54 smtpserver.xml
>>>> -rw-------. 1 root root 21941 2010-11-05 16:01 spring-beans.xml
>>>> -rw-------. 1 root root 48523 2010-10-21 14:07 sqlResources.xml
>>>> -rw-------. 1 root root  4301 2010-10-29 15:48 usersrepository.xml
>>>> -rw-------. 1 root root  2465 2010-10-21 14:07 virtualusertable.xml
>>>> -rw-------. 1 root root 13680 2010-11-06 09:01 wrapper.conf
>>>>
>>>>
>>>> James is packaged with virtual hosting disabled, XML domain list, JPA
>>>> (Derby database) storage for the mails and remote delivery from locahost
>>>> only.
>>>> You can edit the following files to change the behaviour:
>>>>
>>>> - Enable virtual hosting in mailserver.xml: vi mailserver.xml
>>>> &lt;enableVirtualHosting&gt; true &lt;/enableVirtualHosting&gt;
>>>>
>>>> - Replace the XMLDomainList with the JPADomainList: vi
>>>> usersrepository.xml
>>>> &lt;domainlist class="org.apache.james.domainlist.jpa.JPADomainList"&gt;
>>>> &lt;autodetect&gt;true&lt;/autodetect&gt;
>>>> &lt;autodetectIP&gt;true&lt;/autodetectIP&gt;
>>>> &lt;/domainlist&gt;
>>>>
>>>> - Edit the database.properties and change the values according to your
>>>> database.
>>>> - Don't forget to add the needed JDBC driver jar in the ./conf/lib
>>>> folder.
>>>>
>>>> Step 4: Start
>>>> #############
>>>>
>>>> $ cd bin
>>>> $ ./james start (!! you need libc6 installed on Linux - sudo apt-get
>>>> install libc6-i386 libc6-dev-i386 on ubuntu)
>>>> You can see log result in the log/james-server.log file.
>>>>
>>>> Step 5: Create Domains and Users
>>>> ################################
>>>>
>>>> $ telnet localhost 4555
>>>> Trying 127.0.0.1...
>>>> Connected to localhost.
>>>> Escape character is '^]'.
>>>> JAMES Remote Administration Tool
>>>> Please enter your login and password
>>>> Login id:
>>>> root
>>>> Password:
>>>> root
>>>> Welcome root. HELP for a list of commands
>>>> adddomain YOUR_DOMAIN
>>>> Adding domain YOUR_DOMAIN successful
>>>> adduser your_n...@your_domain YOUR_PASSWORD
>>>> User your_n...@your_domain added
>>>> quit
>>>> Bye
>>>> Connection closed by foreign host.
>>>>
>>>> For example, YOUR_DOMAIN=localhost.net, YOUR_NAME=test, so you will
>>>> have a [email protected] user.
>>>> The username to use in you mail client will be [email protected].
>>>>
>>>> Step 6: Test
>>>> ############
>>>>
>>>> $ telnet 127.0.0.1 25
>>>> Trying 127.0.0.1...
>>>> Connected to localhost.
>>>> Escape character is '^]'.
>>>> 220 172.16.1.131 SMTP Server (JAMES SMTP Server 3.0-M2) ready Sat, 6 Nov
>>>> 2010 17:31:33 +0100 (CET)
>>>> ehlo test
>>>> 250-172.16.1.131 Hello test (aoscommunity.com [127.0.0.1])
>>>> 250-PIPELINING
>>>> 250-ENHANCEDSTATUSCODES
>>>> 250 8BITMIME
>>>> mail from:&lt;your_n...@your_domain&gt;
>>>> 250 2.1.0 Sender &lt;your_n...@your_domain&gt; OK
>>>> rcpt to:&lt;your_n...@your_domain>
>>>> 250 2.1.5 Recipient &lt;your_n...@your_domain&gt; OK
>>>> data
>>>> 354 Ok Send data ending with &lt;CRLF&gt;.&lt;CRLF&gt;
>>>> subject: test
>>>>
>>>> this is a test
>>>> .
>>>> 250 2.6.0 Message received
>>>> quit
>>>> Connection closed by foreign host.
>>>>
>>>> Step 7: Manage
>>>> ##############
>>>>
>>>> 7.1. Manage via telnet
>>>> $ telnet localhost 4555
>>>> Trying 127.0.0.1...
>>>> Connected to localhost.
>>>> Escape character is '^]'.
>>>> JAMES Remote Administration Tool
>>>> Please enter your login and password
>>>> Login id:
>>>> root
>>>> Password:
>>>> root
>>>> Welcome root. HELP for a list of commands
>>>> help
>>>> adddomain [domainname]  add domain to local domains
>>>> addmapping [tou...@todomain] [fromMapping]      add mapping for the
>>>> given emailaddress
>>>> adduser [username] [password]   add a new user
>>>> countusers      display the number of existing accounts
>>>> deluser [username]      delete existing user
>>>> help    displays this help
>>>> listallmappings list all mappings
>>>> listdomains     list local domains
>>>> listmapping [u...@domain]       list all mappings for the given
>>>> emailaddress
>>>> listusers       display existing accounts
>>>> memstat ([-gc]) shows memory usage. When called with -gc the garbage
>>>> collector get called
>>>> quit    close connection
>>>> removedomain [domainname]       remove domain from local domains
>>>> removemapping [tou...@todomain] [fromMapping]   remove mapping for the
>>>> given emailaddress
>>>> setpassword [username] [password]       sets a user's password
>>>> showalias [username]    shows a user's current email alias
>>>> showforwarding [username]       shows a user's current email forwarding
>>>> shutdown        kills the current JVM (convenient when James is run as a
>>>> daemon)
>>>> unsetalias [user]       unsets an alias for 'user'
>>>> unsetforwarding [username]      removes a forward
>>>> user [repositoryname]   change to another user repository
>>>> verify [username]       verify if specified user exist
>>>>
>>>> 7.2. Manage via JMX
>>>> Launch jconsole (or any other JMX client) and connect on
>>>> URL=service:jmx:rmi:///jndi/rmi://localhost:9999/jmxrmi
>>>>
>>>> Step 8: Monitor
>>>> ##############
>>>>
>>>> Monitor the ./log/james-server.log log file.
>>>> Monitor via JMX (launch any JMX client and connect to
>>>> URL=service:jmx:rmi:///jndi/rmi://localhost:9999/jmxrmi)
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: [email protected]
>>>> For additional commands, e-mail: [email protected]
>>>>
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [email protected]
>>> For additional commands, e-mail: [email protected]
>>>
>>>
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>

Reply via email to