Mailing-List: contact users-help@archiva.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@archiva.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: "Harris, Christopher P" <chris_harris@baxter.com>
To: "users@archiva.apache.org" <users@archiva.apache.org>
Subject: RE: Cannot get Archiva to create tables in 'archiva' database in
 MySQL 5.5
Thread-Topic: Cannot get Archiva to create tables in 'archiva' database in
 MySQL 5.5
Thread-Index: Ac2GDM4nicVxgJskRx2ipym9c3dGCAAFeZoAAASFTbA=
Date: Wed, 29 Aug 2012 22:30:28 +0000
Message-ID: 
 <9BD825F3554FD04AAB3B8BCBA96F192F01469773@026-SN2MPN1-023.026d.mgd.msft.net>
References: 
 <9BD825F3554FD04AAB3B8BCBA96F192F014685F3@026-SN2MPN1-023.026d.mgd.msft.net>
 <82700F28-0C71-47B5-BF30-2223C5B1B507@apache.org>
In-Reply-To: <82700F28-0C71-47B5-BF30-2223C5B1B507@apache.org>
Accept-Language: en-US
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Language: en-US
Content-Transfer-Encoding: quoted-printable

Thanks, Brett.

Just curious, can you expand on "other options"?  I don't need my hand held=
 in regard to specifics, but I just trying to get a general understanding o=
f what those options are.

Derby had its limitations in terms of number of artifacts stored, which I a=
nd our organization can easily hit and why I was trying to set up MySQL or =
PostgreSQL.  Could I still use an external db (I imagine so)?  Should I use=
 an external db compared to JackRabbit?  What's your recommendation?

I'm about to head home for the day, so I'll look into JackRabbit tonight or=
 tomorrow.

 - Chris

-----Original Message-----
From: Brett Porter [mailto:brett@porterclan.net] On Behalf Of Brett Porter
Sent: Wednesday, August 29, 2012 3:13 PM
To: users@archiva.apache.org
Subject: Re: Cannot get Archiva to create tables in 'archiva' database in M=
ySQL 5.5

Hi Chris,

Archiva 1.4 no longer has an 'archiva' database, as it has switched to usin=
g Jackrabbit for storing the artifact metadata (by default, though there ar=
e other options). The documentation has been updated, but until 1.4 is fina=
l that's not the main version on the site.

Regards,
Brett

On 29/08/2012, at 1:36 PM, "Harris, Christopher P" <chris_harris@baxter.com=
> wrote:

> Hi.
>  =

> I've set up Archiva apache-archiva-1.4-M2.war on Windows XP using Tomcat =
7.0.26 (base separated from installation).
>  =

> I've set up a MySQL 5.5 database.  The problem is that I see no tables or=
 data getting populated in just the archiva schema for the "archiva" user. =
 However, I am seeing tables and data populating the users schema for the "=
users" user.
>  =

> I used this script:
> create database archiva;
>  =

> create database users;
>  =

> use mysql;
> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX ON archiva.* TO=
 'archiva'@'localhost' IDENTIFIED BY 'archiva';
> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX ON users.* TO '=
users'@'localhost' IDENTIFIED BY 'users';
>  =

> I can successfully launch the Archiva .war in Tomcat.  Upon my initial la=
unch of Archiva, I was prompted to create the admin.  Once I created the ad=
min, the admin showed up in the jdouser table in the users schema.  The gue=
st user is present as well.
>  =

> I've attached archiva.log.
>  =

> I see that the \path\to\tomcat_base_archiva\data\repositories\*  director=
ies default internal and snapshots repositories are getting created within =
my file system.  That would indicate that Derby is getting used for the rep=
ositories, correct?
>  =

> Here's my archiva.xml from \path\to\tomcat_base_archiva\conf\Catalina\loc=
alhost
> <Context path=3D"/archiva"
>          docBase=3D"C:/apache/tomcat_base_archiva/archiva/apache-archiva-=
1.4-M2.war"
>          reloadable=3D"true"
>          antiJARLocking=3D"true"
>          antiResourceLocking=3D"true">
>         =

>          <!-- docBase=3D"${catalina.home}/archiva/apache-archiva-1.4-M2.w=
ar"> -->
>   <Resource name=3D"jdbc/users"
>             auth=3D"Container"
>             type=3D"javax.sql.DataSource"
>             username=3D"users"
>             password=3D"users"
>             driverClassName=3D"com.mysql.jdbc.Driver"
>             url=3D"jdbc:mysql://localhost:3306/users?autoReconnect=3Dtrue=
"/>
>  =

>   <Resource name=3D"jdbc/archiva"
>             auth=3D"Container"
>             type=3D"javax.sql.DataSource"
>             username=3D"archiva"
>             password=3D"archiva"
>             driverClassName=3D"com.mysql.jdbc.Driver"
>             url=3D"jdbc:mysql://localhost:3306/archiva?autoReconnect=3Dtr=
ue"/>
>  =

>   <Resource name=3D"mail/Session"
>             auth=3D"Container"
>             type=3D"javax.mail.Session"
>             mail.smtp.host=3D"localhost"/>
> </Context>
>  =

> I poked around in the Archiva code on SVN here :
> http://svn.apache.org/viewvc/archiva/tags/archiva-1.4-M2/archiva-modules/=
archiva-web/archiva-webapp/src/
> I looked at the jetty config file jetty-env-mysql.xml and noticed that th=
e archiva user is given the password 'sa'.
> I noticed that here too:
> http://svn.apache.org/viewvc/archiva/tags/archiva-1.4-M2/archiva-modules/=
archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql?view=3Dmar=
kup
> So, I even tried changing the "archiva" user's password to sa within MySQ=
L and in archiva.xml.
>  =

> That didn't work.
>  =

> I've read about a  bug where MySQL db's shouldn't be set to UTF-8, but th=
at bug appears to have affected older Archiva versions.  Both my users and =
archiva tables are set to UTF-8.
>  =

> It's odd that the users db is being utilized, but the archiva db is not.
>  =

> What am I doing wrong?
>  =

> I'm tempted to try PostgreSQL, but I don't want to open another potential=
 can of worms just yet.
>  =

> -    Chris
> The information transmitted is intended only for the person(s)or entity t=
o which it is addressed and may contain confidential and/or legally privile=
ged material. Delivery of this message to any person other than the intende=
d recipient(s) is not intended in any way to waive privilege or confidentia=
lity. Any review, retransmission, dissemination or other use of , or taking=
 of any action in reliance upon, this information by entities other than th=
e intended recipient is prohibited. If you receive this in error, please co=
ntact the sender and delete the material from any computer.
> =

> For Translation:
> =

> http://www.baxter.com/email_disclaimer
> =


The information transmitted is intended only for the person(s)or entity to =
which it is addressed and may contain confidential and/or legally privilege=
d material. Delivery of this message to any person other than the intended =
recipient(s) is not intended in any way to waive privilege or confidentiali=
ty. Any review, retransmission, dissemination or other use of , or taking o=
f any action in reliance upon, this information by entities other than the =
intended recipient is prohibited. If you receive this in error, please cont=
act the sender and delete the material from any computer.

For Translation:

http://www.baxter.com/email_disclaimer