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 javier <ja...@b4before.com> on 2002/06/17 19:48:10 UTC

Connect James to MySql database help

Hi, all.
 
I'ar try of store al mail information of James on a data base MySql,
The connection to base is fine, the problem is generate the internal
tables.
 
How do it???
 
Thanks!

RE: Connect James to MySql database help

Posted by javier <ja...@b4before.com>.
Thank Noel, ...with your help can solver the problem

Thank you very much!!
Javier

-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com] 
Sent: Monday, June 17, 2002 5:58 PM
To: James Users List
Subject: RE: Connect James to MySql database help

Javier,

Ok, let's try again.  Steps:

 1. Go into database admin and create a new database named "maildb" (or
other name)
 2. Still in database admin, create an authorized user for that database
 3. Modify config.xml.

For example, here is the appropriate section from my config.xml:

         <data-source name="maildb"
class="org.apache.james.util.mordred.JdbcDataSource">
            <driver>org.gjt.mm.mysql.Driver</driver>
            <dburl>jdbc:mysql://127.0.0.1/maildb</dburl>
            <user>dbUser</user>
            <password>dbUserPassord</password>
                <!-- Maximum concurrent connections james may open to
this
database-->
                <!-- If you see "SQLException: Giving up... no
connections
available." in your
                log files or bounced mail increase this value -->
            <max>10</max>
         </data-source>

I created a database named maildb (see the <dburl>), and a user "dbUser"
with password "dbUserPassword" (needless to say, these examples are NOT
the
real user and password).

And, of course, I enabled the db:// section, rather than the file://
sections of the config.

That is it.  The tables are created by James automatically if you have
followed these steps.

	--- Noel


--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Connect James to MySql database help

Posted by "Noel J. Bergman" <no...@devtech.com>.
Javier,

Ok, let's try again.  Steps:

 1. Go into database admin and create a new database named "maildb" (or
other name)
 2. Still in database admin, create an authorized user for that database
 3. Modify config.xml.

For example, here is the appropriate section from my config.xml:

         <data-source name="maildb"
class="org.apache.james.util.mordred.JdbcDataSource">
            <driver>org.gjt.mm.mysql.Driver</driver>
            <dburl>jdbc:mysql://127.0.0.1/maildb</dburl>
            <user>dbUser</user>
            <password>dbUserPassord</password>
                <!-- Maximum concurrent connections james may open to this
database-->
                <!-- If you see "SQLException: Giving up... no connections
available." in your
                log files or bounced mail increase this value -->
            <max>10</max>
         </data-source>

I created a database named maildb (see the <dburl>), and a user "dbUser"
with password "dbUserPassword" (needless to say, these examples are NOT the
real user and password).

And, of course, I enabled the db:// section, rather than the file://
sections of the config.

That is it.  The tables are created by James automatically if you have
followed these steps.

	--- Noel


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Connect James to MySql database help

Posted by javier <ja...@b4before.com>.
Thank Noel, but I don't can tiger the proces for generate the tables, I
make the data base, but don't define any table.   How tiger the process
of generation of tables into the data base.  

Have I change any setting into ../config.xml ???

Expain me please this steps!

Thanks Noel 

-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com] 
Sent: Monday, June 17, 2002 4:37 PM
To: James Users List
Subject: RE: Connect James to MySql database help

Javier,

It should generate the tables for you, if you've setup the database and
account properly.

	--- Noel

-----Original Message-----
From: javier [mailto:javier@b4before.com]
Sent: Monday, June 17, 2002 13:48
To: james-user@jakarta.apache.org
Subject: Connect James to MySql database help


Hi, all.

I'ar try of store al mail information of James on a data base MySql,
The connection to base is fine, the problem is generate the internal
tables.

How do it???

Thanks!


--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>





--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Connect James to MySql database help

Posted by "Noel J. Bergman" <no...@devtech.com>.
Javier,

It should generate the tables for you, if you've setup the database and
account properly.

	--- Noel

-----Original Message-----
From: javier [mailto:javier@b4before.com]
Sent: Monday, June 17, 2002 13:48
To: james-user@jakarta.apache.org
Subject: Connect James to MySql database help


Hi, all.

I'ar try of store al mail information of James on a data base MySql,
The connection to base is fine, the problem is generate the internal
tables.

How do it???

Thanks!


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>