Hi Roland,
First off, I'd like to recommend that for production purposes, you switch
Artifactory from Derby to filesystem-mysql, as it results in much improved
performance.
Running out-of-the-box Artifactory in conjunction with Sonar on the same
Tomcat will cause the clash you experienced since you should not run 2
embedded Derby instances on the same JVM.
If you'd like to run this setup anyway, there are two (kinda-hackish) ways
to do so.
Upon using any of these methods, you should first remove all the Derby
dependencies from the Sonar and Artifactory WAR files and put them into
Tomcat's lib folder so that they won't clash in cases of different versions.
First option:
This method requires Artifactory to be initialized by Tomcat *after* Sonar,
since Sonar requires Derby for authentication.
When Artifactory will be loaded after Sonar, it will cancel Sonar's prior
declaration that requires authentication.
To do this:
1. Simply add "derby.connection.requireAuthentication=false" to the
artifactory.system.properties file in $ARTIFACTORY_HOME/etc.
2. Restart.
Second method:
This method requires you to start from a clean data folder (that is,
completely remove the data folder from $ARTIFACTORY_HOME).
Sonar connects to Derby via port 1527 with the credentials sonar:sonar as
opposed to Artifactory which connects directly to the file system with no
authentication.
We can modify Artifactory to connect to the same port and use the same
credentials defined by Sonar.
To do this:
1. Edit the artifactory.system.properties file in $ARTIFACTORY_HOME/etc
to uncomment "artifactory.jcr.configDir and point it to
repo/filesystem-derby configuration.
2. edit the repo.xml file in $ARTIFACTORY_HOME/etc/repo/filesystem-derby
and in all three blocks of the DataSources element (rep_ds, store_ds, db_ds)
replace the "${repo.home}" part of the URL to "localhost:1527", and change
to the username and password parameters to "sonar".
3. Restart.
HTH and have fun,
Noam
On Thu, Nov 11, 2010 at 11:35 AM, Asmann, Roland <[email protected]>wrote:
> Hi all,
>
> I'm trying to set up a demo-computer to take to a customer, but I seem
> to have problems with the derby-db. I have Sonar running on this
> computer (which uses Derby) and I'm not sure if both are trying to
> connect to the same DB/use the same port!
>
> I'm using Tomcat to deploy both projects in, and initially it seems to
> run without problems. However, after stopping Tomcat and restarting it,
> I get an error from Sonar telling me 'Connection authentication failure
> occurred. Reason: Invalid authentication..'
>
> I already posted on the Sonar mailing-list, but they tell me it is
> impossible to change the port Derby is running on in Sonar. Is there
> something I can change on the side of Artifactory?
>
> --
> Roland Asmann
> Senior Software Engineer
>
> adesso Austria GmbH
> Floridotower 26. Stock T +43 1 2198790-27
> Floridsdorfer Hauptstr. 1 F +43 1 2198790-927
> A-1210 Wien M +43 664 88657566
> E [email protected]
> W www.adesso.at
>
> -------------------------------------------------------------
> >>> business. people. technology. <<<
> -------------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> Centralized Desktop Delivery: Dell and VMware Reference Architecture
> Simplifying enterprise desktop deployment and management using
> Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
> client virtualization framework. Read more!
> http://p.sf.net/sfu/dell-eql-dev2dev
> _______________________________________________
> Artifactory-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/artifactory-users
>
------------------------------------------------------------------------------
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
_______________________________________________
Artifactory-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/artifactory-users
